We provide IT Staff Augmentation Services!

Bi Consultant Resume

West Chester, PA

SUMMARY:

  • Extensive experience in Architecting and Developing Data Warehousing projects.
  • Data Warehouse Design, Modeling, Analyst, ETL and Execution of data warehousing projects
  • Handle Data Warehouse Project End to End
  • Design Database, table and implementation for data warehouse and related ETL processes.
  • Extensively worked on SQL server, Oracle, MySQL, Teradata and HP Neoview Database.
  • Designing Fact & Dimension Tables, Physical & Logical data models using ERWIN and Erwin methodologies like Forward & Reverse Engineering.
  • Extensively worked on the ETL mappings, analysis and documentation of OLAP Cube requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
  • Experience in performance tuning in large volume data and implementing data partition.
  • Extensively worked experience in SSIS, SSAS, SSRS, MDX and Optimization and performance tuning of SQL Server
  • Expertise in tuning the performance of mappings, sessions and workflow in Informatica and determining the performance bottlenecks.
  • Experience in Pentaho Data Integration, Mondrian Workbench and Report Designer 4.8 to create all ETL transformations, report ad jobs
  • Ensure the implementation of the quality standard and processes in project deliverables.
  • Expert in troubleshooting/debugging and improving performance at different stages like database, workflows, mapping.
  • Experience in Installation and configuration of Informatica server to handle the Informatica administrator tasks like creating repository and backup, copying & moving mappings, workflows and creating folders etc.
  • Ability to work independently as well as work with teams having varying backgrounds on complex issues
  • Knowledge in design and development of Business Intelligence reports using BI tools Business Objects, Cognos and Microstrategy.
  • Experience includes thorough domain knowledge of Manufacture, HRMS, Financial system and Banking.
  • Enthusiastic and goal - oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.
  • Very good knowledge in MDM, Big Data, NoSQL and Hadoop technology.

TECHNICAL SKILLS:

Hardware/OS: Windows, UNIX, Linux

Database: Oracle 11g, SQL Server 2012, Teradata, MySQL, HP Neoview, DB2, MongoDB

ETL: Informatica PowerCenter 9.1, SQL Server Integration Service (SSIS), Pentaho PDI 4.8

OLAP: SQL Server Analysis Services (SSAS), Business Object, Pentaho Mondrian OLAP, Crystal Analysis

Report: Crystal Report, SSRS, Pentaho Report, OBIEE, Tableau

Data Modeling: Erwin, Visio 2000, S Designer

Languages & Script: PL/SQL, SQL, MDX, Visual Basic 6.0, XML, UNIX/Power Shell, Python, JSON, Java

Others: MS Visual SourceSafe, TFS and Tortoise SVN

PROFESSIONAL EXPERIENCE:

Confidential, West Chester, PA

BI Consultant

Responsibilities:

  • Architect, develop and deliver Business Intelligence solutions based upon business.
  • Data Warehouse requirements analysis, design and data modeling for multiple subject areas.
  • Provided recommended design and Studied the current system to understand the existing data structures
  • Develops conceptual data models, design, build, and test sets of reporting and analytic business intelligence programs.
  • Extensively used ETL to load data using Pentaho, SSIS and Informatica from source system into staging tables and to load the data into the target database
  • Improved performance by identifying the bottleneck in source, target, mapping and session levels
  • Performs statistical analysis, retrieval processes on a large amount of data to identify trends, figures and other relevant information.
  • Manage large amounts of data, merge data sources together, ensure consistency of data-sets, create visualizations to aid in understanding data
  • Work with different application groups and architecture, design and deliver effective solutions.
  • Conduct code walkthroughs and review peer code

Environment: SQL 2012, Oracle 10g, Teradata, MySQL, SSIS, Pentaho Data Integration, Informatica, Tableau, Tortoise SVN, Putty, Python, SharePoint, Rally, JIRA, Linux and Windows Server 2012.

Confidential, Horsham, PA

BI Consultant

