We provide IT Staff Augmentation Services!

Senior Data Analyst/consultant Resume

Columbus, OH

SUMMARY

  • Over 15 years of experience in analysis, architecture, design, development, testing and implementation of data warehousing, client/server, and relational database applications for Health Care, Publishing, Financial, Service, Energy, Manufacturing, Telecom, Retail and Insurance industries.
  • Focused on providing Requirement Analysis, Data Analysis, Data Architecture, Data Extraction (ETL), Data Modeling, and supporting reporting needs for Data Warehousing and Business Intelligence applications
  • Skilled in providing Senior Level Technical guidance for data warehousing initiatives with expertise in Analyzing, Designing, Developing Business Intelligence applications to satisfy defined Business Requirements; well versed with data Warehousing Architectural Approaches, Agile Methodology, ETL architecture and System development Life Cycle.
  • Experience in helping Organizations eliminate redundancy of efforts, optimize skill sets, lower costs, and reuse work across multiple projects by moving towards some level of standardization and Centralization in Data Integration efforts. Worked with Offshore Development teams and onsite development teams to coordinate/lead ETL Development
  • Experience in building Data Marts, Enterprise Data Warehouses (EDW) and Decision Support Systems (DSS) using Multidimensional Model (Kimball and Inmon), Star and Snowflake schema design and Data Vault Modeling methodology.
  • Experience in designing Conceptual, Logical, and Physical Data Models, Reverse Engineering databases, Synchronizing databases and managing Data Models
  • Strong Relational database design and development skills with Oracle, Netezza, Teradata, DB2 and MS SQL SERVER; Used Oracle PL/SQL, SQL LOADER, Import/Export, Teradata MultiLoad and Fastload utilities, SQL Server Data Transformation Services
  • Expertise in conducting interviews for gathering business requirements, working with business sponsors regarding the business needs, documenting use cases, working with requirement analysts from multiple departments in elaborating their user stories, and explaining the business requirements.
  • Experience in designing and developing data extraction, transformation and load (ETL) processes using Informatica and SSIS.
  • Experience coordinating User Acceptance Testing and Functional Testing with the Business Users and System Testing, Unit Testing with the Team
  • Experience implementing projects using both Agile Methodology and Waterfall Methodology for software development, creating several documents like System Architecture diagrams and Specification documents.
  • As an ETL Architect/ETL LEAD created documents for Error Handling, ETL Standards, ETL Process flows.
  • Experience identifying Performance Bottlenecks in ETL processes, Database procedures, Reports and fixing them using strategies like Partitioning, Indexing
  • Experience implementing Slowly Changing Dimensions, Hierarchies, and Persistent Staging Area

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Senior Data Analyst/Consultant

Responsibilities:

  • Developed high level logical model for the nine subject areas defined by ADS Data Governance team. Worked with data stewards validating and capturing the business relationships, leveraging Collibra for entity definitions and critical data elements
  • Analyzed current landing and warehouse solution for ADS.
  • Gathered requirements and worked on the technical solution for two POC’s to demonstrate Informatica CDC and meet the requirement of providing near real time data for Fraud Transaction Analysis and Call Center dashboard.
  • Involved with Solution Architect proposing the new Architecture for Confidential Enterprise Data Warehouse.
  • Implemented physical data models for Operational Data Store and Operational Data Vault for the scope of the two POC’s.

Environment: Netezza 7.2, ER/Studio Data Architect 17.0, Informatica 10.1, Microstrategy, SQL Server

Confidential, Columbus, OH

Senior Data Analyst/Consultant

Responsibilities:

  • Worked on creating architectural documents like Functional and Technical Design documents,
  • Worked on creating ETL specification documents, data models, database design, DDL’ s.
  • Worked on designing an application for users to be able to maintain product hierarchies.

Confidential

Analyst

Responsibilities:

  • Worked on SSIS and created ETL packages from source systems to EDW
  • Worked with the client team building the datamart
  • Worked with the client team documenting EDW, setting up the test environment.
  • Created Sales Dashboard for FCX salespersons and Management using Tableau and SSAS cube.
  • Environment - DB2, ER Studio, Tableau, Microsoft SQL Server, DataStage, Microsoft Visual Studio, Mircosoft Management Studio

