SUMMARY:

• Experienced Sr. Business Analyst with strong leadership quality with excellent Unified communication and presentation skills
• Followed the Iterative and Agile methodology, Scrum, Sprint and extreme programming concepts of project development.
• Analyzed data and incorporated User Stories in different release plans for the Sprints in Scrum process.
• Experienced in developing functional specifications through JAD sessions and user interviews.
• Extensive work with various Rational tools like Requisite Pro - Requirement gathering/maintenance, Use Case document maintenance, Clear Case- version control and Clear Quest/ Test Director for bug tracking, Rational Rose for Use case diagrams, Sequence diagrams and activity diagrams.
• Ample experience in analysis, design, development, testing, implementing Client-Server & Web based environment using Microsoft .NET.Framework 1.1/2.0/3.0/3.5 including ASP.NET 2.0/3.0/3.5, C#, ADO.NET,VB.NET,
• Assisted in developing and implementing a Unified communication plan associated with the Business Process Reengineering (BPR) implementation.
• Strong experience with OOAD, layered architectures, design p Confidential erns, and UML
• Responsible for managing the data analysis, Data Visualization, data mapping along with defining the meta data repository

TECHNICAL SKILLS:

Operating Systems: UNIX and Linux based Operating Systems - Server / Client; Windows Server 2000, 2003, 2008, 2012; Windows 98, 2000, XP, Vista, 7

Software: SQL Server, MySQL, .Net, Oracle 8i, 10g and 11g, SQL BI suite

Languages: SQL, HTML, XHTML, XML, XLST, C++, JAVA, JavaScript, Visual Basic

Methodologies: Iterative, Agile Scrum, SDLC, SECI, RUP, JAD and RAD

Tools: MS Project, MS VISIO, Tableau, Visual Paradigm, Rational Rose, BMC Remedy, MS Team Foundation Server, CA Clarity, ERWIN

PROFESSIONAL EXPERIENCE:

Confidential, Troy, MI

Sr. Business Analyst

Responsibilities:

• Defining & Documenting Requirements - Working with the functional SMEs to elicit requirements. Documenting the requirements in detail and obtaining formal approval of the requirements from the SMEs and/or process owners.
• Worked with various vendors to determine the best product that suits the company for AIM solution.
• Utilized IAM technology to initiate, capture, record and manage user identities and their related access permissions in an automated fashion.
• Worked automating the centralized directory to minimize privilege creep that created security risks.
• Facilitated the process of user provisioning and account setup. Utilized Oracle Identity Governance suite.
• Provided Privileged account management access from shared accounts and delivered a rich audit trail, ensuring enhanced security and compliance for sensitive systems using Oracle Identity Governance.
• Worked on role-based identity administration to automate user provisioning for both on-premise and cloud applications.
• Preparing Functional Specifications - Extending the functional requirements to functional specifications. Collaborating with the IT staff - developers, contractors, vendors, etc. to ensure that the final specifications provide sufficient detail for the system to be designed and developed.
• Preparing Test Plans & Scenarios - Using knowledge of the requirements and specifications to develop test plans that will adequately test the functionality of the technology solution to confirm it functions as planned. Working with SMEs and functional users to identify sufficient test scenarios and test populations to adequately test the system.
• Designed (GUI) and developed the web forms using ASP.NET 2.0 with C#.NET
• Performing System Testing and Supporting User Testing - Executing system test plans, documenting failures and working with the technical team to correct failures. Re-testing bug fixes. Supporting User Acceptance Testing (UAT) as needed from a trouble-shooting and instructional perspective.
• End-User Support & Troubleshooting - First line of support for HR end-users if they are having trouble with an HR application. May also provide second-tier support / troubleshooting for employee end-users if the issue cannot be resolved at a lower level. This involves troubleshooting, logging and tracking the issue in the appropriate tracking tool, and working with IT team to resolve it.
• Supporting Process Design / Re-engineering - As part of developing requirements, assisted the SMEs with the design or re-design of processes so that the ultimate combination of process & technology produces the optimal outcome.
• Data Analysis & Reporting - Performs data collection and analysis as needed from multiple sources in support of system implementations and ongoing support on HR systems.
• Assist in configuration and maintenance of HR Systems - Supporting Oracle EBS, HCM Cloud, Taleo, Learning Management and Time & Labor

Confidential, Deerfield, IL

Sr. Business Analyst

Responsibilities:

• Defined and reviewed the business case, BRD and technical requirements by regular reviews and controls to ensure that the client receives the system they needs.
• Delivered requirements in an Agile and iterative culture
• Establish root cause analysis by monitoring KPI metrics, focusing on cost saving initiatives.
• Identified and managed the critical path activities on the project
• Tracked percent complete for project activities
• Supported logical data modelling efforts, schema diagrams and have created data mapping documents
• Participated in project and planning, budgeting, and requirement analysis. Documented functional and technical specifications along side BRD. Worked with Solution Architect team in designing and data modelling. Generated insights from available data to provide a summary for senior project managers and highlighted critical issues with real-time metrics using Tableau, a powerful BI tool.
• Designed and developed UI, User Controls, and Client-Server Side Validation Controls using JQuery, ASP.NET and JavaScript.
• Facilitated JAD Sessions.
• Worked closely with business stakeholders to deliver new web functionality in an iterative, multi-release fashion
• Followed the Unified Process Methodology for iterative design. Worked on creating a hybrid model of RUP and Waterfall methodologies for software development.
• Created several reports and dash boards.
• Managed the client relationship by using an adequate direct yet complete and formal reporting format that compliments a respected and productive relationship.
• Established cross-functional relationships and managed all requirements gathering, data analysis and documentation for enterprise projects to centralize insurance policy, premium, claim and loss data with advanced reporting and unified communication.
• Leveraged multiple reporting tools like Tableau, Micro Strategy to provide meaningful analysis and visualization of trends to help clients solve complex business problems
• Utilized Micro Strategy to develop and provide clients with visually rich dashboards for web use and business intelligence applications for mobile devices to ensure dynamic visualization of their data
• ASP.NET and WCF reporting framework with SSRS will provide the user interface for the end user to view the decision-ready reports coming out of warehouse.
• Actively involved in UAT Functional, UAT Regression and Implementation Phase.
• Tracked UAT issues/bugs and prepared reports.
• Connected tableau to different data sources (Business Objects, Informix database)
• Interacted regularly with global business partners to determine their needs and to develop plans for improving delivery. Advocate on behalf of global partners needs as appropriate to senior management.
• Successfully coordinated software development deliverables through iterative evolutions using RUP principles, disciplines, best practices, and artifacts.
• Work cross-functionally to solve problems and implement changes.
• Provides oral and written reporting; defining project plans, problems, and resolutions to appropriate levels of management.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML.

Environment: MS Share Point 2007, MS Office Suite 2010, MS Project 2010, Rational Tools, Callidus TrueComp (v 3.7, v 5.1 & V 7), RUP, Waterfall SDLC, TOAD for Data Analyst 2.6, MS SQL server, Java / J2EE, XML, BI Publisher, CITRIX, HTML, XML, Tableau, CSS and Web 2.0 concepts, IBM Websphere, Teradata, SAS, Cognos, SIEBEL CRM, Salesforce.com SFDC,SSIS,SSRS and SSAS

Confidential, Brentwood, TN

Sr. Business Analyst

Responsibilities:

• Used Agile methodology to build the different phases of Software development life cycle.
• Provided training on Scrum and Agile requirements management.
• Supported the QA team in system testing and participated in user acceptance testing
• Followed RUP iterative development approach and was involved with all iterations of the development life cycle.
• Established system for reporting progress of Agile teams to senior management and governance bodies.
• Provided guidance to Scrum team during implementation of Agile.
• Implemented Green Hopper on Jira as the company wide Agile management tool.
• Performed effectively in agile software development environment, supporting frequent requirement elicitation, Worked on BRD and testing in constant business presence
• Serves as a Subject M Confidential er Expert in routinely briefing key stakeholders on different aspects of assigned initiatives
• Ensures end results are of the highest caliber with a clearly articulated scope and quantifiable business benefit
• Accountable to interface with senior leadership within and outside the organization.
• Maintained use case diagrams (using Rational Rose, OOAD & UML)
• Maintained Requirement Traceability Matrix for L&C.
• Performed functional and data testing and trained business users on the application along with supporting UAT
• Provided Siebel Architecture and System Design for enhancements to current application
• Re-engineer current Inside Sales business processes to adopt Siebel CRM foundations while maximizing CRM automation gains and opportunities
• Work with the Architect to ensure that the data models accurately reflect the business case
• Enhance performance and reliability of nightly legacy data integration
• Provide sustaining production enhancements to satisfy evolving business needs
• Expertise in Version control like Visual Source Safe and Control Version System.
• Worked with BM's Security Identity Manager to deploy and to be compatible with other products in the firm.
• Worked on integrating IBM AIM with the client’s custom applications.
• Created and modified user privileges. Automated user accesses through a rules-based system such that access rights can be automatically added or removed for individual users based on changes in business roles.
• Applied required permissions for groups. Created a clear documentation for other analysts to work on future projects.

Environment: Inspro, MS Share Point 2007, MS Office Suite, MS Project 2007, MS Project 2010, Rational Tools, Tableau, MS Sharepoint, Agile,Waterfall, RUP, Lotus Notes 6, Oracle 9i/10g, DB2, Quality Center, Test Director, Bugzilla, ClearQuest, Callidus TrueComp (v 3.7, v 5.1), Java / J2EE, SQL, XML, BI Publisher, CITRIX, Salesforce, HTML, XML, CSS and Web 2.0 concepts, IBM Websphere, SIEBEL CRM, Salesforce.com

Confidential, New London, CT

Technical Business Analyst

Responsibilities:

• Analyzed the requirements of data marts. During JAD sessions, worked with business users to understand their reporting requirements, worked with Reporting team to develop web-based report prototypes/Mockups.
• Worked with the reporting team to understand the capabilities of Oracle Analytics. Demonstrated these capabilities to the business users, conducted one-on-one and group sessions to educate the business users on various reporting capabilities of Business Objects.
• Createed reports from ADP Recruiting to identify Variable Pay Plan code, Preform Flag, incentive opportunity target amount and variable target amount
• Formated mass changes into ADP template
• Validated requirements against business principles, business goals, and strategic business drivers of the organization
• Identified, analyzed and translated business requirements into conceptual, logical and physical data models in complex, multi-application environments.
• Updated Data Dictionary for Oracle Analytics
• Clarify LOVs (list of values), Confidential ributes, logic rules and match keys with better documentation.
• Validated eligibility for employee referrals and process referral and sign-on payments with ADP payroll New Hire Process.
• Implemented Agile/Scrum to manage process improvement and dashboard creation projects.
• Documented the evaluation of various reporting tools like Oracle Analytics/Business Objects, made recommendations about the product depending on the reporting requirements.
• Developed, reviewed, understood and validated Testing scenarios/scripts.
• Aided in project testing efforts for doing integration tests, regression tests and user acceptance tests.
• Used SQLs to test various reports and ETL load jobs in development, QA and production.

Environment: Web 2.0, Oracle Analytics, Siebel CRM, Informatica Power Center 7.1/8.0, MS Share Point, MS Office Suite, Rational Tools, Business Objects 6.5

Confidential, Chicago, IL

Lead Business Systems Analyst

Responsibilities:

• Responsible for leading a project team, assigning individual responsibilities, identifying appropriate resource needs, Preparing BRD, data capture requirements, process control points, developing a schedule to ensure timely completion of project and meeting interim deadlines of project ensuring alignment with enterprise standards.
• Assisted efficiently in the design, development, testing, implementation, upgrading new HRIS capabilities
• Ensured deployment of common solutions across divisions and businesses
• Prepared detailed plans to track project performance and assure timely completion and achievement of project deliverables.
• Prepared and created statistical summaries, reports from HRIS involving payroll information
• Reported and communicated the results from process improvement efforts to division leadership
• Assessed change readiness and prepared plans for helping stakeholders through change
• Utilized various process improvement tools and methodologies to define activities that are aligned with business objectives
• Documented and customized statistical summaries and special reports from HRIS
• Prepared detailed plans to track project performance and assure timely completion and achievement of project deliverables

Confidential, Indianapolis, IN

Business Systems Analyst

Responsibilities:

• Developed an understanding and established high level mapping of specific service lines, and current and future market trends and establishes a sustainable modeling architecture that summarizes and presents related data.
• Drove Process Reengineering and reported execution against detailed plans, ensuring the on time, quality completion of metrics, milestones and reporting deliverables.
• Managed execution against critical program milestones, inter-dependencies, risk components, progress communication, coordination, and collaboration across teams / commitments.
• Worked effectively with cross functional staff, including IT, other project managers, multiple levels of leadership, business partners, and vendors as necessary.
• Ensured that strategies are in place for risk identification, mitigation and contingency planning
• Supported Service Level Agreement reporting, management, and underlying processes.
• Assessed existing programs against end-to-end enterprise requirements/ policies, and identifed and structureed additional plans as required.
• Participated in system studies to assess existing programs against end-to-end enterprise requirements and policies, assisting in the identification and structuring of additional plans as required to assists the organization to realize maximum benefit from the investments in equipment, personnel, and business processes.
• Utilized KPI data to identify areas for quality and process improvements. Created and implemented new processes to maximize quality, productivity, and revenue.

Confidential

SQL Server DBA/SSIS developer

Responsibilities:

• Designed reports on the monitoring of SQL Server Performance. These reports give a detail report to the management on the Performance of the server.
• Conducted root cause analysis of application availability and narrowed down issues related to coding practices, database bottlenecks, or network latency.
• Created Logical and Physical Data Modeling using Erwin.
• Migrated DTS packages from SQL Server 2000 to SSIS packages SQL Server 2005 database using migration wizard.
• Monitored & Analyzed SQL Log, Perfmon counters and Performance Tuning for all development and staging environment.
• Maintained existing code and fix bugs whenever needed.
• Developed, designed and documented tables, view, stored procedures, advanced queries, triggers, indexes and functions using T-SQL, Query Analyzer and SQL Enterprise Manager.
• Identified the necessary steps to enhance user response time by checking fragmentation and re-index tables for efficient application access methods.
• Worked on Client/server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.

Confidential

Oracle/SQL Server Developer

Responsibilities:

• Actively participated in gathering user requirements and system specifications.
• Filtered unnecessary data using complex T-SQL statements and implementing various Constraints and Triggers for data consistency.
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistency Data entry into the database.
• Wrote complex stored procedures to process employee's requirements and generating records between front end and back end.
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensure optimal performance of the server.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity.
• Built production environment, which involves 10 servers includes Oracle8i and SQL Servers.
• Installed and Upgraded Oracle Databases 7.x to 9.x
• Migrated various Oracle databases from one server to another server.
• Monitored Oracle Full / I Confidential emental Export of the Database.
• Performed RMAN and Manual Backups and Recovery.
• Allocated system storage and plan for future storage requirements for the databases.