SHUCHIKA “DIA” GUPTA

Address- **** Agnew Rd, Santa Clara, CA, 95054

Email – acbkqn@r.postjobfree.com

PROFESSIONAL SUMMARY

• Self-Motivated and Goal Oriented individual with 10 years of experience as IT Project Manager, and 6+ years of

experience with E-commerce, Service Provider, Small Business and Enterprise Organization. Strong liaison between

development team and business owners because of technical and business background

• Certified Project Manager (PMP) with thorough understanding of project management methodologies, Software

Development Life Cycle, and experience working with Waterfall as well Agile (Scrum) development teams

• Project Management experience with - Application Development Team/Front end, which involved working with

designers on Photoshop templates/wireframes and with UI developers on building a new e-commerce website;

with Database Development Team/Back End, which involved working with Back end developers on creating

new database, and adding new data items to existing database, and with Mobile Development, which involved

creating mobile mockups, building new mobile app, and connecting the mobile app with ERP / PHP

• Vast experience consisting of working with offshore teams, product launch worth $2Million, consolidation of

operations, which led to more than $100K savings; migration to new architecture, automation of the database

build process, which saved server space from 23 Terabyte to .5 Terabyte; and developer hours by 50%, and

experience working with CRM applications such as Sales Force, Campaign management solutions such as

Email Campaign, Direct Mail Campaign and Phone Campaign, and Payment Gateways

• Introduced Sharepoint for Project Management in the company, and Organized data assets by creating standard

templates, and by creating Division Wikipedia, and Division SharePoint to place those standard documents

• Maintained project ownership from start to finish and delivered medium to large projects on time, under budget

and within scope, in a rapidly changing environment; Maintained Project Portfolio in line with the business

vision and excelled in giving presentations and providing timely reports of that portfolio to Stakeholders

• Well Versed in analyzing business needs, interviewing clients to gather requirements, create Business Proposals,

Project Estimates, Project Scope, task level Project Plan, Change Management Plan

