SUMMARY:

• 11+ years of Development experience in ETL/Data Warehouse, Teradata, and Mainframes.
• 7+ years of extensive ETL/Data warehouse and Teradata development experience.
• 4+ years of Mainframe development experience.
• Extensive ETL development experience using Informatica Power Center 9.x/8.x (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server).
• Extensive development experience using Teradata BTEQ scripts.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union and Aggregators.
• Strong experience in developing Sessions/tasks, Workflows using Task Developer and Worklow Designer.
• Knowledge on Teradata Utility scripts like Fastload, Multiload to load data from various source systems to Teradata.
• Experienced in writing Teradata SQL scripts for transforming business rules.
• Performed bulk data load to Teradata RDBMS using BTEQ, Fast load and Multi load.
• Extensive development experience in working with large scale Enterprise Data Warehouse for Legacy Data Warehouse Decommission projects.
• In depth technical knowledge and understanding of Data Warehousing, UNIX, SQL, Teradata and ETL.
• Hands on working experience in UNIX.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture.
• Very good understanding in Data Modeling and levels of Data Modeling Conceptional Data Modeling, Logical Modeling (ER Modeling, Dimensional Data modeling) and Physical Data Modeling
• Thorough knowledge on Data ware House concepts of Star Schema, Snow Flake Schemas Dimension and Fact tables
• Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Worked extensively with Slowly changing Dimensions Tables
• Extensive working experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading
• Excellent knowledge in extraction, cleansing and modification of data from/to various data sources like flat files and databases.
• Data profiling done to analyze and understand the type of data that can come in various fields of a table for Legacy Data Warehouse Decommission project.
• Code analysis done to ensure that there are no gaps with respect to the requirements provided.
• Experience in writing medium to complex Bteq scripts based on the data mapping & requirements provided.
• Created SQL queries and validated data counts and Referential Integrity between tables during unit testing of the code.
• Extensive working experience and good knowledge in Health Care domain especially in Claims/Provider/Member/Revenue Subject Areas.
• Very strong understanding of DB Concepts, have worked on Teradata, DB2, IMS DB.
• Good experience in working with onsite - offshore team model projects.
• Well-versed with all stages of Software Development Life Cycle (SDLC).
• Knowledge on Agile Methologies and the processes involved in it.
• Hands on experience in all phases of Project life cycle such as requirements gathering, risk analysis, project planning, Design, Coding, Unit Testing.System Integration Testing and Implementation.
• Actively participating in business requirements gathering sessions and understand client requirements
• Actively participate in design review and code review meetings
• Participation in the Weekly client meetings and Communicating with client about Relative Health of the project.
• Experience in creating Requirement Traceability Matrix (RTM) document.
• Technical expert in developing the MAINFRAME applications which includes COBOL, JCL, DB2, VSAM, Structured query language (SQL).
• Process oriented, versatile and highly motivated team member with a positive attitude and the ability to support multiple projects simultaneously.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks.

TECHNICAL SKILLS:

Operating Systems/ Products: Windows 2007, MVS/OS-390, UNIX

Programming: COBOL, JCL, SQL, UNIX, Shell Scripting, SAS, Teradata SQL

ETL Tools: Informatica

Databases: Teradata 14.0, DB2, VSAM, IMS

Technologies Known: Mainframes

Scheduling Tools: WLM, CA-JOBTRAC

Other Tools: TSO/ISPF, File-Aid, QMF, SPUFI, Endeavor, Change Man,IOF, SDSF, BTEQ, SQL Assistant, Multi load, Fast load, Fast Export, Tpump.

PROFESSIONAL EXPERIENCE:

Confidential, VA

Senior Systems Analyst

• Perform test data management activities in support of projects in the test environment.
• Reviewing and executing data copy requests for projects in the test environment.
• Attending project meetings for regression projects and gathering business requirements.
• Performing requirement document analysis and estimation, transferring the knowledge to the offshore team.
• Analyze WLM jobs and support System Integration Testing
• Performing component migration and code retrofit in test environment.
• Preparing the required execution plan documents and reviewing it with stakeholders.
• Preparing the test environment for test data load execution.
• Coordinating with source system teams and QA teams.
• Performing test data loads for regression testing projects.
• Attend onsite and offshore conference calls to ensure that the work adhere to the UST Global’s established high quality assurance standards and processes.

Environment: Informatica, Teradata SQL Assistant, Bteq scripts, UNIX, WLM tool for job execution.

Confidential,VA

Senior Systems Analyst

• Actively worked in gathering and analyzing requirements, and impact analysis to identify gaps in populating the columns into EDWard from legacy data warehouse.
• Worked in schedule preparation, estimation, and task allocation.
• Worked in developing Requirement Traceability Matrix (RTM), Design documents, developing and reviewing of code, unit test case and unit results preparation and review.
• Responsible for Co-ordination of all Project Activities.
• Participated in Project Team meetings and Test Strategy review meeting
• Conducted System Integration Testing, coordinating with business for User Acceptance Testing, Implementation Readiness and Production Implementation

Environment: Informatica, Teradata SQL Assistant, Bteq scripts, UNIX, WLM tool for job execution.

Confidential,PA

Systems Analyst

• Worked in gathering and analyzing requirements.
• Worked in schedule preparation, estimation, and task allocation.
• Worked in strategy document preparation to implement the applications in business readiness region.
• Performed coding and job creation for all applications.
• Executed the test jobs as part of unit testing.
• Responsible for Co-ordination of all Project Activities.
• Participated in Project Team meetings.
• Conducted System Integration Testing and Production Implementation

Environment: Mainframe JCL, VSAM, DB2, Endeavor, File Aid

Confidential,OH

Senior Software Developer

• Worked in gathering and analyzing requirements.
• Worked in impact analysis, estimation and preparation of Requirements Traceability Matrix (RTM).
• Prepared Design document and conducted walkthrough with stakeholders.
• Worked in coding, unit test case and test results preparation for unit testing.
• Executed the test jobs as part of unit testing.
• Participated in Project Team meetings.
• Conducted System Integration Testing and Production Implementation

Environment: Informatica, UNIX, SQL, Mainframe JCL, VSAM, DB2, SAS, Change Man, Endeavor, File Aid