PROFESSIONAL SUMMARY:

• 14 years in Confidential - Senior DBA/Developer of SQL Servers (Versions 6.5, 7.5, 2000, 2005, 2008,2012), Netezza, ORACLE 10i, DB2 UDB
• 14 years of stored procedures and scripts development, including analysis and programming using T-SQL, MDX, PL/SQL, Shell scripting, VB.NET, .NET
• 9 years of developing DTS, SSIS, SSRS, and SSAS
• 4 years of ETL, using Informatica Data Mart, Power Designer, Informatica Power Center
• 9 years of data modeling using Erwin, Embarcadero, ER-Studio and Sybase Power Designer in data warehouse design, including CRM, SAP, PeopleSoft, Siebel Analytics
• 2 years of SharePoint administration/development
• 2 years of Hyperion administration and development

TECHNICAL SKILLS:

Data Warehousing: ETL, T-SQL, MDX, ODS, MS SSIS/DTS, SSAS/OLAP, Netezza, Hyperion, SharePoint, Informatica Data Mart, Power Designer, Informatica Power Center, SA-designer, CA- AllFusion Erwin Data Modeler, ER-Studio, Embarcadero

Databases: SQL Server 2008, 2005, SQL Server 2000 SP3a, 7.0 SP 3, 6.5, Pervasive SQL 8.1, WATCOM 3.x, SQL Anywhere, DB2 UDB NT and AIX, Teradata, SYBASE 12.9, ORACLE 10i

Operating Systems: Microsoft NT, LAN Network, Windows 2000, XP, UNIX HP &AT, Confidential OS2/Servers and AIX, PC, PC DOS

Languages: T-SQL, MDX, PSQL, SSIS, SSRS, SSAS, OLAP, DTS, PL/SQL, Triggers and Stored Procedures, NET, VB.NET, MS SharePoint Server 2007(MOSS), Rational Rose, ClearCase, ClearQuest, SourceSave, PowerBuilder 6&7,8, PFC, Distributed PB, Web PB, Cornerstone Framework, Silverstream, XML, SQL, SAP ALE & RFC, SAP BW

Legacy Databases: DB2/DBA; DB2/SQL V7; CA-Platinum, BMC DB2, ADABAS/DBA PREDICT, AS-400

Legacy Operating Systems: Confidential 3080, 3090x, XA, MVS JCL, TSO and batch, OS/ DOS/ VSE/MVS/ESA, OS / JCL / ISPF, Confidential Utilities, VSAM, IDCAMS, Endevor, WSF2, CA-7, Omegamon/DB2, Omegamon/MVS

Legacy Languages: COBOL, CICS Command, DYL280, SAS, EASYTREIVE, ADABAS/ NATURAL 2, RPG and Assembler

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Business Intelligence Developer

Responsibilities:

• As Confidential provide development and ongoing support, and troubleshooting SQL Server - SSIS packages in
• Dashboard/ Reporting DW for online and kiosks movies, games, and Blue Ray digitals.
• Design and build Reporting Data warehouse database schema.
• Build SSIS packages to load Dashboard Reporting DW.
• Create stored procedures and MDX scripts.
• Build Confidential for Dashboard application.
• Build SSRS reports for BI applications
• Create scripts to extract, transform, load (ETL), to clean and data mine from: SQL Server 2012, 2008 R2 databases, Access databases, Excel, Flat Files, and XML.
• Extensively use MS BI stack (SSIS, SSAS, T-SQL, MDX) in SQL Server 2012 and 2008 R2.
• Confidential provide development and ongoing support, and troubleshooting SQL Server - SSIS packages in
• Dashboard Reporting DW for hospitals and health care institutions.
• Design and build Reporting Data warehouse database schema.
• Build SSIS packages to load Dashboard Reporting DW.
• Create stored procedures and MDX scripts.
• Build Confidential for Dashboard application.

Confidential

Business Intelligence Analyst/ Developer/DBA

Responsibilities:

