SUMMARY:

• 9+ years of extensive functional experience and specialist in Business Requirements, System Analysis, Data Modeling, Design, Development, Testing of business - critical enterprise applications.
• Working as a Business Analyst and having extensive experience on Business Analysis, Requirement Eliciting, creating functional and design artifacts, configuring system, System testing, UAT, post go-live support.
• Expertise in Teradata, Oracle, SQL Server, Informatica, SSIS, SSRS, UNIX, Toad, Microsoft Office Suite.
• Experience in Finance (Retail and Investment Banking) and Healthcare Industry.
• Knowledge in e-commerce platforms.
• Knowledge of uses cases in medical devices manufacturing and banking sector.
• Worked in GXP Compliance based environment
• Having 5+ years of hands-on experience on Agile Scrum SDLC Methodology
• Worked on Credit risk management projects where the project is to develop associated data taxonomy, document data lineage, document data controls catalog which helps in strengthening of Credit Risk data aggregation and risk reporting practices and support decision making process
• Interacted with senior leaders and subject matter experts of credit risk; actively participate in key meetings and review detailed financial reports to conclude on the credit risk management practices.
• Manage and delegate junior BA’s works, also mentoring them in their work stream and provide the guidance. Worked in coordination with Dev/QA team members who works under my work streams in setting up test plans, test cases and test results.
• Worked on various business improvement efforts and initiatives across already implemented projects in banking and healthcare idnusties.
• Proficient in writing T-SQL queries for creating Tables, Stored Procedures, Views, Indexes, Triggers, User Defined Functions.
• Expert in managing and implementing Enterpise / Global System design, SaaS, and Mobile Apps implementation.
• Worked on WCM (Web Content Management) & CRM (Client Relationship Management) and apply specific functional knowledge of WCM applications to help guide the design and implementation of the solution
• Experience in Data Analysis, Data mapping, current and future state workflows, activity and transition state diagrams, traceability matrices, data dictionaries, translation logic rules
• Possess excellent oral and written communication skills and management capabilities. Proficient in resource management and project estimation, creating and tracking Project Plans using MS Project.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center, Informatica Power Exchange, SSIS, SSRS, DataStage

Database Tools: SQL Plus, SQL Loader, SQL Developer, Python, TOAD, Teradata, Tableau, Power BI, IBM DataStage

Business Tools: Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), MS Visio, MS Project, MS Access, MS Office Suite, Doors Erwin Data Modeler, Business Object (Crystal Reports), Office 365, Swim Lanes, Excel Macros - VBA

Domain: Healthcare and Finance (Retail and Investment Banking)

PROFESSIONAL EXPERIENCE:

Confidential, Newark, DE

Sr. Business Analyst

Responsibilities:

• Gathering requirements from users and SMEs through interviews and questionnaires.
• Reviewed and analyzed the business requirements document (BRD) to derive the functional specifications document (FSD) and assisted in the preparation of System Requirement Specifications.
• Responsible for setting up and implementing software processes for on-time project deliverables and good quality.
• Strong leadership role in conducting scope meetings and survey analysis to identify and write Scope document for the project.
• Worked with capital markets back office system that provides straight through processing and real-time securities/FX settlement.
• Worked on SaaS payment software application for customer support and responsible for gathering user requirements and specifications for designing a mortgage based loan system using and documenting the same.
• Worked on Enterprise level design, development and testing of e-commerce platform which helps to relate information like order status, CRM/Peoplesoft, customer referral, credit card billing, reporting, database and front/back end interfaces.
• Involved in developing complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Documented Functional Design Document for P&L Accrued Calculations - Interest Methods for bonds.
• Organized and participated in JAD sessions with developers, user’s testers, users and other stakeholders.
• Authoring business requirements document and Use Case documents using various UML based methods like Use Cases, Process Flow Diagram, Activity Diagrams and Sequence Diagrams.
• Developed simple and complex mappings using Informatica to load dimensions and fact tables as per STAR schema techniques.
• Performing end-to-end analysis and design of business systems including needs assessment, requirements gathering, prioritization, estimating and risk assessment.
• Worked on Credit risk management projects where the project is to develop associated data taxonomy, document data lineage, document data controls catalog which helps in strengthening of Credit Risk data aggregation and risk reporting practices and support decision making process
• Created and implemented SQL Table structure and performed database maintenance to maintain data integrity for new incoming data.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping. Performed SQL Scripting, Transactional Data Analysis and Reporting on MS SQL database.
• I am involved in developing various backend application programs, such as Views, Functions, Triggers, Procedures, and Packages using SQL language. Data analysis on credit card data using cross-validation techniques.
• I was also involved in creating reports from large data sets by writing complex SQL queries with Inner and Outer Joins, Aggregate Functions, Set Operators, Subqueries, System Calendar, OLAP, Ranking Functions, Stored Procedures, Data Types, Logical and Conditional Expressions, CASE expressions, and Views.
• Assisted in supporting DBA team with SQL tuning, constructing materialized views, creating triggers, and creating temporary tables.
• Regularly follow up with the development team to discuss defects identified during Testing throughout Application Lifecycle Management (ALM).
• Performed Regression testing on the entire application and log Issues.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence.
• Extensively used Agile Methodology in the process of the project Data Quality Management based on SDLC.
• Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.
• Involved in performing a gap analysis on the existing data model of the staging layer versus the requirement on Data Quality Management

