We provide IT Staff Augmentation Services!

Sr Consultant Resume

PROFESSIONAL SUMMARY:

  • Having 10 Years of Extensive and Varied Experience in the design and development of IT related business applications
  • Involved in analysis, design, development and implementation of Business Intelligence Applications using Data Stage.
  • Having good knowledge on Hadoop, HDFS, HIVE, SQOOP
  • Extensive Knowledge in all components of Data Stage.
  • Used Data Stage 7.5x2, Datastage8.1, Datastage8.5, Datastage8.7, Datastage9.1, Datastage9.7 and Data stage 11.3 as an ETL tool to extract data from source, Mappings, Transformations.
  • Experience in Installation, development and administration of Data Stage
  • Performed administration tasks like role setup, connectivity, security, configuration of projects, user registries, create or update users and groups, mapping credentials, configuring DSN and TNS entries, parallel, compiler, reporting, operator and user - defined environment variables.
  • Acquainted in Parallel Jobs processing.
  • Having good knowledge on SQL.
  • Strong in UNIX. Extensively used UNIX scripts for scheduling the jobs
  • Having Knowledge on other ETL tools Informatica
  • Worked on tools like DB2 Control center, Oracle Toad, Teradata SQL Assistant
  • Having good knowledge on Scheduling Tool Control-M
  • Well acquainted and has broad understanding of Software development life cycle
  • Good at requirement gathering and interaction with clients
  • Good at leading the team and project management activities
  • Experienced in deliveries using Agile Scrum methodology
  • Involved in performance tuning of Data Stage jobs.
  • Maintained best practices.
  • Possess excellent analytical and communication skills
  • Expertise in handling the clients.
  • Worked as Onsite Coordinator in UK for Confidential .

TECHNICAL SKILLS:

Tools: Data Stage 11.3,9.7,8.7,8.5,8.1,7.5, Informatica, Cognos

Databases: Oracle, DB2,Teradata

Languages: C, C++, SQL

Operating Systems: Windows, UNIX, Linux

Big Data: Hadoop, HDFS, Hive, Sqoop, Control-M, Autosys, Teradata SQL Assistant, Toad

PROFESSIONAL EXPERIENCE:

Confidential

Sr Consultant

Technology/Software: Data Stage 11.3, Teradata, Netezza, Oracle, HDFS, Hive

Responsibilities:

  • Analysis of the specifications provided by the client.
  • Involved in Preparation of Low Level Design Documents.
  • Used Data Stage Designer to develop process for extracting, cleansing, transforming, integrating and loading the data into the Warehouse.
  • Passed values by loading parameters through Parameter set.
  • Used Data stage director and its run-time engine for debugging its components.
  • Adhered to Quality procedures related to the project.
  • Used DataStage Designer for Exporting and importing the jobs.
  • Handled the critical issues and used multiple instance jobs extensively by passing parameters.
  • Written queries to check whether data has satisfied the business rules or not.
  • Used stages like Join, Lookup, Sort, Column import, dataset, sequential file, Transformer stage …..
  • Involved in loading data for User acceptance test, debugged jobs which does not satisfy business rules.
  • Involved in creation of Hive tables with partitions
  • Involved in creation of Hive queries for transforming the business rules
  • Involved in Unit Testing.
  • Analyzed change request and developed the changes required.
  • Frequent interaction with client on discussing business.

Confidential

Sr Consultant

Technology/Software: Data Stage 11.3, Teradata, Control-M, Hdfs, Hive, Sqoop

Responsibilities:

  • Involved in business and system requirements sessions
  • Requirements elicitation and translation to technical specifications
  • Provided inputs on solution architecture based on evaluation/understanding of solution alternatives, frameworks and products
  • Creating design documents and workflows
  • Design applications based on identified architecture
  • Involved in Daily Status call with client
  • Involved in creation of Hive tables with partitions
  • Involved in creation of Hive queries for transforming the business rules
  • Sqooped the data from different databases
  • Involved in Daily status call with client
  • Responsible for end to end deliverables of CDP

Consultant

Technology/Software: Data Stage 9.1, Oracle 11g, Teradata, Netezza, Linux, Autosys

