SUMMARY

• 20 years of experience in building Data and Analytics product to drive organization data strategy.
• Expertise in architecting and implementing data integration layers, databases and end - to-end Data Warehouse to help enterprise be data driven in their decision-making.
• Proven people, data management & project management skills to implement Business Intelligence initiatives for Fortune 100 companies in domains like Retail, Prescription Benefit Management (PBM), Health Insurance, Media, Finance and Banking.
• Well versed working in different facets of the Data Management like Data Quality, Metadata, Reference data, Data Architecture, Database Technology and DW/BI.
• Experience developing lean, high performance teams that deliver value and excellence by continuous improvement & process improvements.
• Create Enterprise Data Strategy and educate/mentor cross-functional business partners on Enterprise Data Architecture guidelines and best practices.
• Manage and develop talent by creating engaged, inclusive, diverse and empowered teams.
• Expert Data Analyst deriving value from dataset using SQL, Trend, Variance, Regression, Pareto & Correlation Analysis; expertise in defining and measuring KPI for the datasets.
• Experience working on ETL/ELT, Data Lake and cloud platforms like AWS and Azure.
• Well-versed managing teams in different project methodology - Kanban, Waterfall and Scrum.
• Excellent conflict resolutions & negotiations skills; possess good inter-personal, written and oral communications skill.
• Expert Data modeler - creating Conceptual, Logical and Physical data models for different OLAP/OLTP Databases. Proficient architecting Inmon/Kimball Dimensional (star/snowflake) models.

TECHNICAL SKILLS

• Oracle
• SQL Server
• DB2
• Informix
• Toad
• SQL Assistant
• PL/SQL
• Google Analytics
• Adwords
• Netezza
• Greenplum
• Tableau
• TFS
• Sybase
• Hadoop
• Hive
• SQL
• HDFS
• SPSS
• CA Workload Automation
• Informatica
• Cassandra
• HANA
• Erwin
• Teradata
• AWS
• Azure
• Jira.

PROFESSIONAL EXPERIENCE

Confidential, Rochester, NY

Data Architect Manager / DW Manager

Responsibilities:

• Conduct regular 1:1 with the different Data Management team members.
• Understand Business requirements, data analysis and create BDM, logical and Physical Data Models then prepare source to target mappings to load Personal and Business Credit Card Data.
• Access the current architectural state of DW and design ways to achieve the future state.
• Collaborate with Project Manager to better align tasks/resources and strategic initiatives.
• Release management and facilitate different releases in TEST and Production.
• Influence adaption of latest technologies and responsible for overall architecture of the DW/BI system.
• Act as Test Manager prepare test plans, co-ordinate and conduct end to end functional Tests.
• Guide/Coach Data Architects/Developers/Testers on ways to improve product design & quality. .
• Implement Devops practices, and source control to support Multi-tenet development.
• Conduct Interviews, User Trainings, Hiring and Mentoring of new employees.

Confidential, Bentonville, AR

Data Architect and Scrum Master

Responsibilities:

• Lead various enterprise change management and new technology adaptation initiatives.
• As an Agile/Scrum champion enforcing lean, value stream mapping, Devops coupled with Automation continuous integration, continuous deployment to improve speed of the product delivery.
• Improve the different processes and overall delivery of the teams by defining new metrics, measuring and analyzing it for improvements. This has improved teams SLA’s, reduce incidents, improved MTTR, resulting a much-satisfied customer; changed from reactive to a proactive mindset.
• Architected Enterprise Data Warehouse and built Data marts like - Incident Ticket Queue Analysis; Inventory SKU (store-item) analysis; Samsclub.com online order processing, Truck load optimization (TLO) and Freight management. Dashboards (Tableau) and KPI Reports generated which would help operational floor manager and Upper management to make strategic decisions.
• Research various new technologies/databases for different applications
• Create designs for building integrated single customer view to enable Omni-channel Strategy.
• Collaborate with Enterprise Data Platform Counseling group provided invaluable platform recommendation based on data standards and governance strategy, resulting in huge savings (> $10M)
• Track the Members journey and identify data touch points in SAMS Club. Use those data elements to generate different propensity scores for members to run focused/member centric campaigns. This played a major role increasing the Sam’s club membership and traffic jump from negative 0.5 to 3.6% year on year.
• Create NoSQL/Cassandra table designs for the POS applications.
• Conduct logical and Physical Data model reviews for the team and deliver solutions speed-to-market.
• Collaborate with Azure Architect to help migrate Data marts to Azure Cloud.

Confidential

Sr. Data Architect and Team Lead

Responsibilities:

• As chief Liaison between business and technical team built a stronger relationship and collaboration.
• Delegate tasks and set clear goals/deadlines and metrics to measure the effectiveness.
• Create conceptual, logical models, and physical objects with technical design specs to load tables.
• Architect, implement and support retail and institutional subject area marts to help IC build new innovative sales campaigns and enhance client/prospect business opportunities.
• Single point of contact for technical/resource escalations for all development/operation issues.

Data warehouse Architect

Confidential, Richmond, VA

Responsibilities:

• Build DW from scratch to support different reporting requirements to its state clients, and to help transform the business of Magellan from a Medicaid Administrator to a PBM.
• Lead a team of Data Modelers and ETL Developers to build this EDW platform using IBM’s industry standard models and create roadmaps to Implement the domains like Claims, Member, Provider, Rebates and Insurance plan.