SUMMARY

• Senior DW Consultant with 7 years of IT experience in analysis, design, development, testing, implementation and support on Data warehousing.
• Experience working in various domains like Health Insurance, Travel and Hospitality
• Extensive experience working in projects demanding leadership and management skills that include onshore and offshore Team Management, Support Process setup, Mentoring team members and proactive customer communication.
• Extensive experience and very good skills in SQL, PL/SQL, Oracle, SQL server, Unix Shell Scripts, Data Modeling, Data Warehousing strategies, IBM DataStage, Informatica.
• Experience in Data Warehousing Star / Snowflake Schema Design, Requirement Analysis, User Interaction, Logical and Physical database design, Strong Backend Development, Exposure and experience with various ETL tools.
• Area of expertise encompasses Data Model, ETL phases of Data Warehousing. This is achieved with an emphasis on relational data modeling and dimensional data modeling for OLTP and OLAP systems
• Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse
• Extensive experience working in full Software Development Lifecycle (SDLC waterfall) and Agile methodology.
• Strong experience in requirements analysis to identify requirements and helping create Requirement traceability matrix
• ETL experience ranging from debugging, and production support, to setup, maintenance, and debugging, version control, software and license installation.
• Worked extensively with Dimensional modeling, Data migration, Data cleansing, ETL Processes for data warehouses.
• Scheduling the jobs using Autosys,TWS,Control M, crontab in UNIX.
• Export & Import, Performance Tuning of DataStage, Backup and Recovery
• Handled data extraction from multiple source platforms - Flat files, Oracle, DB2, and Teradata.
• Experience in UNIX shell scripting.
• Experience in SQL scripting for creating the table structures and Ad Hoc reporting.
• Performed Testing, Debugging and Performance tuning of SQL, targets, sources and transformation logics and implemented Error Handling Concepts.
• Expertise in doing the Root Cause Analysis and resolving performance bottlenecks and performed enhancements for optimization of the mappings, workflows and server loads.
• Involved in Unit Testing of DataStage Jobs and integration testing in pre-production environment.
• Good knowledge of Hadoop ecosystem, HDFS, SPARK, SCALA.
• Good understanding of HADOOP architecture and the daemons of Hadoop including Name-Node, Data Node, Job Tracker, Task Tracker, Resource Manager.
• Hands on Experience in analyzing data using HIVE.
• Have good Analytical and Problem Solving skills and Excellent Communication and Interpersonal Skills, ability to understand and adapt to new technologies and environments faster.
• Proven ability to work independently as well as in a team

TECHNICAL SKILLS

ETL Tools: IBM DataStage (8.x/7.x) Enterprise Edition/Parallel Extender, Informatica 7.x/8.6

Databases: Oracle, SQL Server, DB2/UDB, MS/Access, Teradata

OS: UNIX (AIX), Linux, MS DOS, Windows NT/2000/XP

Languages: C, JAVA,SQL, PL/SQL, UNIX Shell programming

Scheduling Tools: Autosys, UNIX Cron job,TWS,Control M

Other: HIVE, Tableau

PROFESSIONAL EXPERIENCE

Confidential

DB/DW Developer

Responsibilities:

• Acted as a lead in providing application design guidance and consultation, utilizing a thorough understanding of applicable technology, tools and existing designs.
• Understanding of Omniture data and Booking data which is the most critical area of HCOM
• Created DB2 Sprocs and worked on Informatica and Control M jobs.
• Worked on HIVE while analyzing the data in HADOOP environment.
• Process Improvement: Modified and developed sprocs to meet the SLA and user requirements.
• Performance Improvement: Worked on complex SQL query tuning used query plans.
• Established customer confidence by producing speedy solutions, Utilize in-depth knowledge of functional and technical experience on project in conjunction with industry and business skills to deliver solutions to customer.
• Also worked in DevOps to provide support for same project, handling tickets and worked on Agile Technology.
• Involved in regular interaction with On-site team.
• Created SQL Scripts to create the table structures in the database and also writing complex SQL for ETL and Ad hoc reporting.
• Assured quality, security and compliance requirements are met for supported area and oversee creation of or updates to and testing of the business continuation plan.
• Good knowledge of Hadoop architecture and its components like HDFS, MapReduce, Job Tracker, Task Tracker, Name Node and Data Node.
• Worked extensively with Control M jobs including scheduling, updating scripts, variables and dependencies.
• Extensively worked with Oracle SQL analytical functions including PIVOT, RANK, NVL etc.
• Created documents of understanding such as the process flow document and recovery document for the production support team.
• Lead projects, allocated and managed resources and managed the work of less experienced staff.
• Hands on experience in reporting tools like Tableau
• Improved quality by performing root cause resolution for defects found
• Creating SQL Scripts to create the table structures in the database and also writing complex SQL for ETL and Ad hoc reporting.
• Used coding standards and performance tuning to fine tune the process and meet the SLA.
• Acted as an expert technical resource for modeling, simulation and analysis efforts.

Environment: Informatica, DB2, SQL, PL/SQL, UNIX Shell Scripts, Control M, Tableau, HIVEUnited Health Group

IT Analytics Analyst

Confidential

Responsibilities:

• Created documents of understanding (DOU) which included Business requirements specification, functional specifications, mapping details, job design and support information.
• Worked closely with data modelers and SMEs to help in the design of schemas and tables including SCDs.
• Managed multiple projects, conducted onshore-offshore team meetings on a regular basis, prioritized and assigned tasks to the team and re-prioritized as necessary to meet key deadlines.
• Guided the team to achieve customer SLA including reduction of incidents, on-time completion of key deliverables and reduction of problem records, on-time completion service requests and proactive communication to stakeholders.
• Mentored team members by providing technical and soft skill trainings, induction and guidance.
• Built relationships and partnerships with cross functional teams, worked with multiple teams to complete enhancements and requests on time with good quality.
• Developed UNIX wrapper scripts to initialize variables, run graphs, perform error handling and notify users automatically in case of any failures with debugging information.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data to targets.
• Configured File for Parallel extender as per number of processors available to process the data by using DataStage Manager.
• Validating the control totals for before and after processing the files.
• Validating the different business rules for validation of fields.
• Responsible for developing the process & testing as it pertains to data flow for the interfaces.
• Used DataStage Designer to develop multiple processing jobs to read data from CPF and load into Oracle. Used DataStage Manager for import/export jobs, metadata from one project to another project.
• Designed DataStage jobs to code to read the data from source databases/flat files and load them to the target Oracle ODS tables.
• Extensively worked with Parallel Extender/Enterprise Edition (EE) using Parallel Processing (Pipeline and partition parallelism) techniques to improve job performance while working with bulk data sources.
• Created SQL Scripts to create the table structures in the database and also involved in writing complex SQL for ETL and Ad hoc reporting.
• Used different types of Stages like Sequential File, Lookup stage, Transformer, Change capture, Remove Duplicates, External source, XML input/output, Funnel, Sort, Aggregator, and ODBC for developing different Jobs.
• Used DataStage Director to Run and Monitor the Jobs performed, automation of Job Control using Batch logic to execute and schedule various DataStage jobs.
• Used PL/SQL languages for writing stored procedures and functions and were called in DataStage Jobs.
• Coordinated with team members at times of change in Business requirements and change in design.
• Used DataStage Sequencer to run jobs in sequence.
• Used Autosys to trigger the jobs on a daily basis.
• Developed UNIX shell scripts for scheduling the jobs and for automation of loading processes.
• Participated in the system testing and unit testing.
• Performance tuning and Enhancement
• Resolution of user tickets and Batch failure tickets on time.
• Incident Management and Problem Management
• High Severity Communication
• Resolution of High severity tickets on time
• Batch Monitoring/ Issue resolution and Bug fixes.
• Preparing Weekly/Monthly reports
• Production support and maintaineance for the all applications owned.
• Responsible for Documenting and support maintenance.
• Received Certificate of Appreciation & STAR of the Quarter award for improving business process by automating most critical process of the project, which saved the effort of 176 hours per year worth $13,552.

