Data Management

Subhash Adusumilli

(***) ***- ****

acok0z@r.postjobfree.com

Profile:

Over 18 years of diverse experience in Pharmaceutical, Financial and

Insurance industries

Specializing in Software Engineering, Project Coordination and Management,

and Design Methodologies

Highly proficient in the business functional and technical areas of Supply

Chain, Manufacturing, Planning, Procurement, Logistics, Product Costing

Supported various business units like Pharmaceutical manufacturing, API

manufacturing plants, Dosage plants, Animal Health, Consumer care, Primary

Care, Oncology, Emerging Markets, Established products divisions

Major role player in defining business/functional requirements, and

designing technical architecture and other aspects of SDLC

Extensive SAP Data Migration experience in conversion projects using tools

like BackOffice Cransoft, and Informatica

Extensive implementation experience of mapping the existing business

process to SAP by Fit/Gap Analysis

Lead experience in managing data migration teams for end to end data

migration processes

Experience in managing all stages of data migration from data analysis to

pre go-live validations, user acceptance testing, user sign-off, Cut-Over

plans, migrating to Dev/QA/ Prod landscapes, and post go-live validations.

Good knowledge of technical approaches in data extraction, validation and

cleansing

Key strengths demonstrated in complex problem solving, interpersonal

communications and team leadership with outstanding skills in analyzing,

assessing and prioritizing projects

Committed to seamless integration of business and technology by building

scalable, cost-effective and high quality solutions

Coordination with development and business teams, onsite/offshore teams,

good written/verbal communication skills

Committed to integrity and excellence, proven ability to effectively multi-

task meeting deadlines while focusing on the growth and continuous

improvement of client relationships

Technical Skills:

Tools/ BackOffice Associates(BOA) - Cransoft, LSMW, BDC, MDM,

Technologie TCP/IP, FTP, IFS Dir, DataFlux, Informatica 8.2, COGNOS

s 7.3/8, ERwin Data Modeler(ERwin 4.5), SharePoint, SAP

R3(ECC 6.0), SAP MM, IM/WM, HPQC, SharePoint, PowerPoint,

Project

Database DB2/400, HANA, SQL Server 2008 R2, Oracle 9

Operating Windows 2000/XP/NT, IBM OS/400, System/38, System /36,

Systems Opti-Connect for AS/400, IBM Compatible PCs, Unix.

Languages SQL, CL, CLLE, QUERY, SDA, DFU, EDI/400 from PREMENOS,

DBU/400, iSeries access (Client Access), RPG Free, SQL

Stored Procedures, RPG IV, RPG III, COBOL/400, C, PASCAL,

FORTRAN 77, MS-COBOL, PCL5, UDK.

Education:

. Bachelor of Science in Electronics & Communications

. P.G.D.C.A (Post Graduate Diploma in Computer Applications)

Experience:

Pfizer Inc., Collegeville, PA

10/2008 - Present

Lead Consultant - SAP Data Migration

Data mapping, Extraction, Cleansing, Transformation and Migration to SAP

EnvironmentSAP R/3 (ECC 6.0).Used BackOffice tool set functionalities of

-Cranport, Data staging warehouse, Data Construction Server, Data Garage,

EzMap, Data Dialysis, Data Profiler, Data Governance (cApps), Security,

Admin.

Responsibilities:

. SAP Data Migration for 5 Go-Lives - Migrate data from various legacy

systems like MAPS, RCS, ESCIS, BPCS, GFSS, COMPUTRON, SUN to SAP R/3

. Led SAP Data migration team for Legacy data analysis, Materials Master /

Transactional data collection, extraction, cleansing, harmonization, and

transformation to load into SAP

. Interacting with legacy business users to understand business process

flow, business logics and assess major data objects, data volume for data

migration

. Working with business users/owners to gather data migration requirements,

design data mapping documents, and define business rules for cleansing,

and transformation requirements

. Collection of master data requirements to be processed in SAP, Provide

parameters for identifying obsolete / inactive records

. Usage of Cransoft for data extraction, governance, and transformation

. Review of specific data elements like UOMs, Weights, Dimensions, Lead

Times, BOMs etc.

. Interact with functional consultants to understand configuration and data

requirements for SAP load

. Worked on Material Master, Inventory, Bins, Warehouse Management,

Purchase Orders, Purchase Info Records, Source Lists

. Creating Source tables, Target tables, Source rules, Target rules, Views

and usage of SQL functions, BackOffice - defined functions for data

extraction cleansing

. Prepare and extract data from legacy systems to load into CransoftData

staging warehouse Migration Toolset

. Develop data construction WebApps in Cransoft for the data not available

in legacy systems

. Creating temp work tables from SAP core tables for data pre/post Go-live

validation for Testing, Quality and Production clients

. Develop data reports for the business to identify and drive data

cleansing and remediation efforts

. Created remediation rules to temporarily fix data problems in a more

rigorous, seamless way

. Interfacing with key business and project team members to facilitate

seamless execution of data migration

. Defined Cut-Over requirements for conversions and coordinated with Cut-

Over team before Go-Live

. Documenting data extraction, cleansing and migration processes

Environment: SQL Server 2008 R2, BackOffice tool set functionalities of

