SUMMARY

• An MS professional with 7+ years of experience as a Business Analyst serving as a liaison between Business users and software delivery teams. Extensive qualifications in all facets of information systems methodology from conceptual design through documentation, implementation, user training, quality review and enhancement.
• Solid programming understanding of web, windows and database applications and hands on experience with technologies like SalesForce, Mule Soft, Cisco - Composite, ASP.NET, team foundation server, IIS web servers and data bases like SQL Server 20 .
• Extensive experience in Business System Analysis, Designing and Programming Analysis with Microsoft Technologies and Software Quality Assurance Methodologies in Finance Industry, Health Care and Educational systems
• Expert in SDLC Models such as Waterfall, Agile (Scrum) & project management tools like Rally and JIRA.
• Experience in Software Development Life Cycle (SDLC) including requirements analysis, detailed design, development, testing methodologies, maintenance and deployment of the application along with documentation, estimation, and scheduling, Unified Modeling Language (UML) using modeling tools such as Rational Rose and MS Visio and Agile Methodologies.
• Proficient in Creating Business requirements document (BRD), Functional Specifications Document (FSD), and Transforming Functional Requirements into Technical specification Document (TSD) in a detailed manner using Microsoft Visio.
• Experience in designing front end screens and well versed with all the Microsoft front End technologies ASP.NET, ADO.NET, Entity Framework and MVC models.
• Sound Proficiency in analyzing and Creating Use Cases, Use Case Diagrams, Data Flow Diagrams, using MS Visio and Rational Rose.
• Experience in conducting Joint Requirement Planning (JRP) sessions, Joint Application Development (JAD) sessions with committee of business groups, senior management and IT groups.
• Excellent database administration (SQL/SOQL) skills and good command at writing SQL queries.
• Strong Knowledge in User Acceptance Testing (UAT) and assisting QA team in creating Test plans, test scenarios, test cases, test data.
• Experience in Leading and Managing a team which includes gathering and analyzing business requirements, functional/technical specifications, designing, developing, testing, deploying the applications and providing production support.
• Good team player with excellent communication and interpersonal skills and an ability to work individually or part of a team and good learner to adapt new technologies that improve the business.

TECHNICAL SKILLS

Business Application Packages: MS Office, MS Project, MS Outlook, Rational Rose, Rational Requisite Pro, MS VISIO

Databases: Oracle, SQL Server- 2005/2008/2012

Technologies and Packages: SalesForce, MuleSoft, Composite, ASP.NET, ADO.NET

Programming Languages: C#,Java,APEX,SOQL,SQL,HTML,JavaScript

Test Management Tools: Quality Center, ClearQuest

PROFESSIONAL EXPERIENCE

Confidential

Lead Programmer Analyst

Responsibilities:

• Conducted Business Requirement sessions in the form of questionnaires and scenarios with end users, Product Owners and Subject Matter Experts (SME) and the developers.
• Documentation of business requirements, meeting minutes, responses and approvals in the form of sign offs.
• Writing technical documents for the specified requirements and following up till the requirement moves to production including integration, testing and deployment.
• Developed use cases, workflow, screen mock-ups and conversion requirements.
• Responsible for testing the entire application with Manual and Automated Strategies.
• Responsible for performing functional, integration, performance testing and End to End testing. Involved in QA phase planning, coordination and implementation of QA strategy for overall project.
• Monitored project status to ensure progress towards completion, required procedural steps are followed fully and timely.
• Providing Solution: In SalesForce with REST API calls via .NET windows Services and web application for cleaner maneuver of objects like Journeys, Emails and Content.
• Code Review: Reviewing Apex classes and custom objects setup as and when required in SalesCloud.
• Marketing Cloud Setup: Creating Triggered Sends, writing AMP Scripts,creating Data Extensions in Marketing Cloud, setting up the Marketing Cloud for individual Business Units (children).
• Scrum Master: Played active Scrum Master Role by Organizing Daily Scrum calls and project follow ups on a day to day basis on a Sprint oriented basis.
• Analyze, support, maintain and implement complex project modules-middle tier consisting of data services, orchestration and gateway.
• Developed a project plan using Microsoft Project based on details contained in the HL BRS and also a project plan to schedule and assign work and manage the project.
• Worked closely with project managers, business users to formalize a business idea and define requirements.
• Interacted with the business users and division supervisors to gather the requirements.
• Analyze gathered requirements data, verify requirements and create business requirement specifications (BRS).
• Created process flow diagrams using Visio.
• Conducted JAD and brain storming sessions with the business users and stakeholders.
• Testing and Coordinating with the QA team in writing scripts for testing the webservices in SOAP UI using XML.
• Analyzing and following up on issues in production and fixing bugs as a part of production support team for the existing application.
• Lead the project until release coordinating with developers, QA and release management.
• Solution providing and development: Designing web services Solutions in Mule as a part of Gateway and Orchestration layers with Anypoint studio IDE for development.
• Code Review: Reviewing and testing web services in Cisco Information Server Studio as a part of Data Services layer using XQuery
• Data Mapping: Analyze, design new integration maps in Contivo Analyst for information flow.
• Scrum Master: Lead daily stand-ups and scrum ceremonies for MISP team working with product owners to groom the backlog and plan sprints.
• Deployment and Code Promotion: Deploying and promoting the code for the web services developed in composite and Mule soft to the higher environments on a day-day basis.
• Designed monitoring application in Java using Eclipse and deploying them on Linux machines.
• Mentoring: Reviewing the code in both .NET, JAVA and Composite as a part of guiding and mentoring junior developers in the team.
• Release Management: Creating CRQs and DTS for the releases following the bank standards and practices for all the applications.

