­

• Highly - motivated Business Systems/Data Analyst with around 7+ years of work experience in using Oracle SQL Server in Retail, Banking, Financial Service & Health Care Domains. Strong knowledge of SharePoint, Agile AWS, Azure Environment and HDFS.
• Over seven years of dynamic IT experience in Business Analysis, Data Analysis, Business Design, Data Modeling, Dimensional Modeling, Target Mapping, Implementation and Testing & Data Warehouse applications. High performance in supporting business solutions and analyzing different Business Operations and Business Process Re-engineering from inception through implementation.
• Experience with Agile tracking and collaboration tools (Jira, Confluence).
• Well versed in Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in an Oracle SQL Server environment.
• Excellent Business writing skills in writing Business Requirements Documents BRD, Use Case Specifications, Functional Requirement Documents FRD, Software Design Specifications SDS, Software Requirements Specifications (SRS), Software External Specifications SES, Software Requirement Documents (SRD), Data Dictionary, Workflows and Unified Modeling Language (UML) and diagrams such as Activity diagrams, Class diagrams and Sequence diagrams.
• Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction for varies projects.
• Wrote database scripts & PL/SQL stored procedures, functions and triggers.
• My core responsibilities include me acting as an interface between the business and the Business Intelligence team and also strong analytical skills in performing gap analysis and writing documentation.
• Developed thorough Use Case Diagram, Activity diagrams based on UML methodology and Business process flow diagrams, Data flow diagrams, State chart diagram using Microsoft Visio, LucidChart.
• Integrated different Form and Document Generation tools such as Type forms, Microsoft Forms and Form Crafts to be able to identify and provide accurate business solutions.
• Translate stakeholder requirements into over different tangible deliverables such as functional specifications, user cases, user stories, workflow/process diagrams, data flow/data model diagrams.
• Worked closely with the Business Intelligence Architecture team to understand repository objects that support the business requirements and processes.
• Creating Daily Status Reports, Test Incident Reports and Test Summary Reports.
• Liaise between business and technical personnel to ensure a mutual understanding of processes and applications.

TECHNICAL PROFICIENCIES:

Project Management: MS Office Suite, MS Project, JIRA, Rally

Business Modeling Tools: MS Visio, Rational Rose, LucidChart, SmartDraw

Programming languages: SQL, PL/SQL, HTML, UML

Data Analysis Tools: Advanced Excel - Pivot Tables, Functions, Macros

QA Tools: Selenium IDE

Methodologies: Agile SCRUM, SDLC Waterfall, UML, Kanban

Operating Systems: Windows 10, 8, 7, Windows Vista/XP/2000/2003/NT/98, UNIX

PROFESSIONAL WORK EXPERIENCE:

Confidential, Nashville, TN

Business Systems / Data Analyst

Responsibilities:

• Reviewed and gathered business requirements from the Subject Matter Experts (SME) and Business Partners using various elicitation techniques and create Scope Management Documents.
• Facilitated JAD sessions and elicited customer requirements by organizing interviews with internal/external stakeholders and subject matter experts (SMEs) to create subject specific questionnaires for clinical trials.
• Performed analysis and presented results using SQL, SSIS, MS Access, Excel, and Visual Basic scripts.
• Extensive tuning activities on pl/sql procedures, functions, procedures, and such to enhance performance.
• Implemented different Form and Document Generation tools such as Type forms, Microsoft Forms and Form Crafts as part of the business process solutions.
• Facilitated Scrum planning meetings to coordinate between Clients, Product Owner, Dev and QA teams.
• Wrote database scripts & PL/SQL stored procedures, functions and triggers.
• Regularly analyzed existing and proposed rates to develop actionable Benefits Pricing Models (BPM).
• Leveraged cost improvement analysis, product offerings, and pricing strategies to maximize profitability in a proactive manner.
• Involved in the complete business process redesign and reengineering effort in converting the existing process into a strategic web based environment.
• Worked with Development team to define business parameters and Content Management Service (CMS).
• Prepared a claim data for risk adjustment by extracting, cleaning, and merging from different tables using SQL.
• Extracted data from SQL Server database tables into flat data files and Excel sheets using table export and BCP for easy data migration.
• Directly interacted with clients (Ratings Analysts) to elicit the requirements and translate them into terms that development team can comprehend.

Environment: MS SQL, MS Visio, MS Office Suite, FIX Protocol, Crystal Reports, Moody Analytics, Bloomberg AIM, Mercury Quality Centre, Java.

Confidential

