ESHA JHA

Sr Data Architect Data Modeler

adxiem@r.postjobfree.com 908-***-****

SUMMARY OF QUALIFICATIONS

Over all EIGHTEEN years of work experience in Data Warehouse and BI solutions for enterprise and individual business units.

Key Responsibilities: Data warehouse architecture, data modeling - Star/Snowflake, ETL, Data Management, Data Governance, Project Management, Reporting, Presales, POC/Due Diligence, Costing and resource Management, Data testing and reconciliation.

Worked as a Data Architect on Insurance Property and Casualty Domain - Coverage, Claim, Policy, Payment and Recovery, agreement, Deductibles, FNOL.

Major projects highlights - CJAMS, Data Obfuscation- P&C, Customer Data Hub, BLU lake implementation with RVC Vendor Universe, ERP and Finance Data mart, FD Risk and Compliance Fiserv.

Experience in Operational Data Store and data integration processes/procedures. Worked on Industries such as Healthcare, Insurance, Banking and Investments, Properties, Retail, Payments and Cards, Capital Market. Customer assistance.

TECHNICAL SKILL

ETL: SSIS, Informatica, DataStage, ADF.

Visualization: Tableau, Quicksight, Cognos, Power BI.

Analysis: SSAS.

Database: SQL server, DB2, DB2 BLU, Oracle, PostgreSQL, Azure SQL Database.

Cloud: Azure, AWS.

Methodology: Agile, Waterfall, saFe.

Data Modeling Techniques: Top Down (ER), Dimensional Model (star/Snowflake) Model, Canonical Model.

PROFESSIONAL EXPERIENCE

Aug ‘22 - Present MDThink

Data Architect/Data Modeler Maryland Work from Home

Responsibilities:

Closely work with the development team and business to understand the new requirement and implement the modeling changes to adept in both report design and application design.

Analysis of CJAMS application - Child Welfare, Adult services, Enrollment and Entitlement (Property and Casualty) enrollments.

Reverse engineer CJAMS application model using Erwin perform gap analysis in the application design by identifying missing primary /foreign /unique keys in the table, missing check constraints, not null constraints.

Created a standard data modeling template with naming standards and domain standards in Erwin to be further leveraged by the fellow data modelers. Created centralized repository to save models. Created reusable mapping template in ERWIN using bulk editor.

Create Foster Care and Adoption reports. Create Data Model- star schema and ER model. Create Leadership Dashboards. Create enterprise level Data Dictionary and Business glossary. Create Mapping document for ETL team.

Train the existing team. Plan Project Roadmap. Created a data lineage.

Nov ‘21 - Jul ‘22 Atos All State

Data Architect/Data Modeler - Jacksonville, FL

Responsibilities:

Analysis of data on Property and Casualty Domain, Data obfuscation Drive wise. Create and manage Data Model and Data governance Standards at the enterprise level. Create ETL Standards, Data dictionary for ETL dev team.

Create dashboards and precented reports. Create and maintain data model and data mart for property and casualty reporting capturing policies, coverages, casualty liabilities, beneficiaries, agreements, deductibles and so on.

Nov ‘20 - Oct ‘21 Fiserv

Data Architect/Data Modeler New Jersey

Responsibilities:

Responsible for managing hybrid cloud-based setup by Implementing Azure IaaS Service Model to create FD Risk and Compliance Datawarehouse platform to manage growing cloud-based ecosystem for data storage and real time analytics support.

Create and manage data models. Established Azure SQL Data warehouse solution and created ADF pipelines and SSIS on prem jobs to load data from BLOB to Azure SQL. Worked with API developer in establishing the function to securely transfer data from source to cloud.

Closely worked with business in refining the requirements. Developed reports on cloud Tableau. Create property and Casualty Full Fiserv Advanced insurance programs application model and reports.

May ‘19 - Aug ‘20 Northern Trust Bank

Data Manager Chicago

Responsibilities:

Worked as a release manager for MDM releases 13 and 14. Worked with product owners in creating and releasing requirement specifications. Create Data Analysis report for MDM and downstream applications.

Create and enforce Data governance rules. Collaborate with Data Stewards and product owners to enforce the governance. Work with Downstream application to discover the new change impact. Provide release estimates, risk and mitigation plan and release updates to business stake.

Apr ‘16 - Mar ‘19 Daimler Trucks North America

Data Architect/Data Modeler Portland, Oregon

Responsibilities:

Create enterprise Datawarehouse solution for DTNA. Create a data mart for RVC universe Management. Worked on Data profiling, Meta Data Management, enterprise data modeling, enforcing data standards, creating data dictionary for ETL team.

Create ETL standards and ETL packages. Create pre-canned and ad hoc reports.

Sep ‘13 - Jul ‘14 Syntel

Data Architect/Data Modeler India

Amex Atos

Responsibilities:

Develop, Manage, and enforce Data model, data model templates and guidelines, domain, and naming standards. Train junior Data modelers. Create and implement Data Governance strategy, best practices, guidelines, Meta data management.

Aug ‘14 - Mar ‘16 Syntel

Data Modeler / Architect Edinburgh, Scotland, and India

Standard Life Investment Atos

Responsibilities:

Worked for Alloy TA migration project. Performed Data analysis, gap identification, pre migration checks of existing environment - tables, stored procedures, reports. Created Mapping for migration. Performed Data migration. Creates post migration Sanctity reports.

May ‘13 - Aug ‘13 Syntel

Technical Architect

Memphis FedEx

Responsibilities:

Due diligence of existing enterprise wise data warehouse, reports, and models. Provided Gap analysis and fixes. Performed SWOT analysis, identified data issues and provided estimates for enhancements.

Nov ‘12 - Apr ‘13 Oversite LLC VSERV Business Solution

ETL Architect Denver, CO

Responsibilities:

Created ETL package, ETL standard. Created technical design document and test cases. Created reports.

Nov ‘09 - Oct ‘12 Emaar Group on Company

Datawarehouse Manager Dubai

Responsibilities:

Created enterprise Datawarehouse solution for emaar properties, malls and retains. Created Enterprise data model, data profiling. Reporting marts for finance, properties, and retails. Executed pilot MDM project in entire gulf - setup survivorship rule, MDM model, dedup strategy.

Created pre-canned reports for business. Supported data related queries and changes. Educated business and data stewards for ongoing maintenance of data. Implemented Data governance across Emaar.

Feb ‘09 - Oct ‘09 Emirates NBD Bank Dicetek LLC

Business Analyst Dubai

Responsibilities:

Created stored procedures and ETL jobs to migrate data from equation to Finnacle. Created mapping between equation segments and finnacle segments. Performed pre migration checks, post migration checks. Created reconciliation reports such as Balance Sheet and profit and loss.

May ‘08 - Jan ‘09 SafeNet

Document Manager/Technical Writer India

Responsibilities:

Created product documentation such as release notes, SDK, help documents using RoboHelp and MedCap Flare.

Feb ‘05 - Apr ‘08 Birlasoft

Software Developer India

Responsibilities:

Worked as an ETL developer and data modeler for GE projects such as GE money, GE confirm, GE NBCU. Worked as DBA for redbrick - Database backups, role creation, performance tuning. Created ETL jobs in DTS, SSIS, DataStage.

Did presales work for all GE clients where provided technical solution, estimates and approaches.

EDUCATION

Master of Computer Application, from Birla Institute of Technology, India, ‘02 - ‘05

Bachelor of Computer Application, from Birla Institute of Technology, India, Jun ‘99 - May ‘02

TRAINING

Executive Program in Business Management from Indian Institute of Management, Lucknow Jan ‘15 - Feb ‘16

Contact this candidate