Data Analyst

SUMMARY: Enthusiastic, detail-oriented, resourceful professional seeking to secure a role as a

Senior Data Analyst at a leading premier company
SKILLS:
 First-rate knowledge of the SDLC via waterfall and agile scrum (requirements analysis; workflow
analysis; business process analysis; creating wireframes, current vs. future state identification)
 Advanced knowledge of MS Excel (lookup & reference functions, math functions, text functions,
PivotTables / PivotCharts, conditional statements, conditional filters, macros, etc.)
 Proficient in MS Word / PowerPoint / Visio / Project / SharePoint; Bloomberg; Reuters; UML
 Programming Languages: C, C++, SQL, Intel Assembly, Pascal, HTML, XML (web services)
 Databases: Microsoft Access, Microsoft SQL Server, DB2
 Software applications: Cognos, SAP, Oracle, Lawson, Business Objects, Hyperion Essbase, UNIX (shell
scripting), Visual Studio .NET, Snagit, JIRA, HP Application Lifecycle Management (HPALM),
Shadowsuite, TortoiseSVN, GoSystem Audit, RIA Checkpoint, QuickBooks, EROS & Adobe Acrobat
 Fast learner with superior quantitative, research, analytical, organizational and proofreading skills
 Deadline-driven team player with first-rate verbal, written and interpersonal communication skills
 Fluent in Russian – speaking, reading and writing

EXPERIENCE:

AIG – Marketing Intelligence and Management Consulting Jersey City, NJ

Senior Data Analyst (contract) 08/13 – present
 Implementing and enhancing a new Agency Data & Analytics Tool (ADAT) for global business
intelligence use in the Consumer insurance domain by financial and sales teams
 Gathering requirements from various business stakeholders via user interviews, workshops and e-mail
surveys and developing mockups and wireframes in order to enhance corporate systems including ADAT,
EMIS and SMART used by C-level global executives
 Writing test plans in HPALM and performing QA and UAT testing on requirements and enhancements
for Consumer Lines while meeting tight release deadlines
 Assisting worldwide users with adhoc and analytical reports using ADAT data
 Analyzing, validating and improving domestic and international Consumer Lines data via reconciliations
of premium, losses and commissions against FGEN Genesis, CRUIS & other financial reporting systems
 Collaborating and advising a team of offsite developers on a daily basis on current requirements and
assisting them in efficient resolution of defects
 Providing training demos and creating executive dashboards, release notes and training manuals

Thomson Reuters – Financial & Risk New York, NY

Data Analyst 11/11 – 08/13
 Gathered requirements and resolved defects found in the master data of TR's flagship desktop product:
Eikon, a leading global rival to Bloomberg for real-time & historical market data
 Assisted Global Head of Product Management with Metadata (XML output), contextual Navigation,
Guides and Search & directly coordinated the release cycle with Operations
 Collaborated with financial product SMEs in Equities, Options, Fixed Income, Commodities and FX in
order to execute business requirements dealing with market and reference data
 Performed data quality analysis in a content management system via queries in MS SQL Server
 Used JIRA to log progress on requirements, enhancements & defects in the capital markets arena
 Prioritized issues reported by the clients to be resolved first in weekly scrum meetings during each sprint
and kept clients up-to-date with frequent status updates via an agile methodology
 Communicated globally with various stakeholders (development teams, localization teams, etc.) based in
England, France, Thailand, India, Japan, China, Moldova, Switzerland and Argentina
J.P. Morgan Chase – IB F&BM Infrastructure New York, NY
Data Analyst (contract) 04/11 – 11/11
 Gathered business requirements, created BRDs, collaborated with software engineers to produce FRD
documents, designed test plans / test cases, performed testing and tracked defects for each testing cycle
via a waterfall model in order to go live with the new systems on schedule
 Performed financial data analysis such as end-to-end data mapping on two major capital markets projects
feeding data to a more robust financial data warehouse system that allowed for the automated calculation
of liquidity premium charges for the Financial Controller’s Group on foreign loans & unfunded
commitments
 Reported metrics to management via Excel PivotTable analysis on a daily basis on all action items, issues
/ risks and training course enrollment for multiple projects
 Updated a trainee master data list for daily registrations, attendance and headcount analysis for training
courses related to Investment Banking Finance & Business Management
 Served as the central help desk person on Cognos 8.4 for the Daily Revenue Reporting project
 Created training documentation and job aids for various systems including Cognos and Paragon
 Successfully completed numerous training classes: Daily Revenue Reporting and Workbench File
Submission via Cognos TM1; Paragon Reporting via Cognos TM1; Hyperion Essbase Basics; MIS Cubes
Overview; FDW Overview; Business Objects

AIG (Chartis International) – Finance Application Solutions New York, NY

Data Analyst (contract) 03/10 – 04/11
 Tested and error-checked a new reporting system developed in “IBM COGNOs 8 Business Intelligence”
