Sudarshan D.

Sudarshan D.

Expert Datawarehouse consultanat

, United States

Experience: 20 Years

Sudarshan

Expert Datawarehouse consultanat

72000 USD / Year

  • Immediate: Available

20 Years

Now you can Instantly Chat with Sudarshan!

About Me

 

20+ years of IT experience with 15+ years of strong experience in designing and developing Business Intelligence solutions in Domains like Finance, Investment Banking, Retail.

 

...

 

·         Project Management Professional PMP

 

·         Agile certified Professional PMI-ACP

 

·         Oracle Certified Professional 11G

 

·         Certified in Google Analytics Individual Qualification (GAIQ)

 

·         Working on certification of Google Analytics Tag Manager

 

·         Strong experience in Data Warehouse.

 

·         Gone through complete implementation cycle of Data marts multiple times. The activities include Business Requirement Analysis, Logical design / Data Modeling, Physical Database Design, ETL Build & Reporting, Integration Testing, User Accepting Testing, Production Deployment & Maintenance Transition.

 

·         Good experience in developing Logical and Physical Data Models (Star Schema & 3NF).

 

·         Experience in Data Warehouse Technical Architect for ETL (Informatica Power Center (8.x,9/x), PL-SQL

 

·         Worked extensively in Data Cleansing, data Mining, ETL Performance Tuning of Informatica mappings and sessions.

 

·         Experience in Hadoop BIG Data Environment. Worked in PIG scripting, HIVE, JAVA Tools, Map reduce Good Experience in developing UNIX shell scripting and automation of ETL processes and loading data in Hadoop Lake environment.

 

·         Excellent communication and interpersonal skills, excellent team organizing skills.

 

·         Strong problem solving and analytical capabilities

 

·         Ability to understand customer needs and manage expectations.

 

·         Demonstrated ability to work effectively in a fast-paced, high volume, deadline-driven environment

 

·         Ability to balance multiple demands and work both independently and as part of a team to develop solutions

  

Show More

Portfolio Projects

Data Analytics in digital marketing

Company

Data Analytics in digital marketing

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

Datawarehouse ETL Consultant

Company

Datawarehouse ETL Consultant

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

Tools

Toad

Credit Card Dispute Analytics

Company

Credit Card Dispute Analytics

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

Call Center Data Analytics

Company

Call Center Data Analytics

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 scriptin development and deployments co-ordination
    • User support. Create complex queries based on user requirement
    • Process tuning

Show More Show Less

Tools

Toad

ODW Applications Development in Compliance and Risk Technology

Company

ODW Applications Development in Compliance and Risk Technology

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

Skills

Oracle Unix

Tools

Informatica
Share:

Verifications

  • Profile Verified

  • Phone Verified

Preferred Language

  • English - Fluent

Available Timezones

  • Eastern Daylight [UTC -4]

  • Central Daylight [UTC -5]

  • Mountain Daylight [UTC -6]

  • Pacific Daylight [UTC -7]