A.J. Minhas

acctee@r.postjobfree.com

Address:

**** *** *** **.

Melbourne, FL 32940

954-***-****

OBJECTIVE

I would like to use my experience in Information Technologies, Data

Analysis and Data Analytics to help the organization in meeting its

objectives and goals. I would also like to train and mentor junior

associates to help them grow and realize their potential.

EDUCATION

University of Miami, Coral Gables, FL

M.B.A., December 2005

University of Maryland, College Park, MD

B.A., December 1985

EXPERIENCE

DiBell Group/Harris Corporation - Melbourne, FL

Data Warehouse Developer and Business Intelligence Developer, 11/2012 to

01/31/2014

. Modeled, designed, developed and implemented Dimensional

Schema for Facts and Dimensions into HR Metrics Data Warehouse in

SQL Server 2008 R2

. Developed SSIS packages for numerous ETL processes to extract,

cleanse and load HR Metrics data from Peoplesoft HR into HR Metrics

Data Warehouse in SQL Server 2008 R2

. Maintained and supported Cognos 10 reports for HR Metrics

reporting of headcounts, diversity and turnover

. Maintained and supported Tableau 8 workbooks for HR metrics

domestic and international headcounts geographic charts and reports

. Developed HR Metrics HeadCount Cube for testing and data

verification in Microsoft SSAS in SQL Server 2008 R2

Apex Systems/Abacus Technology - Kennedy Space Center, FL

Data Warehouse Developer, 09/2010 to 11/2012

. Developed SSIS package for ETL process to load CMS &

Allocations data for Cubes

in SQL Server 2008 R2

. Replicated, developed and deployed new Project Management Cube

in SSAS in SQL Server 2008 R2

. Developed and deployed new Project Manager Labor and Materials

Reports in SSRS in SQL Server 2008 R2

. Created T-SQL scripts to maintain, cleanse and extract data in

data warehouse for IMCS data warehouse in SQL Server 2008

. Developed and maintained reports, maintain cube using Visual

Studio 2008

. Developed and maintained SSAS objects in cube, i.e. dimensions

and measures for IMCS data warehouse in SQL Server 2008

. Developed and maintained SSRS reports in IMCS data warehouse

in SQL Server 2008

. Developed and maintained tables, indexes, stored procedures

and functions in IMCS data warehouse in SQL Server 2008

FAME, Inc, Fort Lauderdale, FL

Data Conversion Specialist/Data Analyst, 11/2009 to 09/2010

. Created ETL SSIS packages for data conversion

. Developed and imbedded SQL conversion scripts in SSIS modules

. Converted educational school data from legacy source

to Advantage model

. Debugged and troubleshot conversion data for accuracy and

consistency

. Created mappings and translations from source to Advantage

. Developed a position paper and tool selection matrix for

future conversion process.

Southern Wine and Spirits, Miramar FL

Data Analyst and Reports Developer, 02/2009 to 07/2009

. Met with users to establish reporting requirements

. Created reports (RDLs) using Visual Studio 2005 and published

reports (SSRS) into Report Server

. Installed and configure Report Server on SQL Server 2005

. Developed and implement complex stored procedures and scripts

for reports in SQL Server

. Developed packages in Integration Services (SSIS) to extract

source data into target reporting tables and install and schedule

them in SQL Server

Spirit Airlines, Miramar FL

Business Intelligence Developer and Analyst, 04/2007 to 02/2009

. Met with Marketing, Sales, Accounting and Operations

departments to establish requirements for various projects

. Collaborated with business units to ensure deliverables were

met

. Developed and supported complex T-SQL scripts and stored

procedures to fulfill Marketing

& Sales promotions

. Provided ad hoc analytic data and reports to Marketing, Sales

and Accounting Groups

. Converted Crystal 9 reports to SSRS reports on SQL Server 2005

Consultant, Consultis Inc. - Globecast, Miami FL

Database Administrator and Data Analyst, 08/2006 to 12/2006

. Worked with project managers to develop migration strategy and

verify integrity

of the data in the new environment

. Migrate core business process data from Oracle to SQL Server

2000

. Developed extensive DTS packages and stored procedures for

migration

. Created automated reporting processes between Scheduall and

Great Plains applications on SQL Server 2000

. Created transactional replication between sandbox and

development environments

HOPS International/Trap Systems, Miami Lakes, FL

Database Administrator and Data Manager, 11/2005 to 07/2006

. Developed best practices in data management and operations

processes for SQL Server (2005 & 2000)

. Documented, develop and improve database processing, backup

and restore procedures

. Defined requirements and develop designs for new data ETL

processes

. Worked with operations group to implement processes into

production

. Worked closely with data architect and data engineering

group to automate labor intensive processes

Freelance Consultant, Miami, FL

Database Administrator and Data Analyst, 1/2004 to11/2005

. Designed, developed and administered databases and

procedures for SQL Server

. Analyzed data and presented results to marketing and sales

organizations

. Developed automated processes to make technology processes

more efficient

Lakeland Regional Medical Center, FL

Database Administrator, 7/2001 to 7/2003

. Implemented and supported online 24/7 patient accounts

database systems in DB2/OS 390

. Developed processes for backups, restores and reorganization

processes

. Created formal documentation for maintenance of hospital

database systems

. Implemented and supported SQL Server Applications

. Provided backup support to Oracle DBA on Oracle/AIX

applicatons

Freelance Consultant, Tampa, FL

Database Administrator and Programmer Analyst, 1/1996 to 2/2001

. Designed and developed applications accessing database

systems in DB2/OS390

. Designed and developed database structures in databases

. Developed formal procedures for scheduling batch

applications

. Worked with client organizations to develop requirements

Freelance Consultant, Silver Springs, MD

Programmer Analyst and Data Analyst, 8/1993 to 12/1995

. Modified and improved existing applications in large billing

processes in DB2/OS390

. Designed, developed and implemented OLAP systems

. Created formal procedures for scheduling and executing

maintenance jobs

Bell Atlantic Corporation / C& P Telephone Company, Silver Springs, MD

Manager and Programmer Analyst, 6/1987 to 6/1993

. Worked with client organizations to develop requirements and

procedures

. Lead and facilitated team of programmers for various

projects

. Developed, designed and implemented QA procedures for

testing

. Automated and improved testing processes for software

changes

. Modified, supported and enhanced applications in IMS and DB2

on mainframe

SKILLS

. Microsoft SQL Server (2008, 2005, 2000, V.7, V. 6.5), Microsoft

Reporitng Services (SSRS) & Microsoft Integration Services (SSIS),

Microsoft Analysis Services (SSAS), Crystal Reports, Word, Excel,

Power Point, Access, Visio, Outlook

. IBM DB2, data modeling and database design, Cobol/Cobol2, JCL,

MVS/OS390

. Bell Systems Basic Programmer Training Certification (1987)

Contact this candidate