SUMMARY:

• Over 8+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2000/2005/2008/2012 in Development, Test and Production Environments on various business domains like Financial, Banking Insurance and Healthcare.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008/2012/2014.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Experience in sub - queries, CTE's (common table expression), table variables and physical temptables
• Experience with Agile scrum methodologies for developing and maintaining software.
• Experienced in DW projects ETL testing against DW testing with Informatica and data stage tools.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (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.
• Highly Experience in T-SQL (DDL, DML), documentation, coding, programming and using SQL Server 2000/2005/2008. Used Version control tool Team foundation server (TFS) for the entire development cycle.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Hands on experience in using Team Foundation Server.

TECHNICAL SKILLS:

RDBMS / Databases: MS SQL Server 2014/2012/2008 R 2/2008/2005/2000, Oracle 10g,11g

Languages: C, C++, PL/SQL, TSQL, MYSQL, DHTML, VB.NET, ASP.NET, .NET Frame Work, C#, JavaScript.

Operating Systems: Windows Server 2008/2003/XP/2000/NT/98/95, MS DOS 6.2

Modeling Tools: Microsoft Visio 2007, Erwin Data Modeler 8/7/5

Reporting Tools: Crystal Reports 8/10, SQL Server Reporting Services (SSRS), Power Pivot. Power BI

Integration Services: SQL Server Integration Services (SSIS), Data Transformation Services (DTS)

Analysis Service: SQL Server Analysis Services (SSAS)

Database Tools: MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, OLTP, DBCC, BCP, OLAP, ADO.NET, Database Engine Tuning Advisor ( DTA )

Internet Tools: Internet Information Server ( IIS 5.0 / 6.0 ), FTP, TCP/IP

SharePoint: Microsoft SharePoint 2003 - 2010

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA.

MS SQL Server/SSIS Developer

Responsibilities:

• Designed transformation rules and processes to derive the correct data from the extracted data and transform into the required format and structure to support the business requirements.
• Loading the transformed data into the target database and the associated metadata into the enterprise metadata repository.
• Designed various schemas which are used for Landing the data, staging for transforming the data and PROD in MS SQL SERVER 2012.
• Extensively worked with Team Foundation Server 2012.
• Maintained production OLAP cubes, wrote MDX queries to generate reports using SQL Server 2012 Reporting Services (SSRS)
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Created joins and sub-queries for complex queries involving multiple tables.
• Microsoft Access 2012, 2010: database development; SQL queries, VBA code generation, forms, reporting, procedures.
• Managing and maintaining Oracle databases for SAP and various in-house developed applications.
• Created tables, views, clustered & Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Created Variables, Expressions for Connection String, Project Parameters, Package Configuration, Parent package variables. Worked on Project level deployment in TFS 2012.
• Worked on Slowly Changing Dimensions (Type-1 & Type-2) and Change Data Capture.
• Created Junk Dimensions, Conformed Dimensions and Fact less Fact.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources.
• Worked on using CTE (common table expression) in T-Sql Server and also worked with different methods of logging in SSIS.

Confidential, Philadelphia, PA

Microsoft BI Developer

Responsibilities:

• Involved in gathering and analysis of Business Requirements by interacting with end users.
• Strong Applications Development experience with back-end databases such as SQL Server, Oracle and MS Access using ADO/ADO.NET OLEDB and SQL client.
• Participated in on-boarding of clients and provided support for internal and external audits such as SAS70.
• Having good hands on experience with C#.NET and VB.NET for downloading files from a remote server.
• Front End was designed using VB 6.0.
• Managing all stages of the application from design, development and testing on both development & production environments.
• Creating testing process and documentation in agile environment.
• Designed and architected of OLAP cubes to support business reporting and forecasting processes.
• Wrote various Excel VBA scripts and access queries to massage raw data from carriers across the globe to standardize the data input format and used pivot tables/charts extensively for presenting various trend analysis to the department.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints, CTE (CommonTable Expressions) etc. on various database objects to obtain the required results.
• Involved in creating of T-SQL Stored Procedures, Triggers, View.
• Create joins and sub-queries for complex queries involving multiple tables.
• Developed complex stored procedures to create various reports.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Create documentation as required.
• Performance tuning and testing on stored procedures, indexes and triggers.
• Various Reports were generated including the Purchase Order Form. Used SQL Server Analysis Services 2005 for interaction between client application and instance of Analysis Services.
• Involved in Planning and Monitoring and creating reports in Performance Point Server.
• Implementation of MDM/MDS for Vendor Management.
• Involved in writing MDX queries for cubes and Performance optimization of MDX queries.
• Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.

Confidential, Portland, OR

MSBI / ETL Developer

Responsibilities:

• Developed physical data models and created DDL scripts to create database schemaand database objects. Designed data models using Erwin.
• Created indexes, constraints and rules on database objects for optimization.
• Designed and developed SSIS ETL/SSIS packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Created SSIS package to load data from Flat File to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Data Staging to SQL server. Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Worked in building Multidimensional Expression (MDX) queries and Data Mining Expression (DMX) queries for Analysis Services.
• Designed end to end process solution for Informatica.
• Configured files to deploy the SSIS packages across all environments.
• Responsible for managing BI environment, which includes Business model, Data Model, Data sources,
• ETL/SSIS tools, target data warehouse, Data marts, and Reporting tools.
• Defined report layouts including report parameters and wrote queries for drill down reports, Conditional, Drill Through report, Sub report, using SSRS. Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS). Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions using T-SQL to provide structure to store data and to maintain database efficiently.

