Summary

• Senior IT professional with over 13 years of experience.
• Experience in a cross section of industries such as Financial Services.
• Healthcare, Telecom, Charity and Professional services.
• Successful in coordinating complex projects involving cross-functional resources.
• Worked on Datawarehouse/Business Intelligence technology for over 11 years, excellent analytical, communication, negotiation and project leadership skills.
• Solid background in database conversion, data extraction, transformation, and loading ETL
• Extensive knowledge and experience of Kimball Methodology
• Extensive SQL development experience.
• Extensive expertise in Oracle and SQL Sever databases.
• Database design, development, configuration and performance, and all phases of traditional data warehouse life cycle
• Advanced extensible reporting skills using SQL Server Reporting Services SSRS , Cognos and other reporting tools
• Managed a large project at Verizon for the Financial Services Enterprise Data Warehouse.
• Expertise in Project Management and Business Processes Modeling techniques.
• Advanced Systems and Business Requirements Analysis capability
• Experience in creating and monitoring aggregates
• Broad knowledge of technology tools.
• Demonstrated ability in designing and MDM and ERM database modeling, with the ability to assess risk and develop mitigation strategies.

Technical Skills

• ETL TOOLS: DTS, Informatica, DataStage, DissionBase, Data Juction, Decision Manager, Data Manager, SSIS
• DATABASE DESIGN/ BUSINESS PROCESS MODELLING TOOLS: Erwin, Visio, Micrografix Flow-Charter, UML, ER Studio
• DATABASES
• Sybase, Oracle, Microsoft SQL Server
• OLAP Tools: Business Object, Brio, MicroStrategy, Crystal Report, Cognos 7 and Cognos 8
• PROGRAMMING LANGUAGE: PL/SQL, SQL, VB Script, Visual Basic, VBA, Transact SQL, ActiveX, Java Script, Java, C , C , ASP, Cold Fusion, HTML, DHTML

Professional Experience

Confidential

SQL SERVER DBA/ Business Intelligence Consultant

• Use SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code
• SQL Server Audit and Actual Execution plan
• Perform DBA duties including: database backups, restores, performance tuning, and capacity analysis
• Generate management weekly, monthly, and quarterly reports by using Congos
• Generate daily operational reports using Microsoft Reporting Services SSRS
• Develop, modify, and optimize stored procedures, triggers to handle business rules and history data Manage the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and SSIS packages.
• Design and implement SQL Server 2005 databases for mission-critical business
• Troubleshoot databases and custom application issues
• Work with end users to define, implement, and maintain their reporting requirements.
• Install, configure and implement SQL Server 2005/ 2008r2 2012 databases for mission-critical business
• Troubleshoot databases and custom application issues
• Participate in the creation, modification and maintenance of database structures.
• Disaster Recovery
• Jobs scheduling using SQL Server Agent
• Manage database users and security: Assigning users to data bases and determining the proper security level for each use also assign permission to the various database objects such as, Tables, Views, and stored procedures
• Configuring/ Maintaining and troubleshooting Linked Servers

Confidential

Business Intelligence Consultant/DBA

• Designing ETL packages/Scripts using SSIS and T-SQL
• Designed and deployed Cognos Reports
• creating database objects
• Troubleshoot and optimized existing Cognos reports.
• Debug, monitor, and troubleshoot code and deployed solutions
• Communicate with key business users before, during, and after the development of analytical tools to ensure adequate requirements gathering, development progress, users acceptance and business process integration
• Data Stewardship
• Creating and managing cube
• Creating and modifying SSIS packages.
• Modified SSRS reports
• Database migration testing
• Creating Stored procedures and Database maintenance
• Performance monitor and troubleshooting
• Database administration

Confidential

Business Intelligence Consultant

• Developed , deployed and delivered dynamic reporting solutions using SQL Server 2005 Reporting Services SSRS
• Gathered, organized, validated, and manipulated data to answer business questions as needed by management and financial team
• Creating SQL Server objects such as Views, Stored Procedures and Functions.

