PROFESSIONAL SUMMARY:

• Over 7+ years of experience in Design, Development & Analysis of SQL Server 2005/2008 and SQL Server Business Intelligence Tools (BIDS) - SSIS, SSRS and SSAS.
• Experience with Installing, Configuring, Managing, Upgrading, Migrating, Monitoring and Troubleshooting SQL Server 2005/2008/R2/2012.
• Development and Administration experience on Database Design and Implementation of OLTP and OLAP environment using SQL server 2005/2008/2012.
• Experience in Designing and Implementation of Relational Database Model for business requirements using Normalization forms.
• Good at creating Tables and Views as per the business and design requirements using T-SQL.
• Extensive experience in developing Stored Procedures, Functions (Arithmetic, String and DateTime) using T-SQL.
• Good understanding of RDBMS, Normalization /De-normalization and database modeling.
• Implemented Triggers at different levels of Database Objects to apply Security Constraints.
• Good at improving Performance using Table Indexes, Indexed Views by implementing Schema Bindings.
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS 2005/2008/R2/2012), DTS, Bulk Insert and Bulk Copy Program utility.
• Experience at Transforming and Validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for unstructured and redundant data.
• Worked with Flat file, Excel file, SQL server OLEDB destinations for Loading data.
• Generated VB and C# scripts used for Script task. Script task is primarily to control the flow of SSIS package.
• Experience in generating Ad-Hoc, Drill Down, Drill Through Reports using Local and Global Variables, Expressions and Filters in SSRS.
• Expert in creating Parameterized Reports, Matrix Reports, and Custom generated reports, Charts, Sub Reports as per Business User requirements.
• Experienced in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.
• Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule DTS/SSIS Packages.
• Expert in monitoring SQL Server Performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Proficiency in creating different types of reports such as Cross-Tab, Conditional, Pie Chart Reports, Drill-down, Top N, Summary and Sub reports, ad-hoc reports and formatting them.
• Hands-on experience with Tableau reporting tool.
• Experienced in writing VB scripts for user defined functions and report manager scheduling in SSRS.
• Developed OLAP cubes using SSAS (SQL Server Analysis Services) and calculated the metrics that were revealed in the functional analysis.
• Good knowledge of Defining, Developing and Deploying Star Schema, Snow flake Schema and Dimensional Data modeling using MS SQL Server 2005 Analysis Services (SSAS) on EDW.
• Knowledge in Identifying Facts and Dimensions for Cubes with MDX queries in SSAS 2005/2008/R2/2012.
• A multi tasking Analytical Thinker with the ability to work on fast paced work Environment.
• Strong communication skills and an ability to work individually or part of a team and good learner to adapt new technologies that improve the business.

TECHNICAL SKILLS

Relational Databases: SQL Server 2012/2008/R2/2005/2000, Oracle 10g/9i/8.0, MS Access, MS Excel, DB2, Teradata, Sybase.

Tools and Packages: SQL Server Management studio, Enterprise Manager, Profiler, SSIS, SSRS, SSAS, Erwin, DTS, Microsoft Visual Source Safe, Crystal Reports9.0, Idera, Lite speed, MDX, Visual Studio .Net, ProClarity, Db Pro, Octopus, Visual Source Team Foundation Server (TFS)

Languages: T-SQL, PL/SQL, V.B6.0, MDX, C, C#, ASP.Net, VB.Net.

Operating Systems: Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS

Database Design Tools: MS Visio, Erwin

Web Technologies: HTML, XML, XSL, JavaScript, IIS(4.0/5.0/6/0)

Application Packages: MS Office, MS Outlook (Microsoft Office Suite)

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services(SSIS), SQL Server Analytical Services (SSAS), Performance Point Server 2007, Tableau, Microstrategy

PROFESSIONAL EXPERIENCE:

Confidential, Bluffton, SC

SQL SSIS/SSRS Developer

Responsibilities:

• Good Knowledge on Handling EDI Maps, generation of flat files using EDI maps.
• Hands on experience with Pentaho for data transformation and Microstrategy for reporting.
• Implemented Complex Stored Procedures for Providers and Members for various clients.
• Experienced in writing complex SQL queries, Stored Procedures, Triggers, Views, DML, DDL and user defined functions to implement business logic and also created clustered and non clustered indexes.
• Encapsulated frequently used SQL statements into stores procedures there by reducing the execution time.
• Imported flat files using SSIS packages, BCP command and PDI tool.
• Developed various SSIS packages based upon the source files using various control flow and data flow tasks.
• Deployed SSIS packages involving complex Transformations like Slowly Changing Dimension, Fuzzy Grouping, Merge, Merge join, Pivot, Unpivot.
• Designed SSRS reports (drill-down, drill-through) based on business requirements.
• Worked on TFS tickets, I was also a part of Fire Fighter of the Week (FFOW).
• Designed Data marts for Micro Strategy and SSRS Reports.
• Good understanding of DB2 databases, worked on AS400/MC400 environment both in Test and Production.
• Successfully finished 3 new Implementation projects of United National and AmeriChoice.
• Used SQL Server Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
• Actively involved in Production Support and on-call support for every release on behalf of Dataloads team.
• Also, part of QA team for validating the authorizations and providers information in Test Environment.
• Strong inclination of finishing job before project deadline. Flexible and Versatile to adapt to any new environment and work on any project.

