SUMMARY:

• 9+ years of experience in System Designing, Analysis, Application Development, Maintenance, Implementation, Project Management in SAP MDM and PL/SQL programming with Oracle/SQL Server/DB2.
• Strong Knowledge of all the phases of Software Development Life Cycle (SDLC) such as analysis, design, development, testing, implementation and maintenance.
• 7+ years of Development experience in SQL Scripts, PL/SQL programs in Oracle 10g/9i/IBM DB2 using SQL developer, SQL+ for new requirements, support and resolving the issues.
• Experience with Data flow diagram, data dictionary, database normalization, Entity relationship modelling and design techniques.
• Extensive experience in writing and tuning complex sub queries, SQL, PL/SQL stored procedures, functions, triggers, materialized views
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Partitioned large Tables using partition techniques.
• Worked on basic UNIX shell scripts that in turn called the PL/SQL procedures to perform required data transformation and data load.
• Worked on SQL*Loader to load bulk data into database.
• Basic knowledge of IBM Datastage ETL Tool.
• Knowledge of data warehousing techniques.
• 2 years of experience in SAP MDM SP12 and SP10, ECC 7.1.
• Worked on all SAP MDM tools SAP Console, SAP Data Manager, SAP Import Manager, SAP Syndicator.
• Experience in SAP Modules Material, Customer, Vendor and Variety.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications.
• Strong organizational, time - management and planning skills to deliver projects on time/budget, despite intense pressure and aggressive timelines.
• Assigning tasks to technical team, managing timelines, resolving issues testing solutions, training users, and maintaining communication with customers and management.
• Good Communication and Interpersonal skills. Technically sound, Result-Oriented with strong Problem-solving skills. Innovative & efficient.
• Capable of working as a Team Leader, Team Member or Individually with minimum supervision.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

TECHNICAL SKILLS:

SAP MDM: SAP MDM SP 12 and SP 10, ECC 7.1

RDBMS: Oracle 10g, Oracle 9i, SQL Server 2008, IBM DB 2.

Languages/Scripting: PL/SQL, UNIX

Tools & Utilities: Toad, SQL Developer, SQL* Plus, IBM Data Studio, Datastage

Development Methodology: Agile, Waterfall

Operating System: Windows NT/XP/ 2000/2003/2008, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Database Developer

Environment: Oracle 11g, Java, JSP, Oracle report 10g

Responsibilities:

• Development of PL/SQL procedures, functions, triggers, views.
• Created Database Users, Roles and managing Security.
• Created materialized views.
• Used the inner join, outer join, cross join while writing the complex SQL Queries.
• Created sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Created indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Optimized performance and tuning of SQL queries, Stored procedures and fixed the slow running queries in production.
• Used partitioning and sub partitioning of tables to improve performance.
• Performed performance testing to ensure the quality of the code delivered.
• Created data reports using Oracle Reports.
• Created unit testing plan and cases and performed unit testing to ensure the quality of the code delivered.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Confidential

SAP MDM Group Module Lead

Environment: SAP MDM SP12/SP10, MDM Portal, SAP Net Weaver 7.1

Responsibilities:

• Managing and Monitoring All MDM Servers Development, SIT, UAT and Production.
• Impact analysis of new requirements.
• Assist in establishing Governance structure such as Data Owners, Process Owners and Data Governance Processes.
• Support the activities of Customer, Vendor and Material records creation, edit and workflows management.
• Syndicate for processing in MDM Console and troubleshoot unprocessed import files by handling Exceptions.
• Analysis of IDOCS for Customer/Vendor/Variety Records Maintenance in Foundation systems.
• To perform fields mapping, Impact Analysis, transport the objects and post-migration system checks.
• Syndication of master data from MDM to ECC on daily basis by sending XML using Master Data Syndication Server.
• Perform Data Cleansing, Perform Unit, Integration and User Acceptance Testing.
• Extensive Client interaction for Data Synchronization and Enhancements in Foundation and MDM Systems. Represented Master Data Management in weekly client and internal study meetings to report status updates as MDM module lead.

Confidential

Database Developer

Environment: IBM DB2 (PL/SQL Programming), IBM Data studio, Cognos, Java, JSP, Datastage

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Worked with relationship database models, schemas & entity-relationship diagrams (ERMs) to create technical/system design documents.
• Created Low level design documents for each functionality developed.
• Created impact analysis document for new functionalities and production issues.
• Participated in code and design reviews.
• Prepared and updated design specifications.
• Development of PL/SQL procedures, functions, triggers, views etc using IBM Data Studio.
• Created Database Users, Roles and managing Security. Implemented effective database security practices and procedures.
• Created materialized views.
• Used the inner join, outer join, cross join while writing the complex SQL Queries.
• Created sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Created indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Written stored procedures for Crystal report creation.
• Written Stored procedures for ETL data load.
• Created datastage projects for data transfer from Oracle system to DB2 system.
• Optimized performance and tuning of SQL queries, Stored procedures and fixed the slow running queries in production.
• Used partitioning and sub partitioning of tables to improve performance.
• Performed performance testing to ensure the quality of the code delivered.
• Created unit testing plan and cases and performed unit testing to ensure the quality of the code delivered.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Handled release activities. Created release notes for each deployment to SIT/UAT/Production.
• Worked on SVN to maintain different versions of programs.

Confidential

Database developer

Environment: Oracle 10g, Java, JSP

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Performing impact analysis of new requirement.
• Created Entity relationship diagrams for design documents.
• Data modelling using Oracle SQL Developer data modeler.
• Created the Relational Database Tables with all the necessary Constraints.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Used indexes on tables to improve the performance by eliminating the full table scans.
• Created views for hiding the actual tables and to eliminate the complexity of the large queries.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Performed SQL and PL/SQL tuning and Application tuning using various commands like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Created Materialized views to improve the performance.
• Used hints to direct the optimizer to choose an optimum query execution plan.
• Used Partitioning logic to improve the performance.
• Load data from XML files to Database.
• Data migration using SQL Loader.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Confidential

Database Developer

Environment: Oracle 9i, Java, JSP

Responsibilities:

• Involved in the continuous enhancements and fixing of production problems.
• Performing impact analysis of new requirement.
• Creation of database objects like tables, views, materialized views, procedures and packages.
• Used indexes on tables to improve the performance by eliminating the full table scans.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Prepared test cases and performed Unit Testing, Integration testing and Performance testing for developed SQL Scripts.