SUMMARY

• Highly motivated Software Programmer/Analyst with 6 plus years’ experience in Software Analysis, Design, Development, Testing and implementation. Good domain expertise in the Telecom billing area, Ecommerce and healthcare.
• 6+ years of experience as data developer/ Analyst using Informatica Power Center 9.6/8.5,Oracle, SQL, PL/SQL, Data Analyzer, ETL, DataMart, OLAP, OLTP, Developer 2000, COBOL, UNIX, Shell Scripting, C, C++, and Pro*C
• Full life cycle experience including Software Analysis, Design, Development, Testing, Implementation, User Documentation and Post Development Support of various projects.
• Experience in developing SQLs for various selection and update criteria in Jobs
• Proficient with Creating Test Plans and Program Specifications
• Experience with Agile, Waterfall methodologies, scheduling tools like Control M and Data Integration Hub.
• Excellent Coding, Debugging and Analytical skills
• Proficient in dimensional modeling such as Star schema and Snowflake schema.
• Experience in implementing business rules by creating reusable transformations, MAPPLETS, transformations and PL/SQL stored procedures
• Experience in using UNIX, Linux commands
• Highly motivated resourceful team player takes a positive approach to problem resolution
• Good communication and interpersonal skills, able to work with the team and independently under tight schedules

TECHNICAL SKILLS

Operating System: Windows 2000, Windows 7, Windows 10,UNIX,Windows NT

Tools and Utilities: MS Office (Excel, Word, Outlook), SQL Developer

Programming Languages: C, C++, COBOL, PL/SQL

Design/Development Tools: Informatica PowerCenter (10.1/9.6.1/9.0.1/8.x),PowerExchange 10.1/9.6.5) Data Analyzer, ETL, DataMart, OLAP, OLTP Developer Visio - 2000, Developer 2000, SQL*Plus, SQL*Forms3.0, SQL*Menu5.0, SQL*Reportwriter1.1, TOAD, MS- Office.

Database: Oracle8- 11g,DB2,pro*C,SQL Server

Scheduling Tools: Control-M, AutoSys and Data Integration Hub

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Informatica developer

Responsibilities:

• Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Moving the data from source systems to different schemas based on the dimensions and fact tables by using the slowly changing dimensions (SCD) type 2 and type 1.
• Used various transformations like Filter, Expression, Sequence Generator, Source Qualifier, Lookup, Router, Rank, Update Strategy, Joiner, Stored Procedure and Union to develop robust mappings in the Informatica Designer.
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files (Fixed Width and Delimited),SQL server to staging database and from staging to the target Warehouse database.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed. If the session fails debug the Mapping.
• Involved in testing Unit and integration Testing of Informatica Sessions, Batches, fixing invalid Mappings
• Defined the program specifications for the data migration programs, as well as the necessary test plans used to ensure the successful execution of the data loading processes.
• Developed and executed scripts to schedule loads, for calling Informatica workflows using PMCMD command.

Environment: Informatica PowerCenter 9.6.1/8.6.1,SQL Server 2008, Oracle 11g, PL/SQL, TOAD, AutoSys Scheduler, DIH, UNIX

Confidential, Chadds ford, PA

Informatica Developer

Responsibilities:

• Experience in all phases of Software Development Life Cycle (SDLC) which includes User Interaction, Business Analysis/Modeling, Design, Development, Integration, Planning and testing and documentation in data warehouse applications, ETL processing and distributed applications
• Strong expertise in using ETL Tool Informatica PowerCenter 10.1/9.6.5.1/8.6.5, Informatica PowerExchange 10.1/9.6.5.1(Designer, Workflow Manager, Repository Manager, Data Quality (IDQ10.1/9.6.1) and ETL concepts.
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from disparate data sources like Multiple Relational Databases (ORACLE 11g/10g, DB2, Mainframes, SQL server 2012, XML, Flat files
• Strong experience with Informatica tools using MD5 technique to capture the changes in data..
• Worked with various transformations like Normalizer, expression, rank, filter, group, aggregator, lookups, joiner, sequence generator, sorter, SQLT, stored procedure, Update strategy, Source Qualifier, Transaction Control, JAVA, Union etc.,
• Designing and developing Informatica mappings including slowly changing dimensions type 1 and 2.
• Validating data files against their control files and performing technical data quality checks to certify source file usage.
• Very good in data modeling noledge in Dimensional Data modeling, Star Schema, Snowflake Schema, FACT and Dimensions tables.
• Experienced in writing SQL, PL/SQL programming, Stored Procedures, Functions, Triggers, Views, Materialized Views.
• Experience in Performance Tuning and Debugging of existing ETL processes.
• Report, track and verify defects to resolution.

Environment:Informatica PowerCenter 9.6.1, Oracle 11g, Web Service, DB2, Control-M, UNIX, TOAD, Notepad++,VISIO

Confidential

Informatica Developer

Responsibilities:

• Gathered requirements from the end users and Involved in analysis of source systems, business requirements and identification of business rules.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Extracted sources from flat-files, Oracle, SQL Server and load them into Oracle.
• Responsible for creating system design and detail design documents based on the requirement document provided by the business users.
• Proactive team player with the demonstrated ability to multi-task and prioritize in a fast-paced professional environment.
• Maintained TEMPeffective communication with non-technical client personal and handled the change requests.
• Designed testing procedures and test plans. Provided Production support

Environment: Informatica PowerCenter 8.5, Oracle 10g, Flat Files, PL/SQL, Datastage, Erwin 6.1, MS Visio, SQL Developer, SQL*Plus, TOAD, Windows 2008, UNIX

Confidential

Programmer

Responsibilities:

• Analyze/translate the business requirement documents, to-be process flows into test scenarios.
• Attending the requirement meeting with the client.
• Design of Business Logic Diagrams using Visio - 2000 and review with the client.
• Development of batch and online programs using Oracle/Dev2000 and Pro*C.
• Creation and maintenance of database objects.
• Keeping and documenting system requirements and updating user manual.
• Creation of database structure using designer 2000
• Documenting detailed design document of each program developed.
• Developing reports using Proc*C and Developer 2000.
• Unit and integration testing of programs.
• Used TOAD for running SQL’s and accessing database objects.
• Support for system test and user acceptance test.
• Done file transfer between systems using FTP.
• Created menu for the project using Developer 2000.
• Completion of projects in a timely manner for production implementation.

Environment: Oracle 9, PL/SQL, C, Pro*C, TOAD, VISIO, UNIX, DEVELOPER 2000

Confidential

Programmer

Responsibilities:

• Attending the requirement meeting with the client.
• Designed data flow diagram using flow charts and reviewed with the client.
• Development of necessary programs using COBOL.
• Unit and integration testing of programs.
• Collected necessary sample data from the user and loaded into corresponding tables
• Support for system test and user acceptance test.
• Completion of projects in a timely manner for production implementation.

Environment: COBOL, EXCELL, VISIO, UNIX