Resume

Sign in

Sql Server Data

Location:
Inman, South Carolina, 29349, United States
Posted:
November 13, 2017

Contact this candidate

Bhushan Varsha

E-id: ac3awm@r.postjobfree.com Ph. 408-***-****

SUMMARY

A highly sophisticated and goal focused Business Analyst having 8 years of experience working with diverse client groups while managing a wide range of responsibilities including; business analysis, technology integration, IT analysis, operational support, web development and business process development. An analytical problem solver, have strong experience with Software Development Life Cycle (SDLC) and am very effective at creating and transforming business requirements into functional solutions and at designing business models. Often recognized for my alternative solutions, I am a confident, accurate and decisive team player.

KEY STRENGTHS

Played a dual role working as a Business Analyst and as a Programmer Analyst in my professional career.

Extensive experience in translating user requirements into functional specifications, prepared Business cases and workflow, data model diagrams using UML and MS Visio to facilitate project team members in designing and development.

Extensive experience - primarily working as a Business Systems Analyst with the skills of Business Intelligence and Business Processing and Modeling.

Expertise in all phases of SDLC (Planning, Design, Development, Testing, and Implementation) using Agile/Scrum methodology, Waterfall and Software Testing Life Cycle (STLC).

Defined processes and tools best suited to each project. Moved between agile and waterfall approaches depending on project specifics and client goals, creating detailed project road maps, plans, schedules and work breakdown structures.

Conducted Backlog grooming, release and sprint planning, daily standups, impediment removal.

Formulated Test Plan and Test Cases based on the Design Document and User Requirement Document.

Proficient in creating User Stories, Use Case Diagrams, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams, and Class Diagrams.

Worked in the ETL framework for normalizing data loading process.

Proficient in Object Oriented development processes and expertise in UML in implementing Use Case Model, Analysis Model, Design Model, Implementation Model, Use case Diagrams, Behavior Diagrams (Sequence diagrams, Collaboration diagrams, and Activity diagrams), and Class Diagrams using MS Visio.

Extensive experience in various requirements gathering techniques such as Interview, Brainstorming/Elicitation, Joint Application Development(JAD), Prototyping, Survey, Observation, Roleplay, Workshop, Document Review and Benchmark Application.

Experienced in programming languages like C#, .Net Framework 3.5, Object Oriented Programming concepts(OOPs), 4.0, Ado.Net, MVC and Relational Data Base Languages like SQL Server 2008, 2012, Sybase and Oracle.

Expertise in building Web Services using WSDL and SOAP protocol and expertise in Consuming and publishing Web Services.

Expert in understanding the Serialization/Deserialization of XML documents from third party Dealers.

Experience in Test Data Driven(TDD) Approach.

Extensive working knowledge on Configuring and version controlling with Team Foundation Server (TFS), Visual Source Safe (VSS) and Software Virtual Network (SVN).

Have proven business insight and the technical know-how to implement large-scale EMR and EHR

Engagements.

Experience in executing and writing Complex queries to view successful transactions of data.

Experienced in Developing the projects with Agile, Waterfall, and RUP methodology.

Ensured the development teams are practicing the Agile principles. Completed product demonstrations, retrospectives, and resolve action items. Assisted Scrum master with Backlog maintenance.

Proficient in desktop tools (i.e. MS Visio, MS SharePoint, MS Office, MS Project).

Extensive experience in various testing methodologies such as requirement based (functional decomposition), risk-based, test-case driven and benchmarking methodologies.

Worked closely with Development and Technical Support teams to resolve quality issues and assisted QA in testing.

Strong interpersonal and communication skills; committed, focused, hard working with a passion to learn new technologies.

Possess excellent critical and analytical thinking.

TECHNICAL ENVIRONMENTS

QA Tools : HPQC, HP QTP 10.0, Load Runner, JIRA, PVCS Tracker

GUI Tools : Visual Basic, Outlook and Access

Technologies : Asp.Net 2.0/3.0/3.5/4.0, COM+, WPF, WCF, Web API.

Databases : Oracle 9.x, MS Access, TOAD and SQL Server

Languages : SQL, PL/SQL, XML, HTML, VB Script, JavaScript, C++, OOPs, C#, MVC

