SUMMARY

●Over *+ years’ experience as Business Intelligence Developer using Microsoft BI framework (SQL server, SSIS, SSRS, SSAS) in various business domains including Finance, Insurance, and Information Technology.

●Experience in Relational Database Management Systems, Including Normalization, Data Import/Export, Joins, Stored Procedures, Views, Keys, Constraints, Indexes, Triggers, Cursors.

●Strong knowledge and experience in error handling of SSIS packages using transactions, checkpoints (package restart ability features), break points and error logging procedures.

●Expert in SQL scripts, can really dig into it.

●Expert in building Data Integration, Workflow solutions, and ETL solutions for data warehousing using SQL Server Integration Services (SSIS).

●Extensive experience in migrating data from various sources such as Excel, Oracle, MS Access, MySQL, OLE DB, and flat files to different destinations using SSIS.

●Experience in migration of data using BCP Utility, Bulk Insert command, SSIS and DTS Packages, Import/Export Wizard and Copy Database Wizard.

●Experience in Writing Complex T-SQL Queries, Dynamic-queries, Sub-queries, Co-related sub-queries, Complex joins.

●Used DMV’s and Locking Queries to find out Locks, Deadlocks and Long Running Queries or Transactions.

●Implemented Stored Procedures with TRY-CATCH Blocks, Database E-mail for Error Handling and Effectively Used Join Hints, Isolation Levels to reduce Locking and Blocking.

●Used SQL Profiler, Execution Plans, DMV’s, Database Engine Tuning Advisor (DTA) and Created Suitable Indexes for Query Performance Tuning and Optimization.

●Experience in implementing different types of Replication models like Snapshot, Transactional and Merge.

●Involved in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.

●Involved in monitoring database maintenance plans for checking database Integrity, Rebuilding, Reorganizing Indexes, Shrinking Databases, updating statistics, Creating and Scheduling SQL Server Agent Jobs.

●Power-bi experience

●Experienced in Testing (Unit Testing, System Testing), Automated testing.

●Experience in building web pages using HTML5.

●Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning

●Comfortable working with calculations using DAX and MDX queries.

●Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities

●Working experience with Tableau, created reports using Tableau.

●Worked with T-SQL, DDL, and DML Scripts and established relationships between tables using Primary Keys and Foreign Keys.

●Expert in creating complex Stored Procedures, User Defined Functions, and effective Triggers to facilitate efficient data manipulation and data integrity

●Experience in developing crystal reports.

●Strong communication and team-oriented skills with a strong attitude toward learning new technology quickly supporting the project requirement.

●Experience in Deploying reports in various sources like Web browser in XML and PDF formats.

●Expertise in ETL BACKEND TESTING

●Expertise in reading and understanding execution plan and fixing query to execute with low cost using joins like merge, nested loops, hash join etc. depends on scenarios

●Experience with Power-bi dashboard, reports.

●Worked with end user’s/business analysts to understand business requirements, recommended technical solutions and documented functional requirements.

●Experience in working with Team foundation server to document the source code

●Highly focused, self-motivated, team player with strong professional and executive experience in multiple domains with multiple responsibilities.

●Excellent written and oral communication skills and a team-player with a results-oriented attitude

Areas of Expertise:

SSIS Experience (ETL):