Environment: Agile, Visio, MS Project, Business Intelligence Tools - Tableau, MS Office, TOAD, IBM DataStage, JIRA, SQL Server, SSIS, SSRS, UNIX, Office 365. MS Excel, SharePoint, VBA Macros, SaaS

Confidential, Minnetonka, MN

Business Analyst

Responsibilities:

• Gathered User and Business Requirements through interviews, surveys, prototyping and observing Stored and modified requirements.
• Extensively worked with Project Manager to determine the current best practices for requirement gathering.
• Created Need Analysis Documents of the requirements gathered through JAD and JRP individual elicitation sessions using MS Word.
• Created User Requirement Specifications (URS), Business Requirement Document (BRD) and Functional Requirement Specifications (FRS) documents.
• Implemented business intelligence dashboards and developed detailed and summary reports, line and pie charts, trend analysis reports and subreports according to business requirements using tableau and SSRS.
• Designed business rules for insurance policies, including accounting SaaS integration.
• Use macros with VBA in excel to create reports based on requirement and populate those results in a report.
• Developed Use Case diagrams, business flow diagrams, Activity/State diagrams and Sequence diagrams using MS Visio so that developers and other stakeholders can understand the business process.
• Involved in analysis of the technical specifications of the current system and the infrastructure needs performed Gap analysis.
• I am involved in developing various backend application programs, such as Views, Functions, Triggers, Procedures, and Packages using SQL language. Data analysis on Insurance data using cross-validation techniques.
• I was also involved in creating reports from large data sets by writing complex SQL queries with Inner and Outer Joins, Aggregate Functions, Set Operators, Subqueries, System Calendar, OLAP, Ranking Functions, Stored Procedures, Data Types, Logical and Conditional Expressions, CASE expressions, and Views.
• Experienced setting up test scenarios, executing these scenarios in Microsoft Test Director. Worked closely with testing team to make sure all the changes made to requirements documents are implemented in their Test Cases.
• Set up definitions and process for test phases including Product test, Integration test, System test and User Acceptance Test (UAT).
• Use Office 365 on daily basis for collaboration and documentation.
• Conducted GUI testing, Functional Testing, Performance testing on the application.
• Created Requirements Traceability Matrix (RTM) across the deliverables for a project.
• Created and maintained reports and documents on SharePoint.
• Utilized Agile methodology development process. Communicated with Development and Management to report on project status, defects, and test estimates.
• Generated ad-hoc SQL queries using joins, database connections, and transformation rules to fetch data from legacy Oracle and SQL Server database systems.
• Broad Understanding of Cognos / Tableau and Power BI tools and ability to translate user requirements into Framework Manager Models and reports.
• Was involved in analyzing scope of testing the application. Test Strategy was created to test the all modules of the Data Warehouse.

