PROFESSIONAL SUMMARY

More than *+ years as a Business System Analyst and Quality Analyst in analysis, design and testing of enterprise client/server and web-based applications and associated tools.

Strong experience in Unified Modeling Language (UML), Waterfall Methodologies, RUP methodologies and Agile (Scrum, XP) Methodologies.

Extensive experience in handling Business Intelligence tools, experience in installing, upgrading and configuring MSBI pack.

Experience in Data management tools like SQL Server, Erwin, embarcadero, etc.

Gathered and analyzed business user needs and translated them into proper technical requirements. Strong analysis of user, business, data and functional requirements.

Strong skills in creating FSD/SRS, BRD’s and maintaining the RTM all through the project to help the developers and the testing team.

Excellent skills in designing Logical and Physical Modeling.

Strong experience in developing test plans, test cases, test scripts, managing defect cycle and providing reports on daily basis to the PMO’s.

Performed logical testing, sanity, smoke testing after new build and adhoc testing in various environments to measure the efficiency of various systems.

Experience in developing reports on daily basis using SSRS and data transformations using SSIS.

Strong experience in providing training to business users/SME's - online classes, classroom training, workshops in groups and one-one.

Excellent understanding and expertise in writing complex SQL (DDL, DML and DCL) queries to perform back-end testing.

Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.

Ability to handle multiple tasks and work independently as well as in a team.

Good academic background, strong analytical and problem solving skills.

TECHNICAL SKILLS

Project Management: MS Project Server 2010, Excel spread sheets, and Share Point 2013.

Process/Model Tools: MS Visio, Erwin, MS Business Intelligence tool (ETL), Workflows, UML, Star Team, Data mapping, and ECM (IBM file net and ICN)

MS Office Suite- Word, Excel, PowerPoint, MS Outlook, SQL Server

Testing Tools: Quality Center, IBM Jazz, load Runner, Visual Studio TFS, Clear Case and SOAPUI

