1. Develop and implement ETL processes, reports and queries in support of business analytics.2. Design, code, test, tune, and document all new or existing applications and programs.3. Manages complete life cycle for most complex or high-risk components.4. Demonstrates expert knowledge of technical design alternatives and their implications.5. Provide database&ETL training to group members.

1. Maintained existing BI platform and solutions while looking for opportunities to improve them.2. Gathered requirements for new BI solutions from multiple users; able to translate business requirements into actual solutions while maintaining a high level of accuracy and data integrity.3. Strong ability to translate business requirements into technical terms for other team members.4. Led the development of new applications or modifications to existing applications.5. Created technical specifications and unit test plans for developers.6. Provided guidance to other team members to consolidate and landscape in order to reduce delivery time and increase consistency among BI solutions.7. Developed and implemented complex BI/ETL tasks or other duties as project needs, like Data scraping.8. Worked with a global team for implementation of BI applications.9. Documented new or existing applications, systems, or solutions.10. Provided training and coaching to less experienced team members in BI standards and best practices.

1. Provided business intelligence reports and data warehouse operational support.2. Developed ETL components to move data from data warehouse to data mart using Datastage Data Integration.3. Designed, created and maintained tables, views and PL/SQL procedures to pull data from different systems.4. Implemented a reporting solution using the Cognos Business Suite.5. Involved in optimizing performance of processes and queries.6. Troubleshooted and implemented possible solutions for bug fixes.7. Coordinated with Technical Leads, Systems Administrators and others developers for various component development and migration.8. Prepared detailed specifications for the development of components.9. Responsible for design, coding, supporting testing, debugging and documentation.10. Led a group of engineers to maintain project and promoted as a team leader.

1. Worked closely with the Bank Business Users to gather requirements.2. Experience in analyzing the multiple source systems and based on the business requirements build the transformation rules to extract, transform and load the data in the target system.3. Created mappings to perform the tasks such as cleaning the data and populate that into staging tables.4. Used Datastage and Kettle to analyze the source data to extract and transform from source systems (Oracle, SQL Server, DB2 and flat files)5. Designed and created PL/SQL procedures for auditing the data extracts from source to data warehouse for various entities such as Core Banking System, Credit System and Payment etc.6. Responsible for Unit testing and Integration testing of mappings and workflows.