Consultant – SQL Server SSIS developer/Architect
Project 19
Designed strategies for ETL audit, load balance, exception handling and high
data volumes.
- Provided expertise in Datawarehouse and Data Marts methodologies as well as
extensive knowledge of OLTP/OLAP technologies.
-MDX development/conversions (Excel Business Functions)
- Developed SQL Server Integration Services (SSIS) packages to transform data
from SQL 2000 to MS SQL 2005
- Created interface stored procedures used in SSIS to load/transform data to the
database.
- Reconciled data for transformation from SQL 2000 to SQL 2005 using SSIS.
SOUTHERN COMPANY (Southern Nuclear/Conventional Energy Group) : (Birmingham,
Alabama)
August 2007 – Feb 2008
Consultant – SQL Server Architect, SAP BW Architect , BI Subject Matter Expert
Project 18
Design approach for End User access to the SAP BUSINESS INFORMATION
WAREHOUSE.
Scope and estimate requests.
Developed naming and development standards across all artifacts.
Forecast storage, workload and scheduling capacity.
Provided standard documentation for all phases of report development.
Provided a high level solutions, partnering with end-users in the resolution of
reporting problems or in the deployment of new reports.
Demonstrated 2 Node Failover Cluster (active to passive node) for SAP BW
environment (with SAP Central Instance on second node) connected to a SAN.
Integrated Office Performance Server (score carding, analysis and planning) with
SAP BW.
Use Reporting Services 2005 / Analysis Services 2005 (including MDX
developement) to reports directly access SAP BW environment.
Designed and developed ETL processes extracting data from MYSAP environment to
SAP BW environment.
Demonstrate initiative in resolving problems, balancing conflicting requirements
and priorities
Mentored business users and BI developers
Technologies: SAP R/3 ,SAP Netweaver Application, SAP Central Instance Server,
BI Visual Studio 2008, Proclarity Suite 6.3 ,Office Performance Server
,SharePoint 2007,Excel Services, SQL SERVER 2005 PLATFORM: Reporting Services
(SSRS),Analysis Services (SSAS),Integrated Services (SSIS)
GENERAL MOTORS (Norwood, MA and Detroit, MI)
Sept2006 – August 2007
Consultant – Project Manager/Sql Server Architect
Project 17
Worked with both business and internal IT customers to complete an incomplete
project plan for release 2 version of an Enterprise Application/Data Warehouse.
Worked with a team of business analysts, data architects, application
developers, ETL developers and testers, My objective was to deliver projects
within scope, time and costs while following department standards, methodologies
and guidelines.
My Duties include
•Develop and maintain detailed project plans and budgets using Microsoft
Project.
.Mentor developers on standard and practices of Data Warehouse
•Manage and coordinate a team of various technical resources
. Design/ developing SSIS (ETL)/SSAS (OLAP) MDX developing components.
•Manage customer expectations by clearly documenting and maintaining project
deliverables, plans, and status throughout life of the project.
•Frequently travel to customer sites to present project status and address
customer concerns.
Technologies Utilized – SQL SERVER 2005,SQL SERVER 2000, ERWIN, MICROSOFT
ANALYSIS SERVICES (SSIS),MICROSOFT ANALYSIS SERVICES (SSAS) ,REPORT SERVICES
2005..NET VISUAL STUDIO 2005(BI Visual Studio). BI (Business Intelligence) Tools
: Business Scoreboard Manager / Cognos /Microsoft Office Pivot Tables.
LIFEWAY (Nashville , TN)
Aug 2006 – Sept 2006
Consultant - OLAP Data Warehouse Developer/Architect (SSIS/SSAS Development)
Project 16
The objective was to build a cube (business requirements including KPI’s were
already declared before development) and mentor internals on procedures.
Migrated data from SAS environment to SQL Server 2005 via SQL Server Integrated
Services(SSIS) . Applied conversion and transformation procedures according to
business requirements. Designed and built cube (SSAS) and MDX developing with 10
dimensions in addition built partitions spanning 8 years by month (wrote .net
component utilizing the AMO layer specific to calendar/fiscal time slices
generated partitions automatically ) Added 3 perspective views and 3 drill
through action objectives. . . BI (Business Intelligence) Tools : Business
Scoreboard Manager ,BI Visual Studio 2005, Reporting Services 2005 (SSRS) /
Proclarity 6 /Microsoft Office Pivot Tables,
HARLEY DAVIDSON (Milwaukee, WI)
March 2006 – Aug 2006
Consultant - OLAP Data Warehouse Developer/Architect (DTS/MSAS/SSIS/SSAS
Development)
Project 15
Responsibilities
• Migrated DTS objects to SQL Server Integrated Services(SSIS) (BI Microsoft
Visual Studio 2005) environment
• Migrated SQL SERVER 2000 DATABASES objects to SQL Server 2005
• Migrated Microsoft Analysis Services to SQL Server Analysis Services (SSAS)
(BI Microsoft Visual Studio 2005)
• Deploy/Design cubes in SSAS environment Snowflake/ and Star Schema Designs
• Redesign/ Deploy reports using Report Services 2005 (BI Microsoft Visual
Studio 2005)
• Make modifications/and add new MDX queries to cubes
• Manage /Rebuild Partitions for cubes
• Wrote .Net application to process and rebuild multiple cube(s) partitions.
. BI (Business Intelligence) Tools : Business Scoreboard Manager, Microsoft
Office Pivot Tables/Cognos
SUNTRUST BANK (Atlanta, GA)
October 2005 – March 2006
Consultant - Data Warehouse Developer/Architect
Project 14
• Designed and implemented ETL processes to make data available for reporting
purpose within a data warehouse.
• Designed, administrated and developed Star Schema Datamarts
• Responsible for identifying and translating business requirements for the
Enterprise Data Warehouse into logical and physical
data models.
• Designed, test, implemented and maintained the Data Warehouse across
multiple platforms, technologies and computing environments. Performed daily
database administration, which included table design and maintenance.
• Responsible for producing information models that represented the business
problem to be solved with regard to: data content, data relationships and
structure, processes that managed, transformed data, business rules that govern
data, and durations for which data is utilized or required.
• Created objects, attributes, relationships and responsibilities that
represented the core abstractions involved in business and technical services for
the enterprise.
• Translated business rules and data processing activities into requirements
and models suitable for system design and development.
Technologies Utilized – SQL SERVER 2005,SQL SERVER 2000, ORACLE 9I, ERWIN,
MICROSOFT ANALYSIS SERVICES (SSIS),MICROSOFT ANALYSIS SERVICES (SSAS) ,REPORT
SERVICES 2005..NET VISUAL STUDIO 2005.
. BI (Business Intelligence) Tools : Business Scoreboard Manager ,Crystal Report
/Report Services / Microsoft Office Pivot Tables
AFLAC INSURANCE (COLUMBUS,GA)
August 2005 – October 2005
Consultant – SQL Server Developer, Migration Architect
Project 13
Optimized all web site databases, which resulted in substantial performance
gains.
Optimizations included table redesign, indexing, query rewrites, and stored
procedure rewrites. Used QUEST –SPOTLIGHT ,SQL PROFILER to identify bottlenecks.
Review existing stored procedures and optimize code. Technologies Utilized SQL
Server 2000
BAPTIST HOSPITAL GROUP (PENSACOLA , FL)
March 2005 – June 2005
Consultant – OLAP SQL Server Developer/SQL Server DBA/ Warehouse Architect/
Project Management
Project 12
Ran project including creation of project plan using Microsoft Project,
assigning tasks to programmers, analysts, running project meetings including
attending meetings with hospital departments to stay abreast of the latest user
requirements and changes to any existing data warehouse requirements. Involved
in organizing and assisting in testing, certification, and post “go-live” tasks.
Used many Microsoft Office tools such as Excel spreadsheets, Microsoft PowerPoint
presentations, Word, etc. to get the project completed within time frame.
Project : Build core infrastructure of Data Warehouse - Defined technology
planning requirements, objectives, architectural principles, goals and standards
for enterprise data warehousing. Ensured management development approach were
aligned with the architecture strategy, standard technologies and design
principles by delivering weekly updates. Coached partners and direct managers and
staff at all levels. Technologies involved Windows Sever 2003, Microsoft
Sharepoint, .NET 2003 Visual Studio , SQL Server 2000, Reporting Services(MSRS)
2000,Microsoft Analysis Services(MSAS) MDX developing, Web Services , Microsoft
Project, Microsoft Vision and DTS. Build and administrate a 2 node cluster on a
Windows 2003 Server. BI (Business Intelligence) Tools : Crystal Reports /Report
Services / Microsoft Office Pivot Tables
TEKSYSTEMS: MEDDATA: (2 Month Contract) (New Orleans, Louisiana)
February 2005 – March 2005
Consultant - SQL SERVER DATABASE ARCHITECT
Project 11
Worked on large transactional processing application. Primary role assess
current application database designs and make recommendations to design, build
and tune large transactional databases for core business applications and
development “SQL SERVER BEST PRACTICES”.
GENERAL ELECTRIC (MEDICAL DIVISION) (3 month contract) (CHICAGO, ILLINOIS)
SEPTEMBER 2004 – DECEMBER 2004
Consultant – SQL Server Developer/SQL Server DBA/Architect
Project 10
Write procedures to prepare databases for replication. Design transactional
replication for 16 databases. Provided technical support in implementing transfer
knowledge base to IT staff-All work was done remotely.
U.S. BANK (4 month contract) (ST LOUIS, MISSOURI)
August 2004 – December 2004
Consultant – OLAP SQL Server Developer/SQL Server DBA/WareHouse Architect/
Project Management
Project 9
• Managed a team of sql developers and database designers in the design and
implementation of a OLAP Reporting environment which would service 600 users in
18 different office locations (national/international) . -Provided guidance and
technical assistance to team members on an on-going basis throughout the duration
of the project(s). This included training less experienced analysts/programmers,
directly monitoring work activities, and providing performance feedback for
quality review purposes.Provide database management support to include
implementation and administration of 30 SQL Server's across the enterprise.
Responsibilities also include using Quest Software for monitoring and
administering the system. Conducted performance monitoring and measurement
including: Tuning & Performance Monitoring: executing DBCC Commands, Sizing
Procedure cache, Sizing Data cache, configuring locks and Transaction Isolation
levels and Index Management. Monitor volume (hard drive) space. Wrote (T- SQL)
and fine tuned complex stored procedures. Strategically designed and implemented
data warehouses, data marts, and data stores, while ensuring high levels of data
availability. Designed and developed data warehouse datastores, and analyzed
business requirements, developed target-source data mappings and delivering ETL
processes for end-user OLAP and reporting initiatives (Used report services as an
OLAP client schedule reporting tool ). Installed/administrated SQL SERVER
REPORTING SERVICES, created schedule reports and delivered via email.
BI (Business Intelligence) Tools : Crystal Report /Report Services / Microsoft
Office Pivot Tables
|
