SUMMARY

• Around 8+ years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, SQL SERVER, UNIX & OLAP.
• Experience inOLTP/OLAPenvironment andData Warehouse.
• Extensive experience in SQLServer Analysis Services OLAP Cubes, and Data Mining.
• Work experience on MS SQL Server 2008R2/2005/2000, Oracle, VB 6, crystal reports 6.
• Experience indesigning, developing and deployingBusiness Intelligence solutions usingSSIS,SSRS
• Designed and developedmatrix and tabular reportswithdrill down, drill throughusingSSRS.
• Experience inwritingComplexSQLQueriesinvolving multiple tablesinnerandouter joins.
• Worked as MS SQL Server Developer on enterprise and performance critical applications.
• Extensive experience in developing Stored Procedures, Views, Cursors, Triggers and Complex Queries in MS SQL Server.
• Involved in migration of legacy data by creating various SSIS packages
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
• Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Expert in generating drill down reports in SSRS 2008.
• Experience in Handling Heterogeneous data sources and databases Oracle, Teradata, and csv and XML files using SSIS.
• Enhancing the Reports visually by adding the visual elements like charts, graphs to SSRS reports Involved in Logical and physical Design of the Database using Erwin tool
• Auto - generated analysis reports using SQL Server, ACCESS, Business Objects and Crystal Reports and Excel pivot tables.
• Developed interactive web-based reports and forms with VB.NET and ASP.NET and ADO.NET and html.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Exceptional Computer Science background with programming skills in VB as a Junior Programmer.
• Excellent verbal and written communication skills with a strong focus on customer facing interaction, customer service, and presentation.
• Experience in using Team Foundation Server (TFS) and Visual source safe (VSS) as a tool for repository of codes and version control, branching and merging into production.
• Experience in tuning the reports that includes modifying, Testing the required TSQL and MDX queries using DMV's and creating the necessary environment for Deployment.
• Proficient with automated testing tools - Win Runner, Load Runner and QTP for testing Client / Server and Web based applications
• Test & Deploy code across various SDLC Environments like TEST, UA/UT/Production.
• Self-Motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.
• Ability to work excellently as an individual and also as part of a team with minimum amount of supervision.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2008R2, 2005, 2000, Oracle, Teradata

Database Tools: SQL Server Entreprise Manager, SQL Server Intégration Services (SSIS), Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), DTSX

Reporting Tools: Microsoft SQL Server Reporting Services (SSRS), Crystal Reports

Operating Systems: Windows 7, Windows XP, 2000, Windows 2003 server, Windows 98

Programming Languages: SQL,T-SQL,PL/SQL,XML,HTML,VisualBasic6,VBScript, C#,.NET,VB.NET,ASP.NET,ADO.NETDesign Tools Erwin 7, MS Visio

BI Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

PROFESSIONAL EXPERIENCE

Confidential, Troy, MI

Sr.SQL Server BI Developer

Responsibilities:

• Designed and developedSSIS Packages (.dtsx files)to import and export data fromMS Excel, SQL Server 2005 and Flat files.
• Involved in installing and migrating legacy databases to SQL Server 2008.
• Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.
• Created SSIS packages to integrate the data coming from flat files
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports.
• Designed and developed various complex reports such asDrill down, Drill Through, Cross TabbedusingMS Reporting Services.
• Performed database backup and deployment to the production server.
• Involved in designingParameterized Reportsand alsocascaded Parameterized Reports.
• Created detail Technical documentation of various staging area operations for future reference and guidance.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports (SSRS 2005/2008).
• Installation and configuration of SQL Server Reporting Services (SSRS) 2005/2008
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports (SSRS 2005/2008).
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval
• Involved in testing, bug fixing and documentation for the project.
• Create and execute unit, functional and integrated testing.

Environment: SQL Server 2008R2 Enterprise Edition, SQL BI Suite (SSIS, SSRS), Enterprise manager, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2008.

Confidential, Des Moines, IA

Sr. SQL Server Developer

Responsibilities:

• Designed SSIS packages to migrate the data from Oracle flat files in SQL server
• Designed SSIS packages to load data from CSV and excel files to the Staging Area in SQL server
• Managed Package Configurations in XML Files to efficiently Promote Unit Tested Packages to different environments (System Integration Testing, User Acceptance Testing and Production Environment) from Development Environment.
• Scheduled Packages using SQL Server Agent Jobs to execute at specified time on weekly and monthly basis.
• Developed cubes using Partitions added the Key Performance Indicators (KPI), partition aggregations, Perspectives, slow changing dimensions etc and created various user roles.
• Created sophisticated SQL Server database to responsively handle complex queries (triggers, stored procedures, views, functions) and .NET data access components.
• Participated in designing Logical and physical data models for datamart.
• Enforced the Business Rules by creating multiple constraints like check constraints and triggers
• Optimized the performance of various SQL stored procedures using sql profiler to improve the latency of reports.
• Reviewed the existing stored procedures and improved efficiency by critically evaluating the code.
• Created complex scripts to do chucking and massaging of legacy data in staging area of DTS and SSIS package
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Write Ad-hoc queries for Business analysts to extract required data from datamart.
• Involved in writing MDX queries and manipulating the multidimensional data in OLAP cubes.
• Created reports that call Sub reports in SSRS
• Designed and developedmatrix and tabular reportswithdrill down, drill throughusingSSRS.
• CreatedStored ProceduresandT-SQLcodefor complex business logic.
• Extract data from database and export to Excel files for Data Analyst to analyze the data.
• Capture invalid data while processing the input flat files and inform responsible individuals from business group.
• Capture process performance logs and analyze them for better performance and redesigning of the packages.
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications

Environment: Microsoft SQL Server 2008, T-SQL, SQL Server Integration Services(SSIS), Microsoft SQL Server Reporting Services(SSRS), MS Excel, MS Word, SSAS, Clear Case, Oracle, Terada, DTS, SQL*Plus, SQL Server Management Studio,VB.NET.

Confidential, Austin, TX

SQL Server Developer

Responsibilities:

• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications
• Designed and developedSSIS Packages (.dtsx files)to import and export data fromMS Excel, SQL Server 2005 and Flat files.
• Involved in installing and migrating legacy databases to SQL Server 2008.
• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports
• Installation and configuration of SQL Server Reporting Services (SSRS) 2005/2008
• Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Designed and developed various complex reports such asDrill down, Drill Through, Cross TabbedusingMS Reporting Services.
• Involved in designingParameterized Reportsand alsocascaded Parameterized Reports.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports (SSRS 2005/2008).
• Advanced extensible reporting skills using SQL Server 2005 Reporting Services (SSRS).
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval
• Involved in testing, bug fixing and documentation for the project

Environment: SQL Server 2005/2008 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, XML, MS PowerPoint, MS Project,MS Access 2003 & Windows Server 2003

Confidential

Database Developer

Responsibilities:

• Designed SSIS packages to load data from CSV files to the Staging Area in SQL server
• Designed SSIS packages to load data from various source OLTP application databases in the Staging Area in SQL server
• Managed Package Configurations in XML Files to efficiently Promote Unit Tested Packages to different environments (System Integration Testing, User Acceptance Testing and Production Environment) from Development Environment.
• Developed stored procedures/Packages using T-SQL, PL/SQL programming to meet the business requirements
• Using SQL Server Reporting Services(SSRS)delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources
• Scheduled Packages using SQL Server Agent Jobs to execute at specified time on weekly and monthly basis.
• Participated in designing Logical and physical data models for datamart.
• Enforced the Business Rules by creating multiple constraints like check constraints and triggers
• Optimized the performance of various SQL stored procedures using sql profiler to improve the latency of reports.
• Reviewed the existing stored procedures and improved efficiency by critically evaluating the code.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Write Ad-hoc queries for Business analysts to extract required data from datamart.
• Extract data from database and export to Excel files for Data Analyst to analyze the data.
• Capture invalid data while processing the input flat files and inform responsible individuals from business group.
• Capture process performance logs and analyze them for better performance and redesigning of the packages.

Environment: Microsoft SQL Server 2005, Microsoft SQL Server Reporting Services (SSRS), T-SQL, SQL Server Integration Services (SSIS), MS Excel, MS Word, SQL Server Management Studio.

Confidential

Software Engineer

Responsibilities:

• Analysis of the specifications provided by the capital road lines users
• Design & Develop of front end screens using VB
• Generating reports using crystal reports
• Coding in VB6.0
• Writing database procedures, functions and triggers
• Unit testing & integration testing
• Responsible for overseeing the Quality procedures related to the project

Environment: Visual Basic 6.0, Windows 2000 operating system, Microsoft SQL Server 2000 server, Microsoft Excel, Microsoft Word, Visual Source Safe

Confidential

Software Engineer

Responsibilities:

• Gathering and analyzing the end user requirements
• Design of user interface screens according to the low level design documents
• Coding in VB6.0, unit testing, integration testing
• Writing SQLs to use in application development
• Writing database stored procedures and triggers to as specified in low level design
• Reporting to project manager

Environment: Visual Basic 6.0, Visual Source Safe, Windows 2000 operating system, Microsoft SQL Server 2000 server, Microsoft Excel, Microsoft word.