Management Sql Server

SWETHA CHALASANI 832-***-****

Business Analyst *****************@*****.***

EXPERIENCE SUMMARY

A dynamic professional with 4 years of rich experience in all phases of the Software Development Life Cycle (SDLC) including Requirements Gathering, Analysis, Design, Testing, Deployment, Maintenance and Production support and on software engineering methodology such as Agile and Waterfall Method.

Extensive experience as Business Analyst in Property & Casualty Insurance.

Experience in business process modeling, As-Is & To-Be Analysis, Fit-Gap Analysis and feasibility studies

Have wide knowledge and experience in Project Management, System Analysis, Data Mapping and Design using VISIO.

Extremely conversant with project proposal formulation, project planning, sizing, scoping & estimation techniques, resource planning, scheduling, tracking and control, risk management, quality management, change management, configuration and release management.

Performed Quality Analysis, System Testing, Regression Testing and Intersystem Testing.

Possess impressive interpersonal skills in interacting with Clients, team members and all levels of management.

Good Leadership, people management, excellent communication, analytical and writing skills.

Proven ability to quickly learn new system and apply them in business solutions.

Created test cases for the User Acceptance Test and conduct UAT.

Production implementation upon successful User Acceptance Testing.

Experience in creating various project documentations and metrics project report.

Excellent track record for meeting timelines and exceeding expectations.

Result driven, highly motivated, creative, with solid leadership and team training skills delivering productive solutions.

Over 2+ years of experience in SQL development, Reporting and Business Intelligence solutions using SQL Server 2008/2012.

Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions.

Hands on experience in creating Sub-Reports and Drill-Down Reports in SQL Server Reporting Services (SSRS).

Optimized data for ad-hoc queries by building indexed views.

Strong understanding of database relationships, ER model, Normal Forms and Star Schemas.

Highly motivated, committed and a natural team player with the capability to work independently.

Possess strong analytical ability along with excellent written and verbal communication skills.

EDUCATION

Bachelor of Science in Computer Science from Jawaharlal Institute of Technology (JNTU), Hyderabad INDIA (2008-2012).

TECHNICAL SKILLS

Front - End Tools

MS Excel, MS word, MS Power Point, MS Project, MS Visio, MS SharePoint

Languages

C, SQL Plus, HTML

Testing Tools

HP Quality Centre

Database

Oracle, MS SQL Server 2008/2012,MS Access

Methodologies

SDLC, RUP, Agile, SCRUM, UML, SWOT, Cost/Benefit Analysis

Management Tools

MS Share Point

Operating Systems

Windows 7,XP, 2000, MAC OS/X

PROFESSIONAL EXPERIENCE

City Online Services (May 2015-Present)

Project Description

City Online provides SIP based Voice Over Internet Protocol(VOIP) solution to Call Centers, Corporates and Residential Apartments.

Role: Business Systems Analyst

Responsibilities:

Involved in entire SDLC cycle – Requirement Gathering, Analysis, Design, Testing, Implementation, Post Implementation and Production Support

Gathered and documented business requirements, analyzed and optimized the business processes and converted client requirements into business requirements

Used prototyping as part of Business Elicitation to build the final product by gaining productive feedback from the higher authorities throughout the project

Completed the full life cycle of the project, including requirement analysis, design, coding and release.

Involved in design of database structure and queries

Developed Business specification diagram so as to understand the whole work flow

Developed activity and Use Case diagrams in MS Visio, so as to have a diagrammatic view of the workflow

Carried out UAT activities and presented the results to the Business Stakeholders.

Created test cases and test templates and guidelines to be used by the QA team.

Environment: Microsoft Office 2007, MS Visio, MS Project.

Tata Consultancy Services (Jun 2012-Mar2015)

State Farm Insurance – PMR Update (Jan 2014 - Mar 2015)

