SUMMARY

• Over 7 years of experience in IT industry as a SQL Server BI Developer and SQL DBA with specialized skills in SSIS, SSRS and SSAS.
• Hands on experience with in installing, configuring and deploying MS SQL Server suite of products that includes SSIS, SSRS, SSAS for 2014, 2012, 2008 R2, 2008, 2005.
• Proficient in database modelling for OLTP, Data Marts, OLAP, Operational Data Store (ODS).
• Transformed data from one server to another server using Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Experience in error and event handling, Precedence constraints, break points, check points and logging.
• Strong experience in Developing and Deploying SSIS packages, job scheduling, dataflow and control flow components, SQL mail Alerts using SQL Server Agent.
• Using SSIS, worked extensively on various data sources (Excel, XML, Flat file etc.) and different transformations like lookup, merge join, derived column, aggregate, conditional split etc.
• Involved in Designing and Building of OLAP dimensions and cubes using SSAS.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Experience in Creation and deployment of cubes on SSAS.
• SSRS and Tablue used for report development for montly, quarterly and yearly basis.
• Designing and Deployment of Reports for the End - User requests using Web Interface & SSRS.
• Experienced in creating different types of Tabular, Matrix, Drill-Down, Cross Tab, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
• Hands on experience and knowledge of high availability SQL Server solutions including replication, log shipping, Database Mirroring.
• Better understanding of how to handle environmental related issues and to capture data related errors in custom logging process for SSIS/ETL Packages.
• Working knowledge of .Net Framework 3.5 (VB.NET and C#.NET), IIS Web Server.
• Familiarity with DBA Activities in Development/Test environments including Backups, Restores, Security, User management and Performance Tuning.
• Extensive experience working with Business Intelligence data visualization tools with specialization on TableauTableau, Server, Mobile, and Public,Micro Strategy, Business Objects and SSRS.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints Primary key, Foreign Key, Unique, Default, Indexes.
• Monitoring and tuning performance SQL SERVER with multiple tools including Performance Monitor, SQL Profiler, Event Viewer, Index Tuning Wizard and Spotlight to achieve better performance, accessibility and efficiency.
• Scheduled backups for databases and Transaction logs. Performed restoration operations and suggested backup strategies.
• SQL Server RDBMS database development including T-SQL programming.
• Good experience in data ware house concepts, Relational Database Management Systems (RDBMS), performance tuning, optimizing SQL queries, writing complex SQL Queries using functions, stored procedures in T-SQL.
• SQL Server OLAP database development including KPIs, Data mining, working with changing dimensions.
• Experienced in collaborative team environment working with other developers, business analysts, end-users and with project management teams. Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel.
• Knowledge of Principles of Data Warehouse using Fact Tables, Dimension Tables and Star/Snowflake schema modelling.
• Experience in gathering business requirements and translating them into technical specification and creating reports with respect to business requirement.
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.

TECHNICAL SKILLS

Languages Databases: T-SQL, PL/SQL, Dynamic SQL, MDX, C, XML, HTML, HTTP, Shell Scripting Oracle, MS-Access, MS SQL Server, Teradata, MS SQL Server (2014, 2012, 2008R2, 2008, 2005), Oracle 9i/10g (SQL, PL/SQL, Stored Procedures, Triggers)

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio, Crystal Reports.

Design & Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema, FACT & Dimensions tables, Physical & logical data modeling and De-normalization techniques, FACT, Physical and logical data modeling.

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007.

Tools: and Utilities SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, DTS, Business Intelligence Development Studio (BIDS),Crystal Reports, Power Pivot, Microsoft Office, Excel Power Pivot. Excel Data Explorer, Tableau.

Operating Systems: Windows Vista/XP, NT, MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Sr SQL SERVER BI Developer

Responsibilities:

• Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, and Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
• Worked with various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, script task, etc. as part of ETL.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in Business intelligence studios using SSIS.
• Debugged SSIS Packages using Data Viewers, Breakpoints. Used various transformations like Derived column, Pivot, Un-pivot, copy column, merge join, union all, Lookup, audit, aggregate etc.
• Created Cubes with Star schema in SSAS and developed SSRS reports based on the cubes.
• Used T-SQL in SQL Server 2012 to develop Stored Procedures, User-Defined Functions (UDFs), Indexed Views and DML Triggers to support ETL packages.
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Preparing Dashboards using calculations, parameters in Tableau.
• Created drill down and drill up in worksheets in tableau.
• Created report schedules on Tableau server.
• Developed dashboard reports using Reporting Services, Report Model using Report Builder.
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Designed SSIS Packages to extract, transform, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Involved in trouble shooting of performance issues which were associated with Tableau reports.
• Configured Email Alerts for unsuccessful completion of Scheduled Jobs.
• Experienced in working with agile methodology.
• Experienced in integrating different Microsoft BackOffice Components such as Share Point and IIS with MS SQL Server.

Environment: MS SQL Server 2014, 2005/ 2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), SVN (source control),Tablue, MS Visual Studio.NET, C #, TFS (SharePoint), Visual Studio 14.0/VB.net, VB Script and Windows 2012 Server.

Confidential, Hartford, CT

Sr.MS SQL/BI Developer

Responsibilities:

• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2012 using SSAS, SSIS/DTS, SSRS.
• Extract Transform Load(ETL) development Using SQL server 2012, SQL Server 2008 Integration Services(SSIS).
• Worked on QNXT front end and back end to verify the provider’s information.
• Worked on RAM files to insert, update and modify provider’s data and load into QNXT.
• Developed and maintained MS Access database for the provider data management.
• Hands on experience on SSAS tabular model.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Involved in Migration of packages from SQL Server 2008 to SQL Server 2012.
• Assisted in production of OLAP cubes, wrote queries to produce reports using SQL Server 2008/2012 Analysis Services (SSAS) and Reporting service (SSRS).
• Involved in creation and processing of SSAS Cubes.
• Involved in developing and designing Dashboards using Power BI.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Up gradation of System Configuration.
• Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology.
• Involved in SQL Server Configuration, Administration, Implementation and Trouble-shooting for Business work.
• Experience with the design and development of Tableau visualization solutions.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Converted metric insight reports to tableau reports.
• Working extensively with Tableau Business Intelligence tool to develop various dashboards.
• Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels.
• Converted existing BO reports to tableau dashboards.
• Utilized Tableau server to publish and share the reports with the business users.
• Controlled, coordinated installations (Security Patches, Service packs) and evaluated the performance before deployment.
• Used SQL Analyzer and Profiler for monitoring the SQL statements and procedures.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs.
• Database Performance of Index tuning with using Database Engine Tuning Advisor to resolve Performance issues.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Executed the DTSX Packages by using DTEXEC Command.

Environment: SQL Server 2012, Oracle 10g/ 9i, .Net Framework 4.0, Asp.Net2.0, VSS, Windows 2000, Windows 2003 Server, Visual studio 2013-(V.12), MS TFS, MS-Access, Tableau, T-SQL, SSRS, SSAS, SSIS Packages,, ETL, C#.Net, Excel, Business Objects Data Integrator 6.5, MDX.

Confidential, Tampa, FL

MS SQL BI Developer

Responsibilities:

• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Used DDL and DML for writing triggers, functions, stored procedures and data manipulation.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring and archived data files for different DBMS.
• Created Joins and Sub-Queries for complex queries involving multiple tables.
• Performed Regular Database Maintenance process, checking the disk Defrag procedures in different environments.
• Created dashboards for analyzing POS data using Tableau.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development life cycle.
• Used datasets and ADO.Net to retrieve data from the databases.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2012 using SSIS.
• Worked with different control flow elements like Data Flow Task, Execute SQL Task, Script Task and Send Mail Task.
• Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2/ 2012.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Involved in developing and designing Dashboards using Power BI.
• Published dashboards to Tableau server.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Implemented backups (hot & cold back-ups) along with disaster recovery, exporting / importing databases, monitoring procedures and ongoing support.
• Optimized the T-SQL query performance with modifications in T-SQL queries, removing unnecessary columns, establishing necessary joins.
• Created logging, custom logging and error handling packages.
• Used SQL Analyzer and Profiler for monitoring the SQL statements and procedures.
• Supported 24X7 in production issues and User’s issues on applications.

