SUMMARY:

• Sr. Data/Business Analyst professional with 8 years of track record in requirements gathering, performing gap analysis, data analysis and document between 'As - is' and 'To-be' processes.
• Having excellent communication, organizational and presentation skills, inter-personal relationship and ability to be part of team.
• Liaison between the cross-functional teams, top management clients, users and any stakeholder involved in the project.
• Dealing with processes, governance, policies, standards and tools as part of MDM to consistently define and manage the critical data of the organization.
• Experience in creating Business Process Models for business from conceptual to procedural level i.e Designing a Project and Defining the Scope, managing the project until delivery.
• Experienced in creating business process using use case, UML Class diagrams
• Skilled at gathering requirements by conducting one on one interviews, brainstorming sessions and Joint Application Development (JAD) sessions.
• Extensively involved in MDM to help the organization with strategic decision making and process improvements. (Streamline data sharing among personnel and departments).
• Demonstrated ability to document business processes and write detailed functional requirement document (FRD) or business requirement Specification (BRS), Software Requirement Specification (SRS) and Use Case Specification.
• Experienced in preparing process documents like Project plan (Scheduling and maintain the project timeline (Project planning/ tracking)), change request tracking, Project status report, Project issues and risk mitigation plan / reports.
• Technically competent professional with rich experience in Designing prototype (GUI) of the application, web or mobile application wireframes. Blueprint of the prototype / application were designed using MS Visio and MS Office.
• Involved in MDM Process including data modeling, ETL process, and prepared data mapping documents based on graph requirements.
• Wrote SQL queries to extract related data from transaction record database for OLAP purposes.
• Extensive Experience with data analysis including data modeling, data mapping and data validation.
• Having working experience in SQL and Oracle Databases.
• Having involved in Full Implementation Life Cycle of the application (SDLC) and in post implementation support using Agile Methodology (Scrum Framework), Waterfall.
• Having experience in Documentation tools like MS Visio, Microsoft Office.
• Excellent technical writing skills and ability to peer review technical documents for grammar, content and style of writing.
• Ability to work under tight timeframes. Capability to handle sensitive and complex issues with discretion and good judgment.
• Effectively tested, logged and managed defects found during project system testing, functional testing using BRD with different browser for web applications and validating outputs generated.
• Validating data, mobile web services on various devices and platforms for mobile apps.
• Proficient in developing UAT plans, UAT cases, executing UAT.
• Skilled in training end user and ensure readiness of the user for UAT and train the trainer.

TECHNICAL SKILLS:

Languages: T-SQL, Pl/SQL, R, Python

Data Visualization: Tableau Data Analysis SAS, R

Modeling Technique: Predictive Modeling/ANOVAs/Linear Regression, Logistics Regression/Cluster analysis Web Technologies HTML, DHTML, JAVA Script, XML, XSD

Databases: MS SQL Server, MS-Access, Oracle

Reporting: SQL Server Reporting Services (SSRS), Tableau

Process/Model Tools: MS Office, MS Project, Visio, Rational Rose, RequisitePro, IDQ, Collibra, MDM, Clearcase, Clearquest, MS Excel, MS Power Point, MS Word, SharePoint

PROFESSIONAL EXPERIENCE:

Confidential - Charlotte, NC

Sr. MDM Business Analyst

Responsibilities:

• Created data governance and privacy policies
• Defined accountability procedures governing data access, processing, storage, retention, reporting and auditing measuring contract compliance
• Gathered and documented MDM application, conversion and integration requirements.
• Assist with managing all facets of project life cycle, including design, development, testing, and deployment.
• Support Data and Analytics/Transformation Architecture teams who are building a data strategy aligned with global strategic direction - develop canonical and other models as required, implementing data architecture platforms and solutions and data services, develop MDM foundation, participate in the design and implementation of unified data warehouse; must be able to implement end to end solutions in support of the various data tracts and work streams
• Developed the Stone Soup Pharmaceutical Data Model. Assisted on the development of a proposal for a major client.
• Led development and documentation of data governance policy and procedures as well as Stewardship inventory and control set up processes for MDM projects
• Used Netezza SQL to maintain ETL frameworks and methodologies in use by the company.
• Collaborated with software architects to ensure alignment of the Netezza environment.
• Developed data stewardship program establishing metadata registry responsibilities
• Implemented metadata standards, data governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modelling
• Gathering the information about manual sources that are not captured in point of delivery (POD) Mappings.
• Responsibilities:
• Work with users to identify the most appropriate source of record and profile the data required for sales and service.
• Worked with internal architects and, assisting in the development of current and target state data architectures.
• Extensively involved in MDM to help the organization with strategic decision making and process improvements. (streamline data sharing among personnel and departments)
• Delivered consistent daily results as the fixed income capital markets office manager reporting directly to SVP and VPs of trading desk
• Broad technology background and comprehensive exposure to various capital markets research and electronic trading platforms such as BondDesk, Valubond, TradeWeb and Bloomberg.
• Defined frameworks for Operational data system (ODS), Brokerage data warehouse (BDW), Central file distribution (CFD) and Data Quality (DQ) and created functional data requirement (FDR) and Master Test Strategy documents.
• Involved in defining the source to target data mappings, business rules, business and data definitions.
• Developed the financing reporting requirements by analyzing the existing business objects reports.
• Interact with computer systems end-users and project business sponsors to determine, document, and obtain signoff on business requirements.
• Utilized Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for data profiling.
• Support and development of medical research information systems for data acquisition and management; Database-driven Python applications; Migration, Data transformation and validation tool development; Technical lead for several projects.
• Generate weekly and monthly asset inventory reports.
• Evaluated data profiling, cleansing, integration and extraction tools (e.g. Informatica).
• 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.

