PROFESSIONAL SUMMARY:

• Over 7 years of IT experience in the use and design, development, testing, administration, support and migration of Microsoft SQL Server 2000/2005/2008 R2/2012 database.
• Experience in Requirement gathering, Functional, Technical specifications, System analysis, Design, Development, Testing and Implementation of client/server and web - based applications.
• OLTP Relational Schema and Normalization to 3NF and OLAP Dimensional Modeling using a Star and Snowflake schema and Data vault modeling concept.
• Worked with Erwin tool to forward and reverse engineer data models.
• Exceptional T-SQL scripting for creating various database objects like Stored Procedures, Functions, Triggers, and Views.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experienced in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Expertise in creating and managing Event Handlers, Package Configurations, Error Handling, Logging, System and User-defined Variables for SSIS Packages.
• Experience in Creating Master Packages for variable mapping across multiple environments.
• Experience in developing and deploying complex Drill-Down reports, parameterized reports, Cascaded reports, Dynamic Reports using SQL Server Reporting Services (SSRS).
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• Proficiency in creating different types of reports such as Parameterized, Cross-Tab, Linked, Drill-through, Drill-down reports, Top N, Sub reports, and formatting them using both SSRS 2005/2008 R2
• Deployed the SSIS Packages from development server to production server.
• Experience in managing and automating control flow, data flow, events and logging programmatically using Microsoft .NET framework for SSIS packages.
• Knowledge in integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
• Experienced in working with the source control and version control tools such Visual SourceSafe (VSS) CVS, PVCS, and WinCVS.

TECHNICAL SKILLS:

Database: MS SQL Server 2012/2008 R2/2005/2000, SSIS, SSRS, SSAS, MS Access, OracleReporting Tools: Crystal Reports, SQL Server Reporting Services (SSRS)

Web Technologies: C#, ASP.NET, XML, AJAX, Web Services, Windows Services, CSS, XML, LINQ, Windows Communication Foundation (WCF), WPF and Silverlight.

Languages: C#, C, HTML, JavaScript, jquery

Designing Tools: Data vault modeling, Erwin, Visual Studio 2010/2008/2005/2003, Adobe Photoshop, Microsoft Expression Design, Expression Blend and Expression Web

Version Tools: Vault, SVN, MS Visual Source Safe (VSS), Team Foundation Server (TFS)

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX.

Responsibilities:

• Formulate designs and/or design recommendations which meet various requirements; balancing the goals and constraints of existing solutions.
• Convert business requirements into actionable technical requirements for the project.
• Worked on 30 terabytes of data warehousing storage, with multiple years of historical data.
• Provide technical solutions within BI team in the design process for the project.
• Designed and Built ETL packages to migrate data from different source systems using Data vault modeling concept.
• Design and build reporting and analysis tools that help streamline the business and make reporting, analyzing, planning, and forecasting more efficient.
• Worked on ETL Load SSIS Packages, report / cube creation and data visualization including dashboards and reports leveraging charts (Pivot tables), gauges and drill-through.
• Created SSIS packages to manage SQL Server databases and SQL Server objects between instances of SQL Server.
• Support team projects with technical expertise with all aspects of the solution design and implementation, including requirements definition, data acquisition processes, data modeling, process automation, escalation procedures, construction, and deployment.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Present and propose solutions, and alternatives, to requirements with an eye to scalability, flexibility, ease of maintenance and time to delivery, which often requires a phased approach and understanding of release schedules.
• Created SQL Server Traces in SQL Server Profiler, to collects a variety of information about SQL Server connections, stored procedures and Transact-SQL statements.
• Created complex stored procedures, triggers, cursors, views, user-defined functions, SQL Server Traces in SQL Server Profiler to collect a variety of information about SQL Server transactions, server performances and Transact-SQL (T-SQL) statements.

Confidential, Plano, TX

MS BI Developer / Data Analyst

Responsibilities:

• Created Conceptual (CDM), Logical / Physical (LDM and PDM) data.
• Extensively worked on ETL Load (SSIS Package), report / cube creation and data visualization including dashboards and reports leveraging charts (Pivot tables), gauges and drill-through.
• Created SQL Agent Jobs to schedule jobs for extracting data from different source systems using SSIS packages. Stored Procedures are used within these packages to aggregate the data.
• Created SQL Server Traces in SQL Server Profiler, to collects a variety of information about SQL Server connections, stored procedures and Transact-SQL statements.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Create on demand Ad hoc reports, Parameterized reports, Linked reports, Snapshot reports, Drilldown reports and Sub reports using SSRS.
• Created numerous SSIS packages (ETL) to migrate data from different server locations and heterogeneous sources like Excel, CSV, flat file, XML and Text Format Data.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Advisor.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Migrated data from different source locations to Dev / QA environment using SQL 2008 SSIS packages.
• Created SQL Server Traces in SQL Server Profiler, to collects a variety of information about SQL Server connections, stored procedures and Transact-SQL statements.
• Created complex stored procedures, triggers, cursors, views, user-defined functions, SQL Server Traces in SQL Server Profiler to collect a variety of information about SQL Server transactions, server performances and Transact-SQL (T-SQL) statements.

Environment: MS SQL Server 2008, T-SQL, SQL Server Reporting services, SQL Server Integration Services, Management Studio, C#, .Net, OLE DB, SQL server Profiler, MOSS, SharePoint & Windows.

Confidential, Westchester, PA

MSSQL Server BI Developer

Responsibilities:

• Worked with Auditing and Error Handling for the SSIS Packages
• Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
• Created User defined functions and stored procedures to meet the requirement.
• Worked with Exception Handling with @@error and Try/catch
• Created various Indexes on tables for better Query Performance.
• Re-designed the File Naming Conventions according to the business user.
• Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
• Extensive ETL experience using DTS/SSIS for Data Extractions, Transformations and Loads.
• Wrote SQL Scripts for Script Tasks in SSIS Packages.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports.
• Deployed the SSIS Packages and created jobs for efficient running of the packages.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Identified and worked with Parameters for SSIS.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2008 with .NET applications.

Environment: MS SQL Server 2008, DTS, SSIS, SSRS, SSAS, Business Intelligence Development Studio (BIDS) 2008/2005, MS-Visual Studio, C# and Windows XP.

Confidential, Boston, MA

MSSQL Server Developer

Responsibilities:

• Participated in gathering User Requirements and System Specifications.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Involved in installation and configuration of SQL Server 2005 with latest Service Packs.
• Normalized the database into small tables by applying rules of Normalization, defined check Constraint and applied Business Rules.
• Used SQL Server Integration Services (SSIS) to perform bulk insert operations from SQL Server 2005 databases to flat files/CSV files and vice versa.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Improved automation of existing processes of SQL using stored procedures and SSIS packages.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Used various kinds of Data sets with SSRS.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Formatted the report layout for the requirement of the end users using SSRS.

Confidential

SQL Programmer/ BI Analyst

Responsibilities:

• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Installation and configuration of MS SQL Server on Windows 2000 Server.
• Migrated from SQL Server 2000 to SQL Server 2005
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Scheduling transfer of backups and log files to different servers.
• Used highly complex T-SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules. Extensively used TSQL to manipulate and architect to produce results for users.
• Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.

Environment: MS SQL Server 2000/2005, .Net, C#, Query Analyzer, SQL Profiler, T-SQL, and DTS packages, OLAP, OLTP, ETL and Windows Server 2000.