Confidential, Addison, TX

MS SQL BI ETL Developer

Responsibilities:

• Work with Business User in Understanding the Rules and do the Data Conditioning
• Created database objects such as Tables, Views, Stored Procedures, Triggers, Indexes and functions.
• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Working on Data Migration and Conversion for Client On-Boarding Product (Gold Tier).
• Implemented complex business logic with Store procedures, User Defined Functions, Views and wrote T-SQL batches with CTE (Common Table Expressions) for recursive operations.
• Involved in modifying the Existing Data ware house and add new Data Points for Data Analysis
• Use ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse.
• Implementation of MDM/MDS for Vendor Management.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Designed number of SSIS packages for data transfer between flat files, XML, Sales Force, Oracle, MYSQL and SQL Server using different transformations like Lookup, Derived Column, Merge Join, Fuzzy Lookup, Script Component and etc.
• Created SSIS Templates for developing SSIS Packages, Implemented SQL Server configurations and error handling in SSIS Packages.
• Involved in deploying SSIS Packages to production from different environments and scheduling and administrating SSIS Packages, wrote best practices for deploying SSIS Package to Production.
• Designed the usage summary, performance, Audit/Log, Job Status and detailed reports for ETL users in SSRS.
• Editing, upgrading and maintaining ASP.NET website and IIS Server.
• Developed GUI front end using web forms in ASP.NET. Created Modules and Classes in Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Involved in gathering requirements for EDW and designed the work flow diagrams and wrote the best practices and naming standards.
• Involved in designing ODS and EDW databases.
• Involved in testing the SQL Scripts for report development, Tableau reports,
• Designed the Dimensions and facts using Star Schema
• Created materialized views as per business requirements and wrote number of stored procedure and dynamic SQL.
• Involved in implementation of Master Data Services through Data Quality Services, Designed the SSIS packages move the data between MDS and EDW.
• Built compelling, interactive dashboards in Tableau that answer key business questions
• Designed SSIS Packages to cleanse, remove duplicates and matching data through Data Quality Services.
• Created SSAS Cubes with multiple dimensions, measures and hierarchies based on OLAP reporting needs.
• Worked on Cube partitions and Aggregations according to the requirements.
• Worked on KPI’s and actions.
• Creating Back Up Strategies and implementing Disaster Recovery

Confidential

MS SQL Server/SSIS/SSRS

Responsibilities:

• Wrote T-SQL Tables, Stored procedures, Views and Triggers for performing database operations on SQL Server 2008.
• Designed, developed & tested complex SSIS ETL Packages to pull data from sources like Flat Files, Excel Files, Various databases (DB2, SQL), JDE and other web applications into the Data warehouse System.
• Utilized Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, and Data Flow Task and transformations like Derived Column, Conditional Split, Lookup, Merge, Sorting, Merge Join, Fuzzy Grouping, Fuzzy Lookup, Row Count, Data Conversion etc.
• Configured and maintained Report Manager and Report Server for SSRS.
• Installed and administered Microsoft SQL Server Reporting Services, created schedule reports and sent reports via email.
• Developed queries for generating drill down reports in SSRS 2008.
• Generated and tested reports using Global Variables, Expressions and Functions for the reports.
• Designed and implemented stylish report layouts.
• Identified and worked with Parameters for parameterized reports in SSRS 2008.
• Created connections to source data by creating Linked Servers using ODBC drivers and OLEDB Providers to move data into Source system (SQL Server database).
• Designed and Generated Reports with SQL Server Reporting Services (SSRS).