Environment: MS Project, Microsoft Visio, C#, Rational Suite (RequistePro, ClearQuest, Clearcase ), Requisite Pro, Clearcase, Rational Rose, Business Objects ClearQuest, DOORS, Informatica, Passport, Teradata, Visual Studio, Biz talk Server, Visual C#, MS SharePoint Services

Confidential - Monticello, NY

Business Analyst/Data Analyst

Responsibilities:

• Performed Requirement Gathering & Analysis by actively soliciting, analyzing and negotiating customer requirements and prepared the requirements specification document for the application using MS Word.
• Perform "AS IS" system study to understand the business process and design "TO BE" system structure
• Identify GAP in various business processes. Conduct discussion sessions with various business owners and redefine business processes for the new POS system.
• Immensely diverse and critical role in a growing organization, encompassing IT Project Manager, Business Analyst and E-Marketing Specialist.
• Solely responsible to extract and document technology strategy and all individual project requirements from executives and develop into an implementation plan.
• Active Directory user Windows administration.
• Performed as an enterprise MDM subject matter expert. Responsible for delivering customer information systems across North America and Canada. Took responsibility for integrating variety of data systems, and geographically fragmented customer information.
• Understand the business and number of transactions per day and Design and ease the POS interface screen for quicker sales transaction and to print out daily X & Z reports
• Involved in setting up business process of using various tenders and till maintenance
• Involved in defining business process to in corporate Buy-downs, promotions, Mix and Match, discounts, Customer Loyalty Program for new POS system tobacco franchise
• Set up the rules for auto generation of Purchase Order and it can be verified by the retail store manager.
• Extract data from business intelligence system and generate reports for planning/MDM, manufacturing and other areas of the supply chain.
• Implement new methods to replenishment inventory based on sales pattern, Min-Max, Days of Inventory, Inventory replenishment based on actual sales and manual order entry
• Prepare weekly dispatch schedule based on the order cycle and availability of product, use local transportation companies to set up XDX at warehouse for faster delivery from wholesaler to retail store.
• Design & Implement suggested stock transfer functionality with days of Inventory level
• Involved with QA team to define the test plan and test cases for new application also perform Functional integration testing for the system.
• Involve in database design and write complex query to generate customize reports in SQL.

Environment: MS Office (word, outlook, Excel), Siebel Systems TestLink, OBIEE, MS Project, C, MS Visio, SQL Server, SAP NetWeaver MDM, InfoSphere MDM, JIRA, Confluence.

Confidential - Los Angeles, CA

Data/Business Analyst

Responsibilities:

• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
• Transformation of requirements into data structures which can be used to efficiently store, manipulate and retrieve information
• Collaborate with data modelers, ETL developers in the creating the Data Functional Design Documents.
• Ensure that models conform to established best practices (including Normalization Rules) and accommodate change in a cost-effective and timely manner.
• Created new reports based on requirements.
• Responsible in Generating Weekly ad-hoc Reports
• Performed data analysis and data profiling using Informatica Data Quality (IDQ)
• Attended weekly status meetings and represented the MDM Data platform
• Documented business and technical requirements gathering for the development of MDM, Data Warehousing and Reporting implementation roadmaps
• Led development and documentation of data governance policy and procedures as well as Stewardship inventory and control set up processes for MDM projects
• Gathered requirements for MDM tool implementation and user workflow processes
• Implemented metadata standards, Collibra Data Governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modeling
• Planned, coordinated, and monitored project levels of performance and activities to ensure project completion in time.
• Define the list codes and code conversions between the source systems and the data mart.
• Worked with internal architects and, assisting in the development of current and target state data architectures.
• Reviewed daily compliance reports (CRD) and weekly audits, researching non-compliance issues and forwarding findings to Portfolio Managers for resolution
• Implemented software and hardware components for Microsoft Dynamics CRM and XRM applications
• Conducted customization and migration of Microsoft Dynamics CRM applications and latest system upgrades
• Created and modified tables, views and indexes; PL/SQL stored procedures, functions and triggers according to business requirement.
• Created business reports by joining multiple tables from multiples database using complex SQL queries.
• Performed in depth analysis in data & prepared weekly, biweekly, monthly reports by using SQL, SAS, Ms Excel, MS Access, and UNIX.
• Created and manipulated datasets using SAS, Access, and Excel.
• Involved in Building a specific data-mart as part of a Business Objects Universe which replaced the existing system of reporting that was based on exporting data sets from Teradata to Excel spreadsheets
• Migrated three critical reporting systems to Business Objects and Web Intelligence on a Teradata platform.
• Perform small enhancements (SOR element additions, data cleansing/data quality).
• Create various Data Mapping Repository documents as part of Metadata services (EMR).
• Provide inputs to development team in performing extraction, transformation and load for data marts and data warehouses.