• Evaluated the project success based on project revenue vs. the time /machine cost invested on that project (which

was calculated by enforcing employees to submit task level timesheets via Excel and Tenrox

• Monitored diverse project teams by understanding the culture of different locations, determining effective

communication medium and by creating a process that streamlined the flow of information across different teams

• SKILLS – Process and detail oriented, highly organized, effectively manages stress, not resistant to change, and

have strong negotiation, interpersonal, customer facing, and multi-tasking skills

• TOOLS / TECHNOLOGIES – Microsoft Visual Studio - TFS, MS Project, Asana, Collab, Sharepoint, Wiki,

Microsoft Office, Excel, Power Point, Visio, Trello, Tenrox, SQL, XML, HTML, CSS, C, C++, C#, VB, Dot Net

• Have dedication and desire to MAKE A DIFFERENCE, and ADD VALUE to the company

EXPERIENCE

Project/Program Manager 2013 – Current

InfoGroup (Application Development Division)

• Built product backlog and prioritized projects in alignment with the strategic goals of the company

• Had Daily Stand up meeting to make sure the project is on track and proactively anticipated and escalated the issues

which could impact the project deadline

• Created Release Plans for deployment, scheduled pre-deployment call to ensure responsibilities, led the

deployment calls and used Trello, so that everyone can get visual on items deployed and tested

• Optimized Resource planning by determining dependencies and critical paths, and by defining processes for hand-off of

tasks from 1 team to another.

• Acted as a champion for changes in case of technology change /work environment change and showed impacted

individuals how can they benefit from the change. Such as led the initiative to migrate from SQL to XML

• Created /Monitored test plans to ensure that the requirements are tested thoroughly

• Led the development of an Automated QA tool and trained the team

members to use the new tool. This tool ran auto testing scripts after each database build, and hence it reduced analyst

testing time by 40%. It also had a front interface, which enabled analysts to run queries, which were converted into

complex XML queries on back end.

Program Manager 2012 - 2013

Sun Arc Technologies

• Program Manager for Microsoft, PHP, Mobile and ERP divisions with experience of working with offshore clients at

Singapore, India and US

• Improved communication with clients by using project management tool Asana, by frequent follow ups, by project

demos to ensure that we were running on the right page, and by asking questions to understand the requirements

• Maintained Project inventory and Collaborated with team leads and team members of development team, designer

team and testing team to make sure that the project tasks flow smoothly across all teams

• Ensured that each team member has appropriate system access, training, tools, and protocol documentation in order to

perform their applicable function

• Maintained timesheets for all employees with estimated hours and actual hours spent on each project task, which helped

in better resource allocation, and resource evaluation

• Delivered timesheets to the clients for their respective projects at the end of each month, to ensure proper billing for

each project, and to avoid surprises when they see timesheet after project completion

• Created Client Agreements for clients at the starting of each project, to set the project start date, define the maintenance

period, and change management process

• Submitted prototypes and estimations for Prospect projects after understanding the business need

• Monitored development of various E-commerce and CMS websites using Drupal, Joomla, and

Wordpress

• Standardized documentation by creating templates for - Scope Statement, Project Plan, User Manual, Test cases,

Design templates, and Issue Log; and enforced team members to use it

• Created a matrix which captured all the projects with their technology details, such as –front end and back end

technology of that project, version, coding directory, server details, and database details

Project Manager 2008 – 2012

InfoGroup (Data Delivery Division)

• Scheduled, Coordinated and Prioritized Multi-Phase Projects involving Cross Functional teams

• Defined Roles according to team member’s strength, encouraged independence, discussed possible resolutions, and

motivated them to move in the right direction

• Was able to MEET Deadlines in most projects, by setting timeframes after discussing the project

with the team, by adding a project buffer to account for uncertainties, and by following up on project tasks, issues, and

queries

• Enforced proper closing of the project, by getting a sign off on deliverables from the key stakeholders, by documenting

the re-usable features/ modules of each project and by defining post implementation support

• Monitored development /maintenance of B2B and B2C Databases, and led projects for Database Optimization

and Data –Product Integration

• Monitored the management of project related issues & risks and engaged for resolution

• Performed a Cost-Benefit Analysis for Project Justification and Project Selection

• Developed Quality Checklist and followed it throughout the project, along with Risk analysis and

documentation of project Constrains and Assumptions to avoid last minute surprises

• Acted as a middle man between Data Acquisition team (who would gather data) and Product team (who would

access the database) after it’s deployment from our division

KEY PROJECTS:

• Led the project to support a new product launch from back end. This product

accounts for more than $2 Million in revenue. We built a process for the user to submit their client file, and then we

matched it against our database, and delivered a custom database to the client with prospect contacts, and additional data

for their existing contacts. In order to achieve this, we standardized the input file format, created match and append

services to compare customer file, with InfoGroup database, and created a standard output file which would be displayed

on the website for the user

• Managed development of an Automated Database Build Tool, which was

the 2nd phase of the above project. We created a standard drive to store the customer files, and we linked that drive with an

automated tool, which auto built those customer files. This reduced development/ maintenance hours by 50%; and it

replaced recurring developer hours with recurring analyst hours, as analysts could then run the process via this tool

• Led the project to migrate to new architecture – it saved server space from

23 Terabyte to .5 Terabyte, as on new architecture, 50 customers shared 1 copy of a 220 Million record database, where

as the old architecture had separate copy (i.e. 50 copies) of that 220 Million record database. It also reduced recurring build

time, as that 220 Million record base database was just built 1 time

• Led the project to Consolidate Email Operations performed by 2 divisions,

in order to remove duplication in efforts and increase efficiency. It led to vendor consolidation- 5 email vendors had

redundant contracts with both divisions. This project led to creation of 1 corporate agreement, leading to more than

$100,000 savings. It also led to database Build Consolidation as both divisions were cleansing emails (via email hygiene

processing), and building email database every month. With this project database build was transitioned to 1 division,

which reduced significant processing hours, and created a centralized database.

• Project Management via Sharepoint - Created a new process to gather project requirements, assign resources and

monitor Project Status of various Projects using SharePoint. It became a central repository of all projects and it enabled

team members and executives to view a quick status of all projects in pipeline and to view a list of all projects completed in

a quarter.

Database Analyst 2007 – 2008

InfoGroup (Data Delivery Division)

• Demonstrated attention to detail by analyzing input data, hosting it on servers, and building search capabilities

and functionalities around that data for web applications

• Wrote test cases and performed QA on various in-house databases using SQL queries

• Maintained Data Dictionaries of databases documenting metadata definitions/business rules for data elements;

and maintained Database Count Reports after each deployment, that showed trend on count fluctuations

• Built customized views of data and functionalities for Web Products, Full Files and Core Services

• Answered any data questions, and/or provided support from a data knowledge perspective

• Performed new data integration activity and communicated availability of new data to web products

• Excelled in client service skills and handled multiple customer files / projects at the same time

• Created Data Usage document to track usage of data by different products, which led to better control of data

KEY PROJECTS:

• Led the development of a New Database, which entailed details on occupation of 16 Million

consumers. This database had a direct impact on Company’s revenue. It involved - gathering requirements from various

divisions, providing specifications to the development team, creation of testing scripts to test if the database worked as per

expectation, communication of the completion of this project to impacted divisions and creation of a recurring process to

the build and test the database every month.

• Created Issue Tracking Form on Microsoft Outlook, which was used by Product Support team to

submit issues. This form enforced Product Support team to give details of the issue – such as Database, Application,

Environment, Session Id, Steps to replicate the issue. Time spent on Product Support issues went down by 8% after using

this tool

• Migrated from Shared Network Drive to SharePoint, which led to sharing the data assets with

other divisions. This migration was followed by other divisions’ company wide, so it changed the company culture

Project Manager 2005-2006

Bikaner Public School

• Managed resources through effective resource planning

• Allocated and budgeted funds

• Increased the number of student enrollments in 1 year by 5%.

• Led the initiative to start library and book store divisions for the school

Part Time Faculty 2004-2005

Computer Education Dot Com

• Taught C, C++, Visual Basic, and Database Structure courses to Engineering students

• Mentored students with running software programs in these computer languages

• Developed public speaking capabilities

• Excelled in communicating in the format best perceived by different people

EDUCATION

Master’s - Business Administration (MBA) 2006-2007

University of Nebraska at Omaha, US

GPA- 3.7/4.0

Bachelors - Software Engineering 2001-2005

Rajasthan University

PMP (Project Management Professional) Certified 2012

Contact this candidate