Responsibilities:

  • Analysis the requirements with end users to gather their report requirements and tuned the design of the model based on these requirements.
  • Responsible for translating business logic into transformation logic for the ETL and implementing Source to Target mapping.
  • Designs and implements BI and data integration solutions using Pentaho development methodologies.
  • Used Pentaho Data Integration Designer to create ETL transformations and nightly schedule.
  • Created dashboards in Pentaho using Pentaho Dashboard Designer.
  • Solution development on OLAP Cube in Pentaho Mondrian workbench
  • Created mapping specification documents to define and document source and target attributes.
  • Involved in the process of migrating code and scenarios from development to test and to production and building migration documents.
  • Involved in ETL tuning at the data-mapping level and database level.
  • Mentors customer's staff members in the use of Pentaho product.

Environment: SQL 2012, Oracle 10g, SSIS, Pentaho Data Integration, Pentaho Mondrian, Pentaho Report, Erwin, Shell Script, Putty, Python, Linux and Windows 8

Confidential, Bluebell, PA

BI Consultant

Responsibilities:

  • Designed the SSIS packages in order to extract data from SQL db, flat files and loaded into SQL database.
  • Performed Source system analysis to identify the source data that needs to be moved into the target tables.
  • Extensively used partition components to process huge volume of records quickly.
  • Design and Develop complex queries efficiently as per the given business requirements.
  • Implemented Event Handlers and Error Handling in SSIS packages.
  • Designed Cube partitioning and incremental synchronization for SSAS cubes.
  • Involved in Staging Partitions and Usage Based Optimization for SSAS OLAP databases.
  • Worked on Table Partitioning to load current and historical data.
  • Experience in query optimization & performance tuning using SQL Profiler, Execution Plan and Performance Monitor.
  • Designed MDX queries to retrieve data from SSAS cubes.
  • Implemented indexes for performance tuning and unit testing.

Environment: SQL 2008R2/2012, SSIS, SSAS, SSRS, Erwin, and Windows 7

Confidential, Philadelphia, PA

BI Consultant

Responsibilities:

  • Extensively involved in functionality requirement analysis, understanding source systems thoroughly by preparing the design process flow documentation, Development & Implementation.
  • Involved in designing Data model for various reporting based Data marts using Erwin
  • Assist project manager in scope estimation and work break down structure to meet project milestone.
  • Defined target load order plan and constraint based loading for loading data correctly into different target tables.
  • Designed and develop SSIS package, configuration files, stored procedures and materialized view.
  • Designed SSAS Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
  • Writing technical specs and mapping documents from staging to data mart, cubes and reporting needs
  • Worked on source data analysis and identifying cleansing area
  • Interacted with the users in understanding the enhancement need and scope of existing reports and developed the reports to satisfy their needs and requirements.
  • Conduct code walkthroughs and review peer code

Environment: Teradata, SQL 2012, SSIS, SSAS, SSRS, Erwin, TFS and Windows 7

Confidential

Data Warehouse Design / ETL / OLAP Lead Developer

Responsibilities:

  • Involved in design and development of Business Requirements to business users by identifying data sources
  • Designed dimensional modeling using Erwin.
  • Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using the Informatica PowerCenter and data profiling on IDQ.
  • Writing package and procedure using PL, SQL, SQL and Materialized view.
  • Detected bottlenecks, trouble shooting and tuning of mappings, implement partition on sessions for better performance and efficiency.
  • Perform Unit tests, Performance and Load testing and validated results with Functional lead and providing technical guidance to ETL team.
  • Designing OLAP in Pentaho Mondrian workbench and SSAS tools
  • Used Pentaho Schema Workbench to create Cubes, Dimensions and fact tables in Pentaho.
  • Using MDX query to generating multidimensional report and charts
  • Technical mentoring of the ETL team
  • Wrote UNIX shell scripts for Informatica ETL to run the Sessions.

Environment: HP Neoview, UNIX, SQL 2008, Oracle 11g, Informatica PowerCenter 9.0.1/8.6.1, Informatica Data Quality, Pentaho Mondrian OLAP, Erwin, SSIS, SSAS, SSRS and Windows 7

Confidential, Irving, TX

Data Warehouse Design / ETL / OLAP Lead Developer