Environment: Agile Scrum Methodology, Smart Draw, Microsoft Visio, JIRA, Oracle DB, MS Excel, MS Access, Teradata, UNIX, Designer, Informatica, SAS EG, SAS

Confidential, Lincoln, NE

Business analyst

Responsibilities:

• Worked as a liaison among business client and development team for the implementation of 4010 to 5010 transition in compliance with HIPAA standards.
• Identified the business functions and processes, and prepare system scope and objectives based on user needs and industry regulations.
• Defined terms, conducted stakeholder analysis, elicited business needs, conducted business process modeling work, facilitated work sessions (JAD), elicited requirements, wrote requirements and use cases, analyzed requirements, validate & prioritize requirements, trace requirements to related project documentation (process models, designs, test scenarios & scripts).
• Gathered requirements by using interviews, observation, JAD, brainstorming sessions, and documents analysis.
• Responsible for the analysis, design, development, testing, and support of data extract, transform, and load processes within the enterprise data warehouse
• Created Collibra Data Governance and privacy policies specifying contract implementation
• Developed complex SQL queries to create OLAP cubes inside the data-warehouse.
• Migration of new customer data platform from legacy system CDB to new MDM.
• Setting of timelines to meet the required time and designing project plans using Microsoft project.
• Documented standard procedures for developing and designing all BI solutions.
• Own, managed and created data mapping documentation of Customer Information and Payment information from old CDB platform to new MDM platform.
• Work closely with the team members to identify any bugs, fixes, any issues regarding the development and designing.
• Used Data Mining extensively to analyze data from different perspectives and summarizing.
• Used MDM tool to support Master Data Management by removing duplicates, standardizing data (Mass Maintaining), and incorporating rules to eliminate incorrect data and filter data as per requirements.
• Involved in Data mapping, logical data modeling used SQL queries to filter data within the database tables.
• MDM to resolve data issues to recognize the inconsistent and duplicate data and finding useful relationships to improve business performance.
• Worked with the ETL tool like Informatica for data integration and data quality services.
• Developed a Schedule and identified project milestones.
• Analyzed business scenarios to track possible business outcomes for the functions which could be incorporated into more detailed test scripts.
• Reported project progress to the team, senior management and all stakeholders periodically.
• Identified risk and project impact and performed risk assessment and mitigation.
• Reviewed various Re-engineering techniques with Technical Experts to finalize the Approach. Reviewed functional test cases to confirm the expected outcome and behavior.

Environment: Agile Methodology SCRUM, MS Visio, MS Office Suite, Informatica Power Center, SQL Server, Teradata SQL Assistant, Unix, Excel VLOOKUP, HIPAA, EDI, Windows, MS Office

Confidential, Stratham, NH

Business Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Thoroughly studied the requirements for the process re-engineering. Gathered requirements and modeled the data warehouse and the underlying transactional database
• Create and maintain data model/architecture standards, including master data management (MDM)
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Designed the business requirement collection approach based on the project scope and SDLC Methodology.
• Developed SQL Queries and stored procedures to fetch complex data from different tables in remote databases using joins, database linked servers and formatted the results into reports.Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Developed the project by RUP methodology. Performed gap analysis. Designed flexible project foundation enabling rapid implementation of e-commerce website capabilities
• Created Activity Diagrams, Sequence Diagrams and ER Diagrams. Prepared and documented System Requirements and workflows for Content Management Application tool.
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.

Environment: Microsoft Office Suite, Casewise modeller, Unix, Documentum, .NET, Informatica, Asp. Net, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, VBScript, DOORS, Java, C++, TestDirector, LoadRunner