Other Tools : MS Project, MS Visio, MS Office, Web sphere, MS Excel

Tools : PVCS 7.0, Clear Quest, Clear Case, Visual Source Safe, SharePoint,

ActiveX

Reporting tools: Micro strategy, Business Objects, Crystal Reports.

Operating Systems: MS-DOS, Windows (3.x, 95, 98, 2000, 2003, NT), UNIX, MAC OS.

EDUCATIONAL BACKGROUND

Shadaan College - Bachelor of Engineering in Electronics and Communication Engineering. (2009)

Trine University – Master of Science in Engineering and Management. (2016)

PROFESSIONAL EXPERIENCE

American Credit Acceptance Dec 2015 – Present

IT Business Analyst

ACA handles multiple projects but here, I work with Provenir Project. It is an Auto Insurance project deals with multiple Auto vendors like CarMax, Route One and Dealer Track, with which it accepts the Incoming customer applications and sends them for further processing like Credit check, Risk management and Funding, before granting a Loan.

Responsibilities:

Gathered business requirement and translated into the functional specification for Development Team.

Performed requirement analysis including gap analysis and functional decomposition.

Prepared System Requirement Specifications, High-Level Design Documents, Detailed Design Documents and Requirement Traceability Matrix.

Conducted meticulous GAP analysis while successfully reengineering key business processes to increase operational efficiency and alignment of business unit objectives.

Involved in all phases of SDLC (Planning, Design, Development, Testing, and Implementation) using Agile/Scrum methodology.

Implementing Business logic and data access functionality using ADO.Net and C#/VB.Net.

Extensively performed Scope analysis and Stakeholder analysis.

Designed and developed Web Application using ASP.NET MVC.

Good exposure to object-oriented programming languages.

Professional experience documenting processes and practices, in accepted project methodology artifacts, while effectively prioritizing multiple tasks, projects and deadlines.

Used C#.NET as code behind in all web applications and in WPF based applications.

Worked with decision makers, systems owners, BSAs, stakeholders and end users to define business requirements and systems goals, and identify and resolve business systems issues.

Have created and monitored various artifacts and deliverables such as use cases, SRS, BRD, UML Diagram, weekly status reports, defect reports and issue log.

Responsible for Data conversion plan, source to target mapping, Data modeling Study of an existing system, which loads the Monthly/Weekly Files from the Data warehouse.

Designed and mapped data that were used as the source for analytic reporting.

Involved in Database modeling and Implementation to add more sources to the current system.

Worked on in-depth data analytics, identifying gaps in data integrity and Worked with other team members in reviewing requirements via the use of Use Case Diagrams and Activity Diagrams.

Participated in Change Management Board meetings to ensure deliverability of Functional Requirements change and to assign priority to approved changes.

Created project metrics and analytics dashboards each month to measure team statistics and performance.

Created Data Mapping Documents, Test Cases for System Testing, Integration Testing (UAT) and

Production (Post Implementation Review) in Agile/Scrum environment.

Developed, managed and tracked project plan to implement requested features.

Work with team to adjust focus and approach as needed.

Actively participated in daily scrum meetings with the technical team, to make sure everybody is on the same platform and note down the updates from them.

Held Sprint meetings for every two weeks to prioritize the tickets from the backlog items and if necessary come up with some grooming sessions.

Environment: Agile/Scrum, UML, VMS, MS SQL Server 2000, Client Server, Web Server, SQL*PLUS, Oracle, RUP, EDW, Informatica Power Center 8.1, QTP, Visio Tool, HP ALM Tool.

Fidelity Investments, NYC, NY Jan 2014 – August 2015

Business Analyst

The project was to implement fraud prevention services. Positive Pay service was used to allow companies to accurately verify checks given by businesses and assist in check fraud reduction. Businesses send all details of checks issued to Bank and it maintains a repository for all check data. Once the check is deposited for payments, the recipient bank transmits the check images for payments. In reverse Positive Pay system then compares the received images from recipient bank with bank repository check data to flag any inconsistencies. The system undertakes all verification electronically and blocks all suspicious checks thus reducing fraud.

Responsibilities:

Interacted closely with the Business Users along with the administration and management to gather Business Requirements and analyze the functionalities to be incorporated into the system.

