Fathima Zohra

ad1okg@r.postjobfree.com ***** Valley Green Dr, Apt #111, Cupertino CA 95014

Ph: +1-669-***-****

SUMMARY

Eight years of professional experience in engineering and architecting data warehousing and business intelligence solutions.

Played the role of an Application Programmer at IBM India, a specialist role responsible for leading and delivery projects in the data-warehousing domain.

Core expertise in consulting and development experience in Insurance, Manufacturing and Media industries.

AWARDS AND ACHIEVEMENTS

IBM:

Won an award for Service Excellence in Delivery for executing multiple projects in Bank of Montreal, Toronto in ‘11

As part of the PIX project in Bank of Montreal account, received a Team award in ’11. MindTree:

Recognized as a “STAR” for project delivery and execution for Keenan and Associates, USA in ‘09

Lead a team of 4 to execute a project for Franklin Templeton which won the best project award in ‘08

Certificates and awards for active participation and organizing well received technical trainings.

Course completion and certifications in MS SQL Server, Xcelsius and Crystal reports

Lead a team to execute a project for Kraft foods, USA which went on to win best project award in ‘06

Topper in Jyoti Nivas College during Pre-University 1st and 2nd year in ’99/'00

Subject proficiency award for Science in Jyoti Nivas College in ‘99 TECHNOLOGY PROFICIENCY

ETL: SQL Server DTS packages, Business Objects Data Integrator, Informatica

Reporting: Microsoft Analysis and Reporting services, Business Objects Crystal Reports, Web Intelligence, Desktop Intelligence, Xcelsius

Querying and Analysis: PLSQL, TSQL, Multidimensional Expression (MDX)

Languages: C, C++

Databases: MS SQL Server 2000, MS SQL Server 2005, Oracle 9i, Oracle 10G, DB2

Operating systems: Windows Server, XP

Development tools: Visual cut and Toad

DATAWAREHOUSE PROFICIENCY

Data model design.

Requirement analysis, tool evaluations and prototyping.

Data warehouse project assessment and estimation.

ETL Load Design and Development. End-to-end design for automating the ETL load until the Reporting Layer

Report Design and Architecture. – Evaluating Reporting requirements and designing complex reports for analysis

Performance Tuning in Reports and SQL queries

Source system analysis and data quality assessments.

Client side deployment and postproduction management. EDUCATION

B.E in Information Science and Technology. 2000 - 04 B.M.S College of Engineering, VTU. First class with distinction, 80% overall Pre University, Jyoti Nivas College, Bangalore 1998 - 00 First class with distinction, College topper, Science 89% SSLC, St. Paul’s English School 1998

First class with distinction, 80% overall

Fathima Zohra

ad1okg@r.postjobfree.com 20875 Valley Green Dr, Apt #111, Cupertino CA 95014 Ph: +1-669-***-****

PROFESSIONAL EXPERIENCE

IBM India Pvt Ltd, Bangalore. BO Consultant and Senior System Engineer Feb 2010-Nov 2014 1.Medtronic Jun 2013- Nov 2014

Medtronic is the leading medical technology company, providing lifelong solutions for people with chronic disease. Founded in 1949, Medtronic now serves physicians, clinicians and patients in more than 140 countries. The company is headquartered in Minneapolis, Minnesota, and has research, manufacturing, education and sales facilities around the world. Medtronic employs nearly 85,000 people worldwide in North America (U.S., and Canada), Europe (17 countries), Asia-Pacific, and Latin America in five major divisions. The company’s revenue is $28 Billion USD with Covidien. The main objective of this project is to develop a centralized data warehouse so that reporting can be done in various forms and business can be driven accordingly. Medtronic BI enables Business Units to make timely decisions by providing solutions using the latest industry-oriented technologies. Key strategy is data consolidation from various source systems such as SAP ECC, JDE, Work Day, Siebel, SAP CRM and Other enterprise business systems. Medtronic is leveraging various state of the art BI platforms such as SAP HANA, Oracle 12c, Spotfire, Tableau, SAP Lumira, SAP Business Objects 4.1, SAP SLT, Informatica, IBM Infosphere Replication Server (IRS) and SAP BW. Medtronic has a custom-built Oracle based Data Integration Platform (DIH) of size up to 30 TB and a reporting data warehouse in SAP HANA which is 13 TB in size with 13 nodes. Medtronic’s diverse environment, Business requirements and technology platform provides various challenges in the BI and Analytics space. By using the Business Objects 4.1 tools developing and delivering Universes to enable Users to do reporting and analysis based standard reports to the managers and users for decision making and to give added visibility to the users and higher management authorities about the Business.