-Cranport, Data staging warehouse, Data Construction Server, Data Garage,

EzMap, Data Dialysis, Data Profiler, Data Governance (cApps), Security,

Admin.

Pfizer Inc., Peapack, NJ 01/1998

- 09/2008

Sr.Consultant

MAPS (Manufacturing, Accounting & Planning system) was developed to provide

a structured manufacturing tool for Pfizer Pharmaceuticals. This system

fully integrates AR, AP, GL, and other financial requirements with

distribution management and a complete manufacturing suite which provides

support for inventory controls, materials management, manufacturing (MPS,

MRP, BOM, Budgeting, Capacity Planning/Routing, Costing, Purchasing, Shop

floor control etc.), and project accounting. At the base of the financial

modules is a flexible internal control system that helps organizations meet

critical new compliance regulations with maximum security meeting FDA,

Sarbanes-Oxley.

Responsibilities:

. Extensively worked on Software Development Life Cycle of this (MAPS)

Enterprise application.

. Responsible for design and development of several additional and

supporting key systems such as Regional Procurement, Vendor Management

and Contracts, VMI, EDI, Web Approvals and ASL Matrices. Development of

these products and systems included extensive use of RPG IV, CL

. Design and development of financial reports, analytical reports using

Cognos 8 BI and Cognos Impromptu/Framework Manager, Report Studio.

. Supported financial systems - Oracle Financials (O2C, P2P, R2R),

Computron (P2P, R2R)& Sun business suite (P2P)

. Train End Users

. Validation of development using a variety of methodologies (CFR21 Part

11, GXP, SOX)

. Warner-Lambert & Pharmacia Integration and J&J Divestiture of MRP

application and databases

. Provide training on Pharmaceutical Manufacturing Financial application

and integration with Oracle / Sun / Computron Financials

Environment: SQL/400, DB2/400, CL/400, RPG/400, RPG IV, JAVA1.4.2, COGNOS

7.3/8, ERwin, Visio

Copeland Companies, Brunswick, NJ

05/1997 - 11/1998

Consultant

Copeland Companies' business objective was to sell stock as part of their

401(K) plan. In order to execute this objective, my role was to consult and

oversee development of many key systems.

Responsibilities:

. Design and develop custom Company Stock Price Calculation module.

. Develop Deduction Program to enable stock to be purchased from employees'

payroll system.

. Design and develop custom Self-Directed Company Stock Orders application

. Developed reporting to summarize Company Stock Activity and Transmission

records.

. Managed Development of key projects and software enhancements such as

Gold Track Fixed Income Fund responsible for expanding database and

program specifications.

. Developed a direct deposit system for Commonwealth of Pennsylvania Direct

Deposit program that included creating and innovating database

architecture to storing and reporting specifications.

Environment: SQL/400, DB2/400, CL/400, RPG III, RPG/400, COBOL/400, RLU,

FTP

Delphi Information Systems, Burlington, MA

06/1995 - 04/1997

Consultant

JHAdvantage is a holistic, fully integrated enterprise insurance

administration system for the Property and Casualty industry. Its

comprehensive design allocates all the functionality needed to process a

carrier's claims, policy administration, rating, quoting, and accounting

needs.

Data only needs to be entered once and all related policy information such

as policyholder details, documents, etc., are linked for easy system-wide

access of all data. This design lends to a simple, logical end-to-end

workflow which helps guide users to the correct screen while automatically

creating necessary follow-ups items, work assignments, and tracking

indicators.

Responsibilities:

. Design and development of Prospect/Client management, Submission and

quote generation, Claims settlement, Reinsurance, Document generation

modules

. Develop BIS User Security that controls and maintains security of

companies' business online environment.

. Develop various conversion, maintenance and supporting applications to

assist Delphi in executing business objectives.

Environment: SQL/400, DB2/400, CL/400, RPG III, RPG/400, RLU, SDA, PCL5,

UDK

SQL Ltd., New Delhi, India

10/1994 - 04/1995

Sr. Programmer

Integrated Hospital Management System - This system covers a wide range of

hospital administration and management processes, and provides relevant

information across the hospital to support effective decision making and

future business planning. The system also incorporates advanced diagnostic

practices and delivers key tangible benefits to clients across India.

Responsibilities:

. Involved in design and development of many modules like payroll, account

receivable, accounts payable, material management, drug inventory, drug

orders, drug expires, patient billing and collection.

. Maintenance of existing modules

. Developed key MIS reports

Environment: SQL/400, DB2/400, CL/400, RPG III, RPG/400,COBOL/400 Crystal

reports

Baker Oil Tools Inc., Singapore

03/1994 -10/1994

Consultant

Production Planning and Control - This system is concerned with planning

and controlling all aspects of manufacturing, including materials,

scheduling machines and people, and coordinating suppliers and customers.

Responsibilities:

. Design and development of master modules like Bill of capacity, Bill of

lading, Packing Slip and Box List

. Involved in maintenance of Material management, Account receivable,

Accounts payable modules

. Developed key MIS reports

Environment: SQL/400, DB2/400, CL/400, RPG III, RPG/400, Crystal reports

Contact this candidate