Confidential, Columbus, OH

System Architect

Responsibilities:

  • System Architect in the RADS BSA area supporting I-Media web databases and Confidential Bank.
  • Project Architect/Tech Lead/Analyst for Retirement Plans Private Sector Investment Solution Builder Master Model project. This initiative was to attract more advisors and their 401k clients by enhancing the current Investment Solution Builder. Worked with Analysts and architects in RP, I-Media, RADS and SOA.
  • Worked on enhancing the exisitng ISB Data Model to meet Phase 2 requirements, identified data gaps between different databases for Webservice development and resolved the issues.
  • Worked with the Enterprise and NF architects documenting RADS applications in IBM Rational System Architect (EA).
  • Worked as the RADS BSA System Architect and contributed to the overall solution for the Tier 1 project, BEACON. Solution involved working with SOA and ECIF teams for Bank Customer Data Integration, providing real time single view of Customer and building Auto Segmentation process in RADS with Customer and Agent information from different Enterprise applications.
  • Project Architect for HA databases Server Currency project which consolidated and decommissioned several Solaris servers and moved I-Media databases to RAC enabling High Availability for these critical databases. Also several Oracle databases were upgrade to 11g from 9i as part of this initiative. Worked as the Project Architect for Bank’ s PCI Cage Environment Server Currency effort.
  • Worked as the Project Architect for Target Excess project which was intended to resolve some known issues with IP Variable Life Wholesaler Target Excess Commission flows. This project reduced the manual process and also avoided the situation of overpaying commissions on premiums that cannot be categorized correctly. Also improved accuracy of business reporting and ledger reconciliation.

Confidential, Columbus, OH

Data Warehouse Consultant

Responsibilities:

  • Worked on designing and developing a datawarehouse for Confidential Bank using Data Vault methodology and Kimball methodology.
  • Worked extensively with Business analysts and sponsors in documenting requirements.
  • Worked with the team on defining the deliverables for each sprint/release using Agile methodology. Coordinated the development and testing with other developers, participated in User Acceptance testing and implementation for each release.
  • Handled several roles like Data Analyst, Modeler, Technical Lead, UAT tester efficiently within the team based on need for each release.
  • Worked extensively with Oracle OLAP functions to process millions of rows for history loads.
  • Designed and developed the ETL strategy for error handling, Restart ability, history loads, Informatica workflows for daily loads.
  • Analyzed source systems for data anomalies, and worked with the business to identify rules to handle the anomalies.
  • Supported Business Objects development by working with the business defining metrics, working with users testing the reports, and working with the BO developers in defining the universe.
  • Environment - Informatica PowerCenter 9.0.1, Toad, Erwin 7.1, Oracle 11g, Maestro, Netezza 4.6.8, Business Objects XI

Confidential, Columbus, OH

Data Architect/Analyst

Responsibilities:

  • As a Data Architect/Analyst, participated in the current state assessment of Confidential Bank and providing a high level Solution Architecture for the new datawarehouse that was proposed to replace an existing warehouse.
  • Participated in interviews with bank executives to determine strategic goals for the bank in order to propose a datawarehouse to align with the current and future goals.
  • Gathered user stories from the interviews that could be used as high level requirements for planning and further analysis.
  • Interviewed technical and management resources to determine the data needs for the bank, completed a high level feasibility study of acquiring the data, identified at a high level data sources needed to meet the requirements.
  • Documented the Current State, after doing a gap analysis of the current state to the bank’ s data requirements. Revised the current data models, reports, databases and Informatica workflows to determine what can be retained for the new architecture solution

Confidential, Columbus, OH

Senior ETL Developer/Architect/Database Engineer