Environment: IBM DataStage 8.5, Oracle, SQL, PL/SQL, UNIX Shell Scripts, Autosys, UNIX-AIX, Windows XP.

Confidential

Responsibilities:

• Involved in analyzing the system and gathering the requirements.
• Worked with the project and business teams to understand the business processes involved.
• Worked with the Solution Architect in designing the Data Model.
• Responsible for developing the process & testing as it pertains to data flow for the interfaces.
• Used DataStage Designer to develop multiple processing jobs to read sequential files and load into Oracle. Used DataStage Manager for import/export jobs, metadata from one project to another project.
• Extensively worked with Parallel Extender/Enterprise Edition (EE) using Parallel Processing (Pipeline and partition parallelism) techniques to improve job performance while working with bulk data sources.
• Extensively worked on Unix Shell scripts to extract/load data from/to SFTP server.
• Used different types of Stages like Sequential File, Lookup stage, Transformer, Change capture, Remove Duplicates, External source, XML input/output, Funnel, Sort, Aggregator, and ODBC for developing different Jobs.
• Used DataStage Director to Run and Monitor the Jobs performed, automation of Job Control using Batch logic to execute and schedule various DataStage jobs.
• Creating SQL Scripts to create the table structures in the database and also writing complex SQL for ETL and Ad hoc reporting.
• Used PL/SQL languages for writing stored procedures and functions and were called in DataStage Jobs.
• Configured File for Parallel extender as per number of processors available to process the data by using DataStage Manager.
• Delegating the work to the other resources.
• Coordinated with team members at times of change in Business requirements and change in design.
• Used DataStage Sequencer to run jobs in sequence.
• Developed UNIX shell scripts for scheduling the jobs and for automation of loading processes.
• Participated in the system testing and unit testing.
• Production support and Maintenance for the all applications owned.
• Responsible for Documenting and support maintenance.

Environment: IBM DataStage 8.1, Oracle, SQL, PL/SQL, UNIX Shell Scripts, UNIX-AIX, Windows XP.

Confidential

Responsibilities:

• Involved in analyzing the system and gathering the requirements.
• Worked with the project and business teams to understand the business processes involved.
• Worked with the Solution Architect in designing the Data Model.
• Responsible for developing the process & testing as it pertains to data flow for the interfaces.
• Extensively worked on Unix Shell scripts to extract/load data from/to SFTP server.
• Used different types of Stages like Sequential File, Lookup stage, Transformer, Change capture, Remove Duplicates, External source, XML input/output, Funnel, Sort, Aggregator, and ODBC for developing different Jobs.
• Used PL/SQL languages for writing stored procedures and functions and were called in DataStage Jobs.
• Used DataStage Director to Run and Monitor the Jobs performed, automation of Job Control using Batch logic to execute and schedule various DataStage jobs.
• Participated in the system testing and unit testing.
• Production support and Maintained for the all applications owned.
• Responsible for Documenting and support maintenance.

Environment: IBM DataStage 8.1, Oracle, SQL, PL/SQL, UNIX Shell Scripts, UNIX-AIX, Windows XP.

Confidential

Application Developer

Responsibilities:

• Involved in analyzing the system and gathering the requirements.
• Involved in development, maintenance, enhancements and bug fixing.
• Involved in Developing and integrating the user interface using .NET framework with middleware components.
• Developed the business logic in middleware components using C# and SQL queries and also code review
• Worked with the project and business teams to understand the business processes involved.
• Responsible for developing the process & testing as it pertains to data flow for the interfaces.
• Coordinated with team members at times of change in Business requirements and change in design.
• Participated in the system testing and unit testing..
• Responsible for Documenting and support maintenance.

Environment: Net Framework 3.5, ASP .NET, C#, Oracle