PROFESSIONAL SUMMARY:

• Eight plus years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server-based applications).
• Expert Knowledge of T-SQL, Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Worked Extensively on ETL process using SSIS package.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
• Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Sub reports, and formatting them.
• Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.
• Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS.
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• 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.
• Experience in creating indexed views, complex stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.
• Worked with different versions of SQL - 2005, 2008, 2008R2, 2012, 2014 and 2016
• Supported team in resolving SQL Reporting services, SQL Integration services and T-SQL related issues.
• Experience in designing Power BI reports and Dashboards.
• Experience in writing complex SQL queries involving multiple tables with inner and outer joins, stored procedures.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Involved in DBA activities such as backups and restores.
• Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.

TECHNICAL SKILLS:

SQL Server Tools and Databases: SQL Server Management Studio (SSMS), SQL Server 2012, 2014, 2016, MS Access 2008, Oracle 11g, SQL Server Integration Services (SSIS), SSRS (Reporting Services), SSAS (Analysis Services), Microsoft Visual Studio 2012/2014/2016 , SQL Server Business Intelligence Studio(BIDS), SharePoint, .Net

BI tools: Power BI, Qlikview, Tableau

Statistical tools: SPSS, SAS JMP

Applications: Visual Basics, Excel -Macros

Desktop: MS Office Suite, Word, Excel, Access, PowerPoint, Outlook

EMPLOYMENT SUMMARY:

Confidential, CA

SQL Server/Power BI

Responsibilities:

• Responsible for creating critical compliance test analysis documents and Business Requirement Documents (BRD).
• Implemented advanced SQL queries using DML and DDL statements to extract large quantities of data from multiple data points on MS SQL and Teradata SQL Assistant.
• Worked on writing the T-SQL code for the historical data to pull according to the specification requirement.
• Experience in Data Analysis, understanding trends and patterns in data.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, various other data sources to MS SQL Server by developing SSIS (SQL Server Integration Services) packages.
• Converted the old Data flow logic written in .NET C# to SSIS packages.
• Developed dashboards and ad-hoc reports using MS Power BI and SSRS for senior management team for analysis.
• Developed custom calculated measures using DAX in Power BI to satisfy business requirements.
• Involved in scorecard and KPI Reporting.
• Implemented and successfully tested Log shipping in SQL Server 2008 and SQL Server 2012.
• Create reports in Power BI preview portal utilizing the SSAS Tabular.
• Published Power BI Desktop reports created in Report view to the Power BI service.
• Transformed and combined the data using Query Editor in the Power BI.
• Used SSAS features to build and configure Hierarchical dimensions, define Measure groups, create Calculated Measures, KPI, configure Partitions, aggregations as well as Actions.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports using SSRS.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2014 and in adding calculations using Multidimensional Expression MDX & DAX.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• Developed Star schema using SSAS cubes.
• Created parallel period, filter, ancestors, and cross join MDX queries.
• Developed custom calculated measures using DAX in Power BI to satisfy business requirements.
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.
• Involved in designing and publishing visually rich and intuitive Power BI dashboards.
• Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Provided maintenance and development of bug fixes for the existing and new Power BI Reports
• Experience with Power BI desktop and Power BI Service.
• Published dashboards on an intranet site using SharePoint Server.
• Migration of SQL Databases from SQL 2008 to SQL 2012/2014/2016 .

Environment: MS SQL Server 2012/2014/2016 , Microsoft Management Studio, Teradata SQL Assistant, Microsoft Visual Studio, MS SQL Server Integration Services (SSIS) 2012/2008R2/2008, SQL Server Reporting Services (SSRS), Power BI,T-SQL.

Confidential, Hartford, CT

SQL BI Developer/ Power BI

Responsibilities:

• Created SSIS process design architecting the flow of data from various sources to target.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation
• Create different SSRS Reports based on the user’s requirement. All kinds like ad-hoc reports,
• Create Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using Sql Server Reporting Services (SSRS).
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Trouble shoot any kind of data issues or validation issues
• Designed SSIS Packages to transfer data from various sources of the Company into the database that was modeled and designed.
• Design the ETL frame work for the data load into FRY Tables.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Worked on the ADW Data Warehouse for Santander Bank.
• Create Master Package to run different other ETL in one Master package. Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.
• Bug fixes in SSIS, SSRS and stored procedures as necessary.
• Used C# and VB Scripts in ETL Packages where ever necessary.
• Worked in an agile scrum methodology.
• Scheduling the jobs to run for ETL using SQL Server Agent.
• Migration of SQL Databases from SQL 2005/2008 to SQL 2010/2012/2014.
• Worked on writing the T-SQL code for the historical data to pull according to the specification requirement.
• T-SQL in constructing User Functions, CTE’s, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Perform T-SQL tuning and optimizing queries for SSIS packages.
• Worked on Incremental Loads using concepts like Checksum and Column to Column compare.
• Scheduling SSRS jobs and production support.
• Production support for SSIS and SSRS jobs.
• Worked as an IBM - COGNOS Report Designer and created number of Business-Critical sales reports for company’s Management team.
• Use of SharePoint 2010 and TFS to store all the related work and report the same by creating Tasks in TFS.