Responsibilities:

  • Worked on several projects including Customer Profitability, Consumption Data Mart, integrating external and internal data sources into the Abbott Nutrition’ s Data Warehouse. As part of these projects, data from several external sources were processed and integrated with the existing data sources in the DW and fed into the respective DataMart.
  • Worked on building Lot Traced Reporting System (LTRS) replacing the current mainframe system used for Abbott Nutrition Product recalls. Being a validated system and a project with high visibility, worked extensively with the business users and the mainframe team currently maintaining the system in identifying the Functional requirements, converting the functional requirements into technical specifications, working with the Off-shore team and the on-site coordinator for development, and testing extensively.
  • Involved in creating Proof of Concept for data extraction from SAP APO module using SAP BAPI’ s, and connecting directly to SAP using PowerConnect for SAP. Analyzed data in several SAP tables after extraction to build ITEM MASTER, Planning Data Mart.
  • Designed and developed several extracts using Informatica for downstream systems based on the requirements.
  • Worked on resolving several issues with the current model, Informatica processes and PL/SQL modules for the Customer dimension, Sales Activity and Freight loads.
  • As part of Informatica Administration team, worked on several Informatica upgrade projects, was responsible for admin tasks like doing code migrations for the developers, setting up folders, deployment groups, users, troubleshooting any issues with production and test Informatica Servers.
  • Worked with Abbott team members in replacing current ETL processes from Oracle PL/SQL to Informatica.
  • Developed System Architecture Documents, Design documents, functional and technical specifications, completed source target analysis, and implemented the specifications using Informatica mappings.
  • Developed several Test Protocol documents and involved in Unit, System and User Validation Testing.
  • Trained other developers to understand and use Informatica tool (for example: setting the Target Load Plan, dynamic caches).
  • Worked with Abbott team establishing ETL and data warehouse standards.
  • Involved in creation of Persistent Staging Area (PSA) for the data extracted from various data sources.
  • Responsible for 24/7 Production Support based on on-call rotation calendar, resolving tickets opened by users regarding issues with Production systems.
  • Involved in developing logical, physical models using PowerDesigner, resolving some of the issues with the current model, created and maintained database objects like tables, views, database packages and procedures, indexes as needed for several projects.
  • Worked with on-site and off-site consultants and managed development tasks assigned to them.
  • Environment - Informatica PowerCenter 8.6.1, Toad, PowerDesigner, Oracle 10g, Oracle Discoverer, MVS, Autosys, Cognos

Confidential, Columbus, OH

Data Warehouse Consultant/Data Architect/ETL

Responsibilities:

  • As a Data Warehouse Architect, involved in reviewing the existing Data Warehouse and architecting a Global Data Warehouse (GDW) for the various Business Units of Confidential
  • Involved and interacted with the 7 different Business Units ( Confidential -Hill Companies) to define the business requirements and helped them characterize common hierarchies for Product classification.
  • Involved in analyzing over 200 existing Oracle Report Builder Reports, Oracle Discoverer reports, and Oracle ERP 11i Source Systems to gather business requirements and business rules.
  • Eliminated several ancillary systems of the existing Data Warehouse which were used by Management to analyze Sales, Commissions, Customers, and Products and incorporated into the GDW.
  • Analyzed the existing Canadian Data Warehouse to incorporate into the Global Data Warehouse. Discussed with the International segments to incorporate their sales and inventory information into the GDW.
  • Analyzed various ancillary systems like Market Product Database (MPD), MDR, SFA to include them in the logical and physical models of EDW.
  • As a Data Modeler, created Logical Model and Dimensional Model, managed and synchronized various Data Models, generated several ERwin reports for the team.
  • Involved in designing and implementing 3NF Operational Data Store (ODS) using Erwin and Informatica.
  • Participated in Proof of Value for Kalido and Business Objects for GDW infrastructure. Created a prototype for sales Data Mart using Kalido and their team with sample data and mock requirements. Communicated to the Management the Pros/Cons of using these tools individually and together in GDW.
  • Involved in creating Statement of Work (SOW) for Offshore Tata Consultancy Services (TCS) Team for Development.
  • Created Functional, Technical Design documents for ETL processes like Error Handling, Audit Trail, ETL dependencies, Informatica Mappings, and the overall Process flow.
  • Coordinated with Onsite/Offshore TCS consultants for ETL development, performance tuning and Unit Testing.
  • Coordinated with the QA team, database team setting up Informatica and Testing processes.
  • Environment - All Fusion Erwin Data Modeler, Model Mart, Oracle Applications 11i, Oracle 10g, SQL Server, MS Access, Informatica PowerCenter, UNIX, Oracle Discoverer, Oracle Warehouse Builder (OWB), Oracle Report Builder, Kalido, Business Objects.