Responsibilities include,

● Worked on the Business Intelligence platform using SAP Business Objects 4.0/4.1 tools, Web Intelligence, Crystal Reports, etc.

● Responsible for supporting the BO platform, reports, universes and ensure customer satisfaction targets are achieved through enhanced customer service by owning service delivery professionally and adhering to support SLA.

● Developing universes on top of relational and SAP HANA data sources, designing and building reports based on the requirement.

● Modifying the existing universes and reports based on the user request for changes.

● Analyze/troubleshoot and fix technical issues. Debug, tune and optimize code for better performance. Full unit and user acceptance testing and then deploy them to production. Collaborate proactively with functional users, analysts and other team members to ensure smooth break fix execution.

● Actively utilize and seek assistance from technical team, BO administrators and data architects to analyze and provide solutions to business Users.

● Engage vendor support/technical staff to assess solution options and to analyze and resolve/escalate issues.

● Restarting servers and administrator activities like creating users, groups, folders, access security and creating/maintaining events used for schedules.

● Quarter end and year end maintenance activities.

● Understanding data sources and security requirements for data access.

● Provide technical solutions to a wide range of complex production problems.

● Migrating/promoting the reports/ universes/ connections from source to destination environments as per the change management process.

● Reviewing request for changes and doing an impact analysis.

● Collaborate and work very closely with BO admins to deal with platform related issues and other data teams like enterprise data warehouse, Hana and BW teams for any data issues.

● Creating accelerated solutions that would increase the productivity of support operations.

● Take responsibility for delivering high level of code, providing training/ supporting new entrants on technical process mode.

Fathima Zohra

ad1okg@r.postjobfree.com 20875 Valley Green Dr, Apt #111, Cupertino CA 95014 Ph: +1-669-***-****

● Deliver new and complex high-quality solutions to clients in response to varying business requirements.

● Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.

Skills: AP Business Object 4.1, SAP BO XIR3.1, Crystal Reports for enterprise, Toad, Oracle 11g Role: Application Programmer and BO Consultant

2. Capital Markets and Risk Management Group, Bank of Montreal, Toronto Apr ’10 – June 2012 PIX is BMO’s middleware which receives/sends the XML messages from/to Proponix through internal Management Queue (MQ). Whenever we receive a message from proponix, a confirmation message is sent back. PIX utilizes DB2 to store and manage the messages on the Master Header Tables and DIT

(Data Interface Tables). Data stored in DB2 tables are used for reporting in BMO (Bank of Montreal). Business Objects is used for reporting, query and analysis for the data processed in OTL and PIX. All the information is consolidated from OTL and PIX and reported in the required format. From this users can take advantage of reconciling the messages sent/received from PIX to OTL. The users have the capability to run on-request reports. There are different categories of reports: On-request, Batch and Intraday. The reports are also categorized based on the process, such as: GL, DDA, PIX-EXTRACT, SWIFT etc.

Responsibilities include,

● Worked and taken a lead for almost 7-8 new enhancements and releases

● As a report developer and reviewer, have analyzed and monitored many production issues.

● Administrative activities for BOXI DEV and SIT Environments

● Designed and created multiple new Business Objects XI reports and WebI reports for data analysis

● Well adhered to all Quality Management process and system

● Active user of AQT (Advanced Query Tool) and FileAid for DB2 access and data comparison respectively

● Unit Testing and System Testing

● Worked with the Customer’s Release Management team for smooth report promotion

● Currently working on a migration project, moving objects from BO XI R2 to R3.1 and testing the same. Skills: DB2, Business Objects XI R2

Role: Application Programmer and BO Consultant

MindTree Ltd, Bangalore. Associate Consultant Sep 2004 – Dec 2009 1. Member Provider Network Report for Keenan, USA Jul –’09 – Dec– ‘09 Keenan wishes to enhance the functionality and end user experience on the MPN report, to deliver further value to its customers. MPN stands for “Member Provider Network”. MPN is a program offered to Keenan’s customers so that they can derive certain worker’s compensation benefits. All clients who are registered under this network are advised a set of doctors, hospitals and other providers. When an MPN client incurs any cost, he may or may not opt for the MPN benefits depending on any reason. Some of the challenges faced with the earlier version of this report are: static nature, inconsistent data being reported and limited UI features. The objective of this project is to overcome these challenges and thereby provide an enriched visual representation with more dynamic content. The project also involves the integration of the MPN data from multiple source systems with the Keenan data mart. Responsibilities include,

● Requirements gathering and analysis

● Off-shore project management and co-ordination with the onsite team

● Data model design

