PROFESSIONAL SUMMARY:

• Over 9+ years of IT industry experience with Microsoft SQL Server 2005/2008/2008 R2/2012/2014, SSIS/SSRS/SSAS and OLAP as SQL Developer.
• Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Expert in Developing reports onSSAS & SSRSonSQL Server ( 2005/2008/2008 R2).Sound Experience and understanding ofSSAS, OLAP cube and Architecture using BIDS.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Expert in configuring and creating SSIS solutions for high performance Data Integration, Data Migration and Business Intelligence Process that includes Merging Data from various Heterogeneous Data Stores, Populating Data Warehouses and Data Marts, Cleaning and Standardizing Data.
• Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
• Experience in Data Modelling, Normalization and building Referential Integrity Constraints, Database Design and Programming, Development and Implementation of Client-Server Applications & Database systems using MS SQL 2005/2008/2008 R2/2012 for both OLTP & Business Intelligence applications.
• Expertise in OLTP/OLAP system study, Analysis and developing Database Schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Strong working experience in SQL Server and T-SQL in constructing triggers, tables(DDL), Joins, cursors, user functions, views, indexes, user profiles, relational database models, data dictionaries and data integrity.
• Expertise in creating indexed tables with Primary, Foreign key constraints to maintain referential integrity.
• Good understanding in implementing different types ofReplicationModels such asTransactional, Snapshot and Merge.
• Developed and consumed WCF Services to achieve Service Oriented Architecture (SOA) and communication between heterogeneous applications
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Well versed in Performance Point Server 2007. Designed Dashboards, Scorecards and reports using multiple KPI’S, OLAP charts and SSRS Reports with PPS.
• Expertise in Team Foundation Server (TFS) 2012/2010 & 2008 Administration Included Project Administration, Users, Groups, Permissions and Trigger, Data Tier.
• Involved in Develop, analyze and execute system test plans and worked closely with QA group.
• Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Implemented error handling and roll back process in ETL load.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Excellent ability to gather and understand business requirements and translate into IT solutions with the use of Cognos.

TECHNICAL SKILLS:

Operating Systems: Microsoft Windows 2000/2002/Vista/Windows 7/Windows 8/Mac OS X

Databases: MS-SQL Server 2000/ 2005/2008/2008 R2/2012/2014, Oracle 9i/10g/11g, DB2, MS Access

SQL Server Tools: SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS), Server Query Analyzer, SQL Server Agent, SQL Jobs, SQL Alerts and SQL Mail, SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), BIDS, DBCC, BCP, SQL Server Profiler, Microsoft Performance Point Server.

Data Modeling Tools: Erwin, Microsoft Visio 2000/2003 Microsoft Project/Office 2003,2007, 2010, 2013

ETL Tools: Experienced working with SSDT/BIDS - DTS, SQL Server Integration Services (SSIS), SQL Server Reporting (SSRS), Informatica.

Reporting Tool: SQL Server Reporting Services (SSRS)

Languages: T-SQL, PL/SQL C, C++, HTML, XML/XSLT/.Net/WCF/C#,Core Java, Python

PROFESSIONAL EXPERIENCE:

Confidential, Eden Prairie, MN

Sr. BI Developer

Responsibilities:

• Actively involved in business rule analysis; gathered user requirements.
• Wrote several SQL Scripts such as finding tables that have Identity Columns, finding tables that don’t have primary key.
• Used Joins, correlated and Non-correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION statement & using the TOP operator to limit the Select Statement in certain Queries.
• Created views to restrict access to data in a table for security.
• Developed complex Stored Procedures and views to generate various Drill-through reports, Parameterized reports and Linked reports using SSRS.
• Build different types of chart reports using SSRS like column chart and Pie charts.
• Worked onVB.Net(Windows App) andC#.Net(Web Application) for developing the utilities such asServer Manager, Patient Merger, Visit Re open, Open DoorandHide Visit.
• Responsible in created and consumed WCF (Windows Communication Foundation) using C#.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel Spreadsheet and Flat files into SQL Server 2008R2 for further Data Analysis and Reporting by using multiple Transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all and Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Developed Reports out of the Consolidated Data Warehouse for the Business Users using MS SQL Server Business Intelligence Development Studio (BIDS) 2008 (SSRS).
• Using Team Foundation Server (TFS) 2012/2010 & 2008 Administration Included Project Administration, Users, Groups, Permissions and Security management, Notification and Trigger, Data Tier, Proxy.
• Writing Customized Deployment Process templates for deploying source bits to Dev/QA/UAT/PROD Environments using PowerShell, Microsoft Octopus, MS deploy & TFS.
• Enhanced performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes and scripts.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.
• Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server and scheduled the monthly/weekly/daily reports to run automatically and send the reports via email.

Environment: SQL Server 2005/2008/2012/2014, SSIS, SSRS, Visual Studio,.Net, C#, WCF MS DOS Batch scripting and COBOL.

Confidential, Boston, MA

Sr. SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server Integration Services (SSIS).
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2008.
• Involved in loading the partner flat files into the OLTP database.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Developed error handling routines for packages using both script tasks as well as in the error handling environment.
• Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated measures, dimension members using MDX, mathematical formulas and user defined functions, named calculations using SSAS for generation of cubes.
• Implemented various notifications based upon the scheduling jobs, database monitoring, disaster recovery plans and wrote windows scripting scripts for automation of the tasks.
• Developed reports by using SSRS and deployed them on web pages using ASP.NET using C#.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
• Responsible for creating parameterized, cascading, configuration, drill down, rollup reports using SSRS and deploying them into server using report builder.
• Created UNIX shell scripts, JCL mainframe procedures and processes to extract data from various sources such as DB2 and Oracle.
• Developed stored procedures, user-defined functions, triggers, indexes, cursors and views in SQL Server, DB2 databases.
• Developed processes, automation of maintenance jobs, tuning SQL Server, data validations, locks and indexes configurations.
• Worked on Performance tuning of ETL transformations, data validations and Stored Procedures.
• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
• Extensive Experience in Migrating Database from SQL Server and
• Administered SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.

