SUMMARY:

• 8+ years of referable IT experience in Data Warehousing and Business Intelligence applications design, development, and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS) and Data Transformation Services (DTS).
• Extensive experience in Database Design, Data Modeling, T - SQL Development, Developing and Implementing ETL Packages.
• Expert in all areas of SQL Server development including tables, user defined functions, views, indexes, Stored procedures, functions, triggers, clustering, relational database models, data dictionaries, and data integrity.
• Expert in using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries.
• Well versed in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.
• Expertise in solving Dead Locks/Long running queries using Performance Monitor and SQL Profiler.
• Experience in creating automated administrative functions such as backing up and restoring databases, copying SQL Server databases and the objects they contain, copying SQL Server objects, and loading data using SSIS.
• 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.
• Excellent experience in developing stylish Drill Down, Cascading, Drill through, Parameterized, Sub reports and Charts using Global Variables, Expressions and Functions using SSRS.
• Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
• Good understanding and designing of Star and Snow Flake Schema used in relational, dimensional, and multidimensional data modeling.
• Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication, Log shipping, clustering (Active/Passive) and Database Mirroring.

TECHNICAL SKILLS:

RDBMS/DBMS: MS-SQL Server 2014, 2012, 2008R2, 2005, 2000, Oracle 11g, 10g, MySQL

Database Tools: SQL Server Enterprise Manager, SQL Server Integration Services (SSIS), SSAS, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), DTSX, Data Stage PX 8.1, 7.5, Team Foundation Server (TFS)

Reporting Tools: Microsoft SQL Server Reporting Services (SSRS), Crystal Reports, Tableau 7.0, 8.0, 9.0.

Operating Systems: Windows 7/8/8.1/10, Windows XP, 2000, Windows 2003 Server

Programming Languages: SQL,T-SQL,PL/SQL,XML,HTML4.0,5.0,VisualBasic6,VBScript, C#, .NET

Design Tools: Erwin 7/4, MS Visio 2007/2010

BI Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS)

PROFESSIONAL EXPERIENCE:

Confidential - Northlake, IL

Sr. SQL Server SSIS/SSRS/SSAS Developer

Roles & Responsibilities:

• Provide database administration and day-to-day support of MS SQL Server databases, including backup and recovery procedures, database utilities, and data replication technologies while supporting the development, test and production environments.
• Created Power BI Reports in Power BI desktop and published them to Power BI Service.
• Worked on tuning and performing queries and objects in the database.
• Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel.
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to Power BI Service.
• Rebuilt Indexes and Tables as part of performance tuning exercise
• Worked on ETL programming for capturing data from disparate sources using SQL Server Integration Services (SSIS, SSRS) with Visual Studio 2010 and 2012, and Analysis Services.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, and UDFs.
• Created Indexes for fast retrieval of the data. Involved in Performance tuning and Query Optimization.
• Created new database/tables to put in the extracted data and rebuild the relationship.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Utilized event handling effectively to generate audits and logs for the generated packages.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SSAS.
• Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.
• Created reports as per user requirement using SQL Server reporting services (SSRS) which delivers enterprise and Web-enabled reports.
• Developed Stepped and Block reports using SSRS. Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different locations.
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Worked in Creating partitions and Designing various storage modes to increase the performance of a cube using SSAS.

Environment: SQL Server 2012/2014, MS Excel, SQL Profiler, ETL, T-SQL, MS SQL Server Reporting Services, MS SQL Server Integration Services, MS SQL Server Analysis Services

Confidential - Farmington, MI

Sr. SQL SSIS/SSRS/SSAS Developer

Roles & Responsibilities:

• Collaborated in gathering system specification requirements for the project.
• Collaborated in creation/review of functional requirement specifications and supporting documents during data modeling process.
• Created complex stored procedures with proper error handling, transactions and performance tuning features.
• Redesigned indexes to speed up query performance and utilized database engine tuning advisor for further suggestions.
• Created Triggers to enforce user defined integrity as per the business logic.
• Created tables, views, stored procedures, functions, CTEs and indexes in support of various databases and ETL applications.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Created staging database to perform various ETL data messaging operations such as data profiling, data cleansing and data verification.
• Designed the end-to-end ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources.
• Developed complex mappings utilizing SSIS to transform and load the data from various source systems such as Oracle, Excel and Flat files into the SQL 2014 Server target staging database.
• Implemented various SSIS tasks such as conditional split, derived column for data scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Identified slowly changing transformation, to maintain historical data in data warehouse.
• Implemented Master/Child packages so only the master package needs to be scheduled which will in turn trigger the execution of other packages.
• Implemented debugging of packages using Breakpoints, Checkpoints, Event Handlers and Loggings.
• Configured data source and data source views, dimensions, cubes, measures, partitions, KPIs and MDX Queries utilizing SQL Server Analysis Services.
• Managed very large reports that return a large volume of records and optimized their performance utilizing techniques such as cascading parameters and filters.
• 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.
• Involved in migrating database from SQL Server 2008to 2012 and 2005 to 2008
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
• Used reporting services (SSRS) generated various reports
• Designed several scorecards and dashboards utilizing Power Pivot and Tableau to display information needs by other departments and upper management.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Deployed SSRS reports to the reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Environment: SQL Server 2014, SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL server Profiler, Microsoft Visual Studio 2012, Power BI, Team Foundation Server(TFS), Tableau, SharePoint

