SUMMARY

• Around 8+ Years of IT Experience in using Microsoft SQL Server IT Projects involving Business Intelligence (BI), Data Warehousing and Data Conversion in System Design, Development and Support of Microsoft SQL Server 2016/2014/2012/2008 R2/2008/2005 in Development, Data warehouse, Test and Production Environments on various business domains like Financial, Insurance and Health Care.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting MS SQL Server 2012/ 2008/2008 R2/2014.
• Experienced in using T - SQL for developing Stored Procedures, Triggers, Tables, Indexes, Views and User Defined Functions.
• Expertise in the usage of ETL tools including SSIS, DTS for large-scale Data warehouse implementation Projects involving conversion of data from heterogeneous data sources including SQL Server 2000/2005, DB2 and Oracle.
• Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSISpackages by using Row Transformations, Block and Unblock Transformations.
• Created and organized knowledge supply & knowledge supply Views, Dimensions, Cubes, Measures, Partitions, mistreatment SQL Server 2008/R2 Analysis Services.
• Experience in creating and deployingSSIS(ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Hands-on experience Relational Database Modeling and Dimensional Modeling in combination with SSAS to develop OLAP cubes having Star/Snowflake schemas.
• Experienced and Created logs forETLload at package level and task level to log number of records processed by each package and each task in a package usingSSIS 2012.
• Expertise working with SSAS Tabular model to produce reports in excel files using pivot tables.
• Excellent T-SQL programming skills and experience in the development of SSIS packages using BIDS, complex Stored Procedures, Configuration Files, Tables, Views, Triggers and Functions.
• Worked on administration tasks such as Data loading, Batch Jobs, Data unloading, Backup & Recovery, User and Application Table Management, upgrades, creating Databases/File groups/Files/Transaction logs.
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Proficient in the ergonomic design of Dashboard and Report layouts for canned reports as well as Adhocs with advanced drill-down, sorting and filter capabilities.
• Experience with full development cycle of a Data Warehouse, including requirements gathering, design,

TECHNICAL SKILLS

BI Tools: SSIS, SSRS, SSAS, Informatica

RDBMS Servers: MS SQL Server 2012/2008R2/2005

Operating Systems: Windows 7, Linux, Windows VM Servers, MAC OS X.

Programming Languages: PL/SQL, T-SQL, .Net, C#, Java and Visual basic, html, C++

Office Applications: MS Outlook, Visio, MS Project, MS-Excel, Power Pivot 2010, MS-Access

Configuration Tools: SQL Monitor from Redgate, SQL Profiler, Team Foundation Server

PROFESSIONAL EXPERIENCE

Confidential, TX

SQL BI Developer

Responsibilities:

• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design(SSRS)
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server usingSSRS
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS) Created reports in SSRS with different type of properties likechartcontrols, filters, Interactive Sorting, SQL parametersetc
• Created reports fromOLAP,sub reports, bar charts and matrix reports usingSSRS
• Created report snapshots to improve the performance ofSSRS.
• CreatedETL metadata reportsusingSSRS, reports include like execution times for theSSISpackages, Failure reports with error description.
• Experience in configuring and deployingSSRSreports onto Microsoft Office SharePoint Server.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and client systems.
• Designed and developed ETL process with SCD (slowly changing dimensions) with T-SQL, SSIS and VBScript.
• DevelopedSSISpackages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and ExecuteSQLtask to insert transaction log data into theSQLtable
• Designed the packages in order to extract data from SQL DB, flat files and loaded into Oracle database.
• Designed best practices document for ETL and Reporting Systems using Data Warehouse concepts.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008/2012/.
• Produced operational reports inSSRSi.e. drill-down, drill-through, dashboard and matrix reports. Responsible for ETL throughSSISand loading Data to DB from different input sources.
• Developed SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, Oracle, flat file, CSV, Text Format Data) by using multiple transformations such as Data Conversion, Derived Column, Lookup, and Conditional Split.
• Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models.
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2008.
• Advanced knowledge of Excel for using Pivot tables, Power Pivot, Complex formulas. Created Power View Reports using the Tabular SSAS models in Excel 2010 and 2012

