SQL developer Resume

SUMMARY:

10 years of professional IT experience in analyzing requirements, designing, building, highly distributed mission critical products and Applications.
Worked as an ETL Developer and SQL developer as a SAP - BODS Technical Consultant using Business Objects Data Integration Data Services(BODI/DS 3.2, 4.0 and 4.2)
Expert in Data Extraction, Transforming and Loading (ETL) using Business Objects Data Integrator XI (BODI), Data-services xi3.2, 4.0(BODS) and Business Objects Web intelligence reporting.
Implementing RFC connection and them to interact with SAP systems.
Implementing ABAP data flows in SAP BODS to extract the data from SAP ECC system.
Implemented Slowly Changing Dimension - Type 2 (SCD - Type 2) for the required dimensions by using TABLE COMPARIOSN Transform, HISTORY PRESERVING Transform and KEY GENERATION Transform
Used the LOOKUP EXT functions to derive the columns in BODS ETL by look upping the values in lookup table of type validity tables
Experience in debugging execution errors using Data Services logs (Trace, Statistics, and Error).
Tested data flows and scripts against sample data and real data.
Worked with End-To-End implementation with Data warehousing team and Strong understanding of Data warehouse concepts Star Schema, Snowflake Schemas and Multi-Dimensional Models for query and analysis requirements.
Experience in Automation of jobs through Management console & creating Batch jobs based on Client requirement.
Configuration of Local Repository for each application Environment.
Working knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development, Project Management and Testing.
Knowledge on developing logical and physical schema of the database using data modeling.
Experienced with SQL queries, views and stored procedures
Extensively worked on Metadata management for user provided files.
Knowledge on Repository Manager Configuration, Job Server configuration, Management Console.
Experience in Requirement gathering, Fit-Gap analysis, Blueprinting, build, Configuration, Testing, cutover and Go-live activities for data migration.
Experience in Release management process including development, testing and production.
Worked on SAP BODS Information Steward like creating the rules, binding rules, score card setup and data profiling.
Worked in preparing technical documents like Data Mapping Document and Unit testing evidence documents.
Worked on validations on preproduction and production deployments.
Troubleshoot failed jobs in Preproduction and production environments
Communicate and Co-ordinate with Offshore

TECHNICAL SKILLS:

ETL Tools: Business Objects Data Services XI 3.2/4.0/4.2

ERP: SAP R/3 (4.6 C/4.7), ECC 5.0, ECC 6.0 SAP S/4 HANA

Databases: SAP HANA, Teradata, Oracle 10g, SQL Server 2005/2008.

Reporting: SAP Business Objects, Web I report

Languages and Others: SQL, Big Data Tools HADOOP HDFS, Map Reduce, PIG SQOOP and BPM tool PEGA

Operating System: MS-Dos, Windows 9X, Advanced 200X Server and Linux

Packages/Tools: Remedy, HPQC

Programming Languages: C, C++, Java, SQL,PL SQL

PROFESSIONAL EXPERIENCE:

Confidential

SQL developer

Responsibilities:

Implementing ABAP data flows in SAP BODS to extract the data from SAP ECC system.
Implemented Slowly Changing Dimension - Type 2 (SCD - Type 2) for the required dimensions by using TABLE COMPARIOSN Transform, HISTORY PRESERVING Transform and KEY GENERATION Transform
Used the LOOKUP EXT functions to derive the columns in BODS ETL by look upping the values in lookup table of type validity tables
Experience in debugging execution errors using Data Services logs (Trace, Statistics, and Error).
Tested data flows and scripts against sample data and real data.
Worked with End-To-End implementation with Data warehousing team and Strong understanding of Data warehouse concepts Star Schema, Snowflake Schemas and Multi-Dimensional Models for query and analysis requirements.
Experience in Automation of jobs through Management console & creating Batch jobs based on Client requirement.
Configuration of Local Repository for each application Environment.
Working knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development, Project Management and Testing.
Knowledge on developing logical and physical schema of the database using data modeling.
Experienced with SQL queries, views and stored procedures
Extensively worked on Metadata management for user provided files.
Knowledge on Repository Manager Configuration, Job Server configuration, Management Console.
Experience in Requirement gathering, Fit-Gap analysis, Blueprinting, build, Configuration, Testing, cutover and Go-live activities for data migration.
Experience in Release management process including development, testing and production.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship