Sudarshan D.

Sudarshan D.

Software Professional

Wilmington , United States

Experience: 20 Years

Sudarshan

Wilmington , United States

Software Professional

72000 USD / Year

  • Immediate: Available

20 Years

Now you can Instantly Chat with Sudarshan!

About Me

To be efficient, capable and leading software professional working on cutting edge technologies in thriving on excellence and challenges. To seek a Competitive edge and a challenging work environment in the field of Business Intelligence of Informati...

Show More

Portfolio Projects

Description

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.

Show More Show Less

Description

  • 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

Show More Show Less

Description

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

Show More Show Less

Description

BofA Compliance and Risk Technology have oracle dimensional Datawarehouse environment.

Show More Show Less

Description

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.

Show More Show Less

Description

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

Show More Show Less

Description

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

Show More Show Less

Description

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

Show More Show Less

Description

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

Show More Show Less

Description

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

Show More Show Less

Description

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

Show More Show Less

Description

Returns Inventory Data Mart

Show More Show Less

Description

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.

Show More Show Less

Description

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

Show More Show Less

Description

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

Show More Show Less
Share:

Verifications

  • Profile Verified

Preferred Language

  • English - Fluent

Available Timezones

BROWSE SIMILAR DEVELOPER