Business Intelligence Analyst

Rituparna Ray

Local Address • **** Fountain View Dr Apt#56 | Houston, TX 77057 • Phone: - 979-***-****

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

Education

1) Texas A&M University, Mays Business School, College Station, TX Graduation Date: May 2007

Degree: Master of Science in Management Information Systems

GPA: 3.58

2) Burdwan University, Department of Business Administration, Burdwan, INDIA Graduation Date: Jul 2002

Degree: MBA, Systems & Operations Management

GPA:3.88

3) Calcutta University, Lady Brabourne College, Calcutta, INDIA Graduation Date: Jul 1996

Degree: Bachelor of Science

GPA:3.00

Experience

1) Consultant, Sense Corp, St. Louis, MO Job Duration : Jul 2007- Present

Business Systems Analyst, Centene, St. Louis, MO

a) Created technical documentation for the ETL developers integrating vendor flat file data into client’s slowly changing dimension (type 2) Enterprise Data Warehouse including source to target mapping, lookups, error handling techniques, net change process, insert and update strategies

b) Analyzed existing clients reports and converted them from Crystal reports to Business Objects Webi reports

Generated new testing plans, PL/SQL scripts and performed unit testing for data integrity and containing level 1 data validation checks for integrated data against client EDW

d) Performed data profiling as a part of data analysis during integration of vendor data into client’s system to establish required data quality

e) Drafted design documentation and created new reports using Business Objects Webi based on scope, business requirements, and technical specifications for state reporting requirements

f) Developed implementation plan and process flow model for integration of vendor data into client’s system

g) Established repeatable procedures for gathering production data from vendors to meet client’s data structure

h) Performed impact analysis of data integration for business owners, end users and developers

Technical Analyst, NetSpend, Austin, TX

a) Created new tables and lookups, scripted functions and made code changes on client database using Oracle PL/SQL and migrated them to production environment

b) Handled ETL errors and mapping changes using Oracle Warehouse Builder in a financial data mart

c) Created help documentation for use by vendors and business users to explain and outline the vendor file submission to the EDW

d) Worked with ETL support and maintenance to make sure all processes are running as per schedule

e) Participated proactively and provided critical last minute support for deliverables even while working under pressure to deliver results

2) Graduate Assistant, Texas A&M University, Mays Business School, College Station, TX Job Duration : Aug 2005-May2007

a) Maintained and updated infoadvising.tamu.edu website and database.

b) Instructed undergraduate laboratory sessions for INFO courses and grade assignments.

3) Team Leader - Creative Analyst, Intrasoft Technologies Pvt. Ltd., Calcutta, INDIA Job Duration : Apr 2004-Jun 2005

a) Led a team of 5 analysts to research, analyze, and interpret statistical data from multiple sources including web site performance trends and path analysis activity.

b) Increased user traffic 2 folds by implementing customized changes to increase site effectiveness.

c) Prepared long term business plans for website development and presence.

4) Management Trainee - Marketing, NetGuru India Pvt. Ltd., Calcutta, INDIA Job Duration : Feb 2003-Feb 2004

a) Sold and marketed multimedia, computer based training, graphics and 3D design, and web page development tools to new and existing clients.

b) Acquired projects worth over Rs. 5 million and obtained 2 high value long term clients for the company.

c) Coordinated with all development teams to ensure on time delivery and maintenance of finished products.

Academic Projects

Data Warehousing Project - Dominick’s Finer Foods Database, Texas A&M University, College Station, TX

a) Design, development and implementation of a Data Warehouse in MS-SQL Server 2005 and reporting for strategic business decision-making for a retail store, using SQL Server Analysis & Reporting Services.

Data Mining Project - KDD Cup 1998 Dataset, Texas A&M University, College Station, TX

a) Predictive modeling and validation of promotional campaign data using Regression, Neural Network and Decision Tree Models with SAS Enterprise Miner and JMP, for selection of targeted donor base to increase campaign effectiveness.

Skills

Software: ORACLE PL/SQL; TOAD for Oracle; Oracle Warehouse Builder (ETL); Business Objects Webi & Designer; Informatica (ETL); SAS Enterprise Miner; SAP R/3; Microsoft SSIS

Leadership and Honors

CED Scholarship – Mays Business School, Texas A & M University,Apr 2006

University 2nd Rank Holder – MBA, Burdwan University, INDIA, Jul 2002

Work Authorization Statement

Currently on H1B Visa

Contact this candidate