PROFESSIONAL SUMMARY:

• Over 14 Years of IT experience such as a Sr. Business Analyst, BI Analyst, Data Analyst, Business Analyst using with Business Intelligence applications. My business intelligence experience include working with multiple level leaders within a variety of industries to gain insights into what their data has to say about their company or their industry. Experience in various industry sectors such as Banking, Oil & Gas, Utilities & Public Sector, Health Care, and Retail.

TECHNICAL SKILLS:

OALP Tools: Business Objects 4.0/3.1/3.0, Crystal Reports, Cognos 8.0, Tableau 7.0/8.0/9.0

Methodologies: SDLC, RUP, XML

RDBMS: Oracle 8i, SQL Server 2008/2005/2000 , Teradata 13.0/12.0,IBM DB2

ERP: SAP BW 7.0

Operating Systems: Sun Solaris 5.6/8.0, HP - UX, Aix 5.x, Redhat Linux 6.5, Windows 95/98/NT/2000, MS-DOS.

ETL Tools: Informatica Power Center 5.

1Data Base Tools: Erwin 3.5.2, Toad 7.1.

Testing Tools: Quality Center 9.0/6.0/2.0, Rational Requisite Pro 7.1.

Languages: Java 6/4 (JSP, JDBC), XML, JavaScript, HTML, DHTML, PL/SQL, Perl, Korn/C/Bourne Shell Script C, Sun C++.Siebel 6.x.

Project Management: MS Office, MS Visio, MS Project

PROFESSIONAL EXPERIENCE:

Confidential, TX

AREAS OF EXPERTISE:

• Excellent knowledge of industry standard methodologies like Software Development Life Cycle (SDLC), Water fall methodology, Agile methodologies, Iterative Software Development Life Cycle Process like Rational Unified Process (RUP), CMM (Capability Maturity Models) and Rational Tools used during various phases of RUP.
• Proficient in customizing existing business practices, workflows, activities and deliverables.
• Experience in UML and Process modeling using Use Cases, Use Case Diagrams, Activity Diagrams, Sequence Diagrams and Class Diagrams, Data flow diagram (DFD), Process Flow Diagram (PFD) using MS Visio and Rational Rose etc.
• Acted as a liaison between Domain SME and Development Team ensuring smooth work flow. Worked closely with project managers, SMEs and staff to understand and brief the requirements and specifications for new applications along with re-engineering the existing applications, evaluate the cost/benefit analysis on requirement requests and change requests.
• Experience in conducting Joint Requirement Planning (JRP) sessions, Joint Application Development (JAD) sessions and Rapid Application Development (RAD) sessions with committee of SME, business groups, senior management and IT groups.
• Experience in Gap Analysis of the AS-IS and TO-BE system, analyzed and identified the possible gaps for system integration.
• Thorough in-depth knowledge and experience in Business Intelligence tools, Reporting and Analytics.
• Strong experience in Data Profiling very large data sets to identify system behavior. Experience in creating and maintaining data dictionary in a BI Environment.
• Experience in working with Development and QA teams and UAT testing.
• Proficient in Quality Assurance Life Cycle like developing Test Strategies, Test Plans, Test Cases (Manual / Automated), Defect Reports and developing Test Scripts.
• Experience in Test Planning, creation of Test Strategy, Design and execution of Test Cases, Defect Management and Reporting.
• Performed User Acceptance Testing (UAT) to test the functionality of the application.
• Strong experience in client interaction and understanding business applications, business data flow and logical/ physical data modeling.
• Have extensive experience in documenting business, system and data requirements such as Business Requirement Document BRD, System Requirement Document SRD, Functional Specification Document FSD, Logical Solution Design LSD, Data Requirement Document DRD, and Traceability management & Matrix Reports.
• Experienced with performing various requirements elicitation techniques like interviewing, questionnaires, brainstorming, group discussion, reverse engineering from system documentation, prototyping, and in conducting Joint Application Development JAD sessions.
• Have extensive experience with UML modeling such as creating workflows, Use Cases, activity, logical, class, Sequence, activity and Collaboration diagrams.
• Proficient in manual and automated testing using several testing tools for various testing purposes.
• Proficient in creation of Conceptual Data Model (CDM), Logical data model (LDM), Physical Data Model (PDM) for various types of information systems like OLTP and OLAP.
• Experienced in multi-dimensional data modeling techniques like star schema in building Data Warehousing and worked with data quality and governance team for master data management.
• Experienced in analyzing and designing Source to target (STM) mapping documents for Extraction Transformation and Loading (ETL) Applications & Processes for Data Mart and Data Warehousing Systems with working knowledge and experience in Structured Query Language (SQL).
• Functioned as the primary point of contact and liaison between the client, management, and the software vendor in the installation, configuration and implementation of the software product, and all the communication throughout the project life cycle.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Excellent Analytical skills to understand the business process and Functionality requirements and to translate them to system requirement specifications.
• Expertise at using MS Visio, MS Project, MS Excel, PowerPoint, and SharePoint
• Experience in various RDBMS Oracle, SQL Server and Teradata.
• Knowledge in ETL Data warehousing using Informatica Power Center, Workflow Manager and Workflow Monitor.
• Experience in Business Intelligence tools such as SAP BW/BOBJ, Cognos, Tableau.
• Experience in educating and supporting end-user reporting needs using Business Objects, Tableau, Crystal Report and Cognos.
• Excellent analytical & problem solving skills and a team player with strong interpersonal and communication proficiency.
• Excellent communication skills, Self-motivated, highly committed to responsibilities, ability to work independently and can perform well within cross-functional teams.