SUMMARY:

• Over 7 years of IT experience with MS SQL Server 2017, 2016, 2014/2012/2008 R2/2008/2005 and worked extensively on Integration services (SSIS), Reporting services (SSRS) and Analysis services (SSAS).
• Experienced in all phases of project life cycle & Software development life cycle (SDLC) starting from business requirement gathering, analysis, design, implementation, testing, and production.
• Experience working in Agile and waterfall method of software development life cycle.
• Experience in installation, up gradation and configuration of MS SQL Server 2012/2008 R2/2008/2005 databases.
• Experience working on SQL Server database development using T - SQL in constructing triggers, tables, stored procedures, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Experienced in extracting and transforming data using Import/Export Wizard, Bulk Insert, BCP, and SQL Server Integration Services (SSIS) packages.
• Extensive ETL experience in creating SSIS packages by using different Transformations like Lookup, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all and Script component.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Efficiently implemented SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with C#.NET in SSIS.
• Experience in writing Parameterized Queries for generating Tabular reports, drill down, drill through, click through, matrix, chart, snap shots and formatting report layout using SQL Server Reporting Services(SSRS).
• Experienced in generating Sub reports using Global Variables, Expressions, and Functions, sorting the data, defining data source and subtotals for the reports using SSRS and deploy them to Central Resource Management (CRM) system.
• Experienced in building, deploying, processing and maintaining Cubes using SQL Server Analysis Services (SSAS).
• Experienced in developing and modifying cubes using SSAS, transform into pivot table and generating reports from cubes.
• Experienced using Tortoise Version Control and Team Foundation Server to provide locking and sharing support for files to be shared among multi users.
• Knowledge of Designer tools like Microsoft Visio, Erwin.
• Good experience on DBA functionalities such as setting up User Access, Tuning, Backup, Restoration and Disaster Recovery procedures.
• Excellent communication skills, quick learner and good performer both in team and independent job environments with strong logical and analytical skills.

TECHNICAL SKILLS:

Databases: SQL server 2017, 2016/ 2014/2012/2008 R 2/2008/2005/2000 , MySQL, MS Access, Oracle, Sybase

Programming/Query Languages: SQL, PL/SQLC, C++, HTML, C# and Visual Basic for Application

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, DBCC, SQL Server Profiler.

BI Tools: SQL Server Analysis Service (SSAS), SQL Server Reporting Service (SSRS), MDX, SQL Server Integration Services (SSIS)

Design Tools: Microsoft Office, MS Visio

Operating Systems: Windows NT/98/2000/XP/2008

Version Control: Tortoise SVN, Microsoft Visual Source Safe

PROFESSIONAL EXPERIENCE:

SQL Server/SSIS/SSRS/SSAS Developer

Confidential, Birmingham, AL

Responsibilities:

• Responsible for providing 24x7 Production support, Database and Log Backups &restoration, Backup strategies and scheduling Backups. Backing up system and master databases and restoring them whenever necessary.
• Gathered functional requirements, analyzing and writing the technical specifications.
• Extensive experience in designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Maintained and enhanced SAS-based tool to create disaster recovery files
• Fine tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2000/2005 Analysis Services (SSAS) and Reporting service (SSRS).
• Experience in debugging Stored Procedures using Visual Studio Tool by setting break points.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services.
• Used SAS, SAS Macro, Dialog Manager and list to update and build menu-driven query tool to create SAS reports from accounting database.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers (DDL & DML), User Defined Data types and Functions (UDF).
• Expertise in Troubleshooting Locking, Blocking, Deadlocking and performance issues with very good understanding in SDLC (Software Development Life Cycle).
• Work with App Teams on creating a productive Development, Test and Production environment for App Databases.
• Make recommendations for File Group Creation and Placement, Right Data types for the Structures created.
• Monitor and tune SQL Scripts.
• Creating upgrade scripts for production environment. Responsible for installation of SQL Server Packs and Hot fixes.
• Developed SSIS Packages for Snapshot, Incremental, Historical Changes (SCD Type 2) Data Loads.
• Experience in query optimization & performance tuning using SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements.
• Provided back-end support for performance testing and functional testing using use case testing methodologies.

Environment: SQL Server 2016/2017 Enterprise Edition, Enterprise Manager, ERWIN, UML, MS Project, Windows 2016 Server, SSIS, SSRS, SSAS.

SQL SSIS Developer/SSRS Developer

Confidential, Wayne, PA

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers and Functions.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
• Implemented Performance tuning to optimize SQL queries using query analyzer.
• Tested to optimize the procedures and triggers to be used in production.
• 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 2014
• Involved in project planning, scheduling for database module with project managers.
• Created the reports based on the requirements using SSRS 2014/Crystal Reports XI.
• Generated Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL Promoted RDLs to Reporting Service Server. Wrote the queries for the drill down reports.
• Formatted the reports using the Global variables and expressions.
• Created detailed reports for the customers to help End user Analyze Financial statements by showing demographic information based on various parameters.
• Authored performance based reports for the End user.
• Identified and defined the Datasets for the report generation.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Developed, monitored and deployed SSIS packages.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Created packages in SSIS with error handling.
• Used C# scripts to run custom scripts in package flow
• Worked with different methods of logging in SSIS.
• Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
• Responsible for automation of maintenance jobs, locks and indexes configurations.
• Administered SQL Server security, SQL Server automatic e-mail notification.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions. Handled dead lock scenarios.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Configured replication servers and transactional replication between production and standby server for disaster recovery. Examine two-way database replication using SQL server.

