Data Manager

Chirag D Mehta

*** ****** *** ****** **** NJ ****6 • 424-***-**** • ************@****.***

SUMMARY

10+ years’ experience in technical as well as non-technical roles, developing back end tools in VBA, PHP and leading a team; expert in Business Intelligence, Financial Reporting, Data Analysis, Data Modeling; very well acquainted with SQL, SAP BPC, Excel, Essbase and understanding databases, self starter always committed to organization; dedicated and quick learner with exceptional problem solving and decision-making capabilities. Recognized by associates and superiors for quality of work, alternative solutions and decision making; excellent analytical, inter-personal and communication skills.

Technical Skills: Cognos, Essbase, SAP BPC, XML, Java, PHP, Python, PostgreSQL, JavaScript, jQuery, AJAX, HTML5, MS CRM, Unix Shell Scripting, Regular expressions, advanced Excel (incl. VB and Macro Scripts), CSS PROFESSIONAL EXPERIENCE

American International Group (AIG), New York, NY (September 2013 – present) American International Group, Inc. – also known as AIG – is a Fortune 500 American multinational insurance corporation with more than 88 million customers in 130 countries. Senior Business Analyst, Finance Systems and Data Management - Planning

• Helped define a clear strategy to bridge business and IT stakeholders and deliver solutions to bring better efficiency and transparency to Corporate Planning

• Worked on the build-out of a highly scalable application (CART SAIL) for acquisition, consolidation and reporting of Budget, Forecast, CCAR (Stress Testing), and granular Functional Expense Management.

• Worked with different departments across the company to acquire said data from their General Ledgers and other reporting systems, train them on the use of CART SAIL, and oversaw an increase of data volume from 50k to 500M rows, and user adoption from ~100 to ~1,100 users - achieved by identifying and strategically deploying new functionalities and data structures with the most positive impact across functions and businesses

• Implemented advanced data management features, such as time-based submission locks, hierarchy-based security, change auditing, multi-dimensional mapping, currency conversion, and automatic data replication

• Worked with SAP BPC to load and manipulate data in the system, building templates and packages to make data entry convenient for business owners within the org., creating excel based macros that could pull data and metadata from the system as desired.

• Created reports, templates and Excel forms to extract from SAP BPC 10.1 as well as macros to create load files automatically to help load large amounts of data into the system.

• Developed several tools in Excel VBA that helped in automation of tasks done manually. This included building tools that were later used by offshore teams as well as end users within the company.

• Built tools in VBA to extract data from SAP BPC to create visual tree hierarchies, denormalized hierarchies, flattened hierarchies, help identify upper level changes, balance and replicate parallel hierarchies and automate changes based on changes in other systems like MDG and Workday

• Reached out and worked with finance teams from companies and entities owned by AIG to consolidate data into one system. Gathered Stress testing data for purposes of internal stress tests as well as federally regulated stress tests. Analyzed and manipulated large datasets to create reports.

• Maintained and updated various mapping sets, user security and reconciliation between different systems

• Built data verification and reconciliation queries using Essbase Excel Add-In, built queries and data extracts from an Oracle database using Cognos. Manipulated large data sets in Excel, sometimes using VBA.

• Training different business users on using several internal tools, training them on SAP BPC usage and creating reports.

Affinity Solutions, New York, NY (August 2010 – September 2013) Affinity Solutions is a marketing and loyalty company for clients such as Visa, Discover, Capital One Bank, FISERV, FIS, Sovereign Bank, BBVA, BB&T, 1-800-Flowers, Verizon, Sony and many others. Manager, Data Processing and Reporting, Operations

• Managed a team of seven employees, and assigning them tasks and monitoring their performance

• Responsible for backend process of correctly identifying credit card transactions for scoring and analytics purposes. Developed a system for increasing efficiency for identifying transactions using SQL and regular expressions, and built a web tool using PHP, AJAX and JQuery. The web tool allows a user to search for patterns and regular expressions to enable matching consumers’ card transactions on a mass scale. Several enhancements and improvements are done based on the feedback on a regular basis.

• Responsible for internal and client reports, automated, manual, scheduled as well as ad hoc, responsible for creating templates and scheduling reports for new clients.

• Created several SQL and Shell scripts to automate reports that were previously done manually. Helped the database team set up a centralized database to make manual querying as well as automated generation of reports easier and faster.

• Helping out with several analytics-based requests to get data on consumer spend by region, predicting trends in spend for a merchant, calculating success of rewards program, looking into issues arising from time to time, etc.

• Designed and built Rewards fraud report (using PHP, PostgreSQL) for Capital One Bank which creates reports based on odd patterns in consumer behavior and identifying extreme buying patterns

• Used Groupon API and Google API to build tools to gather deals and other merchant data

• Held several companywide tutorial sessions on our company’s reporting systems, MS Excel and SQL

• Redesigned internal company home page and several of the company’s backend tools in PHP, HTML EDUCATIONAL MERITS

Bachelors in Computer Science, Fairleigh Dickinson University, New Jersey Honors Student, Recipient of Colonel Fairleigh S. Dickinson Full Academic Scholarship (50 out of 1200 students) PROJECTS - Fairleigh Dickinson University, NJ

• Created a website that solves and graphs linear equations and circles

• Created a program for maintaining customer and inventory records for a local business as part of an individual class project using Java and MS Access

• Built a fan website for Halo (video game) using Adobe Flash, ActionScript, Dreamweaver and Photoshop which also included forms, XML and CSS

• Created a 2D shooting video game and a puzzle game using C++

Contact this candidate