SUMMARY

• Over 5+ years of IT industry experience in using Microsoft SQL Server 2005/2008/2008 R2/2012/2014 for Database Design, Data Migration, Business Intelligence, Data Analyst, Data Scientist and Database Back - end Development.
• Interpret data, analyze results using statistical techniques and provide ongoing reports.
• Acquiring data from primary or secondary data sources and maintain databases/data systems.
• Filter and “clean” data, and review computer reports, printouts, and performance indicators to locate and correct code problems.
• Substantial experience in Microsoft and other BI Technologies; SQL Server, SSIS, SSRS, SSAS and Excel Pivot Tables.
• Well experience with c# and .net technologies.
• Strong understanding of SQL Server, plus experience developing in SSIS. Solid development experience with SSIS.
• Excellent T-SQL programming skills in constructing Tables, Triggers, User Function, Views, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.
• Excellent understanding of Relational Database Systems, Logical/Physical Data Modeling, Normalization, and Data Warehousing.
• SQL 2008/2012/2014 , MSFT Team Foundation Server 2010/2012, MSFT Visual Studio 2010/2012.
• Experience in executing various SSIS features like Precedence Constraints, Event Handling, Break Points, Check Points, and Logging for Complex SSIS Packages
• Experience in creating SSIS packages to export data from Flat files, CSV, Excel to database table using each loop task
• Experience in implementing Transactions, Logging, Error files to SSIS Packages.
• Created ETL packages using SSIS to move data from various heterogeneous data sources.
• Experienced in SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases
• Extensive experience in implementation of Data Cleanup procedures, transformations, Scripts, Stored Procedures and execution of test plans for loading the data successfully into the targets.
• Created ETL packages using SSIS to move data from various heterogeneous data sources.
• Well versed in data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS) for data migration.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS (slightly related to SSAS/data warehouse data load).
• Experience in developing Custom Reports and Various types of Tabular, Matrix, Ad-hoc, Drill-down, Lists, Charts, Parameterized and Cascading Reports with multiple formatting using SQL Server Reporting Services (SSRS).
• Good understanding of Other Reporting Service (SSRS) aspects such as Report Authoring, Report Management, Report Delivery and Report Security.
• Good Expertise in developing and extending SSAS cubes, Dimensions, Data source views, SSAS data mining models including deploying and processing of SSAS objects.
• Experience using SQL Server Analysis Services (SSAS) in building OLAP Cubes, defining Referenced Relationships and creating Hierarchies in SSAS.
• Experience in data and report analysis based off business requirement and existing reporting tool with good understanding on subtleties of data, processes, business units.
• Experience inBIlike using tools like Tableau.

TECHNICAL SKILLS

Languages: PL/SQL, SQL, TSQL, C, C++, 8085/8086 Assembly Language, Unix shell scripting

Databases: Oracle 8i/9i, MySQL, MS SQL Server2005/2008 R2, 2012 Teradata, SQL Azure

Database management tool: Oracle Enterprise Management, SQL Server Management Studio, Teradata SQL Assistant

Data Modeling Tools: MS-Visio, MySQL Workbench

Reporting Tools: SSRS, Web Intelligence, SAP Crystal Enterprise 4.0

Operating System: Windows 95/98/NT/2000/XP, UNIX, Linux, MS-DOS

ETL & OLAP Tools: SSIS 2005/2008 and SSAS 2008, Tableau

Other Tools: MS Visual Studio, MS-Office, SQL*plus, familiar with SAP reporting tools. Familiar with OLAP tool SSAS

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Data Analyst/SQL Server Developer

Responsibilities:

• Installed SQL Server 2012 with latest Service pack and established connectivity with the database created, configured and maintained database maintenance plans.
• Work closely with management to prioritize business and information needs.
• Contribute a business or process perspective during design reviews.
• Assess solutions in concert with the design team, identify and escalate issues and mitigation plans to business and technology leadership.
• Created T-SQL queries, stored procedures, triggers, views, Indexes, Constraints and user defined functions (UDFs) on various database objects to create, modify and/or maintain databases.
• Maintained Data Integrity by implementing different types of constraints on tables.
• Implemented SAS (Statistical Analysis System) for statistical analysis of the patients’ medical history and comparison between their trending and previous health status.
• Managed the data by altering and retrieving from a variety of sources and made them ready for statistical analysis
• Creating and Modifying T-SQL Stored Procedures for validating the integrity.
• Maintained data integrity by performing validation checks.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Used SQL Profiler and Database Tuning Advisor for troubleshooting, monitoring, optimizing SQL Server and T-SQL statements from developers and testers and also created SQL scripts for tuning and scheduling.
• Involved in Error Handling using Try/catch Block.
• Migrated SQL server 2008 R2 packages to SQL Server 2012 SSIS packages using SQL Server 2008 Upgrade Advisor.
• Created packages with different Control Flow options and Data Flow Transformations such as Conditional Split, Multicast, Pivot, Union All etc.
• Experience in creating complex SSIS Packages with error handling using control and dataflow elements.
• Scheduling SSIS packages and Jobs.
• Configured Dynamic Checkpoints to allow rerunning a package from the point of failure.
• Implemented Event Handlers, Error Handling and Logging for the packages as per the requirements.
• Created, Tested and Deployed SSIS Packages for Data Migration into Fact and dimension tables in the data marts from the source data warehouse tables.
• Designed and Built Cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs using SQL Server Analysis Services (SSAS).
• Optimized the query performance on cube by following the recommended best practices.
• Designed and developed various Reports on SSAS Cubes as the data source.
• Documentation of all the processes involved in maintaining the database for future reference.
• Actively involved in identifying business requirements with the client
• Enhanced the logical and physical database design to fit new business requirements, and implemented new design into SQL Server 2012

Environment: SQL Server 2008 R2/2012, MS SSIS, SSRS, SSAS, SAS, MS Visio, Windows 7, MS Office, MS Visual Source Safe

Confidential, TX

SQL Server Developer

Responsibilities:

• Actively involved in identifying business requirements with the client.
• Enhanced the logical and physical database design to fit new business requirements, and implemented new design into SQL Server 2008 R2.
• Created complex T-SQL queries, stored procedures, and user-defined functions (UDFs) to encapsulate business logic that is frequently and commonly used, thereby making the system more modular, secured and extensible.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Implemented complex business requirement in back-end using efficient stored procedures and flexible functions, and facilitated easy implementation to the front-end application.
• Optimized the performance of queries with modifications in T-SQL queries, eliminated redundant and inconsistent data, established joins and created indexes whenever necessary.
• Developed, created and implemented complex ETL strategy to grab the data from OLTP, perform various transformations and dump the incremental data into Data Mart.
• Optimized ETL packages using various SSIS features at Control Flow and Data Flow level
• Implemented event handlers in SSIS package for event handling and used custom and system logging, precedence constraints, various transaction types for error handling.
• Implemented checkpoints at various stages in SSIS package for better performance

Environment: MSSQL Server 2005/2008, Visual Studio 2010/2005, Reporting Services (SSRS 2008/2005), Business Intelligence Development Studio (BIDS), MS Office 2007, MS Access, ETL, Performance Point Server 2007, MS Excel.

Confidential, TX

SQL Server Developer

Responsibilities:

• Involved in designing the new packages & also modified the existing packages for the ETL Load using SSIS 2008 to load data to and from various sources.
• Created T-SQL queries, stored procedures, triggers, views and user defined functions (UDFs) to create, modify and/or maintain databases.
• Developed logical and physical data model / database, ETL processes BI reporting queries while meeting business / user requirements.
• Responsible for processes that generate various reports related to risks analysis for internal and external users.
• Created packages to extract data from a Flat file from the SharePoint folder to be modified and save as an Excel output file.
• Responsible for migration task for existing processes residing in SQL Server .
• Gathered reporting requirements from the requestor and shared report options with the requestor.
• Created mock-up reports for review.
• Gathered and shared report options with clients.
• Responded quickly to report modification requests.

Environment: SQL SERVER 2008, T-SQL, SSRS, SSIS, SSAS, MS Excel, MS Office, SQL assistant.

Confidential, Chicago, IL

SQL Server Developer

Responsibilities:

• Involved in designing the physical databases model on SQL Server 2000 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database.
• Created T-SQL queries, stored procedures, triggers, views and user-defined functions (UDFs) to create, modify and/or maintain databases.
• Optimized the performance of queries with modifications in T-SQL queries, eliminated redundant and inconsistent data, established joins and created indexes whenever necessary.
• Developed, created and implemented complex ETL strategy to grab the data from OLTP, perform various transformations and dump the incremental data into Data Mart.
• Optimized ETL packages using various SSIS features at Control Flow and Data Flow level
• Implemented event handlers in SSIS package for event handling and used custom and system logging, precedence constraints, various transaction types for error handling.
• Import/Export and successfully migrated the Databases such as DB2 to SQL Server 2000 using DTS.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Worked on other packages of the SQL server 2005 Edition SSRS (SLQ Server Reporting Services), SSAS (SQL Server Analysis Services).

Environment: SQL Server 2008 R2, MS Access, Excel, Windows Server 2008, Microsoft Visual Studio, MS Visio, MS Integration, Analysis and Reporting Services, Management Studio