Environment: MS SQL Server 2012/2014, Micro Soft Visual Studio, Business Intelligence Development Studio, SQL Server Integration Services (SSIS),SQL Server Reporting Services (SSRS), SQL, SharePoint Server 2010 (MS Visual Studio.NET# 2008, MS Visual Studio.NET# 2010, Team Foundation Server, Visual Basic 6.0/VB.net, VB Script and Windows 2008 Server, Erwin Data Modeler.

Confidential, Weehawken, NJ

SQL BI Developer /DBA

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, FTP Server, Excel, DB2 and SQL 2012).
• Actively participate in the Design, Build, Test, and Deploy phases of Siebel UCM implementations for Oracle customers.
• Project-manage Oracle MDM implementations for Oracle customers.
• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes, if SSIS packages extract row from DB2 to CDC DB, or any insert, update or delete rows in dimension or fact tables in DW.
• Filtered data from Transient Stage to EDW by using Complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, FTP Task Package Execution task to achieve business needs.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Developed SSIS Packages to move data from one database of a server (Partner) to another (CRM) using Web Services Call.
• Wrote and modified various Stored Procedures used in the application using T-SQL.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent.
• Responsible for creating partition function and schema for the table partitioning.
• Involved in creating counter logs and trace logs for advanced performance analysis and data logging over a period of time.
• Created SSIS 2012 Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Created various jobs using SQL Server Agent.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.
• Documented the project work and process.

Environment: MS SQL Server 2012, T-SQL, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS) Visual Studio 2010/2008, SQL Server Agent, Windows server 2008, Erwin 7.2, Visual Source Safe 2005, C#, SQL Profiler, Microsoft SharePoint 2010

Confidential, Overland park, KS

Sr. SQL BI Developer /DBA

Responsibilities:

• Experience in using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, and SQL Server Visual Studio.
• Extensively used T-SQL in constructing User Functions, Views, CTE’s Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2008 R2
• Analyzing and designing reports and reporting solutions according to the specifications given.
• Knowledge and implementation of Reporting Services and other MS tools and in combination to design report solutions to deliver on several CI projects.
• Meet deadlines while meeting the reporting needs of the business users and project owners.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Designed the SSIS packages with error handling.
• Built a consolidated Data Mart for five different Company Organizations which was further populated and used to build a Cube on SQL Server 2012 for further reporting requirements.
• Using SQL Server Reporting Services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Creating Ad Hoc and Parameterized Reports using SQL server 2008 R2 Reporting services.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports using Sql Server Reporting Services 2008 R2 and and COGNO’s.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Generated Sub-Reports, drill down reports, Drill through reports and Parameterized reports using SSRS.
• Representation for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Wrote the Visible Basic expressions in SSRS according to the requirement of the report developed.
• Worked on some ETL development using Informatics.
• Reports were created according to the report specifications and make sure to submit the work assignment before the due time.
• Scheduling the jobs for monthly reports and yearly reports
• Played a major role in production support and maintenance of SSIS jobs.
• Documenting the Developed Code by following the Organizational guide lines where ever required.
• Perform T-SQL tuning and optimizing queries for Reports and SSIS packages.
• Assisted in Creating SSIS process design architecting the flow of data from various sources to target.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation
• Use of version control system (SERENA) for proper accounting.

Environment: MS SQL Server2008/2012, Micro Soft Visual Studio, SQL Server Integration Services (SSIS),SQL Server Reporting Services (SSRS), SQL, SharePoint Server 2007 (MOSS 2007Performance Point Server, MS Visual Studio.NET# 2008, TFS (Share Point), Visual Basic6.0/VB.net, VB Script and Windows 2008 Server.

Confidential

SQL Server Developer / Admin .

Responsibilities:

• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Involved in gathering user requirements, draft specifications, design and create Database objects for performance tuning.
• Part of team for analyzing and implementing the physical design for the database.
• Responsible for drafting documentation for describing the metadata and writing technical guides.
• Created Stored Procedures, Triggers, Views and SQL Joins and other statements for various applications.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Excellent hands on experience with SQL Server Integration Service (SSIS), SQL Analysis Services (SSAS) and Reporting Services (SSRS).
• Involved in designing cubes in SSAS environment using Snowflake/ and Star Schemas.
• Thorough understanding of first NF (1NF), second NF (2NF) and third NF (3NF).
• Extract Transform Load (ETL) development using SQL Server 2008 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Installation and configuration of SQL Server 2008.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, and Subreports using Sql Server Reporting Services 2008.
• Created SQL Server Analysis Project using MS SSAS 2008.
• Querying and manipulating multidimensional cube data through MDX Scripting.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Created complex SSAS cubes with multiple fact measures groups.
• Created Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Developed the chart type, tablix, matrix reports in SSRS (Sql Server Reporting Services) like enrollment status, Financial Aid, Degree Objective from the OLAP system.
• Used performance Point Services, SSRS, excel as the reporting tools.
• Wrote the expressions in SSRS wherever necessary.
• Created reports with different features like drill through capabilities, jump to another report, use of pie charts and bar charts.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Modifying report content and exporting reports in multiple formats based on the business requirements.
• Designed and implemented Parameterized and cascading reports using SSRS 2008.
• Developed data model based on the BA’s and the reporting Team using SSAS, SSRS.
• Created derived columns on the final fact and dimension tables as per the business requirements.
• Understanding the OLAP processing for changing and maintaining multidimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
• Created Analytical reports by PROCLARITY tool.
• Played a major role in production support of SSAS (cube refresh), SSIS jobs.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube

Environment: SQL Server2008R2/2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), VB Script, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MDX, Erwin, MOSS 2007, MS Project, MS Access 2008 & Windows Server 2008, Oracle