Candidates About

 

Tanzeem Baig

Mr. Tanzeem Baig is an accomplished Information Technology Leader offering twelve years of overall IT consulting experience in various capacities such as Functional Architect, Data Architect, System Analyst, and Data Analyst in the entire spectrum of the development process including requirement gathering, planning, fit-gap analysis, application design, configuration setup, testing, deployment and production support. He has experience in leading a team of technical/functional onshore/offshore resources and experience in conducting workshops for gathering business requirements and analyzing pain points for business and being the liaison between business and development teams. His background includes expertise in Design, Analysis and Modeling of Master Data Management (MDM) application with extensive experience in data analysis, manipulation and extraction, transformation and loading (ETL) of data for large scale, highly complex and highly normalized relational database management systems (RDBMS). He is trained and experienced in AGILE methodologies of project development (Scrum) and possesses a strong understanding of data modeling techniques, with the ability to create process flow diagrams and the ability to  read data flow and entity relationship models. He offers strong expertise in Oracle EDQ, EDQ-P, Data Quality Assessment, Data Profiling, Data Modeling and Data Analytical skills and is adept at queries, report writing and presenting findings. He has good knowledge about EDQ Integration with ODI, Siebel etc. With solid analytical skills, Mr. Baig has the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy. He is knowledgeable of statistics and has experience using statistical packages for analyzing large datasets (Excel, Crystal Reports etc.) and is well versed in server side and/or client side technologies. . He is well versed with Teradata, Hadoop, Big Data and Tableau. He offers strong experience in Oracle and in depth hands-on knowledge on advanced PL/SQL and has worked on Stored Procedures, Functions, Packages, Views, Cursors, Bulk Collect, PL/SQL Collection Types, Synonyms, DB Links, Triggers- Oracle 10g,11g and 12c. Mr. Baig possesses exceptional communication skill, as well as ability to work effectively independently or with a team.

 

 

 

 

 

EDUCATION

 

Bachelor of Engineering (Mechanical), Visveswaraiah Technological University, Belgaum, India

 

 

 

 

TECHNICAL SKILLS

 

Tools                                      Oracle Sql Developer 4.0, Erwin Data Modeler, IBM Data Studio 4.1.0.1, IBM, MDM Infosphere, Purisma 4.1.3 MDM Tool, Enterprise Architect 9.3, IBM Blueworks Live, Softerra LDAP Browser 4.5, BMC Service Desk Express SDE, Rally, OpTier, MS Visio, Toad, WinScp, Putty, MS project, IDM Filenet, Oracle PDH, OEDQ 11g and 12c, EDQ-P, Siebel UCM, ODI, PL SQL Developer, Fusion Middleware12c, WebLogic 12c, OBIEE

Technologies                        PL/SQL, Shell scripting (basic), VB.NET, ASP.NET, Silver light, EnterpriseLib 4.0, MSMQ, Aspose

Databases                             Oracle 10g, 11g, 12c, MS Access, SQL Server

Reporting/ETL Tools        BO XI R2, Crystal Report 11.5, SSIS, IBM Infosphere DataStage 8.5

Version Control Tools       VSS, TFS, SharePoint, CA Harvest Software Change Manager, JIRA,GitLab

Methodologies                     Waterfall, Agile, RDBMS

Issue Tracking Tools           Clear Quest, HP Application Lifecycle Management Quality Center,ITSM

Scheduling Tools                Autosys, Indesca

 

 

 

 

 

 

CERTIFICATIONS

 

Domain and Quality           AICPCU/IIA Certification- INS 21 (Property and Casualty) 

AICPCU/IIA Certification- INS 22 (Personal Insurance) 

Technical                              070-526 TS Microsoft .NET Framework 2.0- Windows Based Client Development

070-528 TS Microsoft .NET Framework 2.0- Web Based Client Development

070-480 Programming in HTML5 with JavaScript and CSS3

070-506 TS Silverlight 4, Development

070-573 TS Microsoft SharePoint 2010, Application Development

Lynda.com                           Data Analysis on Hadoop

Data Science and Analytics Career Paths and Certifications

NoSQL for SQL Professionals

Tableau 9 Essential Training

Techniques and Concepts of Big Data

Transitioning from Data Warehousing to Big Data

Up and Running with NoSQL Databases

Hadoop Fundamentals

 

 

WORK EXPERIENCE

 

New York State ITS-CTO (Albany, NY)

