SUMMARY:

• I have a strong desire to learn and explore new concepts. I have good communication and interpersonal skills and will take up assignments with enthusiasm. I am a good team player and have worked well with different teams at multiple customer sites.
• Experience in design, development, and implementation of business solutions
• Over 5 years of experience in Asset Management at Confidential and Confidential with direct development, testing and support responsibilities.
• Experience in all phases of Software Development Life Cycle.
• More than 7 years of experience in SQL Server 2000/2005/2008 /2012 including BI (Business Intelligence) .
• Database backup/restore. Performance tuning and optimization.
• SSIS/SSAS/SSRS - Developed SSIS packages for data transformation from legacy claims processing systems and built Cubes from fact/dimension tables (OLAP). Adhoc reporting using Report Server.
• ETL: Processing of millions of records from databases (extracting, cleansing, transforming, integrating and loading) into data warehouse using SSIS packages. Extensive exposure to ETL tools like SQL Server Integration Services (SSIS), DTS and Data Stage.
• Job scheduling: SQL runtime engine based nightly process scheduling.
• Transact SQL - Tables, Views, Triggers, Indexes, and Cursors.
• SQL development: SQL stored procedures and functions.
• Data modeling--- Erwin data modeling
• Excellent interpersonal and customer relational Skills.
• Capable of working independently and part of teams.
• Experience with the agile delivery methodology.

TECHNICAL SKILLS:

DBMS: SQL Server 2000/2005/2008 , MS Access, Oracle 8i/10G/11G, and Teradata.

ETL Tools: SSIS, DTS, Connect IT.

Excel / VB programming Tools: MS Excel/Word/Power Point, SSRS and Cognos Reporting.

EXPERIENCE:

Confidential, Richmond, VA

Data Warehouse Developer/Systems Analyst (Database)

Responsibilities:

• Design business intelligence (BI) solutions using SSAS.
• Develop automated applications surrounding database data extracts and data cleansing routines using SSIS.
• Perform ongoing database maintenance functions, including data loads, data cleansing. Matching and reporting.
• Create and modify Partitioned Tables, indexes, views, and stored procedures
• Perform quality assurance and system testing on database and systems.
• Review, evaluate, develop, document, implement, and maintain databases.
• Perform requirements analysis and document detailed specifications

Tools: /technologies: SQL Server 2005/2008/2012 , SQL Idera tools Diagnostic, defragment, backup, Team Foundation, Visual Studio 2010, Visio, Erwin data modeling, and IDX

Confidential, Glen Allen .VA

Lead

Responsibilities:

• Accurately identifying, extracting, and analyzing large volumes of data. Extracting data from databases and cleansing, transforming, and integrating it.
• Monthly two enhancements it including testing, change management, releasing to production
• Upgraded Asset Manager 12 times in Development, QA and Production.
• Executing manual processes and automating where feasible.
• Working with business units to coordinate data scope and format requirements.
• Providing production support for bug fixes and enhancements.
• Defining data and reporting requirements for new projects obtained from business and technical leads.
• Collaborating with various levels of staff (including senior management)
• Developing Views and stored procedures to extract data to crate reports using SSRS
• Using SSIS to Import data from different sources

Tools: /technologies: MS SQL server 2005 and 2008, Oracle 11g, MYSQL, Teradata, Asset manager, Connect-IT, Crystal Report XI, HP Service Desk, HP Service Manager, Erwin data modeling, and CG4.

Confidential, Glen Allen .VA

Data Integration / Analysis Specialist

Responsibilities:

• Consolidating, enhancing and overseeing the operations of in-house client adaption processes used to populate a SSAS analytic solution.
• Supporting data analysis services through traditional ROLAP, cube and operational data store environments and creating SSRS reports for business use.
• Communicating directly with business team analysts and providing automation for existing processes and implementing new data discovery and analysis services at the request of the business team.
• Setting up QA environment for performance and functional testing including backup and restore as necessary
• Data mapping.

Tools: /technologies: MS SQL server 2005, Red Get, File zill, Visual Studio, Erwin data modeling, CSV (Source code), Cognos, and JIRA.

Confidential, Richmond .VA

SQL Data Analyst

Responsibilities:

• Accurately identifying, extracting, and analyzing large volumes of data.
• Extracting data from databases and cleansing, transforming, and integrating it.
• Creating stored procedures for reporting/processing data.
• Executing manual processes and automating where feasible.
• Working with business units to coordinate data scope and format requirements.
• Documenting existing processes.
• Providing production support for bug fixes and enhancements
• Defining, in written form, data and reporting requirements for new projects obtained from business and technical leads
• Developing and testing Excel macros using VBA for reports and transferring data using DTS package.
• Collaborating with various levels of staff (including senior management) on numerous reporting initiatives.

Tools: /technologies: MS SQL server 2000, Erwin data modeling, Visual Basic 6.0, and Excel

Confidential, Richmond .VA

Data Analyst

Responsibilities:

• Enhancing and maintaining the Chargeback (Billing and Invoicing) system - creation of jobs using Data Stage Designer to validate schedule run and monitor the Data Stage jobs.
• Using SQL runtime engine to schedule nightly process running the server jobs, monitoring schedules and validating its components.
• Extracting millions of records from Asset management data and cleansing, transforming, integrating and loading data into data warehouse using SSIS package. Also, mapping them in tables for Invoicing and Billing.
• Supporting data analysis services through traditional ROLAP, cube and operational data store environments and creating SSRS reports for business use.
• Performing technical analysis of complete systems and preparing comprehensive system level evaluations.
• Configuration Management, Performance Reporting, Resource Unit Repository, internal invoicing, and external invoicing, and interface with the ERP
• Working on Service Catalog, setting up products for catalog and change data for VITA Requirements.
• Development work on HP Open View service catalog

Tools: /technologies: MS SQLSERVER 2005, SSRS,SSAS,SSIA, Visual Studio 2005, Crystal Reports, Altiris for pulling data, Asset Manager, Data modeling, and Connect IT.

Confidential, Richmond, VA

Data Analyst

Responsibilities:

• Developed stored procedures to extract data for reports rendered in Reporting Services 2005, or for adhoc querying purposes.
• Configured Reporting Services security levels for users accessing reports, also responsible for troubleshooting errors on the reporting server or reporting manager when subscriptions or manually generated reports fail to return data due to an internal error.
• Created ETL processes utilizing SQL Server Integration Services 20005 for the import, export, and transformation of data from and to Sql server
• Worked on developing Transactional Replication Process to replicate data from production server to reporting server for reporting purposes.

Tools: MS SQLSERVER 2000 & 2005, Visual Studio 2005, RoboSource and DevTrack