Fauzia Rary

Data warehouse /BI Developement manager

9+ Years- Experience on enterprise level data warehouse/business intelligence projects. Responsibilities have ranged from Data Warehousing data population and data modeling techniques for target structures such as Star Schemas, Snowflake Schemas. Responsible for translating business data requirements into conceptual, logical, and physical data models. Manage and lead teams in building reports in Business Intelligence Platform. Make recommendations concerning existing Technology/Information systems and the development of new procedures, standards, tools and techniques. Core competencies include:

 Data Mining and Analysis

 Business Intelligence

 Report Development

 Project Management - SDLC

 Data profiling

 Business Requirements

 SSRS Report Development

 Cognos Development

 MSAS OLAP cube creation

 Data Modeling/Data marts

 Transact SQL

 ETL Process Flows

 Financial Analysis

 User Acceptance Testing

 Data Validation

TECHNICAL SKILLS

 Technical Software Tools – Toad, SQL Plus, Query Studio, Cognos 8 BI Packages, Cognos Framework, MSAS,SSRS

 Operating Systems – MS Windows 2000/XP

 RDBMS Languages - MS Access, MS SQL Server, Oracle 10g, SQL, PL/SQL

 Business Software Tools - MS Word, MS Excel, MS Power Point, MS Project, MS Visio, Lotus Notes

PROFESSIONAL EXPERIENCE

JP Morgan Chase Home Finance, Irving, TX 2007-Present

MIS Manager

Summary of Projects and Achievements

- Responsible for all activities related to the design and development of enterprise wide data analysis and reporting solutions .Work with COGNOS 8 series BI packages, Framework Manager modeling, Query Studio, Report Studio, Analysis Studio, and OLAP Cube creation. In-depth knowledge of Data warehouse in an Oracle and SQL server Platform, Relational databases, OLAP, and data access/front-end tools such as SQL, and Excel

- Managed and Deployed a Data Warehousing project that entailed in the development of a central source repository that catered to users across the default organization allowing utilization of the data environment for MIS Reporting and Analytics. The initiative provided a positive financial impact to the operations by allowing for better forecasting, trending, loss control, and procurement.

• Develop data mart models, design specifications to develop analytic and reporting solutions using COGNOS 8 series BI Reporting Tools

• Create ETL process flow Scripts and work with Informatica Developers to automate data extraction.

• Collaborate with DBA team on schemas and data structures to enable access to data elements and variables

• Creation of analytical reports ,modifications to existing reports in the company’s enterprise Business Intelligence framework

• Develop efficiencies to increase the effectiveness of reporting and consolidate & maintain departmental reports used by other departments, senior managements.

• Produce Executive reporting / business intelligence 'packages' (dashboards, presentations, etc.) for use by key stakeholders at all levels of the organization

• Responsible for producing / analyzing monthly, quarterly and portfolio data to ensure data integrity and portfolio information has been recorded accurately.

• Design and develop Cognos packages using Framework Manager

• Provide leadership and direction for the unit in accordance with the overall strategic direction of the department and Assign personnel to various work projects and direct their activities

• Translate high-level requirements from the customer into effective BI solutions

• Integrating complex data from disparate sources into a data warehouse and applying strong analytical skills to develop existing business reports with high level of complexity, thus reducing the time to generate these reports manually to complete automation.

Environment: Oracle, Cognos 8.2, Cognos 8.2 Report Studio, Query Studio, Analysis Studio, Powerplay 7.3, Framework Manager, Toad, SQL

Countrywide Financial - Fortworth, TX

Sr.Financial Systems Analyst-Portfolio Analysis 2005 – 2007

Summary of Projects and Achievements

- Supported Countrywide Tax Service Corporation for their Executive Financial Reporting needs and assist with Department Budgeting & Forecast Planning solutions. Provided Technical solution for their budgeting and forecasting needs using BI solution

