Professional Summary:

• 11 years of experience in several projects covering all the areas of Software Development Life Cycle SDLC development including requirements analysis, application design, technical design, development, testing debugging, implementation, documentation and incorporation of user feedback to plan enhancements in the application system using various technologies such as Informatica and Datastage, and expertise in integrating with Mainframe.
• Worked strongly with the business and testing team. Extensively worked and communicated with the Vendors such as NFS, Experian, FDR and Supported as an ON CALL to the team during warranty.
• Extensively worked in integration of various data sources like Oracle, DB2, SQL Server, Flat Files and Mainframe into Warehouse. Excellent understanding of Database Management System and Data Warehouse including their functional and technical architecture and the design of Data Flow Diagram. Well versed in Data modelling concepts incorporating dimensional modelling star and snowflake schema , logical and physical data modelling. Implementation and Support of various web based applications in OLTP, Data Warehousing, and OLAP application.
• Served as a technical lead and architect in the team. Analyze user needs and software requirements to determine feasibility of design within time and cost constraints Good experience in all phases of the projects starting from business requirements gathering to testing and production support and technical support during warranty.
• Extensively worked on Informatica Power Center, IBM Infosphere Datastage 9.1, Mainframe and Visual Studio.
• Excellent team player and interacts very well with business upon the project needs.
• Excellent knowledge transfer as well documentation skills.

Skills Summary:

Software/IDE: SQL PLUS, TOAD and Mainframe

Languages: SQL, PL/SQL, COBOL, JCL, CICS, ADSO, Sync Sort, CLIST,CICS and REXX

Database: Oracle, SQL Server and DB2

ETL Tools: Informatica Power Center 9.x,8.x, IBM Infosphere Datastage 9.1

Special Software: File-Aid, DFSORT, Expeditor, FTP, NDM, VSAM, REXX, MQ Series, Abend-Aid, Lotus Notes,

and SPUFI

Scheduling Tools: Job Trac and CNTL M

Migration Tools: Change man, Endeavour and SCM

Defect trackers: STAR

Platforms: Windows 9x/00/NT/XP, UNIX, AIX

Office Tools: MS Word, MS PowerPoint, MS Visio, MS Access, MS Excel, Share Point

Professional Work Experience:

Confidential

Tech Lead

• United Services Automobile Association USAA is a Fortune 500 financial services company offering banking, investing, and insurance to people and families that serve, or served, in the United States military. USAA was founded in 1922 by a group of U.S. Army officers to self-insure each other when they were unable to secure auto insurance due to the perception that they were a high-risk group. USAA has since expanded to serve all members of the Armed Forces and all who served honorably in the US Armed Forces, as well as their families with property casualty insurance, banking, life insurance, investment and financial planning products and services.

Confidential

Responsibilities:

• Actively participated in the meetings with Business, Vendor, and functional teams to understand both NF and Phase3 systems.
• Responsible to complete master sheet to create a mapping between P3 vs NF data elements, and attended lot of meetings with NF and USAA SME's for the same.
• Participated in data conversion meetings to discuss on conversion strategy to convert USAA members position, balance and account details to NF.
• By using current system flow diagram, prepared TO BE detailed design document which cover detailed ETL flow, S2T mapping, control m flow, conversion period strategy, business filter logic..
• Responsible for detailed design reviews for entire work stream as a Third Party Tech Lead with Architects.
• Created master sheet which covers retired, modified, new jobs.
• Responsible for internal reviews of the deliverables by the team members.
• Responsible for code reviews with Maintenance team during Integration Testing to make we followed all coding standards and proper design approach.
• Responsible for attending status meeting with customer for the project status.
• Created SQL scripts to create new tables and insert/update/delete rows in the tables for testing purposes.
• Implemented the underlying logic for Slowly Changing Dimensions.
• Full integration test of all jobs within each sequence before migrating the jobs and sequencers from the Development environment Dev to the QA environment, and from the QA environment to the Production environment.

Environment: ERWIN, Oracle 10g, DB2, Flat files, Datastage 9.1 and Mainframe, Flat files,Win NT, SQL Developer, Microsoft Share Point, Microsoft Visio, Microsoft Office, Shell Scripting, WinNT 4.0 UNIX.

Confidential

Responsibilities:

• Extensively involved in Gathering requirements by holding meetings with users.
• Identify entities and relationships in a business environment using an event-oriented focus.
• Modeled the business process in the enterprise wide scenario.
• Constructed context diagrams and data-flow diagrams based on a description of a business process. Analyzing the data model and identification of heterogeneous data sources.
• Constructed an extended entity relationship diagram based on a narrative description of a business scenario.
• Performed testing and QA role: developed Test Plan, Test Scenarios and wrote SQL Plus Test Scripts for execution on converted data to ensure consistency.
• Experience in integration of various data sources like Oracle, DB2, SQL Server, Flat Files and Mainframe into Warehouse.

Environment: ERWIN, Oracle 10g, DB2, Flat files, Informatica Power Center 9.5, Datastage 9.1 and Mainframe, Flat files,Win NT, SQL Developer, Microsoft Share Point, Microsoft Visio, Microsoft Office, Shell Scripting, WinNT 4.0 UNIX.