Environment: MS SQL Server 2012/2008, Visual Studio 2008, Oracle, MS SQL Server Management Studio, SSIS, SSRS, SSAS, MS Excel, Power BI . System Monitor/Performance Monitor, Event Viewer, SQL Profiler, SQL Clustering, Oracle, SAN, Source Control Management System, Index Tuning Wizard, SDLC, Data Warehousing, Data Transformation Services (DTS).

Confidential, Dallas, TX.

ETL and SSAS Developer

Responsibilities:

• Installed, Configured, Managed and Monitored SQL Server 2005/2008.
• Involved inSSISETL Transformation for de-normalization of data sources using UNPIVOT and UNION.
• Developed ETL packages with various different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS) ETL development tool.
• Created Cube in Tabular mode, created hierarchies in VS 2012 for Cube.
• Migrated SQL server 2000 databases into SQL server 2005 and SQL server 2005 databases into SQL server 2008 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
• Involved in creatingDynamic Stored Procedures and views.
• Extensive experience using Data Mining tools Microsoft Analysis Services (SSAS).
• Resolved any deadlocks issues with the Database servers on a real-time basis.
• Created jobs, alerts to run SSIS packages periodically. Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job and windows Scheduler.
• Identified and defined Key Performance indicators (KPIs) for vendor reporting.
• Performance tuning ofSQLqueries and stored procedures using server Profiler and Index Tuning Wizard in SSAS andSSIS.
• Build efficientSSISpackages for processing data feeds and load into relational DB using complex transformations such as type 1 and type 2 SCDs, Sort, Look Up, Fuzzy Lookup, Derived Column, Merge, Union All, and Aggregate.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) .
• Wrote stored procedures and User Define Scalar Functions (UDFs) to be used in theSSISpackages andSQLscripts.
• Extensively worked on creatingSSISpackagesand have used foreach Loop containers, Sequence Container for developing processes and loadeddata using different transformations such as Derived Columns, Condition Split, Aggregate, Merge Join and Union all.
• Worked as adeveloperin creating complex Stored Procedures,SSISpackages, triggers, cursors, tables, and views and otherSQLjoins for building various applications
• DesignedDimensional ModelingusingSSASpackages for End-User.
• CreatedHierarchiesin Dimensional Modeling.
• Created complexSSISpackages extensively for data loads and business logics implementation..

Environment: MS SQL Server 2008R2, T-SQL, SQL Profiler, Visual Studio (2012), Team Foundation Server (2012),, MS Analysis Services 2005, MS Reporting Services, WebFocus Reports, MS Access, Import & Export Data, Source Control Management System Windows XP, Index Tuning Wizard, Silver light, Crystal Reports

Confidential, Minneapolis, MN

SQL Server Developer

Responsibilities:

• Responsible for Delivering new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts
• Created cubes and dimensions in SSAS and measured and calculated measures according to the business requirements.
• Created and Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Created ETL Projects usingSSISin Package Deployment Model as well as Project Deployment Model, also efficiently usedSSIScatalog for ETL Monitoring.
• Expert in designing reports usingSQLserver reporting services (SSRS) and Excel power pivot table based on OLAP Cubes.
• Developed custom crystal reports to analyze financial, operating, and billing processes
• Wrote stored procedures using DynamicSQL, Cursor to handle special case which can't be handled using static T-SQLor set based operations
• Generated and Deployed ETLSSISpackages both design and code to process data to target databases..
• Set up hierarchies and defined Scope of Analysis in the Universe for providing drill down/ drill through options in the reporting environment
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Performance tuning the SSIS Packages by understanding the Data Flow Buffers and by designing for parallelism
• UsedSQLserver business Intelligence Development Studio to designsSSISpackages to transfer data between servers and deploy the data. Scheduled the job to do this task periodically.
• Deploying and scheduling reports usingSSRSto generate all daily, weekly, and monthly and Quarterly Reports including current status.
• Developed Cubes usingSQLAnalysis Services (SSAS) and Dimensions using cube wizard and also Generated Named calculations and named queries.
• Created Drill-through reports, parameterized reports and linked reports usingSSRS2005 and 2008 and were integrated in the Performance point server.
• Created Ad Hoc reports by building models in Report Builder usingSSRS2005/2008 Model Designer and Report Builder

Environment: Windows server 2003, MS SQL Server 2008/2005, SQL Server Analysis Services, SQL Server Reporting Services and SQL Server Integration Services, MS Office 2003/2007 HTML, XML, IIS 6.0, MS Visual Studio 2005, DTS, Crystal Reports 9.0

