Reshma Ambore
Email: *************@*******.*** Phone: 703-***-**** (Home)
Summary
A Highly energetic professional with over 10 years of experience in Data Analysis, Business Intelligence, Marketing Analysis & Project
Management. Excel at interacting with multiple cross-functional teams in managing multiple projects from initiation to completion.
Motivated self-starter performs well under pressure and thrives in fast paced environments.
Professional Experience
Verisign Inc. 2008 - Present
Data Management Analyst
Lead Data Management/Project Analyst for building reporting processes and creating operational reports which are used by internal and
external stakeholders.
• Work independently with minimal supervision to implement successful reporting and processes in Operations Department
• Train and lead other team members to promote team work as well as provide leadership skills and mentoring
• Data mining, data modeling, data quality, data integrity and data approval process for reports and business process
• Utilizing Big Data tools such as Hadoop / Hive to extract data for advance analysis and highlight trends
• Working with Management and Business Owners to gather requirements for developing structured reports for Product, SLA,
OLA Performance, Operational management reports and dashboards using various Business Intelligence tools
• Acting as a liaison and collaborate with multiple departments such as Customer Service, Engineering, Business, PMO and
Operations groups in developing and automation of Operations reports
• Responsible for creating project release tracking, incidents management, change management & problem management metric
• Subject matter expert for producing SLA performance reports and KPI metrics using reporting tools, Excel and SQL
• Creating ad-hoc reports, performance metrics, and trends and presenting it to senior management for performance
improvements and process development
• Working closely with PMO to implement Agile processes and generate PMO metrics to support Project Management
• Building Power Point presentation decks to support AHM, MOR, QOR, etc. used by Executive Level Management
Sallie Mae, Inc. 2007- 2008
Database Marketing Analyst
Implemented Business Objects XI R2 reporting environment at Sallie Mae’s marketing department. Played a key role in building reports
and analyzing marketing data used for financial information, campaigns, loan products, school/university, and marketing responses.
• Created weekly, monthly, quarterly and trends reports for diverse audience in marketing including the senior management
• Marketing channel reports which include Email, Direct mail and telemarketing
• Produced different types of reporting such as financial, campaigns response, inventory and runoff reports
• Analyzed marketing data such as customer information, call patterns, and demographics to better target customers and prospects
for financial growth
• Worked on PL/SQL to extract data from the Oracle database
• Manage data integrity and data quality for the data used in the reporting projects
• Gathering user requirements and converting user requirements into functional requirement for implementation
• Using Business Objects Web Intelligence, Desktop Intelligence, MS Excel and MS Access to design,develop and analyze
various reports for the marketing department
• Providing training and support to Business Objects users for better understanding and performance of the application
•
Guident Technologies, Inc., Herndon, Virginia 2006 – 2007
Business Intelligence Consultant General Services Administration (GSA)
Analyzed, designed and developed reports using Business Objects XI R2 to replace the existing reporting system at GSA.
• Gathered user requirements, business requirements and functional requirement for the development
• Used Business Objects XI R2 Web Intelligence to design and develop various reports to capture data in a clear and concise
manner that will replace the old reporting system currently being used
• Analyzed the SQR code and created documentation for analysis be which will used by higher management and developers in
Universe design and report development
• Enhanced reports using Drill-down, conditions, sorting, etc.
• Designed Universe to extract data from the Oracle database using SQL
• Worked on creating reporting standards documentation for all the reports created by Guident at GSA
• Executed system test script and modification of the reports based on the test results
• Created and delivered weekly status reports to senior management and team members
• Created Report Requirements Document and System Design Documents
Business Analyst/Developer United States Environmental Protection Agency (EPA-OSDBU)
Office of Small and Disadvantaged Business Utilization (OSDBU) is a part of EPA. Working in a team of three members to design and
configure Work Request Tracking System using Serena Team Track which will help OSDBU to track their day to day activities.
• Gathered user requirements by talking to the end users and convert them into business requirements
• Developed several prototype versions to demonstrate tool to clients
• Configured Team Track application according to the specifications mentioned in the business requirements
• Worked on Oracle database for the configuration of the application to store data
• Administrated on creating all the various request forms, users, groups, attachments, reports and workflows
• Ran test scrip and made sure the application is working accordingly
• Provided bi-weekly status reports to the higher management and to OSDBU management staff
• Designed and developed several management and staff level reports from TeamTrack
• Worked on Business Requirement, System Design and Technical Requirement documents
Office Team 2004 – 2005
Computer Engineer Titan Corporation, Reston, Virginia
• Created an Excel database to maintain an account of all the Laptops which were government furnished computer equipment
• Maintained and updated the database to track all the government furnished computer equipment
• Created images on the network and used them to image the computer laptops
• Troubleshoot and maintain laptop computers and computer equipment
• Analyzed, identified and repaired laptop computers and computer equipment
• Ordered and replaced damaged items in a laptop computer
Property Administrator Titan Corporation, Reston, Virginia
• Assisted with property control activities to ensure continual accountability of government furnished property and company
property
• Maintained property accountability records in database and determined their conditions.
• Maintained preferred vendor list and performed vendor setups
• Assist with file management, and other administrative duties
DeVry University, Arlington, VA 22202 2003 – 2004
IT Help Desk Technician
• Help Students, faculty, and staff members with their account and email problems, and technical questions
• Hardware and software maintenance of computers on campus
• Provide technical support for special events that take place on campus
Academic Receptionist
• Responsible for data entry of confidential student information in DeVry’s AS/400 database
• Assist with filing, answering phones, and other administrative duties
• Providing outstanding Customer Service to students and visitors
Tutor
• Assisted students with problem solving in mathematics, statistics, electronic AC/DC circuits,
C/C++ programming language, assembly language programming and lab work
Technical/Management Skills
• OLAP Tools: Tableau, Business Objects XI R2, Oracle Business Intelligence (OBIEE), BI Publisher, Hyperion, Crystal Reports,
Splunk, NetCool,
• Programming Languages and Environments: MS Access, SQL, PL/SQL, Visual Studio.Net, C/C++, Hadoop, Hive/Hue
• Operating Systems: MS Windows XP, 2000, 2003,2007
• Database Management: MS SQL Server 2000 and 2005, Oracle 9i/10g
• Windows Application: Word, Excel, Power Point, Access, Visio, MS Project Management, SharePoint
• Software Tools: Serena Team Track, Service Now, Remedy, Jira, Salesforce
Education
• DeVry University, Arlington, Virginia. GPA – 3.94 Dean’s List
Bachelor of Science in Electronics Engineering Technology
Training
• Oracle Business Intelligence Enterprise(OBIEE), BI Publisher, Business Objects (Web Intelligence Report Design XI R2), Crystal
Reports, Project Management, SharePoint, Splunk, Hadoop and Hive/Hue