Data Project

Matheesha Anuradha Thambeliyagodage

Contact: 646-***-****

Email: *********@*****.***

Summary:

** ***** ** ********** ** Information, Data Modelling and Architecture, design and development of EDWs, DWs,DBs, DMs, MDM, BI applications including over 12 years of working experience in top American/Canadian financial, marketing, telecommunication, health care, procurement, supply chain companies;

Strengths

Data Modelling and Architecture, Business Analysis, Data Analysis, DB Development, Business Intelligence and Reporting, Statistical analysis

Strong Experience in front-end, middleware and backend applications

Software Application Analysis Design and Development

Industrial application background in Banks, Financial Organizations, Telecommunication, Production, Marketing and Sales Companies, Training Colleges, Healthcare, Procurement.

19+ years of experience in IT

4+ years of experience as trainer in IT, mathematics and statistics

Computer Skills:

Databases

Languages

Other

ORACLE

5 yrs.

Visual Basic

6 yrs.

Data Modelling and Architecture, OLAP, OLTP

11+ yrs.

SQL Server

14 yrs.

Progress(4GL-GUI)

4 yrs.

Data Administration

10 yrs.

MY SQL

2 yrs.

C, C++, Java

2 yrs.

Data Marts

10 yrs.

Ms Access

16 yrs.

C#. NET ASP.NET

4 yrs.

BI & MIS Reporting

10 yrs.

Pervesive SQL

1 yr

HTML, DHTML,CSS

4 yrs.

Statistical analysis

5 yrs.

Progress DBMS

4 yrs.

Java Scripts, JSP

2 yrs

Data Warehousing & ETL

10 yrs.

MDX Queries

3 yrs.

VB Script

4 yrs

Business Analysis

10 Yrs

Tools

XML (XSL,XSD,DTD)

6 months

SDLC

16 yrs

Erwin (7.2,9.0)

4+ yrs.

Excel / Access VBA Macro Programming

15 Yrs.

Application Development & Programming

19 Yrs.

Informatica(8.1,9)

2 yr

Cognos(7, 8, 10)

1 yr

Crystal Reports

7+ yrs.

PMLC

6 yrs

VSS / MKS

5 Yrs.

VB.Net

4 yrs.

Agile / Waterfall

3+ yrs.

MS Office

18 yrs.

ADO,DAO,ODBC

14 yrs.

BigData (Cassandra)

yr.

Business Objects

2 yrs

COBOL

1 yr

3NF

13 Yrs.

Visio

5 yrs.

Operating Systems

PeopleSoft

1 yr.

Share Point

5 yrs.

Windows/DOS

17 Yrs

MDM / DQS

1 yr.

ReqPro

yr.

UNIX / LINUX

2 Yrs

Toad for Oracle

yr.

Oracle SQL Developer Data Modeller

1 yr.

OS 400

1 Yr.

Rally

yr.

PRISM

yr

Jira

2 yrs.

Sun Solaris 10

yr.

Altova XMLSpy

yr.

Tableau

1 yr.

DM-OpenText

yr.

WhereScape RED

yr.

Education / Training

Self-studied on Visual Studio 2010/2013, SQL Server 2012/2014

Sept 2008 to Feb 2009 - Victoria College, Toronto.

BI Reporting with Cognos (7, 8), ETL process with Informatica PS(8.1) Data Modeling with Erwin(7.2) Certificate Course

2006 University of Toronto Post-Graduate Diploma

DEED Project University of Toronto, Ontario, Canada

Oracle 10g SQL, PL/SQL, Programming Unit/ MySQL

SQL Server 2005, T-SQL, ASP.NET, C#.NET

HTML, JavaScript, CSS, Java, JSP, J2EE, Ajax, Eclipse

Project Management with MS Project / Unix, SUN Solaris 10

2003, Web Design and Digital Graphics, Yorkdale Adults Learning Center

2000, CIMA-UK (Chartered Institute of Management Accountants) stage-1

1998, Bachelors in Computer Science and Statistic, University of Kelaniya

1994, Diploma in Computer Systems Design, National Institute of Business Management

Experience

DW/BI/Solution Architect (for GPO / MMIS / Procurement) Dec 2014 to To-date

North Shore LIJ Health System – New York, USA

Responsibilities:

Develop overall strategic data and BI architecture direction and provides a comprehensive road map for the business data needs.

Created DW/BI strategies to manage a multi-site supply chain / procumbent inventory data management system for over 1M inventory items, over 5000 vendors/manufactures and 18 different hospital systems.

Analysed, designed, developed data flows, information flows, BI Solutions, data cleansing and staging, ETL strategies for the Data in PEOPLE_SOFT modules

(Inventory / PO / AP / AR / Suppliers/Vendors/Manufactures), GHX Contracts, GPCMU (Group Purchasing Contract Management Utility) transactions,

Provide technical and development leadership for data modelling, management, MDM, architecture, design and development in RDBMS, OLAP, OLTP, MOLAP,ROLAP, drill-down, slicing and dicing, dimensional modelling, star schemas, snowflakes, ETL processes.

Use Oracle SQL Developer Data Modeller for CDM, LDM, and PDM.

Working as a liaison among stakeholders in order to understand the structure, policies, and operations of an organization, and to recommend solutions that enable the organization to achieve its BI/EDW goals.

Perform business analysis, systems analysis, requirements gathering and engineering, process analysis, products and material analysis, project management.

Guiding juniors to design, develop, QA, maintain front ends, back ends, ETLs, DW, BI applications.

EDW Architect Sept 2014 to Nov 2014

Toronto Transit Commission (TTC) – Canada

Responsibilities:

Analysed and synthesized information provided by various sources (Internal and External) for the new EDW Project.

Played a central role in aligning the Business/Data/BI needs of business units and served as a "translator" between those groups in MicroStrategy Analytics platform.

Provided assistance and training to junior Business Analysts and Developers.

Senior Data/Business Intelligence Analyst March 2014 to Aug 2014

AT&T (American Telecommunication & Telegraph) – USA

Responsibilities:

Analysed Telecommunication Business Requirements and Data (Big Data) for inside and outside business clients, projects and applications (Agile/Waterfalls).

Provided Solution Definition Artefacts and System Requirement Artefacts.

Creating, modifying physical/logical data schemas, objects using Erwin/ Altova XMLSpy for Oracle, MySQL, Oracle Coherence Grid, Cassandra

Analysed data dependencies, creating data mapping sheets.

Analysed ETLs (Informatica, Oracle GoldenGate) and Enterprise Messaging Service (EMS-JMS).

Created Epics, User Stories in Rally and Other Artefacts in ReqPro/PRISM

Working with Offshore teams.

DW/BI Solution Consultant Nov 2012 to Nov 2013

Perfect Business Solutions Ltd (PBSS)

Responsibilities:

Analysed Data and BI/Information Requirements of the company Clients.

Experienced in researching, promoting and the development of emerging technologies used in business opportunities

Managed system design and development phases for BI/ETL/DW requirements.

Used ERWIN for Data Modelling.

Analysed, designed, developed and deployed solutions involving OLAP,OLTP, Fact and Dimensions, client/server, DB,DW,BI and web applications

Used Informatica, SSIS, SSAS, SSRS, Crystal Reports and VBA Excel Macros

Managed and Trained business users and company staff

Business-Data Analyst / DW Architect Sept 2009 to Sept 2012

TD Securities

As a Business-Data Analyst

Responsibilities:

Served in Capital Market Risk Valuation and Reporting Team

Involved in full project life cycle from beginning to end in following areas.

Translated business requirements into DW/ETL/BI Technical Design and coordinate with ETL & BI developers, DBA and System Administrators, Project Managers in the development, automation and maintenance of Data Warehouse (including data profiling, logical and physical models, documentation) and ETL work flows, jobs, batch scripts, Data Marts, Cubes and BI Applications.

Analyzed existing risk policies, their process flows and data flows.

