Data Manager

Email-id: ****.***********@*****.***

Phone: +1-201-***-****

Tanushree Paul

Professional Synopsis

Utilities – Retail Energy – Telecomm - Retail & Distribution - Pharmaceuticals

10+ years of strong result-oriented information management professional in designing and implementing technical and strategic solutions with a wide range of skill set, roles and industry verticals

Exposure to Utilities, Retail Energy, Telecomm, Retail & Distribution applications along with experience in designing solutions to extract data from wide variety of source system

Primary efforts focused on Architecting, designing, building, testing, and deploying business intelligence, decision support, and data warehouse solutions

Experience in designing solutions to extract data from wide variety of source system including SAP, Main Frame, ETRM’s, Flat files, COBOL Files, Oracle, SQL Server, XML Files etc.

Strong professional experience in package software development with skills in Informatica 9, DB2, Informix and Oracle database.

Liaison with Business Users and developers and bridged the Gap by acting as DWBI Architect / Technical Lead / Project Quality Lead / Production Support Lead for major business critical applications

Experienced as Onsite Technical Team Lead guiding and providing all core technical DWBI solutions to the technical development team in addition to coordinating with business, onshore and offshore development team

A Team Player with excellent leadership, analytical, organizational and communication skills.

Professional Skills

RDBMS: ORACLE (9i, 10G, 11G), IBM Informix, DB2 UDB 8.1, SQL Server

Languages: Java, Oracle SQL, PL/SQL

O/S: Windows NT/2000 Server, HP-UX 11.1, SCO UNIX

EAI: SSA OpenWorldX, WBI (WebSphere Business Integrator)

Processes: IBM’s QMS (Quality Management System),

EDP (Enterprise Development Process)

OPAL (On Demand Process Asset Library OPAL)

RUP (Rational Unified Process)

Platforms: Windows and UNIX

Tools: Informatica (6.2, 8.x, 9.6.1), IBM Datastage, IBM Business Objects XI, Oracle 10g Enterprise Manager Tool, Backend database handling using SQL Developer (Oracle 10g), Unix shell scripting, Cybermation Expresso Client, Remedy Tool, RPM (Rational Portfolio Manager),Cognos Reporting Tool, Squirrel SQL, Rapid SQL, CoreFTP, Cranberry, TOAD (Oracle 9i and 10g)

Education:

Masters in Computer Application -2006, Vellore Institute of Technology, Vellore, Tamil Nadu, India

Bachelor’s in Computer Application - 2003, St. Xavier’s College, Ranchi, Jharkhand, India

DB2 Universal Database V8.1 Family Fundamentals (701) certification

Professional Experience

Jan 16 – Till Date Lead ETL Architect Verizon Infosys Dallas, TX

EIS Migration Project: Automated migration of customer, service and ordering information from Legacy systems to newer platform of products and services using custom developed Migration Factory processes. The Migration factory supports these migrations via iterative Gather, Assemble, Transform, and Execute processes based on Informatica ETL tools.

The data gathered using files from various Legacy systems are assembled to a common schema and validated for business rules for data integrity and product parity errors. The Validated data is transformed using multiples layers of business rules and saved in a common schema for loading into the target system. After loading the transformed data, the legacy services are disconnected and the newly created services are activated.

Roles and responsibilities:

Analysis, Design, Development using Informatica PowerCenter tools - Mapping Designer, Repository Manager, Workflow Manager/Monitor and Server tools in an agile project environment.

Collaborate with business and technical teams to identify and scope the opportunities, identify risks, benefits and constraints.

Assist the management in defining and monitoring the approach for integration of the solution.

Lead Quality Assurance and Quality Control processes. Ensure adequate test coverage in Unit Testing, System Testing/Integration Testing and Performance Testing.

Environment : Informatica Power Center – 9.6.1, Oracle 11g, Networkx, WITS, LSA

Team Size : 6

Jan 10 – Dec’15 Lead ETL Developer Oncor IBM Dallas, TX

Oncor is a regulated electric distribution and transmission business that uses superior asset management skills to provide reliable electricity delivery to consumers. Oncor operates the largest distribution and transmission system in Texas, delivering power to approximately 3 million homes and businesses and operating approximately 117,000 miles of distribution and transmission lines in Texas.

ONCOR EDW (Enterprise Data Warehouse) is used for reporting and data analysis. It is a central repository of data which is created by integrating data from MDMS, LCIS, Enterprise Bus Transactions and other transactional data sources. This Data warehouse stores current as well as historical data and are used for creating trending reports for senior management reporting such as daily, annual and quarterly comparisons.

AODS (AMS Operational Data Store) is store of all transactional and operational data. AODS serves as a vehicle as well as a data warehouse for dataflow between MDMS/Head end/Maximo/LCIS and SMTP Portal/AMS Portal/ERCOT. Source systems are MDMS/ Head end/ Maximo/ LCIS. Data pushed to the systems SMTP Portal/AMS Portal/ERCOT from AODS.

As per Texas states regulatory norms, all energy transmission & distribution service like ONCOR needs to provide energy consumption of each retailer on daily basis. No application of current IT infrastructure was able to forecast energy usage before end of billing cycle. Advance metering system operational data store pulls RF meter accurate & estimated readings of each customers on daily basis at 15 minutes interval from MDM application.

Using SMTXP (Smart meter Texas portal) retailers can estimate their revenue on daily basis & regulatory body can check audit energy consumption in states. This application is also part of IBM’s smarter planet initiative.

Roles and responsibilities:

• Address Severity 1 and Severity 2 issues and ensure there is no downtime of the AODS (Advanced Metering System Operational Data Source) application

