SUMMARY

• Technically sophisticated engineering professional with over 14+ years of experience designing, developing and implementing data warehousing solutions using IBM Info Sphere Data StageV.11.7, Pentaho PDI, Teradata, SAP HANA and Tableau.
• Broad knowledge and experience in analyzing and documenting the enterprise structure including logical organization of business strategies, metrics, business capabilities, processes, information resources, business systems and infrastructure.
• Success developing and delivering large scale projects within agile and waterfall project development methodologies.
• Expertise in developing data modelling, data integration, data management and business intelligence solutions.
• Hands on in ERWIN in creating Schemas, building logical and physical models.
• Worked on upgrade projects, which involve migration from Pentaho PDI to Data Stage 11.7 version and from Oracle 11g to SAP HANA Teradata.
• Extensively involved in the development of Data stage ETL Parallel jobs for extracting data from different data sources, data transformation and loading the data into data warehouse for data mart operations.
• Have 12 years of in - depth experience in Extraction Transformation and Loading (ETL) processes using IBM Info sphere Information server Data Stage 11.3, 8.5, 8.0.x (Parallel Extender), Oracle, Teradata, autosys, TWS(Tivoli) and Control-m.
• Knowledge on Fuzzy matching algorithms using ETL tools like snap logic.
• Deep expertise in Data Modeling, Data Integration, Metadata Management and BI.
• Ability to use business knowledge to proactively identifying, evaluate and recommend appropriate and relevant solutions, actions and outcomes.
• Extensive knowledge as BI and report developer using various tools like COGNOS 10BI and Tableau.
• Expertise in ETL/ELT and data warehouse concepts with Data Vault 2.0 methodology.
• Experience with multiple SDLC methodologies - Waterfall and Agile.

TECHNICAL SKILLS

ETL Tools: Data Stage 7.5/8.1/8.7/11.7, Pentaho Data Integration

Reporting Tools: Tableau V8.2, Cognos 10BI

Data Modelling Tools: IBM Info sphere Data Architect V9.1, Erwin Data Modeler 7.3

Databases: SAP HANA, Teradata, Oracle 10g.

Operating Systems: Windows, Unix.

Scheduling Tools: Autosys, Zeke Scheduler

Others: Mainframe ISPF 5.7, JCL, Cosort, Unix Shell Scripts, SQL Script, C#, ADO.NET, ASP.NET, XML, WPF, Python, SAP Basis R/3, SAP HANA. Knowledge on IoT(Internet of things)Arduino, Raspberry Pi-3, Gprs Module sim900

PROFESSIONAL EXPERIENCE

ETL Lead / Data stage Developer

Confidential, Irving, Texas

Responsibilities:

• Develop and test ETL DS jobs to load the Aspect VIA (Cloud) data to seed the data mart tables (Netezza) for Customer 360 View.
• Involved in ETL migration project, Conversion of SSIS packages into Data stage jobs.
• Perform unit testing and peer reviews to ensure the quality of deliverables.
• Resolution of IA incidents and the implementation of IA Change Requests logged by the Business Readiness Functional leads.
• Developed ETL Jobs using data stage to load facts and dimensions for customer 360View as per the business logic.
• Involved in Data Modeling, Data Integration and Metadata Management for Customer 360.
• Created logical model and physical model using IBM Info Sphere Data Architect.
• Designed and developed SCD Type 1 and Type 2 ETL jobs for Aspect VIA modules.

Environment: IBM Info sphere Data stage V11.5, Netezza

Senior Systems Analyst /ETL Lead

Confidential

Responsibilities:

• Engage with Business Readiness Functional leads to understand DQ requirements, raise any issues or misunderstandings about the requirements.
• Planning, designing, developing, testing and documenting computer programs.
• Converting project specifications into detailed instructions and logical steps for coding into languages processed by computers.
• Active involvement in requirements gathering and implementing required features according to software design specifications.
• Providing design and technical consulting expertise for new or existing projects.
• Actively participate on the team responsible for development of data mart to support internal business processes in Confidential .
• Work with data architect, ETL developers and DBA to identify the source data and load the from source systems to help development and testing
• Develop and test ETL scripts to load the historical data to seed the data mart tables for testing, dry runs and production migrations from ETL data stage version 9.1 to DS 11.7.
• Work with data architect and developers to design efficient ETL jobs using intermediate tables
• Performance tuning of PL SQL and ETL jobs
• Develop data replication and ETL jobs using RDBMS database.
• Optimization Sprints.
• Delivering views as APIs.
• Data Integration and Synchronization using IBM Infosphere Datastage/ Mainframe/Teradata and Oracle Data Integrator.
• Provide Technical IA guidance and support to Business Readiness Functional leads when required.
• Translation of Global and Regional DQI's into a Technical Specification
• Ensure assigned IA deliverables are completed according to plan and adhering to acceptable levels of quality.
• Resolution of IA incidents and the implementation of IA Change Requests logged by the Business Readiness Functional leads.
• Developing ETL Data stage jobs as per the Technical Mapping document received from DICOE Confidential .
• Involved in ETL migration project, Conversion of ETL Online ( Confidential Tool) to IBM Info Sphere Data stage.
• Created logical model and physical model using IBM Info Sphere Data Architect.
• Writing service methods and SQL queries such as PL/SQL as part of the mapping technique to obtain data from database.
• Compiling and documentation of program development and subsequent revisions.
• Correcting program errors using methods such as modifying program or altering sequence of program steps.
• Analyzing, reviewing and rewriting programs to increase operating efficiency or to adapt programs to new requirements.
• Ensure assigned IA deliverables are completed according to plan and adhering to acceptable levels of quality.
• Engaging with the Data Migration resources responsible for loading the data to ensure that reference and test data are loaded.
• Identifies common objectives and links them to clear measurement metrics in order to evaluate supplier performance and set improvement targets.
• Ensure assigned IA deliverables are completed according to plan and adhering to acceptable levels of quality.

