SUMMARY

• About 8 years of experience in Analysis, Design, Development, Testing and Implementation of Software Applications
• Associated as a full time employee with Tata Consultancy Services. Currently designated as Computer System Architect at Confidential, Greenfield as client location.
• Currently working as a consultant for R&D Portfolio management and Product Management team at Confidential headquarters, USA since May 2013 - present
• Experience in development of Informatica Interfaces (creation of workflows, session, mappings)
• Extensive experience in Enterprise Data Warehousing (EDW) and crystal reports.
• Expertise in database performance, data warehouse, ETL, SQL queries, PL/SQL procedures, packages, functions, cursors, triggers and Exceptions.
• Excellent hands-on experience in UNIX shells scripting.
• Experience in Planisware for portfolio management
• Experience in Track Wise/Workflow Customization according to the business needs.
• Experience in three full lifecycle implementations. Strong knowledge of CAPA (manufacturing), product development life cycle and portfolio management.
• Experience in Retail and Life Sciences Domain
• Strong analytical, diagnostic and troubleshooting skills and ability to work in a fast-paced and team-oriented environment.
• Experience in environments requiring direct customer interaction during requirement specifications, documentation, design and development and implementation phases.

TECHNICAL SKILLS

Computer System: Windows XP, Windows 7, Unix

Database/Tools: Planisware PRO, Oracle-11g, TOAD, PL/SQL developer and Putty for UNIX.JIRA, PVCS, VSS, Informatica-9, Track Wise, SQL LOADER, FTP, Crystal Reports, HP QC 11,Crystal reports. Remedy ticket tracking tool, SharePoint

PROFESSIONAL EXPERIENCE

Confidential, Greenfield, Indiana

Informatica ETL Developer

Environment: Informatica 9.1,UNIX Server, Oracle, Planisware5 IS (SP5.3), Planisware PRO, Remedy, SharePoint, Insights.

Responsibilities:

• Working on Informatica Designer Components Source and Target Analyzer, Transformation Developer, Mapping Designer, Workflow Designer.
• Developed various mappings to load data from sources using different transformations like Router, Aggregator, Joiner, Lookup, Update Strategy, Expression and Sequence Generator to store the data in target table.
• Analysis and Designing the DataMart tables based on Business process. Understanding of Dimensional Data Modelling using Star and Snow Flake Schema, Identifying Facts and Dimensions.
• Developed complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems to maintain full history on project key dates change.
• Worked extensively with the connected lookup Transformations using dynamic cache.
• Created sessions for incremental load into staging tables and scheduled them to run daily.
• Used FTP utility to transfer files from windows server to Linux environment to load Relational Target.
• Developed mappings using External Loading in Informatica Power Center
• Implemented source and target based partitioning for existing workflows in production to improve performance so as to cut back the running time.
• Develop Stored Procedures, Functions and Table Views.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Documentation of ETL Mappings to minutest details so that code could be rebuilt from scratch in case of potential code loss.
• Work with Planisware implementation and R&D business team to translate business requirements into tool functionality.
• Coordinate with Planisware Vendor for System Upgrade and Performance Tuning.
• Support Insights Team on demand business crystal reports

Confidential

Informatica ETL Developer

Environment: UNIX Server, Oracle 11g, Informatica, Remedy, crystal reports, SQL LOADER, FTP, VSS, SharePoint.

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Troubleshooting and resolving technical and functional issues with the users in different Zones of the world
• Managing Change Requests/Trouble Tickets and Delivering solutions as per defined SLA.
• Involved in development of Informatica Interfaces (creation of workflows, session, mappings, complex SQL queries), Unit Testing the code for the functionality, Performed Code Review as well.
• Involved in resolution of Informatica workflows and session failures due to various reasons using Repository
• Develop Oracle-Pl/SQL procedures and functions for populating various staging and production tables/views
• Involved in automation of process, hence improvement in existing process. Developed various UNIX scripts.
• Developed various mappings to load data from sources using different transformations like Router, Aggregator, Joiner, Lookup, Update Strategy, Expression and Sequence Generator to store the data in target table.
• Developed Mapping variable and parameters that can be used throughout the session.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Involved in extracting the data from the Flat Files and Relational databases into staging area
• Push down optimizing mapping by taking the ETL logic more towards Oracle Database level.
• Involved in performance tuning of Informatica workflows at oracle database level.
• Automated jobs execution using Informatica and DBMS JOBS.
• Developing automated job monitoring tool using UNIX Scripts to generate trouble tickets in case of any errors.
• Prepare Design document and test scripts and Perform System Testing using HP QC
• Develop Crystal reports based on business requirements.
• Implement changes to Production environment

Confidential

Software engineer

Environment: UNIX, Window XP, PL/SQL, UNIX, SQL, Oracle 10i, SQL LOADER, FTP, JIRA, PVCS

Responsibilities:

• Data was stored in production staging tables which used various sources (tables from different schemas and flat files). Database was designed in star schema and needed transformation to load it to various materialized views for the reporting application to utilize. As a system engineer, developed Pl/SQL codes for the custom ETL RUN.
• Analyse Requirements from onsite coordinator and estimate timelines
• Develop Stored Procedures, Functions, Views, Cursors, Packages and Table Views.
• Develop/automate UNIX scripts to connect to PL/SQL code and schedule jobs in crontab.
• Data Conversion from Flat files to Oracle using SQL* Loader.
• Create UNIX scripts to format flat files to be used by SQL* Loader.
• Prepare Design document and test cases for testing team
• Co-ordinate with onsite in Production deployment of the codes.