Responsibilities:

  • Used Informatica Power Center 8.6.1 for extraction, transformation and loading (ETL) of data in the Data Warehouse
  • Performed ETL from oracle into SQL Server Data Warehouse using Informatica Mappings including transformations Aggregator, Joiner, Lookup (Connected & Un-conneted), Filter, Update Strategy, Stored Procedure, Router, Expression, Sql and Sorter
  • Write package and procedure using PL, SQL, SQL and Materialized view.
  • Created workflows and tested mappings and workflows in development, test and Production environment.
  • Developed re-usable transformations, mappings and mapplets confirming to the business rules.
  • Actively involved in Performance improvements of Mapping and Sessions and fine tuned all transformations

Environment: SQL 2005, Oracle, Informatica 8.6.1, Analysis Services, SSAS, SSIS, SSRS, ERWIN and Windows2003

Confidential, Illinois

Data Warehouse Design / ETL / OLAP Lead Developer

Responsibilities:

  • Studied the existing environment and accumulating the requirements by querying the Clients on various aspects.
  • Analysis of the requirements and translating it into Informatica mappings.
  • Extensively used ETL to load data using PowerCenter from source system into staging tables and to load the data into the target database.
  • Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
  • Testing Informatica Mappings for data accuracy.
  • Creating / Updating and Running / scheduling Batches and Sessions.
  • Tuned performance of Informatica session for large volumes of data by increasing data cache size and target based commit interval.

Environment: SQL 2008, Oracle, DB2, Informatica 8.6.1, SSAS, SSIS, SSRS, OWC and Windows2000/NT.

Confidential, Lafayette, Louisiana

Data Warehouse Design / ETL / OLAP Lead Developer

Responsibilities:

  • Source data analysis, table design using ErWin, improved cube designs for ease of loading.
  • Created and maintained Informatica PowerCenter mappings and Workflow session as needed.
  • Designing MOLAP Cube in MS Analysis Services
  • Design and create database tables needed for application.
  • Performance tuning in PowerCenter Mapping, and MS Sql Server Database
  • Tuning Informatica Mappings and Sessions for optimum performance.
  • Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, worklets and workflows.
  • Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Workflows and database tuning.

Environment: Erwin, SQL 2005, Informatica PowerCenter 8.6.1, SSAS, SSIS, SSRS, Ramco DecisionWorks, OWC, and Windows 2000

Confidential

ETL Lead

Responsibilities:

  • Extracted data from Oracle source and load to SQL Server
  • Performed Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column
  • Conduct code walkthroughs and review peer code and documentation
  • Responsible for Unit testing and Integration testing of mappings and workflows.
  • Troubleshooting database, workflows, mappings, source, and target to find out the bottlenecks and improved the performance.

Environment: Oracle 9, SQL Server, SSIS, and Windows 2000

Confidential

ETL / OLAP Lead Developer

Responsibilities:

  • Monitor and optimize process efficiencies and effectiveness.
  • Identify business trends and hidden patterns.
  • Have a unique and consistent view of the information.

Environment: SQL 2005, DB2, RBI, Analysis Services, Erwin, Ramco Analytical Report, DecisionWorks and OWC.

Confidential

ETL / OLAP Lead Developer

Responsibilities:

  • ETL Design, Execution, Quality Assurance and Onsite implementation

Environment: SQL 2000, DTS, Analysis Services, DecisionWorks, Excel and OWC

Confidential

Technical Consultant

Responsibilities:

  • Design, Execution, Quality Assurance and onsite implementation

Environment: SQL 2000, Analysis Services, RBI, DTS, DecisionWorks, Excel and OWC

Confidential

ETL Developer

Responsibilities:

  • ETL Design, Execution, Quality Assurance and support

Environment: SQL 2000, Analysis Services, DTS, RBI, DecisionWorks, Excel and OWC

Confidential

ETL Developer

Responsibilities:

  • ETL, Execution, Quality Assurance and support

Environment: Siebel, SQL 2000, Analysis Services, RBI, DecisionWorks, Excel and OWC

Confidential

ETL Developer

Responsibilities:

  • ETL, Quality Assurance and support

Environment: SQL 2000, Analysis Services, DTS, RBI, DecisionWorks, Excel and OWC

Hire Now