SUMMARY

• 7 years of experience in Business analysis with focus on data analysis, data modeling, project management, ITIL Business Processes and GAP Analysis
• Strong experience in working with data warehouses and datamarts using Informatica Power Center
• Experienced with databases MS SQL Server 2008/2012, Oracle 8i/10g/11g, Teradata, and IBM DB2
• Extensive knowledge with dimensional data modeling, star schema/snowflakes schema, fact and dimension tables, process mapping using the top-down and bottom-up approaches
• Experience in giving end-user training in SAP solutions, technologies and preparing the training material and presentations
• Proficient in technical documentation including technical specifications, test plans, requirement specifications, Business Requirement Document BRD , Functional Requirement Document FRD , Non-Functional Requirement Document, data flow diagrams, data path diagrams and Purdue models etc
• Experience in interviewing Business users and SME's providing recommendations to resolve issues for various business/technical groups and defining strategic solutions to business problems in a multiple project environment
• Proficient in SDLCs using the iterative and incremental methodologies such as RUP, Agile Scrum, Agile XP, non-iterative methodologies and Waterfall methodologies
• Expertise in UML Use case modeling, Test cases, Activity diagrams, Sequence diagrams and ER diagrams , writing user cases, test scenarios, release plans and product backlog documents
• Extensive experience in the development, implementation and integration strategies towards a team oriented environment, utilizing quantitative and qualitative analytical skills
• Working experience in a cross-functional team environment/different geographical location teams
• Strong interpersonal and communication skills

SKILLS

• Development: C, C
• ETL Tools: Informatica Power Center, Data Stage
• Operating Systems: Windows 98, Windows XP, Windows 2000, Windows 7 and UNIX
• Databases: MS SQL Server 2000/2005/2008, Oracle 8i/9i/10g/11g, Sybase, IBM DB2, SAP ECC
• Methodologies: Waterfall, Rational Unified Process RUP , Open Up, Agile, Iterative and Incremental
• Data Modeling Tools: MS Visio, Rational Rose, Star UML, Enterprise Architect
• Business Analysis Tools: Rational Rose, Rational Requisite Pro, Microsoft Office
• Change Management Tools: SharePoint, ITSM Remedy

EXPERIENCE

Confidential

Sr.Business Analyst

Confidential is one of the world's leading integrated energy and technology companies. They explore, produce and transport crude oil and natural gas, refines the market and distributes fuel and other energy products, manufactures and sells petrochemical products, generates power and develops future energy resources, including bio-fuels and geothermal energy. The project at Chevron focuses around aligning all of the assets used in the San Joaquin Valley Business Unit in accordance to Chevron and industry standards, thereby ensuring Evergreen compliance. This project further extends its scope to implementation of Lean Sigma business processes.

Responsibilities:

• Lead Compliance Assurance Team in training and promoting compliance activities among various technical, functional and projects teams
• Identify, implement and manage Lean Sigma Projects for various teams including Server Teams, Database Teams, Application Teams, etc
• Supervise and conduct Risk Assessments for various assets in the Process Control Network PCN
• Analyze the gap assessment and remediate the gaps by streamlining and documenting Processes
• Streamlining existing processes and proposal of new processes to keep audit compliance evergreen
• Facilitate workshops on Process Maturity and process validation including Disaster Recovery, Incident Management, Change Management and other ITIL Business Processes
• Expertise in business modeling documentation for the AS-IS process and proposing the TO-BE business process
• Apply PMO tools and controls to work plans, schedules, project estimates, resource plans, risk/issue logs, change control, quality assurance and status reports in compliance with audit and regulations

Environments: SCADA PCN, LOWIS, SharePoint, MS Visio, MS Project Plan, Microsoft Office, EWRIN Data Modeler, ITSM, Excel VBA, Qlikview

Confidential

Business Systems Analyst

Confidential is the consumer division of financial services multinational Confidential is a global bank with 3,777 branch locations in 36 countries. In addition to standard banking transactions, Citibank markets insurance, credit cards, and investment products. Their online services division is among the most successful in the field, claiming about 15 million users. Password Management Pro Tool was implemented to ensure there is a centralized tool for maintaining passwords and better security around them. Cash Management module was developed for Confidential region, module was successfully implemented in 12 countries in the region including Confidential.

Responsibilities:

• Successfully implemented Password Management Pro Tool within a stringent time frame. Involved with testing of Password Management Pro Tool and documenting procedures for Administrators
• Actively involved in different phases of manual software testing which included understanding project requirements, execution, test result analysis and bug reporting for the application
• Acted as a Liaison between various technical, functional teams and stakeholders
• Prepared Test Scenarios, Test Conditions, Test cases and Automation Scripts in Quality Center
• Generated flow diagrams for various processes and functionalities used in Cash Management Module
• Prepared technical specifications for the development of Informatica mappings to load data into various target tables and defining ETL standards
• Designed test plan and test cases to test Informatica mappings
• Developed and validated the test packages of business process like sales order, credit management, billing and pricing
• Created standard guidelines for User Interface Testing
• Performed white box testing and manual testing for the reports
• Involved in testing the new functionalities based on test cases and coordinated with the development team in fixing the identified bugs and defects

Environments: MS Visio, MS Project Plan, Microsoft Office, HP Quality Center, Informatica Power Center

Confidential

Business Analyst

Morgan Stanley mobilizes capital to help governments, corporations, institutions and individuals around the world achieve their financial goals. A consistent industry leader throughout decades of dramatic change in modern finance, Morgan Stanley will continue to break new ground in advising, serving and providing new opportunities for its clients. The Credit Middle Office team plays a pivotal role in supporting Morgan Stanley's Credit Department in credit risk analysis and limits monitoring. The team is also responsible for credit data management, credit policy/procedure implementation, portfolio and single name monitoring credit limits monitoring/reporting/escalation , and process change management.

Responsibilities:

• Worked with Basel III implementation team and documented change management procedures
• Involved with documentation related to Stress Testing procedures, Dodd Frank and SOX regulations
• Worked on Credit Risk, Market Risk, Operational Risk and Financial Risk Management documentation procedures
• Developed scripts in Excel VBA to automate calculations and reports based on Risk Exposures and other risk management calculations. Write SQL queries in Teradata SQL Assistant to query data from backend tables and check performance parameters.
• Test joins conditions, mappings and inter dependencies for Data Mart tables in Teradata
• Extensively used Qlikview for report generation and decision making
• Implemented Project Initiation PI Tool which is used to submit project ideas to IT. PI Tool is used to track project planning, project delivery and handovers including project cost approvals, various phases of the project, etc.
• Gathered business requirements from the managers through JAD sessions and interviews
• Analyzed the reports for Risk monitoring and prepared a GAP analysis report
• Developed Use Cases to capture different scenarios of risks involved in various products
• Documented activity, deployment and workflow diagrams in Visio
• Responsible for onsite, offshore coordination to ensure adherence to report delivery schedules

Environments: ITSM, Excel VBA, Qlikview, Visio, SQL, Teradata, Teradata SQL Assistant

Confidential

Business Analyst

Confidential is a nonprofit health plan that is part of a family of companies financing and delivering health services for more than 1.8 million upstate Confidential. The project involved extraction and aggregation of data from multiple databases for particular members or claims and process them as per the business requirements using ETL and BI Tools.

Responsibilities:

• Worked closely with claim system processing to incorporate claim approval/denial and claim reimbursement and evaluated the claim system with which the data would be interfaced for the user
• Dealt with ICD 9 encryption to verify and confirm the validity of the incoming claims and documented them by saving it in the database
• Worked closely with the EDI 835 transaction to overlook both claim payments and remittance advice as they are incoming documents from the payer
• Helped streamline the 276/277 transaction in order to enable easier and faster exchange of information between the payer and the provider
• Conducted extensive research of the incumbent systems to get an understanding of the processes and the functional workflow in order to analyze and initiate the project
• Used Agile methodology to oversee the various activities of the project on a day-to-day basis and also conducted daily and weekly meetings to maintain accountability of each of those activities
• Documented Business Requirement Documents and use case specification documents and came across various functional requirements through UML diagrams with the help of activity, use case and specification diagrams
• Carried out complete and comprehensive business analysis with the help of Rational Unified Process RUP methodology and used Rational-Requisite pro to document all the gathered business and functional requirements
• Assisted QA team by reviewing test cases and test protocols for verifying the requirements to ensure complete coverage of all functional and technical requirements. Used Requirement Traceability Matrix to conduct thorough testing and verification.
• Extracted necessary data, prioritized and manipulated it to enhance the testing of the system using SQL reporting

Environments: ITSM, SQL, Rational Requisite Pro, MS Visio, Microsoft Office

Confidential

Business Analyst

