Data Manager

Meena Ram

Address: *** ********* *****, ******, ** L1K 0L5

Phone #: 416-***-****

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

PROFILE

A polished Senior Consultant at Deloitte & Touché. With over 10 years of experience in the IT

industry in all phases of a software development life cycle. 8 years combined experience in

solution architecture, data architecture and data warehousing experience in analysis, design,

implementation, development and testing. Experienced working with business process

management tools and frameworks. Experienced working with all architecture and development

frameworks used within the financial industry and public sector in Canada, USA & UK

PROFESSIONAL COMPETENCIES

Software / Products: UNICA, Sybase PowerDesigner 15.1, Macromedia Dreamweaver, SAS,

crystal reports, Business Objects, Remedy, Avaya, Lucent, Microsoft Office

Development Tools / Languages: Oracle SQL*Loader, IBM Cognos 8 BI Framework Manager,

IBM Content Manager, IBM Cognos 8 Report Studio and Query Studio (Version 7,8.1 -8.3),

Cognos Decision Stream, Powerplay, Impromptu, IBM InfoSphere DataStage, PL/SQL, Erwin

Modeling

Hardware / Operating Systems: UNIX (Sun Solaris, HP-UX, Linux), Windows 2000/NT,

MSSQL server 2000

Middleware / Databases: Oracle 8i, 9i, 10g, 11g, Sybase

General Tools: Microsoft Office, Microsoft Project

EMPLOYMENT HISTORY

ORGANIZATION: Deloitte & Touché

Worked on technical contracts with: Scotiabank Group, CIBC Global World Markets, CIBC

Technologies, TD CDIC, Ministry of Transportation, State of North Carolina and OMERS

JOB TITLES TIME FRAME

Technology Consultant Sep 2010 to Present

• Provided design and data modeling for the financial and public sectors in Canada and

USA

• Developed and maintained both operational and data warehouse conceptual, logical and

physical data models

• Responsible for providing data modeling solutions and database design on large projects.

• Provided guidance and solutions for metadata management, data stewardship, data

quality, IT governance, Enterprise Data Models, and Enterprise Frameworks.

• Provided guidance and solutions for operational data store design and data warehouse

fundamentals

• Provided guidance and solutions for data mart access models and dimensional modeling

skills.

• Provided strong analytical and problem solving skills with attention to detail and ability

to work effectively under time constraints.

• Provided the ability to exhibit maturity, reliability and stability by adhering to

commitments is critical in order to maintain business credibility

• A strong team player with leadership skills

• Provided strong written and verbal skills for executives

Projects backgrounds

Scotiabank Group Technology Project

Solution Architect

Deloitte was selected to review and assess current state architecture. The client requested Deloitte

to provide a target state architecture solution and recommend technologies to support the Next

Best Action project

Role:

• Responsible for assessing the current marketing campaign technologies that are used for

acquiring and maintaining Scotiabank’s customer base

• Responsible for evaluating current state architecture for DSM and CIM business users

• Responsible for documenting data flows and process from various line of business such

as Products and Marketing, CIM, DSM and CCT

• Responsible for providing target state architecture to support the Next Best Action

Project and provided technology recommendations

• Identified areas of where current technologies can be leveraged

CIBC Capital Markets & Wholesale Banking Technology FATCA Project

Data Specialist

The client selected Deloitte to define a methodology to create a master client list required for

FACTA and potentially other regulatory projects.

Role:

• Met with various Wholesale Banking LOB subject matter experts to identify what their

client transaction system

• Responsible for analyzing data extracts provided by each LOB

• Responsible for identifying revenue systems within Wholesale Banking to capture client

data for FATCA

• Responsible for creating a proven methodology for capturing Wholesale Banking client

information

• Responsible for developing a pseudo algorithm for eliminating a majority of manual

effort performed currently

• Responsible for identifying key risk areas with their current environments and provided

the client with potential solutions

Identified potential project areas for the future

CIBC Retail Finance Technology Project

ETL Specialist

The client selected Deloitte to help overcome performance and data concerns. They required an

ETL specialist to de-engineer the workflow and document development flaws and identify areas

of risk, following recent production challenges.

Role:

• Responsible for assessing the current retail platform to identify gaps and challenges the