•Integrating AODS applications with Informatica using Adapters with external systems like LandisGyr the system providing Metering reads, with LCIS billing system, with MDMS (Meter Database Management System), the Rep and ERCOT(Electric Reliability Council of Texas) report generation system and the legacy IODS data management system

•Managing complete AMS (Advance Metering System) and AMIS system includes MDMS, AODS, IODS, PiPe(eMeter), TNS and Edify-IVR application and respective databases

•Requirements gathering, Designing and fulfilling custom requirements in AODS using Sun Solaris, Informatica and Oracle 10g and documenting them according to ONCOR standards and training

•Perform reverse engineering and reviewing of logs and failure in production environment and provide code fix and workarounds in live environment in the minimum duration possible

•Responsible for doing analysis on the performance of the production servers and provide PLSQL query enhancements, code enhancements, Informatica workflow redesign and database tuning solution to achieve performance targets.

•Performance tuning of data integration process.

•Database modeling, Informatica ETL mapping development and implementation of data warehousing applications with deployment and resolve any issues

•Translate customer requirements, complex enhancements into test cases; map it with efforts of efficient testing leading to Client acceptance of results.

Environment : Informatica Power Center – 9.6.1, Sun Solaris 5.0.5, Oracle 10g, IBM Informix, Cognos

Team Size : 8 to 10

Nov’09 – Jan’10, Senior ETL Developer PFIZER, IBM New York, NY

Pfizer Pharmaceuticals Group (PPG) is the leader in Pharmaceutical industry. Pfizer S4 Data Management project is a Data Warehouse (DWH) and Business intelligence (BI) project to Support Pfizer’s Sales and Marketing activities. Pfizer receives the data from different health care vendors, extract and transform them to Pfizer specified format using ETL tools and loads it into a target/delivery database. Data feeds are generated from the Target system and send to the outside vendors, BI reports for Marketing representatives are generated from the Delivery system.

As a system engineer and onsite coordinator responsible for analysis, coding, testing and updating the business requirements. Designed ETL processes using Informatica to load data between various systems, need to perform data manipulations using various Informatica transformations.

Environment : Informatica Power Center 8.6.1, Oracle 10g, Autosys, UNIX

Team Size : 5 to 8

Jun’09–Nov’09 Senior ETL Developer MERCK & Co - COMET Project, IBM Kolkata, India/NJ, USA

The COMET project was initiated by Merck & Co., Inc. as a means to implement global common business processes, common master data, and a global ERP system to support, enable, and sustain Merck’s strategic initiatives.

As Associate System Engineer at onsite customer location responsible for analysis, design, development, and testing and customer coordination.

Environment : Cranberry, SQL Server 2000

Team Size : 2 to 4

Jun’08 – Jun’09, ETL Developer TELUS, IBM, Kolkata, India / Canada

TELUS Corporation is the largest telecommunications company in Western Canada and the 2nd largest in the country. Telus provides a wide range of wireless telecommunications products and services including data, Internet Protocol (IP), voice, video and entertainment services. The desire of the project is to develop enterprise DWH.

As Associate System Engineer responsible for analysis, preparation of design documents, preparation mapping design, coding, writing PL/SQL scripts and testing. Designed ETL processes using Informatica to load data between various systems, need to perform data manipulations using various Informatica transformations.

Environment : Informatica Power Center 8.6.1, Oracle 10g, Control M, Toad, UNIX

Team Size : 10 to 15

Mar’08 – Jun’08 ETL Developer ConvaTec, Kolkata, India

ConvaTec is a $1.2B medical products company that operates in 43 countries with four manufacturing facilities – 2 in UK, 1 in Dominican Republic, 1 in Greensboro, NC. Project is to migrate their huge data to new SAP target systems by d Developing/enhancing complex jobs and sequencers using DataStage V8.1

Tools: Datastage v8.1, SAP, Unix. IBM DB2 v9.5

Nov’06 –Mar’08 ETL Developer Nestle Global IBM, India/Switzerland

Nestle was in the process of implementing SAP R/3 ERP system in more than 80 countries, with three implementations having already gone live. Nestle maintains market specific data at the local SAP R/3 implementations as well as some portion of it in the centralized SAP R/3 database on Oracle8i. Data from various disparate legacy systems needs to be extracted, cleansed, transformed and loaded into these SAP databases.

Another aspect of the job is to design ETL process for the upcoming markets in various countries falling under three zones AMS, AOA and EUR. The different countries falling under these 3 zones where ETL implementation is in progress are Poland, Thailand, Brazil, UK, Mexico, Germany, and Austria etc.

As Associate System Engineer responsible for analysis of functional specification, designing technical specification, ETL mapping design, coding, testing and training new resources. Designed ETL processes using Informatica to extract, transform and load data between various systems, need to perform data manipulations using various Informatica transformations. Designed various high efficient ETL processes for complex business processes and successfully deployed in production.

Environment : Informatica Power Center 6.2, Oracle 9i, DB2, Squirrel, UNIX

Team Size : 8 to 10

Training:

IBM Informix

Data Warehouse

Business Intelligence

IBM Datastage

IBM Business Objects XI

IBM DB2 UDB

Informatica Power center

IBM Business Conduct Guidelines Course

OPAL

Review and Inspection

Defect Prevention

Risk Management

Estimation Techniques

Function Point Analysis

Communication Skill and Ascent Neutralization

AIX-UNIX Shell Scripting

Global Services Method Fundamentals

Telecommunications Industry Overview

Information Technology Security and Controls

QPACE (Quality Process Awareness and Competency Evaluation) Level 1

Energy Industry Overview

GBS Data Security & Privacy Awareness Training

References: Available upon request

Contact this candidate