Environment: IBM Info sphere Data stage V11.7, Oracle 12c, Teradata

Technical ETL Lead/BI Developer

Confidential

Responsibilities:

• Engage with Business Readiness Functional leads to understand DQ requirements, raise any issues or misunderstandings about the requirements.
• Developed Pentaho ETL code based on the business mapping and performed unit testing for LSG modules.
• Involved in ETL migration project, Conversion of Data stage jobs to pentaho and pentaho to python scripts.
• Re-loaded Tier 2 migration - Phase II testing (Oracle SQL Scripts into ETL Pentaho transformations.)
• Designed and developed SCD Type 1 and Type 2 ETL jobs for sales and marketing subject areas.
• Migrations of PUAT tables to LSG environment using Pentaho data integration.
• Involved in Migration of Cola reporting to LSG tables (Pentaho ETL).
• Developed attribute views, Analytical views, calculation views, procedures and created Modified analytic privileges.
• Developed ETL Jobs using datastage to load facts and dimensions as per the business logic.
• Developed calculation views with cube star join for performance tuning.
• Hands on creating variables, input parameters, calculated columns in HANA Studio.
• Worked on Creating Universe on Analytical and Calculation views
• Creating Delivery units and importing them into systems.
• Using Unions, projections and aggregation in the Graphical Calculation Views to union, filter and aggregate columns of the calculation views
• Worked on import and export functionalities to get models and files (csv) to studio for views.
• Create Measures using SUM, MIN, MAX, and COUNT.
• Expert in writing stored procedures.
• Creating the datastore between the source systems and target systems. creating the database creation, repository creation, job server creation, project, Workflows, Dataflow, Jobs,
• Creating the transformations as per the requirement.
• Coordinated on loading data toSAPHANAfrom different source systems using SLT for Real-Time.
• Performed scrum master activities to organize sprints and releases with the Dev and Ops team.

Environment: IBM Info sphere Data stage V11.7, Pentaho PDI, Oracle 11g, SAP HANA, Python, Tableau

Data Specialist/ ETL Lead

Confidential

Responsibilities:

• Engage with Business Readiness Functional leads to understand DQ requirements, raise any issues or misunderstandings about the requirements.
• Provide Technical IA guidance and support to Business Readiness Functional leads when required.
• Translation of Global and Regional DQI's into a Technical Specification
• Develop assigned IA deliverables according defined architecture and design.
• Ensure assigned IA deliverables are completed according to plan and adhering to acceptable levels of quality.
• Perform unit testing and peer reviews to ensure the quality of deliverables.
• Resolution of IA incidents and the implementation of IA Change Requests logged by the Business Readiness Functional leads.
• Knowledge transfer of IA deliverables to the IA support team.
• Engaging with the Data Migration resources responsible for loading the data to ensure that reference and test data are loaded.
• Engaging with Data Migration resources to understand the staging tables and migration of stating tables to the test environment.
• Attending progress and team meetings to report on progress, issues or risks.
• Identifies common objectives and links them to clear measurement metrics in order to evaluate supplier performance and set improvement targets.
• Experience with multiple SDLC methodologies - Waterfall and Agile.

Environment: IBM Info sphere Data stage V8.7, IBM Info Sphere Information Analyzer, Oracle 11g

Data Specialist / ETL Lead

Confidential

Responsibilities:

• Developed ETL Data stage jobs as per the Technical Mapping document received from DICOE Confidential .
• Performed Unit testing for ETL data stage jobs as per the technical mapping document.
• Involved in ETL migration project, Conversion of ETL Online ( Confidential Tool) to IBM Info Sphere Data stage.
• Created logical model and physical model using IBM Info Sphere Data Architect.
• Created Data Modeling objects using existing DDL’s from SAP tables and vice versa.
• Involved in end-to-end system testing of ETL projects.
• Worked with the Platform Solutions Manager and Project Managers to evaluate product-enabling technologies.
• Identify, assess and manage risks to the success of the project.
• Ensure Quality dependencies (within program/critical path).
• Utilized IBM metrics and data for continuous improvement reviews occur within given timeframes and according to procedure.
• Establish and manage temporary Program Management Offices (PMO) and the associated processes and procedures for risks, issues, changes, quality and cost management.
• Ensure dependencies include interdependencies (other programs) and intra-
• Establish and maintain a fully auditable communications log during the various project phases.

Environment: Info sphere - Data stage 8.5, Oracle 11g, Teradata

Data Specialist / ETL Lead

Confidential

Responsibilities:

• Module lead for Development team and involved in testing activities along with the testing team.
• Developed ETL Data stage jobs as per the Technical Mapping document received from GEO - Confidential team.
• Developed and delivered ETL jobs on time, as per the schedule provided by the GEO -Development work request document.
• Communicating to Confidential GEO team, regarding Development deliverables and maintaining issue logs as per the GD & GEO process.
• Performed Unit testing for ETL data stage jobs as per the technical mapping document.
• Involved in manual testing by preparing test cases, expected results and sample data as per Testing - Work request document send by GEO team.
• Performed test execution for Connector IN project, by executing the Confidential - Run Connector Shell scripts and validating the output results.
• Validating the expected and Actual testing results as per the Confidential standards.

Environment: Info sphere - Data stage 7.5, Oracle 10g

Data Specialist / ETL Lead

Confidential

Responsibilities:

• Modification on mainframe JCL is as per the project specification during migration activities.
• Capturing the discrepancies in both data stage 7.5 and data stage 8.1 by validating the data using CDC data stage jobs.
• Performed Unit testing of ETL data stage jobs and mainframe JCLs using RBCI standard template.
• Created Technical design document for RBCI enhancement projects.
• Completed Data stage migration jobs from DS 7.5 to DS 8.1.

Environment: Info sphere - Data stage 8.1, Oracle 10g

Data Specialist / ETL Designer

Confidential

Responsibilities:

• Used ETL tool IBM Web Sphere Data Stage V.8.0 for Extraction, Transformation and Loading data into BIH (Landing Area).
• Involved in creating the data stage parallel jobs and Unix Shell scripts based on mapping document.
• Used tools Data stage 8.1, Oracle 10g and Sun Os.
• Reviews of jobs, Unit testing.
• Analyzing the log files and bugs verifying.

Environment: Info sphere - Data stage 8.1, Oracle 10g

Data Stage / ETL Developer

Confidential, Wisconsin - Milwaukee

Responsibilities:

• Used ETL tool IBM Web sphere Data stage V.8.0 for Extraction, Transformation and Loading data into data warehouse.
• Involved in creating the data stage Mainframe jobs and Unix Shell scripts based Change request document.
• Used tools Data stage 8, Cognos 8, Margin Minder, Eureka strategy, Business Objects XI.
• Used DB2 as database with source coming from Mainframe and target as Teradata and SQL Server.
• Received E-Award from hp for creating an automation script and team management skills.
• Involved in monitoring activities like Data stage mainframe jobs, Server Jobs that is running on zeke scheduler and Solving Severity tickets like Sev 1, Sev 2 and Sev 3 with in the set timeline.
• Conducted Technical trainings to the team members as data stage track lead.

Environment: Info sphere - Data stage 8, Cognos 8, Teradata, DB2 8

Data Stage / ETL Developer

Confidential

Responsibilities:

• Involved in moving the data from Source to staging and from staging to target.
• Involved in creating the jobs based on mapping Document.
• Involved in loading dimensions and facts based on mapping design document.
• Used ETL tool IBM Web Sphere Data Stage V.7.5 for Extraction, Transformation and Loading data into data warehouse.
• Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms with invoker’s privileges.
• Developed UNIX scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes.
• Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms with invoker’s privileges.

Environment: Info sphere - Data stage 7.5, Oracle 10g, Cognos 8

Data Stage / ETL Developer

Confidential

Responsibilities:

• Used ETL tool Ascential data stage PX 7.5 for Extraction, Transformation and Loading data into data warehouse.
• Writing technical specification and estimation.
• Developing objects using appropriate Data stage Parallel job stages.
• Reviews of jobs, Unit testing, analyzing the log files and verifying bugs.

Environment: Info sphere - Data stage 7.5, Oracle 10g, Cognos 8

Software Engineer

Confidential

Responsibilities:

• Design, develop, implement, and assist and in validating ETL processes.
• Reviews of jobs, Unit testing.
• Analyzing the log files and bugs verifying.
• Writing technical specification and estimation.
• Testing Data stage Jobs.
• Checking the log files for bugs.

Environment: Info sphere - Data stage 7.1, SAP BI, Oracle 10g