Confidential

Responsibilities:

• Prepare ETL Architecture and ETL Mapping specification Documents to integrate source data into Integrated layer.
• Identify the Data granularity and Design the Data model for staging, integrated layer and semantic layer
• Design the ETL process to source the data from sources and load it into DWH tables.
• Designed Partition Methods, Primary Index key identification, Indexing strategy for Fact Tables, Disk usage statistics and automated email notification to PROD Support Team.
• Developed Unix shell scripts to FTP source files, validate source files, automated archival of Log files, create ETL event start/stop files.
• Designed Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator, Transformer, Sort, Link Partitioner and Link Collector.
• Development of Informatica mappings and Mapplets and also tuned them for Optimum performance, Dependencies.
• Used Informatica to extract, transform and load data from multiple input sources like Oracle/ SQL Server, Flat files into Oracle 10 g database.
• Extensively Worked on Informatica tools such as Source Analyzer, Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer.
• Used different transformations like Aggregator, Filter, Router, and Sorter, Stored Procedure, and Sequence Generator, lookup, Expression and update strategy in the development of mappings.
• Performed various reusable techniques for business logic reusability like mapplets, Reusable transformations, and reusable sessions.

Environment: ERWIN, Oracle 10g, DB2, Flat files, Informatica Power Center 9.5, Datastage 9.1 and Mainframe, Flat files,Win NT, SQL Developer, Microsoft Share Point, Microsoft Visio, Microsoft Office, Shell Scripting, WinNT 4.0 UNIX.

Confidential

Responsibilities:

• Interact with Client, gather requirements and shared it with offshore team
• Involved in Analyzing the source system, data modeling and preparing mapping document
• Actively involved in Analysis, Design and Development, Testing and peer review
• ETL Coding and Job design implementation, which involved extensive use of different
• Transformations, Shared Containers and Sequences
• Performed Impact Analysis based on the Change request
• UNIT testing and System testing of ETL codes in development environment.
• Export/Import metadata from repository, .dsx jobs, Table definitions within the projects
• Development of DataStage jobs, Sequence jobs and Shared Containers.
• Preparation of unit test cases and data validation.
• Acquired the knowledge of business process flow.
• UNIX shell scripting and Scheduling the DataStage jobs in Control-M.
• Used DataStage Manager to Import and Export DataStage components and Import table definitions from source databases.
• Used DataStage Director for monitoring and debugging of the jobs and Sequences.
• Worked on the SQL Navigator, DB2 QMF tools to extract the data from the Source DB2, Mainframes and the target is Oracle database.
• Created Test plans, Test cases and performed Unit Testing, Integration Testing System Testing.

Environment: ERWIN, Oracle 10g, DB2, Flat files, Informatica Power Center 9.5, Datastage 9.1 and Mainframe, Flat files,Win NT, SQL Developer, Microsoft Share Point, Microsoft Visio, Microsoft Office, Shell Scripting, WinNT 4.0 UNIX.

Confidential

Responsibilities:

• Single handedly delivered Email track without any defects and also worked in modules like MAAC, Pre approvals, Credit card tracks and Control table creation process.
• Actively involved in Analysis, Design and Development, Testing and peer review
• Involved in Analyzing of Mapping document and peer review
• ETL Coding and Job design implementation, which involved extensive use of different
• Transformations, Shared Containers and Sequences
• UNIT testing and System testing of ETL codes in development environment.
• Export/Import metadata from repository, .dsx jobs, Table definitions within the projects
• Development of DataStage jobs, Sequence jobs and Shared Containers
• Preparation of unit test cases
• Acquired the knowledge of business process flow

Environment: ERWIN, Oracle 10g, DB2, Flat files, Informatica Power Center 9.5, Datastage 9.1 and Mainframe, Flat files,Win NT, SQL Developer, Microsoft Share Point, Microsoft Visio, Microsoft Office, Shell Scripting, WinNT 4.0 UNIX.

Confidential

Sr. Software Engineer

Responsibilities:

• Interacting with Business Users and Business Analysts to gather requirements
• Dimensional modeling of the Data Warehouse
• Involved in loading financial data from Mainframe VSAM and sequential files to Oracle using Informatica.
• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Designing the Data Refresh strategies for loading data into Dimensions and Facts.
• Designing and creating mappings Using Mapping Designer of Informatica Designer tool.
• Creating complex Mappings using Transformations like Lookups, Update Strategy, and Joiner using Designer.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Connected unconnected lookups, Filter, Router, Sequence Generator, Sorter, Joiner, and Update Strategy.
• Creating reusable Transformations, Mapplets using Informatica Designer.
• Creating and scheduling workflows from Workflow Manager.
• Used COBOL, DB2,VSAM and Flat Files for processing the data.
• Preparing design documents and test specifications
• Managing, coordinating, planning and executing project.

Environment: : Informatica 8.6.1 - Designer, Workflow Monitor, Workflow Manager, IBM Mainframe, COBOL, JCL, DB2, VSAM, CICS.