● ETL and Report design and development

● Unit Testing and System Testing

● Production Migration

Skills: Oracle 10G, Business Objects Data Integrator, Business Objects XI R2, Xcelsius 2008, QaaWS Role: Project Lead

Fathima Zohra

ad1okg@r.postjobfree.com 20875 Valley Green Dr, Apt #111, Cupertino CA 95014 Ph: +1-669-***-****

2. Enhanced P&C Bridge Reports for Keenan, USA Mar ’09

– Jun ‘09

The objective of this project is to enhance the existing PC Bridge portal to display more reports with drill down capabilities. In addition to the school districts, reports will also be available to Hospitals, Municipalities, JPA and Super pool. The data warehouse will be modified and enhanced to make it more scalable for future enhancements in order to support additional business elements. Responsibilities include,

● Reporting and data requirements analysis and design

● Complete design and development of reports on Xcelsius

● Worked on universe enhancement

● Leading a team of 4 and training them on Xcelsius and QaaWS

● ETL Performance tuning

● Custom flex component integration into Xcelsius

● Proposing a Claim analytics dashboard to the customer Skills: Oracle 10G, Business Objects Data Integrator, Business Objects XI R2, Xcelsius 2008, QaaWS Role: Technical Lead

3. Property and Liability reports for Keenan, USA Nov ’08 – Feb ‘09

Valley Oak is the application that administers and processes all claims for Worker’s compensation line of business currently within Keenan. Property and Liability (P&L) line of Business is being currently administered and processed by a legacy application called GenSource. The objective is to move the P&L claim administration from GenSource to Valley Oak. This Business Intelligence initiative is to change the existing Data Warehouse to source P&L claim analytics data from Valley Oak, which was being fetched from GSL. The project also entails requirements to build reports from the new system and email delivery capabilities.

Responsibilities include,

● Understanding the source systems and identifying key data capture and data quality issues

● Reporting and data requirements analysis and design

● Complete design and development of all new reports with enhancements to reports on P&L

● Worked on universe enhancement

● Exploring a new tool Visual CUT that bursts the report into individual pdfs and delivers the same to the end users

● Worked closely with the customer through the project and drove the migration process Skills: Oracle 10G, Business Objects Data Integrator, Crystal Reports XI, Visual CUT 4. Keenan P&C Bridge Implementation, USA May ’08 – Oct ‘08

Keenan & Associates is one of the largest insurance brokers in the United States. Keenan provides superior insurance products to a large number of divisions/subsidiaries like Schools and other Public Agencies. They provide financial security for their employee benefits, workers' compensation and property and liability programs. The process of collection of data and generating reports for driving business decisions is very complex and is currently being done manually. Being a manual process, it is very labor-intensive. There could also be issues like erroneous, missing, or conflicting data that may lead to repeated misreporting. There is considerable risk to information integrity when a process of gathering data from multiple sources and then generation of reports is performed manually. Responsibilities include,

● Understanding the source systems and identifying key data capture and data quality issues

● Reporting and data requirements analysis and design

● Complete design and development of the reports and universe

● Co-ordination with the Java application team to integrate the Crystal Report into WebLogic Portal

● Worked closely with the customer through the project and drove the migration process.

● Worked on developing complex procedures used by the application for consolidating data from multiple sources in to a single database

Skills: Oracle 10G, Business Objects Data Integrator, Crystal Reports XI Role: Module Lead

Fathima Zohra

ad1okg@r.postjobfree.com 20875 Valley Green Dr, Apt #111, Cupertino CA 95014 Ph: +1-669-***-****

5. Franklin Templeton 13FG Project, USA Jun ’07 –

Apr ‘08 Franklin files three regulatory forms, 13F, 13G, and 13D, to the Securities Exchange Commission (“SEC”) as required by the SEC under the Securities Exchange Act of 1934. There are many problems with erroneous, missing, and conflicting data that may lead to repeated misreporting. Franklin Templeton Technologies (“FTT”) has reviewed and discovered that the main causes of the data discrepancies are due to:

● The business logic of the report(s) currently produced which do not capture required information.

● Timing & synchronization issues pertaining to source systems and data feeds

● Lack of controls in the process (e.g., a report to flag errors or missing information). The process for gathering the data and filing the form with the SEC, as currently performed, is very labor- intensive, primarily due to manual research. Additionally, the generation of cover letters, the schedules/ forms and other material, as well as the Electronic Data-Gathering, Analysis, and Retrieval system

(“EDGAR”) filing process, is also extremely labor-intensive. There is considerable risk to information integrity when a process as complex as gathering data for the 13F/D/G filings is performed manually. Responsibilities include,

