SUMMARY:

• Over 10 years of experience in Data warehousing, Dimensional Data Modelling, ETL Database Development, Data warehouse Testing and Data Analyst
• Experience in all phases of data warehouse development viz. Requirements analysis, application design, development (including ETL and database), code migration, testing, implementation to Production environment and Production support.
• Experienced in RDBMS such as Teradata 15/14/13/V2R6 /V2R5, Oracle 10g, 9i, SQL Server & DB2.
• Experienced in Teradata utilities such as BTEQ, Multi Load, Fast Load, TPT, Tpump and Data Mover.
• Experienced in query/scripting languages such as SQL, PL/SQL and UNIX Shell scripting.
• Experienced in tools like SQL*Plus and Teradata SQL Assistant .
• Experienced in Auditing for Data load processes and data extraction processes using load log key concept.
• Experienced in ETL development using Informatica Power Center 10/9.6/8.6/7. x (Transformations, Mappings, Mapplets, Sessions, Workflows etc.) and Datastage Px.
• Experience in performance tuning of Informatica ETL mappings, sessions, workflows and PL/SQL stored procedures.
• Experienced in loading from/to flat files (fixed - width, delimited) and XML files.
• Expert in Data Stage PX installation/Upgrading & setting up configuration file on UNIX.
• Created & modified Teradata databases, performed capacity planning, allocated space, and granted rights for all objects within databases.
• Worked extensively on Data Mover scripts to move data between different Teradata Servers.
• Quality Assurance - Conducted Quality Reviews, Preparation of Templates/Coding Standards/Review Checklists/Deployment Checklists, Quality Audits for Version Control and adherence to Quality Processes, Identification of Best Practices followed in the project, building Traceability Matrices.
• Prepared and Executed the Test Cases during Unit testing and provided extensive support to QA in System, Regression and UAT (user acceptance testing) and deployment of Components
• Have good Knowledge on project related application creation and Installation.
• Worked on projects, which involved tight deadlines, big development teams and direct interaction with client/end-users.
• Contributes to the improvement of the existing processes and identification of new processes and technical alternatives in order to resolve problems .
• Strong focus on quality and adherence to timelines of deliverables.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills, strong team player with an innate ability to take on new roles and enthusiastic in learning new tools and business environment.
• Have good Knowledge on SAS Enterprise Guide, Big Data- Hadoop, Hive and Scoop technologies.

TECHNICAL SKILLS:

Major Strong Skills:  Teradata, Data Mover, Data stage, Informatics, SSIS,XML, & UNIX

Operating Systems:  Unix & Windows

Tools:  Putty, File Zilla, Contol-M, Clear case, PVCS, Tortoise SVN, Auto Sys &Work Load Manager 

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

Source Data Analyst 

Environment: Teradata, UNIX, SAS, Main Frame, Hadoop, HIVE, Autosys & MKS

Responsibilities:

• Analyzed source data and Interaction with IT team of the client for the purpose of requirement gathering, understanding requirements and Active involvement in project workgroup meetings to resolve any ambiguity, incompleteness or incorrectness of requirement.
• Actively involved in the Design of the project, Collected & Analyzed business requirements and converted them in to a Technical Specification document.
• Responsible for putting together the Detailed Design documents required for the new development effort and will coordinate the Design & Construction checkpoint review processes.
• Involve in all phases of SDLC including Estimation and Project plan.
• Designed and developed an entire Data Mart from scratch.
• Loading Medicaid Data to the Teradata Data Warehouse Tables from multiple data sources using Teradata utilities Multiload, Fast load and BTEQ Scripts.
• Written Complex Business transformations using Teradata- BTEQ Scripts.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
• Identify and resolve technical problems related to performance, functionality and coordinate with end users as necessary.
• Expertise in Data quality, Data organization, Metadata, and Data profiling.
• Experience in database analytics, data infrastructure development, and data mining.
• Responsible for the Change Management process and in coordinating the Systems Integration & Production Implementation of the new sourcing efforts.
• Handling Primary Production support by monitoring jobs, Defect Resolution and Analysis /Clarification and provide prompt response to job failures.
• Production break-fix INC resolution, automated ticketing incidents and user opened incidents also inclusive of coordination for prod deployment
• Fix on errors - Deployment of code and data fixes by performing root cause analysis, and application performance improvements.
• Enhanced existing Scripts to adhere to new IDR Standards provided and followed by Organization.
• Extensively make use of Bteq Scripting, Utilities such as Fast Export, Multi Load, Fast Load and TPT.
• Helps lead Business continuity and disaster recovery exercises as well as DR backup daily execution.
• Involved in writing Test Plans, Test Cases, Test Scripts and Test Queries. Also worked closely with Users and helped in accomplishing the UAT successfully.
• Have very Good Knowledge on Medicare, Medicaid Ohio & Virginia data and T-MSIS Source system.
• Provided required support in Multiple (SIT, UAT & PROD) stages of the project.
• Acting as a single point of contact for a Project Manager for all Development resources and deliverables (Business Requirement document, Approach Document, Technical Design Document,Coding, Test cases, SDLC documents etc.).

