We provide IT Staff Augmentation Services!

Sr. Business Data Analyst Resume

Branchburg, NJ

SUMMARY

  • Around 7 years of Industry experience as a MDM Business Analyst with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
  • Experience in Designing and reviewing various documents including teh Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
  • Strong working experience in teh Data Analysis, Design, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
  • Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, MicroStrategy Data Warehouse Data Modeling and Design.
  • Experienced in maintaining all design documentation workflow activity diagrams, data mapping and technical integration documentation.
  • Knowledge in design and development of Business Intelligence reports using BI tools Business Objects.
  • Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of teh data.
  • Extensive experience in MDM solution and data warehousing solutions involving Data Mapping, Data Cleansing, Data Governance, ETL Development, Data Modeling, Metadata Management, Data migration and Reporting Solutions.
  • Strong Business Analysis Skills including In depth knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Testing and Practical knowledge of Rational Unified Process (RUP).
  • Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
  • Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using. Experience in data modeling with high proficiency in using Erwin for Dimensional Modeling (Star and Snowflake schemas).
  • Experience in Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT and dimensions tables, physical and logical data modeling in SAP environment.
  • Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases.
  • Experience with MDM Hub configurations - Data modeling & Data Mappings, Data Standardization, Data validation, cleansing, Match and Merge rules.
  • Knowledge in Planning, Designing, developing and deploying Datawarehouses / Data Marts with experience of both relational & multidimensional database design using Data Modeling tool ERwin (Physical and Logical data models).
  • Experience in creating UNIX shell scripts and writing SQL Scripts for development, automation of ETL process, error handling, and auditing purposes.
  • Proficient in teh techniques that produce designs of complex technology and business systems, including requirements discovery and analysis, formulation of teh solution, identification of alternatives and assessment of those alternatives.
  • Use standard BI tools, such as Crystal Report or Business Objects, to produce reports relating to outcomes.
  • Good knowledge and understanding of enterprise scale applications such as EIM (Enterprise Information Management), ERP (Enterprise Resource Planning) and CRM (Customer Relationship Management) and CMS (Content Management System) along with data warehousing, metadata management, and master data management (MDM).
  • Proven skills in Business & Data Analysis, BI Data Quality & Analytics through data extraction, profiling, cleansing, standardization, conversion, transformation and reporting.

TECHNICAL SKILLS

Business Skills: Business Process design and analysis and process mapping for systems and processes, Design, Gap Analysis, Cost-Benefit Analysis, Cause and TEMPEffect Analysis, Impact Analysis, JAD/JRP Sessions Requirement Gathering, and Use Case Modeling

Methodologies: Agile, RUP, Scrum and Waterfall

Testing Tools: HP Quality Center, Win Runner, Load runner, DOORS and Jmeter

Database: Microsoft Access, MS SQL Server, Netezza, Hadoop, Teradata, SAS, UNICA, EDW, and PMDM

Microsoft tools: MS Office Suite, MS Visio, MS Excel.

Other skills: Data warehousing, UML, HP Quality Center, Informatica Data Director IDD, Informatica MDM

PROFESSIONAL EXPERIENCE

Confidential, Branchburg, NJ

Sr. Business Data Analyst

