SUMMARY:

• Over 7 years of experience in IT industry in various phases of Software Development Life Cycle, including business process analysis, requirements specification, design, development, testing and implementation with strong exposure in the areas of Web Development and N - Tier Client/Server Business applications.
• Actively involved in clarifying business requirements, estimating timelines for a project and consistently delivered complex large-scale projects on time.
• In-depth knowledge in IT Unified Process (ITUP); data modeling and mapping; and design using UML and Visio.
• Experienced in developing web applications using C#.NET, VB.NET, ASP.NET, ADO.NET and HTML
• Excellent working experience in developing use case diagrams using MS Visio.
• Excellent communication, analytical, interpersonal, and presentation skills. Expert Confidential managing multiple projects simultaneously.
• Expertise in business process engineering and implementation of software applications. Good exposure in writing test plans and test cases.
• Experienced in working with onsite and offshore teams.
• Created SharePoint portal for managing websites and maintaining document repositories.
• Extensively used SQL Server Reporting Services (SSRS) for generating reports and SSIS for ETL processes.
• Experienced in performing Unit Testing, System Integration Testing (SIT) and working with end users on User Acceptance Testing (UAT)
• Exposure in working with version control systems like Visual Source Safe.
• Well versed with complete life cycle of software development (SDLC) using Waterfall and Agile methodologies (SCRUM).

TECHNICAL SKILLS:

Technologies: .NET Framework, ASP.NET, C#.NET, ADO.NET & VB.NET

Web Development: XML, XSL/XSLT, CSS, HTML and DHTML

Database: SQL Server 2005/2008

IDE: Visual Studio 2003/2005/2008, Workday Studio Eclipse, Oxygen XML Editor.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Business Systems Analyst

• Design, build, test and maintain enablers of business processes, including technology and process solutions with a focus on medium to high complexity, multiple large application business processes and/or business relationships
• Contribute to the entire implementation process
• Drive definition of improvements based on business need and architectural improvements
• Responsible for overall solution design, build and test, root cause analysis, and advanced performance tuning complex business processes and functionality
• Consult with users to identify current operating procedures and to clarify program objectives
• Write documentation to describe program development, logic, coding, and corrections. Write manuals for users to describe installation and operating procedures

Confidential, Saint Louis, MO

Business Analyst

Environment: Visual Studio 2008, HTML, SQL Management Studio 2008 and MS Office 2007

Responsibilities:

• Actively involved in defining the scope of the project and prepared Functional Specifications and Design documents for the proposed functionalities
• Involved in requirements gathering, analysis, development and testing the project.
• Designed the webpages for the tool and actively involved in deciding the functionality of the tool.
• Guided the team in writing complex stored procedures and queries to insert the data into SQL Server Database.
• Prepared various documents including Requirements Specification, High Level Design, Project Plan, Solution Approach, System Test plan and Unit Test plans for the proposed functionality.
• Regularly analyzed the system to prioritize outstanding defects and system problems, ensuring accuracy to meet the deadlines.
• Diligently managed the project and completed the project development and testing within the estimated timelines
• Helped the team in developing various pages of this web based application in ASP.Net with the business logic implemented using C#.Net
• Involved in testing and publishing the website in testing environment.
• Coordinated project scheduling with the software project manager.

Confidential

Business Analyst

Responsibilities:

• Actively involved in defining the scope of the project and prepared Functional Specifications and Design documents for the proposed functionalities
• Diligently managed the project and completed the project development and testing on time.
• Functioned as a primary bridge between the business, operations, and the technical areas throughout the project cycle.
• Involved in requirements gathering, analysis, development and testing the project.
• Guided the team in writing complex SQL queries for extracting data according to business criteria.
• Prepared various documents including Requirements Specification, High Level Design, Project Plan, Solution Approach, System Test plan and Unit Test plans for the proposed functionality.
• Involved in testing and publishing the website in testing environment
• Validated technical designs created by IT developers against functional specifications.
• Ensured all artifacts complied with corporate SDLC Policies and guidelines.
• Regularly analyzed the system to prioritize outstanding defects and system problems, ensuring accuracy to meet the deadlines.
• Maintained the application database - Creating scripts, backups and versions of the database using Sql queries.

Confidential, Saint Louis, MO

Business Analyst

Environment: Visual Studio 2008, SQL Server 2005, ASP.NET and MS SharePoint

Responsibilities:

• Actively involved in defining the scope of the project, working with all the Magellan Behavioral and Medical Health stakeholders.
• Involved in requirements gathering, analysis, development and testing the project.
• Coordinated the project development and testing.
• Developed extensive Use Case Diagrams using Microsoft Visio for drafting business requirements and presentation to user groups.
• Prepared various documents including Requirements Specification, High Level Design, Project Plan, Solution Approach, System Test plan and Unit Test plans for the proposed functionality.
• Managing the SharePoint internal web portal to share all the project related documents.
• Wrote complex stored procedures and queries to insert the data into SQL Server Database for development and testing phases.
• Ensured all artifacts complied with corporate SDLC Policies and guidelines.
• Regularly analyzed the system to prioritize outstanding defects and system problems, ensuring accuracy to meet the deadlines.
• Maintained the application database - Creating scripts, backups and versions of the database using SQL Server.
• Diligently managed the project and completed the project development and testing within the estimated timelines.

Confidential, Saint Louis, MO

Project Manager/Business Analyst

Responsibilities:

• Actively involved in defining the scope of the project, working with all the stakeholders in Confidential &T global teams.
• Involved in requirements gathering, analysis, development and testing the project.
• Coordinated the project development and testing work with an offshore team of resources.
• Prepared Requirement specification documents, High level Design documents, Project Plan, Solution Approach document, System Test plan, Unit Test plan documents for the proposed functionality. Used PRISM tool to upload all the baselined documents in ITUP.
• Helped the team in writing queries, scripts in Teradata which is used for comparing the suspect’s data available in eCDW platform.
• Used Bteq Scripts to execute the queries and to generate the data in the text file.
• Wrote complex stored procedures and queries to insert the data into SQL Server Database.
• Guided the team while developing complex SSIS packages to generate the suspects data in the excel reports using Microsoft Visual Studio 2008. The packages are scheduled using SQL job agent to deliver the excel reports once in every two weeks.
• Managed the project financials by doing the monthly true-ups using actuals versus estimated cost based reports.
• Diligently managed the project and completed the project development and testing on time.
• Involved in requirement analysis, development, testing and maintenance of the project and also got the sign-off for deployment from the client.
• Used Agile Methodology for measuring development productivity with daily scrum updates and sprint demo.
• Co-ordinated with the team in planning session to select requirements for current sprint and to identify work tasks. Managed the team in scheduling sprint review & sprint demo’s.
• Extensively used PRISM tool for tracking project financials and for project management in ITUP and effectively coordinated the onsite and offshore teams accordingly.
• Prioritized outstanding defects and system problems, ensuring accuracy to meet the deadlines.
• Ensured all artifacts complied with corporate SDLC Policies and guidelines.

Confidential

Business Analyst/Developer

Environment: C#.Net, ASP.Net 3.5, ADO.Net, Visual Studio 2008, HTML, Tortoise SVN, SQL Server, SSRS and XML.

Responsibilities:

• Determined user/business/functional requirements. Created vision, scope, and use case documents; business process models, use case diagrams and state chart diagrams.
• Prepared Functional Specifications and Design documents for the proposed functionalities.
• Involved in testing and publishing the website in testing environment.
• Interfaced with business users to prepare and update Business Process Requirements and Software System Requirements. Created test cases and test scripts.
• Updated System Change Request forms for Product Data Management.
• Validated technical designs created by IT developers against functional specifications.
• Helped the team in developing various pages of this web based application in C#.Net, ASP.Net, Java script with the business logic implemented using C#.Net
• Guided the team in writing complex SQL queries for extracting data according to business criteria.
• Maintaining the application database - Creating scripts, backups and versions of the database using SQLServer.
• Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT).
• Coordinated work plans between project manager and client using MS Project.
• Functioned as a primary bridge between the business, operations, and the technical areas throughout the project cycle.
• Performed analysis, review and signoff of business requirements.
• Conducted UAT. Wrote SQL queries in SQL Server for data manipulation.
• Coordinated project scheduling with the software project manager.
• Worked on MS SharePoint portal for reporting and automating business processes.

Confidential

Business Analyst

Environment: C#.Net, ASP.Net, ADO.Net, Visual Studio 2005, HTML, CSS, JavaScript, WCF Framework 3.5, Workday studio, Workday server, Java, XML, XSLT, SQL Server 2005, SQL Server Reports, and AJAX

Responsibilities:

• Prepared functional specifications and system design specifications for client engagements.
• Recorded and communicated problems and issues reported by the client.
• Functioned as a primary bridge between the business, operations, and the technical areas throughout the project cycle.
• Translated Business requirements to functional and technical language with the help of Use cases and UML diagrams for developers.
• Interacted with the client for system study and documenting the user requirements.
• Designed and implemented the GUI (ASP.NET) with Web Form controls, web-server controls including Data Grid, Data List and SQL Server 2000 used as a database.
• Preparation of a complex chart based report using SQL Reporting Services 2005
• Involved in writing test cases for this application and performed unit testing.
• Actively involved in extracting data from multiple HR systems and feeding it into workday.
• Conducted UAT. Wrote SQL queries in SQL Server for data manipulation.

Business Analyst

Environment: C#.Net, ASP.Net, Visual Studio 2008, CSS, Tortoise SVN, SQL Server 2005, SQL Server Reports, XML and AJAX

Responsibilities:

• Involved in analysis, design, development, testing/debugging and implementation.
• Developed Web and Win forms, .NET components using C#/ASP.NET.
• Used ADO.NET objects like Data Reader, Data Adapter and Dataset for data access.
• Designed and developed complex queries, stored procedures, user-defined functions, triggers and views using SQL Server 2005.
• Configured and maintained Report Manager and Report Server for SSRS on Test server
• Design and developed the C# components for implementing business logic in middle tier in 3-tier application interacting with SQL Server database using Managed provider using ADO.NET.

Confidential

Software Developer

Environment: C#.Net, ASP.Net 2.0/3.5, ADO.Net, Visual Studio 2008, HTML, Tortoise SVN, SQL Server 2005, SQL Server Reports, XML and AJAX

Responsibilities:

• Actively involved and coordinated with client in gathering business requirements and preparation of functional specification.
• Used ADO.NET objects like Data Reader, Data Adapter and Dataset for data access.
• Involved in design of system architecture of web application using C#, ASP.NET, AJAX, Web services and JavaScript.
• Actively participated in the database design activity.
• Developed various dynamic Web Reports in PDF & Excel using SQL Server Reporting Services (SSRS)
• Developed web forms and custom controls using ASP.NET
• Created and design AJAX Grid view and repeater control using AjaxDataControls library.