SUMMARY

• SQL Server/BI developer wif over 8 years of IT experience in Database/Data Warehouse design,development & administration using Microsoft SQL Server 2012/2008R2/2008/2005, T - SQL, SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS), SQL Server Analysis Services (SSAS).
• Expertise in creating/modifying Tables, Views, Stored Procedures, Functions, indexes and Triggers and in depth knowledge in query optimization & performance tuning.
• Have strong experience in designing SQL Server SSIS packages (ETL) to import and transform data between databases and external data sources.
• Proficient in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in migration of data from heterogeneous database like Excel, MS Access, Oracle, and DB2 to MS SQL Server by using Import Export Wizard, DTS and SSIS / ETL.
• Proficient in using DTS packages and BCP utility including extensive knowledge of exporting and importing data to and from SQL Server to any OLEDB and ODBC provider.
• Experience in developing and deploying reports using MS SQL Server Reporting Services (SSRS) 2012/2008R 2/2008/2005.
• Experience in creating ad-hoc reports by using Excel and Report Builder in SSRS 2012/2008R 2/2008/2005.
• Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Developed and deployed OLAP cubes using SQL Server Analysis Services (SSAS) 2012/2008R 2/2008/2005.
• Experience in designing Data Mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
• Experience in SQL Server disaster recovery, backup/restore, migration, and upgrade.
• Experience in developing physical database architecture using ERwin Data Modeler and MS Visio 2003/2007.
• Excellent Analytical, Interpersonal and Communication skills, fast learner, hardworking and versatile team player.
• Ability to work independently or as part of a team to accomplish critical business objectives as well as good decision making skill under high pressure complex scenarios.

TECHNICAL SKILLS

• MS SQL Server 2012/2008R2/2008/2005
• Oracle 11g/10g/9
• Transact-SQL (T-SQL)
• HTML4.0
• XML
• MS SQL Server Integration Service (SSIS)
• MS SQL Server Analysis Services (SSAS)
• MS SQL Server Reporting Service (SSRS)
• SQL Profiler
• SQL Query Analyzer
• Database Engine Tuning Advisor
• Visual Studio 2005/2008
• DTS
• Microsoft Visual SourceSafe
• DB2 Server
• Sybase Server iSeries Navigator
• Oracle Query Analyzer
• Red Gate SQL Compare
• Toad for Data Analysts
• SQL Assistant
• Tortoise Subversion 1.5
• ERwin Data Modeler r7.2
• MS SharePoint
• MS Access
• MS VISIO
• MS Office Suite
• Windows Server 2003/NT/XP/2000.

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Sr. SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Responsible for teh entire project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.
• Created ETL/SSIS packages to extract data from various sources like SAP, Teradata, Excel, Flat files to SQL Server systems using different SSIS components and used dynamic configuration files and variables for production deployment.
• Performed data cleansing by creating staging tables to eliminate teh dirty data using MS SQL Server Integration Services 2008/2012 (SSIS).
• Coordinated wif teh business users to design and develop reports that improved teh access to financial and order management data using SSRS 2008/2012..
• Worked wif advanced data regions like Tablix, Matrix, Gauges, Charts, Rectangle, and Textboxes and generated Sub-Reports, Drill down reports, Drill through reports and parameterized reports using MS SQL Server Reporting Services (SSRS).
• Generated report in Excel Power Pivot using SSAS Cube.
• Developed SSRS solution for teh business users to insert/update/delete teh data directly into database tables using SSRS report and this solution halped in minimizing user requests.
• Defined Multidimensional Expressions (MDX) Scripts for querying teh data from OLAP Cube (SSAS) and build SSRS reports on top of cube.
• Developed MDX Scripts to provide a specialized syntax for querying and manipulating teh multidimensional data stored in OLAP Cube (SSAS).
• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints using T-SQL in MS SQL Server Management Studio 2008.
• Build SQL Development environment for teh Accounts Receivable side of teh business that halped teh team to develop and test teh applications/processes first in Development environment before deployment to Production environment.
• Created various ad-hoc reports by defining SQL queries wifin excel that halped refreshing teh data directly from teh SQL databases on weekly and monthly basis.
• Assisted wif automation of finance department’s manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.
• Experience in working wif tools such as Toad for Data Analysts, SQL Assistant, Tortoise SVN (Subversion) and Red Gate’s SQL Compare.

Environment: Windows 2008 Server, Microsoft SQL Server 2008/2012, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), C#,MS SQL Server Agent, MS Excel 2007, Oracle11g, Toad for Data Analysts, SQL Assistant, Tortoise (SVN) Subversion 1.5.

Confidential, Solon, OH

Sr. Data Warehouse/SSIS/SSRS/SSAS Developer

Responsibilities:

• Worked wif business analysts to identify, design and implement solutions for (ETL) extraction and integration of data to and from databases for teh purposes of data extraction and reporting using MS SQL Server Reporting and Integration Services 2008 (SSRS/SSIS).
• Designed ETL/SSIS packages to extract data from various sources like DB2 Server, SQL Server database, Excel, CSV, and Flat files to teh Data Warehouse.
• Applied various data transformations like Slowly Changing Dimensions, Conditional Split, Lookup, Fuzzy Lookup, Data Conversion, Derived Column, Sort, Merge, and Union All using SSIS/ETL.
• Secured and Configured ETL/SSIS packages for deployment to production using Package Configurations and Deployment Wizard.
• Used C# Script to skip header in excel and loaded data into database using SSIS.
• Responsible for troubleshooting and problem solving during SSIS package development and deployment and also in scheduling jobs to call packages using SQL Server Agent.
• Involved in creating and maintaining data warehouse fact and dimension tables and views that provide sales data to SSAS Cube and finally to SSRS Reports.
• Modified existing reports to accommodate changes in business needs using SSRS.
• Involved in testing SSRS reports for teh sales amount values using Pivot table functionality in Excel by connecting it to SSAS cube.
• Designed Multidimensional Expressions (MDX) to create roles in SSAS database to limit teh access of teh SSRS report user to particular territory to which that user belongs. created job schedules to run Full or Incremental load ETL jobs and to process SSAS database using SQL Server Agent.
• Created various work flow diagrams in MS Visio 2007 for IT Change Control meetings.
• Monitored SQL Server Agent Jobs created to load data into data warehouse and to process SSAS cube and was also responsible to troubleshoot for any error on job failure.

Environment: Windows Server 2008, DB2 Server, Microsoft SQL Server 2008, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), MS SQL Server Agent, iSeries Navigator, MS Excel 2007, MS Visio 2007.,C#

Confidential, Madison, WI

SQL Server /BI (SSIS/SSRS) Developer

Responsibilities:

• Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data model using ERwin Data Modeler.
• Involved in designing, developing and testing of teh ETL (Extract, Transformation and Load) strategy to populate teh insurance data from various source systems feeds usingSSIS.
• Worked Extensively wif MS SQL Server Integration Services (SSIS)to import, export and transform teh data between teh linked servers.
• Created packages using MS SQL Server Integration Services (SSIS) for data extraction from Flat Files, Excel files, OLEDB source to data warehouse.
• Used SSRS to create reports, customized reports, On-Demand reports and Ad-Hoc reports and involved in analyzing multi-dimensional reports inSQL Server Reporting Services 2005.
• Developed stored procedures, triggers and functions to account for some automated insertion of records in some of teh tables.
• Worked wif BCP utility and Bulk Insert to load data from different data sources to SQL Server.
• Used SQL Profiler to monitor teh server performance, debug T-SQL and slow running queries.
• Managed users including creation/alteration, grant of system/database roles and permission on various database objects.
• Tested and configured automated routine maintenance tasks like performance tuning, indexes and stored procedures, checked deadlocks and created jobs and scheduled them.
• Detailed documentation on SharePoint of all teh migrations, procedures and packages for future references.

Environment: Windows 2003 Server, MS SQL Server 2005, SQL Server Management Studio, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), T-SQL, MS Excel 2003, and CA ERwin DM r7.2.

Confidential, Austin, TX

SQL Server/SSRS/SSAS Developer

Responsibilities:

• Involved in planning, defining and designing data and provided documentation.
• Upgraded SQL Server 2000 databases to 2005, using detach/attach, backup and recovery.
• Followed Microsoft recommendations, identified issues and analyzed SQL Server components from SQL Server 2000 using Upgrade Advisor Wizard.
• Created data models to be used by end-users to generated ad-hoc reports using SSRS.
• Generated reports using SSRS that could be used to send information to different Primary vendors, clients and managers.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer.
• Designed and implemented stored procedures and triggers for automating tasks.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Implemented SSAS cubes, facts and dimension tables to perform analysis.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Environment: MS SQL Server 2000/2005, T-SQL, MS Visual Studio 2005, SSIS 2005, SSRS 2005, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Windows XP, MS Office 2003, MS Access 2003.

Confidential

SQL Server/DTS/SSIS Programmer

Responsibilities:

• Interacted wif business analysts to understand teh business requirements
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Created T-SQL triggers and Stored procedures encompassing business rules.
• Involved in creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Wrote complex T-SQL queries for data extraction.
• Migration of data from text files to SQL Server 2000 using BCP and DTS packages.
• Written DTS packages to move data between production, staging and QA environment.
• Created Backups for databases and automated teh process.
• Performed T-SQL tuning using MS SQL Profiler and Index tuning wizard.

Environment: SQL Server 2000, Windows NT, Access 2000, MS SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS).