SUMMARY:

• Over 9 years of IT Industry experience in the role of Business System Analyst.
• Domain experience in Pharmaceutical, Health Care, Supply Chain Management, Retail Systems and Telecom.
• Extensive experience to analyze, diagnose and resolve complex programs in business applications; interact and work with appropriate personnel to develop solutions.
• Proactively driven and collaborated with external and internal customers to analyze information needs and functional requirements and delivered the following artifacts as needed: (Functional requirements (Business Requirements Document), Use Cases, GUI, Screen and Interface designs) involving Agile and mostly Waterfall methodologies.
• Excellent project management skills and ability to manage team in the accomplishment of goals.
• Facilitated training and working sessions with industry users and business executives.
• Extensive experience working with cross - functional teams involving IT and business.
• Excellent problem solving skills with a strong technical background and good communication skills.

TECHNICAL SKILLS:

ERP Products: BaaN 5.0 & BaanLN, SAP R/3

Supply Chain Products: IBM Sterling Distributed Order Management

Relational Databases: Oracle, SQL Server, MySQL, Teradata

Datawarehouse Tools: Informatica, Business Objects XI, Crystal Reports, Cognos, Brio

Database Tools: Toad, SQL Navigator, ERWin

Programming/Scripting: Java, JavaScript, C++, C, PL/SQL, Shell Scripting.

Operating Systems: HP-Unix, Windows

Testing Tools: QTP, HP Quality Center

System Modeling tools: Data Flow Diagrams, Process Models, ER diagrams, Data Models, Use Cases

IBM tools: Rational Clearcase, Rational Rose and RUP

Methodologies: SDLC, Agile

Other Administration: MS Project

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst

• Coordinated business requirements and other documentation in relation to the SDLC model
• Tracked changes, analyzed proposed changes for impact to project schedules
• Coordinated review and approval of changes and revising any requirements documentation and user notification
• Design and coordinate user acceptance testing
• Test requirements at all stages of the project, including functional validation and smoke testing of development deliverables to ensure compliance with the functional requirements as specified

Confidential

Business Analyst

• Coordinated business requirements meetings to determine potential impacts to our front-end Customer Care and Retail systems
• Attended development team scrum meetings to answer design and business requirements related questions. Information gathering from Websphere Commerce team to map the commerce field into Sterling.
• Created specification / wireframes to illustrate UI interactions.
• Created business, functional requirements and worked on User Stories.
• Analyzed and documented new and existing business processes to validate a solution that supports project objective(s)
• Collaborated with IT and business teams to test, deploy and verify requested system changes.

Confidential

Business Analyst

• Gathering and analyzing customer data and user requirements, understanding and interpreting user needs and goals into solutions.
• Working with subject matter experts, IT professionals, and software developers to define project scope and objectives.
• Define business process flows and workflows.
• Represent the organization in client meetings, document meeting outcomes, and coordinate all internal and external follow-ups to close issues in support of the project requirements.
• Collaborate with system architect and development leads to document all software changes necessary to meet the requirements project request.

Confidential, Dallas

Business Analyst

Environment: Java, Quality Center, QTP (BPT component)

• Supported activities related to the creation of business requirements for application development
• Worked in translating the requirements into functional and non-functional requirements in form of Use Cases, Business flow diagrams, etc.
• Worked on creating the Business process components for testing the functionality of the application.

Confidential

IT Business Analyst

Environment: SXC Rx Express (PBM), Java, Oracle

• Prepared project feasibility reports in conjunction with project/development initiatives.
• Evaluated projects to determine strengths, weaknesses, opportunities, and problems and engineer appropriate solutions
• Acted as liaison with external as well as internal clients to ensure project requests/business needs are met in an efficient and effective manner.
• Translated business requirements into specified project requests for presentation to management, development and Quality Assurance teams
• Worked under aggressive timelines and involved extensively in workflow mappings in identifying potential issues.
• Assisted the business to create proposals for modification of existing systems and future state systems based upon the business needs.
• Extensively involved in identifying and documenting impact of business requirements on all primary and secondary systems.
• Worked closely with developers and end users to ensure technical compatibility and business process uniformity.

Confidential

Business System Analyst

Environment: BaaN ERP, SQL Server, Business Objects XI, Crystal Reports

• Under general direction of the Director was responsible for participating in planning and coordination of some of the below technology projects to ensure that the goals and objectives of projects and deliverables are accomplished within specified timeframes and funding parameters.
• Some of the projects followed Agile Methodology which focused on more face to face meetings with stakeholders, software developers and testers; making use of more User Stories and less Use Cases for documenting the requirements.

Confidential