Confidential, Lansing, MI

MS SQL Server BI Developer

Responsibilities:

• Responsible for Delivering new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts
• Created Database Maintenance Planner for the Performance ofSQLServer, which covers Database Integrity checks, Database Statistics update and Re-indexing.
• Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
• Data migration (import & export/BCP) from Text toSQLServer.
• Planned complete Back-up of Database and Restored the Database from Disaster Recovery.
• Coordinating post-implementation events such as testing.
• UsedSSISto create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Write complexSQLqueries and create stored procedures for retrieval of the data and analysis of the data. Created complex Triggers, Functions, Indexes, Tables, Views,SQLJoins and T-SQLcode to implement business rules.
• ImplementedEvent HandlersandError HandlinginSSISpackages and notified process results to various user communities
• Optimized queries usingSQL ProfilerandDatabase engine tuning advisor
• Use different features like grouping, sorting, and reports parameters to build sophisticated reports. Built Ad hoc reports and added drill through functionality using report builder, and created tabular, matrix, graphical reports fromSQL/OLAP data sources usingSQLServer 2005 Reporting Services.
• Designed a relational database using Erwin data modeling tool. Created logical and physical data models. Defined the relationships between primary and foreign keys in tables. Generated the data base script using Erwin.
• Experience in DTS for data flow from one source files like Excel, Tables, and Views to other databases or files with proper mapping.
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX andSQL

Environment: SQL Server 2008/, T-SQL, SSIS, SSRS, SSAS, Query Analyzer, Enterprise Manager, SQL Profiler, Index Tuning Wizard.

Confidential

ETL &Report Developer

Responsibilities:

• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) has assigned.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS
• Hands-on working on dummy projects with creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, and Histograms in Tableau.
• Optimized queries and tuned performance using SQL Server tools including SQL Profiler, SQL Performance Monitor, Execution Plan and Index tuning wizard.
• Designed, developed and deployed complex DTS packages to cleanse and transform data and load from legacy systems into the Enterprise system SQL Server database.
• Ensured the quality of the output for each system Interface by conducting Meetings with the respective vendors to review the output and obtain continuous feedback.
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to SQL Server using DTS and also used BCP and Bulk Insert and even the other way.
• Implemented Version Control with Visual Source Safe.
• Created the SSIS DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Converted Logical Database Diagram into Physical Schema using the balanced Normalization in 2nd and 3rd Normal Form for highest performance.
• Development of data dictionaries and schemas and associated publishable documents for Flat Files in webMethods developer.
• Deploying the SSRS reports using MS reports builder.
• Involved in scheduling,creating snapshots and subscriptions for the reports using SSRS 2008
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• 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 database security of the operational and developmental application system databases.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Expertise in writing the complex SQL queries.
• Generated detailed reporting using SQL Server Reporting Services.

Environment: MS SQL Server 2008/2005, SQL Server Analysis Services, SQL Server Reporting Services and SQL Server Integration Services, MS Office 2003/2007, Data Warehousing, C, CPP, C#, .NET, Rational Rose Enterprise

Confidential

SQL Server Developer

Responsibilities:

• Managing Installation, Configuration and Maintenance of MS SQL Server 2005.
• Created and managed schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Participated in re-design and development of back-end SQL Server database, wrote queries, triggers and stored procedure.
• Involved in creating different flow Services required for data transformation, creating & validating IS Schema, IS Document types.
• Involved in the Configuration of JDBC Adapter using different templates like Custom adapters using different SQL Queries and Stored Procedures.
• Installation of replication server, configuration and monitoring the replication between two sites, implemented Transactional replication.
• Created and running DTS Packages for Import and Export of Heterogeneous Data.
• Creation of schema objects, granting of roles and privileges to the users, compilation of procedures etc.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created database administrative job of Security, Backup/recovery, ODBC connections etc.,
• Provided support to the Application developers on the application databases.
• Responsible for creating stored procedures and SSIS packages as part of the ETL process to populate the data marts.
• Performing error handling design and implementation
• Used BCP utility to publish table output to text files.

Environment: SQL Server 2005, Windows 2000/2003/ NT/ XP, MS Access, SQL Profiler, DTS, T-SQL, BCP, Replication.