SUMMARY:

• Proactive, confident, goal oriented, pragmatic and attentive Business Analyst and Data Analyst with over 8 years of experience in Health - care, Banking, Retail domains with a focus on designing, development, implementation of business processes and system solutions with the addition of an in depth domain understanding of the entire retail business operations.
• Extensive knowledge, expertise and involvement in various phases of Software Development Life Cycle (SDLC) in Waterfall, Scrum, Agile (Extreme Programming, Test Driven Development) and Scrum Waterfall Hybrid and SAFe software development lifecycle environments.
• Excellent writing and documentation skills in creating, modifying and analyzing Business Requirement Document (BRD), Functional Requirement Document (FRD), System Requirements Specification (SRS), Use Case Specification, High Level and Low Level Documents (HLD/LLD), User Story.
• Experience and Technical proficiency in Designing, Data Modeling, online applications, solution lead for Architecting Data Warehouse/Business Intelligence Applications.
• Designed SQL queries and automated 40+ PowerBI dashboards for to multiple levels of stakeholders by understanding different
• Proficient with analytical reporting using Power Pivot and Macros in Excel, PowerBI, MS Office, Visio for Logical Data Modeling, functional design, technical design, PM and PowerPoint.
• Skilled in conducting and facilitating Requirement Gathering Activities.
• Experienced in enhancing data warehouse with extensive knowledge of Data mapping, Data Modeling, Snowflake and Star Schemas, ETL jobs, OLAP operations.
• Detailed understanding of RACI Matrix (Responsible, Accountable, Consulted and Informed) and prepared Requirement Traceability Matrix (RTM) to map requirement with its origin throughout the process to verify adherence.
• Proficient in Requirement Management, Sprint Planning, Issue Tracking, Impediment Management, and Work Allocation using tools like JIRA(Confluence), RALLY, and HP ALM. Helped PM in preparing various artifacts related to the Planning phase.
• Skilled in System Analysis, E-R/Dimensional Data Modeling, Database Design and implementing RDBMS specific features.
• Knowledge on equity capital market (ECM),border capital market and financial instruments.
• Worked and extracted data from various database sources like Oracle, SQLServer, DB2, Regularly accessing JIRA tool and other internal issue trackers for the Project development.
• Experienced in creating Prototypes, Wireframes and MockUp Screens to visualize Graphical User Interface (GUI) as to understand the layout of the interface using tools like BalsamiqMockUps and MockUp Screens.
• Proven Track Record in conducting ASIS and TOBE analysis, GAP Analysis, Risk Analysis, Cost Benefit Analysis and SWOT Analysis to assist PM in Release Planning as well as PO in setting better stakeholder expectation.
• Experienced in enhancing data warehouse with extensive knowledge of Data mapping, Dimensional Modeling, ETL jobs, OLAP operations.
• Experience working with data modeling tools like Erwin, Power Designer and ERStudio.
• Well versed in writing SQL queries in order to do data manipulation for analysis and reporting.
• Participated in various Scrum Ceremonies including Daily Scrum, Sprint Planning, Sprint Review, Sprint Retrospective and Backlog Refinement meeting as part of the management framework. Helped Product Owner in maintaining information radiators.
• Well versed with backlog prioritization techniques (Business Value, Kano, And Technical Risk) and estimation techniques (T-Shirt sizing, Planning Poker, Complexity buckets, value streaming and technical risk based estimations) to help product owner in picking Product Backlog Items (PBIs) to commit to in the iterations (Sprints).
• Works collaboratively with resources within the department and across supporting business units in support of new connected car product offerings and capabilities
• Proven expertise in developing Test Cases, Test Plans, Procedures and Traceability Matrix and documenting defects using HP QC and HP ALM. Collaborated and monitored BlackBox Testing, Smoke Testing, User Acceptance Testing (UAT) and Regression Testing.Helped testing team in understanding test scenarios regarding Interface testing &API testing.
• Created Training Script and conducted Training Sessions for the end users in the production environment once the product went live and was ready to use.
• Knowledge of working with Proof of Concepts (PoC’s) and gapanalysis and gathered necessary data for analysis from different sources, prepared data for dataexploration using datamunging and Teradata.

TECHNICAL SKILLS:

Languages: SQL, C, C++, XML, HTML, DHTML, HTTP, Python

Databases: SQL Server 2014/2012/2008/2005/2000, MS-Access, SybaseOracle 11g/10g/9i and Teradata, MongoDB, PG Admin 4

DWH / BI Tools: Microsoft Power BI, Tableau, SSIS, SSRS, SSAS, Business Intelligence Development Studio (BIDS), Visual Studio, Crystal Reports, Informatica 6.1

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Fact & Dimensions tables, Physical & Logical Data Modeling in Power Designer 16.1

Tools and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, Import & Export Wizard, Microsoft Management Console, Visual Source Safe 6.0, DTS, Crystal Reports, TFS,Microsoft Office, Excel Power Pivot, Excel Data Explorer, Tableau, JIRA(Confluence), Rapid SQL, MongoExpress, RapidSQL, PowerBI.

PROFESSIONAL EXPERIENCE:

Confidential, Reston, Virginia

Business Data Analyst

Responsibilities:

• Acted as Sr Business Analyst on Confidential initiative to combine a legacy and existing claims processing system (Javelina ) into one single platform.
• Worked on gathering requirements from different vendors in sending or receiving the eligibility, authorizations feed post to Confidential . Prepared business requirement document for each and every vendor that we have on-boarded.
• Actively involved in updating internal processes (submit claims, check eligibility), updating data collection and data reporting.
• Prepared Use Cases, User Stories and Test Cases as per the user requirements documentation and developed detailed work plans, schedules, project estimates, resource plans and status reports.
• Generated reports and performed data validation in Talend Open Studio.
• Allocated the stories to developers during sprints and performed milestone tracking.
• Worked on preparing scope documents and allotted tasks to developers.
• Worked on testing the output extracts that were generated from the claims processing systems with QA based on the requirements defined.
• Worked closely with SMEs and vendors to define the requirements.
• Provided source to destination mapping information to development Team for loading the data from files we receive to the existing claims system.
• Incorporated and implemented all HIPAA standards, Electronic Data Interchange (EDI 834, 837, 278) transaction syntax like ANSI X12, ICD-9, ICD-10coding.
• Conducted user acceptance testing and data validation of web applications used to present benefit information.
• Worked on PG Admin 4 in getting data from different tables and validating the output extracts with GUID.
• Developed and maintained Confluence pages for Eligibility outbound feeds to different vendors.

Confidential, Chicago, Illinois

Business Analyst / Data Modeling

Responsibilities:

• Prepared Use Cases, User Stories and Test Cases as per the user requirements documentation and developed detailed work plans, schedules, project estimates, resource plans and status reports.
• Assisted Project Manager in preparing status updates, Scorecards and Burn Down Charts.
• Allocated the stories to developers during sprints and performed milestone tracking.
• Worked on preparing scope documents and allotted tasks to developers and QA team.
• Performed UAT and Conducted daily status calls with Development and QA teams.
• Worked closely with data governance, SMEs and vendors to define data requirements.
• As a Business Analyst gather the requirements for the data model and design conceptual, logical and physical models using Power Designer.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Designed the prototype of the Data mart and documented possible outcome from it for end-user.
• Involved in business process modeling using UML
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Actively involved in updating internal processes (submit claims, check eligibility), updating data collection and data reporting.
• Responsible for creating data flow analysis and processes and creating management reports based on the analysis.
• Coordinated with the stakeholders and project key personnel to gather functional and non-functional requirements during JAD sessions.
• Worked with ETL to load data from SQL tables to NoSQL databases(MongoDB) with referential integrity and developed queries using SQL, SQL*PLUS and Rapid SQL.
• Provided source to destination mapping information to ETL Team for loading the data from SQL Database to NoSQL database(MongoDB)
• Analyzed ETL jobs and mappings to document the existing transformation logic and understand ETL strategies used.
• Worked on analyzing and designing of snowflake Schemas , Dimensional Data Modeling , SCD (Slowly Changing Dimensions), and CDC (Change Data Capture)
• Prioritized stories based on user and business requirements as system requirements that must be included while preparing the software and communicated the same to development team.
• Experience in maintaining database architecture and metadata that support the Enterprise Datawarehouse.
• Worked on various QlikView Data Models by extracting and using the data from various sources files, DB2, Excel, Flat Files.
• Handled importing data from various data sources, performed transformations using Hive, Map Reduce, and loaded data into HDFS.
• Interaction with SMEs and other Data Architects to understand Business needs and functionality for various project solutions.
• Incorporated and implemented all HIPAA standards, Electronic Data Interchange (EDI 834, 837, 278) transaction syntax like ANSI X12, ICD-9, ICD-10coding

Environment: Rapid SQL, MongoDB, Power Designer 16.1, Informatica 9.0, ODS, OLTP, OLAP, DB2, Metadata, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro, JIRA, Rapid SQL, MS VISIO,SQL,SQL Server

