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. Summary

Programming/development:

Experience in design, development, and implementation of business solutions

• Capable of working independently and part of teams.
• Excellent interpersonal and customer relational Skills.
• Data modeling--- Erwin data modeling
• SQL development: SQL stored procedures and functions.
• Transact SQL - Tables, Views, Triggers, Indexes, and Cursors.
• Job scheduling: SQL runtime engine based nightly process scheduling.
• 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.
• 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.
• Database backup/restore. Performance tuning and optimization.
• More than 7 years of experience in SQL Server 2000/2005/2008/2012 including BI Business Intelligence .
• Experience in all phases of Software Development Life Cycle.
• Over 5 years of experience in Asset Management at Capital One and Northrop Grumman with direct development, testing and support responsibilities.
• 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.

SQL Data Analyst

Tools:

• MS Excel/Word/Power Point, SSRS and Cognos Reporting.
• Experience Confidential
• Data Warehouse Developer/Systems Analyst Database
• Prime rely responsible for design, develop, and maintain OLAP Data Warehouse database structure within the company. Support all data initiatives, which include data mining, creating views and analyzing data.

Key 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

Lead

Primary responsibility for the design, development, testing and support of Asset Manager 9.31 Oracle11g . Also responsible for addressing business opportunities. Creation of specifications, coding, testing, and implementation of enhancements,

Applications: Asset Manager, DDMI, and CG4.

Key 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

Data Integration / Analysis Specialist

Primary responsibility for delivering fully automated SSIS data integration and ETL processes in SQL Server 2005. Familiar with data warehouse architecture, SSIS and data transformation services including staging and transformation,

This position included

• 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

SQL Data Analyst

Developed and supported the reporting needs of the SunTrust Consumer Lending Operations Group and SunTrust Mortgage companywide for the War on Losses Project. A high degree of creativity and latitude was required for this position.

Key responsibilities included

• 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

Data Analyst

Created and updated operational tables and procedures. Created reports SSRS , including all related stored procedures. Analyzed data constraints and maps, wrote scripts to convert legacy data and table, structure to SQL Server. Also responsibility for the design, development, testing and support of Asset Manager 9.31 and Connect It

Key responsibilities included.

• 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

Data Analyst

Responsible for Data Analyst team daily objectives, ETL data warehouse processes, SQL Server Reporting Services development, Analysis Services cube development and analysis structures.

Key responsibilities included

• 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

Confidential

Data Analyst Developer

Developing, modifying, and monitoring SSIS ETL packages, Data warehousing dimension and fact table weekly loads, and Analysis Server Daily Cube processing automation.

Confidential

Data Analyst Developer Contracting

Part of Business Intelligence team of 4 in the creation and design of a new data warehouse for business reporting needs, using Sql Server 2005 Integration Services for the ETL process loading dimension and facts tables and Analysis Services 2005 for the aggregation and analysis cube Tools used: MS SQL SERVER 2000 2005, Visual Studio 2005,