Data Project Manager
Resume:
Summary:
Around Eight years of experience in application development, this includes design, development and implementation of projects as Oracle PL/SQL developer and SQL Server developer.
Experienced in tools such as SQL *Developer, TOAD and Putty.
Exhaustive experience in writing PL/SQL scripts for database entities like Tables, Procedures, Functions, Packages, Triggers, Sequences and Indexes.
Well versed in using Views, Synonyms, Indexes, Hints, Joins and Sub- queries.
Experience in writing UNIX and LINUX shell scripts to automate batch processes.
Proficient in SQL query tuning to improve performance.
Knowledge of Master Data management (MDM) processes.
Skilled in writing unit test cases.
In depth experience in all phases of SDLC: Requirements Gathering, Analysis, Design, Development, Testing, Implementation (Production) and Maintenance Support(Post Production)
A Self-starter with strong planning, organizing and controlling skills. Consistently manage time, plan and multiple tasks to meet deadlines, established objectives and quality performance standards.
Able to work independently, as a lead or in a team effectively.
Technical Skills:
Database Technologies
Oracle 8i/9i/10g/11g
Languages
PL/SQL, SQL,Red Hat Linux and Unix Shell Script, Python, C++
Development Tools
Oracle Enterprise Manager, TOAD 9.6.1,Oracle SQL Developer, SQL *Plus, SQL *Loader, Erwin 7.3, Oracle Data Modeler, Query Analyzer, Export/Import, DFPowerStudio 8.2
Application/Web Services
Apache Tomcat Server, WebLogic, Websphere
Operating Systems
Red Hat LINUX,UNIX, Solaris, Windows NT/2000, Windows 98/XP
Experience:
Pfizer, Inc. April 2016- Current
Project: Hospira Data Integration
Role: Senior Data Analyst – Lead
Pfizer acquired Hospira in September 2015. The Hospira data integration project was to integrate all Hospira data into Pfizer systems.
Responsibilities:
Lead a team of 3 resources on shore and offshore.
Worked in close Interaction with developers, Business Analyst and Project Manager and regional leads of Hospira teams to understand functional specifications and developing creative solutions to meet business requirements.
Used ERwin to model additional tables needed to accommodate Hospira attributes.
Optimized and enhanced the existing procedures and packages for the better performance using CURSORS, SQL STATEMENTS AND VALIDATIONS etc. to load new items from Hospira.
Defined and configured schema, staging tables and landing tables, base objects foreign-key Relationships, look up systems and tables, packages, query groups and queries/custom queries.
Defined, developed, tested and documented Oracle packages, procedures and functions for new requirements for Hospira.
Extracted various reports using Data flux Power Studio.
Developed UNIX shell scripts to automate batch processes to load data to production tables.
Database optimization using indexes and normalization principles to increase the efficiency of data manipulation and extraction.
Pre-Migration testing, validation and verification of all data elements to be migrated
Performed initial data migration, subsequent delta migrations and validated the data been converted.
Involved in refreshing test environment with production data after each release to make way for testing the locations going live the next release.
Creating all test data (with templates provides by regional leads) and process in test environment for other teams to start testing and make changes as and when required.
Involved in data validation process in data validation environment before the data is processed in production.
Involved in intensive data migration, data validation and report generation on the go-live day.
Involved in hypercare support.
Environment: Oracle 11g, TOAD 11.5, SQL Navigator 5.5, Windows 2000, Red Hat Linux, DFPowerstudio 8.2., ERwin Data Modeler 7.2
Pfizer, Inc. September 2014-March 2016
Project: Streamlink
Role: Senior Data Analyst - Lead
Pfizer’s animal health division was bought by Zoetis an animal health care company. Zoetis was implementing SAP across set of organizations including the supply operating model. Streamlink was about data migration from Pfizer to Zoetis SAP systems for AHG (Animal Health) line of business .This was continues with discontinuation of all animal health activities from Pfizer.
Responsibilities:
Lead a team of 3 resources onshore.
Worked in close Interaction with developer, Business Analyst and Project Manager and regional leads of both Zoetis and Pfizer teams.
Understanding functional specifications and developing creative solutions to meet business requirements.
Optimized the existing procedures and SQL statements for the better performance using CURSORS, SQL STATEMENTS AND VALIDATIONS and etc. to tune SQL queries to support Streamlink processes.
Performed ETL mappings & ran sessions and workflows to execute the Land Process of loading the customer/product Data Set into MDM that was coming from various source systems.
Extracted various reports using Data flux Power Studio.
Defined and configured schema, staging tables and landing tables, base objects foreign-key Relationships, look up systems and tables, packages, query groups and queries/custom queries.
Defined, developed, tested and documented Oracle packages, procedures and functions for new requirements for Streamlink.
Involved in the database design of using the staging tables to load the data into each application.
Developed UNIX shell scripts to automate batch processes to load data to production tables.
Database optimization using indexes and normalization principles to increase the efficiency of data manipulation and extraction.
Pre-Migration testing, validation and verification of all data elements to be migrated
Performed initial data migration, subsequent delta migrations and validated the data been converted.
Involved in refreshing test environment with production data after each release to make way for testing the locations going live the next release.
Creating all test data (with templates provides by regional leads) and process in test environment for other teams to start testing and make changes as and when required.
Involved in data validation process in data validation environment before the data is processed in production.
Involved in intensive data migration, data validation and report generation on the go-live day.
Involved in hypercare support.
Discontinuation of user access to Animal health data.
Discontinued all animal health items in Pfizer database.
Discontinuation of animal health line of business elements in all Pfizer applications.
Environment: Oracle 11g, TOAD 11.5, SQL Navigator 5.5, Windows 2000, Red Hat Linux, DFPowerstudio 8.2,
Pfizer, Inc. February 2014 – August 2014
Project: Production Support
Role: Senior Data Analyst
Ongoing support for changes to made to data elements of SCIM (Supply Chain Item Management) and process enhancement to better user support.
Responsibilites:
Creating new locations, cross references
Updating item attributes
Granting and updating user access
Enhancement of existing processes to support batch loads
Adhoc reports to users
Loading templates to insert/update/delete various data elements.
Environment: Oracle 11g, TOAD 11.5, SQL Navigator 5.5, Windows 2000, Red Hat Linux, DFPowerstudio 8.2,
Marlabs, Inc. November 2012 – January 2014
Project: Employee Self Service Portal
Role: Oracle PL/SQL Developer
ESS Portal is an Internet solution that changes the business of Human Resources and Employee Benefits Administration and builds one-to-one relationships with employees, managers. The interfaces are built to integrate the various applications in the HR realm like the PROCS (procurement), eSAL (Remuneration and benefits) and time tracker application. The interfaces are built on a database to database model to integrate the employee data across the various applications and regional systems.
Worked in close Interaction with Business Analyst and Project Manager.
Understanding functional specifications and developing creative solutions to meet business requirements.
Optimized the existing procedures and SQL statements for the better performance using EXPLAIN PLAN, HINTS, SQL TRACE and etc. to tune SQL queries.
The interfaces were developed to be able to connect to multiple databases like SQL server and oracle.
Coordinated efforts with SAP ERP team regarding SAP Master Data Tables with the Enterprise MDM Solution
Involved in the database design of using the staging tables to load the data into each application.
Involved in preparing roll back scripts and developing roll back plans.
Supported the production team in developing the scripts for maintaining the JCAPS logical host and periodic clean up.
Database optimization using indexes and normalization principles to increase the efficiency of data manipulation and extraction
Responsible for Installation, Design, Configuration, Development and maintaining Content Management System for clients.
Environment: Oracle 10g, TOAD 7.5 / 8.0, SQL Navigator 5.5, JCAPS, Windows 2000.
UBS Jersey City, NJ Jun 2010 – October 2012
ETS (Equities Trading System)
UBS is well-equipped to capture the clients’ complete end-to-end cross-border trade flows. ETS is one of the global applications used across UBS for managing cash Trading to futures, indices, baskets and options. Involved in data modeling and development of complex procedures.
ORACLE PL/SQL Developer
Physical design and development of Database.
Understanding the business requirements, analysis, design, development and implementation into the system, Improve business processes.
Involved in PL/SQL, Stored procedures, Functions, packages, Triggers, Constraints, Cursors and Views, writing test scripts.
Created audit table to record the UPDATEs and INSERTs on the tables by creating database triggers.
Troubleshooted performance issues and bugs within packages and stored procedures using dbms_output and explain plan.
Created indexes on some columns of tables to increase the application's performance.
Used PL-SQL features like cursors, ref cursors, Exception handling records.
Used PLSQL Records, Collections (Nested Tables and Varrays) in complex backend packages.
Created SQL*Loader scripts to load data from external system to oracle.
Used EXPORT/IMPORT to do table level and full database defragmentation.
Also used Oracle Enterprise Manager (OEM) to schedule jobs using the DBMS_JOBS package.
Environment: Oracle 11g, PL/SQL, Toad, Unix Sun Solaris 2.6, AIX 4.3, WINDOWS NT Workstation, Crystal Reports.
Client: CISCO Systems, Inc. August 2009 - Jun 2010
Project: City Tracker
Role: SQL and PL/SQL Developer
The COO [City Of Origin] sub-module utilizes several rules to determine the location of last significant manufacturing phase. This information is weighed heavily for sales and logistical shipping to end customers as there is US political restrictions that feed into the equation where Cisco can ship products from. The focus is the detailed functional and design specification of COO. It will cover all interfaces of all internal modules as well as dependencies on other SDI sub-systems.
Extensively involved in Developing Components for Application Layer, Business Layer and Data Layer, implementation in Architecture.
Configured and designed Entity Relationship Diagram[ERD] to demonstrate the logical structure of the database.
Developed stored procedures and complex packages using PL/SQL for maintaining manufacturer information.
Responsible for data modelling and schema changes in production.
Develops and support back end data processing in PL/SQL.
Gap-Fit each MDM requirement as well as provide high level of estimate for the level of effort required to meet each requirement.
Defined services such as business service, data service, work flow etc. with the team.
Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.
Involved in code review and code optimization part of entire project
Responsible to provide the documentation & progress report to senior manager on daily basis.
Environment: Oracle 11g, PL/SQL, Toad 9.1, Putty, UNIX
Marlabs, Inc. August 2008 – July 2009
Project: S-Campus
Role: PL/SQL Developer
S-Campus (Smart Campus) is a comprehensive school management system to assist schools reaches their full potential by delivering unmatched functionality and value. S-Campus focuses on the needs of, both educators and students and gives all school stakeholders, the power to manage. S-Campus leverages the power of existing technology resources and provides with seamless and intuitive tools that can automate routine classroom and administration function provides interactive learning aids and fulfil the communication and information needs of the entire school community in real time.
Responsible for design, development and delivery of Functional Specifications and Design Documents.
Created assessment table to record the UPDATEs and INSERTs on the tables by creating database triggers.
Coded and implemented PL/SQL packages to perform batch job scheduling.
Data design for time module.
Used EXPORT/IMPORT to do table level and full database defragmentation.
Used web services for interaction between various components and created SOAP envelopes.
Responsible to Reviewing Product Documents and Test Documents (Test Plans and Test Cases) from Document and QA teams.
Responsible to test the modules for load testing, memory leaks and performance.
Worked at Client place in deploying and implementing the modules with their test data successfully on Linux Machines.
Environment: Oracle 11g, PL/SQL, SQL *Loader, Toad 9.1,Windows 2000
Education:
Bachelors in Electrical and Electronics Engineering, Mysore University, India
Contact this candidate