Environment: Sales Cloud, Cisco Information Server, XSLT, XQuery, XSD SOAP and REST,.NET, Mule Soft, TOAD, SSMS, T-SQL, Windows server 2012.

Confidential, Los Angeles, CA

Sr Technical Business Analyst

Responsibilities:

• Co-ordinate withBusiness Usersin gathering and documenting business requirements
• Perform and documentGap Analysisby evaluatingAs-Is Businessprocesses against standard Product functionalities
• Created detailed Technical Specs to explain logic and design as per business requirements for Reports (SSRS), Screens and Interfaces.
• DocumentBusiness RequirementsandBusiness Rulesassociated around gaps between actual business practices and the product
• Organized, facilitated and conducted Scrum meetings and release planning in Agile.
• Work inSQL and Oracle environmentdealing with extraction, analysis and processing of data by writing complex SQL Queries
• DefineUse Casesaround business needs to be utilized by Developers in implementing solutions and deriving test Cases for QA/UAT
• Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT)
• ManageChange Requestby performing thoroughImpact Analysisof changes required
• Design and documentTest Case scenariosfornew and existing product functionality and business processes
• Analyze Bugs (using SQL and Team Foundation Server) and create Bug Analysis Technical Document to aid the development team in resolving bugs timely and effectively.

Environment: SSIS, SSRS, SQL server 2012, Oracle, MS Word and MS Excel, Visio 2013

Confidential, San Diego, CA

Technical Programmer/Business Analyst

Responsibilities:

• Conducted JAD sessions with business team and Development team to facilitate elicitation with regards to analysis, specifications, and design of the relevant business processes and systems.
• Collecting the requirements from the Scrum Master for every sprint.
• Provided a full- proof plan with and dividing the Story point into sub-tasks by giving estimates.
• Traced High level into Detailed Requirements in Functional Specification Document(FSD)
• Interacted with Data Warehousing team in gathering requirements for Data mapping and Data Modeling.
• Working with QA team for writing unit test cases for the web services.
• Extract data using source datasets by using PROC SQL.
• Utilized SAS and SQL to perform analysis of healthcare data.
• Worked on Void & Replace process.
• Worked on Data Integration/Migration with third Party vendor Alere for Authorizations requests from Confidential Medical Management System.
• Supporting the post release activities.
• Wrote complex SQL Queries to verify the data from the SQL server databases

Environment: MS SQL Server 2012, T-SQL, Windows server 2012, JIRA, MS Word and MS Excel, Visio 2003

Confidential, CA

Business System and Technical Analyst

Responsibilities:

• Collecting the intake items from the LOB and standardizing them according to the priority for monthly releases.
• Provided a full- proof plan with resource management and phase wise releases.
• Assigning Jr System Analysts to each intake items and participating in the ACD preparations.
• Preparing the intake list and TAR list specifying the need- Enhancement/Break Fix.
• Assigning the items to the developers and maintain agile process to track updates.
• Providing solutions for the fixes and screen changes on the front end using C# and JavaScript.
• Designing solutions to the ETL developers for issues fixing and optimizing the SSIS packages.
• Mock Reports in Cognos and creating Store Procedures plans both on SQL Side and Oracle using TOAD.
• Reports analytics in Spotfire-TIBCO technology for monitoring the server performances.
• Tracking daily updates and dividing the intakes in case of emergency maintaining timelines.
• Working closely with QA testers in the SIT environment and providing solutions to the defects for developers.
• Tracking the defects, maintaining and following till the closure in the QC management life cycle.
• Working with LOB users on the UAT testing and scheduling walkthroughs and providing testing plans.
• Creating and Maintaining Code review (eURR) process and providing solutions for resolving code review defects.
• Release cycle tickets creation and collection of approvals.(RFC)
• Supporting and maintaining multiple application releases in parallel at the same time.
• Deployment into production servers and involved in 3 phase wise Releases.
• Supporting the post release activities.

