Grace Verma

Grace Verma is an experienced Technical Project Manager PMP /Analyst with 13 years of work experience. Her current focus areas include data analytics, corporate performance management, business intelligence and data warehousing. She is PMP certified from the Project Management Institute PMI . She specializes in aligning resources and investments with overall organizational mission. She has a proven ability t effectively plan, coordinate and meet customer needs of multiple projects across various project management methodologies Waterfall / Agile . She has in-depth experience in planning, budgeting and implementing effective cost control. She als specializes in acting as a cross-functional coordinator and managing projects related t network maintenance, network design, capacity planning, and wireless network deployment/design, performance monitoring, process development/re-design, application development and vendor management. She has worked for Ericsson Managed Services, Sprint PCS, Nextel Communications and Sprint-Nextel Corporation. She holds a Master's degree in Electrical Engineering.

EXPERIENCE:

Confidential

Role: Technical Project Manager/BI Data Analyst

Managed and developed a Business Intelligence BI and Data Warehouse DW solution t enable accuracy and transparency of network budgeting, planning and forecasting BP F , allow network profitability modeling and optimization PM and provide better understanding of drivers of AT T's profitability. The initiative enabled tracking the funding, payment timelines and return on investment of 200,000 network enhancement and maintenance projects with budgets in billions of dollars. This was achieved by consolidating BP F spreadsheet and legacy reporting processes t achieve consistency in financial and operational reporting.

Responsibilities Included

• Project planning, resource allocation and client management
• Data profiling of source system OLTP application
• Provided critical business input in Data warehouse DW data model and ETL design Source t Target mapping .
• Requirement gathering and analysis, report design, business process translation int reporting logic and SQL.
• SQL logic for automated testing
• End t End report testing and troubleshooting
• Testing source t DW Mapping and ETL logic
• Testing DW t reporting
• Testing of Reporting logic
• DW defect analysis and troubleshooting
• DW enhancements based on business requirements
• Predictive modeling: Collected requirements and put together approach for a predictive solution t determine ROI for the completion of construction projects budgeted during the planning phase.

Technology Portfoli Managed

• Reporting Tool: Cognos v8.4 10.1
• Cognos Reports
• Cognos Active Reports
• Cognos Framework Manager
• Cognos Dashboard
• Cognos reports using Google Maps API.
• Database for Data warehouse: SQL Server 2005, 2008
• ETL / Data Integration: SSIS SQL Server Integration Services
• Predictive Analytics Application:
• HTML5
• Silverlight

Confidential

Role: Business/Data Analyst

• Y-Point Analytics is a Data warehousing/business intelligence based start-up. Involved in developing the go-t market strategy and analytic solutions for this company.
• Applied Wireless and Telecommunications background knowledge t assess market needs for data warehousing and business intelligence requirements.
• In-depth knowledge in the industry was used t gauge the data needs and type of application requirements t manage the data.

Confidential

11 years of service starting with Sprint PCS, Sprint Nextel After Sprint's Nextel Acquisition , Ericsson Services After Ericsson took over Sprint's network services group

Confidential

Role: Project Manager/Data Analyst

Managed multiple simultaneous projects over a course of 2 years. Project goals included Sprint's information technology transformation at a global scale creation of Sprint's in-house decision support systems for budget, inventory, procurement and site portfoli management

Responsibilities:

• Project managing a transformation project for Sprint with key focus on balancing global resources and information technology investments Build / Buy / Accessibility / Security / Retirement Strategy etc . Acted as a Cross-functional liaison by managing all stakeholders including, Business team, Citrix team, Offshore Team, Network Security, and Testing Team.
• Effectively involved in conflict resolution, client satisfaction and produced out-of-box ideas in delivering results.
• Managing and implementing a BI Reporting solution t optimize site acquisition business processes. Responsibilities included: Project Management, Requirements /Data Gathering, Stakeholder Identification, and Provide Subject Matter expertise for Site data, Site Acquisition / Planning Business Processes. Built ability t notify business executives based on control charts based on predefined dynamic thresholds
• Leading the effort in requirement gathering t implement a SaaS application used for network monitoring, maintenance and reporting.
• Conducted meetings t procure information about the network monitoring data and their sources.
• Worked with engineers t determine the key and frequently used KPIs and the metrics that will be needed on a day t day basic t effective maintain the wireless network.
• Worked with the SaaS service provider t build queries and templates for report generation, dashboard creation, alarm generation, map generation and metric display graphically and map-based .

Role: Business Analyst and Data Analyst

