Summary:

• ETL /SAP BODS Developer having 8.6 years of IT Experience
• Highly self-motivated and goal-oriented professional committed to pursuing a long-term career inData warehousingSAP Products,Oracle Database Development, Design and Management, Writing SQL, PL/SQL and other administrative tasks, offers 8years track record of demonstrating strong analytical and problem solving skills, computer proficiency and ability to follow through with projects from inception to completion and post production support and enhancements with production database.
• Exceptionally well organized, strong work ethics and willingness to work hard to achieve employer objectives.
• A strong team player with excellent interpersonal and communication skills and ready to take an independent challenge.
• Proven ability to learn quickly and apply new technologies.

Technical Skills

• ETL Tools: Informatica Power Center 7.5, 8.1, 8.3,
• SAP Business Objects Data Services 3.2,4.0,
• KALIDO8.3 , Oracle Data Integrator
• Databases: Oracle 9i, Oracle 10g, Erwin ER Modeling, SAP HANA, SAP ECC 6.0,
• Microsoft SQL server 2000, 2008 ,Sysbase IQ
• Languages / GUI: SQL, PL/SQL
• Other Skill: Good Exposure to Database Administration, Data stage, UNIX, SAP BODS

Experience

Confidential

Designation: ETL DEVELOPER / Lead

DESCRIPTION: Established in Confidential, the company provides CAD, CAM, geospatial information system GIS solutions, EBusiness related services and huge range of IT Products such as Oneview Oil gas, Power Onepoint, so on. These has Unqiue IP for company.The company's subsidiaries include Confidential while the company owns a 50 stake in Confidential as of Confidential, and acquired Confidential. Confidential is also in partnership with Intergraph to market and support its software.

Responsibilities:

• Design the road map to add one more platform SAP HANA to the OneView product.
• Leading team of 3 SAP BODS developers.
• Design ETL Architecture, Audit Control Framework and development scope.
• Mentor junior team members with the assistance of PM/Architect
• Flexible in working under changing and different work settings.
• Maintain high team morale.
• Adhere to company and project standards and guidelines.
• Accurate time accounting and reporting of own work.
• Promptly escalate issues, which affect product delivery and quality that are beyond scope of influence and report same to reporting manager.
• Pay high attention to detail in all work.
• Quality, on time delivery of agreed deliverables
• Good ability to anticipate issues and formulate remedial actions.
• Sometime take multiple assignments.
• Define and Implement unit testing methodologies and frameworks
• If required create complex procedures , functions and calculation Views in SAP HANA

TechnicalEnvironment: SAP BODS 4.0, SAP HANA, Crystal reports, Dashboard, SAP ECC6.0, Oracle Data Integrator, SQL server , Oracle

Confidential

DESCRIPTION: Create a business module using real time reporting tool SAP HANA to reduce the manufacturing time of Airplane.

Responsibilities:

• Leading Design Development of Data services.
• Leading team of 5SAP BODS developers from offshore.
• Leading ETL designing and development.
• Create procedures , functions and calculation Views in SAP HANA as per the requirement
• Use SAP HANA tool for data modeling
• Learning to create Dashboard in SAP HANA.

TechnicalEnvironment: SAP BODS 4.0, SAP HANA, Crystal reports, Dashboard, SAP ECC6.0

Confidential

DESCRIPTION: Analyzing, classifying and converting the data of multiple SAP ECC systems to single SAP ECC system.

Responsibilities:

• Leading Business Process flow.
• Leading Design Development of Data services.
• Leading team of 1SAP BODS developers from offshore.
• Leading ETL designing and development.
• Leading ETL Control Framework Audit and governance framework data modeling.
• Leading Control framework Development and testing.
• Leading PL/SQL procedures to retrieve data from BODS metadata to support the control framework design and architecture.
• Create deliverable documents as per SDLC standard.
• Use the SAP best practices data migration content for Data conversion.

TechnicalEnvironment: SAP BODS 4.0, MS SQL 2008, SAP Best Practices Data Migration

Confidential

DESCRIPTION: Create expense report as per Confidential which needs to be submitted to Confidential.

Responsibilities:

• Leading Business Process flow.
• Leading Design Development of Data services.
• Leading team of 1SAP BODS developers from offshore.
• Leading ETL designing and development.
• LeadingETL Control Framework Audit and governance framework data modeling.
• Leading Control framework Development and testing.
• Leading PL/SQL procedures to retrieve data from BODS metadata to support the control framework design and architecture.
• Create deliverable documents as per SDLC standard.
• Created complex SAP BODS 4.0 jobs to find a golden record for MDM.

TechnicalEnvironment: SAP BODS 4.0, SAP BW, SAP MDM

Confidential

DESCRIPTION: Confidential is a leading global distributor of industrial and specialty chemicals, with an extensive network of over 170 distribution facilities in Confidential region and Confidential, as well as additional sales offices in Confidential. Company wanted to convert their legacy data into SAP ECC 6.0.

Responsibilities:

• Leading Design Development of Data services.
• Leading team of 2SAP BODS developers from offshore.
• Involved in ETL designing and development.
• Involved in ETL Control Framework Audit and governance framework data modeling.
• Involved in Control framework Development and testing.
• Created PL/SQL procedures to retrieve data from BODS metadata to support the control framework design and architecture.
• Create deliverable documents as per SDLC standard.
• Created complex SAP BODS 4.0 jobs for Material master , Vendor Master , Bill of Materials etc.

