SUMMARY

• Around 7+ years of extensive experience in IT that includes MS SQL Server 2008/2005/2000 with major focus on SSIS, SSRS and SSAS.
• Proficient knowledge in software development life cycle (SDLC) with substantial experience in object oriented analysis and design methodologies.
• Possess experience in independently handling design, development, documentation and testing phases in a project environment.
• Experience in writing and debugging stored procedures, functions and triggers.
• Experience in optimizing code and improving efficiency in databases including Re - indexing, Recompiling Stored Procedures.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Experience in creating reports using SSRS and worked on OLAP environment.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of SharePoint with SSRS.
• Experience on creating dashboards, building reports and also created management and adhoc reports.
• Administered, maintained, developed and implemented policies and procedures for ensuring the security and integrity of the databases.
• Expertise in Database Design, Development for OLTP (Batch Processing, Online Processing), OLAP, Star and Snowflake schema, ETL, MDX, Data warehousing, Data mining, bill inmon and ralph kimball DW and Data Modeling.
• Experience in managing and automating Control flow, Data flow, Events and logging programmatically using Microsoft .NET framework for SSIS packages.
• Familiar with implementation of SSIS (SQL Server Integration Services), Notification services, Database Mirroring and Service Broker.
• Expertise in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data Warehouse from Heterogeneous data sources such as Excel, MS Access, Oracle, Sybase and DB2 to MS SQL Server.
• Expertise with job scheduling using SQL Server Agent to perform hourly/daily/nightly updates.
• Experience in using performance monitor to resolve Dead Locks/Long running queries thereby optimizing query execution plan.
• Experience in Data Modeling using Erwin, Rational Rose (UML) and MS-Visio to create logical and physical data models; use case diagrams and data flow diagrams respectively.
• Excellent Communication, interpersonal, technical, organizational, presentation and customer service skill set and involved in authoring and reviewing many user and system documents.

TECHNICAL SKILLS

Operating System: Windows NT/ 98/2000/2003 Server XP/7

Languages: T-SQL, PL/SQL, C#.Net, VB.Net, ASP.Net, Java Script, VB Script, ASP HTML, XML, C, C++

Database: MS SQL Server 2000/2005/2008 , MS Access, Oracle 9i, IBM DB2, MySQL

Data Warehouse Tools: MS SQL Server Integration Services (SSIS) 2005/2008, MS SQL Server Reporting Services (SSRS) 2005/2008, MS SQL Server Analysis Services (SSAS) 2005/2008, Crystal Reports, Business Objects.

Tools: /Utility: Enterprise Manager, SQL Server Management Studio(SSMS) 2005/2008, Business Intelligence Development Studio(BIDS), MS Visual Studio 2003/2005/2008 , SQL profiler, Query Analyzer, Data Transformation Services(DTS), DbVisualizer 8.0.3

Microsoft tools: MS Office, Visio, MS-Project, MS.Net framework 2.0/3.0/3.5

Adobe tools: Adobe Dreamweaver, Adobe Photoshop, Adobe Flash, Adobe Cold Fusion

Data Modeling tool: Erwin 4.0,Visio 2003

Version Controlling tools: Visual Source Safe, Team Foundation Server(TFS), Clear Case

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

SQL Server/Netezza Developer

Responsibilities:

• Involved in creating data mart in Netezza DB and data staging schemas in SQL server.
• Generate DDLs for Fact, Lookup, and Intersection tables for SQL Server and Netezza.
• Identified Data Sources(SQL Server, Flat Files) and Run ChainBuilder to Produce Source Files for 3rd Party Data.
• Created Source-Target mappings for Raw to Stage for Netezza.
• Import data from SQL Server into Netezza Staging using NZLoad.
• Create Counts and Populate Lookup tables in SQL Preview and Netezza.
• Wrote triggers to Push Counts from SQL Preview to SQL Production.
• Created stored procedures and functions in Netezza for enhanced security and increased reliability.
• Extensively involved in reviewing dimensions and gear operators.
• Involved in defining uses cases with client.
• Created reports that have been defined by business architect and generated canned reports in a Crystal format of Crystal Reports.
• Involved in Test Creating Audiences and Matching Counts.
• Conducted Training and Feedback Sessions with Client.
• Demonstrated ability of good leadership, teamwork, and project management / communication skills.

Environment: Netezza, SQL Server 2008/2005, DbVisualizer, ASP.Net, C#, Crystal Reports, MS SQL Server Integration Services (SSIS), Visual Studio 2005, Microsoft Visio.

Confidential, Miramar, FL

SQL Server BI Developer

Responsibilities:

• Primarily working with reporting team to monitor, plan, and implement the synchronization of data across several reporting, development, testing and production environments.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs) and loaded the data into target data sources by using SSIS.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse using SSIS packages.
• Designed dynamic SSIS Packages and worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses.
• Design and develop Stored Procedures and Database Triggers.
• Responsible for Rebuilding and Reorganizing Indexes for performance tuning.
• Generated various Report models on Views and deployed them on to the production reporting server and generated various report models and ad-hoc reports.
• Developed Reports which were used to generate all daily, weekly, monthly and quarterly Reports.
• Resolved Deadlock and Blocking Lock Issues by setting Trace Flags like T1204 and T1205.
• Involved in developing front end using C#, ASP.Net, and .Net framework.
• Involved in implementing ADO.NET to connect with SQL server and execute stored procedures.
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Generated Reports Utilizing Crystal Reports and allowed user to download the reports as MS Excel or MS Word documents.
• Created components, tools, techniques, methods and procedures used in an on OLAP environment for accessing and translating data into understandable and usable business information using SSAS.