Confidential

Business Intelligence Consultant/ DBA

• Re-designed Financial framework model
• Designed and Developed Financial reports Suites like Commitments, Budget Vs Variance Analysis, Invoice Aging, Project/Category Budgets, Cash flows, Forecast.
• Worked with users and captured data/reporting requirements from business users and prepared Functional Specifications Document
• Wrote test Plans
• Wrote stored procedures
• Troubleshoot performance issues
• Jobs scheduling using SQL Server Agent
• Manage database users and security: Assigning users to data bases and determining the proper security level for each use also assign permission to the various database objects such as, Tables, Views, and stored procedures
• Build SSIS packages
• Designed SSAS Cubes

Confidential

SNR Business Intelligence Technical Consultant

• Worked on Qatar National Education Data System QNEDS project
• Develop Cognos Framework packages
• Designed Analysis Studio, Metric Studio and report Studio reports and Dashboard for users such as Supreme Education Council's staff, school principals, parents, students and others involved in the education field.
• Working with users and coordinating with application developers to understand and capture data/reporting requirements
• Responsible for Software testing. Documentation / Training for both technical non-technical end users.
• Responsible for designing a Multilingual Cognos environment to support English and Arabic in Cognos framework manager, also created multilingual reports and dashboards Arabic English utilizing Cognos report studio.
• Cognos Metrics Manager configuration
• Designed and loaded Metric Packages.
• Designed and implemented Cognos Environment and Portal Security Architect Model ensured data confidentiality and privacy agreed within the Supreme Education Council .
• Cognos installation and administration,

Confidential

SNR Business Intelligence Consultant

• Taking business requirements including reporting specifications and mock-ups, and turning them into reporting designs and translating these designs into functioning reporting solutions.
• Designing and implementing Requirement specification document
• Designing and implementing Reports designs standards
• Designing and modifying Reports data validation, Accruals and forecasting reports using Microsoft Reporting services SSRS
• Designing Data Models using Report Builder
• Designing Cubes using Analysis services SSAS
• Administering SharePoint Server MOSS
• Creating users and groups in Active directory AD
• Designing and implementing security between Active Directory, MOSS, SSRS and SQL Server 2005.
• Modifying Solis Reports
• Unit tests reports to ensure they are delivered and run in a system testing environment.
• Perform integration and system testing.

Confidential

SNR Data warehouse Developer

• Developed, enhanced and maintained information flow in the warehouse
• Ensured Data quality like designed reconciliation traffic light and exception reports that compared the source data to the warehouse data
• Member of Alliance Boot change management Board
• Analyzing requirement for new projects
• Designed, Development and maintained of new SQL Server Analysis services Cubes
• Designed and developed marketing, sales summary, profitability and KPI reports, including weekly sales and script trackers to Alliance Boot Board members via Blackberry.
• Liaison with external marketing data providers like IRI, ACN, IMS and provide data extractions as specified by the companies
• Assisted business teams in identifying, modifying and establishing business processes and business rules
• Redesigned both the staging and target database models to support project requirements
• Liaison with BOOTS Sap Bw team to provide monthly EPOS sales, supplier and matching products data extractions formatted as required by the business and team.
• Data warehouse Capacity and performance management
• Developed and maintained ETLs utilizing Cognos Data manager, Decision Stream, DTS and SSIS
• Developed the detail design specifications for the extraction, transformation and load processes
• Developed System documents
• Data warehouse Administration and management

Confidential

Project Lead/DBA

