SUMMARY

• Overall, 8+ years of versatile IT experience in various business domains like Finance, Legal and HR Systems.
• 3+ years of project management and leadership experience. Including 1.5 years of experience as Portfolio Lead for HTR and legal applications at Confidential, comprised of 12 associates.
• Diversified documentation experience of articulating artifacts such as BRD, FSD, user - stories, workflows, process flows, cross functional diagrams and Business Processes.
• Involved in code reviews and ensured code quality across the projects.
• Experienced in elicitation of requirements and collaboration of solutions to ensure user experience and bridge IT Gaps, Strategizing and documenting Data comparison and Data clean up processes.
• Experience in capturing current Business Processes and proposing new Business Processes with respect to Risk management. Excellent process modelling skills using UML (Use Case, Sequence Diagrams, Activity Diagrams)
• Working as liaison with stakeholders and developers to change requests and prioritization of all enhancements.
• Managing multiple and concurrent projects and make sure the work is completed within the defined scope, budget and time.
• Worked on multiple complex applications and systems with various vendors in Onsite-offshore model while upgrading the 3rd party tools to higher version.
• Experienced in working in Agile/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 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.
• Experience in working with multiple IT service management tools like Service Now, HP ITSM, BMC Remedy.
• Diversified experience in ETL (Extract Transform Load) Tools like SSIS and SSRS.
• 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/2012. 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.
• Well experienced using Microsoft Office Suit, Excel, Visio, Word
• Strong communication (written and verbal) skills

TECHNICAL SKILLS

• C, Core Java, Java scripting, Groovy scripting, VB Scripting, Python.
• Struts, Spring
• SQL Server 2005/2008/2012 , 2014, DB2, CMDB, MS Access Tools, Sybase
• SumTotal (TARS), Salesforce, Workday
• Windows (95, NT, 2000, XP, 7, server 2012, 10), zOS (Mainframes)
• Clear Quest, HP ITSM, BMC Remedy, ServiceNow, ClearQuest, JIRA.
• Time and Attendance (SumTotal), Workday, Salesforce
• Human Resource (HR)-
• BA Skills
• Data & Process Analysis
• Analytical Approach
• Elicit requirements
• Collaborate Solutions
• Project and Backlog Tracking
• Data Mapping and Data Modelling
• Agile/Scrum/Kanban/Waterfall/V- Model SDLC
• End-to-End Testing
• IT Gap Analysis

PROFESSIONAL EXPERIENCE

Confidential, Saint Paul, MN

Business Analyst

Responsibilities:

• Act as a liaison between Business operation teams and technical teams while creating solutions for the pain points of users and new features. Writing user stories and technical specifications.
• Writing relevant user scenarios per user stories, using behavioural design driven approach
• Elicit current (AS-IS) business processes and collaborate with product owner and tech teams to design the new business processes as per the new solution
• As part of this migration project the responsibilities were to analyse the functionality of current system and work with business team on workday side to help them implement the same.
• Preparing test plans and testing the functionalities.
• Perform Defect Tracking and co-ordinate with the Testing and various Development team (onshore and offshore) for testing the new solution
• Assisting with coordinating Sprint and Release cycles as needed using agile methodologies.
• Writing user stories using JIRA based on epics given by the Product Owners.
• Collaborate with Tech teams to break stories to demo able size for a 10-day Sprint.
• Validating the implementations against the functional / business requirements.
• Creating test plans and tracking the completion of technical unit testing and user acceptance testing.
• Developing reports using SQL business intelligence tools such as SSIS/SSRS for business during different migration phases as and when required.
• This project involves system interacting with Hardware, responsible for planning the load onto each equipment and designing a strategy for deployments. As part of this interacted with the Infra team in coming up with a strategy.
• Analyse Data for the various mapped fields and create reports using vlookup’s across the workbook for operation teams.
• Involvement in analysing different clock vendors along with Confidential clients to match the current functionality system.
• Strategize the data comparison and data clean up technique for cross-functional data issues.

Confidential, Saint Paul, MN

Business Analyst

Responsibilities:

• Act as a liaison between Business operation teams and technical teams while creating solutions for the pain points of users and new features. Writing user stories and technical specifications.
• Writing relevant user scenarios per user stories, using behavioural design driven approach
• Elicit current (AS-IS) business processes and collaborate with product owner and tech teams to design the new business processes as per the new solution
• As part of this migration project the responsibilities were to analyse the functionality of current system and work with business team on workday side to help them implement the same.
• Developing complex SQL queries for generating the clock data for different sites.
• Working with Site co-ordinators, infra team, vendor and business stakeholders on implementation of the clocks at different sites across US.
• Preparing test plans and testing the functionalities.
• Perform Defect Tracking and co-ordinate with the Testing and various Development team (onshore and offshore) for testing the new solution
• Writing user stories using JIRA based on epics given by the Product Owners. Collaborate with Tech teams to break stories to demo able size for a 10-day Sprint.
• Strategize the data comparison and data clean up technique for cross-functional data issues.

Confidential, Saint Paul, MN

Subject Matter Expert

Responsibilities:

• The roles for this project assignment are developer, onsite coordinator and support analyst. In this capacity must use an array of languages depending on specific project requirements in analysing, designing, testing and modifying application software for enhanced functionality and productivity.
• Also need to develop new applications as necessary to fulfill client requirements.
• Must use practical knowledge of various software languages, tools and platforms and apply design specification techniques under the supervision of an experienced team lead.
• This project involves system interacting with Hardware, responsible for planning the load onto each equipment and designing a strategy for deployments. As part of this interacted with the Infra team in coming up with a strategy.
• Worked with the Site to test Impulse clock configuration and monitor Blueline interface which loads punches of the resources.
• Developed SSRS reports to fulfill client requirements for data for different locations across US.
• Worked on streamlining the issues with old clock technologies used by Confidential along with Infra team and vendor teams.
• Working on resolutions for IT tickets received by business users in ServiceNow.
• Also guide the activities of Cognizant programmers and programmer analysts delivering value additions such as innovation and process improvements.
• As part of this deployment activities designed numerous processes that helped them in UAT and deployments.
• Proposed some processes to infrastructure that helped them in monitor the health of various components, this helped in reduction complaints from various plants that eventually helped business achieving the Confidential HR goals and standards.
• Developed a process for IT Support team involving technologies like Web services/Groovy that helped reducing the effort in their day-to-day process.
• SLA tracking, monitoring and status reporting as well are included in the responsibilities
• Analyse Data for the various mapped fields and create reports using vlookups across the workbook for operation teams.
• Running Payroll process and coordinate with Workday team to submit Pay for weekly, biweekly & salaried employees.
• Running year end conversions to manage the absence policy per the Confidential corporate policies for Salaried, union and non-union employees.
• Strategize the data comparison and data clean up technique for cross-functional data issues.

Confidential, Minnesota

Support Lead

Responsibilities:

• Act as a liaison between Business operation teams and technical teams to identify gaps in existing workflows and propose solution to the same.
• Subject Matter Expert in Business transformation project from GWN to WD and solved technical queries.
• Maintain various jobs and stored procedures and modify them as per new requirements/BT.
• Developed SSRS and SSIS jobs to fulfill client requirements on Peoples data for various countries.
• 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
• Worked with Active Directory team to find the mapping between Workday/EID and AD.