SUMMARY

• A result oriented Business Analyst/Consultant with 7+ years of IT experience in Software Development Life Cycle (SDLC): analysis, design, planning and monitoring, testing, and implementation of projects.
• Experience in the Banking and finance, infrastructure, automotive industry with extensive requirement gathering for custom solution in the cross - functional areas and also product launching for Customer relation management team (CRM).
• Excellent skills in Business Analysis, Data Analysis, Requirement Analysis, Data Modeling and Use Case Development using UML methodology.
• Prepared various documents: Business requirements, functional requirements and data requirements documents for better understanding and analysis of requirements.
• Proficient in using Web services, UML for Business Process Modeling, Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Collaboration Diagrams, Class Diagrams and document them using Microsoft Visio.
• Strong understanding in the principles of Data ware housing using Fact Tables, Dimension Tables, star, slowly changing dimensions, foreign key concepts, and referential integrity.
• Knowledge and experience with HLDD’s (SRS/SSR/BRD) and LLDD’s (FRD, RTM) reporting process and created mapping documents for transformations.
• Experience in database modeling and the development of Data Flow and Entity Relationship Diagrams.
• Strong SQL development/scripting work experience: Reporting, query design, query optimization.
• Adept Confidential interdepartmental coordination and communication to maximize business functionality and efficiency.
• Tool agnostic. Ability to quickly learn the available tool to accomplish project tasks.
• Primary liaison between lines of business (LOBs) operational support and information technology.
• Partners with the business unit to develop a solid knowledge base of the business line, including the business plan, products, processes and revenue stream.
• Excellent experience in working with process Improvement, Process modeling and analysis.
• Member of IIBA Cincinnati chapter and CBAP trained.
• Possess strong communication skills and believes in team work and cooperation.
• Good Interpersonal skills in listening, mentoring, coaching, negotiation, mediation, influencing, conflict resolution and strong communication, written and presentation skills.
• Committed to ongoing professional development and research to ensure improvement and innovation in management and problem-solving.

TECHNICAL SKILLS

Requirements and Document Tools: Rational Requisite-Pro and MS Share Point.

SDLC/Design Methodologies: Unified Modeling Language (UML), RUP, Agile, RAD and Waterfall.

Project Management Tools: Microsoft Office tools namely MS Project (WBS, PERT, Gantt charts), MS Visio, MS Access, MS Excel, MS Outlook, and MS Power Point

ETL Tools: Data stage 8.7/9.1, Erwin 7.0, Parallel extender

Data Modeling: MS Visio, ER Model, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling

Reporting Tools: Crystal Reports, Tableau, BO XI

Database: SQL Server, MYSQL, PL/SQL, Oracle 11g/10g, MS Access, MS Excel, FTP files

Applications and Tools: HP quality Center, AQT, Consona, BMC Remedy, Autosys, Toad, CRM Siebel

Operating System: Windows 7/Vista/Server 2008/XP/2000/9x/NT/DOS.

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

Senior Business Analyst/Consultant

Responsibilities:

• Involved in analysis of source systems, business requirements and identification of business rules.
• Played a key role in the planning, testing and implementation of processes and CRM project Enhancements aligned with IT conversations.
• Ensured system enhancements follow the appropriate guidelines, meet or exceed user requirements and are completed in a timely fashion.
• Successfully introduced a product called Consona, a knowledge management software tool into CRM and also authored various documents, which reduced the ticket resolving time by 24hours.
• Acted as a project leader for a pilot project in the CRM team.
• Partnered with the relevant parties including LOB and IT in the research and resolution of system and process problems.
• Worked with users in defining user, system and project requirements for new systems and system enhancements.
• Identified system enhancements, documents business needs and determines development impact to current system processing.
• Worked with programmers and users to ensure accuracy of enhancements.
• Identified, researched and analyzed production problems, develops solutions and resolved Problems.
• Provided guidance and context in prioritizing and determining complexity of problems and Requests.
• Provided input into the creation of detailed project plans, work assignments, target dates and ther aspects of assigned projects.
• Reviewed operational procedures and methods and recommends changes for improvement, with an emphasis on automation and efficiency.

Confidential, Detroit, MI

Senior Business Analyst

Responsibilities:

• Involved in analysis of source systems, business requirements and identification of business rules.
• Created the System Requirement Document, Program specifications and Technical specifications
• Interacted with business users, security and architectural teams to document functional and non-functional requirements .
• Initiated and crafted project charted by collaborating with senior business executives and technical architects and elicited business requirements from subject matter experts by writing user stories.
• Participated in Sprint planning, daily scrum stand up and facilitated JAD/JAR sessions.
• Perform an impact analysis for changes on the existing system.
• Data Stage job design, development & debugging to populate data to the target tables.
• Created job sequences, subsequences and master sequences to control the flow of jobs.
• Used Information Analyzer to perform column analysis
• Used Database Connectors to Extract and Upsert the data.
• Designed Sequencer to automate the whole process of data loading.
• Developed ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Created SQL Scripts required for extracting data from various tables.
• Performed Unit and System Testing and validated the test cases by comparing the actual results with expected results.
• Assist in user acceptance testing of code in UAT and Pre-production environments.
• Prepare and schedule the ETL workflows using Autosys for Scheduling and to automate the whole process of data loading the Jobs based on the dependency.
• Participate in design walk-throughs and code walk-throughs
• Worked on HP Quality center to raise and resolve defects identified in Test and UAT environments

Environment: Agile, Data stage 8.7, Oracle 11g, Autosys, Linux, XML, Java

Confidential, Dallas,TX

Business Analyst

Responsibilities:

• Interacted with Business users and Technical Architects to analyze the data & gathering the requirements from various sources.
• Involved in daily meetings with the client for requirements and provide services to meet the required SLAs.
• Participated in discovery sessions with customers and stakeholders.
• Became the subject matter expect for multiple partner relations.
• Created Design Documents and Unit Test cases with test Results Documents.
• Provide implementation support by attending defect and UAT meetings and participating in pilot/launch activities Provide implementation support by attending defect and UAT meetings and participating in pilot/launch activities
• Basically involved in providing Support to the built Applications and also involved in developing in new dimensions while enhancing the application.
• Involved in Unit, Integration, system, and performance testing levels and Involved in Performance tuning Confidential source, target, jobs and system levels and Testing Jobs with Unit Test plan.
• Integrate the data from the Source system into the target database.
• Involved in S.I. Confidential (System Integration and Testing) and U.A. Confidential (User Acceptance Testing).
• Supported Data Reconciliation team during the data recon process.
• Used Job Sequencers to orchestrate the parallel job execution and reporting the Status of the Job through Email.
• Supported the application after moving into Production and Troubleshooting the issues faced in Production support.

Environment: Datastage 7.5/8.0, Oracle 9/10g, DB2/AIX64 9.7.5, Sun Solaris 10, XML, Java