Reddy J Tupakula

Senior Data Manager and Data Governance

E-mail: ac0w9r@r.postjobfree.com

470-***-**** (PST)

SUMMARY:

Highly accomplished and motivated IT Leader with over 18+ years of contribution in individual and leadership roles involving Enterprise Software and Consulting Services, catering to a variety of different areas across many industry verticals, including Business Intelligence/Data Warehousing, Data Governance, Data Integration, Master Data Management (MDM) and ETL

18+ years of experience in end-to-end Life Cycle Design and Development of Data Warehousing Master Data Management, Customer Data and Product Data Hub groups to help analyze and then help resolve issues using Informatica and Oracle

With expertise in implementing Oracle Master Data Management (MDM) (including Customer Master Data Management (CDM), Product Data Management (PDM), Product Information Management (PIM), Customer Data Quality (CDQ) and Product Data Quality (PDQ).

Technical Manager that can build best of class teams and retain technical talent

Managed and mentored direct 20 and 25 offshore team technically to deliver business solutions

SME on building Enterprise Data Warehouse or Data Warehouse appliances from Scratch using both Kimball and Inmon Approach. Having knowledge in Data Lakes Architecture and Design experience.

ETL Architecture experience involves defining different layers (landing/staging, recovery point layers,) Complete ETL schedule and flow to fit SLA, IDQ, Power Center, mapping design, Error handling and Workflow Design on Informatica. Knowledge in ELT Processing. Hands on mainly on Informatica, guided team on SSIS and DataStage. Worked on Databases like Oracle, SQL Server and DB2

Strong expertise as solution architect designing and delivering solution deployment architecture, Infrastructure sizing, performance and scalability options, benchmarking & tuning (application, database and hardware) for test, development and production environment

Proven track record in Project Management in Traditional Methodologies and Agile Methodologies

Worked with high performance teams developing and implementing state-of-art data warehouse applications. Ability to understand (or get the customer to articulate) the business needs in terms of business value

Education:

B.S in Electronics & Communication Engineering

MS in Computer Science

Work Authorization:

Green Card

Training:

Project Management and Consulting Practices.

Corporate Governance, Data Governance and Data Quality

Best Practices in Data warehouse Performance & Tuning

MDM and IDQ Training

Technical Skills:

Data warehousing: Dimensional Modelling - Star, Snowflake, Fact Table, Dimension Table, Slowly Changing Dimension, Data Governance, Master Data Management, Metrics, KPIs, OLAP ( Worked on Both Kimball and Inmon Approach)

Domain Expertise:

oBank: Customer Master Data, Credit Card Utilization/ Disputes Tracking Analysis, Credit Management, Multiple Loans Processing, Cross Product Sales

oHealthcare/Insurance (Benefits Administration, Health, Dental, Vision, Life, AD&D, Short & Long Term Disability, Eligibility & Enrolment, Claims Processing, Patient/Provider Data Management, Pharmacy Data and Hospital Management)

oCRM (Customer Enrolment, Sales Enquiry, Sales Order Booking, Order Processing, Billing, Order Delivery, Logistics Monitoring, Service Monitoring, Customer Survey)

oSupply Chain Management (Demand Analysis, Distribution Analysis, Financial Analysis, Fulfilment Analysis, Inventory Analysis, Procurement Analysis, Allocation Analysis, and Resource Analysis, Transportation Analytics, Retail Analytics)

Languages: SQL, T-SQL, PL/SQL, XML, VB, .Net, PB, Stored Procedures and Triggers

ETL Tools: Informatica, IDQ, Power Center, SQL Server Integration Services(SSIS) and DTS

Data Modelling Tool: Erwin, TOAD and Visio

Databases: Oracle, SQL Server and DB2

Project Management: MS Office Suite, MS Project, SharePoint, MS Visio and Agile Methodologies

BI/Reporting and Analytical Tool: Cognos, SQL Server (SSRS & SSAS), Tableau and Micro Strategy

PROFESIONAL EXPERIENCE:

Loyalty Methods Credit Union of Texas Jan 14 – May ‘17

Senior IT Manager and MDM Architect

Oracle, MDM, Collibra, Informatica, Cognos, DB2, Erwin, MS Project and Tableau

Responsibilities:

Headed the data warehouse team in successful implementation of project within budget and time frame in establishing cross platform Data warehouse in the finance industry in multi-million dollar budget by converting from legacy systems.

Created Data Governance and MDM standards in the across all operational, transactional and data warehouse systems..

Initiated the MDM process and successfully completed in achieving single 360 degree view of customer and product and minimized 25% of marketing budget to promote new products

Defined, implemented and supported Enterprise BI strategy and Architecture for Enterprise level Data/

Providing best possible solution and getting it approved from Architectural Team

Providing alternate solutions or approach to improve the from the legacy systems

Providing Architectural Design to the development team, Managed 15 member IT team

Lowered software and hardware maintenance fees by 30% by reviewing the SLA and changing applications to site-licensed software

Implemented target oriented project planning in achieving business drivers and solutions

Closely interact with Vendors, business users and internal teams to make sure every process goes smoothly

Timely communication to the Project participants and management team about the progress

Improve the existing process towards more automated, reduce failure risks, improve data quality and increased resource utilization

Loyalty Methods Baylor Scott&White: Mar’ 12 – Dec ‘13

Data Manager/ Data Governance Lead

Erwin, Oracle, Informatica, IDQ, MDM, Java, Visio, MS Office, PL/SQL, and Cognos

Responsibilities:

Created Strategy Roadmap for Architecture of Enterprise Data Warehouse and Data Lakes

Defined Data Governance Standards, and streamlined MDM process in Customer, Product Services 360 Degree View.

Co-ordinated business and technical teams in meeting the time frames and tasks assignments/monitoring

Involved in setting up Enterprise Architectural Board.

Lead the team of direct 10, offshore team of 20 in successful implementation Enterprise Data warehouse with multi-million dollar investment.

Reduced the data maintenance cost by 30% by cloud based solutions and managing scalability issues

Closely monitored in converting business strategy implementation in to the enterprise data warehouse

Lead the Data Architecture and BI Team in evaluating Vendor and Products Evaluations and Selection.

Coordinated with multi-level management for different levels of approvals of the project

Analyzed complex organizational and technical issues related to technology and improved performance and efficiency

Extensively used Informatica MDM for Customer and Processes domain for data consistence. And IDQ process in ETL to load & maintains quality of data.

Loyalty Methods Verizon Jan 10– Mar ‘12

Solution Architect and MDM Specialist

Erwin, Oracle, Informatica, IDQ, MDM, SAP. Java, Arbor, PL/SQL, and Tableau

Responsibilities:

Architecture of Enterprise Data Warehouse Data Modeling and Database Design

Lead the Team of Architects in achieving the timely completion of the Data warehouse

Participated in Vendor and Products Evaluations and Selection.

Extraction, Transformation and Data Loading and Data Quality from different sources to data warehouse

Lead Informatica MDM team (Customer and Services Domains) and Data Quality process in ETL to load data.

Coordinated both in-house and offshore development teams of 25 size

Implemented data and user based security at different levels.

Cozent TD Waterhouse Aug 2007 - Dec 2009

Data Architect

Erwin, SQL Server, SAP, SSIS, SSRS and DB/2

Responsibilities:

Involved heavily in gathering business requirements, systems requirements and user interaction at different levels in for business and Report requirements in achieving logical & physical data model implementation in transactional and dimensional environment.

Initiated the Enterprise wide data consistency and data quality matrix and reduced the Operational and Capital Expenditure for marketing new products

Implemented EDW Created data warehouse data models using STAR Schema methodology using Kimball process.

Reverse engineered the data structures, provided data maps, documented data dictionary

Worked closely with DBAs and developers in technical specification documentation and implementation of business logic

Coordinated with business users and end user training and user documentation

Cozent Christiana Care Health Oct’ 04 – Jun ‘07

Solution Provider /ETL Lead

VB.Net, Erwin, SQL Server, SSIS, SQL and Cognos

Responsibilities:

Collaborated with infrastructure, data warehouse, and business analyst resources, and clearly communicated solutions to both technical and non-technical team members.

Worked closely with business analysts, IT architects, DBAs and implementing the Data warehouse

Involved in ETL process of enterprise healthcare data warehouse (EDW) to integrate clinical, financial, patient satisfaction, lab, patient registration and claims.

Lead a team of IT team size 10 in providing technical and business guidance

Monitored timely achievement of target oriented implementation of tasks

Provide management insight and actionable information into clinical performance and core measures.

Performed detailed documentation of design, development, testing and deployment activities.

Knowledge of Health Care Systems and Workflows.

EDS MetLife May’ 01 – Sep’04 Data Modeler/ ETL Developer

Erwin, Informatica, PB, SQL Server, Microstrategy

Responsibilities:

Participated in system analysis, design and development of application based on user inputs

Designed Relational Data model and STAR Schema for OLAP Reports

Expertise in supporting ad-hoc ETL, Data Governance and report requirements

Involved in ETL, BI Reports process development and documentation

4-Serv General Motors Feb’ 97 – Mar ‘01

Software Engineer

SAP, Siebel, Erwin, Oracle, Cognos, Informatica and PL/SQL

Project Description: This projects provides dealer management system for managing customer relation, vendor management, entire operations of sales process, order payments, service tracking and service logistics, SSI, CSI, inventory tracking of GM and its channel partners

Responsibilities:

Business Requirements, Analysis, Design of Database and System Design using STAR Schema

Participated in the ETL design process and Load Data using Informatica

Created and Maintained Reports using Cognos and PL/SQL and trained End Users.

Designed and developed multi-dimensional cubes and implemented security in cubes.

Enhanced existing security in cubes and reports to add new user classes.

Contact this candidate