Confidential, Cleveland, OH

Data Warehouse Consultant/Data Architect

Responsibilities:

  • Performed as a Data Architect/ ETL Developer involved in working with the Business users to create Business specifications and the ETL specifications.
  • Created the Logical and Physical Data Models.
  • Determined the Monthly Snapshot Facts, Daily Snapshot Facts, Dimensions (CUSTOMER, ACCOUNT, BRANCH and others), and Aggregate tables.
  • Compared different data models, synchronizing data models with databases, setting up domains, templates in ERWIN, creating reports using ALLFUSION ERWIN DATAMODELER.
  • Worked with the ETL team and Business Users and resolving issues with the data model like many to many relations and super type subtypes.
  • Worked as a Liaison between the database team and the ETL Team, setting up developmental standards, mentoring the developers during coding and testing, conducting code reviews.
  • Coordinated the Testing with Business Users, working with the team in resolving the issues and coding them
  • Used DTS Package Designer or the Import and Export wizards to create new packages.
  • Gathered Report Specifications and creating report templates
  • Environment - ERwin 4.0, Oracle 9.2.3, SQL Server, Informatica PowerCenter 6.0, DB2, Toad, Unix, Perl, Oracle Discoverer, Trillium 7.0, XML

Confidential

Data Warehouse Consultant/ Data Architect/Analyst

Responsibilities:

  • Involved in development of a Data Mart for Confidential ’ s Sporting Goods distribution center reporting application.
  • Conducted interviews with the end users and prepared business specifications.
  • Involved in the data modeling, data and ETL architecture and created Oracle and SQLSERVER databases.
  • Involved in exporting and importing data from SQL SERVER databases and applying simple transformations.
  • Implementing type 1 and type 2 slowly changing dimensions.
  • Developed the multi-dimensional data model and PL/SQL extraction procedures to load the data from OLTP application - Catalyst Warehouse Management System (WMS) into the Data Mart. Extensively used Oracle packages, stored procedures, and functions to load the data into Oracle 9i Data Mart. Involved in fine-tuning the load procedures to reduce the data load times. Used Oracle 9i features such as Materialized Views and MERGE statements.
  • Developed UNIX korn Shell Scripts for creating daily data loads into the Data Mart using TIDAL job scheduler.
  • Developed reports for the distribution center users and management using MicroStrategy 7.2.3.
  • Environment - Oracle 9i, MicroStrategy 7.2.3, SQL SERVER, UNIX, Erwin, SQLSERVER DTS.

Confidential, Akron, OH

Data Warehouse Consultant

Responsibilities:

  • Used Informatica Power Center - Designer tool in developing Mappings and Mapplets to extract and load data from flat files (ESSBASE) and SAPBW data sources to Teradata data warehouse.
  • Used Teradata BTEQ, MULTILOAD and FASTLOAD utilities to load the Teradata databases from flat files
  • Designed Informatica Mappings with source and target definitions, Mapplets, Transformations and Re-usable Transformations.
  • Loaded flat file data into the target warehouse, using Sorter, Aggregator, and Joiner Transformation combination.
  • Optimized the overall ETL session performance using Lookup Cache, Sorted Input Aggregator, Incremental Aggregation overriding with custom SQL and by identifying performance bottlenecks.
  • Created Decision Task, Email, Command and Control tasks in preparing the workflow using Workflow Designer using Informatica PowerCenter.
  • Designed, created and tested production jobs using UNIX korn Shell Scripts for loading the data into data warehouse.
  • Environment - Informatica PowerCenter 5.1, Teradata V2R4, SAPBW, Erwin 4.0, AutoSys, AS/400, DB2 data sources, COGNOS

Hire Now