SUMMARY:

• Self - motivated Professional with effective communication skills, an ability to learn new things quickly and work as a team.
• Worked as a Business Analyst Intern for more than 1 Year.
• Completed a 2 years diploma course in Interior designing and Auto CAD.
• Completely involved in Documentation, Test cases and producing Behavioral Diagrams and Class Diagrams through Visio in Academic projects
• Have ample knowledge in diversified fields of Software Development Life Cycle (SDLC), specializing in Quality Assurance methodologies.
• Providing status updates to management.
• Experience in analyzing Business Specifications and writing, maintaining and executing the Test procedures, Test plans, Test cases and generating software defect reports
• Took training in MSBI and learned SSIS, SSRS and SSAS.
• Over 1 year of extensive experience in MS SQL Server 2008/2012, Business Intelligence technologies MSBI (MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS)
• Strong experience in designing and developing enormous number of reports in SSRS/Business Objects using the data from ETL Loads, MS SSAS Cubes and various heterogeneous data sources and Creating and Deploying SSRS Reports on the portal for user accessibility.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Experienced in developing and modifying cubes using SSAS and transform into pivot table.
• Proficiency in Microsoft Word, PowerPoint, Excel, Project, Access.
• Ability to think outside the box and work independently with minimal supervision.

LANGUAGES AND TECHNOLOGIES:

• Java; SQL; HTML; JavaScript; CSS; C++; ASP.Net, C#.Net; MVC, Linux
• Android Studio; NetBeans; Microsoft SQL Server; Eclipse; CodeBlocks.

PROFESSIONAL EXPERIENCE:

Business Analyst intern

Confidential

Responsibilities:

• A bility to elicit, analyze, gather, document and prioritize requirements.
• Excellent analytical skills to understand the business process, functionality, requirements and to translate them into System Requirement Specifications.
• Participated in daily Scrum meetings.
• Experience in dealing with Software Development Life Cycle (SDLC) using the Waterfall model with a good understanding of Agile Methodology .
• Requirement gathering through workshops, JAD sessions with clients, developers and QA analysts and referring to existing system documentation and procedures as well as test scenarios.
• Experience in conducting User Acceptance Testing (UAT).
• Created quality documentations such as Requirements Documents, Design Document and User Acceptance Test Plans.
• Writing Use cases and producing Behavioral diagrams such as Sequence diagrams, Collaboration diagrams and Class diagrams based on UML Methodology and creating business process flow diagrams.
• Writing and documenting Business Plan, Requirements Document, Functional Specification Document, and Test Cases
• Defining Test Cases, analyzing bugs , interaction with team members in fixing errors and User Acceptance Testing (UAT)
• Assisted QA team in developing Test Scripts, Test Cases and Test Plans for the User Acceptance testing (UAT).

SQL Developer

Confidential

Responsibilities:

• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using MSBI (SSIS).
• Worked Extensively with MSBI - SQL Server Integration Services (SSIS) to import, export and transform the data between the linked servers.
• Created packages using MSBI (SSIS) for data extraction from Flat Files, Excel files, OLEDB source to data warehouse.
• Used SSRS to create reports, customized reports, On-Demand reports and Ad-Hoc reports and involved in analyzing multi-dimensional reports in MSBI (SQL Server Reporting Services 2005).
• Involved in developing stored procedures, triggers and functions to account for some automated insertion of records in some of the tables.
• Have a keen eye for log analysis. Analyzed logs for troubleshooting user login issues and understanding online user behavior.
• Maintained accounts and financial records.

Graduate Assistant

Confidential

Responsibilities:

• Organized tasks and assisted the Professor in grading students.
• Updated the grades attained by the students on blackboard (website).
• Crosschecked the assignments of the students and rectified their mistakes.

Confidential

Responsibilities:

• Involvement in the leadership of requirements gathering phase of the project.
• Involvement in designing the user interface using Visual Studio 2010.
• Responsible for designing the Data flow diagrams (DFDs) for the system.
• Involvement in manual testing phase of the developed system.
• Documented the entire project.

Confidential

Responsibilities:

• eveloped use case diagrams for the system.
• Designed Data flow diagrams (DFDs) for the system.
• Documentation of DFD components.
• Involvement in the system documentation.

Confidential

Responsibilities:

• Involvement in the process of data gathering using Microsoft Excel.
• Responsible for generating the map and locations using ArcGIS.
• Responsible for the configurations that were made to generate the desired map using the properties in ArcGIS.

Confidential

Responsibilities:

• Designed database and generated Entity Relationship Diagram (ERD). Involvement in the back end support using MySQL.
• Responsible for generating the desired queries and involvement in the validation.