SUMMARY

• Total 9+ years of versatile IT Experience in various business domains like Procurement Sourcing, Document Management, Six Sigma, Healthcare, Finance, Investment Banking.
• Diversified documentation experience of articulating artifacts such as BRD, FSD, user - stories, workflows, process flows, cross functional diagrams, Business Processes, wireframes and Detailed mock ups.
• Experienced in Data Mapping and Data modelling documentations.
• Well versed with various Business requirement gathering techniques.
• Experienced in elicitation of requirements and collaboration of solutions to ensure user experience and bridge IT Gaps.
• Strategizing and documenting Data comparison, Data Migration and Data clean up processes.
• Experience in capturing current Business Processes and proposing new Business Processes for new solutions.
• Excellent process modelling skills using UML(Use Case, Sequence Diagrams, Activity Diagrams, SwimLane Diagrams and wireframes)
• Well experienced in migrating application projects from one platform to other such as Lotus Notes to Sharepoint.
• Experienced in creating Reports and Dashboards/Visualizations for Business using Power BI, Access,Excel,extracts from Sybase and SQL Server.
• Well experienced writing requirements for Web services teams using REST and dynamic web pages using Angular.
• Worked multiple complex applications and systems with various vendors in Onsite-offshore module while upgrading the 3rd party tools to higher version.
• Experienced in working in Agile/Kanban/Scrum methodology with fast paced sprints while participating in WAR room sessions getting bugs fixed.
• Well experienced creating Backlogs for developers and testers and participating in retrospect.
• Experienced in working in agile, waterfall model, V Model to write SRS and FD as per new requirements.
• Experienced in coordinating with various development and offshore testing teams
• Experienced in Functional Testing, Migration Projects End - to-end testing, ETL testing and UAT.
• Defect Tracking and co-ordination with various offshore (Testing team) and vendors (developers) for complex system upgrades.
• Diversified experience in ETL (Extract Transform Load) Tools like SSIS, Process Maps,Informatica.
• Experienced in working concurrently in several projects while meeting tight timeliness in Managed Services module.
• Performed Incident Management while meeting SLAs.
• Experienced in upgrading complex systems involving multiple vendor applications on upgraded servers.
• IT experience in the Design, Modeling, Development, Implementation and Support of SSIS packages and Complex Stored Procedures using SQL Server 2000/2005/2008/2008 R2.
• Well experienced writing complex SQL queries .
• Self-learner and Good ability to quickly grasp and master new concepts.
• Excellent analytical and creative problem-solving skills.
• Experience as a team leader at offshore and onsite for project coordination and deliveries.
• Good Understanding of client/server architecture and desktop systems.

TECHNICAL SKILLS

Languages: C, Core Java, PERL, Java scripting, Groovy scripting, VB Scripting.

Database: SQL Server 2005/2008/2012 , 2014, DB2, MS Access Tools,Oracle

Tools: Process Suite 360(Open Text), GCMS (Sci-Quest), Confidential (Zycus), Open Text - Kofax, ProSteward 360 (CGI), Microsoft Office Suite, SQL Server Data Tool, Visio, Power BI, WyStar/ NowTrac(k),Axure, IBM Blueworks

QA Tools: ALMQC, Selenium Tools, UFT

Operating systems: Windows (95, NT, 2000, XP, 7, server 2012, 10), zOS (Mainframes)

PROFESSIONAL EXPERIENCE

Confidential

Senior Business Analyst

Environment: Oracle SQL developer, JIRA,HP ALMQC, Axure, Excel, IBM Blueworks, Visio

Tools: OneCTS Transformation Tool

Responsibilities:

• Act as a liaison between Business operation teams and technical teams while creating solutions Intake of new Data and processing the Data.
• Writing user stories and technical specifications to Widget level details
• Writing User stories per Epics given by Product Owner.
• Writing relevant user scenarios per user stories, exception handling details and detailed process flows .
• Elicit current (AS-IS) business processes and collaborate with product owner and tech teams to design the new business processes
• Developing Wireframes for new solution and giving training to business while making sure the wireframes are user friendly.
• Work very closely with UI/UX teams to make sure the mock ups are ADA complaint.
• Facilitating Backlog grooming sessions with Developers (Angular and Backend) to build the new solution.
• Facilitating Solution Demos for Businesses and capturing the feedback to accommodate in the new solution using dynamic mockups.
• Facilitate JAD sessions for cross functional solutions.
• Data Modelling Documentation for Data Intake and Data Process. Articulate the Data fields details for reporting.
• Perform Defect Tracking and co-ordinate with the Testing and various Development team (onshore and offshore) for testing the new solution
• Writing queries and scripts for test Data search.
• Analyze the reports field per activity type.