Confidential is focused on providing branded consumer goods. The company's products are sold in over 180 countries around the world. Primarily through mass merchandisers, grocery stores, membership club stores, drug stores high-frequency stores and the neighborhood stores, which serves the consumers in the developing markets. The expense control dashboard was built to save user preferences.

Responsibilities:

• Worked with Project Managers and end users to discuss and decide the business goals and strategies of the project
• Prepares estimation sheets and requirements as well as defined timelines for each individual object
• Played key role in System Development Life Cycle Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria, and Implementation of User Preference Dashboard
• Gathered business requirements from the managers and coordinated with the offshore team to develop Data Sources and InfoCubes as required by the business
• Coordinated participation and sign-off of various business partners and customers
• Worked with developers onsite to create custom tables, GUI's and workflows as per the functional requirements
• Performed and monitored the unit testing, integration testing, user testing through various environments such as development, quality and production
• Assisted in development of the reports using SAP Business Warehouse
• Delivered training to the users and additional training to the power users in using the ad-hoc reports
• Provided Go Live support after deployment of the project

Environment: SAP BW, MS Project, Visio, MS Office

Confidential

Business Analyst

WellCare provides Medicare and Medicaid managed care health plans for 2.2 million members, partners with over 91,000 physicians, and employs over 3,500 associates. WellCare Health Plans, Inc. is the holding company for several subsidiaries, including WellCare, Staywell, HealthEase, Harmony, and 'Ohana. The project involved building dashboards and reports for various products for all their clients.

Responsibilities:

• Created and analyzed data and reports using SAS and business objects to track issues and risk management
• Analyzed SAS and business object reports to identify high risk cases and escalate and resolve issues based on priority
• Maintained SQL scripts to update daily migration reports and integrate them with the application database
• Created and maintained daily project dashboard with charts and graphs to present graphical view of the progress under various classes of business to the global team
• Created and ran SQL queries to gather data from multiple sources for executive review reports.
• Worked with business objects for reporting. Tracked and reported different assets for different departments and their status.
• Created analysis report on current issues and suggest solutions. Produced special cases progress reports for the management review.
• Worked with users to resolve application readiness issues for the new operating system
• Maintained internal application database using various data sources
• Performed regular data integrity checks and balances to ensure clean and accurate data
• Participated in Functional and User Acceptance Testing to ensure complete and successful deployment
• Managed ad-hoc requests and bulk requests for early system migrations to the new system

Environment: SQL Server, SAS, UNIX, MS Access, MS Excel, Business Objects, MS Office, SharePoint, Windows 2000 and Windows Vista, MS Live Meeting, MS Office Communicator.

Confidential

Business Analyst

Confidential Infotech provides winning edge by leveraging a three-pronged unique value proposition encompassing Business-to-IT Connect Engage the Future and Execution Excellence. Confidential Infotech's services and solutions have a strong domain focus that helps companies from different industries maximize the value of their IT spend.

Responsibilities:

• Participated in the business requirements gathering discussions with end users for the iterative approach needed for migrating legacy apps to a consolidated Web application for estimation and bidding
• Designed the application including the business logic, process flow and interfaces
• Involvement in development of various Web screens and interactive/print forms using Adobe forms
• Acted as a liaison between business team and technical team to articulate needs, issues and concerns
• Worked on performance tuning to optimize the output of applications
• Provided global support to SAP R/3 landscapes
• Created Custom Tables, Search Helps, Database Tables in SAP
• Used MS-Visio for flow charting, process model and architectural design of the application
• Analyzed the security requirements for user authentications and validations and created the SAP security objects to be verified as part of the Web application access
• Designed the data models for all custom data storage creating 20 custom tables to store the catalog data
• Performed the unit testing and supported business acceptance testing to verify the functionality
• Supported the complete software lifecycle from development to the production deployment

Environment: SAP BI/BW, SAP BO, MS Visio

Confidential

Confidential and Tier-I auto component manufacturers in India for the past 20 years, with an annual revenue of over INR 350 million. Globe Steels manufacture precision machined automotive components for a variety of applications, including transmission, steering system, fuel injection, hydraulic systems and auto electrical. Their product range includes machined castings and forgings, splined shafts, pinions, sprockets.

Responsibilities:

• Work with stakeholders to develop the strategic direction for product management
• Contribute to the develop of the product management strategic plan
• Develop new processes and refine existing processes
• Perform process improvement activities
• Develop and deliver training
• Participate in project selection activities
• Implement Disaster Recovery and best practices

Environment: MS Visio, MS Word, MS Excel, MS Project