Adarsh D. Email & Phone Number

Boston, MA, US

East Brunswick, NJ, US

• Informatica ETL development work for Insurance line of business(LOB) like Commercial Auto, General Liability, Inland Marine. Tasks include process documentation, debugging, code fixes and any new development.
• Working as Onsite coordinator for code review, effort estimation and offshore support
• Developed and maintained ETL mappings to extract data from policy admin system (Source system).
• Created technical specification documents and deployment documents for the mappings
• Involved in creating new table structures of Operational Data Store (ODS) and modifying existing tables and fit into the existing Data Model
• Designed and developed transformation rules (business rules) to generate consolidated data to post the policy into Corporate Record (CR)

Washington, DC, US

• Supporting Informatica ETL development work for Bio-Medical line of services. Tasks include process documentation, debugging, code fixes and any new development.
• Extract data from sources like fixed width and Delimited Flat files transformed the data according the business requirement and then loaded into Target Database
• Work with different sources like Oracle, flat files, Teradata, Excel files
• Create Informatica mappings and maplets to load the database. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator, LookUp
• Use SQL Plus to write queries and interact with Oracle database
• Use SQL assistant to write queries and interact with Teradata database

• Learned to extract data from sources like fixed width and Delimited Flat files transformed the data according the business requirement and then loaded into Target Database
• Learned to work with different sources like Oracle, flat files, XML files, MS SQL Server
• Learned to create various Informatica mappings and maplets to load the database. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator, LookUp
• Learned Performance tuning of targets, sources, mappings and session and performed pipeline partitioning
• Learned to configure the mappings to handle the updates to preserve the existing records using Update Strategy Transformation (SCD Type-2)
• Learned to use Debugger to identify the errors in the mappings and fix them

San Jose, California, US

• Created 70+ manual test scenarios and cases based on the analysis of the Business Requirements Document
• Created Test Scripts in VBScript to test various functionalities of ServiceNow using the Quick Test Professional (QTP)
• Reported and tracked defects/bugs to the development team using HP Application Lifecycle Manager (ALM)
• Facilitated more than 10 meetings using WebEx Connect with off-site test team
• Developed Test Strategy and plan with QA and project managers
• Participated in Defect Triage meetings to determine the effects of defects

Boston, Massachusetts, US

• Installation and repair of hardware
• Analyze and report bugs
• Manage cross site projects
• Provide desktop support and troubleshooting
• Completed business communications and leadership training

• Created and executed test cases based on the analysis of the Business Requirements Documents
• Used HP Quality Center for recording and executing test cases
• Executed test scripts using QTP

Education record

Post Graduation Diploma In Business Economics