SUMMARY

• Highly motivated and adaptive with the ability to grasp things quickly with excellent interpersonal, technical and communication skills. Ability to work effectively and efficiently in a team and individually.
• 15 years of IT experience in Analysis, Design, Modeling, Development, Testing and Implementation of Data Warehousing Business Applications as well OLTP application.
• 7+ Years of Data warehousing experience. Design and developed medium to complex size data warehousing project for Client like Cisco, Confidential and Confidential .
• 8+ years of experience in application support. Supported P1 application in Cisco systems, Confidential in 24/7 model. Lead a team of 10 members in onsite - offshore support model. Sound knowledge of SeviceNow, BMC remedy tool for incident management.
• Expert in Data mart designing, ETL development, Data migration.
• Expert in Creating and managing logical, physical and conceptual models using data modeling tools. Handled number of medium to larger project independently End 2 End.
• Analyze and profile source data to find underlying data/domain relationships and gaps. Develop and communicate standards for data structures.
• Experience in requirement gathering and requirement management in cross functional projects
• Expertise in business and systems documentation, use case analysis and change management
• Very good knowledge of MongoDB database. Successfully converted Application from Oracle Database to MongoDb database.
• MongoDB database monitoring, deployment with DBA team. Configure MongoDB as per application requirement.
• Successfully handled a team of 15+ associate in Onsite/Offshore model. 10+ years of abroad experience (USA + Uruguay) worked closely with Client.
• Expertise with Data Migration, Data Mapping or Table mapping, Data loading and exporting by using Import Export, SQL*Loader and UTL File Utilities.
• Good knowledge of Data Modeling using ETL tools, OLAP tools, Star Schema, Snowflake Schema, and Entity-Relationship Diagrams.
• Expert in developing reports using Tableau, Actuate tool.
• Proven leadership and project management skills (PMP certified).
• Excellent skills in designing and development of applications using Oracle 11g/10g/9i/8i, SQL, PL/SQL. Good knowledge on Oracle tools like SQL * PLUS, PL/SQL, SQL and used TOAD, PL SQL developer in many development projects.
• Expertise in Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, TKPROF, SQL Trace, Explain Plan, Bulk Collect feature, Materialized Views and Troubleshooting Oracle database issues.
• XML, JSON processing through Oracle PL-SQL.
• Excellent knowledge for Oracle apps pricing module, Oracle AQ, PVCS, Kintana
• Experience in Bulk Data loading using Oracle utilities namely SQL Loader and External Tables.
• Leading the Confidential Toastmaster club as President. Achieved the Certification as Competent Communicator and Competent Leader from Toastmaster International.

TECHNICAL SKILLS

Programming Languages: C, C++,Java, SQL, and PL/SQL,Visual Basic 6.0

Databases: Oracle 11g/10g/9i/8i, SQL Server. Advanced Oracle queuing technique (Cisco Data Bus). Oracle Apps Pricing Module.MY SQL,MongoDB,Cassandra, Golden Gate, Oracle AQ, PVCS, Kintana

BI Tools: Tableau, Siebel Analytics, Actuate,Informatica

Operating Systems: Solaris, UNIX, Linux, Windows 95, NT, 2000, XP

Scheduling tool: Dollar Universe,CRONTAB,BMC Control-M

Front end Tool: Toad,PL-SQL Developer

Incident management tool: Service Now, BMC

WORK EXPERIENCE

Confidential

Senior Database Engineer

Responsibilities:

• Converting Flash PnL application from oracle to MongoDB database.
• Data modeling from RDBMS to MongoDB for Flash PnL project.
• MongoDB database planning and deployment in coordination with DBA group.
• Interact with the stakeholders to gather and manage requirements.
• Analysis of business requirements and functional specifications documents
• Creation of Technical design document to mapped the requirement
• Creating and managing logical, physical and conceptual models using data modeling tools. Working closely with Data Architect for data modeling.
• Writing ETL to pull the data from different data sources and work extensively on data migration. For Extraction Informatica is used and for business logic Oracle PL-SQL is used. Job Scheduling is done by BMC Control-M tool.
• Provide the level 2 support for the production issue.
• For Flash PnL working on moving database from Oracle Database to MongoDB database.
• Work with Business Analyst to get the QA as well as BA sign off.
• Work with Release team to deploy the code in production environment by following guidelines.
• Do coding in PL/SQL using packages, procedure and function. Creation of relevant quality documents like Analysis, Design, Test cases.
• Develop the complex View using Table function, Materialized View for downstream.
• Create Tableau report for Prudential Risk Asset (PRA), Risk weight assets (RWA).

Confidential

Technical Lead

Responsibilities:

• Interact with the stakeholders in the GIS to gather and manage requirements
• Analysis of business requirements and functional specifications documents
• Creation of Technical design document.
• Creating and managing logical, physical and conceptual models using data modeling tools. Working closely with Data Architect for data modeling.
• Successfully migrated the application from Oracle Database to MongoDB database.
• Provide the level 2 support for the production issue.
• Act as the liaison between the business users and the technical team (onsite and offshore)
• Manage traceability between requirements, use cases and test cases
• Perform GAP analysis and Data modeling
• End 2 End performances tuning of the Application.
• Writing ETL to pull the data from different data sources and work extensively on data migration.
• To do the code review, developed the reusable component.
• Coding in PL/SQL and creation of relevant quality documents like Analysis, Design, Test cases.
• Work closely with the testing team for preparation and execution of UAT plans.
• Create Work Break Down Structures, Cost and Time estimates, Responsibility Assignment Matrix as necessary
• Manage resources to ensure delivery within planned timeframes and budget
• Prepare user manuals, presentations and provide end user training

Environment: Oracle 10g, Golden gate(Oracle AQ), perl, Toad, CRON TAB- Unix Job Scheduling tool, Erwin,Unix,PL-Sql MySQL, PVCS, Kintana.

Confidential, San Jose

Technical Lead

Responsibilities:

• Interact with the stakeholders in the Commerce Work Space group to gather and manage requirements
• Analysis of business requirements and functional specifications documents
• Creation of Technical design document.
• Create Work Break Down Structures, Cost and Time estimates, Responsibility Assignment Matrix as necessary
• Manage resources to ensure delivery within planned timeframes and budget
• Act as the liaison between the business users and the technical team (onsite and offshore)
• Manage traceability between requirements, use cases and test cases
• Perform GAP analysis and Data modeling
• Work closely with the testing team for preparation and execution of UAT plans.
• Coding in PL/SQL and creation of relevant quality documents like Analysis, Design, Test cases.

Environment: Oracle 10g, Oracle APPs, Golden gate, Java, Toad, Dollar Universe Scheduling tool, Oracle AQ, PVCS, Kintana, Unix

Confidential

Technical Lead

Responsibilities:

• Interact with the stakeholders in the Commerce Work Space group to gather and manage requirements
• Analysis of business requirements and functional specifications documents
• Creation of Technical design document.
• Create Work Break Down Structures, Cost and Time estimates, Responsibility Assignment Matrix as necessary
• Manage resources to ensure delivery within planned timeframes and budget
• Act as the liaison between the business users and the technical team (onsite and offshore)
• Manage traceability between requirements, use cases and test cases
• Perform GAP analysis and Data modeling
• Work closely with the testing team for preparation and execution of UAT plans.
• Prepare user manuals, presentations and provide end user training
• End 2 End performances tuning of the Application.
• To do the code review, developed the reusable component.
• Coding in PL/SQL and creation of relevant quality documents like Analysis, Design, Test cases.

Environment: Oracle 10g, Java, Toad, DBMS profilers.

Confidential

Senior Database Developer

Responsibilities:

• Interact with the stakeholders in the Commerce Work Space group to gather and manage requirements
• Analysis of business requirements and functional specifications documents
• Creation of Technical design document.
• Create Work Break Down Structures, Cost and Time estimates, Responsibility Assignment Matrix as necessary
• Manage resources to ensure delivery within planned timeframes and budget
• Act as the liaison between the business users and the technical team (onsite and offshore)
• Manage traceability between requirements, use cases and test cases
• Perform GAP analysis and Data modeling
• Work closely with the testing team for preparation and execution of UAT plans.
• Prepare user manuals, presentations and provide end user training
• End 2 End performances tuning of the Application.
• To do the code review, developed the reusable component.
• Coding in PL/SQL and creation of relevant quality documents like Analysis, Design, Test cases.

Environment: Oracle 10g, Java, Toad,DBMS profilers, Unix. ‘Performed an intense process flow analysis that resulted in pre-emptive identification of many bottlenecks in the operations and provided a reliable solution for this mission critical application to make it more robust and stable.

Confidential

Senior Database Developer

Responsibilities:

• Interact with the stakeholders in the Commerce Work Space group to gather and manage requirements
• Analysis of business requirements and functional specifications documents
• Creation of Technical design document.
• Create Work Break Down Structures, Cost and Time estimates, Responsibility Assignment Matrix as necessary
• Manage resources to ensure delivery within planned timeframes and budget
• Act as the liaison between the business users and the technical team (onsite and offshore)
• Manage traceability between requirements, use cases and test cases
• Perform GAP analysis and Data modeling
• Work closely with the testing team for preparation and execution of UAT plans.
• Prepare user manuals, presentations and provide end user training
• End 2 End performances tuning of the Application.
• To do the code review, developed the reusable component.
• Coding in PL/SQL and creation of relevant quality documents like Analysis, Design, Test cases.

Environment: Oracle 10g, Java,Toad,DBMS profilers, Unix.

Confidential

Senior Database Developer

Responsibilities:

• Interact with the stakeholders in the Cisco channel partner to gather and manage requirements.
• Analysis of business requirements and functional specifications documents
• Creation of Technical design document.
• Create Work Break Down Structures, Cost and Time estimates, Responsibility Assignment Matrix as necessary
• Manage resources to ensure delivery within planned timeframes and budget
• Act as the liaison between the business users and the technical team (onsite and offshore)
• Manage traceability between requirements, use cases and test cases
• Perform GAP analysis and Data modeling
• Work closely with the testing team for preparation and execution of UAT plans.
• Prepare user manuals, presentations and provide end user training
• End 2 End performances tuning of the Application.
• To do the code review, developed the reusable component.
• Coding in PL/SQL and creation of relevant quality documents like Analysis, Design, Test cases.

Environment: Oracle 10g, Java, Toad, DBMS profilers,unix.

Confidential

Database Developer

Responsibilities:

• Sales Hierarchy,
• Corporate Vertical Market,
• Localized EMEA Vertical Market,
• Core/Advanced Technology
• Top 20 Customers.

Environment: Oracle 10g, Java, Toad,DBMS profilers, Dollar Universe, Siebel Analytics, Unix.

Confidential

Database Developer

Environment: Oracle 10g, PL-SQL Developer, Actuate reporting tool.

Responsibilities:

• I am purely worked on technical side. I had developed the PL-SQL package for the data extraction.
• I had also involved in Report development using Actuate and training blue dart staff on Actuate.

Confidential

Database Developer

Environment: Oracle 9i, Toad, Visual Basic 6.0,MSFlex Grid.

Responsibilities:

• I worked purely on technical side. I had developed the PL-SQL package.
• I had done coding in Visual Basic 6.0 to support the ERP’s screen.
• Develop Form-5, Form 6 in Visual Basic 6.0 and oracle 8.0.

Confidential

Database Developer

Environment: Oracle 9i, Toad, Visual Basic 6.0.

Responsibilities:

• I had done coding in Visual Basic 6.0 to support the biometric finger print attendance system.
• I worked purely on technical side. I had developed the PL-SQL package.
• Created the Data model for Finger print attendance system.