SUMMARY

• Around 7 (seven) years of IT industry experience with Microsoft SQL Server 2005/2008/2012/2014/2016/2017 , SSIS/SSRS/SSAS in OLTP and OLAP (Data warehousing) environments.
• Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS and SSRS.
• Hands - on experience in T-SQL Programming using DDL, DML, and DCL commands for various business applications.
• Expert at developing ETL interfaces using data marts & cubes and enterprise reports using SSRS, utilizing latest versions (2005/2008/2012/2014/2016 ) & features.
• Involved in writing complex Stored Procedures, Functions, Views, Triggers, and Cursors for various business applications.
• Strong knowledge of Data Warehousing Concepts and Data Modelling Techniques like Dimensional Data Modeling, Star Schema Modeling and Snow-Flake Modeling.
• Experience in error handling, debugging and troubleshooting production issues.
• Extensive experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• Experience in SQL Optimization by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMFs and Query Execution Plans.
• Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS, Import, Export Data, Bulk Insert and BCP utilities.
• Expert level experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Experience in conversion of packages from legacy systems (DTS & SSIS) and migrating & deploying packages across Dev/UAT/Prod environments.
• Experience in developing and extending SSAS Cubes, Dimensions and data source views, SSAS-Data Mining Models.
• Hands-on experience in deploying and processing SSAS objects.
• Expert in automating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Extensively worked on various features of SSRS like Reports, Charts, Filters, Sub-Reports, Drilldown, and Drill-Through, Multi-valued parameters etc.
• Good understanding of Normalization /De-normalization and database design methodology.
• Strong Applications Development experience with back-end databases such as SQL Server, Oracle and MS Access using ADO/ADO.NET, OLEDB, ODBC and SQL client.
• A good team player and a result oriented professional with Excellent Analytical/Communication skills.

TECHNICAL SKILLS

• Windows Server 2008R 2/2008/2003/2000
• UNIX
• LINUX
• DOS
• MS SQL Server 2005/2008/2008 R2/2012/2014
• T-SQL
• PL/SQL
• OLEDB
• MySQL
• Oracle 8i/9i
• 10g/11g/12
• Installation
• Upgrade & Migration
• Performance Tuning
• Capacity Planning
• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• SQL Server Integration Services (SSIS)
• Business Intelligence Development Studio (BIDS)
• MS Office Suite
• Word
• Excel
• Access
• PowerPoint
• Outlook
• Fire Fox
• Power BI
• MS Visio
• Star Schema/Snowflake Schema modeling
• FACT & Dimensions Tables
• Erwin
• Methodologies Agile
• Water Fall
• Scrum
• SDLC
• C
• C#
• HTML.

PROFESSIONAL EXPERIENCE

Confidential, Marlton, NJ

SQL BI Developer/Report Writer

Responsibilities:

• Designed and deployed SSRS reports to reporting server and implemented security measures at report server by implementing authentication and authorization methods.
• Scheduled and monitored SSRS report subscriptions and deliveries such as Email Delivery and File Share Delivery as required by the business.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs).
• Embedded SSRS reports on SharePoint portal and managed access of reports and data for individual users using Roles.
• Developed insightful Reports for business users in SSRS using SQL Server tables and SSAS cubes. Design database queries, views, stored procedures and functions for reporting and data analytics using MS SQL Server
• Created Drill Down, Drill through, linked and sub reports using SSRS and resolved issues and errors in SSRS for errors generated.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Generated Sub-Reports, Parameterized reports, cascading, chart reports using SSRS.
• Generated reports using Global Variables, Expressions and Functions using SSRS.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Environment: MS SQL Server 2017 T SQL, SSIS, SSAS, SSRS, MS Access, MS Excel, Windows, ER-Win, Visual Studio, XML, CSV

Confidential, Woodbridge, NJ

SQL Server BI Developer

Responsibilities:

• Involved in reviewing the Investments application and interacting with business users to understand the user requirements.
• Set up ETL Jobs to run on a daily basis using SQL Server Agent.
• Gathered user requirements and analysed and designed software solution and database.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2016.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modelling, Snow-Flake Modelling, Fact, and Dimensions Tables using MS Analysis Services
• Used scripts and variables, email notifications for ETL process using Data Integrator.
• Worked on the Power Bi reports & dashboards with SQL Server/Tabular SSAS source.
• Used Table, Matrix, Bar, Card, Gauge, Slicers visualizations.
• Worked on Custom Visualizations like multi slicer and Hierarchy slicer.
• Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc.
• Created New Calculated Column and Measure using DAX Expression.
• Responsible for implementation of creating complex SSIS packages using proper control and data flow elements with error handling.
• Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
• Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS.
• Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).
• Designed and Implemented various reports using Crystal Reports and responsible for the migration to SSRS.
• Designed and build the OLAP cubes using Star schema and Snow Flake Schema using native OLAP Service Manager.
• Stored Procedures, User Defined Functions, Views, TSQL scripting for complex business logic. Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Performed maintenance duties like performance tuning and optimization of queries, functions, and stored procedures.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL server 2016 and SQL code.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Taking Database Full Backup, Transaction log backup & differential backup in daily Routine.

Environment: MS SQL Server 2016, T SQL, SSIS, SSAS, SSRS, MS Access, MS Excel, Windows, ER-Win, Visual Studio, XML, CSV, Mongo DB

Confidential, NYC, NY

SQL Server BI Developer

Responsibilities:

• Continuously interacted with Business Analysts and end users to gather business requirements.
• Designed and developed a database to house data from various data sources for all reporting needs.
• Created SSIS packages to extract, transfer and load data into the data warehouse on daily basis.
• Created SSIS Packages for Incremental loading and slowly changing dimensions.
• Created SSIS Packages to import and export data from Excel Spreadsheet, People Soft, Text files, CSV files and various direct sources.
• Executed the DTSX Packages by using DTExec Command.
• Created logging, custom logging and error handling packages.
• Identified the Data Source and define them to build the Data Source Views.
• Created and scheduled SQL jobs to run SSIS packages on daily basis.
• Used different transformations like data Conversions, lookups, derived column transformations etc. for data cleansing to remove unnecessary columns, eliminate redundant, inconsistent and unnecessary data (remove empty rows using SSIS).
• Created DTS (SSIS) packages to get data from various sources (mainframe, Informix, Oracle).
• Generated reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports
• Created stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.
• Generated reports using Global Variables, Expressions and Functions.
• Created subscription to reports.
• Used ETL (Extraction, Transformation, Loading) from heterogeneous source systems. Assisted DBA in using the repository manager to give permissions to users to create new users and repositories.
• Developed Stored Procedures and Views to be used to supply the Data to the Reports. Complex formulas were used to show derived fields and to format the data based on specific conditions.
• Maintenance and provide support to the users for the deployed reports.
• Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
• Created Development and Production support documents.
• Developed queries for generating drill down reports in SSRS 2005/2008.

Environment: SQL Server, MS SQL, Window Server, Oracle 10g, Teradata, DB2, SSIS, SSAS, SSRS, Visual Studio

Confidential, Stamford, CT

SQL Server BI Developer

Responsibilities:

• Developed MDI applications using Window Presentation Foundation (WPF) with integrated special effects into several control elements.
• Designed and developed hundreds of high tech SSIS packages for different ETL projects.
• Developed configured and deployed SSIS packages, both programmatically and using GUI.
• Designed and developed OLAP database models, data marts and cubes.
• Developed web application for a sales store, linking the web pages to source database, design and connect reports to web and applications using Crystal Report.
• Developed and managed dynamic ASP.NET web applications with the use of AJAX controls, validation controls, and login controls.
• Developed database applications using multitier concepts with the use of SQL statements query and stored procedures to retrieve, manipulate and update databases using SQL Server and Access databases.
• Created, managed, and manipulated databases using SQL server 2008, Oracle 10g, and Access.
• Design/Build Extract Transform Load procedures in SQL Server 2008 using SSIS packages to import/export data feeds to/from data warehouse and claim systems.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000/2005/2008.
• Participated in migration from SQL Server 2005 to SQL Server 2008.
• Analysed, tuned and optimized SQL Server Applications by using performance monitor.
• Excellent technical and analytical skills with clear understanding of design goals of ER modelling for OLTP and dimension modelling for OLAP
• Experience in tuning of Stored Procedures and query optimization to improve the performance and eliminate the deadlock situations and hang-ups on server.
• 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.
• Expertise includes Data Analysis, Data Modelling, Data Cleansing, Transformation, Integration, Data import, Data export.
• Implemented dimensional data warehouse model using Ralph Kimball and Inmon methodologies.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Developed Tablix Reports, Sub Reports, Matrix Reports, Charts, and Drill down reports, Ad Hoc reports using SQL Server Reporting Services (SSRS).
• Created various complex reports and manage those using SQL Server Reporting Services (SSRS 2008/2005) according to ERLC.
• Designed and developed Reports in SQL Server 2005 Reporting Services (SSRS).
• Involved in migration and Conversion of Reports from SSRS .
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Creating Tabular, Charts and graphs as per customer requirements Using SSRS.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Created SSIS packages to retrieve data from Legacy sources and to retrieve PII user data from the Flat files on monthly and weekly basis.
• Creating and running SSIS Packages for Import and Export of Heterogeneous Data.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc., to generate underlying data for the reports and to export cleaned data from Excel Spreadsheet, Text file, MS Access and CSV files to data warehouse.