Responsibilities:

  • Analyze the SLD
  • Development of data stage jobs using Data Stage Designer
  • Used the Teradata SQL Assistant to fetch data from Teradata database
  • Used Toad for fetching data from Oracle database
  • Involved in Unit testing and System testing
  • Involved in Migration of Jobs from Dev Environment to Testing Environment
  • Involved in Daily Status call with client
  • Used Datastage director to run and monitor jobs
  • Used Shared container to reuse the SAP code block data.
Confidential

Consultant

Technology/Software: Data Stage 8.5, Oracle 11g, UNIX

Responsibilities:

  • Business requirement analysis.
  • Involved in preparation of Low Level Design Documents.
  • Used Data Stage Designer to develop process for extracting, cleansing, transforming, integrating and loading the data into the Warehouse.
  • Performance tuning of data stage jobs.
  • Involved in Unit Testing.
  • Daily call with client and onshore team to discuss on day to day status and issues.
Confidential

Consultant

Technology/Software: Data Stage 8.1, Data stage 8.7, Oracle 10g

Responsibilities:

  • Business requirement analysis.
  • Using agile scrum method, partitioned deliverables in to sprints and delivering the sprints on timely manner.
  • Involved in preparation of Low Level Design Documents.
  • Used Data Stage Designer to develop process for extracting, cleansing, transforming, integrating and loading the data into the Warehouse.
  • Performance tuning of data stage jobs.
  • Involved in SIT support, fixed the defects.
  • Supported the onshore team in implementation of the application.
  • So far worked on 48 reference tables.
  • Used Macro for converting the Excel tabs in to individual CSV files.
  • Daily call with client and onshore team to discuss on day to day status and issues.

Consultan Confidential t

Technology/Software: Data Stage 8.1, DB2 9.5

Responsibilities:

  • Business Requirement analysis.
  • Involved in preparation of Low Level Design Documents.
  • Used Data Stage Designer to develop process for extracting, cleansing, transforming, integrating and loading the data into the Warehouse
  • Involved in Unit testing.
  • Involved in UAT support, fixed the defects.
  • Supported the onshore team in implementation of the application.
  • Involved in delivering the chaining and transaction for two regions Malaysia and Taiwan.

Consultant

Technology/Software: Data Stage 8.1, DB2 9.5

Confidential

Responsibilities:

  • Business Requirement analysis.
  • Involved in Functional requirements discussion and developing code to the existing jobs.
  • Involved in Modification of Low Level Design Documents.
  • Involved in assigning the work to the team and responsible for the deliverables to the client.
  • Used Data stage Designer to develop process for extracting, cleansing, transforming, integrating and loading the data into the Warehouse.
  • Passed values by loading parameters through Parameter set.
  • Involved in various Functional requirements like FR3, FR8.
  • Involved extensively in testing.
  • Involved in SIT support, fixed the defects.

Confidential

Sr Software Engineer

Technology/Software: Data Stage 8.1, DB2 9.5

Responsibilities:

  • Analysis of the specifications provided by the client.
  • Involved in Preparation of Low Level Design Documents.
  • Used Data Stage Designer to develop process for extracting, cleansing, transforming, integrating and loading the data into the Warehouse.
  • Passed values by loading parameters through Parameter set.
  • Used Data stage director and its run-time engine for debugging its components.
  • Adhered to Quality procedures related to the project.
  • Used DataStage Designer for Exporting and importing the jobs.
  • Handled the critical issues and used multiple instance jobs extensively by passing parameters.
  • Written queries to check whether data has satisfied the business rules or not.
  • Used stages like Join, Lookup, Sort, Column import, dataset, sequential file, Transformer stage,DB2 Enterprise stage…..
  • Used file pattern reading for reading one lakh files per day.
  • Involved in loading data for User acceptance test, debugged jobs which does not satisfy business rules.
  • Involved in Unit Testing.
  • Analyzed change request and developed the changes required.
  • Frequent interaction with client on discussing business.

Software Engineer.

Technology/Software: Data Stage 7.5x2, DB2.

Responsibilities:

  • Understanding the Business Requirements.
  • Involved in Preparation of Low Level Design Documents.
  • Used Data stage Designer to develop process for extracting, cleansing, transforming, integrating and loading the data into the Warehouse.
  • Passed values by loading parameters through Job properties.
  • Used Data stage director and its run-time engine for debugging its components.
  • Used Data stage Manager to import and export metadata, job categories and data elements.
  • Involved in Unit Testing.
  • Involved in Component Integrating Testing.

Hire Now