We provide IT Staff Augmentation Services!

Business Intelligence Consultant Resume

Atlanta, GA

SUMMARY:

  • Over 12 years’ experience in DWH ETL BI area mainly in:
  • Data visualization and Report Development using Tableau Desktop (10.1) and MS Excel Pivot table.
  • Data warehouse ETL Integration using Informatica.
  • Strong Data processing knowledge in designing and implementing Data Warehouse Business Intelligence applications, mainly using Tableau (10.1) and ETL tool Informatica Power Center 6.x, 7.x and 8.x etc.
  • Thorough knowledge on Data warehouse concepts like Star schema, Snowflake schema, Fact constellation, Data Marts, ODS, Dimension and Fact tables. Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
  • Strong experience of preparing SQL queries for performing ETL, Database, Migration, Data Comparison, Reports testing
  • Good experience in formulating test strategies for Sum total functional & BI projects (ETL, Data Migration, Reports)
  • Experience in analyzing functional requirements and breaking them into high level & low level scenarios. Created solution driven dashboards by developing different chart types including Crosstab’s, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area, Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
  • Administered user, user groups, and scheduled instances for reports in Tableau Server.
  • Testing of job scheduling using control - m, job dependency & debugging the failures
  • Have around 4 years of Team Lead experience and managed geographically distributed team of 10 members
  • As an lead, performed end to end STLC activities encompassing On boarding, Estimation, Planning, Execution, Monitoring and Closure phases
  • Worked in domains like Insurance, Investment Banking, Finance & Securities and Capital Markets

TECHNICAL SKILLS:

DWH Tools: Informatica ETL, Power Designer as Data Modeling tool, Control-m

Databases: SQL Server, Oracle, DB2.

Reporting Tools: Tableau (8.1), Microsoft BI (Pivot table and charts)

Database Tools: SQL Developer, TOAD

Configuration Management: VSS, Clear Case, SharePoint,

Languages & Scripting: Java, HTML, CSS, XML, PL/SQL

Operating Systems: Windows, UNIX

EXPERIENCE DETAILS:

Confidential

Business Intelligence Consultant, Atlanta, GA

Responsibilities:

  • Create solution driven dashboards by developing different chart types including Crosstab’s, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area, Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
  • Creates dashboards for daily use by the Marketing and Business teams to aid in making informed decisions.
  • Develops, enhances, and integrates Data Warehouses/Data Marts, and Business Intelligence solutions.
  • Gathers requirements from stakeholders and create functional requirements within an Agile software development environment.
  • Participates in business analysis activities to gather required reporting and dashboard requirements.
  • Develops forecasting models for Finance team and visualizes the targets achieved as the basis for strategic decisions and planning.
  • Gathers, scrubs, classified and enhanced data for analysis and predictive models. Provide churn analysis and customer behavior.
  • Data Quality analysis, ETL testing, Control-m testing, standardization & cleansing, matching and linking, fuzzy matches, workflow dependencies and testing, SCD Type 2 checks, de-duplication etc.
  • Control-m job scheduling & testing, job dependency & debugging the failures, sending test progress report to client and all stakeholders

Confidential

ETL lead developer

Responsibilities:

  • Preparing estimates for JIRA items for every release
  • Understanding the requirements, preparing the high level test scenarios (positive, negative, exceptional) and writing SQL queries for validating the data against the mapplets in IDQ
  • Pre-validation checks on feed files from UNIX, file validation, file load and file archival
  • Preparing test feeds for validating the source filter conditions, delta checks (SCD type 2 checks) etc
  • Study the Requirements for Phase I & II
  • Develop/Modify Informatica Mappings, Workflows, and different session tasks
  • Worked extensively on different types of transformations like Expression, Filter, Aggregator, Rank, Lookup
  • Preparing scenarios and writing test cases for E2E testing of the application
  • Writing medium to complex SQL queries using Business Rules for comparing data against Teradata database
  • Exclusively worked on validating the new monthly statement with the current statement from OnDemand
  • Querying EDW for the required account classifications/account types and transactions as needed
  • Validating the transaction codes for Activity section, identifying the missing transactions in new statements
  • Defect management with onsite lead and QA manager
  • Data Quality analysis, ETL testing, Control-m testing, standardization & cleansing, matching and linking, fuzzy matches, workflow dependencies and testing, SCD Type 2 checks, de-duplication etc
  • Control-m job scheduling & testing, job dependency & debugging the failures

Confidential

Senior Software Engineer

Responsibilities:

  • Preparing & uploading the test data as per test scenarios for Pre landing schema to validate the ETL mapping & transformation rules
  • Preparing the Sum Total functions in SQL test scenarios and writing SQL queries for validating the mapping & transformation rules in ETL, validating data in Landing, Staging and Base Objects, validate the match functionality
  • Validating the source and target counts, lookups, cleanse functions, data duplication etc
  • Sending test progress report to client and all stakeholders
  • Publishing the project Lessons Learned document among stakeholders
  • Formulating test plan and BI test strategies for
  • Data Migration
  • ETL Testing
  • Reports Testing (Cognos, Actuate, Spotfire)
  • Preparing the high level test scenarios (positive, negative, exceptional) and writing complex SQL queries for validating the mapping & transformation rules in ETL, testing stored procedures
  • Identifying accelerators for test activities like data comparison & ETL testing
  • Sending test progress report to client and all stakeholders.

Confidential Support and Development

ETL Developer

Responsibilities:

  • Develop/Modify Informatica Mappings, Workflows, and different session tasks.
  • Worked extensively on different types of transformations like Expression, Filter, Aggregator, Rank, Lookup, Update Strategy, Sequence Generator and Joiner etc.
  • Created and maintained Informatica Mappings.
  • Prepare UTR, TDS & Unit Test Cases for the Mappings.
  • Sort out the internal Defects of Developments.
  • Testing - unit testing & integration testing.
  • Worked on migration of mappings & workflows across environments
  • Tuning the Informatica Code for Optimum Performance.
  • Performance tuning of mappings as per production timeline for different upstream and downstream.

Confidential

ETL Developer, Philadelphia

Responsibilities:

  • Worked extensively on different types of transformations like Expression, Filter, Aggregator, Rank, Lookup, Update Strategy, Sequence Generator and Joiner etc.
  • Created and maintained Informatica Mappings.
  • Prepare UTR, TDS & Unit Test Cases for the Mappings.
  • Sort out the internal Defects of Developments.
  • Used Workflow Manager to create, schedule, execute, and monitor sessions and batches that perform source to target data loads.
  • Created Reusable Transformations and Mapplets.
  • Repository Manager, Designer, Workflow Manager and Workflow Monitor.
  • Implemented Informatica Best Practice strategies while developing Transformations, Mappings and Mapplets using Informatica power Center.
  • Created Sessions using Workflow Manager.
  • Identifying & assessment of resources, allocation, on boarding, assigning roles & responsibilities
  • Identifying learning & plans for team and executing them
  • Performing team appraisals, setting goals & objectives, providing constructive feedback with improvement areas
  • Good understanding of stakeholder management
  • Identifying risks, escalating on time with appropriate stakeholders and mitigating them
  • Performing project assessment on process areas & implementing solutions for improvement

Confidential

ETL Analyst

Environment: Informatica 8X for ETL, BOXI for BI reporting, Oracle, UNIX, and Distributed Environment

Responsibilities:

  • Study the Requirements for Phase I & II
  • Develop/Modify Informatica Mappings, Workflows, and different session tasks
  • Worked extensively on different types of transformations like Expression, Filter, Aggregator, Rank, Lookup
  • Preparing scenarios and writing test cases for E2E testing of the application
  • Writing medium to complex SQL queries using Business Rules for comparing data against Teradata database
  • Exclusively worked on validating the new monthly statement with the current statement from OnDemand
  • Querying EDW for the required account classifications/account types and transactions as needed
  • Validating the transaction codes for Activity section, identifying the missing transactions in new statements
  • Defect management with onsite lead and QA manager
  • Preparing different status reports for E2E testing
  • Preparing module-wise induction document for project
  • Coordinated and mentored new team members

Confidential, Kentucky

ETL Developer

Environment: Informatica Power Centre 8.x for ETL, BOXI for reporting, SQL Server 2000,Unix

Responsibilities:

  • Study the Requirements for different work packets
  • Preparing traceability matrix and writing test cases for Functional, Integration, Systems, GUI and Localization testing.
  • Test data creation for financial ratios and performance data of various financial instruments
  • Querying SQL Server, preparation of complex SQL queries for test execution
  • Sum Total functions in SQL
  • Closely worked with Dev team for successfully deploying first application build for QA team
  • Defect management and escalation
  • Coordinated with developers, mentored new team members

Hire Now