SUMMARY:

• Accomplished Business Intelligence and Data Warehousing professional with 15+ years of success delivering solid enterprise data management and business intelligence (BI) solutions for health care, insurance, financial, and retail organizations; adept at driving
• ETL processing, achieving superior levels of data quality, and leading all data warehouse processes involving requirements gathering, use cases, and business process models.
• Versatile and reliable project leader; work effectively with local and offshore resources, global stakeholders, and vendors, and adapt readily to cross - functional group environments.
• Highly motivated and performance driven; noted for going above and beyond to guarantee project success and ensure complete customer satisfaction.
• Enterprise Data Warehousing (EDW)
• FDA regulated systems at Pharmaceutical (Astellas and Separacor). CFR 11, ICD 9 and MDDB ( Confidential ). Clinical data movement ( Confidential )
• Advanced Data Modeling
• Source-to-Target Mapping
• Star Schema-based Data Marts
• Software Development Life Cycle (SDLC)
• Requirements Analysis & Documentation
• Business Case / Use Case Analysis
• Defect Identification & Resolution

TECHNICAL SKILLS:

Platforms: Linux, Unix, Windows

Tools: Hadoop Architecture, Cloud architecture for AWS, MDM Hub, Business ObjectsDreamweaver, Erwin, Informatica, MS Office Suite (Access, Excel, PowerPointVisio, Word), Oracle, Netezza

Programming: ETL, IBM DB2, SQL, Teradata, XML / XSD

PROFESSIONAL EXPERIENCE:

Confidential, Arlington Heights, IL

Manager, Data Services

Responsibilities:

• Data Governance for Bigdata environment at Confidential . Define the process and documentation for projects to move the SAS and Cognos data into Data Lake and to Amazon cloud (AWS) in UK. Analyze the SAS datasets for lines of businesses.
• Master data for customer. Add US customer data to global master data hub (MDM Customer) and match it with the golden records. Send the matched master data to the data lake.
• Help project teams with the Ingestion process in Hadoop data lake.
• Data migration from legacy systems to the new Hadoop cluster.
• Worked on a proposal for HSBC for Hadoop data repository for client information from 13 regions.
• Data integration into the cluster from different country source systems.
• Data segmented and mined based on lines of business as permission to move data was only granted for one line of business.
• Data across borders needs regulatory approval. Worked on the architecture, especially the folder structure and access to the right users.

Confidential, Chicago, IL

Senior Modeler

Responsibilities:

• Design and create a new database for ad hoc query submission to the Insbridge rating engine by the business.
• Create logical and physical dimensional model of the new PRIA database ( OLTP) to store the request and the XML’s in Oracle 12c database.
• Supervise and mentor an offshore team to deliver the project on time and within budget.

Architect

Confidential, Chicago, IL

Responsibilities:

• Created functional design documents for the phase 2 of the master data management project around location domain. The project is leveraging SAP MDM’s capability.
• Helped the testing efforts by being part of the test case creations and monitor the executions.
• Implemented the golden record creation in phase 2 by following the established guidelines in phase 1. Lead an offshore team involved in technical design.

Confidential, Bloomington, IL

Data Architect

Responsibilities:

• Supervised Data Designers for the STG project. New billing and payments system would go on their e-commerce platform facing policy holders. The e-commerce platform had to be 99.9% available.
• Data integration and migration from legacy policy and billing systems to the new system.
• Lead an offshore team with Gap analysis work.
• Lead data integration effort for the new billing and payments systems - Majesco Mastech’s STG. (OLTP system for payments)
• Identifying the gaps and creating architecture decision documents to resolve the gaps.
• Participating in architecture decisions meetings and taking ownership of Action items.
• Leading meetings with business to resolve business requirements issues with existing functionality of the new system.
• Implementing scalable solutions which aligns with Confidential ’s target architecture.
• Integration points with different systems within the Confidential and getting data from systems of record for customer, documents, and enterprise values.
• Work with Enterprise Service Bus team to establish new services for SOA architecture.
• Resolve data replication and governance issues and align the solution with target data architecture.

Confidential, Deerfield, IL

Data Warehouse Architect

Responsibilities:

• Collaborated effectively with internal stakeholders, external consultants, vendors, and offshore team to complete tasks and deliverables on schedule.
• Drove SDLC process improvements and defined relationship between application development and support vendors, leading to smoother project hand off.

Informatica Developer

Confidential, Boston, MA

Responsibilities:

• Created new Informatica workflows and Master Data Management to facilitate vendor change for client; utilized SQL to understand source tables and create target tables in test environment.
• Conducted meetings with business to understand existing data mappings and created design documents for new mappings and workflows.
• Created new hierarchy for product tables in data warehouse, along with Star Schema for sales group.
• Ensured insurance data was parsed to data warehouse tables in compliance with HIPAA and patient privacy rights.

Confidential, Deerfield, IL

Data Architect

Environment: Windows, Visio, PowerPoint, XML / XSD, Oracle HTB database, HL7 v3, Clinical Document Architecture (CDA)

Responsibilities:

• Proposed design changes that streamlined data flow for batch process.
• Earned recognition as self-starter able to complete assignments with minimal supervision; ramped up to speed quickly to make immediate contributions to existing projects.

Confidential, Libertyville, IL

Data Architect

Environment: Planview, SQL, Dreamweaver, Excel, Business Objects

Responsibilities:

• Joined multiple tables, functions, aliases, aggregations, and nested queries to generate reports for review by high-level IT Steering Committee.

Confidential

Data warehouse Architect

Environment: Oracle, SQL, Ascent, Initiate, Teradata

Responsibilities:

• Completed business analysis, data analysis, data architecture, and data warehousing projects for major customers in insurance, IT, pharma, and retail, culminating in role as Business System Analyst supporting NextGen claim enhancements and implementation of cloud computing for Allstate Insurance.
• Met with developers and project stakeholders to lead kickoff meeting, secure buy-in commitments, and share group vision. Gathered business requirements and rules, and defined project goals, team roles, and key deliverables; mapped out timelines, milestones, and communication processes.
• Provided Master Data Management (MDM) of policy data, created business scenarios, participated in building, and validating test environments, and guided implementation of data into test environment.
• Performed functional, regression, and usability testing; verified test results, and served as SWAT Coordinator to troubleshoot test environment problems and ensure maximum availability.
• Worked with broad range of insurance data including provider information, bodily injury claims, EOBs, payments to providers, recurring payments, billed / allowed amounts, Current Procedure Codes (CPT), and diagnosis.

Confidential

Data Warehouse Architect

Responsibilities:

• Organized meetings to form data governance process and gather requirements, created business requirement document, performed master data management, and performed data mapping, modeling, and integration for ODS system.
• Analyzed Medispan Drug Database (MDDB), a comprehensive list of all drugs with National Drug Code (NDC) and Universal Product Code (UPC), worked with drug utilization reviews (DUR), and incorporated ICD-9 codes into database.
• Conducted two-day workshop on data modeling attended by 75+ participants.