SUMMARY

• Around 16 years of experience in System Analysis, Design and Development in the field of data Warehousing, Data Integration, Production Support, Migrations and developing Client server application using IBM (Ascential) Data Stage, Teradata Bteq Scripts, Fast load scripts, Control M, Netezza, Oracle store procedures and Shell scripts.
• 5+ years of experience in Business analysis and maintaining large Data Warehouses and DataMart using Teradata Bteq Scripts, Fast load scripts. Developed ETL processes with In - Depth knowledge in Data Warehousing & Business Intelligence concepts with emphasis on ETL Life Cycle Development including requirement analysis, design, development, testing and implementation.
• Lead teams and actively involved in development for Migration’s form Natezza to Teradata, Teradata 15.10 to Teradata 16.20, Oracle 11 to Oracle 12g.
• Trained in mulesoft and developed mule interface to create UNICA offers.
• Strong experience in handling ETL load failures due to resource constraints, missing/invalid data/files, Bugs and infrastructure component issues
• Implemented SCD’s (Slowly Changing Dimensions) and CDC (CDC Change Data Capture).
• Monitoring and reporting on SLAs and data availability Load
• Expertise in Extraction Transformation and Loading (ETL) processes using Data Stage Client components like Data Stage Designer, Director and Administrator in Data Warehouse development. Worked with Data Migration, Data Conversion in diverged environment like Oracle, SQL Server and complex flat files, Teradata and Netezza.
• Involved in Performance Tuning and troubleshooting of ETL programs. (Round Robin logic for partitioning Datasets using 4-nodes). Tuned Data Stage and Stored Procedures in Oracle.
• Expertise in OLTP/OLAP System Study, Analysis and Dimensional Modeling, E-R modeling and Forward/Reverse Engineering using Erwin. Strong knowledge on Strong SQL experience in working with SQL queries, PL/SQL Stored Procedures, Table Partitions, and Packages, to load data into Data Warehouse/Data Marts.
• Built customized routine UNIX shell scripts for implementing business logic and scheduled the jobs using Cron tabs.
• Developed Audit Controls and reports using Shell Scripts, Stored Procedures to audit the data at several different stages that is Auditing the data at Source systems, Staging, Data Warehouse and DataMart.
• Excellent communication skills, Good organizational skills, outgoing personality, Self-motivated, Initiative, hardworking, ability to work independently or cooperatively in a team and ability to grasp quickly.

TECHNICAL SKILLS

Tools: & Utilities: Teradata utilities Bteq, Fast load, TPT, Mload Data stageParallel Extender and Server Jobs.

Reporting Tools: Micro strategy and Business Objects.

Data Modeling: Erwin

DBMS: Netezza, Oracle 10g/9i/8i/12g, Teradata 15.10/16.20

Operating Systems: UNIX, Red Hat Linux.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Programming analyst

Responsibilities:

• Involved in EDW production support. Worked actively on Business raised incidents and closed around 1100 incidents in last one year without breaching SLA’s.
• Automated creating UNICA offers using create offer API in mulesoft.
• Designing and developing Data stage jobs to load the files into staging layer after performing various data validations and developed Bteqs and fast exports to load reporting data.
• Developed Audit jobs to compare sales from SAP to EDW reports.
• Lead team to migrate entire EDW platform from Teradata version 15.10 to Teradata 16.20 without impacting business.
• Complete and solo responsible for migrating Oracle platform version 11 to 12g successfully without any issues on day of migration.
• Worked closely with SAP team to implement business logic for reporting on Sales orders, purchase orders, and inventory reporting and reports with respective sales. (Good Knowledge in SAP)
• Worked on Incident (Failures/Missing or Invalid Data, Delayed data), Problem (Repeated incidences not permanently fixed) & Change management (Bug/Break Fixes; Enhancements)
• Monitoring and reporting on SLAs and data availability Load
• Monitoring ETL load failures due to resource constraints, missing/invalid data/files, Bugs and infrastructure component issues
• Guiding other team members in creating the required components to build the application.
• Interacting with Offshore to help them understand the design and build the application.
• Perform Unit testing and support User Acceptance Testing.
• Analyze and fix any bugs raised during UAT.
• Worked on Performance tuning the application.
• Worked on Batch Dependency and created the dependencies for the jobs and helped scheduling team in creating the batch.

Environment: Data stage11.3, Oracle 12g, Teradata 16.20, Micro strategy, UNIX scripting, Control-M Scheduling and programming.

Confidential

Data Warehousing Specialist

Responsibilities:

• Creating design documents as per the requirements.
• Working with Analysts to finalize the design and creating the required tables.
• Creating UNIX shell scripts to modify the input files.
• Designing and developing Data stage jobs to load the files into staging layer after performing various data validations.
• Designing data stage Jobs to load Reporting Tables.
• Worked on Incident (Failures/Missing or Invalid Data, Delayed data), Problem (Repeated incidences not permanently fixed) & Change management (Bug/Break Fixes; Enhancements)
• Monitoring and reporting on SLAs and data availability Load
• Monitoring ETL load failures due to resource constraints, missing/invalid data/files, Bugs and infrastructure component issues
• Creating oracle store procedures.
• Guiding other team members in creating the required components to build the application.
• Interacting with Offshore to help them understand the design and build the application.
• Perform Unit testing and support User Acceptance Testing.
• Analyze and fix any bugs raised during UAT.
• Worked on Performance tuning the application.
• Worked on Batch Dependency and created the dependencies for the jobs and helped scheduling team in creating the batch.

Environment: Data stage, DB2, Oracle, Teradata, Micro strategy, Business Objects, UNIX scripting, Control-M Scheduling and programming.

Confidential

Lead Technologist

Responsibilities:

• Prepared technical specification documents for the Jobs and their reviews.
• Involved in development phase meetings for Business Analysis and requirements document reviews.
• Maintaining the support matrix and Updating the Remedy ticket for analysis purpose.
• Lead a team of 50 members involved in the migration to Teradata from Netezza.Provided Technical solutions for various teams, playing a role of Technical Architect and been a part of code review team.
• Incident (Failures/Missing or Invalid Data, Delayed data), Problem (Repeated incidences not permanently fixed) & Change management (Bug/Break Fixes; Enhancements)
• Monitoring and reporting on SLAs and data availability Load
• ETL load failures due to resource constraints, missing/invalid data/files, Bugs and infrastructure component issues
• Prepared Technical Specification Documents for the Jobs and their reviews.Building the SQL queries as per the business requirement and build the logic in the DataStage for further processing and loaded into Teradata.
• Gap Analysis and fulfillment.QA. Production implementation and release of application. Formulating value propositions, mission statements, critical success factors, and statements of work.
• Create Design Specification for BI applications. Navigational attribute specifications, Target Table Structures, Source Target Mapping, Data Flow Diagrams and Modeling, Report TemplatesWritten automated shell scripts to covert the NZ code to TD code which has been used across all the projects in the company.
• Monitored different teams at time to make sure all the teams were on the same page during migration to avoid last minute surprises, and to make sure the no issues for downstream projects.

Environment: DataStage 8.1(EE) Parallel Extender, Netezza, Oracle, Teradata, Micro strategy, Business Objects, UNIX scripting, Control-M Scheduling and programming.