Environment: Microsoft SQL Server 2000/2005/2008 Enterprise Edition, MS Access, ETL Packages(SSIS), SQL Server Analysis Services(SSAS), MDX, .Net, VB.Net, HTML, Visual Studio, Visual Source Safe, DTS, T-SQL, Oracle 10g.

Confidential, Anthem, CA

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, DB2, SQL 2000, and SQL 2005).
• Created Configurations to make package portable and created Event handlers for handling package error.
• Worked on Report Creation from TFS using SQL Server Reporting Services, Excel Reporting From Work Item Query and SharePoint Dashboard.
• Hands on Experience in use of Power Tools, TFS Side Kick, Performance Analysis of Logs(PAL) Tool and Team Foundation Server Best Practices Analyzer(BPA).
• Ensuring Standard Branching/Merging for each Release Cycle using TFS Inbuilt Feature.
• Managing Build process for which solution includes dependency on Microsoft Framework .Net Version (1.0, 2.0, 3.0, and 4.0) and external dependencies.
• ConfiguringClustering, Log shipping and Merge ReplicationatSQL Server leveland monitoring.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 asSSISPackages.
• Used Performance Point Server to create reports, scorecards and dashboards.
• Created score cards with executive summary dashboards using MS Office Performance Point Server 2007, Dashboard Designer that display performance monitoring measures for sales, sales trends, and book return rates for a fictitious book publisher deriving data from a SQL Server 2005/2008 OLAP data source and deployed them to SharePoint sites.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• DevelopedMDX Queriesagainst SSAS cubes to generate reports using BIDS.
• Managed AMO (Analysis Management objects) usingBIDS.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Power Pivot table based on OLAP cubes.
• OLAP design (SSAS 2008R2) for different cloud services and service items. Implemented OLAP cube and connecting using Excel Power Pivot.
• Trained the end-users to access OLAP cube using Excel Power Pivot.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Designed Cubes with star schema in SSAS and Executing Analysis Services Processing Task in SSIS for processing cubes in packages.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages
• Created Project Expense Statements in all Data marts and other Financial Reports using SSRS.
• Developed yearly and quarterly company expense reports.
• Responsible for Deployment of the report using SSRS and used Report subscription (Data Driven and Email) to publish reports.
• Tuning SQL query for better performance using SQL Profiler.
• Actively supported business users for change requests.

Environment: SQL Server 2008/2005, Enterprise Edition, SSRS, SSIS, Spotlight, MS SharePoint, Microsoft Excel Power Pivot, MS Access 2000 & Windows 2003/2000 platform, VB.NET,ASP.NET.

Confidential, Philadelphia

MS SQL Developer

Responsibilities:

• Performed extensive data extraction from web and other sources and handled data preparation missing values, formatting, transformations using SSIS.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into Data Warehouse.
• Written Stored Procedures and SQL scripts both in SQL Server and Oracle to implement business rules for various clients.
• Designed T-SQL scripts to identify long running queries and blocking sessions.
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions.
• Worked with various SSIS control flow tasks and data transformation tasks like Data Conversion, Derived Column, Look-up, Fuzzy Look-up, Conditional Split etc. as part of ETL.
• Data migration (import & export - BCP) from Text to SQL Server.
• Error handling using Try-Catch Block.
• Normalization and De-Normalization of tables.
• Developed Backup and Restore scripts for SQL Server 2005.
• Installed and Configured SQL Server 2005 with latest service packs.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions.
• Written T-SQL queries for the retrieval of the data.
• Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
• Worked with the developing team in the Writing functions in Visual Basic 6.0 for Upload download functionality, Data transfer and migration.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau.
• Prepared daily and weekly status reports and collaborated with other team members.
• Involved in migration of catalogs, Reports from Impromptu to Cognos8 & Report Net using Migration Utility. Used Cognos Scheduler to schedule the Reports.
• Scheduled and Distributed reports using Schedule Management in Cognos Connection.
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
• Customized the stored procedures and database triggers to meet the changing business rules.
• Implemented indexes for performance tuning.
• Data loaded into the database using SSIS 2005 from flat files.

Environment: SQL Server 2005, SQL Server 2000, Oracle 9i, Visual Basic, Excel, R, Tableau, Cognos Report Net 1.1, SPSS.

Confidential, Minneapolis, MN

MS SQL Server Developer

Responsibilities:

• Created tables, views, indexes based on the requirements.
• Wrote complex SQL queries to retrieve information from the databases depending on the requirement.
• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• 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.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Involved in performance tuning using indexing (Clustered Index, Non Clustered index) tables.

Environment: SQL Server 2000/2005, Visual Basic, .NET

Confidential

SQL Server/SSIS Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC).
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2000 to SQL Server 2005.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension Wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Calculated measures and dimension members using multi-dimensional expression (MDX).
• OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Developed a High level dashboard using SSRS 2005.
• Involved in designingParameterized Reports and Report Modelsfor generatingAd-Hocreports as per the client requirements.
• Created Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.
• Managed and created and altered Databases, Tables, Views, Indexes, and Constraints with business rules usingT-SQL
• Created complex Stored Procedures, Triggers and User Defined Functions to support the front-end application
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions.
• Performed SDLC support services, Duties include new account development, customer management, stakeholder identification, requirements analysis, product planning, scheduling, design, development, support, managing projects and client expectations.

Environment: SQLServer 2005/2000, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.