SUMMARY:

• A successful, results oriented Senior Business Systems Analyst, Senior System Developer, Offshore Engagement & Delivery Manager
• Proven track record with strong communication skills to gather Business Requirements, create Functional and Technical Specifications that involves Application Design, perform the Development, self and with offshore team, Test, Implement and provide Production Support
• Expert in understanding, performing and implementing Product Development, Technology Transition/Migration, Application Support & Maintenance
• Domain expertise in assessing Business Operational efficiency, Automation and Reporting for cost effective growth
• Demonstrated and Implemented, modernized system optimization through Self - Development, End to End pre-prod testing, Performance Analysis, Impact Analysis and technical Production Support
• Experienced in Application and Data Migration from Legacy systems to Oracle and DWH involving Design, Development and Implementation
• Worked closely with DB Administration team, BI Reporting, Application Monitoring, and Onsite/Offshore teams.
• Managed offshore teams in India & China for Volvo Cars, to work effectively and efficiently, for the success of transformation we implemented in CRM
• Identified allied technology of DWH and Informatica for Confidential, incurred the knowledge and started supporting with Development, Implementation and Production Support.
• Assessed, Identified and Proposed, Data Migration and data conversion from Mainframe to Oracle for Confidential . Productively worked with the Contracted resources for Migration, Development, and Assessment for successful completion of Legacy conversion.
• Worked with Cross-Functional teams diversified across facilities / countries on Re-architecture, Design, Development and End-to-end data conversions

CAPABILITY STACK:

• Performed Deliveries comprising technology stack of Oracle12cDatabase, Oracle E-Business Suite - (Supply Chain Management, Financials), Oracle PL/SQL, Oracle Developer 2000(Forms, Reports)), Data Warehouse (DWH), Informatica (PowerCenter, Metadata Manager), Teradata, Unix (Shell Scripting), Java, MS Access, high level of SAP& ODDB, Mainframe (IBM OS/390, COBOL, DB2, CSP, PANVALET)
• TOAD, SQL Navigator, ODBC, JDBC, LDAP, API, CA Unicenter, Concurrent Manager, MS Office, MS Project Professional
• Proficient with PMBOK - Agile, Scrum, Waterfall - ITIL, CMMi

PROFESSIONAL EXPERIENCE:

Confidential

Senior Business System Analyst, Senior Developer, Offshore Engagement Manager

Responsibilities:

• Gathered and documented the Business Requirements (BRD) from Volvo Cars Business Managers at Sweden & Belgium. Upon obtaining their Sign-Off, transformed the BRD to Functional Requirement& Specification Document, for Detailed Design Documents (High Level Design, Low Level Design), Created Technical Specification document (TSD) for Project Development Signoff.
• Participated in defining software development project plans, including scoping, scheduling, and implementation for successful, Time Targeted completion
• Technically involved in the Development of Volvo CRM using Volvo Data Warehouse (DWH) in Teradata DB, Volvo Consumer data in Oracle DB, using Informatica ETL tool, to extract OLTP data after Siebel Application processing, through Oracle PL/SQL Stored Procedures and Informatica Transformations as per the Design and loading it into OLAP Oracle DB for OBIEE Reporting.
• Performed Unit Testing, End to End testing to complete the Development Cycle and assisted the Testing Team in creation of test cases and in successfully performing System Integration Testing and User Acceptance Testing
• Technical and Functional enhancements of accounts, were performed on Existing System, through Code Reviews and comparison with Business Requirements received, to assess the achievement of Business Delivery

Environment: DWH, Informatica (Power Center, Metadata Manager), Teradata, Oracle DB, Oracle PL/SQL, Unix, LDAP, API, ODBC, Toad

Confidential

Senior Business Analyst, Senior System Developer, Offshore Delivery Manager

Responsibilities:

• Developed and Implemented DWH Informatica ETL for Fidelity, by Transforming the business data from Oracle, SQL Server and DB2 to Teradata target tables for BI reporting
• Actively responsible for the definition and documentation of Business Requirements (BRD), objectives, deliverables, and specifications (FSD, TSD) for projects in collaboration with internal users and technical teams
• Developed Data Warehouse workflows by extracting Mainframe VSAM files and Copybook, Database table & Flat file extract from Oracle DB and MS SQL Server using Stored Procedures, transformed it using Informatica ETL Mappings & Mapplets to meet the BRD and loaded the Teradata target tables for Business Report generation
• Performed Unit Testing and assisted Testing team in the creation of in-depth test cases, test scripts for System Integration Testing (SIT) and User Acceptance Testing (UAT), for successful implementation release
• Provided Production Support and its operation was measured, analyzed and impact analysis done for efficient, cost effective development and production support

Environment: DWH, Informatica (Power Center), Teradata, Oracle DB, SQL Server, Mainframe, Flat files, Oracle PL/SQL, Unix, LDAP, API, ODBC, Toad

Confidential, Rochester, NY

Senior System Developer

Responsibilities:

• Responsible for Confidential Oracle online and database applications, UNIX server maintenance, coordinating business requirements from 3 vice-presidents and 7 business managers.
• Developed custom Oracle Forms, Reports, Oracle Database applications using PL/SQL, SQL*Plus, SQL*Loader and Unix Scripts, to implement Confidential Long Term Care division daily business operations and nightly data processing
• Created Test Cases and perform Unit Testing, Performance Testing and provide 24x7 production support
• Initiated, created & presented proposals for application optimization on new development to IT Manager and Operations Vice-President
• Escalation point for delivery issues, execute resolution and corrective actions at enterprise level

Environment: Oracle 11g, Developer 2000 (Forms, Reports), PL/SQL, SQL*Plus, Toad, Unix Shell Scripting

Confidential, Rochester NY

System Analyst, Senior Systems Analyst

Responsibilities:

• In Oracle ERP Applications INV, BOM, OE, PO, WIP modules of Supply Chain Management (SCM) - Manufacturing and GL, AP, AR modules of Financials, developed custom Foms, Reports, Oracle PL/SQL Procedures, Functions, Packages, Triggers for Supply Chain and Logistics divisions for McQuay Int Client
• Design, develop and maintain Oracle, JAVA Batch system comprising of Oracle PL/SQL Procedures, Functions, Packages, Unix Shell Scripting and JAVA batch process for Confidential Corp client
• Create synchronization process between Mainframe and Oracle to sync over the data across platforms to continue support business from both Mainframe and Oracle for smooth transitioning. The sync process was slowly eliminated as the mainframe processes were retired and replaced in Oracle for Confidential Corp
• Cross train, mentor offshore team members with customer business knowledge and processes, Oracle PL/SQL procedures, packages & functions development, Unix Shell Scripting and 24x7 on-call support in Oracle
• Educated full life cycle methodology starting with requirements gathering, technical design, development, coding, testing, quality control testing, performance tuning and implementation in Unix/Oracle environment.
• Managed Offshore resources performance and timely delivery of development and production support.
• Earlier to the above Designed and Developed IBM Mainframe Systems using COBOL/DB2 programs, Cross System Product (CSP) on line screens, coding, testing and implementation.

Environment: Oracle ERP Applications, Forms 4.5, Reports 2.5, PL/SQL, SQL, SQL*Plus, SQL*Loader, Java, MS Access, Unix Shell Scripting, CA Unicenter, TOAD, SQL Navigator, IBM OS/390, TSO/ISPF, COBOL, DB2, MVS/ESA, CSP, File Aid, Endevor, PANVALET