PROFESSIONAL SUMMARY:

• Currently working as Senior Associate at Cognizant Technology Solutions
• Worked as Senior Software Engineer at UST Global
• 11+ years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Business Intelligence projects.
• 7+ years of development experience in Informatica Power Center (8.6x/9.1x/9.6x)
• 3+ years of development experience in Reporting tools SSRS 2008 R2/2012 and Business Objects XI R2/R3
• Experience in the development, administration and production support of Informatica projects.
• Expertise in UNIX shell scripts to run the Informatica workflows and file processing.
• Extensively worked with various Informatica transformations and performance tuning.
• Proficiency in developing SQL and Stored Procedures in various relational databases like Oracle, SQL Server & DB2
• Hands - on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, development, unit testing, systems integration, and implementation.
• Excellent in reviewing the business requirements from high level documents and developing the ETL solutions.
• Strong business understanding of domains like Insurance and Health care.
• Independently perform complex troubleshooting, root-cause analysis and solution development.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, client facing skill and possess good interpersonal communication skills.
• Team player, motivated, able to grasp things quickly with strong analytical skills.

TECHNICAL SKILLS:

Operating Systems: Windows 2008 R2/7/XP, UNIX, LINUX, MS-DOS

ETL Tools: Informatica Power Center 9.6/9.1/8.6

Relational Databases: MS SQL Server 2012/2008/2005, DB2 9/10, Oracle 12c/11g/10g/9i

DW Databases: Netezza v3.1, Teradata v13

Reporting Tools: Business Objects XI R2/R3, SSRS 2008 R2/2012

Languages: SQL, PL/SQL, UNIX Shell Scripts

Scheduling Tools: Autosys, Work Load Manager, ESP

Agile Tools: JIRA, TFS

WORK EXPERIENCE:

Confidential, Columbus, Ohio

Integration Lead & ETL Developer

Technologies: Informatica 9.6, LINUX, Oracle 12c, OIPA, TPP, Perl

Responsibilities:

• Analyze the business requirements and build the new ETL solution to load the data from new underwriting and policy admin systems.
• Coordinate with various application SMEs and analyses the impact of new ETL process and resolve any conflicts with existing ETL process.
• Follow the enterprise ETL framework and create the Informatica mappings based on it to process the extract files from the systems.
• Develop 60+ mappings to process the extract files from the new systems to various interfaces.
• Create custom Perl scripts and modules for file operations, run Informatica workflow and control table load.
• Work with various interfaces and ensure data is reaching their systems without any issue.
• Coordinate with data modelers and requirement analysts to resolve data load issues.
• Help the QA team to build the automated test scripts to validate the extract files generated from the ETL process.
• Test the Informatica components in various environments with the help of QA and validate the data against new systems.
• Deploy the Informatica components to production and provide warranty support to applications.

Confidential, Plantation, Florida

ETL Lead/Developer

Technologies: Informatica 9.6, Salesforce, LINUX, SQL Server 2012, Agile methodology

Responsibilities:

• Develop a dynamic solution to process the different files from clients irrespective of the format.
• Involve in the scrum meetings, sprint planning, demo and review meetings.
• Work with business analysts to understand the requirements and propose better solutions.
• Build new data model and database objects needed for the new Informatica process.
• Develop new sets of Informatica mappings for processing evidence of insurability files, claim eligibility files and payment records.
• Develop a combination of Informatica user defined functions & mapplet for the data validation and exception handling process.
• Create Unix shell scripts for transferring files between various servers and error notifications.
• Test the Informatica components in various environments using autosys scheduler and verify the data against Salesforce application.
• Deploy the Informatica and database components using change management process and support the jobs in production.

Confidential

ETL/Report Developer

Technologies: Informatica 9.1, SSRS 2008 R2/2012, Business Objects XI R3, UNIX, DB2 v10Responsibilities:

• Involve in the daily scrum meetings, sprint planning, sprint demo and sprint retrospection meetings.
• Analyze the requirements and identify the Informatica mappings impacted.
• Coordinate with Data Architect & DBA to implement the data model changes.
• Develop new Informatica mappings and modify existing mappings based on the new requirements.
• In corporate the agent/staff information to the Business Objects universe and reports.
• Modify 30+ existing SSRS reports to bring the associate/staff information along with financial representative.
• Analyze the business requirements and come up with the solution to build a new set of associate/staff centric SSRS reports.
• Perform unit testing and system testing of new ETL & reporting changes and impact analyze on other systems and process.
• Deploy the Informatica and reporting components to production and transition the knowledge to support team.

Confidential, Milwaukee, Wisconsin

Onsite Lead & ETL/Report Developer

Technologies: Informatica 9.1, SSRS 2012, UNIX, DB2 v10, HP Autonomy

Responsibilities:

• Analyze the different user stories from business users and designed the ETL solution for the new application.
• Finalize the format of the data feed by working with vendor application team based on the requirements.
• Coordinate with data architect in developing the dimensional model (star schema) of the reporting data mart.
• Develop Informatica mappings to load flat files from vendor system into staging table after applying data validation rules using Informatica transformations.
• Create Informatica mappings to populate the dimension and fact tables from stage table.
• Perform unit testing & system testing of Informatica components in various environments and resolve the issues noticed.
• Finalize the design and template of SSRS reports by working with business users.
• Develop 30+ SSRS reports with sub reports, dynamic filters as per the business needs.
• Develop complex stored procedures for SSRS reports and verify the report data against existing business reports.
• Identify the performance issues in Informatica workflows and SSRS reports and resolve it by working with DBAs.
• Coordinate the project activities with offshore team and deliver the project on time.
• Guide the offshore team members in the development of Informatica jobs and SSRS reports.
• Coordinate with various teams to deploy the Informatica jobs and SSRS reports into production.
• Document the application process & transition the knowledge to support team after the production release.

Confidential, Milwaukee, Wisconsin

Administrator

Technologies: Informatica Power Center 9.1, Informatica Power Exchange 9.1, SSRS 2012, Business Objects XI R3, Crystal Reports 2008

Responsibilities:

• Monitor various BI applications servers and fix failures in both prod & non-prod environments.
• Build new application setup in Informatica, Business Objects & SSRS environments based on project team requirements.
• Set up new Informatica repositories and folders & applied security for new projects.
• Create data connections in Informatica, BO & SSRS environments for various projects.
• Enforce security management in BI applications by creating groups and restrict users.
• Resolve high priority production tickets within SLA by working with other teams.
• Migrate Informatica, BO, SSRS components between prod & non-prod environments.
• Provide support to the maintenance activity on application servers.
• Analyze the manual processes in admin team and came up with automated processes for it.
• Assist various project teams to resolve their job failures and performance issues in BI applications.

Confidential, Milwaukee, Wisconsin

ETL Lead & Developer

Technologies: Informatica 9.1, Business Objects XI R3, DB2 v10, UNIX

Responsibilities:

• Analyze the Informatica jobs & database components of current learning management system and develop Informatica solution for the new learning system.
• Learn the working of Success Factors application and develop reports in the new system to provide source data for Informatica jobs.
• Monitor various issues in OLTP and Data Mart Informatica load process in production and resolve it in a very short turnaround time.
• Analyze the data issues in Business Objects reports and apply the fixes in database and Informatica jobs through change management process.
• Gather requirements and develop the design & mappings for new Informatica small projects using various transformations like filter, expression, sequence generator, update strategy, joiner, stored procedure and union.
• Review the Informatica mappings developed by offshore and suggested necessary improvements.
• Coordinate the project activities with offshore team and guide them on various issues.
• Identify process improvements in existing applications and implement it.

Confidential

Offshore Lead & ETL/Report Developer

Technologies: Informatica 9.1, Business Objects XI R3, UNIX, Oracle 10g, Performance Point, Genesys SIP server, Teradata 13

Responsibilities:

• Monitor the Informatica production jobs and resolve the job failures within the SLA
• Analyze and fix the various data issues in Business Objects and custom reports.
• Gather requirements from business users and develop Informatica mappings as part of enhancements.
• Implement the Informatica jobs and reports in production through the change process.
• Schedule the Business Objects and Crystal reports for business users.
• Build and deliver custom Business Objects reports as per business user’s request.
• Primary contact to resolve the data issues in reporting applications by coordinating with other support teams.
• Coordinate the project activities with onsite counterpart and manage a team of size 4.
• Provide guidance to team members on complex issues and helpe them to implement the defect fixes.

Confidential

ETL Developer

Technologies: Informatica 8.6, Oracle 9i, SQL Server DTS, MS Access, Pervasive Data Integrator

Responsibilities:

• Analyze the small change requests (SCR) from business and come up with the design for the new enhancement and changes.
• Develop new ETL jobs and modified the existing SQL Server DTS jobs based on new change requests.
• Automate MS DOS scripts for file transfer between different servers and execute different processes in their order.
• Fix the production issues and apply the new change requests in Oracle PL/SQL packages, pervasive data integrator and DTS jobs
• Implement Informatica jobs in production after thorough testing.
• Migrate legacy ETL applications into the new environment and Informatica mappings.
• Monitor production ETL jobs and fix the issues in a very short turnaround time.
• Provide necessary reports to business users in MS Access application.

Confidential

Database Developer

Technologies: Netezza 3.1, LINUX

Responsibilities:

• Analyze requirements from the client and implement the database schema and tables in new netezza database.
• Review the existing SAS programs and provide suggestions regarding key areas of improvements in netezza programs.
• Create new nzsql scripts for populating the netezza tables from source files and performing various calculations.
• Develop Linux scripts to execute nzsql scripts in the respective orders.
• Perform unit testing & system testing of nzsql programs against the existing SAS programs and validate the data in both systems.
• Automate all the Linux & nzsql scripts to run for every subsequent change in the year without any manual intervention.

Confidential

Report Developer/Support

Technologies: Business Objects XI R2, Cognos Impromptu 7.0, MS SQL Server 2005, Oracle 8i

Responsibilities:

• Analyze the Business Objects reporting issues raised through incident tracking tool and implement the fixes within a very short turnaround time.
• Create new reports as per business requirements as well as the enhancement to the existing reports.
• Fix the production issues in SQL Server stored procedures for data transfer.