EDQ Data Quality Architect

January 2017 – Present

 

 

·         Provided technical, functional and configuration expertise of the Oracle Enterprise Data Quality(OEDQ) to support enterprise operation and growth  

o    Installed and Setup OEDQ 12c on Fusion Middleware/WebLogic platform in compliance with Oracle pre-defined standards and considerations.

o    Configure and setup OEDQ Customer Data Services Pack.

o    Develop Customer Data Profiling as a Service used for data profiling, auditing, cleaning and matching various NY State agencies data.

o    OEDQ Address Verification Server Installation and Setup with Loqate data for address validation needs.

o    Integrate OEDQ with Siebel UCM 8.2 and Oracle Data Integrator 12c.

o    OEDQ User Setup, Security, Administration, Upgrades and Release Management

·         Installed and Setup ODI 12c and OBIEE 12c on Fusion Middleware/WebLogic platform

·         Worked on SSL Setup and Active Directory Integration for OEDQ, OBIEE  and ODI on Fusion Middleware/WebLogic platform.

·         Document and prepare workflow charts, architecture and deployment documents per Fusion Middleware/WebLogic High Availability architecture

·         Responsible for making sure the Industry Best Practices are followed

 

 

 

 

 

 

 

 

 

Ascension Health (St Louis, MO)

EDQ Consultant

August 2016 – January 2017

 

 

·         Worked on design and development of Oracle Enterprise Data Quality (EDQ) module which was part of the MDM initiative that also included Oracle Product Data Hub (PDH) and Product Extensions (EDQP)

o    Load, enrich and audit inbound Share-point based Item Master and Contract Data before populating to PDH

o    Perform Matching and deduplication to provide cleansed data to PDH and EDQP

o    Integrate the EDQ Jobs with TIDAL scheduler

·         Lead on EDQ Performance improvements which included data streaming, parsing and matching performance options

·         Led the discussions and helped the MDM team in defining business rules, profiling rules, cleansing rules

·         Help in preparation of the various iterative plans and test plans for the profiling and quality related aspects

·         Document Data Quality Functional and Technical Design Documentation

·         Provided Production Support during post implementation of projects for the period of warranty.

 

Eaton (Cleveland, OH)

MDM EDQ Functional Consultant

August 2015 – July 2016

 

·         Worked on multiple projects as part of the “FE4 - MDM” program that included

o    Full cycle implementation of MDM PDH for Hydraulics and Golf Pride Businesses

o    PDH Syndication project for enabling data syndication to Eaton distributors

o    Working with Vendor for Syndication POC with Informatica Product 360 as Omnichannel solution

o    Creating Process Flows as part of PDH to PLM Integration project

·         Generated EDQ reports using the OOTB EDQ Capabilities of data cleansing, deduplication, merging, matching.

·         Optimized their efforts to utilize EDQ in matching source data oracle to target data and decrease the amount of time that is being spent on manual batch processes

·         Led the discussions and helped the MDM lead in defining business rules, profiling rules, cleansing rules

·         Help in preparation of the various iterative plans and test plans for the profiling and quality related aspects

·         Partnered with the business teams and Customers to identify opportunities for accomplishing the business and strategic objectives.

·         Managed changes to baseline requirements through effective application of change control processes and tools

·         Coordinated user acceptance testing, plan/coordinate deployment, design appropriate measures to report on success and client user acceptance of technical implementations testing and ensure customer satisfaction.

·         Provided Production Support during post implementation of projects for the period of warranty.

 

 

Erie Insurance Group (Erie, PA)

MDM ETL Systems Analyst

May 2014 – July 2015

 

·         Involved in Planning, Design, Scheduling and Execution of multiple work streams to support the Agent Identity solution using the IBM MDM Party Model

o    Load sole-proprietors as individuals in MDM

o    Create fields for individual contact information in MDM

o    Extract specific data from Agent Master(Legacy Mainframe Agency application) and load it in MDM

o    Load not-appointed Agency employees into MDM

o    Support the real time synchronization program

·         Single handedly designed and developed the initial load and an ongoing daily sync ETL solution that extracts data from Source table (Oracle) and populates an existing set of target staging tables (Oracle).

·         Identified, analyzed, and interpreted trends or patterns in Agent Suspect Matching Engine to redefine the match rules.

·         Continually modified the above solution to accommodate new business rules, new attributes, changed staging table structure thus ensuring performance metrics are within the SLAs.