Confidential, Rochester Hills, Michigan

Business Data Analyst/ Modeler

Responsibilities:

• Worked as a Modeler/Analyst to generate Data Models using Erwin and developed relational database system.
• Analyzed the business requirements of the project by studying the Business Requirement Specification document.
• Extensively worked on Data Modeling tools Erwin Data Modeler to design the data models.
• Designed mapping to process the incremental changes that exists in the source table. Whenever source data elements were missing in source tables, these were modified/added in consistency with third normal form based OLTP source database.
• Designed tables and implemented the naming conventions for Logical and Physical Data Models in Erwin 7.0.
• Worked on modern capital markets that almost invariably hosted on computer-based electronic trading systems.
• Provide expertise and recommendations for physical data base design, architecture, testing, performance tuning and implementation.
• Designedlogical and physical data models for multiple OLTP and Analytic applications.
• Extensively used the Erwin design tool &Erwin model manager to create and maintain the DataMart.
• Designed the physical model for implementing the model into oracle9i physical data base.
• Involved with DataAnalysis primarily Identifying DataSets, SourceData, Source Meta Data, Data Definitions and Data Formats
• Performance tuning of the database, which includes indexes, and optimizing SQL statements, monitoring the server.
• Wrote simple and advanced SQL queries and scripts to create standard and adhoc reports for senior managers.
• Collaborated the data mapping document from source to target and the data quality assessments for the source data.
• Used Expert level understanding of different databases in combinations for Data extraction and loading, joiningdata extracted from different databases and loading to a specific database.
• Co-ordinate with various business users, stakeholders and SME to get Functional expertise, design and business test scenarios review, UAT participation and validation of financial data.
• Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for the new programs.
• Designed and developed UseCase, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML and Visio.

Environment: SQL Server 2008R2/2005 Enterprise, SSRS, SSIS, Crystal Reports, Windows Enterprise Server 2000, DTS, SQL Profiler, and Query Analyzer.

Confidential, Detroit, MI

Business Data Analyst (Data Science )

Responsibilities:

• Involved in the migration of content from old Tableau server to new Server.
• Constantly researching best practices for automobile financing solutions and risk adjustment.
• Creating of Business Process Workflow Diagrams with Stakeholders throughout the Business System Development Life Cycle (SDLC).
• Provided domain understanding and subject matter expertise of business processes, business rules and operations workflow within the domain.
• Involved in complete life cycle process (SDLC) i.e., Requirements gathering, Design, Develop, Test and Implementation.
• Worked in creating Test plan, Test cases and executing the Test scripts. Participated in Functional testing, Regression testing, and User Acceptance Testing.
• Working extensively with .Net developers, QA teams in order to review the implementation phase of the project.
• Accessed entities within the financial sector of the treasury department within the organization .
• Responsible for managing and supervising the project team consisting of 1 data modeler, 2 software testers and 3 developers.
• Actively worked in the logical and physical design sessions with the data modeler and developed design documents and pattern documents.
• Designed new process flows for the existing system as well as for the enhanced system.
• Created Wireframes for the User Interface (UI) design using Mock flow, Balsamiq.
• Worked on developing Use Cases, Workflow, and Business process flow diagrams and documenting them using MS Visio.
• Customization of Sales Force (SFDC) User Interface to accommodate the sales department requirements.
• Worked on XML Data Mapping from loan origination systems to third party vendor systems such as Credit card payments, Dealer Track, Trans-Union, Sales Force (SFDC), etc.
• Data-monitor is engaged in providing cutting edge business information and delivering independent data and analysis by generating reports across leading industry verticals.
• Facilitated Joint Application Development (JAD) sessions to design Data Flow Diagrams (DFD’s) for the different phases of requirements. Acted as liaison between end users and technical team to address issues and recommend solutions.
• Conducted Daily triage meeting and managed defects using JIRA.
• Developed SQL scripts for verification and validation of data to ensure correctness of the data migrated from source to target and business rules were successfully implemented.
• Documented workflow for each of the batch process feeding to the master database.
• Assisted in developing different dimensions such as slowly changing, rapidly changing, and conformed dimensions and fact tables with facts and measures as per business requirement documents.
• Designed logical and physical data models for multiple OLTP and Analytic applications.
• Extensively used the Erwin design tool &Erwin model manager to create and maintain the DataMart.
• Worked on the physical model for implementing the model into Mongo DB
• Involved with Data Analysis primarily worked on SSAS. Created Cubes in SSAS.
• Performance tuning of the database, which includes indexes, and optimizing SQL statements, monitoring the server.
• Collaborated the data mapping document from source to target and the data quality assessments for the source data.
• Got an opportunity to learn and work on generating dashboards and reports and PowerBI.
• Used Expert level understanding of different databases in combinations for Data extraction and loading, joining data extracted from different databases and loading to a specific database.
• Co-ordinate with various business users, stakeholders and SME to get Functional expertise, design and business test scenarios review, UAT participation and validation of financial data.

