SUMMARY

• Over 20 years consulting experience in providing Software, Architecture and Data Solutions. Have leadership experience inn leading medium sized teams to deliver data solutions in various industry verticals. Extensive experience in pre - sales, solution presentation, project initiation and delivery of end to end solution.
• 15+ years Data Analysis / Data Architecting/Data Modeling experience, including responsibility for all aspects of scope-,SDLC time-, cost-, quality assurance- and risk-management
• Analyzed, Designed, built, and managed multi-tiered enterprise data warehousing and decision support systems
• Possessing end to end process understanding, enterprise visionary and have proven experience in solving complex data problems enabling business to make better decisions
• Experience with current state data solutions and engaging stake holders to provide state of the art data solutions

PROFESSIONAL EXPERIENCE

Operating Systems: SCO-UNIX/ HP-UNIX: Shell Scripting Windows interface in creating OLTP applications.

Cloud: AWS, Azure

BI Toolset: Cognos, Crystal, proCube,BOBJ

Databases: Oracle, SQL Server,Teradata

Programming Languages: HTML, JavaScript, ASP, VBScript, DHTML, Transact-SQL, PL/SQL, COBOL, C, ADO, Active-X, PERL 5.0

PROFESSIONAL EXPERIENCE

Confidential

MDM lead for Customer Master

Responsibilities:

• Single View of Customer - Create “golden” customer records by reconciling names, addresses, emails, phone numbers, and other data from disparate sources for a single view of a customer
• 360-degree customer view - Expanding the Single View of Customer to include the customer’s products across lines of business (checking, mortgage, IRA, auto loan, etc.)
• Extended customer view - Expanding the 360-degree customer view to reflect the bank customer’s network of people, business, and product relationships can help customer teams pursue long-term, multi-generational value
• The three major business objectives which were met due to this successful implementation were
• Build a MDM strategy to bring in Customer data across disparate sources. Build trust based rules engine to govern the Master Data. Create and implement a multi party / business unit data stewardship process.
• Implemented a multi-domain reference data management capability that provides consistent, validated, well-formed and well-governed reference data, for all reference data domains (classes) owned and managed by Back Office IT.
• Responsible for putting in place Future State Vision for data to accomplish the following

Confidential

Data Governance and Management

Responsibilities:

• Identify a customer across multiple sources, by matching various identifying attributes of a customer such as name, address, phone, email, SSN, etc
• Probabilistic (fuzzy) matching - consider changes in attribute values due to spelling errors, phonetic differences, nicknames
• Deterministic matching - match based on pre-defined rules that are based on data profiling and source system specific information.
• Construct a golden view of the customer by assembling attributes from the matched source records according to pre-defined rules such as trusted source, most current attribute, etc.
• Publish golden view changes to consuming systems.
• Identify, construct and manage customer hierarchies and relationships, with the help of third party reference data. Major business objectives which were met:
• Reduced Failures or Delays for Orders, Trades, Confirmations, Settlements and Payments through elimination of incorrect account - client linkages
• Increased Straight Through Processing (STP) levels and Program (algorithmic) Trading - this is achieved in combination with an instrument / security (product) master, counter party master
• Timely and Accurate Operations and Financial Reporting by reducing reconciliation effort between financial ledgers and client master
• Elimination of incorrect or duplicate mailings

Confidential

Big Pharma Customer Alignment

Responsibilities:

• Leading data scoping sessions to identify various new data sources like DTHCP, Synergy(Opinion Leader), eSP, DCT( Data Capture), iPlan, Trecnet data to be consolidated in the DW.
• Facilitating stake holders and vendors meeting to finalize requirements and reach consensus.
• Organizing workshops for stake holders and business users for solution buy in.
• Establishing procedures for client data identification and tagging.
• Reviewing Master Data Management processes and making recommendation to streamline new processes being implemented to bring in new data sources.
• Reviewing Customer Master and making customer model recommendations including who or what should be represented in the customer master, customer relationships, types of addresses, contact information and other customer master attributes
• Designing conceptual, logical and physical models of different new dimensional and fact tables and validating design with user groups.
• Established procedures for data quality checks for existing and new data feeds..
• Gathered requirements for new reporting structure and data access frequency to determine load balancing.
• Designed and implemented changes in alignment process to handle multiple alignments for both outlet and retail customers.
• Establishing data governance rules and guidelines for data integration collected from disparate sources.

Technology Stack: Oracle 11g,, SQL/PL/SQL Erwin, Access, Informatica, Data Flux, UML

Data Architect

Confidential

Responsibilities:

• Leading data scoping sessions to identify various data sources like IMS, NDA and internal marketing data to be consolidated in the DW.
• Established rules for data management and data quality.
• Created procedures and rules for Master Data Management for clients and products.
• Created trust rules for client data management.
• Handled regulatory change projects, changes to data governance frameworks and offshore data.
• Actively involved in fact gathering sessions to determine purpose and mission of the data warehouse.
• Formulating and presenting various solutions and educating stake holders on best practices.
• Engaging and educating clients and key stake holders in defining scope and purpose of the BI initiative.
• Performed detailed analysis for tool selection and but vs. build decisions for the DW.
• Leading efforts to establish data governance rules. Establishing guidelines for data integration collected from disparate sources.
• Validating data design with various groups who are getting feeds from the DW.

Confidential

Law Practices

Responsibilities:

• Understanding Client businesses and providing them with various solutions for their BI/BPM requirements as well as Data Governance processes and guide them to reach a consensus on the best solution.
• Conducted data requirement sessions and facilitated cross functional teams data sessions to streamline data flow and data handoff across functional teams.
• Established data strategies, data management and quality control rules for data being integrated into data warehouse.
• Formulated and documented data governance rules and procedures.
• Created and established Master Data management applications and strategies.
• Designed (logical/physical) various schemas, creating and modeling the dimensional and FACT tables in STAR as well as snowflake schemas.
• Did forward engineering in creating Database schemas from established data models.

Data Architect

Confidential

Responsibilities:

• Actively involved in fact gathering sessions to determine purpose and mission of the data warehouse. Facilitating user interviews.
• Involved in designing the Dimension and Fact tables (15 in nos.) and creating and Data models for the same and maintained the model marts.
• Involved in designing and implementing the data extraction, cleansing and load processes using PL/SQL Packages.
• Responsible for maintaining established enterprise database design principles and policies.