Professional Experience

Analyst,JP Morgan Chase& Co.                                                                                     Oct ’16 – Present

+       Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2008using  SSIS, SSRS, SSAS.

+       Handled a complex end-end Headcount process; data mining from different sources using SSIS, applied data transformation in order to extract meaningful insights (like Open/Pending/Closed Req Details) from existing datathat furthered Qlikview dashboards.

+       Developed and optimized database structures, stored procedures to automate the manually processed allocations for GTI as a part of the CDMP process.

+       Designed SSIS package to extract Actual Dollars & Volume allocations on a CC/LOB/product level and structured data in a format compatible by SAPCO (JPMC GL Tool). The package was constructed in a generic manner to handle adjustments as well.

+       Responsible for building report solutions like drill-down, drill-through, and linked reports using SSRS, Testing for quality and finally review with the customer to ensure the solution meets requirements.

+       Designed and created OLAP cubes with star schema using SSAS 2008 to show the CC allocations -actuals, budgetand multi-year forecast data & created reporting measures that aided users for planning and forecasting.

+       Contributed in process improvement and automation for reporting with greater accuracy.

+       Played a vital role in the sub-LOB project – “Oracle End of Life” by migrating core processes from Oracle to SQL.

+       Troubleshooting skills for quick issue resolution in large-scale production environments located globally.

+       Hands-on experience in SQL Server, SSIS, SSRS, SSAS.

Consultant, Capgemini India Pvt Ltd                                                                           Aug ’14 – Aug ‘16

+       Worked in building logic in database for Client as per complex requirement for Data Transformation.

+       End to End project management – Requirement Analysis, Application Maintenance, Design, Coding, Dev/UATand Production Deployment.

+       Handled various transitions and sustainable activities for Database development of various Clients like Warner Brothers, Disney, Energy Food Holdings (EFH), Unilever, Hydro One, COKE, and OPG.

+       Creating database objects – tables, procedures, function views customized as per business need or client Requirement.

+       Designed packages and created stored procedures, functions and views that helped to show the incident tickets of various clients in the dashboard named COMMAND CENTER (IMSCC) based on priority/completion status/breach status. The View of dashboard is shown in various modules like Daily Dashboard, Real-time Dashboard, SLA Scorecard, and SLAMTD etc…

+       Responsible for loading data in database through SSIS packages of various clients from different SFTP’s and Mail servers.

+       Worked on Package deployments, package configurations, logging, SQL job creations and Automation of SSIS packages.

+       Supported as the sole dedicated resource for a priority client and provided reporting solutions by designing dashboards for their expense management and other financial needs.

+       Hands-on experience in SQL Server, SSIS, SSRS ,SSAS.

Engineer Technology, Selfinity Solutions Pvt Ltd                                                  Sep ’13 – Aug ‘14

+       Designed and developed the ETL process (SSIS packages) to make the data available from various relational databases, flat files etc., for analysis and reporting purposes

+       Utilized multiple transformations provided by SSIS such as Conditional Split, Derived column, Union-all, aggregate transformation

+       Updated the package to redirect "bad data" to a text file for later analysis and to loop through all of the flat files in a folder and load their data into the table.

+       Worked on the raw data files sent by the client in txt format, extracting the relevant data, scrubbing them against TPS/DNC converting it to dialer acceptable format using SQL queries and performance tuning of SQL queries and stored procedures.

+       Researched and resolved issues regarding the integrity of data flow into databases.

+       Designed a PHP webpage to capture the details entered by the sales representatives for further analysis.

+        Hands-on experience in SQL Server 2008, SSIS.

Education

Jawaharlal Nehru technological University, Anantapur                                     2013

Bachelor of Engineering– Computer Science & Engineering.

SYNOPSIS

·         Ambitious, perceptive and logical data analyst with strong track-record of delivering top performance.

·         5+ years' experiencein development and implementation of software applications in SQL, MSBI (SSIS, SSRS,SSAS) Tableau.

·         Skilled communicator with ability to engage stakeholders and clients.

·         Analytical bent of mind to understand patterns from large data to create actionable insights.

·         Seeking an opportunity to drive business effectiveness through making recommendations based on data findings.