Environment: MS-Access, SQL Server 2008/R2/2012, Visual Studio, SQL BI Suite (SSIS, SSRS, SSAS) TFS-2008, Windows Server 2003, IBM-AS400, Pentaho, EDI, C#.

Confidential, Schaumburg, IL

SQL Server/BI Developer

Responsibilities:

• Understanding the Report Design Requirements and Constraints.
• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Design and implementation of Security Model, Policies and Procedures.
• Performing query plans and making sure each and every query is using appropriate useful Indexes.
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity.
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Maintained records in Excel Spread Sheet and exported data into SQL Server Database using SQL Server Integration Services (SSIS)
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generating various Monthly, Quarterly, Bi-Yearly, Yearly and random ad-hoc reports using SQL Server Reporting Services (SSRS).
• Created Drill-down, Parameterized and Sub-Reports using RDL.
• Promoted RDLs to Reporting Service Server (SSRS).
• Used SQL Server Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Designed and developed Data marts using SSAS.
• Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS.
• Scheduled Backups and performed Restore operations for system test data.

Environment: MS-SQL Server 2012/2008R2, Visual Studio 2008, TFS, VB.Net, C#, Oracle, MS SQL Server Management Studio, SSIS, SSRS, SSAS.

Confidential, Houston, TX

SQL-SSIS/SSRS Developer

Responsibilities:

• Worked with various upstream and downstream customers in interfacing various systems and processes for Data extractions, ETL, Analytics and reporting needs.
• Point of contact for all the Data processes, Data Mappings, Data dictionaries, Data pulls and Reporting solutions.
• Designed and Developed SSIS Packages to import and export data from MS Excel, XML, SQL Server 2008,Flat files, DB2 and used SSIS Package Configuration, Expressions, passing variables dynamically, logging, Event Handler.
• Performing Data source investigation, developed source to destination mappings and data cleansing while loading the data into staging/ODS regions.
• Involved in various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration.
• Applied various data transformations like Lookup, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Creating SQL Server Agent Jobs to maintain and run various SSIS packages periodically or as scheduled.
• Responsible for identify and translate business requirements for the Enterprise Data Warehouse into logical and physical data models.
• Integrated SQL Server 2005 reporting services (SSRS) with Microsoft Office Share point Server to automatically deliver reports to the Share Point portal.
• Loading the Fact and Dimension tables.
• Querying, creating stored procedures and writing complex queries and T-SQL Joins to address various reporting operations and also random data requests.
• Created Drill-through reports, parameterized reports and linked reports using SSRS and were integrated in the Performance point server.
• Created SSIS packages and used Analysis Services (SSAS) processing task to update the cube with current data.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services (SSAS).
• Creating and maintaining various subscriptions in the Report Manager for the reports.
• Creating custom forms using MS Access to facilitate user data requests on demand.
• Developing products by determining what competitors are doing, risk assessments, ratings assessments, pricing and coverage.

Environment: MS SQL Server 2008/2005, SQL BI Suite (SSAS, SSIS, SSRS), Visual Studio, Team Foundation Server, C#, Visual Source Safe (VSS), Oracle, Pl/SQL, Share Point, MS Project, MS Access 2003/2007.

Confidential

SQL Developer/ Programmer

Responsibilities:

• Standardized way of writing stored procedure following a specific pattern and naming conventions.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Developed various reports using SSRS, which included writing complex stored procedures for datasets.
• Migrated DTS Packages from SQL Server 2000 to SQL Server 2005 and done the necessary changes to SSIS Packages which were not properly migrated.
• Developed many Packages using SSIS to migrate data from different various sources into SQL Server.
• Created stored procedures for maintaining SQL Server and for supporting the Application Developers to get easy access to data objects.
• Filtered bad data from legacy systems and implemented various constraint and triggers for data consistency.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services (SSAS).
• Created and maintained database, tables, views, indexes, and constraints to implement business rules by using Query Analyzer and SQL Server Management Studio.
• Implemented Disaster Recovery Plan by maintaining Backups and performing the Restoring of the system and user databases.
• Good Knowledge on EDI for Exchanging Business Data.
• Created complex Stored Procedures, Views, and Triggers according to the business needs and also done optimization to some objects so that they run efficiently.
• Developed DDL Triggers for Database security.
• Used complex join conditions to retrieve data from the database
• Used SQL Server Profiler to trace the slow running queries and the server activity.

Environment: SQL Server 2000/2005/2008/R2, SQL BI Suite (SSAS, SSIS, SSRS), Visual Studio, Share Point, MS Project, VB.Net, Oracle.

Confidential

Jr.SQL Developer

Responsibilities:

• Actively involved as part of a team for gathering and analyzing the needs of end User Requirements
• Used TSQL to create various queries
• Created new tables, wrote stored procedures and some user defined functions for Application Developers
• Performed data conversions from flat files into a normalized database structure.
• Created Triggers, Check Constraint and Primary/Foreign Key to enforce data and referential integrity.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Worked on DTS Packages, DTS Import/Export for transferring data between SQL Server.
• Managed historical data from various heterogeneous data sources like Excel, Fixed Width Flat Files.
• Performed tuning of SQL queries and stored procedures using SQL Profiler
• Involved in generating summary reports using Crystal reports.

Environment: Microsoft SQL Server 2000, Windows XP, VB Script, DTS, Crystal Reports, Visual Studio 2002.