TechnicalEnvironment: SAP BODS 4.0, SAP ECC 6.0, Oracle 10g

Confidential

DESCRIPTION: Confidential.is a biotechnology company specializing in drugs for neurological disorders, autoimmune disorders and cancer. The company sends its representatives to the Doctors and MD and sells its product. Company keeps the track of expenses through the Confidential web application which is accessible to each employee. The client was not 100 sure on the data quality so the data was send to Confidential for analysis. Based on the analysis and suggestion given by Confidential the client will enhance his systems and process.

Responsibilities:

• Understand the business requirement
• Load the flat file data into database and perform profiling on it
• Create SAP BODS job for Business Data Quality validations.
• CreateWebi reports for Data Quality matrix

TechnicalEnvironment: Oracle, Informatica Data Quality

Confidential

DESCRIPTION: Confidential is a Confidential company which is aimed to transform patient care through innovation. It develops and markets advanced medical devices and instruments for minimally invasive and open surgical procedures within Confidential and around the world. The Confidential project uses advanced data warehouse software and newly developed report tools to deliver daily, monthly and annually reports efficiently and dynamically based on client's requirements and existing databases E1, Coact, Cincom, CDL, EASI, SAP etc .

Responsibilities: -

• Business Modeling Developer building up business models based on client's needs and project requirements.interacted frequently with onsite team to discuss necessary requirement modifications and adjusting the business models promptly and accordingly
• Analyzing the source data to understand how the data can be pulled in EDW and the how existing dimensions/facts can be reused
• Performance tuning for multiple projects analyzing explain plans, creating indexes, partioning etc.
• Develop Informatica and Kalido objects file definitions, class of transaction etc. as per business requirements
• Develop Windows batch scripts and Shell scripts in UNIX/LINUX to automate the process of running workflows
• Create and execute complex test scripts.
• Document the SIT results as per the SDLC standard
• Process lead for Oracle 9i to 10g Upgrade project
• Team Lead of Informatica Upgrade from INFA 7.1.3 to INFA 8.6.1
• Production Support Lead
• Ensuring all the business reports are generated daily on time including weekends.
• To monitor and support the daily ETL and Kalido jobs in the production environment and assist in the smooth running of the jobs.
• Number of supported jobs 600 daily
• also 30 weekly , 40 monthly, 10 yearly
• Percentage of downtime throughout the year less than 1 .
• Resolving Business issues with Cognos Reports
• Enhancements using Informatica, Kalido
• Code deployment using Informatica, Kalido and Cognos
• Migrate ETL, Kalido and Cognosmodules from Development to Test Production environments and support go-live of projects
• Creating/Modifying job schedules in IBM TWS Maestro scheduler by putting in appropriate requests with concerned teams.
• At multiple times independently handled critical situations in the project and has been appreciated for the same from client

TechnicalEnvironment: Oracle 9i,10g,Informatica 7.1, Informatica 8.6.1, Cognos 8.2 BI, Kalido 8.3.277 DIW, IBM Maestro, TOAD, SQL Developer

Confidential

DESCRIPTION: Confidential is a Confidential company which is aimed to transform patient care through innovation. It develops and markets advanced medical devices and instruments for minimally invasive and open surgical procedures within Confidential and around the world. The Confidential Data Warehousing Confidential project uses advanced data warehouse software and newly developed report tools to deliver daily, monthly and annually reports efficiently and dynamically based on client's requirements and existing databases E1, Coact, Cincom, CDL, EASI, SAP etc .

Responsibilities: -

• System Integration Testing Lead
• Create and execute complex test scripts.
• Document the SIT results as per the SDLC standard

TechnicalEnvironment: Oracle 10g

Confidential

DESCRIPTION: Implement a system which will help client to estimate and meet the Demand and Supply of Liquor.

Responsibilities: -

• Understand the business requirement and update the PL/SQL procedure.
• Document the business change request and Unit Test Scripts.

TechnicalEnvironment: Oracle 10g, SOS, Java

Confidential

DESCRIPTION: Build Enterprise Data Warehouseto replace 30 year old technology and reduce the plant shutdown time. EDW was implanted for Supply Chain Management and Financewhich helped to reduce the plant shutdown duration from 2 days to 8 Hours to generate quarterly report.

Responsibilities: -

• Design and development complex BODS jobs for Supply Chain Management
• Design and development of PL/SQL scripts for Supply Chain Management.
• Performance testing of BODS 3.2 jobs
• Analyze and work on the deployment of CRs Change Request requested by product team
• Creating and reviewing technical Design Document
• Create and execute System Integration Test SIT scripts
• Software product Testing and UAT along with the business users

TechnicalEnvironment:SAP BODS 3.2, Oracle 9i, SAP ECC

Confidential

Responsibilities: -

• Support and Installation of Databases like MS SQL, Oracle
• Application Support like MS.Net, Oracle , D2K, JAVA
• Installing and configuration of 2000/2003 Servers
• Supporting Deloitte Security policy applications EPO, Cryptography
• Network and Desktop Support Engineer
• Managing the Hardware and Software Inventory.
• Old asset de-bonding

Confidential

Responsibilities: -

• Network and Desktop Support Engineer