SUMMARY:

• Having 5+ Years of IT experience in design, development, testing, presentation, implementation and analysis of SQL Server and SSIS and SSRS.
• Experience in complete Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation.
• Excellent skills in writing complex SQL queries involving multiple tables (Join) ability to develop and maintain views, stored procedures, triggers and user defined functions.
• Worked Extensively on ETL process using SSIS package. Experience in using variables, expressions and functions and defining Query for generating drill down reports in SSRS.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations .
• Effectively used Normalization and De - Normalization techniques for both OLTP and OLAP systems in creating database objects like tables, constraints and indexes.
• Extensive knowledge in ETL Process and Progressive knowledge in using DTS/SSIS utilities.
• Experience in Huge data migrations, transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Proficient in writing and tuning SQL queries and improving the query performance, working on DTS, Data Cleansing and Data Migration.
• Expertise in creating/modifying Tables, Views, Triggers, Joins, cursors, User Functions, Indexes, user profiles, relational database models, data dictionaries, Stored Procedures and in depth knowledge in query optimization and performance tuning.
• Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
• Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Experience in Extraction and Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, and DB2 to MS SQL Server by using Import Export Wizard, DTSSSIS, and BCP and Bulk Insert utilities.
• Experience in logging, Error Handling, Check Points, and Package Configuration to provide the dynamic flow of data to load data warehouse.
• Experience in database modeling and database architecture based on functional requirements and system design of the client using RDBMS concepts.
• Expertise in implementing complex ETL packages to extract data from various sources (SQL Server, Oracle, Excel file, DB2, SharePoint lists and Flat File) and load into various destinations. Experience working in Agile and Waterfall model working methodologies.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills.

TECHNICAL SKILLS:

RDBMS: MS SQL SERVER 2016/2014/2012 , 2008, MS Access, Oracle

ETL & Reporting Tools: SSIS, SSRS, SSAS, BIDS, DTS, OLAP, OLTP

Management Studio: Business Intelligence Development Studio, SQL Enterprise Manager, SQL Server 2005, Query Editor, Reporting Server, SQL Query Analyzer, and MS-Access

SQL,T: SQL, PL/SQL

MS Visio 5.0, ER: Win

Tools: Report Builder, MS Excel

Methodologies: Agile, Waterfall

Operating System: Windows XP/ 2003/2007/2010 , Windows Server, Windows Server

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH.

MS SQL Server SSIS /SSRS Developer

Responsibilities:

• Involved in developing SSIS packages and modifying existing ones as per the requirements using SQL Server data tools in Microsoft SQL Server Integration Services (SSIS).
• Used various query performance and SQL tuning techniques to improve the output time and the quality of the SQL database objects.
• Developed different types of tabular reports, matrix reports, chart and graphs, reports that aggregate data using SQL Server Reporting Services.
• Documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
• Have used SQL Server Integration Services (SSIS) transformations in the data flow of a package to aggregate, merge, distribute, and modify data.
• Database development experience with Microsoft SQL server in OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation and Loading).
• Developed SQL triggers and master tables for automatic creation of primary keys.
• Wrote SQL programs required to retrieve data using cursors and exception handling.
• Extracted 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.
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Created cascade parameterized, adhoc, drillthrough, drilldown, Graph, Chart, KPIs, linked, snapshot, sub reports, canned reports etc. using SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS . Generated ad-hoc reports using Business Object and Crystal reports.
• Involved in building and maintaining dimensional cubes with SQL Server Analysis Services ( SSAS) and used MDX script for querying the data.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Developed Business views, Report objects, Cubes for the users to analyze the data and help them in decision making.
• Developed Stepped and Block reports using SSRS.
• Developed complex programs in T-SQL, wrote Stored Procedures, Triggers, Views and Queries with best execution plan.
• Used various SSIS transformations to pull the data from source and load them into different destinations such as ORACLE, OLEDB tables etc.
• Performed various data transformations using conditional split, data conversion, derived columns and lookups to source data to transfer data in a format as per organization needs.

Environment: MS SQL Server, SSIS, SSRS, SSAS, ETL, MS Access, HTML, Windows XP.

Confidential, Birmingham, AL.

MS SQL Server SSIS /SSRS Developer

Responsibilities:

• Responsible for gathering/refining requirements from the customer for developing reports.
• Worked in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using SSIS.
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases. worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Created bottom count, top count, cross join, non-ascendants and log MDX queries for creating Calculations and KPI's on a cube.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Designed SSIS Packages to extract, transfer, load (ETL ) existing data into SQL Server from different environments for the SSAS cubes.
• Performance Tuning the Stored Procedures used in SSIS Packages and SSRS Reports.
• Worked with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Created SQL Agent Jobs and scheduled the SSIS Package to run overnight. Resolved the issues associated with the job failure.
• Worked with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, and SQL Profiler.
• Involved in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Used various control flow tasks like FTP, Bulk insert task, Transfer job task etc and different data flow tasks.
• Create and Modify User Defined Functions, Stored Procedures, Triggers, Views according to the business requirements.

Environment: MS SQL Server, SSIS, SSRS, SSAS, DB2, MS Access, HTML, XML, Windows XP.

Confidential, Boca Raton, FL.

MS SQL Server SSIS /SSRS Developer

Responsibilities:

• Modified the existing packages by making changes in the stored procedures according to the requirement.
• Created SSIS packages for Uploading of different formats of files (Excel, Access) and databases (SQL Server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Configured Server for sending automatic mails to the respective people when a SSIS package fails.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Analyzed the Reports, Tables and ETL process, Various ETL Transformation tools were used for Control Flow and Data Flow tasks.
• Implemented and enhanced existing reports like Group By, Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multivalve Parameters.
• Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL.
• Worked with SSIS tool suite like Conditional Split, Lookup, Multicast and Derived Column.
• Used script task in SSIS to design complex SSIS packages using Java.
• Involved in performance tuning for new databases and existing databases by using SQL profiler.
• Used Event handlers to run send mail tasks in the background upon success or failure of a package in SSIS.
• Collaborated with fellow team members through Team Foundation Server for effective project management which includes work issues and track on the update of versions.
• Involved in troubleshooting, enhancing and creating new ones of claims retro report templates.

Environment: MS SQL Server, SQL Server Integration Services (SSIS), SSAS, SSRS, T SQL, SQL Excel, Windows XP.

Confidential

SQL Developer

Responsibilities:

• Involved in Setting up new MS SQL Server instances and databases.
• Involved in Capacity planning of MS SQL Servers. Implemented and maintained database security.
• Going through the clients' requirements and coming up with database design and application architecture. Plan capacity specification requirements for new database servers.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server. Used SQL Server System Tables to retrieve metadata.
• Wrote many stored procedures and Triggers as per clients requirements.
• Ran DBCC consistency checks, and fixing data corruption in application databases.
• Designed new job process, new database maintenance plans, DTS packages and did performance tuning of the existing processes. Troubleshoot and minimize production down issues.
• Created scheduled maintenances and backup procedures to the database as a disaster recovery method. Monitor failed and long running MS SQL Server jobs.
• Data conversions and data loads from various databases and file structures.
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.

Environment: SQL Server, Transact-SQL, Enterprise Manager, Query Analyzer, Oracle, PL/SQL.