SUMMARY

• Over 9+ years of experience in ETL, Data Warehousing, Data Analysis, Data Analytics, Metadata Repositories, Data Migration, Data Mining, Distributed Databases Design, Data Cleansing, Business Intelligence and all phases (Full Life Cycle) of software application development.
• I have realized valuable hands - on experience working on various Data Warehousing and Business Intelligence Projects implementation using various business intelligence and ETL tools like OBIEE, Cognos, SSRS, Tablue, SSIS and Informatica.
• I have good functional knowledge on various financial domains like Banking applications (BFSI), Wealth Management Systems (WMS), Retail Banking and commercial Banking systems.
• I have excellent understanding of system development life cycle and has proven project management skills.
• I am self-motivated, team-oriented individual with strong ability to merge and coordinate with other team members in the respective work environments.

TECHNICAL SKILLS

ETL Tools: Informatica 8.6/9.1/9.5/10.4 , SSIS

BI Tools: Cognos 10.1/10.2, OBIEE 11g, Tablue, SSRS

Operating Systems: UNIX, Read hat Linux, Cent OS Linux Windows

Financial Management Tool: Cognos TM1

Programming Languages: C Basics, Java Basics, Python 3.1, PL/SQL.

DBMS: Oracle 10g, 11g, Teradata, MS-SQL 2008,DB2

Web Tools: HTML, XML

Big Data: Hadoop 2.x, CDH 5.X, Hive

Scripting Language: Shell Scripting,Python, SQL

Data Science: Data Mining, Data Analytics, Machine Learning models

Cloud Technologies: AWS, Snowflake

Dev Ops: Junkins

PROFESSIONAL EXPERIENCE

Confidential, Windsor CT

ETL & BI Lead

Environment: Informatica, Oracle 12c, Tivoli Workload Scheduler, RHEL, Snowflake, SyncSort

Responsibilities:

• Coordinate with data analysis team to get the ETL mapping specification document.
• Analyze the ETL mapping spec and clarified all the outstanding items to proceed with the design.
• Provide the estimates to complete the ETL development with some staggered approach to the project management team.
• Finalize the ETL design approach along with other team members and get it reviewed by the client review committee team to make sure our design is meeting all the industry standards.
• Divide the implementation tasks into groups and delegate it to the team and address the team challenges w.r.t functionality and technical.
• Take up the ownership of complex design development, implement the coding and unit testing and take full responsibility till it moves to production.
• Setup the teams huddle calls every day to hear the team’s challenges and address those or send it to the concern team/person to address the issues.
• Coordinate with QA team to address the defects and observations logged in QC portal.
• Establish a ETL jobs scheduling process using Tivoli Workload scheduler by coordinating with upstream systems SMEs to create the job external job dependency also implement the precedence to run the ETL jobs.
• Coordinate with business requirement team to make sure the coding is in line with the business requirement. If any gaps found call out the issue with data analyst team and correct the error in spec.
• Prepare the KT documents to handover the code to application maintenance team after three weeks of warranty support in production.
• Implement the audit process to capture the data statistics to reconciliation.
• Load data from AWS to Snowflake with different source formats like CSV,JSON and PARQUEST
• Implement history of objects in snowflake

Confidential

ETL & BI Senior Developer

Environment: Cognos 10.2.1, MS SQL Server 2008, Informatica 9.5, .Net

Responsibilities:

• Involved in Requirement Gathering, Gap Analysis, Data Mapping
• Built logical Dimensional model in cognos FM for Profitability Data Mart
• Design and Develop Profitability Models in Cognos Framework Manager
• Develop 60+ Profitability Reports in Cognos BI
• Developed 140 daily transactional reports using cognos report studio.
• Developed 35 spread sheet reports using cognos report studio.
• Built a robust, centralized & controlled Decision support platform to measure Customer & Product profitability on Product, Customer, LOB & Regions Dimensions
• Focused on Commercial, Consumer & Wealth LOBs for Product (30+ Products,100+ SPs) & Customer Profitability (>3MM Customers)
• Provides Profitability/Revenue/Costs of various dimensions (Customer, Account, Product, Region, Market, LOB, Time, Relationship Manager)
• Top-Down, Algorithmic or Parametric Costing/Profitability model
• Built the dashboard that showcases portfolio performance and progress to various stakeholders
• Enables key stakeholders to take right decisions
• Provides early warning to executives for deviations, exceptions

