Srikanth Pannala

SRIKANTH PANNALA Mobile:-- EXPERIENCE: Amazon (10th Nov 2014 – 23rd Dec 2018) Worked as Analyst. Capgemini (8th March 2019 – Present) Working as Associate Consultant. Meridian (20th June 2013 – 30th Aug 2013) Worked as Operator. TBSS (15th Feb 2013 – 18th June 2013) Worked as CSE. EXPERIENCE SUMMARY AS ANALAYST & ASSOCIATE CONSULTANT: Coordinate meeting management activities with client. Maintaining IT work request records on Clear Quest tool. Apprising Project managers about compliance red code records and making appropriate changes to update the status. Updating project Artifact documents, schedules on Planview and SharePoint. Managing Financial activities - forecast and invoices. Tracking statuses of all projects. Setting up governance and tracking timeline & milestone Leading governance calls and providing project status to management Project monitoring and creating status reports. Manage risk/issues and ensure mitigation, in order to minimize their impact of the project Budget management, tracking and forecasting. Is able to plan projects based on the budget allocated. Prepare project forecasts, regular and final project reports, and develop other documents required for project management. Manage changes to the project scope, schedule and costs using appropriate techniques in order to keep the project plan accurate. Followed through on backlogs using a defect tracking system (JIRA tool). Assign internal tasks with due date on Confluence tool. Share Point management, uploading project deliverable documents. EXPERIENCE SUMMARY AS ANALYST: Create SOP documentation and provide cross training on developed Excel templates. Develop automated excel workbook(s) for use as data entry templates. VBA and Excel Macro Working Knowledge. Created pivot tables and charts using worksheet data and external resources, modified pivot tables and modify spreadsheets to achieve analytical goals. Built Interactive dashboard reports using excel formulas and pivots for senior management review. Knowledge of SQL, including table design and stored procedures. Create, modify and troubleshoot SQL queries, stored procedures and jobs Coordinate both external and internal resources to effect problem resolutions. Daily Activity Tracker: Details from various teams are collated and the type of activity, its criticality is being judged and a report is prepared for senior managers. Downtime/ Incident Report: Downtime report is been fetched from the tool and pivot is created in order to distinguish the team names and the time undergone as downtime. It is circulated to the heads weekly once. Business Continuity Plan: Collecting BCP drill reports from various teams and prepare a final report for senior management. IT and Audit Compliance: Coordinate with different teams in department for internal and external audit activities, collecting evidences verified and shared with auditors. MEMO & Process: Drafting a document for the approval of any support, contract or procurement from any vendor from the senior authorities with regards to the finance as the payment of a huge amount is involved. Temporary storage and server allocation: Tracking and chasing the teams to release, return or regularize overdue spaces and servers by the said approved time. Manage Dependencies, Assumption and Action Logs TECHNICAL SKILLS: Proficiency in MS Office (excel, word, PowerPoint, internet). Knowledge of SQL, VBA, Tableau and Jira/confluence. Typing speed: - 40wpm. Efficient in running data retrieving tools for various metrics. ACADEMIC QUALIFICATIONS: Bachelor of Technology from JNTUH University, in the year 2013. Intermediate from Board of Intermediate education, in the year 2009. 10th from Board of Secondary Education, in the year 2007. SRIKANTH PANNALA.