• Led team on Sybase to SQL Server Migration.
• Project Plan Creation, Management, problem resolution initiatives, and Reporting.
• Responsible for directing and monitoring the work of team members.
• Conducts team meetings regularly to assess project status from every contributor.
• Oversees and performs all quality assurance techniques and procedures to ensure the quality goals and objectives are met.
• Database administration, maintenance, capacity planning and performance monitoring/ tuning.
• MDM modeling using Erwin
• Interacted with CRM R/3 Consultants to understand the basic flow of data in the source system.
• Monitors and ensures adherence to service levels.
• Maintains issues tracking and reporting databases, spreadsheets.
• Migrated Sybase Data to SQL server with SSIS
• Participated as a team member in discussion with business analysts and end users for Data Modeling of Business Content, Granularity, and Performance Tuning.
• Created ODS, Info cube, Update rules and the corresponding info objects based upon the data source available in the source system.
• Developed Scorecards flexible queries using filters, navigational attributes in BEX analyzer and Cognos to facilitate data analysis in a drill down or summarized way to give detailed levels of information
• Created Crystal reports and workbooks based on client requirement e.g. MIS reports, Patients Care plans .
• BW Production support, Performance Tuning using aggregates, indexing, in addition monitored and rescheduling of process chains, data loads and debugging of transfer, update and start routines.
• Advised Basic team on resolving Sap Bw performance issue like data blocking, data statistics, and indexing and SQL Sever errors
• Created stored procedures, triggers and view using T-Sql
• Assisted in changing embedded Sybase codes in ASP .Net application to T-SQL.
• Coordinated and developed detailed work plans, schedules, project estimates and status reports.
• Manage and maintain Vitas real-time transactional database
• Ensured adherence to quality standards and reviews project deliverables.
• Provided technical and analytical guidance to project team.
• Communicates with project stakeholders, senior business manager s and/or senior technology manager s , regarding status of specific projects

Confidential

Technical Lead/DBA

• Provide Technical advice for ARC Prove of Concept POC .
• Mapped Teradata datatype to SQL Server Datatype
• Migrated Teradata Warehouse schema to MS SQL Server
• Migrated data from Teradata to SQL Server using DTS
• Migrated Teradata Views and scripts to MS SQL Server
• Converted Teradata sql codes to MS Sql T-SQL codes
• Performed Performance baseline Established performance baseline by running the sql queries which are the queries executed by Business Objects reports.
• Capture performance data to include reads, writes, cpu cycles, and duration.
• Analyzed Indexes and made recommendations
• Performed Comparative Analysis
• Wrote Reports and Documentations.
• Designed and implemented Disaster recovery plan
• Designed decision support model

Confidential

Senior Database Administrator Consultant MCDBA

• Researched existing standards like change management, coding and security and identified how these evolved to include new ideas and prepared contributions to appropriate standards bodies and present these to the standards groups
• Solved performance related issues and conducted performance checks on databases
• Created SQL Server email alerts using SMTP
• Assisted in Data Conversion Migration using Microsoft DTS
• Created Reports using SQL Web assistance
• Wrote stored procedures to maintain/monitor SQL Server and Databases
• Wrote several DTS packages for data extraction and loading into SQL Server tables.
• Wrote stored procedures, triggers, functions, views, using T-SQL
• Wrote migration script in T-SQL and VBScript/ActiveX
• Review VB codes and modified .Net applications due to performance issues.
• Designed and built the data feeds using DTS packages and transact-sql stored procedures and functions
• Provided technical support to application development / Network teams
• Implemented and enforced security and change management procedures
• Set up, monitor and troubleshoot replication
• Administered all database objects, including tables, clusters, indexes, views, sequences, packages and procedures to ensure space

Environment:

Microsoft Office Suite, Microsoft Project, Erwin, Microsoft Visio, SQL Server, ASP, Visual Basic, VBScript, Transact SQL, HTML, Visual Source Safe .Net

Confidential

Lead DBA/Data warehouse Architect

• Maintained the Enterprise Data Warehouse and supported data warehouse team.
• Managed and mentored a team of database administrators
• Developed and maintained Analysis Services cubes
• Developed and used strategies and procedures for Cleaning, Extraction, and Transformation of Data. Using Microsoft DTS/ Informatica
• Developed and supported Brio environment by developing Brio Reports and maintaining Brio OnDemand and Broadcast servers
• Provide 24/7 Data warehouse support. Created alerts and notifications
• Troubleshooting, maintenance, Performance Tuning and Server Installation.
• Create Stored procedures, Trigger and view with T-SQL
• Performance monitor and troubleshooting
• Data Migration Lead
• Designed Data Mapping document.
• Troubleshoot and modify .Net codes
• Troubleshoot and modify ASP pages
• design and build the data feeds using DataStage
• Planned, developed and implemented Knowledge Management System.
• Planned, and developed and implemented Change management and Requirement System.