• Sprint is attempting t standardize their business processes, applications and decision making across all the markets. As part of this standardization effort, Sprint was building a standardized data warehouse across all the markets. Specific responsibilities included:
• Conducting research t identify key decision makers across all markets.
• Interacting with the key decision makers across all markets t understand their business goal, day t day activities, challenges and information needs. Convert these information needs int a list of attributes and metrics.
• Conducting an initial data audit t assess the feasibility of requirements.
• Interacting with Information Technology IT t get data from various data sources, which was loaded int a profiling database. Processed the data and presented t the business t verify data availability and feasibility of business requirements.
• Conducting cross market facilitated meetings t achieve consensus on meaning of attributes and formulas for metrics.
• Documenting the business requirements based on various business processes they catered to.
• Prioritize requirements based on their business impact and feasibility.
• Provided input t data modelers s that the data model is designed t meet the requirements.

Confidential

Role: Data Analyst/Project Management/Cross functional coordinator:

Acted as a cross-functional project coordinator for following projects at Sprint-Nextel. Projects included: Managing and coordinating the various functional teams involved in the iDEN frequency reallocation based on FCC guidelines Network maintenance projects which involved planning, designing implementing and testing the measures taken t improve network performance Responsibilities included:

Re-banding:

• Coordinated all projects related t Rebanding for the Northeast Region for Sprint-Nextel. The Rebanding project involves surrendering the lower 120 iDEN 800 MHz bandwidth t FCC. Project managed, coordinated and tracked all initiatives t facilitate removal of these channels from the network for each market in the Northeast region.
• Worked with the area Points of Contact, organized weekly meeting t track initiative progress, updated team on feedback from the National team. Served as a liaison between the National and Northeast Regional teams. Facilitated direction provided by the National team within the Northeast region. Analyzed and reported progress and als undertook performance analysis and reporting for parameter impacts, traffic trends and traffic forecasts.
• Produced Executive level Dashboards t report initiative progress t senior management.
• Northeast Budget planning and review, cost cutting and appropriate asset allocation exercises.

Network Performance Optimization:

• Managed the national initiative for network improvement by targeting various performance aspects Coordinated with all teams t establish completion of set targets within the given timeline and budget. Monitored and reported network impact. Socialized results with all teams involved.
• Bi-weekly Cross Function Plan t coordinate activities between cross-functional teams Put together a plan t coordinate and align all current projects in the market that involve various departments/teams. Als created Dashboard and reporting t track progress.
• Hotspot optimization Project: Reviewed the network performance and target critical groups of sites in the network as hotspots and came up with various efforts needed t improve performance of these hotspots t eventually improve network performance.

Confidential

Role: Data Analyst/Project Coordinator

Led multiple projects simultaneously, serving a wide variety of internal and external customers. Successfully maintained the operation of the network while simultaneously managing capacity enhancements and network expansion projects.

Network Design and Optimization Analytics and Implementation:

• Lead projects t design and implement expansion and fill-in cell sites.
• Collect daily network statistics and analyze using Excel and Excel macros t drive budget approvals for network enhancements.
• Search-Ring generation and definition of coverage and capacity objectives. Evaluated potential candidates through propagation prediction software. Ensured optimal cell placement based on factors relating t zoning restrictions, regulatory issues, handoff status, path balance, RF interference, coverage footprint, capacity management, and in-building coverage requirements. Provided Site Acquisition Support. Reviewed RF NEPA analysis for FCC compliance and Intermod studies. Designed the network as per the 3g1x RF Engineering Guidelines.
• Managed successful integration and optimization of new sites and carriers.
• Trained engineers on tools and techniques t identify and resolve problems.
• Worked with Network Design t implement hardware upgrades, cell rehomes, switch cutovers, etc.
• Performed cost optimization and network implementation using just in time methodology.

TECHINCAL HIGHLIGHTS:

• Project Management and Other Tools: Microsoft Project / Project Server, SharePoint, CA Clarity PPM, Salesforce.com
• BI Reporting / Analysis: Cognos, .NET / VB Dashboards, Access-Excel-IIS
• Database: Oracle 10g/9i/8i, SQL Server 2000, 2005, 2008, MS-Access.
• Software Development Tools: ASP.NET, VB / Visual Studio, PL/SQL, Unix Shell Scripts, PHP, C, C , MATLAB
• Productivity Tools: Strong Excel skills, MS Project / Project Server, Visio, Front Page, SharePoint, Macromedia Dreamweaver
• Data Integration ETL / Extraction: Oracle SQL, Microsoft SQL, Conceptual Data Flow.
• Geo-Spatial Tools: MapInf Mapping tool , PlaNET Prediction tool by Mentum , Wizard Prediction Tool , Xceed Wincatcher Drive data collection and post processing tool