Environment: SQL Server 2012, ORACLE, MS Access, Excel, Visio, BIDS, SSIS, SSAS, SSRS, Visual Studio

Confidential

SQL Server BI Developer

Responsibilities:

• Installed and Configured Microsoft SQL Server 2008R2/2012.
• Created Tables, Views, Indexes, Stored Procedure and Triggers. Used multiple join statements to retrieve data and update the tables. Created Backend validations using Insert/Update and Delete triggers.
• Extensively used Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources and converted SAS environment to SQL Server.
• Worked in transferring the data using SQL Server Integration Services Packages Extensively used SSIS Import/Export Wizard for performing the ETL operations.
• Implemented security for Application and application system databases
• Migrated DTS objects to SQL Server Integrated Services environment, migrated data from SAS environment to SQL Server 2008R2/2012 via SQL Server Integrated Services
• Implemented SSIS data, created maintenance procedures and provided data integrity strategies.
• Implemented Snow Flakes Schema and Star Schema
• Worked with Development teams in relation to application tuning and Performance tuning
• Involved in the Database design (Logical Data Modelling and Physical Data Modelling) of the system and worked with tools like ER Studio 8.5
• Used Performance Point Server to create reports, scorecards and dashboards.
• Involved in Performance Tuning of Code using execution plan and SQL profiler. Added Indexes to improve performance on tables.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008R2/2012.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Created data driven subscriptions for different users using Report Manager.
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS 2008R2/2012. Extensively worked in sorting the data, defining subtotals for the reports.
• Identified and added the report parameters and uploaded reports on to the report manager and organized them in folders.

Environment: MS SQL Server Enterprise Edition, MS Analysis Services, MS Access, SSIS, SSRS, Erwin, XML, Visual Studio

Confidential

SQL Server Developer

Responsibilities:

• Created T-SQL (DDL and DML) queries, complex stored procedures and user-defined functions.
• Performed troubleshooting on various BI tools, systems, and software; performance-tuned these applications as necessary.
• Conducted job duties and responsibilities according to the organization’s business systems development methodology and/or its Systems Development Life Cycle (SDLC) methodology.
• Designed and delivered end-user and materials; provided technical support as necessary.
• Designed, coded, tested, and documented all new or modified BI systems, applications, and programs.
• Developed the semantic layer, metadata, reports, and report definitions.
• Assisted in designing databases and data warehouses to ensure interoperability with BI solutions.
• Conducted research and made recommendations on BI products, services, and standards in support of procurement and development efforts.
• Evaluated and selected database/data warehouse components, including hardware, relational database management systems, ETL software, metadata management tools and database design solutions.
• Analysed user requirements and, based on findings, designed functional specifications for BI front-end applications.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Created data driven subscriptions for different users using Report Manager.
• Created views and Stored Procedures for generating reports.
• Responsible for creating the reports based on the requirements using SSRS 2008R2/2012. Extensively worked in sorting the data, defining subtotals for the reports.
• Identified and added the report parameters and uploaded reports on to the report manager and organized them in folders.

Environment: MS SQL Server 2008 Enterprise Edition, MS Access, SSIS, SSAS, SSRS, Erwin, CSV, Visual Studio