SUMMARY

• I have 10+ years of experience in the field of Information Technology. As part of my assignments, I was mainly involved in ETL Development, ETL Administration and Unix Shell Scripting for backend application development to automate administration tasks.
• I am very passionate about my work. A sense of urgency and willingness to be flexible with team size, schedules and working after hours. I am a self - motivator to perform better and learn latest technologies. I am excellent with time management and planning capabilities. I believe passion, sincerity, punctuality and friendly attitude is the key to success.
• Involve with the Business analysts in requirements gathering and data mapping.
• Develop Informatica mappings based on Design specifications.
• Design and development of interface maintaining the coding standards.
• Creating workflows and schedules.
• Assisted in the design of an efficient reliable mechanism for the creation of the National Pricing Solution application.
• Prepare Impact Analysis and Design Specifications for Coding and mapping standards.
• Working on service request for change and incidents on code failures or defects.
• Analysing the issue and make necessary changes to the code.
• Coordinating with Admin to migrate code to QA/test domain and then to live/PRD environment.
• Creating unit test plan, unit test result, collect unit test evidence.
• Coordinating with release management team by creating unit test plans, implementation plan and backup plan.
• Analysing the type of issue, whether this is a defect or enhancement or PRD failures and making necessary code changes accordingly.
• Working with system integration test team and production assurance test group on a change and complete the code migration path.
• Creating migration documents and facilitating code migration.
• Performance Tuning.
• Code Reviews.
• ETL Troubleshooting.
• ETL Security Architecture and Enhancement.
• Code Migrations to different environments.
• Creating Users/Groups/Projects based on Project Setup.
• Creating all types of database connections (FTP, SFTP, ORACLE, TERADATA etc.) from Workflow Manager.
• Using PMCMD, PMREP etc. commands to perform Informatica jobs from backend.
• Version control for all the Informatica projects before code migrations.
• Repository Creation from Informatica Admin console.
• Repository Backup from Informatica Admin console.
• Metadata Backup from Informatica Admin console.
• Moving source files from DEV to QA to PROD
• Folder to folder copy.
• Export as xml files.
• Server to server copy.
• Automate jobs through scripts using PMREP commands.
• Job monitoring through Workflow Monitor or Admin console.
• Hot fixes (8.6.1 / 8.6.12/ 8.6.14 etc.) and patch installation.
• Informatica Installation.
• Performance Tuning.
• Code Reviews.
• ETL Troubleshooting.
• ETL Security Architecture and Enhancement.
• Code Migrations to different environments using automated scripts (through air import/export commands).
• New Project Setup in the EME.
• Project’s Branch creation in the EME.
• New Group creation in the EME.
• Creating Project Directories in the backend (2-way, 4-way, n-way multi filesystem.)
• Creating all types of database connections (FTP, SFTP, ORACLE, TERADATA etc.)
• Using EME (AIR) commands to perform tasks from backend.
• Maintaining the sandbox to comply with the standards.
• Backup of sandboxes.
• Keep track on the disk space utilized by projects and users.
• Hot fixes and patch installation.
• Requesting keys for users (with expired keys) from AbInitio corporation.
• Version controlling for all the AbInitio projects before code migrations.
• Getting Package Support from AbInitio corporation.
• Development of applications in backend for AbInitio and Informatica administration using shell scripts.
• Automated scripts to keep check the utilized disk space.
• Automated scripts to maintain sandbox comply with the standards.
• Automated the following Informatica and AbInitio admin procedures using UNIX shell scripts:
• Deployment Group Migration/Copy from one Repository to another for Informatica 8.6.1 using automated scripts.
• Copying folder from one Repository to another in Informatica 8.6.1 using automated scripts.
• Rollback of deployment groups in Informatica 8.6.1 using automated scripts.
• Migrating AbInitio Projects from DEV to QA to PROD using automated scripts with commands like air export/import etc.
• Creating data directories of AbInitio projects using automated scripts.
• Creating new Private/Public projects for AbInitio in the EME using automated scripts in the UNIX backend for new AbInitio projects.
• Creating new branch of AbInitio projects using automated scripts.

TECHNICAL SKILLS

• Windows 2000/NT/XP/VISTA/7/10, HP UNIX, UNIX (Solaris), AIX.
• Oracle PL/SQL, UNIX Shell Scripting, C/C++
• Informatica PowerCenter 10.1 & 9.5, AbInitio, Oracle SQL Developer, Quality Centre
• Remedy, Tivoli