Tested, Validated and audited the quality and accuracy of existing data received from various source systems and new data feeds(internal and external ) (Bloomberg, Reuters, Yahoo, Google, Global Insight, Activ, Stock Exchanges, etc

Supported the Project Manager in planning, executing, controlling and closing project phases.

As a DW/BI Architect

Responsibilities:

Created data models and process models to calculate Alpha, Beta, Estimations, different kind of Risks and Safety limits, Gains and Losses, long and short Leverages for the Securities, ETFs, Derivatives, Commodities, Indexes, Bonds, Options, Coupon, Futures, Forex, E-mini.

BI/Data Modelling (Erwin) for Data warehouses, Data Marts, Data Mines and BI reports.

ETL, Migration and DTS with MSSQL Server 2000/2005/2008 Excel, Access, text files, UNIX, CSV Files

Develop BI Reports (SSRS RDL, Crystal Reports, Excel Pivots, VLOOKUP, Macros, MS Access Macros ) for TD Market Risk policies

Used OLAP, OLTP, Cubes, RDL, MDX, Pivots, CLR, C#.Net, ASP.Net, SSRS, SSIS, SSAS for DW/BI/Reporting Systems

Created, Automated, Monitored, Scheduled ETL jobs, Repot Publishing System in SSIS and ETL

Documented project details according to the company standards.

Version controls in VSS and MKS.

Client Information/Data Analyst Nov 2006 to June 2009

Mosaic Sales Solutions

Responsibilities:

Provided full SDLC in the following areas.

Data Modelling for Data warehouses, Data Mining and Client reports,MDM

ETL, Migration and DTS with MSSQL Server 2000/2005/2008, Excel, Access and text files, ETL, DW testing

Developed Reports (Crystal Reports, Business Objects, Excel Pivots and Macros )

Implemented solutions in OLAP, MDX, OLTP, Cubes, Pivotal with SSAS, SSIS, SSRS

Trained users and new staff for operations and activities

Project management with MS Project 2003 and Visio

Communicated with all levels of an organization and external clients

Documented project details according to the company standards

Created supporting documents, manuals and administrative reports

Business Support Analyst 2004-2006 Nov

Bank of Montreal

Responsibilities:

Tested and audited data received from branch level before loaded in to Data Marts

Automated manual tasks using VBA and SQL Jobs in Data testing and loading

Design, develop and Implement MIS reports or Investor Relations, Everyday Banking, Loans and Mortgages, Fund Accounting

Support GRIDBEAST (Excel-VB application to read any legacy systems report-image text data into Excel worksheets, and to process data for MIS reporting)

Design, develop and implement Excel Macros to maintain and analyze foreign currency transaction income

Design, develop and implement a MS-Access system to manage BMO transits mail deliveries

Design and develop a MS-Access system to tally customers' monthly transactions and month-end balances to produce two different reports

Document project details according to company standards

Performed quality assurance duties

IT Manager 2001-2003

Institute of Bankers of Sri Lanka

Responsibilities:

Provided consultancy, assistance, technical support and knowledge to design, develop, implement and managed MIS requirements for the following areas of the institution (SQL server(DTS, Reporting and Analysis Services), Oracle 9i, Crystal Reports -8, VB 6/ .net)

v Bank Professional Members

v Students Details

v Accountancy and General Ledger

vCourse income

v Fixed Assets

v Full time and Part Time Employee Payroll

Provided technical training and user support

Managed Computer Training Centre of the Institute

System Administrator 1999 – 2001

Harischandra Mills Limited – Sri Lanka

Responsibilities:

Installed and administrated SYBIZ VISION-ERP solution

Setup and installed computer network with 2 servers and over 40 workstations.

Installed and setup two NT-Domains with over 40 (Dell, IBM, Acer, Simons) PCs

Designed, programmed, tested and implemented server-side processes (packages, procedures, functions, triggers, in database using SQL-Server (7,2000), Access, FoxPro)

Created a Data warehouse and a decision support system (Data mine) using SQL Server, Visual Basic and Crystal Report Writer to provide the information in the areas of

v Sales

v Inventory

v Creditors

v Debtors

v Market research

v Sales & Production

v Forecasting

v Income & Profit

v Statistical Analysis

Performed database backups and recoveries

Engineered a remote access server between company’s offices

Established data entry policy to ensure the accuracy of data

Software Developer / Systems Analyst 1996 – 1999

OpenArc Systems Management (put) Ltd

Responsibilities:

Designed, developed, implemented, updated, controlled and maintained General Ledger. Front-end (VB and Progress-8 (Developer)) and Back-end (Progress (RDBMS), SQL Server) for the leading banks in Sri Lanka

Transferred manual/old computerized systems in to new computerized systems, used SDLC

Contact this candidate