Quality Assurance Data

*** ****** **, ********, ** *****

* * * * * * * * 4 4 *****.*********@*****.***

POOJA CHANDIWAL

W ORK EXPERIENCE

July 2011 – Present

Brookfield Office Properties Junior Application Developer

Saved 110,000 USD by generating reports for the Legal Department which enables them to view and analyze Tenant Information

from multiple systems.

Reduced by 2 Weeks the time and manual effort required to generate quarterly financial reports using Cube and SSRS.

Reduced by 80% the manual effort involved in generating Monthly/Quarterly reports using Crystal Reports.

Reduced by 30% the execution time of SSRS reports by using CTE, views and stored procedures.

Enabled generation of customized financial reports for internal Auditing using SSRS and Crystal Reports.

Improved integrity of the Lease CRM data by generating an Exception Report that validates entered data.

Empowered business users by providing self-service reports created using QlikView to provide financial information from CTI.

Provided insight into cash flow and financial commitments by creating more than 16 SSRS reports for the purchase-to-pay (P2P)

portal based on data from the P2P application designed by Basware.

Increased visibility and ability to track client priorities and cost by creating a new SharePoint website to manage reporting tasks

Enabled quarterly application entitlement audits by creating SSIS packages to retrieve data from 3 different data sources

Reduced risk of project slippage by setting expectations and flagging risks during bi -weekly meetings with Department leadership

Reduced time required to set up P2P structure for newly acquired properties by writing Design Documentation for existing P2P.

Demonstrated commitment by consistently delivering on time and with quality stretching when necessary to meet deadlines

Mentored two new members of the team to ensure that they are brought up to speed with the technology and standards of the firm

Reduced manual work involved in running and comparing reports run on two data sets by consolidating using Data Warehouse

Enabled BAM (Brookfield Asset Management) to validate CRM data by delivering several ad-hoc executive reports utilizing

SQL and various functions and formulas within Excel.

Resolved bugs with a very less turnaround time by working with the Quality Assurance Team

February 2011 – June 2011

Brookfield Office Properties Intern, Application Engineering &BI

Improved User experience by enhancing the Vendor Management System (VMS) using ASP.Net.

Improved tracking of new vendors in VMS by creating a report using SSRS and providing daily e -mail updates to subscribers

Helped FSC (Financial Service Center) to analyze vendors and their records on a daily basis by working on Crystal Reports

Reduced manual work involved in consolidating leasing and financial data by maintaining a data warehouse that gathers data

from systems like CTI, Hyperion and Lease CRM and generated various Crystal and SSRS Reports.

July 2010 – February 2011

Brookfield Office Properties Application Development Intern

Improved user experience by developing a report using SSRS that allows users to view property deals and scenario details.

Enhanced user ability to keep a track of transactions with the company by creating a check approval report using SSRS.

Generated a report using SSRS that allows users to view lease information for properties rented to them.

Increased maintainability by writing technical documentation for all the reports.

Understood requirements and deployed quality reports in a short time, by working with a global team of SQL experts.

Ensured quality of reports by using Microsoft CRM to analyze reports and validate them against requirements.

Improved auditability by using SSRS to generate a report to understand date differences between leases for global cl ients.

E DUCATION

Aug 2008 - May 2010 New Jersey Institute of Technology Master of Science in Electrical Engineering

June 2003 - June 2007 W.I.E.C.T Bachelor of Engineering in Instrumentation Engineering

S KILLS

Operating Systems: Windows 98, 2000, XP, 7 Wireless: FDMA, CDMA, TDMA, OFDM, GSM, UMTS

Applications: MS Word, MS Excel, MS Power Point, MS Visio Protocols: ARP, DNS, IPv4, IPv6

Languages: C, C++, JAVA, PHP, T-SQL, PL/SQL, HTML Networking: LAN/WAN, TCP/IP, Routers, Switches,

MDX, JavaScript, CSS OPNET, Wireshark, MatLab

Technologies: SSRS, SSIS, SSAS, ETL, DataWarehousing, XML, Soft Skills: Client Management, Project Estimation,

Business Objects,Cognos,PowerPivot, SharePoint, Project Planning, Business Analysis, SOW,

CTI, Propidex, Serengeti TrackerTM, Cube, Mentoring, Dashboard designing

QlikView, Lease CRM, Great Plains Software

P ROJECTS

Planetary Space Probe: (NJIT, 2010)

Designed a probe to perform Data collection in autonomous mode once deployed into orbit around a planet .

Design included magnetometer, sun sensors, spectrometer, camera, antenna etc. to collect data about the planet’s surface.

Online Chat Application: (2010)

Implemented a chat server and client in Java using TCP Sockets.

Allows users to chat online using the chat client UI which is similar to conventional chat windows.

Used Eclipse IDE for Java, Microsoft Expression Web for the HTM L

Online Library Management System: (2009)

Allows users to view, search, borrow and return books online. Provides a separate login for Administrator privileges.

Used PHP and Oracle DB. Used Eclipse IDE for PHP.

Sudoku: (Seed InfoTech, 2008)

Created Sudoku game Applet allowing users to play Sudoku using an intuitive User interface

The code was written using core Java.

E-Banking: (Seed InfoTech, 2008)

Implemented an e-banking application which involved account handling, transaction details of customers.

It was in Java and made extensive use of the Swing libr ary.

Domain Name System and Security Issues: (NJIT, 2008)

Established the mapping of name to address and vice-versa in Domain Name System.

Elucidated various concepts including Domain Name Space, Distribution of Name Space, and Resolution Mechanism.

Focused on the security issues related to DNS concerned with cache poisoning, denial of service, information leakage.

T RAINING

2 day QlikView training (Brookfield Office Properties, 2012)

Data Warehouse Planning and Design and Cube Design (Brookfield Office Properties, 2012)

MDX Basics and Calculations (Brookfield Office Properties, 2012)

Adding KPIs, Actions and Perspectives (Brookfield Office Properties, 2012)

Introduction to PowerPivot (Brookfield Office Properties, 2012)

4 day Business Intelligence training that covered Navigating Data Warehouse, using Cognos Connection to run reports, Query

Studio to create basic reports and Report Studio to create more advanced reports (Brookfield Office Properties, 2011)

8 week core Java training (Seed Infotech, 2008)

P APER PRESENTATIONS

Presented a paper on Bluetooth which is a new technology standard that uses short range radio links intended to replace cable for

connecting electronic devices. (NJIT, 2009)

Presented a critique paper on Net Neutrality which states that data packets on the Internet should be moved impartially, without

regard to content, destination or source. (NJIT, 2009)

Contact this candidate