Participated in JAD sessions/conducted interviews for analyzing Business Requirements and reviewing them with business and technical teams.

Developed web pages using ASP.Net with C#, HTML, JavaScript and CSS.

Developed Use Case diagrams, business flow diagrams, Activity/State diagrams and Sequence diagrams using Rational Rose so that developers and other stakeholders can understand the business process.

Identified all necessary Business and System Use Cases from requirements, created Sequence Diagrams including Use Case Diagrams, Activity Diagrams and Data Flow Diagrams using MS Visio.

Meticulously analyzed complex data, staffing plans and variances to recommend solutions to improve revenue per call and customer satisfaction/retention.

Attended demo sessions to understand existing system functionalities.

Written complex queries, Stored Procedures and function in SQL Server Database.

Facilitated Demos of the software output of each Sprint and assisted Business in making decisions on the release during the Sprint Review Meetings.

Conducted requirements Churns between Sprints to update the product backlog.

Conducted Analytics and Assessments to derive the Team Velocity based on the various Sprint

Outputs.

Arranged interviews with all Stakeholders to review and understand the gathered business requirements.

Developed UID Documents, FRD and other SDLC Artifacts.

Coordinated with system architects and developers to convert Business Requirements into System

Requirements.

Responsible for Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2008 environment.

Planning and executing test cases that confirm business requirements and functional designs.

Engaged in ETL, Data Migration, Data Mapping and Data Quality Analysis.

Provided support to current and future business needs by designing, examining and updated reporting structure.

Built the small enhancement project line from the ground up. Generated a streamlined process to understand the various steps in the ETL process and create an effective and efficient change management process.

Utilized statistical methods such as process capability data analysis, statistical process control (SPC), and scientific sample size selection to ensure processes capability and repeatability and to determine statistically valid sampling plans.

Conducted Demos and walkthroughs for confirming Business Requirements.

Developed UAT strategy, UAT Plan, and facilitated UAT.

Conducted Smoke Tests in Production and documented lessons learned during the project.

Environments: JAD, UML, MS Visio, UID, FRD’s, Smoke Tests, MS Office Suite, Rational Clear Quest 8.0, Rational Requisite Pro 7.0, Mantis, UAT.

Business System Analyst

Ernst & Young, NJ September 2012 – December 2013

Ernst & Young is one of the world’s most globally coordinated tax practices with network of 29,000 professionals in more than 140 countries dedicated to setting the standard for exceptional client service. The purpose of the project was developing a new web-based system where existing clients can order services, input the necessary information and receive finished work products.

Interacted closely with the Business Users along with the administration and management to gather Business Requirements and analyze the functionalities to be incorporated into the system.

Participated in JAD sessions/conducted interviews for analyzing Business Requirements and reviewing them with business and technical teams.

Guide the development teams to break down large and complex user stories into simplified versions for execution.

Conducted Demos and walkthroughs for confirming Business Requirements for the graphical User Interface built with C Sharp.

Designed User Interface Documents using Snag IT and MS Visio.

Developed EPIC’s from the Themes and Documented the Product Backlog for the release.

Presented and Detailed Product Backlog Items to the Scrum Team in the Sprint Planning Sessions and assisted them in arriving at the Story Points for the User Stories.

Reviewed User Stories and Acceptance Criteria with the team.

Assisted the Scrum Master in creating and managing the Release Planning Documents in the Version One and SharePoint Repository.

Assisted the Technical Teams in deriving the Tech Design Tasks and reviewed the tech designs made for the Sprint.

Queried relational databases using SQL daily to resolve operational issues and assisted business and IT in better understanding of Business Requirements.

Assisted Scrum Master in developing the Task Sheet and Burn Down Charts.

Attended demo sessions to understand existing system functionalities.

Developed UAT strategy, UAT Plan and facilitated UAT.

Executed SQL queries on relational databases to create daily reports.

Verified and validated all built or release related issues and resolved them through discussion with business analysts with users’ approval.

Environments: Agile/Scrum, Snag IT, MS Visio, MS SQL 2008, MS SSRS, JIRA, Java Script, XML, SharePoint, Rational Rose, SPC, UAT, HP Quality Center, MS Azure, MS Office Suite.