client will face from a technology point of view

• Responsible for interviewing various technical and business staff to identify workflows

and critical path processes from source to reporting interfaces

• Responsible for investigating technical approaches derived by the architectural team to

understand reasoning behind their decisions

• Responsible for providing feedback to senior management on my findings and

documenting areas of concerns

• Responsible for delivering executive level risk and impact assessments for current

technical portfolio and possible remediation plans

• Responsible for creating a roadmap of their current retail platform and guiding them to

where they should be moving towards from a stability stand point

TD CDIC Project

Data Modeler

The client selected Deloitte to help determine the design and implement a solution to insurance its

clients in the event of bank failure. The Canadian Deposit Insurance Corporation (CDIC) offered

the financial institutions with a financial initiative if they were able to implement a solution that

complied by CDIC's requirements by November 2011.

Role:

• Responsible for coordination working sessions with different line of businesses

understand their initial business scope

• Responsible for aligning their current data structures with that of CDIC requirements

• Responsible for providing a clean set of requirements to creating copybooks and DDL for

development

• Responsible for creating pseudo code and SQL approaches to load CDIC database

• Responsible for creating documentations for CDIC compliance and for testing phases

• Responsible for creating test scenarios and possible test cases for testing phase for

various lines of business

Ministry of Transportation RUSMOD Project

Requirement Coordinator

The client selected Deloitte to be there trusted advisor, in gathering requirements for the

development on implementation of their new integrated system. The client's expectation was to

have the requirements gathered ready for RFP

Role:

• Responsible for gathering requirements from the domain subject matter experts, and

aligning them with the given methodology and playbook

• Responsible for implementing business scenario models and activity diagrams in Sybase

Power Designer

• Responsible for entering Business System Requirements, Business Rule Profiles and

Business Rule Sources into Power designer in preparing for seeking a potential vendor

for the clients implementation approach

• Implemented UML diagrams and other notations into Powerdesigner

State of North Carolina OSBM Project

Oracle PL SQL ETL Developer

The client selected Deloitte to design, develop and implement a state budgeting system for the Governor

of North Carolina.

Role:

• Responsible for the development of PL/SQL scripts to convert data from a third normal form to a

de-normalized form for data staging and TM1 Analytics

• Responsible for improving database performances on query execution by researching the

PL/SQL functions and packages

• Responsible for testing the data contained in the database prior to deploying model for BI Report

writers

• Responsible for deploying packages from UAT to Production environments

OMERS Pension Project

BI Report Developer

The client selected Deloitte to define and develop a pension reporting system, based on the existing

infrastructure, using IBM's framework and tools.

Role:

• Responsible for researching BI report issues, incorporating performance changes to a multi-

dimensional model

• Responsible for implementing report model changes requested by the client

• Responsible for documenting the implemented model for client training and validations

• Responsible for improving performance measures on complex financial calculations for

reporting

ORGANIZATION: CGI Group INC

Wealth Management and Portfolio Services

JOB TITLES TIME FRAME

Data Warehouse Subject Matter Expert (Analyst) Mar 2008 to Sep 2010

Role:

Responsible for the development and QA of the ETL unload scripts as well as the deployments in various

client environments. Provide on call support, maintenance and training of the warehouse on the Cognos

BI tool for financial reporting.

• Responsible for ensuring that data from source systems have been loaded correctly in the data

warehouse and any failures during the extraction, transformation and loading processes have

been corrected to maintain data integrity

• Responsible for the initiation of the data processing experience in designing and implementing

Data Mart applications for banking and investment clients. Mainly focusing on the

transformation processes using ETL tool DataStage (Ver8.0), designing and developing jobs

using DataStage Designer, Data Stage Manager, DataStage Director and DataStage Debugger

• Worked on scalable parallel processing Infrastructure using DataStage Parallel Extender

• Responsible for tracking and prioritizing ETL enhancements (client funded and core

developments)

• Responsible for the development and enhancements of the unload and load using UNIX scripting

and PL/SQL programming languages

• Responsible for the data modeling and building of data models for all new clients using IBM’s

Cognos 8 Framework Manager

• Developed the relationships between the materialized views of the metadata for GUI interface of

the data warehouse for new client environments