Designed ETL packages dealing with different data sources (SQL Server, Oracle, Flat Files, Excel Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Developed SSIS Packages with Custom error handling, Logging using event handlers, Send E-mail Task and Used Checkpoints to rerun Packages from Point of Failure.

Well-versed in usage of SSIS Control Flow items (For Loop, Execute SQL task, Send Mail Task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).

Experienced in working with different data sources like OLE-DB, flat files and Excel to source data in SSIS and proficient in creating SSIS packages from scratch and deploying them.

Designed SSIS Packages with Dynamic Tasks and Connections Using Variables, Expressions and Packages Configurations and followed best practices to maintain Optimized performance.

Experience in Performance Tuning in SSIS package by using Row Transformations, Block and Unblock Transformations.

Loaded Data Warehouse Fact Tables and Dimension tables of type 1 and type 2 attributes Using Transformations Lookup, Merge Join, Conditional Split and also Using T-SQL 2008 Merge Statement

Debugged the Packages Using Break Points, Data Viewers, Script Task, Deployed the Packages Using DTUtil Commands, Deployment Utility and Scheduled Packages with DTExec Commands.

SSRS Experience:

Designed and Deployed several SSRS reports such as Drill down reports, Drill through reports, Parameterized reports, Cascaded reports, Cached reports, Snapshot Reports, linked reports, ad-hoc reports, Sub reports.

Used Report Manager to assign roles, permissions and Created report schedules and Subscriptions.

Expert in creating traditional as well as Web-based interactive reports using SSRS.

Experienced in creating reports using SQL Server Reporting Services sourcing OLAP cubes and data warehouse, data marts as well as transactional systems

SSAS Experience (OLAP):

Experienced in building Star schema and Snow Flake schema depending on business requirements.

Defined Relationships between Dimensions and Measure Groups like Fact Relationship, Many-to-Many Relationship, and Defined Dimension Granularity within a Measure Group.

Experienced in developing and modifying cubes and dimensions in cubes using SSAS.

Experienced in Dimensional Data modeling, SSAS Performance Tuning, Cube Partitioning, ER diagrams and Data Flow Diagrams, Scripts and formulas, Refresh Strategy and Planning

Created a tabular model and deployed it using Microsoft SQL Data Tools and analyzed it using Excel.

Using power view interacted with data in multidimensional dimensional models on an SSAS server (using power view in SharePoint server).

Implemented Power pivot and Power view for importing huge amounts of heterogeneous data to BIDS environment

Sliced and diced data Using DAX language in SSAS.

Skilled in developing Data Warehouses, Data marts using Star Schemas and Snow Flake Schema.

Experienced in Developing, Deploying and Processing SSAS Cubes and writing MDX, DAX queries.

DBA TASKS:

●Hands on experience with High Availability & Disaster Recovery Solutions – Log Shipping, Mirroring (High safety and High performance), Replication (Snapshot, Merge & Transactional) and Clustering (Active-Passive and Active -Active).

●Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, Index rebuild, reorg, horizontal and vertical partitioning.

●Hands on experience with High Availability & Disaster Recovery Solutions – Log Shipping, Mirroring (High safety and High performance), Replication (Snapshot, Merge & Transactional) and Clustering (Active-Passive and Active -Active).

TECHNICAL SKILLS :

Languages C, C#, SQL, TSQL, JAVA

Databases MS-SQL Server 2000/2005/2008/2008R2/2012

IDE Tools Eclipse, Visual Studio

BI Tools SQL Server Integration Services (SSIS), SQL Server Reporting

Services (SSRS), Crystal Reports, SQL Server Analysis Services(SSAS)

Database Tools SQL Server Management Studio (SSMS), SQL Server Business

Intelligence Development Studio (BIDS), Enterprise Manager, SQL

Profiler, Query Analyzer, SQL Loader, Power Shell

Operating Systems Windows 98/2000/2003/XP/VISTA/7/8,

Professional Experience:

TD bank june'14- Till date

Mt Laurel NJ

SQL Server Developer/Business Intelligence

TD Bank, N.A., is a United States national bank chartered and supervised by the federal Office of the Comptroller of the Currency. Head quarters at Portland ME with "hub quarters" throughout the country. It is one of the 10 largest banks in the U.S. by assets and the largest bank by capitalization.

Responsibilities:

My major tasks for the role is to develop and maintain OLAP cubes and Tabular model using SQL server Data Tools, using the data obtained after performing ETL operation from heterogeneous data sources and the system database and created some reports using SSRS as per my business requirement. I have worked in Developing, testing, production environments. I have spent 60% of my time writing SQL queries. Responsible for all backend database issues.

●Gathering requirements, Design, functional & technical specification, Coding, testing and Document preparation.

●Used Team Foundation Server (TFS) for documenting source code.

●Support Data team and QA team for data extraction and reporting jobs.

●Responsibilities include Database Design and Creation of User Database.

●Logical, Physical Database design

●Created complex SQL queries for data extraction and reporting

●Performance tuning of queries. Used SQL Profiler for database administration.

● Worked on tuning sql queries by adding the missing indexes.

●Designed and wrote stored procedures, functions using T-SQL

●Supported application written in Oracle PL/SQL and converted into T-SQL packages.

●Worked with SSAS to design and develop cubes. and partitioned cubes.

●Created data extraction ETL jobs using SSIS, extracting data from MS ACCESS, Oracle and MS Excel and loading into SQL Server Databases.

●Implemented Enterprise Semantic Layers with database views and SSAS (Tabular Model).

●Addressed various production issues.

●Performed Unit Testing, System Testing.

●Pro-actively monitoring and managing SQL Server performance like disk space issues, Log file full and backup failures.

●Creation of backend SQL Server TABLES, INDEXES, VIEWS.

●Deployed SSIS packages to SSISDB using SSIS Catalog Deployment.

●Scheduling Jobs and Alerting using SQL Server Agent. (Task automation)

●Created T-SQL Stored procedures, Functions and Triggers

●Created reports using SSRS (SQL Server reporting services).

●Created matrix, reports, drill down reports and developed reports with graphs using SSRS.

●Developed Test cases, Test plans, and Test procedures using MS Word and MS Excel.

●Developed Test Cases and Test Scripts for System and UAT Testing.

●Performed basic testing of security features using manual testing

●Created reports using Tableau.

Developed and extended OLAP cubes, dimensions and data source views.

Built cubes from scratch from the data warehouse.

Developed SQL Stored Procedures and Queries for Back end testing.

Involved in automation of test cases using QTP.

As a team member involved in analyzing, designing, building and testing of OLAP cubes with SSAS 2008 and in adding of calculations using MDX.

oCreated a tabular model and deployed it using Microsoft SQL Data Tools and analyzed it using Excel.

oSliced and diced data Using DAX language in SSAS.

oImplemented Power pivot and Power view for importing huge amounts of heterogeneous data to BIDS environment

oCreated a Power View in SharePoint Server report, SSRS.

oUsed Power view for interactive data exploration, visualization and presentation.

oAs an individual my role is to design and implement data marts, facts, dimensions, OLAP cubes using dimensional modeling standards in SQL server that maintained data.

oI have actively supported business users for a change requests.

Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.

Worked on enterprise Reporting Lifecycle. Created Ad-hoc reports, Monthly, weekly reports.

●Deployed SSRS reports to XML.

●Used VB.NET in script task in SSIS

●Deployed reports in various sources like Web browser in XML and PDF formats.

●Transformed data from various data sources using OLEDB

●Developed Various Operational, drill-through and drill-down reports using SSRS.

●Performing query plans and making sure each and every query is using appropriate indexes

●Created some reports using power-bi .

●Implementing DTS Packages for transferring data.

●Working in Waterfall SDLC model.

●Created Test cases, Test Plan, and Test conditions for QA testing.

●Supported the QA team for Data validation, Data extraction and SQL Query optimization.

●Developed custom reports using SSRS/SQL Server BI studio.

●Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment

SQL Server 2008/2012, T-SQL, SSAS, MDX, SSRS, Oracle 10g, PL/SQL, MS ACCESS,, Windows 2003/2000(Advanced Server),EXCEL, Crystal reports, Windows 2003 advanced Server.

Client: American Electric Power, Columbus, OH Aug 2012 – may2014

Date

Role: Sr. SQL Server/SSIS/SSRS/ETL Developer

Responsibilities:

My role for this project was mainly confined to Integrating of data and performing an ETL operation and load the outcome to a Sql server Database and then create and maintain OLAP Cubes and designing Reports for analysis using SSRS.

Writing advanced T-SQL queries, analyzing existing stored procedures and recommending modifications for efficiency gains.

Used SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, and SQL Server Visual Studio.

Used T-SQL&PL-SQL in constructing User Functions, CTE’s, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.

Created Table Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using SQL Server Reporting Services 2012.

Testing Packages and fixing bugs using SQL 2012 Business Intelligence Development Studio.

Worked with Team Foundation Server to report source code for Packages in Visual Studio 2012.

Scheduling and executing SSIS Packages, using SQL Server Agent.

Creating SSIS package to import data from SQL tables to different sheets in Excel.

Optimizing the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, established joins and created indexes.

Creating SSIS Packages to extract data from CSV and TXT files into schema tables and sends Email attachment of the extracted data.

Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring and archived data files for different DBMS.

Bug fixes in SSIS, SSRS, stored procedures as necessary.

Use DDL and DML for writing triggers, stored procedures, and data manipulation.

Performance tuning of SQL queries & stored procedures using SQL Profiler and Index Tuning Wizard.

Involved in Index Analysis and Performance Tuning, Tune slow running queries

using SQL Server Profiler.

Worked in an agile scrum methodology.

Worked with SSAS cubes and Written MDX queries to retrieve data.

Implemented Enterprise Semantic layers with database views and Tabular Models(SSAS)

Created Tabular Models using Sql server data tools by importing data from heterogeneous sources and by Power Pivot& Power view.

Identified the dimension, fact tables and designed the data warehouse using star schema.

Designed and Implemented SSAS Calculations, KPIs, Perspectives, and Hierarchies

Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.

Scheduling the jobs to run for ETL using SQL Server Agent.

Worked on writing the T-SQL code for the historical data to pull according to the

requirement.

Played roles like production support of SSIS and SSRS jobs.

Gathered requirements, Design, functional & technical specification and documentation.

Perform T-SQL tuning and optimizing queries for and SSIS packages.

Worked on Incremental Loads using concepts like Checksum and Column to Column compare.

Environment

MS SQL Server 2008/2012, MS SQL Server Reporting Services (SSRS) 2008R2/2012, MS SQL Server Integration Services (SSIS) 2008R2/2012, MS SQL Server Analysis Services (SSAS) 2008R2/2012, C#, Microsoft Visual Studio, MS Excel., MS Visio 2013.

Client:-Humana Cincinnati, Ohio Jan2011 - july 2012

MS SQL Server / SSIS / SSRS Developer

HCS is an online portal which provides health and wellness awareness, programmed to clients. A client can available the benefits of the program for being healthy and fit. Each coach will guide to members based on their activities like to reduce Weight as well as diabetes and other things, The Member is enrolled through online or telephonic, Member has complete Their Goals and Activities and Will get rewards points, Every Member has interaction with corresponding coaches through online, telephonic, face to face

Responsibilities:

Working with business for collecting the proper requirement to implement in development phase and validate it by business approval

Have a discussion with business for tracking of the requirement on weekly basis to distribute the task by team wise

Involved in trouble shooting for finding solutions in team

Data migration from existing old system to new Humana system

Working on Agile project to attend the daily stand up meeting to update the status on every day.

Designed and developed cubes

Worked with DAX and MDX queries to retrieve data.

Implemented Kpi's, hierarchies and some SSAS calculations.

Data synchronization across all the environment and Systems with SQL script.

Involved in report requirement analysis, and Design

Creating ETL with SSIS to extract data from RDBMS, Excel and CSV, perform business logic and Load data into Excel, Text or RBDMS Destinations.

Deployment of all the SSIS packages across environment TEST, QA and Production.

Scheduling of SSIS Package to execute daily, weekly or monthly.

Created operators, Alerts and Database Mail using SSMS.

Worked with Epic software.

Created some charts using EPIC as per requirement.

Created Back-up for database.

Experience to work with ACA(Affordable Care act), Obama Care.

A member in disaster management team.

Implemented SQL server auditing for tracking and logging events that occur on the Database Engine.

Bug fixes in SSIS, SSRS, stored procedures as necessary.

Creating reports in SSRS and providing to business as per requirement.

Developed complex SSRS reports

Develop the Documents for Logging/Error Handling for SSIS Packages

Configure the SSIS Package for run time Parameters and Config file.

Environment: Microsoft SQL Server 2012 /2008R2 /200.8/2005, Windows 2008, SSIS, SSRS, Qlik View.

HSBC Hyderabad India sept'09- Dec'10

Hyderabad India

MS SQL Server/ SSIS Developer

Founded in 1865 to finance trade between Asia and the West, today HSBC is one of the world’s largest banking and financial services organizations serving some 52 million customers. HSBC’s aim is to be acknowledged as the world’s leading international bank.

Responsibilities:

Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.

Developed and optimized T-SQL stored procedures and UDF’s to support the bottom line invoice system.

Involved in creating database objects like tables, views, procedures, triggers, functions using PL-SQL to provide definition, structure and to maintain data efficiently.

Converted Actuate Reports to the reports in SQL Server Reporting Services and established Reporting Framework.

Deployed Reports onto the Report Server.

Used SSIS packages to do file operation, to apply business rules.

Created several SSIS jobs and packages and executed those tasks

Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users like VP, AVP, CD, Coach, Lead, SA, SR, Office Clerk.

Created various dynamic reports using SSRS and Crystal reports.

Created SQL Server Reports based on the requirements using SSRS 2008.

Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.

Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008

Created and deployed cubes in BIDS using SSAS.

Scripted MDX queries to fetch data from cubes using SSMS

Created reports to retrieve data using Stored Procedures that accept parameters.

Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard

Responsible for Monitoring and Tuning Report performance.

Created various database objects like stored procedures, functions, tables, views.

Configured the report viewing security for various users at various levels using Report Manager.

Maintained server level, database level and object level security best practices by creating logins and users, configuring permissions and assigning different roles to users.

Scheduled reports and exported in PDF format.

Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS packages.

Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.

Provided documentation for all kinds of reports and SSIS packages.

Designed and implemented Stored Procedures and Triggers for automating tasks.

Environment: SQL Server Development Studio 2005, 2008, SQL Server Business Intelligence Development Studio 2005, 2008, SQL Server 2000.

Smart Software Tech. Dev. Pvt. Ltd.(INDIA) Jun 2008 – Aug 2009

Role: SQL Server Developer/SSIS/SSRS

Responsibilities

●Developed complex SSIS packages to migrate the data from flat files to SSIS.

●Worked on different sources in SSIS (XML, Flat file, Excel, OLEDB Source).

●Created batch files to load the data from text file to database tables.

●Developed packages to copy tables, schemas and views and to extract data from Excel and from other legacy systems using SSIS.

●Experience in creating Drill down reports, parameterized reports, cascading parameterized reports and drill through reports.

●Created ETL/SSIS packages both design and code to process data to target databases.

●Worked with SQL Server broker.

●Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis.

●Developed SSIS packages and SSRS Reports.

●Created ETL SSIS packages both design and code to process data to target databases.

●Created technical documents for the process of executing the packages

●Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables.

●Experience in MS SQL Server Configuration, Performance Tuning of stored procedures, SSIS Packages, SSRS Reports.

●Involved in an application related to Java Script

●used functions in Javascript.

●Involved in Project tracking using MS Project.

●Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

●Fixing some of the production issues.

●Created adhoc reports based on the user requirements and worked on different on-demand reports using SAS, PROC SQL and MS Excel.

Environment

SQL Server 2000/2005, SSIS, SSRS, SAS MS PowerPoint, MS Project and MS Excel.

Contact this candidate