Environment: SQL Server 2008R2/2005 Enterprise, SSAS, SSIS, Crystal Reports, Windows Enterprise Server 2000, DTS, Mongo DB, TFS, Power BI, Jira, PL SQL, Oracle 12, PowerBI.

Confidential, Dallas, TX

Business Analyst (Data)

Responsibilities:

• Gathered User and Business Requirements to create Business Requirement Documentation (BRDs) using MS Word and MS Visio that provided appropriate scope of work for technical team to develop prototype and overall system.
• Conducted AS-IS and TO-BE analysis and assisted in developing process models and systems integration structure.
• Conducted and facilitated Joint Application Development (JAD) sessions to reduce time spent in moving information between stakeholders and team members.
• Wrote Test Cases and Test Plans for related and assigned scripts as per test strategies defined in project and testing team guidelines in Quality Center.
• Assisted the testing team to perform User Acceptance testing and Quality Assurance Testing.
• Recommended corrective actions along with progress against Development/Action Plan routinely to Project Manager.
• Tracked and maintained Stakeholder requested enhancements and changes using Requirement Traceability Matrix (RTM).
• Identified critical areas of business risk and modified business processes to reduce risk using Risk Management Process.
• Worked with source system Subject Matter Experts (SMEs) to ensure extracts were properly mapped.
• Used MFT to perform secure transfer of customer billing data to the server.
• Used SQL for data mapping, enabling data warehousing and querying.
• Wrote requirements document for ETL - Data Extraction, Data Analysis and Loading process of collected data as part of data mapping procedures.
• Gained Compliance audit experience due to exposure to legal/audit consulting groups.

Environment: MS Office, Quality Center, SQL Server, MFT, MS Project, Server, MS Visio, Unix, Java, XML, Rational ClearQuest, ClearCase, Windows XP

Confidential

Data Modeler

Responsibilities:

• Extracted data from Oracle and SQL Server and DB2 using Informatica to load it into a single data warehouse repository.
• Created entity relationship diagrams and multidimensional data models, reports and diagrams for marketing.
• Used Model Mart of ERwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Developed and implemented measurements for various marketing campaigns.
• Created a net loss model which analyzes the impact of loan defaults and recoveries.
• Created a relational model and dimensional model for online services such as online banking and automated bill pay.
• Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets.
• Developed logical data models and physical data models using Power Designer.
• Facilitated QA for developing test plans and test cases for unit, system and Enterprise testing.
• Collaborated on the data mapping document from source-to-target and the data quality assessments for the source data.

Environment: R 3.0, Erwin 9.5, PowerDesigner, TFS, MS EXCEL, MS Visio, Waterfall, SQL, POWERBI

Confidential

Data Analyst

Responsibilities:

• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
• Involved in defining the source to target data mappings, business rules, data definitions.
• Worked with BTEQ to submit SQL statements, import and export data, and generate reports in Teradata.
• Responsible for defining the key identifiers for each mapping/interface.
• Responsible for defining the functional requirement documents for each source to target interface.
• Document, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
• Remain knowledgeable in all areas of business operations in order to identify systems needs and requirements.
• Responsible for defining the key identifiers for each mapping/interface.
• Implementation of Metadata Repository, Maintaining Data Quality, Data Cleanup procedures, Transformations, Data Standards, Data Governance program, Scripts, Stored Procedures, triggers and execution of test plans
• Performed data quality in Talend Open Studio.
• Coordinated meetings with vendors to define requirements and system interaction agreement documentation between client and vendor system.
• Enterprise Metadata Library with any changes or updates.
• Document data quality and traceability documents for each source interface.
• Establish standards of procedures.
• Generate weekly and monthly asset inventory reports.

Environment: Erwin r7.0, SQL Server 2000/2005, Windows XP/NT/2000, Oracle 8i/9i, MS-DTS, UML, UAT, SQL Loader, OOD, OLTP, PL/SQL, MS Visio, Informatica.