• Analyzed and gathered the just-in-time (JIT) requirements through intense collaboration with customers involving multiple business units, software architects, stakeholders and software testers.
• Used agile systems and strategies to provide quick and feasible solutions, based on agile system, to the organization.
• Analyzed the complex logic involving multiple business units to aid towards the development of High Level Impact Assessments.
• Involved in the development of test requirements, creation of user documentation, delivery of end user training, testing effort and assist user community with UAT planning and activities.
• Effectively managed, prioritized, implemented requirements including defects for iterations as part of user testing activities and added to the stack of lists.

Confidential

• Critically evaluated information gathered from multiple sources, reconciled conflicts, decomposed high level information into details, abstract up from low level information to general understanding and distinguish user requests from the underlying true needs.
• Provided advice and consultation to help clients adopt best practice aspects of the business process.
• Driven and challenged business units on their assumptions of how they can successfully execute their plans.
• Developed ad hoc reporting and assisted with the production of daily, weekly and month-end reporting as needed.

Confidential

• Performed evaluations of installed applications for cost savings achievable with new technologies; assisted managers and directors in developing plan justification for conversion of potential applications

Confidential

• Reviewed the business environment and worked with the key users and functional managers to identify improvements supporting various applications.
• Performed preliminary project evaluations, analysis and design for complex programs and/or systems.

Confidential

• Involved in building a repository for Business Process Management group, which includes the information from HR Payroll and active directory. It’s created to be a part of assisting the IT organization and attempt to find ways to improve for ‘SOX’ and ‘Better Practices’
• Involved in the beginning of a project, during Iteration 0 to do some initial architecture modeling to identify a potential vision for how the team can build the repository.
• Captured the initial architecture views and the details on a just-in-time (JIT) basis via model storming, over viewing the business entities and relationships between them.

Confidential

Data Warehouse Business Analyst/ETL Lead

Environment: Business Analysis, User Requirements, Use cases, Informatica Power Center 7.1.2/6.1, Erwin, Oracle 9i, Business Objects 6.5, Toad, UNIX.

• Estimation and Project Planning for the development of project.
• Gathered business requirements and analyzed business needs to prepare Functional Specifications
• Analyzed the Business Requirements and developed functional design and technical specifications documentation.
• Analyzed and developed "as is" and "to be" Use Cases, Process Maps, Process Flows and Systems Design documents through the use of focus groups; reverse engineered the existing system to obtain data and process flows; re-engineered business process for "To be" application with Use-case analysis.
• Developed ETL Mappings and Mapplets in Informatica to load data from various sources like flat files/sources to ODS to Anthem East Data Warehouse (AEDW).

Confidential

Data Warehouse/Business Intelligence Analyst

Environment: Informatica Power Center 6.2/7.1.2, Hyperion Brio 6.6, Oracle 8i/9i, TOAD, ERWin, UNIX

• Involved in ETL processes to load data into the target Oracle database by applying business logic on transformation mapping for inserting and updating records when loaded.
• Created sessions, worklets and workflows for carrying out test loads.
• Extensively used Hyperion Brio for reporting purposes.

Confidential, Dallas, TX

Data Warehouse/Business Intelligence Analyst

Environment: Informatica PowerCenter 6.2, Microstrategy 7.1/7.2, ERWin, XML, Oracle 8i / 9i, UNIX and Windows 2000.

• Imported various Sources, Targets, and Transformations using Informatica Power Center 6.2 - Repository Manager, Designer Workflow Manager and Workflow monitor.
• Analyzed and Created Facts and Dimension Tables.
• Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Used Microstrategy for reporting purposes.
• Developed various Mappings with the collection of all Sources, Targets, and Transformations. Used multiple Sources and Multiple targets.

Confidential

Data Warehousing Consultant

Environment: ERWin, Oracle 8i, Informatica Powercenter 4.5/5.1, Windows 2000, Visio

• Designed and Developed Mappings using features of Powercenter Designer.
• Preparing Source-Target Mappings documents to provide the logic for mappings development.
• Involved in Project life cycle documentation- with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into different targets.
• Resource Information System Transformation (RIST) Datawarehouse infrastructure is an integrated approach to identifying, acquiring and retaining customers. By enabling In-Store 7-Eleven Process to provide an analytical solution by managing and coordinating customer interactions across various modules like Finance, Sales and Marketing.
• Involved in communicating with the Business to understand their requirements, provide possible solutions to meet their needs and provide explanations in a clear and concise manner Worked on the Project initiation documents and power point presentations in gathering the stakeholders.
• Worked on the Vision and Scope documentations. Assessed user and business needs to identify technology requirements. Also used Visio for drawing specific proposals.
• Worked on the Business Requirement documentation by identifying the business rules, basic business process flow and sub-flow for the concerned business activity flow steps