Environment: MS SQL Server 2014/2012, DTS, Windows 7, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), Crystal reports XI, Business Objects XI, SQL Server Query Analyzer, Erwin, SSRS, TFS, FTP Communication, MS-Visual Studio 2010, MS Access, XML, XSLT, ADO.Net

SQL Server/SSIS/SSRS/SSAS Developer

Down Foods, Jackson, MI

Responsibilities:

• Built Data marts (Fact and Dimension tables) from the warehouse tables.
• Designed and developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX
• Used Performance Point Server 2007 (PPS)
• Extract, Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Understand user requirements and Data Model defined and developed by the business analysts and data architects.
• Usage of Ab-Initio EME for dependency/impact analysis and configuration management. Using the same for creating project builds (TAR files) and migrating them to testing and production environment
• Created SSIS Packages according to the requirements.
• Communicate to the business analyst, Data Modeler on a regular basis to be informed on changing requirements or data model design alterations.
• Design and set up of firewall systems, and DNS servers from scratch
• Stage (Extract) the source data from files, SQL server, Oracle, DB2 sources.
• Worked with Flat Files (Pipe Delimited) sources and implemented error handling routines.
• Worked with Flat Files Data source connections, ODBC data source connections (to SQL server sources) and DB2 data source connections.
• Created OLAP Dimensions, Measures and Cubes using SSAS.
• Designed and implemented HyperionSystem9 Essbase multidimensional database.
• Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations.
• Constructed OLTP and OLAP Databases.
• Used Query, SQL, Merge, Case, Validation transforms to transform the data (as needed) before loading into the warehouse tables.
• Wrote custom functions to produce the derived fields using the source table fields for each record from source
• Used Date functions, String functions, Database functions to manipulate and format source data as a part of Data cleansing and data profiling process.
• Worked with Date/time manipulations in SQL Server 2005 built in functionalities as well as Data Integrator Date functions
• Worked on Performance tuning of Abinitio Load processes.
• Generated Parameterized/dropdown SSRS Reports.
• Implemented history preserving using Table comparison, History Preserving and Key generation transformations in warehouse /dimension workflows.
• As a part of optimization: Used MAP operations to route UPDATE and INSERT records in warehouse workflows
• Ran stats on all tables. Right choice of transformations & right design in data flows. Implemented incremental load process
• Handled the cross schema (Warehouse, Data mart) challenges between the different environments (Development, QA and Production) by granting permissions on tables using Database functions in scripts before running work flows.
• Prepared ETL design documents for implemented work flows and loaded the documents in the project share point site.

Environment: SQL Server 2000/2005, Query Analyzer, SSIS 2005, T-SQL, Excel, Microsoft SQL Reporting Services 2005 (SSRS), SSAS 2005, Abinitio, Oracle 10g, Analysis Services (SSAS), DTS, T-SQL, Windows 95/NT/2000/2003, XML, MS Excel, MS Access

SQL BI Developer

Confidential

Responsibilities:

• Responsible for creating SSIS packages to extract data from different sources consolidate and merge into one single source.
• Modified existing SSIS packages to meet current business needs.
• Wrote stored procedures to be used in the SSIS packages.
• Created custom and Ad hoc reports using SSRS.
• Extract, transform and load (ETL) the data from source applications systems into the data warehouse.
• Generated different types of Reports like Tabular, Matrix, Charts, Drill Down and Drill Through reports using SSRS.
• Deployed reports, created report schedules, subscriptions, securing reports.
• Identified the Data Source and defining them to build the Data Source Views.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Responsible for developing Stored Procedures, Triggers, Views and User defined functions.
• Made Efficient use of Joins and sub-queries in queries that involve data from multiple tables.
• Fine tuning of stored procedures to improve the performance.
• Performed Performance tuning on SQL queries, triggers and stored procedures. Used Audit functions to keep track of the changes made to the database.
• Had to modify the current stored procedures to meet the current design.
• Responsible for creating indexed views, and appropriate indexes to cut the complex query time.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Wrote T- SQL queries for data retrieval.
• Took part in the normalization and de-normalization of database.

Environment: SQL Server 2005, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio 2000 and Team Foundation Server.

SQL Server Developer/DBA

InfoTech, Hyderabad, India

Accountabilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2000.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• 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.
• Managed user access. Created and managed new security accounts.
• Backup and restore databases.
• 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 2000, T-SQL, DTS Designer, MS-Office, MS-Excel, VSS.