Confidential - St. Louis, MO

QL Server/BI Developer

Roles & Responsibilities:

• Implemented stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analysis in SQL Server Management Studio.
• Implemented the logging process for all the SSIS packages.
• Involved on Data Management, Data Dictionary, Data Cleansing, Data Integration, Data Flow Design, and Data Governance.
• Worked on Data warehouse such as dimensional modeling, Star schemas, fact and dimension tables identification and OLAP.
• Involved in development phase meetings for Business Analysis and Requirements Gathering.
• Designed complex Extracts, Transforms and Load strategies to pull data from various sources like SQL server, flat files and OAKS and load it to the destination database after using multiple transformations
• Implemented the Master Child Package Model for easier maintenance and better performance
• Writing ETL process from the scratch and performance analysis
• Developed Cubes using dimensions, measures and measure groups from source data in the data warehouse system
• Involved in data profiling, identifying data quality issues by doing data analysis, impact analysis, and data model enhancements
• Individually worked on developing SSIS packages and Deploying jobs in DEV, STAGE and Production
• Developed SSRS reports as per the BI dashboard project requirements.
• Create new SSIS packages and developed cubes from the scratch, and completed full life cycle till deployment.
• Studied the data requirements and the impact analysis on the existing schema.
• Designed High Level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Worked on Normalized and De-normalized entities for the Data Warehouse.
• Supported SSIS packages in Production

Environment: MS SQL Server, SQL Server Integration Services (SSIS), SSAS, Cognos Reports, SSRS, SQL DBA, JAMS, Visual Studio 2015, Kimball Data Modeling and Star Schema, IBM Cognos Data Manager, Cognos Frame work, SSRS, TFS and Agile Scrum Methodology

Confidential - Windsor, CT

Sr. SQL Server/BI Developer (SSIS/SSRS)

Roles & Responsibilities:

• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files into the SQL Server data warehouse using SQL Server Integration Services.
• Created T-SQL functions and stored procedures to supply comma-delimited lists and date information.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Worked on Data Extraction, Transformation and Loading from different data sources using ETL tool like SSIS as per client requirements.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Worked with Control-M to automate the tasks like migrations and loading data in bulk.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Involved in data migrations from client sources to current design and from other data sources, Good knowledge on using SSMS for querying.
• Worked on high level design of ETS DTS Packages and SSIS Packages for integrating data using OLE DB connection from heterogeneous sources.
• Used Microsoft Visual C#, ASP.NET, HTML 4.0, 5.0 and CSS for web application developing process.
• Involved in performance tuning using views and materialized views, indexing (Cluster Index, Non Cluster index) tables.
• Worked on various backend Procedures and Functions using PL/SQL and T-SQL.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Developed a High-level dashboard using Power BI, SSRS 2008 and Tableau 9.0/9.X.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Troubleshooting and fixing Bugs/issues in the enterprise level web application using C#, .NET, ASP.NET.
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, C#, PL/SQL, Ado.Net, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003

Confidential - White Plains, NY

Sr. SQL Developer

Roles & Responsibilities:

• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Worked on mapping multiple related systems.
• Used BCP command line utility to replicate a database.
• Designed Entity-Relationship diagrams and thus the database schema
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Involved in the development of a normalized database using Data Definition Language (DDL) in T-SQL.
• Performed job scheduling in the SQL Server Environment.
• Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties.
• Responsible for Day-to-day activities like taking backup on disk and restoring the databases and transaction log on production/development servers as per requirement.
• Developed cursors and views to improve performance in data transactions.
• Created and Rebuild the Clustered & Non-Clustered indexes at regular intervals for better performance.
• Conducted data import and export operations using the DTS wizard.

Environment: MS SQL Server 2008, MS SQL Enterprise Manager, SSIS, DTS, T-SQL, and Windows NT

Confidential

Sr. SQL Server Developer/DBA

Roles & Responsibilities:

• Built logical models to describe all the date and relationships between them depending on business requirements.
• Created new database objects like Functions, Procedures, Packages, Triggers, Views, and Indexes using T-SQL in SQL Server 2005.
• Standardized the implementation of data, validated change requests and made appropriate recommendations.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Updated the statistics info for both the old and new servers.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2005, T-SQL, DTS Designer, MS-Office, MS-Excel, VSS

Confidential

Jr. SQL Server Developer

Roles & Responsibilities:

• Extensively involved in creating Stored Procedures, views, tables and constraints.
• Conducted Performance tuning/MS SQL server development-SQL Profiler, SQL scripts, stored procedures, triggers, functions and transactions analysis, thorough understanding of indices and statistics (Query Optimizer).
• Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer and SQL Enterprise Manager.
• Created and administered multiple development, training and production databases.
• Developed and created data dictionary, advanced queries, views and functions for databases.
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check.
• Responsible for creating standards and operating procedures to maintain all databases.
• Worked with development teams in the design of physical databases and in modification.
• Reduced systems downtime risk through automatic offsite backup and recovery over network.
• Responsible for database security of the operational and developmental application system databases.
• Managed MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.

Environment: MS SQL Server 2005/2008, T-SQL, DTS, Oracle 8i/9i, TOAD, Micro strategy, Microsoft Visual Source Safe, MS Visio 2007, MS Projects 2007