Environment: Windows Server 2008 Enterprise Edition, MS-SQL Server R2 / 2005, IIS, SharePoint, Clustering, VB.Net scripting, SSIS, SSRS, T-SQL, Tableau, GEM Fusion, Visual Studio 2013, Toad, Cluster, .Net Framework 3.5, 4.0, snapshot, backup/restore, MS Office suite 2003.

Confidential

SQL DEVELOPER

Responsibilities:

• Defined and designed the data sourcing and data flows, data quality analysis.
• Proactively create framework to analyze system performance to ensure high availability and of processing using a variety of tools.
• Identified the data source and defined them to build the data source views.
• Creating Stored Procedures in MS SQL Server 2008.
• Experience in writing complex SQL queries involving multiple tables inner and outer joins, temporary tables, table variables.
• Strong SQL programming skills and some stored procedure development experience
• String technical knowledge in Troubleshooting and performance tuning.
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
• Developed and deployed SSIS packages to load data from OLTP to Data Warehouse system.
• Designing flow of data from daily tables to weekly tables and monthly aggregates in the billing Data marts.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Identified and modified the KPI’s, measures in co-ordinance with the requirement and created calculate members in cube using MDX queries in Business Intelligence Studio using SSAS.
• Migrated 80+ DTS packages from SQL R2 using SSIS designer.
• Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data destination by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created/ Modified SSRS based reports based on T-SQL and Stored Procedure with Input parameters.
• Worked with RDBMS objects such as tables, views, indexes, stored procedures, functions, and triggers in MS SQL Server Management Studio (SSMS) to make data transformation services (DTS) effective.
• Created stored procedures and functions to support efficient data storage and manipulation. Created check constraints to maintain data integrity.
• Used SQL Server Agent to automate the SSIS 2008 package execution.
• Analyzed source data and gathered requirements from the business users.
• Working with huge databases (size>5 M rows).
• Performing basic troubleshooting of conversion logic.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS 2005 and then created reports using this data using SSRS.
• Configured and maintained Report Manager and Report Server for SSRS.
• Identified and added the report parameters and created the reports based on the requirements using SSRS 2008.
• Tested and managed the SSIS 2005/2008 and SSIS 2007/8 packages and was responsible for its security.

Environment: MS SQL Server, MS SQL Server Reporting Services, SQL, MS Excel, MS word, Visual Studio 2005.

Confidential

SQL Server Developer

Responsibilities:

• Created Database Diagrams using third party tool ER-Win in beginning of the project.
• Identify database entities and attributes, relation among the entities tables and enforced the referential integrity constraints.
• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL
• Database and DB2 Billing Systems
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
• Created SSIS packages to load data from Oracle to Sql Server using various transformations in SSIS.
• Designed and developed Data Transformation Process (Extraction, Transformation & Loading) using Heterogonous Sources to Destination (SQL Server).
• Used SQL Agent for job scheduling.
• Worked as a developer on databases like MS SQL Server 2005/2008, MS Access.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Involved in gathering of all the requirements for the project and Implemented the SDLC concept.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
• Implementation of Microsoft Office SharePoint Server 2007 Beta for corporate intranet, document management, collaboration.
• Involved in installation and configuration of SQL server 2000 on Servers.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Designed new job process, new database maintenance plans, DTS programs and did performance tuning of the existing processes.
• Created Scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Responsible for Query Performance tuning and Optimization.
• Used BCP techniques, Stored Procedures, Triggers, Cursors and Transaction management, T-SQL to convert data from various sources to MS SQL 2008 databases.

Environment: MS Office suite 2008, MS-SQL Server Management Studio 2000/2005/2008/ R2, T-SQL, DTS, Replication, Rational Rose, Windows NT, MS SQL Reporting Services 2008, MS SQL Server Analysis Services 2008, MS SQL Server Integration Services 2008, MS Access, Erwin, SQL Query Analyzer.