Objective
Looking for full time/ internship opportunity to utilize my IT skills in corporate sector

Summary

• Experience in building Universes using Designer component of SAP Business Objects XI
• Expertise in developing Strategies for ETL mechanisms using Informatica PowerCenter (8.x/7.x)
• Strong RDBMS concepts and working knowledge of database Tables, Views, Stored Procedures and Functions using SQL
• Involved in troubleshooting, optimizing, and fine-tuning the SQL Queries for efficiency
• Expertise in requirement gathering, process mapping and transitioning knowledge to the off shore team

Education

Master of Science, Management Information Systems

Databases Tools: Microsoft SQL Server 2005 2008, MS Access
ETL Tools: Informatica, SSIS
Reporting Tools: SAP Business Objects XI, Cognos, SSRS, Xcelsius,
Statistical Tools: SAS 9.0, JMP8.0
Other Tools: MS Visio, MS Project, MS Office Suite
Programming Languages and Web technologies: C, C++, HTML, CSS, Dreamweaver

Work Experience

Confidential,Houston, USA (Client: Ceva Logistics) May 2011-Present
Business Analyst

• Gathered requirements through interviews, existing documentation and defining the scope of processes of the logistics industry
• Process mapping and effort estimation to analyze the FTE requirement to implement change management
• Defining timeline for Go Live and gap analysis
• Root cause analysis and implementing corrective measures to fill in the gaps
• Conducting data analysis and defining metrics to create Business Intelligence reports
• Implementing scope change and transitioning process operations to offshore team
• Liaison between the offshore-onshore team and conflict management to maintain customer relationship

Confidential,Ambernath, India November 2006 – July 2009
Analyst (Data Analysis/Reporting and Project Management)

• Reviewed existing documentation of Fuel cell parameters and implemented measures for performance enhancement improving the efficiency by 20 %
• Developed universes to accommodate complex database design approaches.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Developed Canned and Ad-Hoc Reports using existing/modified universes in Web Intelligence XI 3.1 using web Intelligence features and functionalities
• Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
• Developed interactive dashboard using Xcelsius withalerts,calculators, and datacomparisons
• Documented Universe and Reports as per the standards for support and for future references
• Created parameterized Crystal reports and customized existing reports for presentations using Cross-Tab reports, sub-reports, Running Totals, Sorting, Alerting
• Involved in tuning of SQL queries and Universes for better performance.
• Analyzed project requirements and developed specifications for products as per requirements
• Tracked the funding allocation, project status, and procurement activities to maintain timely deadlines
• Negotiated with vendors for price bid comparison

Confidential,Hyderabad, India June 2010-August 2010
Summer Project (Business Intelligence Analysis and Reporting)

• Gathered requirements, designed documents as per client’s specification efficiently served as liaison between business and IT needs
• Worked on Informatica PowerCenter tools-Source analyzer, Target Designer, Mapping Designer and Transformation developer
• Designed and developed Informatica Mapping for data load and data cleansing
• Worked extensively with Designer tools like Source Analyzer, Target Designer, Transformation Developer and Mapping Designers
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate periodic loading of Data
• Involved in designing, developing, testing and deploying Business Objects Universesfor report generation.
• Designed and developed reports usingWebIntelligence, and Desktop Intelligence

Confidential,Spring’10
Project Name: Design and Implementation of a Data Warehouse for a Retail Store

• Converted the data into text files and analyzed the data with Pivot Tables to formulate business questions
• Created Star Schemas using dimensional modeling methodology
• Implemented ETL operations using SSIS and constructed Dimension and Fact tables
• Developed a set of BI reports by implementing SSRS and SSAS

Confidential, Fall’10
Project Name: Managing a virtual company in real-time market simulation using ERPSim

• Developed an operational plan describing initial offerings and team organization
• Prepared market research report using Pivot tables to document the existing market know-how.
• Forecasted the market demand and raised production plan accordingly using modules of ERPSim
• Tracked sales and managed inventory levels in response to the market demand
• Establish pricing strategy to meet the demand and to maintain the profitability
• Created Visual Composer dashboard using SAP Netweaver using InfoCube containing market data from ERPSim

Business Database Management, Fall’09
Project Name: Design and Implementation of a Customer Database for a transport company

• Developed an Entity-Relationship schema using MS Visio
• Converted ER model into Relational Design Model up to 4th normal form
• Created tables using SQL server and written queries in SQL
• Developed user manual and documented system components, its control structure etc.

• Awarded Fred W. Dollar Scholarship in recognition of excellence academic achievements and performing job duties
• Member of Council of Info Graduate Students, Texas A&M University
• Among the top ten percentile of the Class of 2011