Summary

• Highly motivated and result oriented with over 8 years of industry experience as Sr. Business/Systems Analyst
• A self starter with leadership qualities, interpersonal and communication skills
• In - depth domain knowledge of Telecom, Networking and Automobile Industry.
• Strong organizational, communication, leadership, planning and vendor management skills.
• Excellent knowledge of industry standard methodologies like Software Development Life Cycle (SDLC), Project Life Cycle, Rational Unified Process (RUP) and Capability Maturity Models (CMM).
• Excellent Analytical skills to understand the business process and Functionality, Requirements and to translate them to system requirement specifications. Developing functional specifications for business process refinement and automation, data modeling, system architecture, conducting feasibility studies, scope.
• Experience in conducting Joint Application Development (JAD) sessions for requirements gathering, analysis, design and Rapid Application Development (RAD) sessions to converge early toward a design acceptable to the customer and feasible for the developers and to limit a project’s exposure to the forces of change
• Experience in Teradata SQL Assistance and BTEQ Teradata utilities.
• Expert inanalyzing/troubleshootingandproviding technical supportfor Oracle/Unix applications and their interfaces.
• Experience withcreating reports using Business Objects.
• Extensive experience with process modeling using UML, flow charts, task diagrams, Sequence Diagrams, Activity Diagrams and Use Cases.
• Experience in writing queries/scripts for data analysis and QA report testing.
• Excellent communication and presentation skills. Experience working with business users as well as senior management.
• Academic Experience in conducting SWOT analysis, Gap analysis, Risk analysis, Net present value (NPV) analysis, Return on investment (ROI) analysis.
• In Depth understanding of the AS-IS and TO-BE business processes and experience in converting these requirements into technical specifications for preparing test plans.
• Ability to work cross-functionally and with all levels of the organization
• Creative and Aggressive person capable of forming and maintaining positive and productive team environments and with integrative thinking skills.

Technical Skills

Languages: C,C++, Java

Scripting Languages: Perl, JavaScript, VBScript

Markup Languages: HTML, XML

Methodologies: RUP, UML, CMM, EXPRESS ONE, PRISM, IT UP

IDE/OOAD: Rational Rose, Rational Clear Case, Rational Requisite Pro

Reporting: MS Visio, MS Project Test Director, WinRunner, LoadRunner

Database: Oracle 9i, Oracle DBA, Microsoft Access, MS SQL server

Telecom: VPN, ATM, Frame Relay, MPLS, VoIP, Dedicated voice, SIP, MGCP, Telecom OSS/BSS, Telecom billing, SS7, ITIL, UMTS, GSM, CDMA technologies. CobiT.

Operating Systems: Windows95,98,ME,XP, Win server 2003, RedHat Linux, UNIX

Networks: Network Management, Network Security, Firewalls, LAN, WAN configuration

Hardware: Cisco routers, Cisco switches, Alcatel Lucent EMS and NE, Microsoft EMS.

Applications: Alcatel Lucent 5620 SAM, Alcatel Lucent IMS Core Applications, Scientific Atlanta ROSA, Microsoft MOM.

Professional Experience

Confidential, Chicago, IL

Sr. Business Systems Analyst

Responsibilities:

• Responsible for collecting and documenting the business and technical requirements for the Network applications which interface with the OSS/BSS applications.
• Responsible for capturing the requirements for the Integration between Network and OSS/BSS applications.
• Worked with applications like Unified Messaging, Alcatel Lucent IMS core applications, 5620 SAM and Microsoft MOM, Microsoft SMS.
• Designed the ETL system for populating the Data warehouse from the operational DBMS
• Interacted with the Users for collecting their requirements to design and format reports. Documented the creation and maintenance of the Business Objects Universe/Reports and Standard Operating Procedures.
• Installed and Configured the Teradata Server database into Oracle 9i database
• Involved in creating, modifying and completing the change requests for various applications using the CR tool.
• Responsible to conduct Peer Reviews for all the Interface Agreements and the swBRD’s.
• Worked with interface detail template (IDT) to update the information contained in the IA.
• Developed the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting. Interface with internal customers.
• Created SQL tables with referential integrity and developed queries using SQL, SQL*PLUS and PL/SQL
• Using detailed knowledge of application features and functions assess scope and impact of business needs throughout analysis and completion of all enhancement specifications
• Performed a gap analysis between the current TWG control framework and COBIT.
• Responsible to design the Software Business Requirement (swBRD), Interface Agreement (IA), System and Feature Design (SFD), High Level Design Document (HLD) and Detail Design (DD).
• Responsible for assisting clients in resolving various network and systems management problems using ITIL.
• Assisted in development of training materials for new technology and process improvements
• Experience in creating design documentation related to system specifications including user interfaces, security and control, performance requirements and data conversion.
• Developing strategic partnerships with the business unit to develop a solid knowledge base of the business line, including the business plan, products, process and revenue streams

