SUMMARY:

• Over 7 years of experience as a Business Analyst in IT and Health and Fitness industries exposure to all phases of the Software Development Life Cycle (SDLC).
• Worked on ETL AbInitio on DW & BI projects. As part of my assignments, I have been involved in Requirement Analysis, ETL Design, and application development, Application Maintenance, Functional Studies, Quality Reviews and Testing.
• Experience with healthcare system, Medicaid and with prime focus on claims adjudication, provider, eligibility and prior authorization.
• Working in Agile project methodology with product owner and scrum master for preparing detailed work plans, schedules, project estimates, resource plans and status reports.
• Proficient at working in large, complex, mufti - platform environments for global organizations.
• Extensively worked on Ab Initio Components - Datasets, Database, Partition and Transform.
• Deep Knowledge in Normalization/ De Normalization technique for optimum performance in relational and dimensional database environments.
• Well versed in Data Warehousing Concepts like Star Schema and Snowflake Schema, Slowly Changing Dimensions, foreign Key Concepts, referential integrity.
• Preparation of High Level Technical Design Document (TDD) and Low Level ETL Design documents to build a Data Warehouse.
• Experienced professional in the field of project management and organizational skills that balance work, team support and ad-hoc responsibilities in a timely and professional manner. Hands on experience in Planning, Scheduling and project cost control.
• Proficient in Business process analysis and improvement, with solid understanding of requirement specification gathering and documentation.
• Expert in interacting with business team, project sponsors and other stakeholders to understand the system requirements and delivery of project.
• Adept in the complete life cycle of project development (SDLC) including System Analysis, Design, Development, Testing and Deployment.
• Experience in documenting and Cresting Test Plans, Test Objectives, Test Cases and Test Scripts.

TECHNICAL SKILLS:

BUSINESS SKILLS: Project Management & Scheduling, Business Analysis, Budgeting & Cost Estimation, Vendor Management, Resource Management, Risk Management, Requirements Gathering, Work Breakdown Structure (WBS), Business Intelligence, Data Migration, Data Mining and Data Warehousing.

OPERATING SYSTEMS: Windows, UNIX, Linux

DATABASES: MS Access, MySQL, SQL Server

METHODOLOGIES : Agile, UML, Rational Unified Process (RUP), SDLC, OOAD

PROFESSIONAL EXPERIENCE:

Sr. Business/Data Analyst

Confidential, Charlotte, NC

Responsibilities:

• Played key role in System Development Life Cycle Process consisting of: Design and Analysis of Business Requirements, Systems Requirements, Test Criteria, and Implementation.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Led the development of a training program to train users on a custom web application.
• Owned the entire reporting process. Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modelling.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Extensively involved in data modelling.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Gathered requirements and modelled the data warehouse and the underlying transactional database.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL).
• Involved in the testing phase right from the Unit testing to the User Acceptance testing.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Involved in jobs and analyzing scope of application, defining relationship within & between groups of data, Star Schema etc.
• Followed the UML based methods using Rational Software Modeler/MS Visio to create: Use Cases, Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Tuned the batch programs and online transactions to alleviate performance problems.
• Developed & executed several Optimized queries in SQL on this data.

Environment: Microsoft Office Suite, Microsoft Visio, ETL, Documentum, Windows NT/XP, Oracle, SQL, SQL Server

Business/Data Analyst

Confidential, Tennessee

Responsibilities:

• Gathered and translated business requirements into detailed, Business requirement document and Functional Requirement Specifications and involved in analyzing them.
• Responsible for creating mapping documents for requested data fields from Third Party Systems.
• Responsible for direct interaction with the business consultants, DBA team and End user to gain a thorough understanding of the data being requested.
• Created the Source to Target mapping documents and developed the file processing rules.
• Involved on developing the transformation logic and creation of data field conversions.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models.
• Owned the entire reporting process. Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.
• Analyzing data in Hive tables
• Creating Hive tables and partitions.
• Ad hoc query execution and report generation based on customer needs and performance tuning in hive.
• Design and or develops data base objects (databases, tables, stored procedures, DTS Packages) to support the collection, tracking and reporting of business data.
• Worked extensively on Data Quality(running Data profiling, Examine Profile Outcome), Metadata management(loading metadata, mapping metadata, or perform data linkage)
• Involved in deploying in the Production environment along with developers and providing production support for data when issues arise.

Environment: Erwin, MS-Excel, MS-Access, HIVE, ETL and Windows Server

Business Analyst

Confidential, Miami, FL

Responsibilities:

• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Gathered user and business requirements through open-ended discussions, brainstorming sessions and role-playing.
• Prepared Logical Data Models using ERWIN that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
• Troubleshot the designed jobs using the Data Stage Debugger.
• Tuned Data Stage transformations and jobs to enhance their performance.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Created test scripts for all the test cases in PL/SQL.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on an ad hoc or scheduled basis.
• Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.
• Designed Data Stage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Responsible for designing and developing universes for development of reports using business object designer.
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Query optimization using SQL Profiler and performance monitors to enhance the performance of database servers.
• Created Activity Diagrams, Sequence Diagrams and ER Diagrams.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution.
• Designed and Administered Teradata Scripts, Tables, Indices and Database Objects
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Developed strategies with Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing.

Environment: Microsoft Office Suite, Microsoft Visio, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, PL/SQL, ETL, Sybase.

Business Aanalyst

Confidential

Responsibilities:

• Gathered and documented business requirements.
• Analysed business needs, created and developed new functionality supporting in-house development projects.
• Participated in the identification, understanding, and documentation of business requirements, including the applications capable of supporting those requirements.
• Translated the business needs into system requirements, communicating with the business on a non-technical level, and with the System Analyst on a more technical level.
• Collaborated with development architect and the business to develop both high-level and detailed application architecture to meet the business needs.
• Performed GAP Analysis and Impact Analysis for all business requirements having an impact on the existing application.
• Using GAP analysis, reviewed high level company processes, identified gaps that require operational change in order to optimize the proposed system solutions.
• Designed and developed activity diagrams and, sequence diagrams.

Environment: MS Project, MS Office, Windows XP, RUP, UML