Environment: Shell Scripting Linux, Java, UNIX SQL Server, Crystal Reports, Business Intelligence, SAS, Rational tools like Rational Rose and Requisite Pro, Rational Clear Quest, Agile/Scrum, Cognos BI Business Objects, Test Director, Office 365 Suite, SharePoint, JIRA

Confidential

Business /Data Analyst

Responsibilities:

• Utilized Agile development process. Communicated with Development and Management to report on project status, defects, and test estimates.
• Supported full traceability among all artifacts throughout the software development lifecycle
• Extracted the Business Requirements during various sessions with business leads and tagged all requirements in Requisite Pro, tracing them all the way to the stakeholder requirements.
• Data Analysis Primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Extensively worked on Patient, provider, claims and encounters data sets.
• Knowledge of various healthcare systems like Cerner, Epic, Star etc.
• Worked with several tools to access and perform several operations on database.
• Created unique VBA project management utility that facilitated import/export of project forms, modules, and individual procedures, making updating and rebuilding of projects substantially quicker.
• Build and maintain SQL scripts to validate and profile healthcare data.
• I was also involved in creating reports from large data sets by writing complex SQL queries with Inner and Outer Joins, Aggregate Functions, Set Operators, Subqueries, System Calendar, OLAP, Ranking Functions, Stored Procedures, Data Types, Logical and Conditional Expressions, CASE expressions, and Views.
• Closely worked with development teams on business requirements and source to target mappings.
• Designed and developed specific databases for collection, tracking and reporting of data
• Involved in requirements gathering, Analysis, Design and Develop and Maintenance Phases.
• Wrote advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Played a key role in planning UAT and implementation of system enhancements and data migration and conversions.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Worked with Waterfall methodology during the beginning of the project then transitioned to Agile methodology

Environment: Oracle SQL, MS Access, MS Excel MS Word MS Outlook SSIS, SSRS, PowerPoint SharePoint

Confidential

Technical Business /Data Analyst

Responsibilities:

• Utilized Waterfall development process. Communicated with Development and Management to report on project status, defects, and test estimates.
• Worked on Application Development, Application Testing from end to end in a data warehouse implementation.
• Designed and Developed enterprise design / system level implementation documentation and created test cases and test scripts (Both manual and Automated).
• Design and create daily, monthly and ad-hoc reports for BI and Analytics customers
• Provide recommendations for data presentation within reports/dashboards
• Support for end users connected to servers in various departments regarding connection and data access issues.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Work with customers to define reporting needs and implement Tableau reports to satisfy needs
• Played a major role in production support of SSAS cube and SSIS jobs.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• I am involved in developing various backend application programs, such as Views, Functions, Triggers, Procedures, and Packages using SQL language. Data analysis on sales data using cross-validation techniques.
• I was also involved in creating reports from large data sets by writing complex SQL queries with Inner and Outer Joins, Aggregate Functions, Set Operators, Subqueries, System Calendar, OLAP, Ranking Functions, Stored Procedures, Data Types, Logical and Conditional Expressions, CASE expressions, and Views.
• Prepare macros using VBA as and when required and edit and modify them as per the requirement.
• Responsible for loading the identified regression test scripts to Quality Center.
• Identify and create test cases for functional, system integration and regression testing using HP Quality Center.
• Wrote and implemented automated test scripts for various End-to-End data validation across all the up & Down streams using HP Quality Center.
• Coordinated with development team in system integration test and services level unit testing.
• Exported Manual Test Cases from MS Excel template directly to HP Quality Center and executed all the Test Cases in Quality Center with Pass/Fail/Blocked status.
• Data blending implemented on databases and generated interactive dashboards.
• Generated tableau dashboards for sales with forecast and reference lines.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved with Query Optimization to increase the performance of the Report.
• Employed Filtered Indexes to improve query performance and reduce the storage and maintenance cost.

Environment: MS SQL Server 2005, Tableau, SharePoint, Windows 2003 Server, SSIS, Microsoft VISIO, ERWIN, HP Quality Center 10.0