The Hartford Insurance group has multiple product lines such commercial lines (CL), personal lines (PL), Group benefits (GB) & so on. The digital marketing uses customer emails and phone numbers collected through various channels, campaigns, surveys and input systems.

• Analyze the raw data coming from various source systems , identify the best contact points (emails or phone numbers) and send the extracts to the digital marketing team .
• Gather requirements from marketing team to source data , identify transformation rules and produce the reports
• Identify KPI and report them periodically.
• Maintain data mapping documents and data dictionaries.
• Do gap analysis between various source systems to identify best possible data artifacts for the digital marketing team
• Create rules to assign weightage to emails , consolidate & cleanse the customer , address and contact point data from source systems and across the product lines.
• Identify best possible contact channels which can be used for sending marketing Audits & surveys to customer
• Work in Scrum team to create backlog items for the development team
• Analyze data in excel

Responsibilities:

• Data analysis of Canada reporting systems, requirements gathering
• Analysis of data warehouse data model. Enhance and create new DB objects
• Shell scripting to process data files
• Create and enhance ETL Informatica components
• Create and enhance Tidal scheduling components
• Data comparison between source and integrated systems
• User acceptance testing

BofA Compliance and Risk Technology have oracle dimensional Datawarehouse environment.

Capital One EDS (Enterprise Data services) environment consists of Oracle Datawarehouse For reporting legacy data application while HADOOP environment is being set as part of BIG Data Initiative.

For Prime services Data warehouse: Data is sourced from 3 different Trading systems namely New York London and Singapore stock exchanges.

To design an analytical environment for credit mortgage data. Integrate the external systems data into main analytical environment

Data analysis from various heterogeneous source systems, preparation of extraction specification, data Profiling.

Data analysis & design: Data analysis from various heterogeneous source systems, preparation of extraction specification, data Profiling.

Understand the End users reporting requirement & their existing SOX non-compliant applications

User requirement analysis, Design & Development of Analytical Environments for various departments

Returns Inventory Data Mart

Responsibilities:

• Requirements gathering with data analysts to understand existing sql server logic
• Data Architecture, Source system data analysis, data lineage mapping, creating transformation logic mapping documents.
  • Data dictionary preparation, data lineage mapping, process flow
• Architecture of ETL process in oracle pl/sql
• Daily Stand up meetings and status review.
• Development of oracle components, packages, procedures and functions.
• Tuning of sql queries, deployment into various test environments and production.
• User support. Create complex queries based on user requirement
• Production environment tuning and support of newly developed application in production.

Responsibilities:

• • Requirements gathering
  • Data Architecture, Source system data analysis, creating transformation logic
  • Data dictionary preparation, data lineage mapping, process flow
  • ETL Tech lead. Architecture of ETL process
  • Daily Stand up meetings and status review.
  • Informatica, Mappings design and SQL server Stored Procs & Unix scriptindevelopment and deployments co-ordination
• • User support. Create complex queries based on user requirement
  • Process tuning

Responsibilities:

• ETL Tech lead , Requirements gathering
• Data Gap analysis and Master data management
• Logical and physical data modelling (Star Schema Dimensions/Facts)
• Data Architecture and gather and update the Meta data
• Informatica , Oracle Pl/SQL Stored Procs & Unix development and deployments
• ETL and DB Performance tuning. Developing adhoc queries on warehouse data
• User support