and reported the issues to a project manager, business analysts and developers
 Reconciled and validated data for the FX Impact project in order to convert reporting from a mainframe
system to the COGNOs platform
 Executed legal restructuring implementations for each Chartis reporting office as per user deadlines via
completion of manual test cases on various insurance reporting systems including CMR, Genesis suite,
CRUIS, Cognos, etc.
 Extensively utilized Excel PivotTables and dynamic search functions (vlookup, index and match) on
various ad hoc assignments
 Wrote a user guide for IBM Cognos v8.4.1 designed for distribution to new staff at Chartis
 Built and ran IBM COGNOs reports based on defined selection criteria for a team of 8 testers and
managed report distribution so all testers have adequate workflow
 Assisted project managers and business analysts with production support as well as presentation
deliverables for user signoff under tight deadlines

EMI Music North America – Domestic Royalties Jersey City, NJ

Data Analyst (contract) 01/10 – 03/10
 Directly assisted Director of Royalty Accounting daily with various ad hoc projects to ensure smooth
operation of each accounting cycle and timely distribution of royalty statements
 Made necessary accounting adjustments in Lawson G/L to ensure artists and their producers received
royalties according to their legal contracts
 Interacted daily with management, lawyers and vendors regarding royalty reporting concerns
 Resolved inquiries using an artist royalty system (ARS) to retrieve and update client data
 Maintained logs of royalty statements and checks mailed out in MS Excel

Sony Music Entertainment – Domestic Royalties Lyndhurst, NJ

Data Analyst (contract) 10/09 – 12/09
 Researched and corrected accounting discrepancies in SAP related to domestic royalty activity and
payment for a variety of artists and their producers
 Analyzed royalty computations to verify adherence to contractual legal terms and agreements
 Cleared sales accruals for music products and removed pending royalties from artists' accounts on a daily
basis in EROS (royalties reporting system)
 Investigated into legal contracts in order to link new releases into artist / producer accounts
 Utilized advanced MS Excel features (pivot tables, vlookups, functions, etc.), MS Access and SAP
(royalty accounting G/L) to retrieve needed data
  Interacted daily with management regarding royalty reporting concerns

U.S. Bancorp Fund Service (AIS Fund Administration) Hackensack, NJ

Staff Accountant / Fund Administrator 08/08 – 10/09
 Reconciled cash balances, daily trades and investment positions (equities, options, fixed income, swaps,
FXs, etc.) to external third parties (banks, prime brokers, counterparties)
 Resolved trade breaks and other differences via direct contact with clients and prime brokers
 Entered trades and journal entries into a portfolio accounting system – Shadowsuite
 Used Bloomberg daily to confirm client pricing on market data after pricing checks and to set up new
securities in the accounting system
 Produced precise daily end of day financial reports and daily NAV calculations
 Completed timely month end work and fulfilled audit requests in an expedient manner

Rothstein, Kass, & Company, P.C. – Financial Services Roseland, NJ

Staff Accountant / Auditor 10/07 – 05/08
 Public accounting experience in auditing domestic and offshore multi-billion dollar hedge funds, master
feeder funds and fund of funds
 Conducted interim testing procedures and completed year-end audits of financial statements in
compliance with US GAAP including proofing them before sending out to the clients
 Prepared and analyzed trial balances and worked with the client's G/L (Oracle Financials) to prepare
various reconciliation schedules
 Ensured completion of all workpapers, administrative checklists and audit programs
 Prepared and reconciled investor allocations to those produced by the client
 Created and sent out capital confirmations to investors and other confirmations to banks, brokers,
administrators, attorneys and other relevant entities
 Directly corresponded with fund managers, investor relations and fund administrators

Narod’s Web Design Hillsborough, NJ

Web Developer / Design Consultant 06/03 – 09/07
 Developed, designed and marketed a variety of websites for various small and medium-sized businesses
as well as non-profit organizations
 Analyzed web analytics and made strategic decisions to increase site traffic for many clients
 Worked directly with Senior Web Designer to propose and implement process improvements
 Set up CGI scripts (site traffic reporting, ad rotation, etc.) and implemented e-commerce technology
(shopping carts, e-billing) based on clients’ needs
 Brought in new clients based on recommendations from previous clients

EDUCATION AND AWARDS:

Ramapo College of New Jersey Mahwah, NJ

B.S. in Accounting – May 2007 (150 credits)

Note: My 5 years in undergrad studies consisted of a heavy emphasis on both Computer Science and Accounting /
Finance course work.

 Ramapo College Dean's List, Academic Excellence, Fall 2005

 Industry Champion for GLO-BUS – Strategic Management Online Simulation, Spring 2007
 Certificate of Excellence in Business Ethics – Spring 2006
 President’s Award for Educational Excellence – 1995, 1998, and 2002

References Available Upon Request