• As BI Analyst provide ongoing support and troubleshooting for production support of SSIS packages and
• Confidential in creation analytical business forecasts for hospitals and health care institutions.
• Extensively use MS BI stack (SSIS, SSAS, T - SQL) in SQL Server 2008.
• Provide ETL design and development for ongoing projects in EDW.
• Build BI Analysis cubes.
• Create scripts to extract, transform, load (ETL), to clean and data mine from: SQL Server 2008 databases, Access databases, Excel, Flat Files, and XML.

Confidential

Data warehouse Developer/DBA

Responsibilities:

• Worked on ETL design and development for ongoing projects in EDW.
• Create the scripts to extract, transform, load (ETL), to clean and data mine from:
• Netezza, DB2 UDB on AIX, UDB, AS - 400, ORACLE, Access databases, Excel, Flat Files, and XML.
• Create and modify ETL processes to accommodate changes in source systems and new business user requirements for EDW reports in Microstrategy.
• Map source system data to EDW, and develop the staging areas, recoveries, data cleansing, fact and dimension tables, slowly changing dimensions, conformations, and use of surrogate vs. natural keys.
• Define and capture metadata and rules associated with ETL processes. Apply Data Warehousing theory and techniques.
• Troubleshoot ETL job failures during regular business and after hours.
• Use SSIS/DTS, T-SQL, PLSQL, Netezza SQL, Informatica Power center, SQL 2005 in 64 bit environment, SSRS and SSAS.
• Created SSAS project, identified data sources, cubes, dimensions, and mining model deployed to
• EDW databases, and SSRS utilizing EDW databases as the sources, troubleshoot the issues, and performance.
• Work responsibly together with the other team members to provide the success of the EDW/BI solution.
• Work with key members of various departments to determine the definitions of essential data. Provide quality and timely work for full customer satisfaction.

Confidential, Chicago, IL

Consultant/DBA/SQL developer

Responsibilities:

• Performed MS SQL server 2005 32 and 64 - bit, 2008 installations and upgrades, troubleshoot the issues, worked on improving the performance.
• Applied patches, and implemented SQL Server 2005 Server failover clustering.
• Converted 16 large size digital X-Ray images databases to MS SQL 2005 EDW, involving database redesign, stored procedure changes, data conversions issues, jobs creation, used CA ERwin Data Modeler r7.3, T-SQL, SSIS/DTS, SQL server Jobs.
• Created logical and physical data models and performed inventory of data objects and data quality assessment, using Embarcadero ER-Studio.
• Identified data sources, cubes, dimensions, and mining model deployed to EDW, using SSRS and SSAS, utilizing EDW as a source;
• Created ETL to load DW Stage, using Informatica Power Center 8.11 and PSQL Integrator to connect to different sources;
• Worked with management and programming team to ensure that deliverables are met on time, on target and on budget.

Confidential , Chicago, IL

SR. DBA/Developer

Responsibilities:

• Upgraded test, stage and production data environments from SQL Server 2000 to SQL Server 2005 64 - bit, virtual servers, and maintained test, stage and production data environments.
• Managed the distribution, replication and archival of enterprise data.
• Maintained Clustered and mirrored servers, supported BACKUP and RECOVERY and created server s jobs to alert team s members by e-mail and pager to check on backups and space issues.
• Converted DTS packages into SSIS packages, using T-SQL, MS Access and SQL databases, Shell scripting,
• Informatica Power Center 8.11 to design ETL processes to load DW, and created stored procedures for SQL Server 2005 and Oracles 10i, 10G RAC databases to develop custom and dashboard reports for Intranet applications, using PSQL V8 and PSQL Integrator, T-SQL.
• Designed and architected solutions using content management, portal, search, form services and custom code within the platform (Sharepoint Services 3.0 and Sharepoint Server (MOSS 2007).
• Provided administration and development to manage Intranet sites and applications for company staff and clients, and investigated and alleviated application related performance problems by resolving critical issues for 24/7 production environment s support, and worked closely with management and with the programming teams, ensuring deliverables are met on time, on target and on budget.