State Farm has a dedicated Property & Casualty application support team that takes care of maintaining all the legacy applications. P&C Application support involves production support, defect fixes and minor enhancements based on the State Farm’s requirement. Policy Master Record (PMR) Update is one of the many applications that are part of State Farm Auto Systems.

Responsibilities

Worked in a team of 25 business analysts and took charge of all the offshore responsibilities, Business meetings and was the primary point of contact for all Business SME’s and actuaries.

Hosted and facilitated multiple all day workshops to brainstorm and define the requirements.

Worked with the management team to create product backlog which is a backbone to agile methodology.

Prepared business process models, which includes modeling of all activities of the business from conceptual to procedural level.

Created various documents including Business Case, Feasibility study, Business Requirements Document, Operational Flow Diagrams, mockups, user stories, use cases, data elements and all SDLC artifacts documents such as Master test plan, Change initiation request etc.

Conducted Gap analysis to understand new business model and additional functionalities to be incorporated into the new application.

Acted as QA and tested multiple applications to ensure proper code is being delivered to UAT.

Conducted end to end UAT with the Business and multiple applications to make sure that all the Business Requirements are addressed in the application, in the interfacing system and all the way in all downstream systems and finally in the financial books.

Managed a complete UAT cycle starting from Test Cycles planning, Schedule, ID setup for the users, URL and other application related details, Defect tracking and Management and Status reporting.

Conducted brainstorming and JAD sessions with all the stakeholders to define and prioritize the requirements and resolve the issues.

Manage relationships and expectations by developing a communication process to keep business sponsors up-to-date on results; staying current with stakeholder expectations of deliverables and outcomes.

Execute and maintain program and project management processes and disciplines in the areas of: Project schedule, scope management, quality management; communications management, risk / issue management and change management.

Environment: Agile, Waterfall Methodology, MS Project, Visio, MS Office Suite (Word, Excel and PowerPoint), HP Quality Center.

State Farm Insurance - Claims to Haplex (Apr 2013 – Mar 2014)

Claims to Haplex DB Migration Project is to migrate the IMS Database which holds the claims information specific to each office to DB2 Database in Haplex environment which can hold different offices data in one DB Server. Having access to claims from different offices helps to track the claim history related to customer in other states. One of the module for this project is to develop Web Services that retrieves the claims information with different inputs like policy number, client ID, Deleted claims, Active claims, claim count etc. and validate the input passed.

Responsibilities:

Performing Source System Analysis. Analyzing the Source and Target Data elements. Develop Mapping document and Unit & System Test Plans.

Involve in Impact analysis of the new requirement or change request on the existing programs initiated by the client.

Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008.

Created Joins and Sub-Queries for complex queries involving multiple tables.

Used DDL and DML for writing functions, stored procedures, and data manipulation.

Ensured all code and versions are properly maintained.

Involved in preparing detailed technical documents.

Involved in code review and preparing unit test cases.

Technologies: MS SQL Server 2005, SSRS 2005, SQL Server Management Studio, Windows Sever 2003, Query Analyzer.

State Farm Insurance – House Hold Screen (HHS) (June 2012- Mar 2013)

The client has a dedicated Property & Causality (P&C) application support team that takes care of maintaining all the legacy applications. House Hold Screens (HHS) is one of the many applications that are part of the Auto Systems.

This application (HHS) has got many online screens, which are widely accessed by agents and customer representatives. These Screens display various information about Policies, Clients, Accidents & Violations, etc. that are crucial to day-to-day business activities. Operation centers invoke House Hold screens on an average of 70 million times per month company wide, which comprise of 80% of monthly transactions.

Responsibilities:

Handling service tickets on Business cases.

Application Maintenance.

Acting as a liaison between the client and the development team to understand, analyze and resolve functional issues.

Collaborate with BA’s in other areas..

Meeting the clients and understanding the workload/work plan.

Carrying out everyday tasks based on customer’s prioritization of work.

Technologies: MS SQL Server 2005, SSRS 2005, SQL Server Management Studio, Windows Sever 2003, Visio.

Contact this candidate