SUMMARY:

• Over 6 Years of experience as a Microsoft SQL Server - MS BI / ETL Developer Specialized in SSIS, SSRS, SSAS development and administration in OLAP, OLTP environment in SQL Server 2014/2012/2008 R2/2008.
• Expertise in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and in SQL Server Analysis Services (SSAS) in Business Intelligence (BI).
• Experience in Extraction, Transforming and Loading(ETL) data flows using SSIS, Bulk Insert, creating mappings/workflows to extract data from Oracle, DB2, SQL Server, Excel and Flat File sources and load into various Entities.
• Strong experience in Creating, retrieving, Configuring, Deploying and Testing SSIS Packages.
• Excellent report creation skills using Microsoft SQL Server 2012/2008 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Extensive experience in and deploying ETL SSIS (Integration services) packages.
• Hands on experience with performing various SSIS data transformation tasks like Look - ups, Fuzzy Look - ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Experience with Reporting Services(SSRS)in creating tabular, matrix, ad hoc reports based on predefined models and interactive reports from relational, multidimensional or XML data sources and publishing reports, scheduling report processing, or accessing reports on- demand.
• Strong ability in defining query for generating drill down reports with drop down menu option, sorting the data, defining subtotals in SSRS.
• Experience in implementing the changes in the existing ETL process to move data back and forth from ODS to all the integrated systems.
• ETL implementation using SQL Server Integration Services(SSIS) in OLTP and Data warehouse Environment
• Experienced in implementing various logic using objects like Tables, Joins, Views, Roles and Constraints using Data Defining Language (DDL), Data Manipulating Language (DML).
• Expertise in executing complex queries using stored procedures, Triggers, Cursors, User defined functions using SQL in observing Business Rules.
• Experience in data migrating between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
• Good Working experience in designing STAR, SNOW FLAKE Schemas, database modeling, logical and physical database design using Erwin.
• Actively participated in team building and involved in many operations for maintaining healthy work environment.
• Excellent Communication and interpersonal skills.

TECHNICAL SKILLS:

BI Tools & packages: SQL Server Management Studio(SSMS), MS Visual Studio 2012/2010/2008 , Business Intelligence development Studio(BIDS), Export & Import (DTS), Query Analyzer, SQL Server Reporting Services (SSRS), SQL Server Integrating Services (SSIS), SQL Server Analysis Services (SSAS), SharePoint 2010/2007, Enterprise Manager, Team Foundation Server

Databases: MS SQL Server 2014/2012/2008 R2/2008, MS Access, Oracle 11g/10g/ 9i.

Language: T-SQL, ASP.net, VB.net, C#

Operating Systems: Windows 7/ Vista /XP professional. Windows Server 2008/2003/2000 , UNIX.

Application Packages: MS Office 2013/2007/2003/2000 (Word, Excel, Power Point, Access).

Data Modeling Tools: MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, OH

SQL Server SSIS/SSRS Developer

Responsibilities:

• Worked with business Team to collect data for the conceptual design of the system and Interacted with Development Teams and Managers to Analyze Business needs and developed technical specifications.
• Monitored and scheduled existing/new jobs on production environment.
• Troubleshooting and fixing bugs/issues, error handling, debugging, error logging for production support in SSIS.
• Production support responsibilities for all daily, weekly and monthly SQL Agent jobs.
• Monitor production error logs to fix the issues on day-to-day basis.
• Actively ensuring the production implementation of the new enhancements with smooth transition of the project by adding value to the team in filling the gap where required as an analyst, programmer and QA tester.
• Created various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Creation of Clustered and Non-Clustered Indexes for Query Performance and Generated various reports using complex stored procedures.
• Wrote complex T-SQL batches with Common Table Expressions (CTE's) for recursive operations.
• ETL implementation using SQL Server Integration Services(SSIS) in OLTP and Data warehouse Environment
• Worked with SSIS packages which involved tasks like Execution SQL, FTP tasks, Dataflow, File system, Script and Various Data Flow transformations like Lookup, Merge, Pivot, ROW Count and Sort.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems with different transformation and scheduled jobs to run the packages on a daily basis.
• Involved in designing of complex ETL solution based on the Customer needs, which involves various stages of the data flow from Flat File/SQL server source to staging area, cleansing the data, loading to the fact tables and then aggregating the data for reporting purpose.
• The SSIS packages involve various transformations like SCD (Slowly Changing Dimension), Merge, Look-up, derived column, data conversion, multicast, union all transformations etc.
• Generated Drill down, Drill through, Matrix Reports, Parameterized reports, cascading parameterized reports using SSRS
• Excellent report creation skills using Microsoft SQL Server 2008/2012 Reporting Services(SSRS) with proficiency in using Report Designer as well we Report Builder
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Generated Daily, Weekly, Monthly, Subscriptions, Dashboard reports for the analysis of managers and end users by using SSRS.

Environment: MS SQL Server 2012/2008R2, SQL Server Reporting Services (SSRS) 2012/2008, SQL Server Integration Services (SSIS) 2012 /2008, T-SQL, PL/SQL, Excel, XML, C#

Confidential, Philadelphia, PA

SQL Server SSIS/SSRS Developer

Responsibilities:

• Created various database tables and procedures to update and clean the old data.
• Performed basic DBA activities.
• Responsible for creating SQL Scripts, Complex stored procedures, Triggers, Indexes, various constraints, views, function, and variables to implement business rules.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Designed SSIS Packages in SQL Server 2012 to handle data migration (ETL Processes) from transaction system to dimensional Model.
• Built efficient SSIS ETL packages for processing fact and dimension tables with transforms and Slowly Changing Dimensions (SCD) to ensure the changes are appropriately captured.
• Implemented SSIS(ETL) to extract and transform data from RDBMS and Flat flies/CSV, SQL Server 2012 instances and to load into staging and then to DW for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merger and union all.
• Designed and develop SIS (ETL) packages for loading data from Oracle and Flat flies (3GB) to SQL Server Database.
• Created SSIS Packages using Lookup, Merge, Sort, Derived columns, condition Split, Aggregate, Execute SQL Task and Data Flow Task, Execute Package Task etc., to generate underlying data for the reports and to export cleaned data from Excel, Text file, XML file to different Data Marts. Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for monthly statements.
• Responsible for creating dashboard and tabular reports using SSRS.
• Worked on OLAP Data warehouse, Model, Design and Implementation.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS in Business Intelligence Development Studio (BIDS).
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema.
• Created Calculated Measures and Key Performance Indicators in SSAS using MDX.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.

Environment: MS SQL Server- 2012/2008 R2/2005, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin, OLAP, OLTP, Erwin, Performance Point Server, Office-2007, MS Excel.

Confidential, Houston, TX

SQL Developer/SSIS/SSRS

Responsibilities:

• Involved in performance tuning of the database and T-SQL queries using Execution Plan and SQL Profiler.
• Worked with development staff in approving database changes.
• Configured and monitored database application and managing security.
• Created complex stored procedures, triggers, cursors, tables, views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Reviewed, developed and designed data models, in conjunction with the application development team.
• Used Data Transformation Services (DTS) an extract Transform and Load (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Created various reports using MS Reporting Services and deploy public reports in dynamic web portal.
• Created and integrated used defined functions and store procedures for reporting purposes.
• Generated reports that can handle dynamic grouping and dynamic sorting.
• Installation and troubleshooting of SQL Server on standalone boxes and applying patches and service packs to keep the database at current patch level.
• Recommended the procedures necessary to save retrieve and recover databases from hardware and software failures within established procedures.
• Monitor Disk Space, performance, Memory and CPU Usage.
• Managed database integration issues including migration between disparate database, integration, maintenance/conversion, capacity planning issues, and new applications.

Environment: SQL Server 2008, Visual Basic 5.0, Win NT, Crystal Reports 8.0, MS Excel 2003, MS Access 2003, MS SQL profiler, MSBI Crystal Reports 9.

Confidential, Columbus, OH

SQL Server / MSBI Developer

Responsibilities:

• Imported the data in to the SQL server from different external sources and internal sources with the help of ETL tool SSIS.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL server by using SSIS services.
• Created SSIS Packages after performing ETL for getting data from multiple data sources for certain reports.
• Scheduled jobs and job steams to ETL SSIS Package.
• Creating and modifying SSIS and DTS packages
• Migration of DTS into SSIS packages.
• Created multiple tasks in a package and executed them.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Designed and maintained reports in SSRS.
• Distributed reports to the users by uploading them to Report Web.
• Gained knowledge of various databases including Service Center, Asset Center.
• Worked with SQL optimization team to optimize SQL statements and implement better techniques for efficient SQL execution.
• Controlled Security for reports in Report Web.
• Performed administrative functions on the share point site.
• Reduced monthly manual maintenance by automating certain reports and tasks and achieving consistency among database logins.
• Created shared dimensions tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/Analysis Server (SSAS).
• Involved in Analyzing, designing, building & testing of OLAP cubes.

Environment: MS SQL Server 2012/2008R2, SSRS, SSIS, SAS, Oracle, UNIX, SQL Server, SharePoint.

Confidential, Seattle, WA

MS SQL/SSIS/SSRS Developer

Responsibilities:

• Created Tables, Views, User Defined Functions and Stored Procedures for new and modified business requirement in SQL server and SSIS Servers.
• Written T-SQL stored procedures and queries for accessing Data from Teradata Database.
• Created various connection managers (OLEDB connection, flat file connection, ADO.NET connection, Analysis Services connection, Excel connection) available in SSIS to collect data from heterogeneous sources such as Oracle, SQL server, flat flies, excel to perform ETL process.
• Done ETL process extract, transform and load data from Excel sheets, flat flies to tables using SSIS and data flow Transformations.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements into ETL procedures.
• Created, tested, modified and scheduled SSIS packages to update the tables on day to day basis.
• Extensively involved in designing and maintaining the SSIS package to export data of excel spreadsheets and flat files sources to SQL server Database.
• Optimization of stored procedures in SQL Server to improvise the speed of the application to display the data.
• Designed, Developed and Deployed reports in MS SQL server environment using SSRS 2008.
• Used store procedures to retrieve reports data that accept parameters.
• Deployed packages in SQL server MSDB database.
• Used SSIS Documenter for documenting SSIS packages.
• Designed and programmed custom reports throughout the organization. Maintained current reports created in SQL Reporting services. Created AD-Hoc reports as needed and carry out report projects as required.
• Used SQL Profiler for debugging issue, performance tuning whenever necessary.
• Modified and created new stored procedures, views and SSIS packages for the existing ones to reduce their execution time.
• Reviewed and documented existing stored procedures.

Environment: MS SQL Server 2008 R2, SQL Reporting Services, Oracle, Visual Studio 2008/2010, C#.NET, Crystal Reports10, SQL Server Integration services, TFS/VSS, T-SQL, ASP.Net