SUMMARY

• Overall 7 plus years of extensive experience using MS SQL Server 2012/2008 R2/2005 in Programming, Development and Implementation of Database and Data warehouse systems in various Industry verticals such as Finance, Casualty Insurance and Health Care.
• In - depth knowledge of SSIS, SSRS, SSAS, T-SQL, OLAP, OLTP, BI suite, Reporting and Analytics.
• Wrote complex queries involving multiple tables and sub-queries to retrieve data based on customer identification.
• Requirements gathering, analysis and design of ETL processes using SSIS and SSRS.
• SSIS package design, constructing, and deployment.
• Transformedand loaded the data from one server to other servers using tools such as SQL Server Data Tools 2012 and SSIS 2008/2005.
• Extracted and migrated data from heterogeneous data sources such as MSExcel, Oracle, MS Access, flat file to MS SQL Server by using import/export wizard as well as third party connectors and creating ETL packages in SSIS.
• Extracted and consumption of XML objects into a Data Warehouse from external apps through Talend.
• ETL packages using SSIS and scheduling packages, validating data using SSIS.
• Provided Logging, Error handling by using Event Handler for SSIS Packages.
• Developed, Deployed and Troubleshoot SQL Server Reporting services using SSRS 2012/2010/2008/2005 across various environments.
• Created data-driven subscriptions for reports linked reports, and ad-hoc reports using Report Builder in SSRS.
• Generated drill down reports, parameterized reports, linked reports, sub reports in SSRS 2012/2010/2008/2005.
• Created dashboards, scorecards and building reports using Performance point server 2007.
• Created business specific tabular reports and crosstab reports using Crystal Reports 11.
• Created MDX query in SSAS cube for various calculated members, KPI and various actions such as drill through, reporting, etc.
• Data Warehousing, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Data Vault Modeling, FACT and Dimensions Tables.
• Logical and physical data modeling of the database using ERWIN.
• Database design, Performance Analysis and Production Support for large and Complex Databases.
• Designed and created databases, tables, views, store procedures and triggers.
• Created the tables and defined the relations between them.
• Created effective dashboards with critical business values to assist in decision-making ability.
• Supported huge databases, troubleshooting problems, and documenting cause analysis.
• Database migration and upgrade from SQL Server .
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
• MS SQL Server configuration, performance tuning, query optimization, back-up/recovery.
• Created effective data mining structures to predict key business performance indicators.
• Good knowledge of System Development Life Cycle (SDLC).
• Excellent communication skills, good team player, highly self-motivated, initiative and a quick learner.

TECHNICAL SKILLS

SQL Server Tools and Packages/BI tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, SQL Performance Monitor, Data Base Engine Tuning Advisor, SSIS, SSRS, SSAS, Business Intelligence Development Studio and Data Transformation Services.

RDBMS/DBMS: SQL Server 2012/2008 R2/2005/2000,Oracle 10g, and MS Access 2003/2000.

Reporting Tools: MS-Excel, SSRS, and Crystal Reports and Report Builder 3.0.

Data Modeling: ERWIN and MS Visio.

Software Development Methodologies: Agile Methodology, SDLC, RUP and UML.

Operating Systems: Windows Sever 2010/2008/2003, Windows XP/7/8, UNIX and Windows NT 4.0.

Languages: SQL, PL/SQL, T-SQL, MDX, C, C++, C#, OLTP, OLAP, .Net, VB.Net and UNIX Shell scripting.

PROFESSIONAL EXPERIENCE

Confidential, Utica, NY

Sr. SQL Server BI (SSRS/SSIS) Developer

Responsibilities:

• Designing the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Processing the cubes and dimensions on a daily basis using the SSIS tasks.
• Creating SSIS packages to Oracle and other SQL Server instances in SSIS 2012.
• Creating several SSIS packages for performing ETL operations to transform data from a cube using MDX and OLTP to OLAP systems.
• Extracting the data from the different sources (CSV files, Oracle, and MS SQL) and stored the data into the intermediate staging database using the SSISETL tool.
• Creating database maintenance plans and deleting history data using SSIS packages.
• Performing the data conversions, adding derived columns, and sending results using of various tasks in SSIS.
• Deploying SSIS packages and reports to production servers.
• Generating reports using global variables, expressions and functions for using SSRS 2012.
• Designing SSRS reports with sub reports, dynamic sorting, defining the data source and subtotals for the report.
• Involving in migration from SSRS 2008 to SSRS 2012.
• Configuring and deploying the reports from SSRS to SharePoint 2010.
• Generating reports from the cubes by connecting to analysis server from SSRS.
• Deploying reports using SSRS and ProClarity.
• Creating data warehouse cubes in SSAS.
• Designing cubes with star schema using SQL SSAS 2012.
• Developing T-SQL queries and stored procedures with multiple parameters to created data sets for reports.
• Developing and Extending OLAP Cubes, dimensions and data source view.
• Buildingdatabase queries and test cases for the testing team to test the reports.

Environment: SQLServer 2012, SSIS, SSRS, SSAS, T-SQL, ETL, Performance Point Server, SharePoint 2010, ProClarity, Erwin, Oracle 11g, OLAP, MDX and MS Excel.

Confidential, St. Louis,MO

SQL/BI Developer

Responsibilities:

• Maintained records in Excel spread sheet and exporting data into SQL Server database using SSIS.
• Generated reports using SQL Server Reporting Services 2008 from OLTP and OLAP data sources.
• Developed reports using SSRS 2008 and crystal reports, used table control, matrix control for cross tab reports.
• Wrote queries to generate reports for analysis of data using SSRS.
• Managed existing indexes in ROLAP to optimize the performance of reports accessing it as well as all other BI applications.
• Wrote DDL Scripts for generating tables, views and functions.
• Developed SQL scripts to Insert/Update and Delete data in MS-SQL database.
• Scheduled jobs, backups, and restore database.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Performance tuning, query optimization and execution plan of queries for better performance.
• Configured IIS and deployed reports and analysis project into server.
• Extended data to XML and Excel spread sheet.
• Assisted end users in user acceptance testing, by explaining all the functionality of the data warehouse and its applications.
• Wrote and executed complex T-SQL queries using SQL management studio for back-end data validation testing.
• Wrote and tested stored procedures.

Environment: SQL Server Management Studio, SSIS, SSRS, SSAS, T-SQL Stored Procedures, OLAP, OLTP,Crystal Reports, Visual Studio 2010 andMS Excel.

Confidential, Chicago, IL

MS SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Created SSIS packages using pivot transformation, fuzzy lookup, derived columns, condition split, aggregate, execute SQL task, data flow task and execute package tasks and such 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.
• Deployed numerous SSIS packages for effective data transfer.
• Migrated data from heterogeneous data sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL SSIS to overcome transformation constraints.
• Used SSIS jobs for implementing ETL and importing data from the flat files that brings the data to the application tables.
• Generated different types of reports such as sub-reports, parameterized, and tabular reports from the database using SSRS reporting services.
• Performed data analysis for automating various customer order reports utilizing SSRS.
• Involved in design, programming, deployment and unit testing of requested reports.
• Worked with the data architect to migrate legacy data into the new analysis data mart and created reports for inventory module.
• Worked extensively in DDL and DML database creation, database tuning, SQL Server performance tuning, and performance planning, backup planning, and database administration.
• Involved in requirements gathering, analysis, design, development, change management, and deployment.
• Installed and configured SQL Server 2008 R2 successfully for various users.
• Involved in login and user management such as adding logins, roles, groups to the Window NT and SQL Server and maintaining proper security procedures.
• Generated ER diagrams (physical and logical using ERWIN) and mapping the data into database objects.
• Scheduled daily and weekly jobs and alerting using SQL Server Agent.

Environment: MS SQL Server 2008 R2, SSIS, SSRS, SSAS,T-SQL, MS Visual Studio 2008, Erwin, MS Access, MS Excel and DB2.

Confidential, St. Cloud, MN

MS SQL Server (SSIS/SSRS) Developer

Responsibilities:

• Worked extensively in creating T-SQL queries to pull data, stored procedure for implementing insertion and deletion logic and also for validating data, UDF for reusability of certain logic and table expressions to make the code more readable and easy to modify.
• Extracted data from the front end applications and stored it inside particular SQL Server Databases.
• Worked extensively to Extract Transform and Load (ETL) using SSIS in BIDS environment.
• Created SSIS Packages to migrate the data from Oracle to SQL Server Destination.
• Generated various SSIS Packages to load data coming from the front-end applications to its necessary destination after considering the complex business logic and after gathering that information from various departments.
• Created the SSIS Packages by considering the execution plan and filtered out the path that provides the least cost to run the package and consumed a minimum amount of time.
• Tested all the SSIS Packages for any flaw during the execution by creating the possible complex cases that verified the accuracy of the results needed to extract and in an accurate format as well.
• Integrated the packages for executing it on a daily basis using Jams Scheduler at times.
• Incorporated variables and expression inside the package that made the package dynamic in its operation.
• Inserted the test data into the development environment that satisfied all the updated requirements.
• Juggled with the data insertion and deletion process from the databases while the testing operation and created an instance that ease the operation of testing every time with minimum amount of changes to the code.
• Created parameterized and drilled down reports using SSRS, which helped to analyze the data for the business users.
• Managed the creation of folder structure and user access for SSRS web server.
• Analyzed the unnecessary columns inside various databases and discussed with the team to remove the unwanted attributes from the highly populated tables to improve their performance during execution.

Environment: SQL Server 2008 R2, SSIS, SSRS, MS Excel2007/2003, MS Visual Studio 2008, Windows Server 2008 and MS Outlook 2007.

Confidential

MS SQL Server/BI Developer

Responsibilities:

• Worked with T-SQL and created complex stored procedures, UDF, views and also created needed indexes on columns for improved performance of queries.
• Used all major functionalities of T-SQL as derived tables, common table expressions (CTE) and also used windows functions as needed.
• Included Execute SQL Task, For Each Loop Container, Script Task, Conditional Splits, Derived Column, Slowly Changing Dimension, Data Conversion and other to successfully carrying out the data moving process.
• Maintained and modified existing Talend Jobs based on the new requirement changes from the business users and also created new ETL using Talend.
• Modified ETL based on performance stand point and rescheduled jobs for load distribution on the server.
• Extensively used SFTP servers to get the source files, which is then loaded to the database by using the ETL process on a daily basis and also send out files over to the server for further processing.
• Worked extensively with setting up a new server and the necessary tools required for the targeted workload going to be carried on the server.
• Tested the migration process of the database from Informix to SQL Server and configured SSIS to support the extraction process from heterogeneous sources as Informix and Oracle successfully.
• Created the ETL for Database migration process from Informix DB to SQL Server DB.
• Simultaneously maintained the existing ETL and recreated new SSIS packages and also created test cases for testing the SSIS packages.
• Worked with TFS for checking the jobs in and out and also maintained the versions of SSIS package.
• Created parameterized reports, and drilled down reports.
• Worked extensively with making SSRS reports dynamic using variables and expressions in the designer and also subscribed these SSRS reports as an email subscription and also as windows file share subscription.
• Maintained the access control for SSRS web server where a particular group of users were restricted to view only needed stuff for that particular user group.

Environment: SQL Server 2008 R2,SSIS, SSRS, ETL, Informix, Oracle, MS Excel 2003/2000, Atomize(scheduler), Windows Task Scheduler, TFS, DB Visualizer, MS Visual Studio 2008, Windows Server 2008/2003, and MS Outlook 2007.

Confidential

MS SQL Server/SSIS Developer

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Created calculated measures and dimension members using multi-dimensional expressions (MDX), mathematical formulas, and user-defined functions.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Utilized SSIS to produce a Data Mart for reporting.
• Created SSIS Packages and used OLEDB Source as an existing Oracle Database.
• Created different type of reports including Cross-tab, Conditional, Drill-down, OLAP and Sub reports using SSRS.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Involved in Performance tuning and Query Optimization.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for marketing team.

Environment: SQL Server 2005,SSIS, SSRS, SSAS, T-SQL, OLAP, OLTP, MDX, Query Analyzer, Data Mart, MS Visual Studio 2005, Windows Server 2003, and MS Outlook.