PROFESSIONAL SUMMARY:

• Having around 6 years of IT experience in Finance, Health environments with primary skills on Development, Analysis, Design and Implementing Client/server application using Microsoft SQL Server and BI suite for both OLTP & OLAP.
• Extensively worked on Business Intelligence technologies like SSIS, SSRS, and SSAS of MS SQL server 2016/ 2014/2 .
• Experience as MS SQL/BI/ETL developer involving in all phases of SDLC, using Agile and Waterfall methodologies.
• Extensive knowledge in writing T - SQL queries (DDL and DML) and good understanding in Normalization and Relational Database Management Systems.
• Hands on Experience in installing, configuring, version upgrades, data migrations, data modeling, production support and various other tasks such as performance tuning and monitoring.
• Good understanding in database and data warehousing concepts (OLTP & OLAP). Experience with logical and physical data modeling and database design using Erwin.
• Created Reports with complex formulas and to query the database for Business Intelligence.
• Experience in ETL implementation using SSIS/Data Services for loading the data from Various Data sources to using Variables, Parameters and Configurations to Other destinations by creating various DTS packages.
• Proficient in working with source code version control SVN, TFS and SharePoint codebases and versioning for DB, SSIS and SSRS related project development.
• Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements & tools like Import & Export Wizard, BCP for developing the Packages.
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
• Ability to work independently or as a part of team to accomplish business objectives.
• Experience in working with internal stakeholders and external clients to understand the requirements for building the reports and packages to deliver files and reports to clients.
• Proficient in creating different types of reports such as drill down, sub reports, parameterized reports, interactive reports, ad-hoc reports, custom reports and formatting them using SSRS/Business Objects.
• Involved in creating stored procedures, triggers, functions, Indexes, tables, views and other T-SQL code and SQL joins for applications by maintaining best standards to perform efficiently.
• Expertise in Analyzing and Optimizing the slow-running queries, cost-based queries using SET operations, Query plans, Statistics and Indexes.
• Involved up gradation and migration from MS SQL Server 2008 to MS SQL Server 2012.
• Experience in creating Autosys Jobs, Alerts, setting up SQL server mail agent for SSIS packages.
• Experience in Deploying and Configuring packages, Error handling and Batch logging, check points and troubleshooting Reports using SSRS.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
• Good Knowledge in designing Visualizations using Tableau dashboards.
• Designing and implementing data warehouses and data marts using components of Kimball Methodology, like Data Warehouse Bus, Conformed Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema, etc.
• Experience in using Atlassian products JIRA and Confluence.
• Knowledge regarding usage of data blending feature in Tableau.
• Worked in agile and waterfall environments, worked together with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Good team player, strong interpersonal skills combined with self-motivation, and initiative and quick learner.

TECHNICAL SKILLS:

Platforms: Windows 2003 Enterprise, Windows 2000 Datacenter, Windows NT & XP

Database/Data warehousing: MS SQL Server 2014/2012/2008 R2/2008/2005 & 2000/, T-SQL, PL/SQL, OLEDB, MySQL, Oracle 12/11g/10g/9i/8i, Installation, Upgrade, & Migration, Performance Tuning, Capacity Planning, IBM DB2

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Data Services, SharePoint 2013,, Power BI, Tableau, Informatica Power center 10.1.0.

Applications: C/C++, C#, Java, HTML, CSS, Java Script, XML, XSLT, ASP.Net, VB.NET, UNIX, LINUX Visual Studio 2008/2010/2013.

Desktop: MS Office Suite, Word, Excel, Access, PowerPoint, Outlook, Dreamweaver, Fire Fox

Methodologies: Agile, Water Fall, Scrum, SDLC.

Database Design Tools & Data Modeling: MS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Erwin.

Operating Systems: Windows Server 2008R 2/2008/2003/2000 , UNIX, LINUX, DOS

PROFESSIONAL EXPERIENCE:

Confidential, Saratoga Springs, NY

ETL MS SQL Developer

Responsibilities:

• Designed ETL processes for extracting, transforming and loading of OLTP data into a central data warehouse.
• Performed physical and logical modeling and Created SSIS packages to migrate data from heterogeneous sources such as MS Excel, Flat Files, and CSV files and then transform and load into the data mart.
• Responsible for enhancement of database performance using database performance and tuning optimization tools and techniques
• Responsible for mentoring team members, helping with assignments, providing guidance and technical oversight, and making key decisions on the technical design.
• Implemented replication in SQL Server for syncing up data across servers.
• Optimized the performance of TSQL queries, established joins and created clustered/non-clustered indexes wherever necessary.
• Involved in daily batch loads into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2014.
• Utilized change data capture for data integration across various environments
• Created the Shell Scripts to automate the execution of the SQL subprograms and to move the data to store in historical/archive folders.
• Analyzing the gaps between the old source system and new source system and estimate the time frame to complete the gaps.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
• Developed reports and deployed them on server to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created SSIS packages to extract data from multiple flat files, CSV, Excel and XML files and scheduled jobs to call the packages.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Supported reports Power BI and Visual Basics applications, which are used to generate data in a specific format.
• Created Excel Reports, Power BI by connecting to various SQL Server databases and improved the efficiency of these large reports.
• Generated Sub-Reports, Drill down reports, and Drill through reports and parameterized reports using SSRS 2012 and Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created ad-hoc reports with incorporated filters, sorting etc. and presented them at the client side to note the changes they may need.
• Handled huge financial data, expert level Query optimization and Performance tuning experience.
• Participated in the full development life cycle within the reporting framework, from developing business intelligence requirements to QA and production deployment
• Provide production database support, enhance existing system and design and develop new systems.
• Involved in ETL process from development to testing and production environments. Managed Package Configurations in XML Files to efficiently Promote Unit Tested Packages to Live Environment from Development Environment.
• Involved in data migration from legacy platform.
• Create C# code for to implement variables with the use of SSIS script task.
• Created SSIS script task with C# code for obtaining parameters from the applications.
• Integrated new systems with existing data warehouse structure and refined system performance and functionality.
• Effective in on-site/offshore model and coordination.
• Work with offshore team to coordinate development work and operational support. Split up the tasks with offshore team and track them through JIRA tickets.
• Worked directly with clients in managing their requests, understanding their requirements and translating functional requirements to technical specifications.