● Understanding the source systems and identifying key data capture and data quality issues

● Reporting and data requirements analysis and design

● Complete design and development of the reports

● Design of the reporting layer and metadata information for driving reports

● Worked closely with the customer through the project and drove the migration process.

● Worked through the UAT phase with the customer

Skills: Oracle 10G, Crystal Reports XI

Role: Module Lead

6. Kraft Foods, USA Apr ’06 –

May ‘06

Kraft Foods (NYSE: KFT) is a global leader in branded foods and beverages. Built on more than 100 years of quality and innovation, Kraft has grown from modest beginnings to become the largest food and beverage company headquartered in North America and second largest in the world, marketing many popular brands in more than 155 countries.

Responsibilities include,

● Reporting and data requirements analysis and design

● Complete design and development of the reports

● Design of the reporting layer and metadata information for driving reports

● Generating re-usable Report templates

Skills: MS SQL Server 2000, Crystal Reports XI

Role: Module Lead

7. Indigo Data warehouse Assessment Project, India Feb ’06 – Mar ‘06 Indigo is a non-voice call center at Hindustan Lever, which captures information for invoice processing across multiple countries. This was an assessment done to estimate the scope for a data warehouse in Indigo and to propose the roadmap and the tools for an implementation. Responsibilities include,

● Assessing and analyzing the flow of information w.r.t. invoice processing across different countries

● Identifying and analyzing the study of key performance indicators to assess employee performance, critical to a non voice call center

● Conducting interviews with the functional heads for these areas and understanding the information gaps and requirements

● Understanding the Source systems and identifying key data capture and data quality issues

● ETL Tool evaluation for pulling data from the existing source systems and reporting tool evaluation for developing and deploying reports

Skills: Requirement analysis and pre sales

Role: Consultant

8. Essilor LabMaster Project, Singapore Oct ’05 – Feb ‘07 Essilor Asia Pacific Ltd (referred also as to “Essilor”) is a world leader in ophthalmic products. Essilor works closely with eye care professionals providing innovative products that meet the lifestyle demands of Fathima Zohra

ad1okg@r.postjobfree.com 20875 Valley Green Dr, Apt #111, Cupertino CA 95014 Ph: +1-669-***-****

their patients. The project, which is named as LabMaster Reporting Tool is developed using Microsoft technologies in the pharmaceutical domain. We were responsible to build a data warehouse for sustained reporting of standard reports and set up a platform on which further Business Intelligence application can be made. The database used was SQL Server 2000, ETL was done using stored procedures and DTS, and Reporting was done via cubes.

Responsibilities include,

● Understanding the source systems and identifying key data capture and data quality issues

● Designing the Data model

● Designing and developing DTS packages for ETL

● Worked on developing complex procedures used by the system for consolidating data from multiple sources in to a single database

● Designing and developing cubes and dimensions in OLAP

● Designing and developing reports through excel by connecting to the cubes in Analysis Manager

● Implementing transaction handling and error handling framework

● Involvement in unit testing and system testing

● Individual involvement in implementation and deployment of the project at the client site

● Proactively support the business team and technical team on the customer’s side to clear discrepancies during User Acceptance Testing phase of the project Skills: MS SQL Server 2000, T-SQL, Data Transformation Services (DTS), Microsoft Analysis Services, MDX

Role: Technical Lead

9. GroupM Media Analytics, India Jan ’05 – Jul ‘05 GroupM is a media agency operating in the Advertising and Media Industry. It provides strategy consultancy on advertising through the TV and Print media. This project involved the development of a Media Analytics data warehouse with an online browser-based reporting tool used by the Media Planning and Buying users. This solution has enabled users to measure a host of weighted Key Performance Indicators like Reach, Time- weighted average viewership by program, by advertisement, by minute, etc, GRP (Gross Rating Points), Share of Voice, Share of Expenditure.

Responsibilities include,

● Design of the ETL Framework for accessing data sources and processing Analysis cubes and loading report tables

● Designing DTS packages to pull data from flat files and MS Access sources

● Database Administration for the development database

● Database design for Reporting tables which will be used by MS Reporting Services

● Data Model design for fact and dimension tables used by Analysis Services Skills: MS SQL Server 2000, T-SQL, DTS, VB Script, Analysis Services 2000, MDX and MS Reporting Services 2000

Role: Developer

PERSONAL INFORMATION

Full Name: Fathima Zohra

Nationality: Indian

Date of Birth: April 19, 1983

Languages: English, Hindi, Urdu, Kannada.

Marital status: Married.

REFERENCES

Available on request.

Contact this candidate