SUMMARY

• IT Professional with 7 years of experience in Analysis, Design, Development, Testing and Implementation of complex Data Warehousing applications using ETL tool Informatica PowerCenter for Healthcare, Insurance and Industrial Equipment clients.
• Certified as Informatica PowerCenter Data Integration 10: Developer, Specialist.
• 2 years of experience in Data Integration tools like Informatica Data Quality(IDQ) and Informatica Cloud Services(IICS) and minimal experience in SSIS tool.
• Possess knowledge on Python and Linux commands.
• Have major experience in using Informatica PowerCenter tools - Designer, Workflow Manager, Workflow Monitor, Repository manager, Informatica Data Quality and Informatica Cloud services.
• Proficient in using Oracle, SAP, Flat file sources and Salesforce, Oracle, SAP, IDoc and flat file targets.
• Developed IDQ mappings for generating data profiling reports to aid in data cleansing and proficient in transformations like match, standardizer etc.
• Worked with Oracle database, involved in basic DBA activities and possess expertise in SQL commands.
• Exposure to Software Development processes involving requirement analysis, Worked closely with Customers in the requirement phase and fixed the bugs, Lead the team with the design for each modules and also developed error reporting strategies, Also involved in existing design enhancements and fixing issues.
• Team player with good communication, interpersonal and analytical skills.
• Have experience in using front end applications -Salesforce, SAP and worked on Data Integration projects.
• Minimal Experience in building Qlikview and Tableau reports and trained in Talend ETL Tool.
• Also trained in using AWS S3.

TECHNICAL SKILLS

BI Technologies: Informatica Power center 10.1/9.5.1, Informatica Data Quality(IDQ), SQL Server Integration Services, Qlikview, Tableau

Operating Systems: Windows, Linux

Scheduling Tools: Automic UC4 V11

Software/Languages: SQL, PL/SQL, Unix shell scripting, Python

Databases: Oracle 11g/10g, SQL Server 2008/2012

Cloud Technologies: Salesforce, Informatica Cloud Services(IICS)

Other Tools: Salesforce Data Loader, FileZilla, Putty, SQL Developer, Toad

Methodologies: STAR schema, Fact & Dimension tables, ETL

Version Control: Tortoise SVN, Jira

PROFESSIONAL EXPERIENCE:

Confidential

Technical Lead

Responsibilities:

• Worked on Data Migration using SQL Server Integration Services tools and performed Insurance data migration to Guidewire application, and also involved in feature enhancements, support and maintenance of application.
• Developed SSIS packages for migration and performed deployments of optimized packages to Production highly efficient for loading insurance policies and claims data to Guidewire Production system by understanding the limits and rules suitable for the Insurance suite.
• Experience in using temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Expertise in writingT-SQL Queries, Dynamic-queries, sub-queries and complex joins for generatingComplex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Experience in usingSSIStools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience inimporting/exportingdata between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Designed SSISPackagesto transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such asLookup, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used Execution Plan,SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Supported onshore team with the required assistance and performed the migration effectively.

Confidential

Senior Software Developer

Responsibilities:

• Worked on Data Migration using Informatica Powercenter and Informatica Cloud Services(ICS) tools and performed data migration to Veeva CRM cloud application, and also involved in feature enhancements, support and maintenance of application.
• Involved in developing migration framework after understanding the target (Veeva CRM application) design and limitations, and applied code optimization techniques like Database Partitioning to handle large volumes of data.
• Acted as Technical lead and created workflows, and built code for automating the existing manual job executions and reporting the status to the key stakeholders.
• Used parameterization in the mappings and applied rules via parameter files to facilitate reusability of the code, thereby allowing the code to handle multiple scenarios.
• Acted as SPOC for all application data issues, by analyzing data flow and work in solving them on time without any impact to Business needs.
• Prepared material for new joiners to understand the existing implementation along with limitations.
• Worked closely with downstream dashboard applications to make sure the required data flows into dashboard effectively.
• Also involved in working on support of existing issues reported through SNOW tool.
• Worked on tool upgradation activities from Informatica 9.6.1 to Informatica 10.1.

Confidential

Senior Software Developer

Responsibilities:

• Primary point of contact for the data migration process for several countries especially APAC group.
• Was involved in major enhancement and Change request activities.
• Visited China for UAT testing and got positive feedback from Client Onshore. Have interacted with the clients and onshore counterpart on a daily basis.
• Learnt methodologies to migrate data to Salesforce without slippage by reporting the errors and resolving them.
• Provided functional and technical knowledge transfer sessions.
• Guided the testing team to script the test cases as per the client standards and identified the high-level scenarios to cover as a part of regression testing.
• Documented technical, deployment checklist and materials which are required for deployment to production and client sessions.
• Provided knowledge transfer to third party vendor on the application, to handle the same post Hypercare

Confidential

Associate Developer

Responsibilities:

• Key member of Data Warehousing team, with major involvement in build phase by understanding the functional requirements provided by client.
• Interacted with the clients and onshore counterpart on a daily basis.
• Tracked deliverables on a daily and hourly basis and report status to the onsite counterpart and/or client.
• Understood the functional requirement and processing the data using ETL logic.
• Proposed solutions to the issues raised by the clients or the onshore counterparts.
• Created weekly KPI reports using Informatica Data Quality. These are used by the key users to cleanse the source system.
• Worked effectively and collaborated with various teams to ensure error-free deliverables without slippage.
• Contributed in speedy ramp up of new resources by giving them frequent support and knowledge transfer sessions.
• Was also part of data migration to SAP systems using Informatica.