Confidential

Senior ETL Developer

Environment: SQL Server, Oracle 11g, Informatica 9.5, Teradata, CA7

Responsibilities:

• Identified the fields that needs to be reported from .Net Application as per the requirements and data mapped those fields.
• Created ETL design documents as per the requirements and high level design document.
• Created new customized mappings to move data from Siebel Application database to Analytics Warehouse and modified the current existing customized mappings as per the requirements.
• Extensively used various transformations like Lookup, Source Qualifier, Expression, Update Strategy, Joiner transformations to build mappings.
• Used Post and Pre session commands to call scripts which Drop, recreate indexes, run reorg and run stats on the warehouse table which was loaded.
• Used Post session success commands to invoke the next workflow automatically without having to actually kickoff next workflow manually.
• Extensively involved in pre and post deployment tasks which involved monitoring ETL, disabling and enabling the Auxiliary mappings for tables which were force extracted and coordinating with DBA for Reorg and Database backups.

Confidential

Informatica Developer

Environment: Informatica, Windows 7,MS SQL Developer,Cognos

Responsibilities:

• Involved in User Requirements Gathering.
• Developed various Cognos Standard & Dashboard Reports for calculating Travel & Expenses.
• Designed Data Model to satisfy the User Report requirements.
• Involved in Detailed Documentations / Client Calls / Web ex Sessions.
• Involved in setting up Cognos DEV / UAT / Production environments.
• Designed Data Model in Frame work Manager to satisfy the user's requirements.
• Used Informatica Power center to populate the Data Warehouse from the ERP system and other sources.
• Performed ETL using Informatica to create DataMart as per the business requirements.
• Analyzed the data elements for Forecast and Quota facts and their corresponding dimensions.
• Customized the Physical, Business, and Presentation Layer of the repository.
• Developed various kinds of List, Cross Tab, and Chart and Dashboard report using Cognos 8.4 & Cognos 10.
• Scheduling the reports based on the clients requirements using IBM Cognos Connection.
• Developed Various Dashboards Finance, Impact, Helpdesk, Sales Dashboards.
• Understanding the existing stored procedures and migrated all the existing stored procedures to various List, Crosstab, and Chart reports using Cognos.
• Handling complete Datacenter Migration.
• Designed Transformer Cubes in Cognos 10.
• Involved in Setting up the Cognos and DB2 environment offshore and onsite.
• Involved in gathering the requirements and documented the requirements gathered.
• Designed the data models in Frame work manager based on the client's requirements.
• Involved in supporting the existing Reports
• Involved in training the team at Onsite

Confidential

ETL-BI Developer

Environment: OBIEE 11g, Oracle 11g, Informatica 9.1, Windows 7

Responsibilities:

• Performed the Incremental ETL process to populate the Data Warehouse
• Gathered client’s requirements and performed gap analysis on the OTB Business models to identify the gap.
• Proposed Business Model performed Dimension modeling, Identified Fact tables & Measures, Identified Dimension Tables to store business attributes, Identified Aggregate tables & their definitions.
• Created and modified OTB reusable mapplets and transformations to be used in mappings.
• Developed Informatica mappings for populating aggregate tables.
• Modified the existing workflows for refresh load using image tables.
• Worked on the transformations like Expression, External Procedure, Router, Sequence Generator, Aggregator, Filter, Joiner, and Lookup.
• Created Workflows to execute tasks such as sessions, e-mail notifications and shell commands.
• Fine-tuned mappings and transformations to address the performance issues.
• Coordinated with OLTP/Enterprise DW team for data mapping.
• Created and modified the Business Models as per the client’s requirements
• Created and configured Siebel Analytics tables.
• Built Repository at 3 layers Physical Layer (connecting Data sources & import schema), Business Model & data mapping (create Logical tables & data source mapping) and Presentation layer level (create presentation catalogs).
• Worked on Siebel Answers to create the reports and used Filters.