Web Technologies: Visual Studio (C#, .NET), HTML, XML, and SQL

Operating System: Windows 95/98/NT/2000/XP, UNIX

Web Tools: MS Front Page, Adobe Photoshop

PROFESSIONAL EXPERIENCE

Criminal Justice Information System for CT Mar 2015 – till date

Senior System Business Analyst / Senior Quality Analyst

The Criminal Justice Information System (CJIS) Governing Board project is about, developing an application programming interface for Connecticut Information Sharing Systems to exchange data between various government agencies like the police department and State judicial agencies in order to track and help the government in viewing and maintaining criminal history. This project has two phases with list of major releases for every phase depending on other Government Agencies.

Collaborated with vendors, stake holders, SME’s and agency technical staff members to identify and document business requirements and testing strategies to support CJIS initiatives

Distributing the technical requirements documents and testing documents to various Government agencies which are in interest towards the data, Coordinate design reviews of workflows and requirements between stakeholders.

Being knowledgeable on all facets of Software Development Methodologies (SDM)/ STLC and assisting the CISS team on SDM compliance for CJIS activities.

Design technical workflows based on business requirements, analyzed complex data models & prepared a functional document for business analysis.

Delivery of high quality data visualizations using MS Excel.

Experience in creating design specifications, developing replication scripts and documenting source system data elements using UML, ERD and a UI reverse engineering document.

Checking/Verifying the metadata for all the arrest related documents within ECM and auditing the db.

Have considerable expertise in Metadata Management, Data Analysis, Data Profiling & Quality, Data Governance and Master Data management (MDM).

Investigate and resolve ambiguities in design specifications between business and technical and making changes to the test plans.

Providing estimation for the testing team and following up with deferred defects with change management team by leading business analysis activities for various change requests for the CJIS community that impacts the CISS Program.

Experience in maintain the estimations for testing tasks and involved in creating high level scenarios or business scenarios and writing detailed test cases and scripts.

Building reports based on various stake holders requirements and involved in assisting in designing, deploying and maintaining SSRS reports in share point 2013.

MRI Network/ Blue Cross Shield Jul 2013 – Mar 2015

Senior Business Analyst / QA Analyst

The project was to develop software for providing applications for multiple hospitals, doctors, nurses and other business users. The system also produced reports based on the requirements specified by the SME’s. The system facilitated the business users to perform technical analysis for securities by generating charts, graphs and accessing historical data.

Interviewed business area experts such as Business User, Heads of health advisory board (SME's) and IT experts asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical teams across organizational lines.

Involved in designing of the system with the system architect and the development team, supporting the technical team in the product development and delivery process and translated the business requirements into Technical and Functional Requirement Specification.

Prepared Business Requirements Document (BRD), business rules and high level scenarios, Use Case Specifications, Systems Requirement Specification (SRS) and Change Request along with the Business Group and the IT project group members.

Created Use Cases, Use Case Diagrams, Activity Diagrams, Sequence Diagrams using MS Visio

Provided Risk estimation and managed technology and business risks by performing impact analysis.

Raise the change request ticket for the application to be de-commissioned.

Involved in creating SSIS packages and SSRS reports to load data to centralized SQL server database from diversified data sources. Solution for automating email alerts whenever there is a case reported was built in Microsoft SSIS and created reports using SSRS.

Developed highly customized tabular and matrix reports for weekly, monthly or quarterly reporting needs. Reported status to project owners on a weekly and monthly basis using MS Project for project planning and scheduling and status reporting.

Converted report extracts to excel and loaded the excel data to an archiving database within different schemas for each department using Microsoft SQL Server Management Studio.

Facilitated Joint Requirement Planning (JRP) Sessions for communicating and managing expectations with the client whose customers were going to be the final users of the product.

Involved in the periodically held Brain Storming sessions and JAD sessions for project updates as well as involved in the weekly meetings with testing team and business to discuss the current project status.

Responsible for creating and maintaining the RTM from the business and testing team.

Involved in leading System Testing, E2E Testing, and UAT.

Performed smoke and sanity testing after every build and before regression.

Modified and updated the test plans according to the business change.

SUN TRUST Sep 2012 – Jun 2013

Business System Analyst/ QA / BI Analyst

The scope of the project was to develop and implement a modern Web system that would support real time Internet banking and brokerage transactions, and streamline business processes. The project also included the development and implementation of an enterprise Web-based interface system supporting primarily the mortgage loan origination. And I have worked very closely in setting up the initial application process system.

Gathered User and Business level Requirements from SMEs from various departments and designed the functional specific requirement collection approach based on the project scope using AGILE.

Created Use Case Models, Design Models, authored Use Cases, Use Case Diagrams, Behavior Diagrams (sequence diagrams, activity diagrams) based on UML methodology using MS Visio. Created Dimensional Data Modeling using Star and Snow Flake Schema.

Performed gap analysis between business and technical requirements.

Facilitated discussions, presentations and preparation of the burn out charts and estimated the schedule of the project timelines. Designed screens and storyboards during web system development.

Conducted surveys, interviews sessions and translated them into functional Requirements. Suggested measures and recommendations to improve the current application performance of the system.

Conducted JAD Sessions periodically with various stakeholders at various phases of the Software Development Life Cycle (SDLC) to discuss open issues and resolve them. Performed GAP analysis at different stages of the project.

Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS)

Created and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension, Data Conversion, OLE DB command, Union All, Flat file Source, Flat file Destination, Conditional Split and more. Performed ETL mappings using MS SQL Server Integration Services

Using Checkpoints in packages to enable the package to run from the point of failure and also configured SQL mail agent for sending automatic emails when SSIS packages are failed or succeeded.

Created workflow diagrams to better demonstrate the processes. Involved in preparing Test Plans based on User Requirement Document (URD) and prepared the Test Cases using HP Quality Center.

Knowledge in creating estimates for the testing team and involved in creating test plans.

Prepared and loaded test data in different environments for different testing needs

Safeco Insurance Feb 2011 – Aug 2012

Business System Analyst / QA / BI Analyst

The project was a web-based application developed for a customer claim management system and integrated with their insurance system that enabled a prospective policyholder to interactively pursue quotes. The claim file utility enabled policyholders to file claims through the GUI.

Performed the requirement analysis and documented the requirements using Visio.

Used the requirement attributes (priority, effort, and risk) as the basis for negotiating the inclusion of the requirement, to manage the scope of the system efficiently.

Developed UML Use Cases using Visio and developed a detailed project plan with emphasis on deliverables.

Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members.

Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.

Conducted brainstorming sessions with QA for framing the high level test scenarios.

Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services.

Created Reports with latest features provided by SSRS like dynamic navigation, hyperlinks, different set of graphs in tabular format etc.

Managed changing requirements that included establishing a baseline, keeping track of the history, determining dependencies that are important to trace, tracing relationship between related requirements and maintaining version control, helping QA for batch testing.

Checked Business Readiness and determined activities of flow.

Developed & executed several Optimized queries in SQL on this data and created report template using SSRS reporting tool.

Performed data migration from text to SQL server.

Capital Bank Sep 2009 – Feb 2011

BI Analyst / Business Analyst

The project involved online retail banking website re-engineering. This involved interface redesign to better highlight existing features, add new functionality and improve overall usability.

Involved in all phases of entire SDLC/STLC from Initiation to the implementation, testing and support phase.

Developed Business Requirement Specification by gathering the Business requirement and interface specifications and converted them into design specifications.

Designed and developed Use Case Diagrams, Activity Diagrams, Data Flow Diagrams, Business Process and Data Process Model using MS Visio.

Created DTS package through ETL process to vendors to extract records from different sources.

Facilitated JRP sessions for communicating and managing expectations with SME’s and to understand thoroughly the business process and the interface specifications.

Creating, modifying, updating, maintaining and optimizing SQL Server databases, database security issues and auditing the server.

Created the scripts and SQL jobs for database backup, recovery and data processing alerting and also monitoring

Generated Sub-Reports, Drill down reports, Drill through reports, Tabular Report and Parameterized reports using SSRS

Provided management with the proof of concept, with a complete analysis on key performance index metrics, reports and schedules as necessary and participated in the design walkthroughs meetings.

Assisted the development team in the application encompassing creation of tables, triggers, sequences, functions, stored procedures, and normalization.

Created the test plans by discussing the testing strategy with the QA team and PMO’s.

Performed End to End testing and provided the UAT test results as well to the Business users.

HCL Jun 2008 - Aug 2009

SQL Programmer / BI Developer

These project deals with the Migration of Product Availability call & its business rules to the RXG from the NTAgent and Enabling Product Availability call through MI for Spanish cases (Partners cases).

Document, review, analyze and evaluate business processes, systems and user needs.

Write detailed requirements description of user needs, program functions and steps required to develop or modify computer programs or business processes. Perform tasks for initiative development through implementation for all projects assigned.

Installed and configured SQL Server 2000 in multi-server environment

Configured the DTS packages to run in periodic intervals

Extensively worked with DTS to load the data from source systems

Evaluate, analyze, and map business processes working with the Business Units to determine possible solutions to increase efficiencies and productivity.

Designed data objects like Views for permissions within various groups and Store procedures for maintaining data within dev environment.

Designed Schemas for databases with the DBA team.

Work with the Project Manager to ensure assigned milestones are delivered on time, within budget, and it meets or exceeds expectations.

EDUCATION

Anna University

Bachelors in Computer Sciences 2008

Contact this candidate