Project Manager Data

SHEETAL SHROFF

**** ****** ***** **. *****: 469-***-****

Plano, TX 75024 **************@*****.***

EXPERIENCE

Tech Lead/Quality Lead, Rent-A-Center, Plano, TX

• Improved quality of the developer reports and reduced the number of rejected reports by 85%

• Mentored developers so that the reports developed were as per industry standards and improved product quality by about 75%

• Architected and developed 3 financial dashboards (Product, Daily Sales, Profit and Loss) using best dashboard design practices. Data connections to the dashboards were through Excel Spreadsheets

• Provided guidance to the developers for enhanced and optimized coding and reduced number of defects by 60%

• Interfaced with Data Warehouse and PM during various stages of development and quality control

• Developed and provided test data for ensuring that the reports conformed with the business logic

• Performed quality control for new/changed reports/universes and helped migrate them to Production environment.

• Administered security settings. Monitoring system usage and performance and recommending appropriate changes

Business Intelligence Sr. Report Developer/Architect, Rent-A-Center, Plano, TX Jan 07 – Present

• Gathering reporting requirements from users and translating them into finished and working Business Object queries, reports and data universes.

• Developed reports using business objects functionalities like Queries, Slice and Dice, Drill down @Function, Formulae etc. Created various geographical and time dimension reports for Fiscal Year, Quarter, Month, week and daily reports for all Domains and published through Web Intelligence.

• Developed structured reports for various departments such as Marketing, Purchasing, Operations, HR, Internal Audit Reports with extensive usage of functions, variables, filters, conditions. Created Drill down reports, slice and dice reports, cross – tab reports.

• Created Universes, Classes, Objects, complex measure objects, Prompts, Hierarchies, Predefined conditions for the users to do Ad-hoc Reporting, slice and dice, drill down. Resolved loops by either creating Aliases or Contexts or by defining Shortcut Joins. Checked the Integrity of the Universes.

• Architected and developed a Marketing Dashboard that measures leads and contacts for different marketing channels. Provided end to end solution, starting from the Universe, to the Web Intelligence dataset layer, to the Xcelsius Dashboard.

• Converted existing reports from the old system (High touch) to Business Objects.

• Created and made modifications to JSPs/ASPs to use dynamic parameters and rendered reports online.

• Liaised with Data Warehousing team to make changes to the DW before and after generating the reports. Interfaced with various departments such as Marketing, HR, Operations, at various stages of report development. Interfaced with various retail operators for issues when the data wasn’t received.

Senior Business Analyst, Indus, Dallas, TX June 04 – Dec 06

• Created Repository, Multiple Document and Universe domains, users, user groups, universes, Classes, Objects, complex measure objects, Prompts, Predefined conditions for the users for Ad-hoc Reporting, slice and dice, drill down.

• Created various simple and complex reports mainly using business objects universes as the data providers. Created reports using Business objects functionality like Queries, Slice and Dice, Drill down, Formulae, Aggregate Awareness feature etc.

• Developed PL/SQL stored procedures to be used as data providers for few Complex reports Environment: Oracle 9i, SQL, PL SQL, and Business Objects Reporter 5.1

• Participated in the building of Data Warehouse including the design of data mart using Star schema. Created Informatica mappings to populate data into fact and dimension tables.

• Developed transformation logic & designed Complex Mappings and Mapplets such as Lookup, Aggregator, Expression, Joiner, Router, Filter and Update Strategy.

• Assisted development of streamlined logical and physical data models using ERWIN for staging, storing and propagating data. Assisted in updating the logical model with all related entities, attributes and relationship with each entities based on the business rules.

Project Manager/Senior Consultant, Aidmatrix, Dallas, TX Jan 02- June 2004

• Project Manager for Contact Management Tool. Tasks included information and requirements gathering, developing use cases, coding, implementation and testing.

• Managed the full-life cycle of the Relief Exchange project.

• Performed database maintenance and activities for all the projects.

• Created/modified complicated SQL queries for data analysis and ad-hoc decision support.

• Designed Frame Work Models Using PL/SQL stored procedures that implement the security at the data base level, resulting in the quick turn around time for the reports.

• Synchronized data from various sources such as databases, flat files, etc.

• Remotely installed, configured and administered the applications on hosted servers.

• Interfaced with the hosting provider on periodic basis for operational efficiency

• Created and modified database tables to add other food banks to the portal.

• Provided Support for Donor Express and Agency Express. Responsibilities include synchronizing data, site admin functions

Business Consultant, i2 Technologies, Dallas, TX Mar 01- Sep 01

• Member of team involved with the release for airline industry B2B marketplace.

• Served as the owner for Profile Management service for the airline Marketplace.

• Involved in the verification and validation of workflows and multi-users concurrency.

• Interfaced with i2 Partners such as PWC and CGEY to perform regression testing.

• Installed and configured WebMethods B2B server/integrator for Open Commerce Network.

Developer, Allied Informatics, Inc, Norcross, GA June 00- Feb 01

• Responsible for various database operations such as data transfer, backup, export, import.

• Created PL/SQL stored procedures, triggers, cursors etc.

• Creating control files for uploading data from flat files to SQL loader, which are populated by from web.

• Understanding and implementing business logic for State government’s procedures for different types of licenses issued, renewed, revoked etc.

• Member of project team for Medical College of Georgia, Augusta, and GA. The project involved creating forms and reports for the Pregnancy department of the medical college. About 50+ forms and reports each created for this project.

Team Lead, Guru Software Services, Atlanta, GA June 98 – June 00

• Designed and developed an ad-hoc query tool (similar to Query Builder) using PL/SQL tables and extensive use of pick-lists.

• Installed and configured software and performed the administration duties for the database.

• Performed various database administration duties for the company.

• Designed and developed three-tier architectural software for a building maintenance and repair company.

• Developed a functional dependency diagram using Oracle CASE* Method.

• Developed PL/SQL code for use with database - level modules and tool.

• Designed and generated parameter, drill-down and matrix reports along with graphically displayed data for company to track performance, revenue and costs.

• Integrated Forms, Reports and Graphical applications are for reliable and quick data access, synthesis and analysis maintaining user security and automated auditing.

• Created an HTML based web interface of the Activity tracking System. The interface allowed user authentication, entering new work orders and review of existing work orders.

EDUCATION

Graduate Certificate in Information Systems Management, University of Dallas December 2002

Masters in Economics, University of Gujarat, India Aug 93-Aug 95

Bachelors in Economics, St. Xavier’s College, India Aug 89- Aug 92

COMPUTER SKILLS

Database Skills: Oracle (11x, 10x) SQL Server, Data Design and Modeling, Stored Procedures, Triggers, Oracle Forms, Reports, Designer, Financials, Database Administration,

Data Warehousing

/Reporting: Business Objects (XI 3.1), Informatica Powercenter, Cognos (Impromptu, Powerplay, Visualizer), Reportnet, ERWIN, Data Warehousing, Mining

Languages: SQL, PL/SQL, Java (JSP, Servlets), ASP, HTML

Operating Systems: Windows, UNIX

Middleware Oracle WebLogic

Contact this candidate