Environment: Microsoft Office Suite, Microsoft Project, Microsoft Visio, eroom, Arc View's Geographical Information System GIS , GroupWise , Erwin, Magic. Microsoft SQL, Sybase Visual SourceSafe, Microsoft SharePoint Server, Seagate Crystal 8.5/9.0, MS Excel, Brio, Informatica, DTS

Confidential

Integration Architect

• Conducted an independent assessment of the overall VETSNET system in order to determine whether or not VETSNET, as currently designed, can support its projected workload.
• Reviewed the VETSNET architecture design to determine whether the application architecture, Oracle database, middleware, and Tuxedo applications are being implemented in a manner that will meet workload projections.
• Prepared design documents from the Business Requirement and identified the relevant data targets for satisfying the customer requirements
• Evaluated statistical performance using BW Statistics and suggested recommendations to Basis support for optimization. Improved data load and query performance by doing Compression, creating Aggregates, Indexes, Data packet size, parameters, table spaces, and partition,

Confidential

Lead Data warehouse Architect

• Designed an Enterprise Financial Data Warehouse for Verizon.
• Designed and implemented SQL Server 7 Data Warehouse utilizing Kimball Methodology.
• Installed Microstrategy DSS Agent and created over 50 reports
• Responsible for Technical definition of the data warehouse environment, providing platform, database and infrastructure design.
• Performed business requirements analysis necessary to design and construct the technical architecture to support the solution.
• Performed and designed technical architecture solutions, which consist of an operational data store, data warehouse, data marts and associated delivery mechanisms.
• Created SQL Server Alerts and job notifications
• Wrote stored procedures, views and triggers in T-SQL
• Defined and implemented the architectural components including RDBMS, operating system platform, hardware and tools. Developed data requirements, data maps, transformation rules, and aggregation plans.
• Defined strategies for data extraction, hygiene, acquisition, and loading.
• Worked with the client and Data Architect to implement and refine data quality best practices.
• Developed ETL Packages using DTS with ActiveX and Custom Tasks.
• Was responsible for Quality implementation by development and execution of detailed test plans, knowledge transfer and delivery of operational best practices.
• Worked with the client technical team on the definition and planning of system implementation and growth forecasting.
• Defined and implemented monitoring systems to perform load validation.
• Created and maintained metadata, and ensured overall data integrity.

Environment : Microsoft Office Suite, Microsoft Project, Microsoft Visio, Erwin, Rational Requisite Pro, Microsoft SQL Server, Sap BW, Oracle, SQL, Transact SQL, VBScript, ActiveX, Seagate Crystal, MS Excel, Microstrategy, DTS

Confidential

Senior SQL DBA/Developer

• Worked closely with the system architect and developer leads to coordinate project efforts.
• Represented the CRM team in DBA issues.
• Assisted in overall QA efforts for CRM projects, including attending project review meetings and developing database test environments.
• Worked with Developers in development and beta environments, advising them on database issues and assisting them with database changes and stored procedures.
• Incorporated data from a variety of sources into a common database, i.e. extending database tables and managing integration efforts between multiple applications that share the same database.
• Wrote stored procedures, views and triggers in T-SQL
• Wrote several DTS packages for data extraction and loading into SQL Server tables.
• Migrated from Oracle 7 to Oracle 8.16
• Managed all routine DBA tasks i.e. Security Management, Database Modelling, Database Migration, Database Performance tuning, Release management and support, Database Maintenance, Developing and monitoring DTS packages, Production Support, Backup and Recovery, Planning, setting up and monitoring Replication.

Environment: Microsoft SQL, SQL, Transact SQL, DTS