·         Facilitated design workshops with key stake holders (including the in house Enterprise Architects Team and Solution Engineers) and created business specification documents (BSD) that were used by the MDM development team.

·         Plan monthly releases and coordinate with release manager using BMC Service Desk Express.

·         Played the role of Scrum Master in our agile methodology project (bi weekly sprints), facilitating daily stand ups and syncing the story board with Rally tool.

 

 

 

 

 

 

 

 

Aon Risk Services (Chicago, IL)

Infosys Technologies Ltd                                          

January 2006 – April 2014

 

Position:               MDM Solution Architect/Project Manager                                                                     July 2012 – April 2014

·         Primarily involved in analyzing and mining business data to identify patterns and correlations among the various data points involving the key entities like Carrier, Client, Product, and Industry using the OEDQ tool

·         In-depth understanding of EDQ processing including ‘profile and audit, ‘parsing and standardization’ and ‘match and merge’

·         Performed functional design and configuration and improved data quality for key master data entities - Client and Carrier hierarchies by 35%.

·         Created a data governance workflow which standardized stewardship processes and reduced time required for data governance and distribution between data source and data consumption systems.

·         Mapping and tracing data from source system to downstream applications to maintain the lifecycle of an entity.

·         Responsible for managing data and metadata migration from legacy source to destination

·         Managed requirements from blueprint to business sign-off, directly presented design in senior leadership steering committee meetings throughout project.

·         Facilitated workshops with key stake holders and converted functional specification documents into technical design documents.

·         Closely involved in the support activities that include performance tuning, job scheduling, resolving deadlocks, managing data space utilization and periodic patching of the application and database servers.

·         Involved in full lifecycle activities  including requirements analysis and design, developing analysis and reporting capabilities, and continuously monitor performance and quality control plans to identify improvements.

·         Managed a team of 10 resources offshore and 4 resources onsite (including different vendors) through redesign
and implementation of master data entities as first phase of achieving global system adoption.

 

Position:               Technology Lead                                                                                                                     January 2011 – June 2012

·         Managed a team of 5 developers and 2 Quality Analysts for the Office Upgrade project to enable ‘Bridge’ application support to Office 2007/2010.

·         Involved in the design and architecture for the solution developed in SharePoint 2010 and Silver light platform.

·         Interacted with client, gathered the requirements and steered the development effort.

·         Estimated the timelines for each change request and conducted sessions to help defect prevention.

 

Position:               Technology Analyst / Technology Lead                                                                           May 2008 – December 2010

·         Involved in complete development of the MDM framework from inception and progressed into the role of a Developer, Technology Analyst and Team Lead over the span of 3 years.

·         Developed and managed MDM application data deployment in over 30 countries.

·         Created processes to adhere to Service Level Agreements (SLAs) for Level 3 application support team.

·         Designed Commission Grid that provided negotiated commission rates with Carriers available to ARS offices nationally by certain markets, by line of business. This facilitated current systems, processes and reports to capture the total commission leakage by 31% representing $11M in annualized potential revenue lost.

·         Involved in transitioning the legacy Rosetta ETL application to the MDM framework (using Purisma 4.1.3 MDM Tool) that retired approx. 50-70% of the custom database scripts and automated the data stewardship environment.

·         Worked closely with the client, developing complex reports involving PL/SQL procedure, VBA macros and Crystal Reports.

 

Position:               Module Lead                                                                                                                       September 2007 – April 2008

·         Involved in support and enhancements of ‘Bridge’ application by leading a team for working on the Change Requests.

·         Involved in Performance Testing of the application using VSTS Tester’s Edition.

·         Involved in estimation for future opportunities that are in scope of Bridge and related functionalities.

·         Worked as a KM Prime and CC and responsible for managing KT sessions and configuration controller related activities.

 

 

Position:               Developer                                                                                                                              January 2007– August 2007

·         Implementation and testing of code changes required in the application for deploying it on Citrix.

·         Involved in fixing issues raised during User Acceptance Testing and production rollout support of the ‘Bridge’ VB.Net application

 

Position:               Developer                                                                                                                      January 2006 – December 2006

·         Contributed to development effort for ARS proposed migration of Bridge (Aon’s Policy Management System) from VB 6.0 to VB.NET.

·         Responsible for development and unit testing of key modules of Bridge.

·         Integrated Business Objects XI Reporting Framework with the new .NET application.