• Created Data Marts in SQL server .Developed DTS packages to extract raw data from various Databases (SQL server and Hyperion)to develop OLAP cubes with MS Analysis services and developing reports with MS Reporting Services

• Designed/Implemented OLAP cubes (Finance cubes such as –Actual Vs Budget Vs Forecast cube, Headcount cube , Income & Cost Analysis Cube) with MS SQL Server Analysis services to facilitate Reporting and data analysis functions

• Developed department Reports(Dashboard, Scorecards) using MS SQL Server Reporting services(2000 & 2005), and Excel Pivot tables

• Gathered Requirements and coordinated with various departments to assure satisfactory data content, quality, data integrity and receipt of desired information

• Variance analysis ,Reconciliation of accounts and provided consolidated reports for proper Decision making

• Analyzed and delivered Monthly Expenses vs. Budget report, Month End closing reports and other Ad-Hoc reports with high level of accuracy to senior management.

Environment: SQL Server 2000, MSAS, SSRS, DTS Packages, Transact SQL

Barrette Burke Wilson Castle Daffin & Frappier L.L.P -Dallas, TX 2004- 2005

Business Data Analyst

Barrett Burke Wilson Castle Daffin & Frappier LLP is legal advisory firm that offers assistance on issues related to real estate law and mortgage. Worked as a Business Analyst in their IT department, responsible for developing application system to automate the Business process related to Bankruptcy, Foreclosure

• Gathered business requirements to automate business processes in providing legal services (specializing in Bankruptcy and Foreclosure cases) to the Mortgage industry.

• Identified and documented business requirements, prepared Functional Specs. by working with members of the business and IT teams

• QA testing, Writing Test cases and Conducted UAT (User acceptance testing)

• Maintained databases, manipulated large data sets, and extracted data according to specification using SQL queries

• Ensured data integrity across all billing systems database platforms and related third-party systems

• Run SQL Scripts against databases to apply database changes and Troubleshoot applications go-live issues

Environment: Oracle, Toad, SQL

NORTEL NETWORKS- Richardson, TX 2003- 2004

Data Support Analyst-CDMA wireless Market Forecasting/ Order Operations.

Evaluated Business Processes and research industry best practices to recommend operations performance improvement to Nortel Networks Wireless Operations Supply Chain

• Gathered Business Requirements to automate and design Report Generating Tools in Access

• Worked with the Order Commit Implementation/Systems/Metrics team to support various Order Management initiatives including various systems alignment, data feed issues.

• Monitored weekly orderfill consumption in relation to the current demand plan and allocation and present timely metrics to the management team to increase efficiency

• Responsible for Variance Analysis of Forecasted and Actual data

ALCATEL USA- Plano, TX 2002-2003

Intern-Business Analyst- Operation/ Finance group.

Used ERP (Oracle financial) to retrieve raw inventory data and compiled it into desirable output and performed meaningful financial analysis.

• Performed Cost Behavior Analysis on Vendor quote and Alcatel quote

• Responsible for Budget Variance Analysis

• Calculated Financial Ratio and projected performance with other suppliers

• Assisted in preparing Price Models and supported purchasing related business needs

• Analyzed and interpreted manufacturing data and created financial reports

• Managed and maintained contract manufacturer’s financial matrix

• Prepared weekly OEM (original equipment manufacturer) liability reports to be delivered to managers

NORTEL NETWORKS– Richardson, TX 1999-2001

Intern- Project Coordinator- Service Provider Solution.

AMERICAN EXPRESS– Dhaka, Bangladesh 1995 –1998

Financial Analyst

EDUCATION:

University of Texas at Dallas

Master of Science – Information Technology August - 2003

University of Dhaka, Bangladesh

Bachelor of Commerce – Finance Nov-1997

Certification-

Completed COGNOS 8.2 Framework manager, Powerplay and OLAP Modeling Course

• Completed Microsoft OLAP certification Course

Contact this candidate