SUMMARY:

• Over 8 years of IT experience as a MS SQL Server Developer in analysis, design, implementation & administration of Business intelligence solutions (SSIS/SSRS/SSAS) with Microsoft SQL server 2014/2012/2008 - R2/2008/2005 in development, testing & production environment.
• Conversant with all phases of Software Development Life Cycle ( SDLC ) involving Systems Analysis, Requirement Gathering and Analysis, High Level Design, Detailed Design, Development and Implementation Support.
• Excellent experience to deliver comprehensive Business Intelligence through integration of BI suite of products ( SSIS, SSAS, SSRS ) including MS solutions like Microsoft Excel.
• Extensively used Erwin for Logical Data Modeling, Physical Data Modeling, Logical-to-Physical Transformation, Forward engineering, Reverse engineering, and Model-to-model comparison.
• Strong knowledge of Data Warehousing methodologies and concepts, including Star Schemas , Snowflake Schema , SSIS processes, Dimensional Modeling and Reporting tools.
• Highly proficient in using T-SQL for developing complex Stored Procedures , Effective Triggers, Tables, Views, User defined Functions, Relational Database Models and Data Integrity, SQL Joins, Indexing and Query Writing.
• Strong ability in Data warehousing tools, Data Mapping , Unit Testing, Migration, Conversions , and Process Documentation
• Proficient in Creating, Configuring, Deploying and Fine-tuning MS SQL Server Integration Service (SSIS) packages.
• Well versed in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS including tools like BCP utility, DTS and SSIS /2012 Packages with proper control flow and data flow elements by using MS SQL Server.

TECHNICAL SKILLS:

• Databases: MS SQL Server 2016/2014/2012/2008 MS - Access 16.0/15.0/14.0/12.0
• Database Tools: Enterprise Manager, Query Analyzer, SSMS, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, Database Engine Tuning Advisor, SQL Server Dashboard, Business Intelligence Development Studio (BIDS)
• SQL: Server Reporting Services (SSRS), Crystal Reports 12/9, Tableau 9.3, Org Publisher, Microsoft Share Point
• Data Modeling: Erwin, TOD, Fact and Dimensional Data Modeling, UML, Logical data modeling and Physical data modeling
• SQL: Server Integration Services (SSIS),IBM Data Stage 7.5
• Operating System: Windows 2010/7/8.1/8/7, Linux CentOS 7, Solaris 11, Windows Server 2008 R2
• Designing Tools: Rational Rose, MS Visio
• Applications / IDE: Visual Studio 2015/13/12/10, Adobe Photoshop, Adobe Dream viewer
• MSOffice, MS: Project

Professional Experience:

Confidential, Denver, CO

Sr. MS SQL / SSIS Developer

Responsibilities:

• Worked with Stored Procedures, tables, and views and other SQL joins and statements for applications by using T-SQL.
• Used SSIS and T-SQL stored procedures to transfer data from source databases to staging area and finally transfer into data warehouse.
• Taking Database Full Backup, Transaction log backup & differential backup in daily routine.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Created SQL server configurations for SSIS packages. Used SSIS transformations to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created packages using the various control flow task such as data flow task, execute SQL task, Execute package task, File System task.
• Performed maintenance of Stored Procedures to improve Performance of different front end Applications.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks .
• Operations and perform the Different required transformation in the Staging Database and make the data ready to load in the Data Warehouse Database.

Environment: - MS SQL Server 2016,2014, SQL BI Suite (SSMS, SSIS, SSRS), XML, SI-Base, MS Excel, MS Access 2007 & Windows Server 2012, SQL Profiler, Data Analyzer.

Confidential, Confidential, HI

MS SQL /SI-base/SSIS/SSRS Developer

Responsibilities:

• Created SSIS package to load data from XML Files , Ftp server and SQL Server to SQL Server 2014/2012 by using Lookup, Derived Columns, Condition Split, Ole DB Command, Term Extraction, Aggregate, Pivot Transformation, Execute SQL Task and Slowly Changing Dimension .
• Designed and developed physical and logical Data Models using Erwin and also responsible for Forward Engineering in Data Modeling.
• Defined and Designed data based on business requirement and provided documentation.
• Worked with Agile Methodology tracking the product backlog and resolved the defects assigned in daily scrum.
• Actively took part in Data Modeling/Data Dictionary ODS
• Designed, developed and supported many Tables, Stored Procedures, and Triggers on Sybase and SQL server.
• Worked closely with data modeler to create data model for or modified existing datamodel to support different report running on business object and SSRS.
• Developed Validation Plans for SSIS packages for checking the functionality of each component and Code review.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse.
• Planned and executed SSIS Package step process to load data, validate data and Recommending task to resolve performance issue with loading data in to the Data Ware House .

Environment: - MS SQL Server 2014,2012, SQL BI Suite (SSMS, SSIS, SSRS), XML,SI-Base, MS Excel, MS Access 2007 & Windows Server 2008, SQL Profiler, Data Analyzer, Erwin r 7.3, .Net 4.0/4.5, TFS 2010.Sybase 15, Informatica9.0

Confidential, Little Ferry, NJ

MS SQL /SSAS/SSIS/SSRS Developer

Responsibilities:

• Worked closely with Business Analyst, Team Leader, DBA and Technical Manager in order to gather requirements for design and implementation of database for their existing customers as well as new online customers.
• 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.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database , Excel spreadsheet, and flat files into SQL Server 2008 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.
• Generated several dimensions, cubes, 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.

Environment: - MS SQL Server 2012, SSRS, SSIS, SSAS, VB.Net, EXCEL, MS Access, ORACLE 10g, Erwin Data Modeler v7.0/v4.x.

Confidential, San Diego, CA

MS SQL /SSIS/SSRS Developer

Responsibilities:

• Developed backup restore scripts for SQL Server as needed.
• Involved in Creation of Reports, Created ODBC Connections and database Connections.
• Wrote complex ETL scripts using SQL server integration services.
• Deeply involved in developing SSIS packages for extracting the data from database transforming it and loading into the data warehouse.
• Worked on various SSIS objects like Data flow components, Control Flow elements, Connection Manager, Event Handling and log providers.
• Based on the required reports, identified various data sources and Confidential the connections using SSIS and constructed data source view.

Environment: - MS SQL Server 2012/2008, SSRS/SSIS, Microsoft Office SharePoint Server 2007/2010, Crystal reports, T-SQL, Windows 2007.

Confidential

MS SQL /C#.net/SSIS/SSRS Developer

Responsibilities:

• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Involved in designing the physical databases model on SQL Server 2005 RDBMS using different Data Definition and Manipulation languages ( DML/DDL ) implementing constraints and triggers for data integrity.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created OLAP Cubes and was responsible for OLAP processing, Optimizing Dimensions, creating hierarchies and adding the Aggregations to the Cube.
• Performed partitioning of cubes as well as cube optimization in order to increase the performance of cubes.
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.

Environment: - Microsoft SQL Server 2005 Enterprise Edition, T-SQL, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, Windows server 2003 and IIS 5.0, Visual Source Safe.