Environment: MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), SQL Server 2008/2005, Visual Studio 2005, HTML, XML, Microsoft Visual SourceSafe, Crystal Reports XI, ASP.Net, C#, VB.Net, ADO.Net, Team Foundation Server, Microsoft Visio.

Confidential, Trumbull, CT

SQL Server BI Developer

Responsibilities:

• Involved in Blueprinting, Business requirement gathering, and mapping of the business AS-IS process with TO-BE process.
• Involved in Planning, Defining and Designing data based on the business requirement and provided documentation.
• Involved in designing, developing and implementing of web applications using ASP.Net, C#.Net.
• Extensively used ADO.NET for data retrieving, querying, storage and manipulation.
• Developed business components and data access components inC#.Net.
• Worked on querying data and creating on-demand reports in SSRS 2008.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report according to the requirement.
• Created standard report Subscriptions and Data Driven report Subscriptions.
• Used conditional formatting to change the behavior of the report depending upon the requirement.
• Designed and developed SSIS packages, configuration files, tables, views, stored procedures, functions and implemented best practices to maintain optimal performance.
• Involved in deploying the SSIS packages to an instance of SQL server and also to the file system by creating the deployment utility.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services to overcome transformation constraints.
• Scheduled, monitored SSIS Packages using SQL Server agent.
• Involved in Performance tuning of Queries, Indexes and Stored Procedures.
• Providing On Support for the Other Data Team/End Users to resolve Critical Issues during Cut Over, Production and Year End Support.

Environment: MS SQL Server 2005/2008, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), ASP.Net, C#, VB.Net, ADO.Net, MS Office, Windows Server 2003.

Confidential, Miami, FL

SQL Server BI Developer

Responsibilities:

• Involved in different phases of SDLC Life Cycle.
• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views and complex 2
• Developed the T-SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency SSAS and SSIS.
• Involved in mock testing and Unit Testing and Integration testing in SSIS, SSAS.
• Performance tuning of SQL queries and stored procedures using SQL Profiler in SSAS and SSIS.
• Created jobs, alerts to run SSAS, SSIS packages periodically.
• Created the Load packages for loading the CSV files from DB2 into SQL Server using SSIS
• Created reports that have been defined by business architect and generated canned reports in a Crystal format of Crystal Reports.
• Created and Designed Data Source and Data Source Views using SSAS.
• Developed the PL/SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency SSAS and SSIS.
• Created and Configured OLAP Cubes (Star Schema and Snow flake Schema) using SSAS.
• Enhanced the functionality in database and data warehousing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SSAS and MDX.
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in SSAS.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Developed Query for generating drill down reports in SSRS 2008.Prepared AD HOC reports through report builders.
• Used DBCC commands to troubleshoot issues related to database consistency.

Environment: SQL Server 2005/2008, MS Access, Windows Server 2008, IIS, Visual Source Safe, Share Point Server, Crystal Reports 10.R2, .Net Framework, ADO.Net, ASP.Net, Java Script and C#.

Confidential, Dallas, TX

SQL Server Developer

Responsibilities:

• Created functional specification document and technical specification document.
• Created and managed stored procedures, indexed views, user defined functions, triggers, joins database constraints to meet business requirements and policies.
• Migrating of the DTS packages to SSIS packages by Complete Rewrite and Import wizard.
• Wrote complex queries, DDL, DML, functions, triggers, stored procedures, and views for new and existing applications.
• Involved in developing the VB Script, C#, and ASP.Net, VB.Net and .Net framework creation in SSAS and SSIS.
• Wrote stored procedures for report generation in SQL Server2005.
• Developed Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
• Worked with scheduling and publishing of reports in SQL server reporting services and integration with Microsoft Office tools like automatically emailing reports in various formats such as Excel, PDF etc.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.
• Fine-tuned SQL Queries for maximum efficiency and performance.

Environment: MS SQL Server 2005, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), BIDS, SQL Query Analyzer, MS Visual studio 2005, ASP.Net, C#.Net, VB.Net, Crystal Reports.

Confidential

SQL server Data warehouse Architect

Responsibilities:

• Effectively used SDLC methodologies to define the project; this includes defining business, functional, technical requirements, implementation and post production support.
• Created several materialized views, stored procedures, indexes, joins and correlated sub queries to be accessed by the new front end applications.
• Performance tuning, and optimization of procedures and queries.
• Created SSIS Templates for developing SSIS packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Involved in creating Drill Down and cascaded reports with interactive sorting in SSRS 2000.
• Defined report layouts for formatting the report design as per the needs.
• Developed reports using SSRS 2005 and used table control, matrix control for cross tab reports.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.
• Involved in migration of the DTS package to SSIS by Import wizard and complete Rewrite.
• Involved in designing, developing and implementing of web applications using ASP.Net, C#.Net, VB.Net.
• Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.
• Used Visual Source Safe for version control.

Environment: MS SQL Server 2000/2005, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), Visual source safe, MS Visual Studio 2003/2005, ASP.Net, C#.Net, VB.Net.