Environment: MS SQL Server Business Intelligence Development Studio 2012,2010,2008/2008R2, SSIS, SSAS, SSRS, XML, Oracle, MS Visual Studio, SQL Server Management Studio, SharePoint 2013, ASP.NET, T-SQL, Data Mining, Power Bi.

Confidential, Murray Hill, NJ

BI DEVELOPER

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Designed and developed SSIS Packages to import and export data from Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Implemented Event Handlers and Error Handling in SSIS packages.
• Involved in code review, writing Unit test case, and creating a platform to run and validate these Test cases.
• Scheduled and maintained routine jobs, tasks, and alerts and setting up SQL server mail agent for SSIS packages.
• Designed Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Developed Dashboards using performance point dashboard designer, which is a part of performance point services in Microsoft SharePoint server 2013.
• Perform data analysis and develop data mapping and functional solution design documents.
• Scheduled and monitored the all jobs and report subscriptions.
• Implemented data driven subscription using SSIS and C# script in the script component.
• Performed data conversion from flat file into a normalized database structure.
• Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.
• Wrote complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic Utilized documentation prepared by Business Analyst to complete projects.
• Resolved and closed the Production tickets generated due to failure of production jobs.
• Developed unit test plans for SSIS packages and created a technical documentation.
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS). Created calculated measures, dimension members using MDX, named calculations using SSAS for generation of cube.
• Responsible for code enhancements for applications using C#.
• Designed and developed complex Informatica ETL mappings by making use of transformations like Source Qualifier, Joiner, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Involved in extracting the data from sql server and Flat Files Developed and implemented various enhancements to the application in the form of Production and new production rollouts.
• Experience in using Data Warehousing tools like Informatica and Databases like SQL Server.
• Created various mappings, sessions and workflows in Informatica.
• Knowledge on Windows Azure machine.
• Used BCP utility inside SSIS packages to import and export bulk data across servers
• Created a number of cubes, dimensions using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Responsible for Bug fixing, Session monitoring, log analysis Implemented Various Data Transformations using Slowly Changing Dimensions.
• Worked on Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.

Environment: SQL Server 2012, 2008 R2/2008, Visual Studio 2008/2005, SQL Server Integration Services(SSIS), SSRS, Visual Studio .Net, C#, ASP.NET,.NET Framework 3.5, Informatica Power Center 10.1.0,Toad

Confidential, Teaneck, NJ

Research Assistant (Android App)

Responsibilities :

• Developed an Android app to complete an agile run for Predictive Waste Water Management System (PWMS)
• The message format for alert messages to be sent by the Audit and alert server and received by the android app.
• The Android app which will subscribe to the server that will send alert messages to it. When received, the alert shall be displayed by the app on the android device
• Reports are generated from the stored data and a system admin interface Raspberry Pi boards are used to implement the Audit and Alert control object as a server and the audit and alert data store as a file or other database on the Raspberry Pi board.
• Implemented the server on a notebook and ported it to the Pi boards

Confidential

SQL Server Developer /SSRS Developer

Responsibilities:

• Created tables, views, stored procedure as per design needs.
• Optimized queries tuned and monitored server performance.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity.
• Optimized ETL Packages using various SSIS features at Control flow and Data flow level.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Responsible for creating the reports basing on the requirements using SSRS 2008.
• Performed Unit testing an Integration testing.
• Identified the database tables for defining the queries for the reports.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Configured and fine-tuned all the ETL (Extract, Transform and Load) workflows.
• Worked closely with developers, end users and Administrator in designing database and creating
• Defined the report layout in SSRS and generated drill down reports, parameterized reports.
• Created SQL server Reports using SSRS 2005 while identifying the data source and defining them to build the DSV’s.
• Used SSIS Control Flow items (for each Loop, execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Union all).
• Converted various sql statements into stored procedures thereby reducing the number of database accesses.
• Created Queries for generating drill down, critical drill- through and Identified and worked with parameters for parameterized reports in SSRS 2005.
• Identified and added the report parameters.
• Formatted the reports using the Global variables and expressions.
• Deployed the generated reports on to the server.
• Worked on parameters to generate cascaded parameterized reports along with that extensively used global variables, expressions and functions.
• Documentation of all the processes involved in maintaining the database for future reference.

Environment: MS SQL Server Management Studio 2008/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Microsoft Visual Source Safe.