Data Management
Resume:
Subhash Adusumilli
**********.*******@*****.***
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