Fifth Third Bancorp, Cincinnati, OH

Programmer Analyst February 2011 – August 2012

Loan IQ is a strategic lending platform and customer information from loan IQ will be available through reports in IQ view website and screenshots from the teams servicing the deals. Loan IQ view is a robust website which contains numerous loans booked through Loan IQ. All the syndicated loans spread out across multiple banks will be tracked by Roleplay daily, weekly, monthly, quarterly, Yearly batch jobs.

Responsibilities:

Developed website, creating services and worked on the User interface along with validations.

Gathered and analyzed the requirements and converted them into User Requirement Specification and Functional Requirement Specifications for the designers and developers to understand them.

Created Modular application structure using AngularJS framework and HTML5, CSS3.

Experience in object-oriented JavaScript Libraries including Various Plug-Ins like Angular.js.

Integrated the service call with UI using $http and $resources which are substitutes for AJAX in AngularJS.

Used Ajax, to create pagination and with client-side events like quick search.

Used Angular.js, MVC Frameworks in the development of the web applications.

Used AJAX framework for asynchronous data transfer between the browser and the server.

Implemented user interface guidelines and standards throughout the development and maintenance of the website using HTML, CSS, JavaScript, and JQuery.

Developed related PowerBuilder objects like (windows, UserObjects) and Database Objects like (StoredProcedures, Tables, Views etc.) using Sysbase Trasact-SQL.

Used JIRA for Bug Tracking, before moving the code production site.

Designed and development of Website using ASP.NET and C#.NET.

Expertise in Client Scripting language and server-side scripting languages like Html5, CSS3, JavaScript, JQuery, JSON, AngularJS.

Made use of Grid View, Data List, and Repeater Controls to display data in a customized format in the ASP.Net web pages.

Worked with the team of architects and back-end Developers to gather requirements and enhance the application functionality and add new features.

Environment: HTML5/4, CSS3/CSS, JQuery, WCF, AJAX, PowerBuilder 9, Sybase, MVC 5, C#.Net, JIRA, TFS, SQL Server 2012.

TekFriday Processing Solutions, Hyd, India December 2009 – January 2011

.Net Developer

The project involved the development of a web-based application, to show the various solutions, products and services provided by Application and the Customer Portal which gives anywhere, anytime access to the management tools you need to get the most out of your application services. Analyze near real-time business information that allows you to control costs and elevate customer satisfaction. Communicate directly with support representatives when you need technical and billing issue resolution.

Responsibilities:

Worked closely with the end users in writing the functional specifications, Design Developing, testing and Maintenance based on the business needs.

Designed and developed UI, User Controls, and Client-Server Side Validation Controls using ASP.NET.

Implemented the business logic layer (BLL) and data access layer (DAL) using C#.NET, and ADO.NET.

Used ADO.NET Concepts like Command Object, Data reader, Dataset in Data access layer for

communicating with Database.

Developed rich user Interface using Microsoft WPF technology with Prism Framework.

Created views, controllers and models using ASP. NET, MVC, C# within MS Visual Studio 2010 and Team foundation server.

Extensively involved in developing components for Business and Data-tier using C#, ADO.Net.

Worked on Strongly Typed Views and model-based bindings.

Involved in Test Driven Development and in the testing of the application as a member of the Quality Assurance team.

Have used Web Methods extensively with JQuery Ajax services across the UI(ASP.NET) part of the application.

Have worked with SQL server to create tables, stored procedures, Functions and views.

Developed and consumed WCF to search for documents based on their ID unique to every system.

Worked on preparing SSRS reports using SQL Server BI Development Studio and implement on a website.

Used JIRA for bug tracking.

Developed SOAP-based solutions using Web Services, Web API, WCF, SOAP including RESTful services.

Responsible for various duties like designing, developing, writing specifications, coding, debugging and other duties as assigned by the Team Lead

Responsible for providing extensive support and debugging of the application.

Participated in error handling and troubleshooting using various log files.

Involved in estimations for each sprint, and provided status in scrum meetings.

Environment: Visual Studio. NET, .NET 3.5, MVC 4, C# 4, SQL Server 2008, COM, WCF, WPF, AJAX, XML, SVN.



Contact this candidate