Feb 2018 – Till Date| Treasury Front Office | Data Warehouse DesignerInfosys Vendor to Westpac Bank (Australia)• As a Data Analyst, I analyze and interpret data to provide the required insights to the business to take better business decisions. • Data Warehouse Design and Database Modelling using Kimball Methodology.• Use of Erwin Tool to conceptualize database model.• Design and development of Multidimensional OLAP data warehouse using Star Schema. Star schema development using multiple hierarchy dimensions, role playing dimensions, junk dimensions and degenerated dimensions. • Creation of Fact Tables involving Periodic Snapshot Fact Tables and Fact-Less Fact Tables.• Adopted partition switching algorithm to ensure zero downtime for a typical star schema.• Production deployment of Star Schema and components like stored procedures and SSIS packages.June 2017 – Feb 2018| RMW| SSRS and Power BI Report Designer and DeveloperInfosys Vendor to Westpac Bank (Australia)• Database object design, performance troubleshooting, database development and SSRS reporting. • Analysis of existing Legacy systems, applying reverse engineering on Power Builder reports to design equivalent SSRS Reports, building SSRS reports, applying security layer on reports and deploying to production. Developed Power BI report report.• Provided leadership to developers to assist them in the delivery. Nov 2012 – June 2017| Panorama| Data Warehouse EngineerInfosys Vendor to Wells Fargo Bank (USA)• Requirement gathering and converting the requirements to High level Technical Design• Data Warehouse development using Kimball Methodology. Use the Erwin Tool to conceptualize the database model. Design and development of dimension and fact tables, for multidimensional OLAP data warehouse using Star and snowflake schema. • Development of optimized T-SQL code, implementation of partitions and indexing to database objects.• Provided leadership to developers to assist them in the delivery.

Oct 2011 – Nov 2012 | Corporate and Institutional Banking | Database and SSIS Developer Microsoft Vendor to Royal Bank of Scotland (Scotland)• Requirement gathering, preparation of Low Level Design document, creating unit testing plan.• ETL development to load data from SQL server to CRM database.• Development of optimized T-SQL code, implementation of partitions and indexing to database objects.• Worked on error handling, auditing and deployment of SSIS packages.• Deployment of SSIS packages in all environments.• Coordinating with customer and onshore team

Jul 2010 – Oct 2011| Sales Edge | Database and SSIS Developer iGATE Patni Vendor to Philip Morris (USA)• Analysing business requirement document, UI mapping document and functional specification to identify the data model gaps.• Development of Stored Procedures, SSIS Packages, performing Initial Data Load was my primary responsibility. • Participating in deployment of SSIS packages in all environments.• Automation of creating the SQL Server Agent Jobs by creating the Stored Procedure.• Preparation of KB articles • Communicating directly with Client/Business owners/onsite team.

Oct 2009 – June 2010| VLSC | Database and SSIS Developer Accenture Vendor to Microsoft (USA)• Preparation of T-SQL code and stored procedures to resolve the incidents. • Troubleshooting using the SQL Profiler.• Day to day Service Request handling within specific SLA.• Reviewing/preparing Functional Specifications. Documentation/preparation of KB articles, best practices.• Conducting training session for teammates for process awareness. • Communicating directly with different level of support team, incident coordinators.

July 2007 – Oct 2009| Original Equipment Manufacturer IT| Database Developer Mahindra Satyam Vendor to Microsoft (USA)• Involved in handling the applications - Inventory, Cycle Count, Stale Events, Scarp Events, Shrink Events, COA to SAP Recon, TV main for COA and OEM Shipment View. • SME/Module Lead/Shift Lead.• Preparation of T-SQL code and stored procedures. • Troubleshooting using the SQL Profiler. • Day to day Service Request handling within specific SLA.