Confidential

Senior Business Analyst

Environment: Sybase,SAP HANA,Version 1,Visio, Paint, JIRA,MS Microsoft Suit, Excel.

Tools: WySet up, PILAR, Master Profile, Informatica, Share point

Responsibilities:

• Act as a liaison between Business operation teams and technical teams while creating solutions for automating current manual processes.
• Writing BRDs and FSDs for the master Profile migration project.
• Document the Impact of migration project on PILAR and Wyset up application.
• Elicit current business processes and collaborate the new business processes as per the new solution for respective operations teams.
• Elicit current(As-Is) cross-functional business processes and collaborate the future (To-Be) cross-functional processes as per new solution,using scorecard technique for baselining the business processes for future state.
• Developing Wireframes for new solution and giving training to business while making sure the wireframes are user friendly.
• Facilitating Joint Application Development sessions with Developers (Angular and webservices) to build the new solution.
• Facilitating Demos for Businesses and capturing the feedback to accommodate in the new solution.
• Data Mapping Documentation of all the fields which are common in the 3 systems to identify their modelling as single field in new solution.
• Data Modelling Documentation for the Database of the new solution .
• Creating backlogs for developers and testers.Working with the Infrastructure teams to get the required data store set.
• Impact Analysis of the migration of data on various downstream systems to either of these systems.
• And coordinate with respective tech leads to accommodate ETL changes as per the new solution.
• Perform Defect Tracking and co-ordinate with the Testing and various Development team (onshore and offshore) for testing the new solution
• Analyze all the different data fields for the data migration piece and coming up with an efficient verbiage for Call Center Reps to answer participant calls.
• Work closely with operations risk managers to get the new solution approved.
• Strategize the data comparison and data clean up technique for cross-functional data issues.
• Work with developers to help build Dynamic web pages using Angular.
• Work with webservices developers and provide them requirements to develop REST webservices

Confidential, Minnesota

Systems Analyst

Environment: SQL Server 2012, Windows Server 2012, ALMQC,Microsoft Office Suit,Visio

Vendor tools: ProSteward 360 (CGI)

Responsibilities:

• Impact Analysis of modified workflows on the Data piece.Impact analysis of new workflows on existing data structure.
• Conduct extensive data analysis to identify defects and data Issues.
• Generate Reports for requested Data Elements used in Datasheets indicating the quantities using SQL Server Extracts and presenting it to business
• Perform Defect Tracking and co-ordinate with the Testing and various Development team (vendor and offshore) for testing the upgraded systems.
• Review Automation Test Suits and Test Scripts. Make Test Strategies and Test Plan.
• Performs system testing and lead user acceptance testing cycle
• Provide ELMS (Lotus Notes) application Business support to users and parallel work on migration documentation. (Lotus notes to Innovia)

Confidential

Data Analyst/Business Analyst

Tools: ELC Thick Client, Code soft, SQL 2012,Power BI

Responsibilities:

• Act as a liaison between Product Engineer and technical teams to identify gaps in existing Labels and propose wireframes to the same.
• Write various artifacts such as BRD, FSD, Use-cases.
• Elicit current (As-IS) and collaborate Future (To-Be) complex wireframe/template for accommodating new product design specifications.
• Facilitating Demos for Businesses and soliciting the feedback to accommodate in the new or modified wireframes.
• Facilitate JAD sessions with developers(onsite and offshore) to solve technical queries for complex workflows.
• Write User stories for the enhancements for various developers and testers at offshore and tracking the same.
• Analyze existing labels and the data piece for new products to cover all technical details of product and regulatory specifications.
• Create dynamic visualizations for product engineers displaying generation of a label per manufacturing units all across the globe using Power BI.
• Get the design of the label approved by Product Engineer
• Designing SQL queries to pull extracts and create reports for the Product Engineers and track the status of labels.
• Do end-to-end testing of labels for acceptance testing (UAT).

Confidential

Subject Matter Expert

Environment: SQL Server 2008, Windows Server 2008,Visio

Vendor tools: Process Suite 360(Open Text), ACDS (Kofax), ALM QC, Selenium Tools

Responsibilities:

• Document Business Requirements and system requirements in accordance with IT requirements and quality documentation practices.
• Translates business requirements to technical specifications and interface with other technical staff to design, develop, and maintain solution to develop new Scan Set ups.
• Lead the team at onsite and offshore for various work flows development.
• Review Automation Test Suits. Make Test Strategies and Test Plan.
• Work with multiple Vendors (developers) and Testers (offshore teams) to write User Stories, Test Scenarios, Test Plans, Test Scripts.
• Perform Defect Tracking and co-ordinate with the Testing and Development team for testing the upgraded systems.
• Document Sequence diagrams, activity diagrams and workflow diagrams using Visio .
• Review the test results and work with multiple vendors to get the bugs fixed.
• Created Component Maps and Process maps defining the existing process flows.
• Write complex SQL queries to test Process Map /SSIS package based on data mapping and requirements provided
• Evaluate code, scripts, ETL jobs, even modifying such to some extent.
• Review Test Scripts and Results
• Conduct extensive data analysis to identify defects and Data Issues.
• Work with Business and various stake holders to build the Process Maps(ETL) and perform end to end testing of the Work Flow.
• Installing Scanner drivers and making sure all required software’s are installed including drivers.
• Provide application support for business-critical issues.
• Automated Creation of Reports using Access database for audit purposes on daily basis increasing the audit efficiency by 12.5%
• Automated the business monitoring of documents archival process by setting jobs to do so overnight, saving manual efforts.

Confidential

Technical Analyst

Environment: SQL Server 2008, Windows Server 2008

Vendor Tools: Confidential (Zycus)

Responsibilities:

• Maintain various jobs and stored procedures and modify them as per new requirements.
• As and when needed work with Zycus and upload the new set of UNSPSC codes and perform the data Manipulations as per Confidential requirements.
• Conduct extensive data analysis to identify defects and Data Issues. Perform Data analysis using complex SQL queries and functions.
• Write Technical Specifications for the UNSPSC model.
• Support and maintain this application for scheduled Batch Classes.

Confidential

Technical Analyst

Environment: SQL Server 2008, Windows Server 2008, SQL Server BIDS, Microsoft Office Tools.

Vendor Tools: GCMS (Sci-Quest)

Responsibilities:

• Elicit requirements for modified and new workflows for contracts.
• Propose the new designed workflows while working with various sourcing managers.
• Analyze the impact of modified workflows on data piece and assist with data comparison and data clean up activities.
• Provide reports by pulling extracts from sql server to provide sourcing managers with requested contract details .
• Maintain various SSIS/ETL packages and stored procedures and modify them as per new requirements to Extract Data from ERP and load it to SQL.
• Write complex SQL queries to test ETL/SSIS package based on data mapping and requirements provided.
• Conduct extensive data analysis to identify defects and Data Issues
• Understand business process in depth to understand possible data scenarios and write robust test cases
• Fix production issues in SLA Time window.

Confidential

Support Analyst

Environment: SQL 2008, Eclipse Indigo, Groovy Console

Responsibilities:

• Maintain various SSIS/ETL packages and modify them as per new requirements.
• Maintain various Stored Procedures and modify them as per new requirements.
• Generating Reports using SSAS and SSIS for various Six Sigma Users.
• Performing various Year End activities such as updating UNSPSC codes and setting Targets in the application
• Support and maintain the data issues and job abends while meeting SLA.
• Developed servlets and JavaScript for J2EE application.
• Coding servlets using Pojo and completing Unit testing.
• Performed various Data Modification tasks using Groovy scripts and Hash Maps.

Confidential, MN

Software Engineer

Environment: Quality Center 11.0, SQL 2005

Responsibilities:

• Work with Vendor (developers) and Testers (offshore teams), Test Plans, Test Scripts and execute the same.
• Review the test results. Perform Defect Tracking and co - ordinate with the Testing and (Vendor) Development team.
• Modified Test cases according to the new Requirements.
• Work with Vendor (developers) and Testers (offshore teams), Test Plans, Test Scripts and execute the same.
• Review the test results.
• Perform Defect Tracking and co-ordinate with the Testing and (Vendor) Development team.
• Worked closely with BAs and Developers to report QA issues, testing status.
• Tracked all the requirements using Quality center.
• Also performed Data Cleansing in eBRP tool.

Confidential, Mendota Heights, MN

Software Engineer

Environment: Quality Center 11.0, Test track Pro, Delphi 2010, SQL 2005

Responsibilities:

• Modified Test cases according to the new Requirements.
• Worked closely with BAs and Developers to report QA issues, testing status.
• Tracked all the bugs and their status.
• Performed end to end testing, loaded test data, wrote and executed SQL queries and compared records to test Data Migration between Store, DRS and CSS