• Developed custom reports for client statements using Cognos Report Studio

• Perform system analysis, design and maintenance on the client interface using Cognos Report

studio and query studio

• Responsible for assessing change requests that was assigned to team

• Mentored and trained staff members for knowledge sharing and educational purposes

• Designed and developed a training program for clients to aid with their production of client

statement development

ORGANIZATION: Guinness UDV, Essex and Park Royal, London, UK

JOB TITLES TIME FRAME

Senior Report Developer Aug 2006 – Dec 2007

Role:

Responsible for delivering a product performance utility using Cognos reports, cube, development and

deployments in relation to the activities in various locations in the South East of England.

• Worked with various business verticals together business requirements

• Documented development specifications and established project plans for the extracted data and

develop databases as per development specifications and business requirements

• Responsible for development of ad-hoc reports using established databases

• Created reports using the data access tools such as MS Access, SQL, etc. for conceptual purposes

• Automated and streamline the business process through the use of IT tools and resources

• Worked closely the team with the design and development of OLAP and reporting databases

• Was responsible and worked alongside DBA with daily and weekly loads, backups, database

refreshes and other database operation support tasks

• Developed new web based on-line applications as well as enhancing and maintaining the existing

GUI interface

• Developed front-end application for data reporting and extractions by the business users

ORGANIZATION: Citigroup UK

JOB TITLES TIME FRAME

Quality Assurance Data Warehouse Lead Feb 2004 – Jul 2006

Role:

Responsible for the quality assurance of developers, in the design and implementation in a data

warehousing environment that extracted data from various external sources that could be used in an in-

house reporting, data mining environment and coordinate the development between two sites: UK and

India.

• Gathered and analyzed requirements for the data warehouse and data marts entities

• Performed the analysis and design of the ETL environment determining the historical data that

can be used for behavior and trend patterning

• Responsible the conceptual modeling of ETL lifecycle for credit card

• Responsible for the database design and working closely with the DBA

• Developed numerous unload scripts utilized in the extraction phase using UNIX shell scripting

and PL/SQL Programming

• Was heavily involved in the design and development of the data cubes and dimensions using

Informatica PowerCenter

• Development of fact and dimension tables using DDL scripts

• Responsible for the building relationships and mapping tables for data mining exercises

• Responsible for documenting development changes and training documents

• Responsible for training and managing of the developer’s work load and working closely with

DBAs and system support personnel in elevating successful code into production

• Responsible for providing on-call support to production systems to resolve any issues

ORGANIZATION: Citigroup UK

JOB TITLES TIME FRAME

Database Developer/ Analyst Feb 2002 – Feb 2004

Role:

• Participated in the product scope, analyzed, enhanced and maintain data warehouse system

utilizing

• RDBMS database (Oracle 8i, 9i, SQL Server, Sybase) and developed SQL scripts and

Informatica tools

• Developed Extraction scripts using PL/SQL, maintained data transformation processes.

• Developed data automation on load processes, maintained and updated data loading processes.

• Defined and captured metadata and business rules in coordination with other data ware house

teams to support projects.

• Assured and monitored all programs are documented using standardized documentation

procedure.

• Worked with various IT verticals with the company to manage and implementations.

• Provide High level estimates.

• Participate in on-call duties.

ORGANIZATION: British Telecommunications

JOB TITLES TIME FRAME

Technical Analyst Dec 2000 – Feb 2002

Role:

Responsible for liaising with clients and providing them with the necessary information for the

installations and network configurations. Monitored network and troubleshot alarms for network circuits,

IVRs, Windows, Linux, Exchange and Apache servers. Tracked long distance, wireless and internet

network outages and maintained continuous contact with all technicians until resolved and logged all

events that occurred during shift.

EDUCATION / PROFESSIONAL DEVELOPMENT

HND Software Engineering

Manchester Metropolitan University

BSc.(Hons) Electronic Systems

Manchester Metropolitan University

PERSONAL INTERESTS / ACTIVITIES

I have an active interest in cake decorating and baking. I have made numerous cakes for family

events. I enjoy reading crime thrillers and thriller fiction. Entertaining family friends is especially

important to me. My family and I enjoying travelling, I love to explore the cultures of the world.

Contact this candidate