Anshuman Rath

• Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL, HDFS etc.
• Managed data quality issues during ETL processes, directing qualitative failures to team lead for amelioration.
• Designed and created ETL code installations, aiding in transitions from one data warehouse to another.
• Gathered, defined and refined requirements, led project design and oversaw implementation.
• Developed complex mappings using Lookups, Sort, Join, Merge, Aggregator, Filter, CDC stages as well as transformer to transform data as per requirements.

• Excellent understanding of the process of data flow from higher lane to lower lane with perfection via SQL and IBM Datastage on platform Unix.
• Expertise in Development, unit testing, integration testing, system testing and regression test for the desired system and application.
• Fair knowledge in writing JIL scripts for integrating jobs in Autosys for both midrange and mainframe applications.
• Expertise in finding the issue, root cause and coordinate with the development team for further improvisation for avoiding the further issues.
• Developed complex mappings using Lookups, Sort, Join, Merge, Aggregator, Filter, CDC stages as well as transformer to transform the data as per the requirements.
• Identified issues, analyzed information and provided solutions to problems.
• Quickly learned new skills and applied them to daily tasks, improving efficiency and productivity.
• Validated results and performed quality assurance to assess accuracy of data.

CLIENT: MunichRE

• Expertise in creation of test scripts with respect to manual testing via SQL queries and execution through IBM Data stage and Unix.
• Excellent understanding of mapping document and creation as well as execution of test cases for different scenarios as per the requirement.
• Expertise in unit testing, integration testing, system testing and regression test for the desired system and application.
• Provided project level improvement plans for better performance in the database level with perfection resulted in savings and improved profit margins.
• Identified issues, analyzed information and provided solutions to problems.
• Eliminated downtime and maximized revenue by providing top project quality control.

CLIENT: BAYER-BI

• Extensively worked on understanding the business requirements, Data modeling and ETL structure.
• Developed complex mappings using Lookups, Sort, Join, Merge, Aggregator, Filter, CDC stages as well as transformer to transform the data as per the requirements.
• Successful Application management and improvement on the performance of delivery.
• Independent deployment of new business requirements in production after successful Unit testing, integration testing, UAT testing and System testing.
• Played a major role in migration of DataStage version from 8.7 to 11.5.
• Worked on different project level improvements both functionally and technically to enhance the performance of the existing servers.
• Expertise in SAP-SSM module for Documentation of different project level Functional as well as Design documents.
• Creating and Handling of Change requests for improvement as well as enhancement in present services and data delivery.