Business Analyst

Address: *** ******** ******,***# *****, Lewisville, Texas, 75057

Email: ******.******@*****.***

Cell: 314-***-****

QUALIFICATIONS

* 3 years’ experience in Business and Data Analysis consisting of projects in IT and Telecom domain.

* Expertise in Business Intelligence Tools to provide advanced Business Insights and Management Reporting.

* Experience in Delivering end to end solutions with support in all phases of the project life cycle.

* Experience in various tools and technologies such as Databases, Data Warehousing Tools and Business Intelligence

CORE STRENGTHS

Project and Operations Management

Database Design and Analysis

Enterprise Solutions

Systems Implementation

Clients Needs Analysis

Continuous Process Improvement

Business Process Reengineering

TECHNICAL ACUMEN

Business Software

: IBM Rational Modeler, Business Objects XI R3, Crystal Reports, Informatica Powercenter 7.x,8.x, Cognos, SAS Enterprise Miner, ERwin

Microsoft Products:

Visio, MS Project, MS Office (Excel, Word, and PowerPoint)

Databases

: MS SQL Server 2008, Oracle 10/11 g, MS Access 2007

Languages

: SQL, UML

CREDENTIALS

* MASTER OF INFORMATION TECHNOLOGY AND MANAGEMENT

University of Texas at Dallas | Richardson, TX | GPA: 3.77 | May 2011

* BACHELOR OF SCIENCE IN ELECTRONICS AND TELECOMMUNICATION ENGINEERING

University of Mumbai | Maharashtra, India | June 2007

* SAS Institute Graduate Certificate in Business Intelligence and Data Mining

RELATED EXPERIENCE

STUDENT WORKER UNIVERSITY OF TEXAS AT DALLAS | RICHARDSON, TEXAS | MAY 2010-MAY 2011

* Managed smart card publishing.

* Data extraction from database using SQL Queries.

* Facilitated distribution of smart cards.

* Involved in Car Parking Management for UT Dallas.

BUSINESS ANALYST | RELIANCE COMMUNICATIONS PVT LTD | MAHARASHTRA, INDIA | JUL 2007-MAR 2008 AND

RELIANCE TECH SERVICES PVT LTD | MAHARASHTRA, INDIA | APR 2008-JUL 2009

* Perform a broad array of requirements gathering and upgrade of processing requirements; engaged in creating Fit-Gap analysis; and write detailed description of user needs as well as functional/technical specifications.

* Document business and system requirements, process flows, and data model; conduct comprehensive analysis on business records, operating manuals, as well as business guides for data and process mapping.

* Acquire broad experience with business process models, functional and non-functional requirements, uses cases, activity diagrams, sequence diagrams, data dictionary, business rules, and user interface specifications.

* Worked with subject matter experts, IT professionals, and software developers to define project scope and objectives.

* Experience in the full System Development Life Cycle (SDLC) with understanding of a variety of technologies and platforms such as web, client/server, entity-relationship diagrams (ERDs), relational database concepts.

* Experience in creating Entity Relationship database models using MS Visio and Erwin.

* Created SQL queries consisting of complex joins, aggregate functions and advanced SQL functions.

* Created adhoc reports and dashboards in Excel, Business Objects, Cognos as per requirements.

* Expertise with analytical reporting using Advanced Excel features like Pivot tables, lookup, formulas and charts.

* Formulate and analyze IT process reports and provide trends, patterns feedback for process improvement.

* Developed mappings using Informatica Power Center Designer to transform and load the data from various source systems like Flat files and Oracle source database and loading to Oracle target database.

* Conducting training sessions for process support group.

* Performed UAT testing along with QA team.

ACADEMIC PROJECTS

DATABASE MANAGEMENT SYSTEMS

* Designed and implemented a database using the entity relationship modeling technique with understanding of relationships, data types, tables, views and queries.

* Forms and Reports creation using SQL Server 2008 and access database.

SYSTEM ANALYSIS AND PROJECT MANAGEMENT

* Modeled an information system using Unified Modeling Language (UML) diagrams.

* Analyzed an existing system and identified the causes of an information related problem, and designed a new system using class, sequence, ERD, Use Case diagrams to mitigate these problems.

SPREADSHEET MODELING

* Identify the conceptual structure of a decision or planning problem

* Analyzing the logic associated with the components and process of model development

KEY ACHIEVEMENTS

* Awarded Dean’s Excellence Scholarship for academic excellence by the School of Management, UTD

* Promoted to Deputy Manager Level in Reliance ADA Group of Industries for portraying excellent technical, management, communication and customer support skills.

* Distinction in Under-Graduate Engineering degree and Master’s Degree at University of Texas at Dallas.

AFFILIATIONS AND ACTIVITIES

* SAP User’s Group at University of Texas at Dallas.

* Association of Information Technology Professionals at University of Texas at Dallas.

* Volunteer for spring 2010 Career Expo held at University of Texas at Dallas.

Contact this candidate