Experience

Platinum Bank

• United States
• Banking
• 1 - 100 Employee

• Head of Reporting and Analysis Department

  • Aug 2011 - Present

  Management of the Reporting and Analysis Department team. Development of new solutions, troubleshooting the existing ones and possible involvement in Operation & Support tasks. Designing, coding, testing and documenting in the following tools: SSAS, SSRS, Oracle Bi, Bi Publisher, MS SharePoint, Crystal Reports, Fast Reports etc. Development of DWH and ETL process. Full range of activities from business analysis to reporting development. Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems. Designed and developed SSIS Packages to import and export data from transactions system to DWH. Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in all environments (Development, Test and Production). Involved in ETL architecture enhancements to increase the performance using query optimizer. Implemented Event Handlers and Error Handling in SSIS packages. Advanced extensible reporting skills using SQL Server 2008 R2 Reporting Services (SSRS). Designed and created Report templates, bar graphs and pie charts based on the financial and sales data. Developed various types of complex reports like Drill Down, Drill through, Cross tab reports. Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008 R2. Involved in Normalization and De-Normalization of existing tables for faster query retrieval. Advised optimization of queries by looking at Execution Plan for better tuning of the database. Show less



Home Credit Bank

• Banking
• 100 - 200 Employee

• Head of Analytics and customer segmentation

  • Jan 2007 - Aug 2011

  Management of the team in analysis Department. Data collection, organization and analysis. Development of Top Managers reporting and analysis. Management of the team in analysis Department. Data collection, organization and analysis. Development of Top Managers reporting and analysis.