Sr. Configuration Analyst/Data Analyst

Responsibilities:

• Incorporated Agile methodology and SCRUM techniques to manage requirements and enhance the evolving RPM (Ratings Process Manager) application.
• (RPM is the core ratings process manager application, which helps S&P in atomizing its process to rate different deals, issues and organizations. It reduced the overall time to complete the ratings process and the manual effort).
• Involved in facilitating rapid development, minimizing impediments, resolving support issues and implementing overall RPM enhancements successfully.
• Involved in Creating & Editing SQL queries to generate data for the pricing department and business units within Payroll and Benefits implementation.
• Develop various pricing and financial models onto the benefits side.
• Modified and maintained oracle procedures using SQL and interacted with BI team in fine tuning SQL and creating benefit management business reports.
• Wrote database scripts & PL/SQL stored procedures, functions and triggers.
• Evaluated QA / data conversion MS-SQL for logic problems. Automated key testing scripts via MS-SQL programming.
• Facilitated Scrum planning meetings to coordinate between Clients, Product Owner, Dev and QA teams.
• Shadow and assist some of the Product Owner activities by providing high level estimates, prioritizing user stories for the sprint and maintaining backlogs and release plans.
• Developed advanced SQL queries with multi-table joins, group functions, subqueries, set operations and T-SQL stored procedures, user defined functions (UDFs) for data analysis.
• Captured user story points, categorized into respective epics and maintained the requirement matrix.
• Directly interacted with clients (Ratings Analysts) to elicit the requirements and translate them into terms that development team can comprehend.
• Designed, coded, tested and debugged custom queries using Microsoft T-SQL and Crystal Reports per defined technical specifications.
• Captured requirements for around 45 user stories in 9 sprints. Generated user story Acceptance Criteria and depending impact analysis documents.
• Suggested several process improvements within the ratings process and also suggested solution options to automate manual data entry tasks performed by Data Managers.
• Elicit Requirements from internal stakeholders and customers.
• Create Business Requirements Document and user stories.
• Create and maintain automated dashboards and reports providing a ‘State of the Business’ view to executive team.

Confidential

Business Analyst/Data Analyst

Responsibilities:

• The purpose of the project was to enhance and improve the existing legacy Balanced Business Scorecard (BBS) application for Commercial banking associates by providing advanced features and also integrate with other commercial sales tools for seamless access to all individual associate data.
• Directly interacting with clients to elicit the requirements and translate them into terms that development team can comprehend.
• Conduct client interviews, high-level reviews, focus groups to derive and execute action plans, meet deadlines and follow industry standards & best practices.
• Create data queries for clients using SQL, Crystal, Access and Excel.
• In spite of being a novice to the application, successfully developed BRD, PFS, Use-case, functional executive summary and prototype documents.
• Traversed through all the phases of six-sigma to improve existing processes. Worked on analyzing the process gaps and suggested several process improvements.
• Facilitate User Acceptance Testing (UAT) and production rollouts, and the defects detected were tracked and managed using HP Quality Center.
• Produced reporting documents and led weekly meetings with developers and business units to discuss outstanding technical issues and deadlines that had to be met.
• Assist junior BAs in the team with appropriate documentation and domain knowledge.
• Responsible for Requirements gathering, Business Process flow, Business Process Modeling and Business Analysis.
• Conducted technical/non-technical presentations to the management and workshops for the clients.
• Created and executed Test plans, Test Cases, Requirement Traceability Matrix.

Confidential

Business Systems Analyst

Responsibilities:

• Purpose of the project was to provide an enhanced web portal for the existing functionality of Client Profitability reporting module & cleaning its critical data for accurate and flexible profitability analysis.
• Facilitate client interviews and workshops to gather, understand, and set client's project goals, objectives, complex business needs and potential opportunities.
• Perform GAP analysis of the existing functionality of Client Profitability module. Pointed out 65 functional discrepancies and relevant solutions were suggested and implemented.
• Create requirement docs for the existing functionality by performing a code walkthrough of Ab-initio graphs and reconfirm the same with demanding business users.
• Timely delivery of the Scope doc, functional requirement spec, Process workflows, Use cases, and Defect trackers.
• Developed mock-up screens for the client to visualize the end product and suggest required enhancements.
• Met with client groups to determine user requirements and goals. Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures and create a Business requirement Document (BRD).
• Interacted with Subject Matter Experts (SME’s) and stakeholders to get a better understanding of client business processes and gather business requirements. Extensively worked with Project Manager to determine the current best practices for requirement gathering.