Shital Thakre

Hands on experience in Data migration, analysis and report creation system for Telecom. I was able to attract and hire top talent to round out my team, which then exceeded sales goals by 15 percent.

Worked on crucial migration project for HDFC bank. below were my roles and responsibilities 1. Developed ETL processes to populate the Data Warehouse using Informatica, Oracle SQL, PLSQL for HDFC bank data. 2. Extensively worked on INFORMATICA tools:- Designer, Workflow manager and Workflow Monitor. 3. Developed mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookups, Filter, Router, Sequence Generator, Update Strategy, and Joiner. 4. Worked with different Sources such as Oracle, and Flat files. 5. Created sessions, database connections and batches using Informatica Workflow Manager. 6. Created the slowly changing dimensions 7. Developed mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookups, Filter, Router, Sequence Generator, Update Strategy, Joiner and Stored Procedure. 8. Defined data and tool standards, tools used for data acquisition, modelling, metadata management and for OLAP. 9. Designed and developed a solution for Business intelligence solution. 10. Crafted and designed queries depending upon request of data using SQL/PLSQL 11. Developed OLAP cubes using Informatica Powercenter 8.6 to store data 12. Evaluated and Improved existing BI solutions. 13. Prioritize BI release. 14. Visualized key trends in data for better understanding and decision making using Tableau reporting tool. Skills : Informatica Power center 8.6, Tableau, SQL, Unstructured data management, Unix, payment gateway, Putty, remedy7.

Organization Name : TechMahindra Ltd. Client : British Telecom (http://www.bt.com ) Role : ETL Developer Duration : Oct 2007 To May 2010 Module : Flow stream LLU. Environment : Oracle9i, PL/Sql, C++. FLOW Stream is composed of the following functional components: This is implemented in C++ and Oracle PL/SQL. Each FLOW Stream server has its own Oracle database. FLOW Stream is the system for taking forward the "Handle Order" capability within provisioning. It is seen as having two critical objectives. In the short term it is to act as a means of placing orders on existing order handling systems, presenting a common interface to client systems and providing additional functionality to enable cross system working. In the longer term it is seen as a vehicle for migrating function away from the existing systems providing a full set of functionality and data to allow it to handle all aspects of order processing. Initially FLOW Stream will simply post orders to the appropriate back end system and maintain a cross reference to facilitate progress checking and subsequent retrieval or update. Over a period of years, however, services will be added to allow orders to be handled in a greater variety of ways. Roles & Responsibilities:  • Query Writing (Procedure, Function,Triggers )  • Design and Develop Reports using Jasper Reports  • Data Migration on Live Database Server.  • Involved in designing of test plan documentation.  • Written test cases and performed Manual Testing like Positive  •Execute all assigned test cases.  •Query Optimization.  •Providing MIS Reports to Client