Confidential, Richmond- VA

Environment: Teradata R12, Teradata Utilities, Informatica 8.6, SQL Server, UNIX, IBM Requisite Pro, IBM Service Center, WLM Scheduling, Clear Case for Version control and Quality Center.

Responsibilities:

• Involved with the Business analysts in requirements gathering, business analysis, discussed issues to be resolved and translated user input into Business specifications documents.
• Analyzed the Change Requests and did the impact analysis and effort estimation.
• Documented Business requirements, Coordinated with offshore team to prepare flawless ETL specifications and Technical design documents.
• Constantly interacted with the Confidential Representative, External Vendor, Business owners of extracts to gather the Remediation and Repointing requirements.
• Well versed with IBM Rational Requisite Pro software integrated tools for requirements management and analysis use case development, business modeling and data modeling.
• Lead and worked with teams to examine and solve business problems by accurately analyzing the needs of clients and helping them achieve improved quality and value of their business.
• Created multiple complex BTE script to load the data in to Teradata Tables.
• Actively involved in finding the Data issues and work with teams to implement the solutions.
• Identifying indexes for Teradata Tables to improve the performance.
• Collected stats on required tables to improve the performance.
• Created Join and Hash Indexes were required to improve the performance.
• Provided required support in Multiple (SIT, UAT, IR, PROD) stages of the project.
• Coordinated with WLMCOE team to create jobs in SIT/UAT/IR/PROD environments.
• Effectively worked with data architect, DBA, Testing team and production control team.
• Project delivery management - Single point of contact from offshore for deliverables/issues. Coordinating between onsite and offshore to ensure smooth and timely delivery.
• Resolve the issue for History data & apply the necessary changes to Incremental scripts
• Have developed a level of competency, which helps to anticipate issues and solve them in advance
• Proactive team player with demonstrated problem solving and analytical reasoning abilities.

Confidential, Minneapolis-MN

Environment: Teradata, Informatica 9.1, UNIX & Build Forge

Responsibilities:

• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Responsible for effective communication between the project teams and the customer. Provide day to day direction to the project teams.
• Involved in writing the ETL specifications and unit test plans for the mappings.
• Design and development of ETL process extracting Member, pharmacy and provider from IDW and send files to Inovalon for generating analytic report.
• Automated the jobs thru scheduling using Main Frames scheduler i.e CA7, which runs every day by maintaining the data validations.
• Effectively worked with supporting groups data architect, DBA, Infa Admin, Testing team, Scheduling team and production control team
• Have developed a level of competency, which helps to anticipate issues and solve them in advance.

Confidential

Environment: Teradata, Bteq, Fast export & Informatica 8.6,UNIX & WLM

Responsibilities:

• Worked on Informatica Power Center tool - Source Analyzer, Warehouse designer, Mapping, Transformations, Informatica Repository Manager and Informatica workflow Manager.
• Involved in the migration process of Informatica from version 8.1 to Informatica 8.6.
• Used ETL to standardize data from various sources and load into Data Stage area, which was in Teradata.
• Developed and Implemented different transformation techniques for identifying slowly changing Dimensions as per technical specifications.
• Extensively used ETL to load data from fixed width as well as Delimited Flat files, COBOL, XML files.
• Created ftp connections, database connections for the sources and targets.
• Created workflows and worklets for designed mappings.
• Implemented Variables and Parameters in the mappings
• Extensively worked in the performance tuning of programs ETL procedures.
• Performed the troubleshooting when the workflows failed in loading the data.
• Implemented complex Business logics using BTEQ.
• Modified the reusable scripts such as Load log key & Audit Process as per the project requirement.
• Project delivery management - Single point of contact from offshore for deliverables/issues. Coordinating between onsite and offshore to ensure smooth and timely delivery.