PROFESSIONAL EXPERIENCE

Confidential, Pleasanton, California

Sr. Business System Analyst

Responsibilities:

• Involve with the KP-IT & Business teams in requirements gathering and data mapping.
• Consulting with the end-users on their requirements and the challenges they face
• Create Logical & Physical design documents based on the requirements.
• Guide the ETL Development team in coding the design through Informatica workflows, sessions & mappings.
• Help in coding Unix scripts based on project needs.
• Create Informatica mappings for complex modules in the project.
• Write stored procedures, create packages as and when required to enhance performance and promote reusability.
• Help the support team to investigate any issues which can come up during production executions.
• Help in designing an efficient system in case of performance issues in production.
• Getting involved with Business Team to understand new requirements and in turn help the development team achieve the ETL design based on new requirements.
• Help Business team validate the benefits data during User Acceptance Testing (UAT).
• Work closely with the QA team to ensure the test cases are meeting the requirements documented in Logical & Physical design documents.
• Work closely with ETL Admin team, DBA team, Scheduling team etc. to perform cutover during production go-live of the application and its enhancements.

Hardware Windows PC, IBM AIX UNIX

Operating System AIX 5.3, Windows 10

Tools: & Languages Informatica PowerCenter 10.2.0, SQL, PL/SQL, Linux Shell Scripts

Project Location Pleasanton, California, United States of America

Confidential, Pleasanton, California

Sr. ETL Developer

Responsibilities:

• Involve with the Business analysts in requirements gathering and data mapping.
• Assisted in the design of an efficient reliable mechanism for the creation of the National Pricing Solution application.
• Prepare Impact Analysis and Design Specifications for Coding and mapping standards.
• Extensively perform unit testing and coordinated functional testing.
• Involve in project activities such as preparing the component inventory, build, implementation, integration, and testing the components.
• Integrating the various components and verifying the unit test results and system test results.
• Work closely with the QA team to ensure the test cases are meeting the requirements documented.
• Migrating the components to Production environment.
• Provide the warranty support and knowledge transfer to Maintenance team.

Hardware Windows PC, IBM AIX UNIX

Operating System AIX 5.3, Windows 7

Tools: & Languages Informatica Powercenter 9.5.1, SQL, PL/SQL, Linux Shell Scripts

Project Location Pleasanton, California, United States of America

Confidential, Pleasanton, California

Sr. ETL Developer

Responsibilities:

• Upgraded Informatica applications from Informatica 8.6.1 to Informatica 9.5.1.
• Upgraded Oracle 10g to 11g used by numerous applications.
• Completed dry run of the code components in development environment, performed code / configuration changes and applied the SAE standardization changes. Overall extensive standardization was done for all these applications.
• Issues were resolved by applying fixes during the upgrade program.
• Worked together with the DBAs, Unix Admins, ETL Admins etc. for a seamless tech upgrade of the applications.
• Perform retrofitting of code for any current development or production bug fixes
• Performed extensive Unit & SIT/UAT testing before the applications were upgraded and migrated to production for go-live. Unit test preparation and execution for Informatica & Oracle. Executed Regression testing.
• Ran the Jobs in new development environments for unit testing.
• Provided warranty support for the applications after upgrade and go-live with 0 defects.

Hardware Windows PC, IBM AIX UNIX

Operating System AIX 5.3, Windows 7

Tools: & Languages Informatica Powercenter 8x/9x, SQL, PL/SQL, Linux Shell Scripts

Confidential, Pleasanton, California

ETL Developer.

Responsibilities:

• Working on service request for change and incidents on code failures or defects.
• Analysing the issue and make necessary changes to the code.
• Coordinating with Admin to migrate code to QA/test domain and then to live/PRD environment.
• Creating unit test plan, unit test result, collect unit test evidence.
• Coordinating with release management team by creating unit test plans, implementation plan and backup plan.
• Analysing the type of issue, whether this is a defect or enhancement or PRD failures and making necessary code changes accordingly.
• Working with system integration test team and production assurance test group on a change and complete the code migration path.
• Creating migration documents and facilitating code migration.

Hardware Windows PC, IBM AIX UNIX

Operating System AIX 5.3, MVS, Windows XP

Tools: & Languages ABINITIOV1.14.37, Informatica 8.6.1, UNIX/AIX, DB2 v8, ORACLE 11g, PL/SQL