PROFESSIONAL SUMMARY:

• SQL Server / BI (SSIS/SSRS/SSAS) developer with 9 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.
• Expertise in designing SQL Server SSIS packages (ETL) to import and transform data between databases and external data sources.
• Experience 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.
• Experience 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.
• 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 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:

BUSINESS SKILLS/TECHNICAL SKILLS: MS SQL Server 2012/2008R2/2008/2005, Oracle 11g/10g/9, Transact-SQL (T-SQL), 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, Visual Basic VB.Net, Microsoft Visual SourceSafe, DB2 Server, Teradata, Sybase Server, iSeries Navigator, Oracle Query Analyzer, Red Gate SQL Compare, Toad for Data Analysts, SQL Assistant, Tortoise Subversion 1.5, TFS version control, ERwin Data Modeler r7.2, MS SharePoint, Crystal Reports, MS Access, MS Visio, MS Office Suite, Windows Server 2003/NT/XP.

PROFESSIONAL EXPERIENCE:

Confidential, Trumbull, CT

SQL Server BI (SSIS/SSRS/SSAS) Developer

Responsibilities:

• Responsible for the 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 the dirty data using MS SQL Server Integration Services 2008/2012 (SSIS).
• Worked with the business users to design and develop reports that improved the access to financial and order management data using SSRS 2008/2012.
• Worked with 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).
• Developed SSRS solution for the business users to insert/update/delete the data directly into database tables using SSRS report and this solution helped in minimizing user requests.
• Defined Multidimensional Expressions (MDX) Scripts for querying the 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 the 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 the Accounts Receivable side of the business that helped the team to develop and test the applications/processes first in Development environment before deployment to Production environment.
• Created various ad-hoc reports by defining SQL queries within excel that helped refreshing the data directly from the SQL databases on weekly and monthly basis.
• Assisted with 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 with tools such as Toad for Data Analysts, SQL Assistant, TFS Version Control and Red Gate’s SQL Compare.

Project 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), MS SQL Server Agent, MS Excel 2007, SAP, Toad for Data Analysts, SQL Assistant, TFS Version Control, Red Gate’s SQL Compare 8.0.

Confidential, Parsippany, NJ

SQL Server Data Warehouse (SSIS/SSRS/SSAS) Developer

Responsibilities:

• Worked with business analysts to identify, design and implement solutions for (ETL) extraction and integration of data to and from databases for the 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 the 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 vb.net Script in SSIS packages to send email notifications upon the completion of SSIS jobs.
• 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 the 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 the access of the SSRS report user to particular territory to which that user belongs.
• Involved in creating 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.

Project 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, Tortoise (SVN) Subversion, vb.net, MS Excel 2007, MS Visio 2007.

Confidential, Princeton, NJ

SQL Server/SSIS/SSAS 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 the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds usingSSIS.
• Worked Extensively with MS SQL Server Integration Services (SSIS)to import, export and transform the data between different 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 the tables.
• Implemented SSAS cube, fact and dimension tables to perform analysis.
• Prepared Source to Target mapping document with the business logics and transformation rules used in ETL SSIS packages.
• 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 the migrations, procedures and packages for future s.

Project 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, Philadelphia, PA

SQL Server/SSRS 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.
• Used BCP utility and Bulk Insert to load data from different data sources to SQL Server.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Project 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 Programmer

Responsibilities:

• Interacted with business analysts to understand the 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 Staging, QA and Production environment.
• Created Backups for databases and automated the process.
• Performed T-SQL tuning using MS SQL Profiler and Index tuning wizard.

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