Environment: ITIL, CobiT, HTML, DHTML, Oracle, RUP, Express One, IT UP, PL/SQL,PRISM, UML, SQL, MS-Office, MS Project, Business Objects, MS Visio.

Confidential, Allentown, PA

Sr. Business Systems Analyst

Responsibilities:

• Developed project plans, specify goals, strategies, schedule and allocation of available resources
• Created risk management plans and tracked risk items through all phases of the project
• Collected requirements from cross functional business community
• Studied and assessed the clients systems and business processes
• Conducted individual and group (JAD) sessions with business stakeholders and technical units
• Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures and create a Business requirement Document
• Developed project delivery schedule, managed projects and identified resources to successful completion
• Analyzed all aspects of the order processing lifecycle, starting from initial order entry and welcome call to the first billing and designed the system in such a way that the complex orders could be easily identified and monitored
• Assisted DBA for fetching data from OLTP using Oracle Export/Import.
• Validated the test data in DB2 tables on Mainframes and on Teradata using SQL queries.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Implemented and oversaw the ongoing execution of the ITIL/ COBIT best practice frameworks.
• Played a key role in the planning, testing, and implementing system enhancements and conversions
• Assisted Test Lead, Testers understanding business process and helped them for successful completion of Unit Testing, Integration Testing and Requirements Testing
• Played a major role in developing the Design Documents for the Developers.
• Communicated with upper management to help define requirements, designs, and develop prototypes
• Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams
• Streamlined clerical work processes and mapped to the automated system
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle
• Prepared rollout schedule and negotiated with clients/users and provided management with appropriate deliverables as and when needed.
• Assist with Data issues when needed (Bulk updates or moves, backups, migrations)
• Mentor team and organize training sessions for team to improve performance.

Environment: PL/SQL, Java (J2EE), Test Director, Win Runner, MS Office, MS Visio, MS Project, SQL, ISDN protocols, eTom, ITIL, HDLC, RUP, VOIP, Business Objects, UML, CobiT.

Confidential, Denver, CO

Business Analyst

Responsibilities:

• Defined the customer’s critical to quality (CTQ) issues and requirements for current Defect Management process.
• Measured performance of the “As-Is” process and collected metrics such as defect resolution rate and cycle time.
• Converted existing Excel Reports and MS Access Reports to Business Objects Reports.
• Analyzed the data collected and process maps to determine the root causes and identify opportunities.
• Performed Gap analysis for the modules in production, conducted feasibility study and performed impact analysis for enhancements, Cost benefit analysis and ROI analysis.
• Coordinated activities of multiple business groups such as ASI, IS with in the organization and supported strategic planning, goal settings and plan implementation.
• Conducted user interviews, one to one sessions with the managers and the critical users, and arranged JAD Sessions.
• Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation package.
• Provided “To-Be” process maps and recommended improvements such as streamlining workflow, enhancing defect traceability, reducing manual handshakes, and providing integrated defect view for all stakeholders.
• Acquired appropriate business rules in coordination with users to understand the business functionality.
• Estimated time and cost, developed schedule, budget and determined communication requirements of certification and support initiatives.
• Analyzed and reviewed project elements involved in traceability including testing artifacts, end-user support documentation and training materials to provide tractability across the project.
• Develop the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge
• Assisted Test Lead, Testers understanding business process and help them successful completion of Testing
• Created user guide and production documents for NGSS and thereby improved productivity of production application support groups.
• Collaborated with the ARM/ARC throughout the documentation effort.
• Documented process flows, process dependencies, and production environment configuration.
• Install, deploy and configure applications, perform installation verification
• Apply vendor patches as released, software testing, certification and implementation of NPA
• Writing queries or data analysis and QA report testing
• Coordinate and install new vendor releases, and assisted users with troubleshooting functionality issues
• Managed project initiation, planning, execution, controlling, scheduling, support test, training, and production environment management.
• Manage change, release, and problem events, produce tech plans for new or changed solutions

Environment: Solaris 8.0, Oracle, Informix, Business Objects, NPA 4.0/5.0, Test Director, PL/SQL, Win Runner, Load Runner, CORBA, Apache, MS Project, MS office Suite

Confidential, Auburn Hills, MI

Business Systems Analyst

Responsibilities:

• Facilitated JAD sessions, introduced use cases into application development methodology and created client approval process for project methodology.
• Prepared & presented weekly and monthly business operations review before the senior leadership team
• Implemented systems applications for PFMEA, Control Parts and Decision Gates
• Responsible for conducting meetings & providing training sessions for Suppliers for improving External Balance Score Card.
• Analyzed reports in Business objects and Web Intelligence using the Universes as the main Data Providers and writing the complex queries.
• Performed database query using Teradata SQL Assistant 7.2
• Involved in control settings for AR/AP - Transaction Types, Terms, Class, Source, Method, Activity and Accounting Rules
• Involved in set up for GL - Defined chart of Accounts, Recurring Journals, Cross validation rules, security rules and Calendar
• Prepared High level design for customization of payroll and inventory module.
• Created bi-weekly reports and conducted client meetings to track the progress and timely delivery of final deliverable.
• Plan, schedule, initiate, and follow up with quality engineering procedures to improve and maintain product quality
• Aligned requirement documentation with use of UML for object oriented software development (OOD).
• Created detailed functional specifications for development team
• Documented the Use Cases and prepared the Use Case, Activity, Logical, Component and Deployment views using MS Visio and Rational Rose for a clear understanding of the requirements by the development team. Coordinated with testers in using Rational ClearQuest for defect tracking
• Reviewed Integration Test Plan for integration between modules.
• Documented project processes and procedures and version controlled them using Rational ClearCase
• Created Artifacts and defined Milestones and iteration plans for Inception and Elaboration phases of SDLC
• Assisted the Account Management people in reviewing the account of the customers.
• Used TestDirector with QA team for testing.
• Developed supplier payroll system with the provisions of dynamic salary structure/increments/ annual leave, gratuity calculation, staff overtime, report generation module and salary posting to GL.
• Worked closely with project manager in handling whole project.
• Identified and managed issues, risks, constraints and change requests for projects as well as those applications that could affect projects resulting in successful implementations
• Worked independently using a pre-defined project plan and maintained detailed level records for all phases of the application systems and programming activities

Environment: Rational Rose, Test Director, RUP, UML, MS Office, MS-Project, Business Objects, SQL, MS Visio, UNIX, Crystal Reports.

Confidential, Warrenton, VA

Business Analyst

Responsibilities:

• Researched on business requirements, documented system workflow procedures, planned the project flow using SDLC methodology.
• Reviewed and approved system change requests and developed detailed provisions for implementation.
• Facilitated team meetings to coordinate activities for project schedules with the management, Marketing & Sales Managers, clients, SME's and technical managers conducting JAD sessions.
• Had planned deadlines assigning the responsibilities, monitored and summarized project progress on weekly basis.
• Evaluated, analyzed, and made recommendations for global IT management processes using CobiT maturity models.
• Responsible for the Designing and analyzing classes and objects by using the Business Object Designer.
• Created test cases and test plans for User Acceptance Testing
• Performed Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Proactively identified, analyzed and communicated project issues and risks.
• Prepared status reports for upper management regarding focusing on the status of project on different modules.
• Used UML/RUP approaches to deliver the use cases, conceptual and detail designs, architectural flow, test plans, and business requirement.
• Identified and documented business rules and created detailed Use Cases on different scenarios.
• Developed the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.
• Conduct User Acceptance Testing (UAT)
• Acted as a resource in understanding how IS systems carry out business functions and assists in ensuring the timely and effective implementation
• Developed timelines for project delivery, and managed projects and resources to successful completion.
• Established the business analysis methodology using Rational Unified Process technique
• Trained End-users and customer service agents on the CRM (Customer Relationship Management) application
• Assisted in building the business analysis process model using Rational Rose.
• Worked extensively with RUP methodology and Rational Suite Analyst Studio using Rational Rose, and Rational Requisite Pro
• Used Six Sigma Methodologies in solving the errors and issues while the development of the project.

Environment: Windows, Crystal Reports, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), J2EE, Business Objects, Oracle, SQL Server, RUP, UML, and GAP Analysis.