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.

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.

Confidential, Chicago, IL

MDM Architect

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.

Confidential, Boston, MA

Informatica Developer

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

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.