Environment: Visual Studio 2010, MS SQL Server 2008, Cognos, Oracle 11g, SSMS, SSIS, T-SQL, Windows server 2008.

Confidential

Responsibilities:

• Lead the key part of the project from end to end development.
• Interacted with the Business for understanding the system and got involved in the budget meetings for the MTS system design.
• Provided a full- proof plan with resource management and phase wise releases.
• Documented HLD with Data Architects and other teams System Analysts.
• Created the LLD in a screen wise manner with the inclusion of SSRS reports.
• Designed mock screens in the Visual Studio 2010 environment with ASP.NET and C#.
• Technical design of the pages while maintaining the consistency with the earlier design that was in MS Access.
• SQL Stored procedure design inputs including the conditions for the population of the data and accessed the SQL Server and the SSRS server from the front end using impersonation hopping.
• Assisted in preparing sample Test Data and executing Test cases
• Validated the data entered into the front end and tested the stored procedures.
• Inputs for SSIS packages to load the data from the csv and excel files provided by the business and created job to schedule their runs.
• Provided design based ideas for connection to Reporting server to send the parameters and display the SSRS reports.
• Navigation to Cognos reports from the Front end website.
• Used SITEMINDER to validate the user logins and utilized web services provided by the internal system which generates XML file to validate the user accesses.
• Deployed the code on a daily basis from TFS to the development server as a part of AGILE process.
• Fixed bugs and related deployment issues to the higher(Testing) environment with remote access to the web servers (IIS 7.0)
• Used HP Quality Control to mark the defects as Fixed.
• Deployment into production servers and involved in 3 phase wise Releases.
• Supporting the application Post-production.

Environment: Visual Studio 2010, MS SQL Server 2008, SSMS, SSIS, T-SQL, Windows server 2008,Visio, MS Access, MS Word.

Confidential

Responsibilities:

• Prepared LLD with user interface screens and screen wise details.
• Create functional requirements, Project change request document which may consist of documented workflows, business rules, and screen prototypes.
• 15 different Screens idea and implementation using ASP.NET
• Debugged through the MS Access application VB code for understanding the functional and business logic.
• Coded with 3 layered architecture there by providing the robust code with bank coding standards.
• Followed agile methodology and testing and deploying on a daily basis.
• Created stored procedures to populate the data to the front end grids.
• Responsible for testing and writing test case scenarios for customized edits for all the screens. .
• Integration testing to identify bugs before the testing environment (CIT).
• Worked with QA team on conditioning defects in the SIT environment.
• Trained and provided extensive support to Business in the User testing environment (UAT)
• Deployed to production environment and provided the production support.

Environment: VS 2008, Word, Excel, As400, TFS, SQL Server 2008, Windows 2008.

Confidential

Responsibilities:

• Gathered the requirements and written the BRD for the development of from-scratch web application.
• Worked on Vendor Conversion BRDs to formulate Test Strategy and Test Cases
• Supported an asp.NET web application using .NET framework 4.0 and VS 2010 where user uploads the data from excel to SQL.
• Implementation of SQLBULKCOPY function and dataset functionality to upload the data and added 6 columns dynamically on the fly in SQL Server.
• Tables and Stored Procedure design in T-SQL and provision of SQL authentication with BulkAdmin Rights to use them from the front end.
• Provided the design functionality to truncate the tables and archive the data into separate tables from the .NET code.
• Archived the excel files into a shared location after the upload and extended the functionality from SQL Server to AS400.
• Worked on IIS 7.0 to deploy the code into 4 different environments (Dev Server) and handled the bug fixes and issues to reduce the development time.

Environment: VS 2010, Word, Excel, As400, TFS, SQL Server 2008, Windows 2000.

Confidential

Responsibilities:

• Interacted with the client to gather business requirements.
• Studied and analyzed the Functional Requirement Specifications, System Design specifications and interacted with analysts for changes in requirements if any.
• Participated in the Business Meetings and took part in the designing of High Level Design.
• Implemented Agile Methodology as part of project requirement changes.
• Perform GAP analysis, Create Business Requirements document (BRD), Functional Spec.
• Apply Requirements engineering technique right from elicitation to analyzing, validation and management
• Modeled functional requirements using MS Visio to create Use Case Diagrams, for interaction between the various actors and system and to supplicate the Workflow Models.
• Monitored daily jobs to check the data updated in I Series tables and maintained the same in mirror (SQL Server) databases.
• Identified, defined and organized test ideas, test scenarios and test cases based on technical specifications
• Involved in deployment and post production support for the application.
• Testing, bug tracking & regression testing after Fix and promoted to test environments & deployment into production servers and involved in build/Release.

Environment: MS SQL Server 2008, SSMS, BIDS, T-SQL, Windows server 2008, MS Visio.

Confidential

Responsibilities:

• Interacted with the Business Team for the preparation of High Level Design.
• Gathered the requirements and designed the Low Level Design accordingly.
• Working extensively with DBA and Rigorous Analysis of data coming in and going out to find the data sources and destinations.
• Used to Microsoft Visio to depict the model and work flow and Import/Export wizard to restore a copy and back up of the files.
• Worked with 3 different teams parallel to attain the correct solution for data Migration.
• Assisted in writing T-SQL Stored Procedures to transfer the data from one SQL Server to another by using Linked Servers pointing to ODBC connections which uses drivers to enable connection between SQL Server and AS400.
• Replacement of Linked Servers for getting the data from the IBM iSeries Servers using OPENROWSET functionality which creates a dynamic connection in MS SQL Server.
• Assisted in handling Scrum meetings and reviews.
• Moved the entire databases including tables, Stored Procedures, Views, functions and SSIS packages.
• Involved in Bug fixes and deployments issues.
• Contributed to the deployment, production and post-production by extensively working in out of office hours.

Environment: MS SQL Server 2008, SSMS, SSIS, BIDS, T-SQL, MS Visio

Confidential

Responsibilities:

• Interacted with stakeholders to get a better understanding of client business processes and gathered requirements to develop Business Requirements Document (BRD).
• Create functional requirements, Project change request document which may consist of documented workflows, business rules, screen prototypes
• Responsible for testing and writing test case scenarios for customized edits for the screens.
• Actively involved in weekly walkthrough meetings and Defect calls to verify the status of the testing efforts, meeting the deadlines & mid-term targets
• Involved in the Bug fixes and deployment to higher environments.

Environment: VS 2008, Word, Excel, As400, TFS, SQL Server 2008, Windows 2008.

Senior .NET Developer

Confidential, FL

Responsibilities:

• Conducted Joint Application Development (JAD) sessions with stakeholders.
• Using information gathered from the stakeholders; produced use-case specifications, software requirements specifications, screen mock-ups, workflow, functional specification documents, use case/diagrams and activity diagrams.
• Worked on Case Management, Disease Management and Utilization Management BRDs and formulated Test Plan and Test Strategy
• Worked on Vendor Conversion BRDs to formulate Test Strategy and Test Cases
• Worked on Case assessment, Letters and Quit the Nic BRDs to assist QA team to come up with Test Plan and Test Cases
• Coordinated defect resolution with the development team
• Used SQL Queries to verify the data from the Oracle database
• Involved in Database design, creation of Tables, Views, Stored Procedures and Triggers.
• Worked closely with the team lead and other team members to implement a software release schedule to move software code from development to testing.

Environment: MS Word, MS-Access 2007, Visual Studio 2005, SQL Server 2008, SOS, Windows Service, FileZilla, IIS 5.1

Software Engineer

Confidential

Responsibilities:

• Involved in Functional and Technical discussions.
• Involved in Database Design
• Planning and scheduling work to meet the deadlines
• Developed Data Access Components using C#
• Developed Proxy For the System using Asp.Net and C#
• Developed Web Services for the System using .Net(C#/SOAP/XML).
• Created complex Stored Procedures, Triggers using T-SQL to perform database activities
• Used the Concept ADO.Net as a Database Connecting Technology.
• Used Microsoft VSS for Version Control management
• Implemented Reflection, Microsoft Application Blocks, Serialization etc
• Developed Stored Procedures for Generating Reports.
• Used Java Script validations with ASP.Net controls.
• Unit testing of developed modules.

Environment: .NET IDE 1.0, ASP.Net 1.0, C#.Net, Remoting, IIS 5.0, Sql Server2000, VSS.