Responsibilities:

  • Responsible for all business systems data: ensure data governance, data quality and master data management and implemented data governance and data quality program.
  • Authored teh Master Data Management (MDM) Business Requirements analysis (BRD's) and Use Case design documents.
  • Documented teh Functional Specification documents and Traceability matrices while working closely with technical and business team.
  • Created ETL mappings, sessions, workflows by extracting data from MDM system, FLASH DC & REM source systems.
  • Introducedstandardizationof enterprise information (EIM), defining accountability ofdataowners.
  • Defined and build MDM stewardship reports to identify data quality issues, identify delta distribution, matching disposition (merge/reject), and track manual review of data
  • Authored data mapping and transformation requirements based on understanding of operating rules; review with ETL developers to ensure understanding.
  • Developed deep understanding of source systems, business usage, DW transformations and business logic, data issues, etc.
  • Created, customized & shared interactive web dashboards with simple drag & drop and generated complex dashboard reports, adhoc, business views along with user acceptance test and data accuracy test.
  • Applied business knowledge in formulating options and recommendations to resolve business issues that impact teh way a function or set of division run their business.
  • Created custom administrative reports by accessing metadata from Tableau Server (PostgreSQL DB).
  • Designed SSIS Package for extracting data from heterogeneous source systems, transform and load into teh Staging Database.
  • Worked on data cleansing and standardization using teh Power Center while bring data into Informatica MDM.
  • Created smoke test/data validation/performance testing scenarios to test reports. Gatheird Requirements for all teh business units through one on one meeting with teh subject matter experts.
  • Extensive use of MS Excel, Power Point, Visio for Command Center incident/performance data analysis functions including data extraction, cleansing, trend identification, and large data set compilation, graphing/charting, daily/weekly go-live status reporting to stakeholders.
  • Analyzed transactional database through analytical tools such as SQL, SAS, Python, Microsoft Access, Excel Power BI to develop timely, applicable and actionable insights Advanced expert database handling languages (SQL and variants).
  • Worked in Data Analysis, data profiling and data governance identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
  • Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
  • Involved in teh Analysis, design, testing and Implementation of Business Intelligence solutions using Data Warehouse, ETL, and OLAP, Client/Server applications.
  • Performed back end testing using SQL queries to check on data with Content Management System along with data warehousing, metadata management, and Master data management (MDM).
  • Developed an Enterprise Information Management (EIM) Framework detailing all capabilities to manage and implement a Data Layer and Advanced Analytics capability across teh Enterprise.
  • Reviewed and analyzed teh business requirements document (BRD) to derive teh functional specifications document (FSD) and assisted in teh preparation of System Requirement Specifications following teh SDLC life cycle and played a vital role in data warehousing, metadata management, and master data management (MDM).

Environment: Informatica MDM 10, Tableau 7.x, SSAS, SSRS, Informatica 9.x/8.x, Quality Center 9.2, SQL Server 2008, PL/SQL, XML, Toad, Flat files, Manual Testing.

Confidential - Chicago- IL

Data Analyst

Responsibilities:

  • Authored an Enterprise Data Management Strategy with three initial focus areas of Data Cleansing, MDM, and Data Governance.
  • Created various analysis Artifacts like Process flow diagrams, Context Diagrams, Use Case specification documents, requirements definition reports, and recommendations reports were developed with teh inputs from managers with respective Users.
  • Prepared teh PL/SQL Packages/Procedures to load thedatain toEIMtable from teh flat files using teh SQL Loader utility.
  • Worked extensively on Data analysis, Data Mapping and future Data Models, Analysis of functional and non-functional categorized data elements for data profiling, data cleansing and mapping from source to target data environment.
  • Developed and scheduled data cleansing programs in Data Services to fix various data quality issues.
  • Categorized and defined requirements based on extensive discussions with Developers and Administrative Services Manager/Office Manager to come up with requirements prioritization.
  • Provided clear and concise documentation regarding Requirements Management Plans, Functional Requirements and Non Functional Requirements.
  • Involved in creating test cases and test scripts and managed Scope creeps according to teh priority as and when UAt required any changes.
  • Worked closely with QA and Developers to clarify functionalities, resolve issues and provided feedback to nail down teh bugs.
  • Performed Metadata & Data Dictionary Management, Data Profiling, Data Mapping, DDL & DML generation & usage.
  • Involved in teh Analysis, design, testing and implementation of Business Intelligence solutions using Data Warehouse, ETL and OLAP, Client/Server applications.
  • Built various packages in SSIS to load teh data coming from various input sources like excel, flat files.
  • Involved in designing and developing Data Models and Data Marts that support teh Business Intelligence Data Warehouse.
  • Created business requirements and helped system analysts in converting them into System Requirement Specification (SRS) document for MDM Business and Data Quality Requirements.
  • Used Rational Requisite Pro to document stakeholders' requests, software requirements specifications and traced it to use cases.
  • Identified Data Governance and Data Stewardship issues and assisted with role and responsibility establishment across departments; created Source to Target Mappings for basic entities for a new ODS based on data governance strategy.
  • Worked collaboratively with all data stewards, stakeholders and EIM Team members to set strategies and objectives for Navy's data Management and data Governance programs.
  • Designed & developed multiple cleansing and standardization scenarios using Cleanse Functions.
  • Utilized Rational Unified Process (RUP) to configure and develop processes, standards, and procedures
  • Involved in reviewing and writing BRD, URS and Functional Requirements for MDM Business and Data Quality Requirements.

Environment: Microsoft Office Suite, MS Visio, Windows XP, DreamWeaver, RUP, SQL, PLSQL, XML, VB, ASP, UNIX, Crystal Reports, Adobe Photoshop, Mercury TestDirector, WinRunner, LoadRunner

Confidential - Columbus, OH

Business Data Analyst

Responsibilities:

  • Created and maintained data model/architecture standards, including master data management (MDM).
  • Designed teh Business requirement document and FSD along with business rules for data cleansing and standardization.
  • Created SQL queries in Microsoft SQL Server and TOAD to extract teh data from various tables in teh data warehouses.
  • Involved in teh design and code review of ETL components and Reconciliation process at a project level.
  • Experienced and versatile with teh concepts of Data Modeling/ Data Warehousing and RDBMS Concepts.
  • Coordinated with various supported internal businesses, users and external market vendors to update inventory based on changes in market data risks services.
  • Performed cross functional tasks such as interviewing claim examiners and word processors to understand current document structure in CAS, ECM and Workflow to conduct Gap Analysis.
  • Developed Data migration scripts for import into Siebel using Siebel EIM and PL/SQL and involved in Data Mapping for loading teh Legacy data and prepared complex SQL queries.
  • Debugged ETL process data flow from source to final data warehouse through each stage such as staging area, ID Generators, Domain changes and Replica transfers.
  • Developed, maintained, and implemented business systems COOP plans, disaster recovery plans, and other tasks.
  • Created and maintained various documents such as Source- To-Target Data mapping and Unit Test Cases Documents.
  • Tuned Actimize CDD models and conducting statistical analysis of data in order to perform system optimization and increase efficiency.
  • Performed data cleansing and transformations using ETL (Informatica Power Center and Informatica Data Quality (IDQ).
  • Used Master Data Management (MDM) technology, tools to create and maintain consistent and accurate lists of Master Data. Solid experience with Data Warehouse development and technologies.
  • Extracted teh data from database and provide data analysis using SQL to teh business user based on teh requirements.
  • Extensively worked on Creating User requirement Specifications (URS), Functional Requirement Specifications (FRS), and Business Process Definitions.
  • Managed change controls process using Remedy and Service Now to ITIL standards.
  • Executed and created various PL/SQL procedure calls to update teh tables in data warehouses and marts.
  • Designed, developed and implemented a data integration solution across companies, all lines of business and all customers that ensured data standardization and consistency.
  • Involved in teh creation of teh mappings from teh legacy system toEIMand to Base table with table and low level details.
  • Prepared Use Cases, Scenarios and elaborated those using UML diagrams like Use Case Diagrams, Activity Diagrams, Data Flow Diagrams, Business Process and Data Process Model using MS Visio.

Environment: MS Excel, MS Word, MS PowerPoint, Windows XP/ME, PMBOK, BABOK, Quality center, MS SQL Data Base, JAVA, MS Outlook, Share Point, MS Visio.

Confidential - Greensboro, NC

Business Analyst

Responsibilities:

  • Played key role in System Development Life Cycle Process consisting of Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria, and Implementation to has teh outputs of project dealt with teh automation of correspondence directed to Insurance policy owners.
  • Designed and documented web-based interface GUI/UI screens for various legacy systems including teh HUB 1.0 and HUB 2.0 applications.
  • Created source table definitions in teh DataStage Repository by studying teh data sources by importing teh data from Mainframe.
  • Optimized teh EIM loads to import huge data files faster by adding teh appropriate parameters to IFB file.
  • Translated Business requirements, business rules and business criteria to system specifications and system requirements theirby preparing SRS (System Requirement Specifications) and PRS (Performance Requirement Specifications).
  • Developed a Master data model (MDM) using ERWIN. Also designed teh infrastructure for usage of teh MDM by different applications during teh elaboration phase.
  • Participated in teh Master Data Management (MDM) effort provided technical advice and support toward teh development of strategic and tactical plans for client master data management strategy, data inventories, data governance, data management, storage, and distribution alternatives in support of client MDM strategy.
  • Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
  • Created business requirement documents and integrated teh requirements and underlying platform functionality.
  • Worked with systems area to translate business needs into system requirements.
  • Was responsible for identifying and documenting business rules and creating detailed Use Cases, Use Case models, Use Case diagrams and Object Oriented Analysis and Designs (OOAD) using UML (Unified Modeling Language).
  • With SQL Server 2005 performed ETL processes with mappings and transformations for loading data into Databases and Data warehouses.
  • Involved in teh testing phase right from teh Unit testing to teh User Acceptance testing.
  • Worked closely with PM to coordinate daily activities between Applications Development and Master Database Management teams.
  • Collected and studied teh Metadata about teh Master data for MDM and teh transactional data.
  • Assisted project manager with teh development of project schedules and prepared teh reports that are possible with teh existing data.
  • Functioned as teh primary liaison between teh business line, operations, and teh technical areas throughout teh project life cycle.
  • Configured and customized Subject Area Groups and Subject Areas in IDD, as well as screens and lookups, to meet teh data governance objectives.

Environment: Visual Studio.NET, VB.NET, SQL Server 2008 R2/2005, SSIS, SSRS, VSS, Crystal Reports, MS office 2008, Visio, Windows 7, Windows Server 2008 and Windows Server 2008 R2

Hire Now