Ishani Kulatilaka

acwl10@r.postjobfree.com/617-***-****

Business Systems Analyst/Data Analyst/Project manager

Fourteen years of experience in Business Analysis : Requirement Docs, Use Cases, Test Cases, Test Plans and Scope Documents, Project Plans, Risk Matrices, UAT and QA

Liaising between IT and Business Units, Gap Analysis and Project Management

Quantitative Analytics and Metrics Development. Dashboards and Report Development using OLAP tools, Business Objects

Knowledge SQL Server Reporting Services (SSRS/SSIS), SQL Query Development, Brio, Advanced Excel

Segmentation models, regression models using statistical tools

Skilled In: Software Development Life Cycle and methodologies (XP, RUP, Agile) and Project Management, SSRS (SQL Server Reporting Services), Business Objects (Infoview, Universe Designer and CMC), Rapid SQL, SQL Plus, Toad, Win SQL, Remedy, Quality Center, Doors, Base Camp, Microsoft Team Foundation Server, Rational Clear Quest and other similar project and bug tracking software, Brio (OLAP Tools), Access and Oracle Databases, Visio, Knowledge of Reporting and Analytics Packages (Business Objects, Informatica and Cognos), Microsoft Office including Advanced Excel, MS Project and Visio

Training and Certifications

Completed Certified Business Analyst Course

Fannie Mae Mortgage Industry 101

Completed IT Project Management Course (Harvard)

Business Objects- Universe Designer Certification

Informatica Developer Training

DataSage Systems Integtrator Training Certificate

Oracle 10g Database Tuning Training

SAS Data Step-Data Manipulation Certificate

Career History

Report Developer/Business Analyst, (Contract) Tropics Software – Sarasota, FL (2015)

Analyzed Workers Compensation Insurance (Property and Casualty) data and completed systems requirements to enhance existing product with new features

Developed reporting solutions using SQL Server Reporting Services (SSRS)

Created complex queries, procedures and functions to support financial and insurance calculations

Converted Crystal Reports from an older system to SSRS using Visual Studio based on minimal requirements and supervision

Deal Structuring Manager (Senior Business Data Analyst), Federal National Mortgage Association – Washington DC (2009 to 2013)

Managed Primary Mortgage Insurance data Analytics and Reporting within the Single Family Mortgage Division

Developed End User Computing Tools using Fannie Mae approved SDLC standards to record and measure Primary Mortgage Insurance data variations

Created Requirements documents, test plans and test cases using Doors, Quality Center and other tools

Regular communications with Mortgage Insurance Companies to establish a process for loan level data corrections

Participated in Internal and External Audits (SOX Controls) and Regulatory Reporting

Created metrics and reports (Internal and External facing) using Microsoft Tools for upper management and to support Quarterly and Annual Financials

Managed and coordinated a monthly production support process with the technology teams that involved system backups, issue resolution, escalation that minimized system downtime

Reporting and Analytics Developer/Analyst, Cambridge Interactive Dev Corp-Cambridge, MA (2008-2009)

Conducted JAD sessions and documented report requirements

Developed operations, financial, marketing and campaign related reports using Business Objects Infoview

Produced analytical findings as needed for the business for making tactical decisions and goal planning using Structured Query Language and Informix and Ntezza databases

Designed database Universes using the Business Objects Designer to support ad-hoc and ongoing reporting needs

Worked on creating dashboards for the EWallet project

Led internal training sessions and provided guidance and ad-hoc support to end users and team members on various technical and data quality issues

Business Analyst (contract) – Mass Health and Human Services – Boston, MA (2007)

Analyzed existing databases and reporting environments consisting of Medicaid Claims data for a large scale project (NewMMIS)

Streamlined and managed a new Enterprise wide process for reviewing, storing and validating specifications from a third party vendor

Extracted, validated and loaded data requirements onto an Access Database

Converted existing report requirements into report specifications based on a new model in Cognos/Oracle

Business Analyst/Consultant (contract), Oracle Inc. – Burlington, MA (2005 to 2006)

Analyzed “Telecommunication Billing” System data models and created sample data that accurately simulate billing data for Oracle Applications for multiple clients in the telecom industry.

Tested Analytics and Reporting components within the application based on product requirements.

Prepared Business Use Cases and Test Cases and managed application enhancements and bug fixes

Using SQL, validated and tested various data elements and table relationships, created Data Dictionaries and consulted developers on data relationships.

Worked with International clients providing consulting services, gap analysis and fit assessment workshops.

Reviewed and updated Product Requirement Documents with new use cases. Created System Flow Diagrams and Use Cases Using Visio.

Engaged in Performance, Scalability and Reliability (PSR) Testing and creating requirements docs.

Data Manager/CRM Analyst, Upromise Inc. – Needham, MA (2003 to 2005)

Managed and was responsible for the data list pull process working in a cross-functional setting managing work flow, data sets, approvals, data extractions, storage, security and delivery. The data lists are used for various Direct Mail, Email and other marketing initiatives with our partners and internal Marketing Group.

Consulted and applied strategic and analytical models for marketing campaigns.

Analyzed the effectiveness of various marketing initiatives and response rates of campaigns using SQL, SAS and excel.

Created predictive models using proprietary software for marketing campaigns.

Ensured the strategic guidelines are followed when defining, sharing, analyzing, extracting and developing data pulls for internal and external use

Analyzed retail data (Sales, Inventory, Seasonality, Price Elasticity, GMROI and other metrics) for trends and relationships using statistical data mining tools such as Statistica. Supported formal presentation of results to clients using Power-Point and other media

Business Analyst, Fidelity Investments – Boston, MA (2001 to 2002)

Helped internal clients identify and measure web traffic to their sites (Retirement, College Planning,401K etc) and drive strategic business decisions regarding web content and marketing.

Designed, created, quality inspected and automated online customer measurement reports using Brio Enterprise Software using Oracle Databases.

Created and Automated a generic report (that has been extensively utilized) that can measure customer visit frequency and segment level information for various Business Divisions within Fidelity.com. Communicated weekly online traffic trends to internal Business partners through analysis and weekly email newsletters.

Analyzed business trends and segments in the customer, prospect, trade data using Excel and Brio, presented results to Executive Management. Maintained operational reporting (daily, weekly, monthly).

Education and Professional Development

University of Massachusetts, Amherst, MA, Master of Science in Industrial Engineering and Operations Research, May 1999

GPA: 3.7/4.0

Berea College, Berea, KY, Bachelor of Arts, May 1996. Major: Mathematics, Economics Minor: Computer Science

GPA: 3.9/4.0

Harvard Extension School, Cambridge MA, Investment Theory Graduate Course Fall 2002, IT Project Management Spring 2006

Academic Honors

Deans Honor List (1992-1996) Mortar Board (National Honor Society-1994)

Fleur de Lis (Freshman Honor Society) Phi Beta Lambda (1995)

Ching-Wang Prize in Economics (April 1996) Phi Kappa Phi (National Honor Society-1994)

Vincit Qui Patitur (Junior Honor Society) Phi Mu Epsilon (National Math Honor Society-1993)

Omicron Delta Epsilon (International Honor Society in Business and Economics, 1994)

Alpha Pi Mu (National Honor Society for Industrial Engineers, 1999)

President, Student Mathematics Club, Berea College, Berea KY(1995-96)

Contact this candidate