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.
• 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

E Commerce: IBM Websphere Commerce and SAP Hybris

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

Responsibilities:

• Analyzed business strategy and user needs, document specifications, and translated business objectives into proper specifications that deliver value to business.
• Guide business users through business case development for new application functionality, including cost/benefit analysis and risk/impact analysis.
• Coordinated business requirements and other documentation in relation to the SDLC model
• Tracked changes, analyzed proposed changes for impact to project schedules
• Design and coordinate user acceptance testing across different platforms and devices (i.e. Desktop, Mobile and tablet)

Confidential

Business Analyst

Responsibilities:

• Conduct research on prospect companies (industry, financials, etc.)
• Develop benchmarking, savings, and service analysis and case studies for inclusion in proposals
• 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

Responsibilities:

• Gathering and analyzing customer data and user requirements, understanding and interpreting user needs and goals into solutions.
• Define business process flows and workflows.
• Support development of RFP abstracts or summaries
• Compile all solution elements and input into client pricing templates, synchronize and reconcile with internal in house product models
• 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)

Responsibilities:

• 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

Responsibilities:

• Prepared project feasibility reports in conjunction with project/development initiatives.
• Evaluated projects to determine strengths, weaknesses, opportunities, and problems and engineer appropriate solutions
• Communicate with client personnel in order to identify and assess existing accounting processes internal controls, and compliance with regulatory requirements.
• Review accounting transactions and consider appropriate application of generally accepted accounting principles.
• Perform other duties as needed on engagements and as assigned by supervisory personnel.
• 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

Responsibilities:

• 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.
• Effectively managed, prioritized, implemented requirements including defects for iterations as part of user testing activities and added to the stack of lists.
• 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.
• 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.
• 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.

Responsibilities:

• 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.
• 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

Responsibilities:

• 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.

Responsibilities:

• 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

Responsibilities:

• Designed and Developed Mappings using features of Powercenter Designer.
• Preparing Source-Target Mappings documents to provide the logic for mappings development.
• 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