SUMMARY:

• Business Intelligence/MS SQL Server Developer having 6 years hands - on experience in database designing and development, ETL processes, BI Reporting, Business Intelligence products including the whole suite of Microsoft BI stacks (SSIS, SSRS, SSAS, Database Engine, etc.)
• Excellent understanding of Relational Database System, Normalization, Logical/Physical Data Modeling, ETL, and Data Warehousing.
• Excellent SQL programming skills in writing business logic and complex queries to create database objects such as tables, indexes, joins, triggers, views, stored procedures, user defined functions, and temporary tables using MS SQL.
• Experienced in SSMS tools such as SQL Profiler, SQL Query Analyzer for Query Optimization.
• Experienced in building Data Integration and Workflow solutions with SSIS packages to Extract, Transform, and Load (ETL) data into Staging area from heterogeneous databases such as Oracle, DB2, MS Access, and Text by using necessary transformations.
• Experienced in debugging, setting checkpoints, breakpoints, error handling, and logging in SSIS.
• Expert in designing Enterprise Reports using SQL Server Reporting Services SSRS.
• Experienced in developing various types of drill-down reports, drill-through, parameterized reports, cascading reports, sub reports using SSRS.
• Expertise in creating snapshots, subscriptions and reports scheduling
• Experienced in Ad hoc reporting and custom reporting using SSRS, Excel, and MS Access for daily reports.
• Worked on Microsoft's Power Pivot tool in Excel for data exploration
• Broad knowledge in Data Warehouse concepts and technologies, dimensional modeling, MDX queries, Star and Snow Flake Schema, and reporting tools.
• Knowledge in developing OLAP cubes, facts and dimension tables with star schema and snowflake schema using SQL Server Analysis Services (SSAS)
• Experienced in all phases of the Software Development Life Cycle (SDLC), Agile Scrum, involving business process analysis, requirements gathering and analysis, detailed design, development, testing and post implementation support.
• Known for excellent communication and client facing skills, strong analytical and problem solving skills, ability to effectively multitask, meet deadlines, quickly adapt to different project environments and an excellent team player.

TECHNICAL SKILLS:

RDBMS: SQL Server 2000/2005/2008/2008 R2/2012, MS Access

Languages: C, VB.NET, C#, Java, Java Script, Json, T-SQL, PL/SQL, HTML, XML

ETL Tools: DTS, SQL Server Integration Services (SSIS).

Tools: Business Intelligence Development Studio (BIDS), SQL Profiler, SQL Query Analyzer, SQL Server Management Studio, SQL Server data tools (SSDT).

Database Tools: SQL Server Enterprise Manager, SQL Server Management Studio, Query Analyzer, SQL Profiler, Data Transformation Services(DTS), ETL, Query Builder, BCP

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports, Report Builder, SSDT

Operating Systems: Windows NT/ 98/2000/2003/ windows 7/Vista/ Windows 8, UNIX

Case Tools: MS Office 2010/2007/2003 , MS Excel 2010/2007/2003 , MS Outlook 2010/2007/2003 , MS Visio, SharePoint Server.

PROFESSIONAL EXPERIENCE:

Confidential - IL

SR.SQL Developer

Responsibilities:

• Senior database developer responsible for data warehouse ETL process development, conversion and maintenance, SSRS report creation, and SQL query performance tuning.
• Developed, transformed, enhanced, and supported processes using Transact SQL and SSIS which moved data from text file and other sources into the SQL Server warehouse. Assisted in conversion of ETL and SQL stored procedures.
• Developed SSRS reports and complex stored procedures for real-time benchmark and scoreboard display at Enterprise monitor dashboard. These reports retrieved data from OLTP SQL production databases and required extensive stored procedure tuning for rapid display.
• Designed SSRS 2012 reporting system to share reports between plants eliminating the need to support multiple versions. Reports were deployed to SharePoint as well as remote reporting servers.
• Investigated nightly ETL data integrity issues for business intelligence reporting. Corrected job errors, data access issues, and platform data type conversion conflicts.
• Worked on different Production Issues and Wrote complex stored procedures and user defined functions. Mentored DBAs and developers in existing stored procedure design and data access techniques.
• Worked closely with end-users to collect requirements and test processes. Analyzed data and designed databases for importing data.
• Approved database changes and moved into production systems. Analyzed and corrected SQL bottlenecks and poorly performing logic using SQL Profiler and query execution plans.

Environment: Microsoft SQL Server 2008/2016 R2 Enterprise edition, T-SQL, SSIS, SSRS, SSDT, Microsoft Visual studio

Confidential

MSBI / Data Engineer

Responsibilities:

• Built and maintained T-SQL scripts, indexes, and complex queries for data analysis and extraction.
• Determined user/business/functional requirements. Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.
• Designed and developed reports using Microsoft SQL Server Reporting Services (SSRS) and Crystal Reports.
• Processed Daily expenses through SSIS jobs by collecting data from Concur FTP servers.
• Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
• Wrote T-SQL queries to validate the error reports being given to the client and prepared T-SQL scripts for the Application team, Reports team during development.
• T-SQL development included queries using joins, subqueries, Ranking functions, Derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF), constraints & Database triggers.
• 11. 24/7 on-call support for the production environment.
• Reviewed and documented existing stored procedures.
• Worked on writing complex sql queries for business logics.

Environment: Microsoft SQL Server 2008/2016 R2 Enterprise edition, T-SQL, SSIS, SSRS, SSDT, Microsoft Visual studio

Confidential

MSBI / Data Engineer

Responsibilities:

• Creating complex SSIS packages using proper control and data flow elements with error handling. Involved in conversion of DTS to SSIS packages and troubleshooting the migration issues.
• Involved in troubleshooting at database levels, error handling and performance tuning of queries and procedures.
• Worked as a database developer on databases like MS SQL Server 2008R2 using T-SQL, stored procedures and views to get data from Data warehouse.
• Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel, Text file, XML file to different data Marts.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Configured Connection Manager Files and CMD files for SSIS packages to dynamically execute on QA Server and Production server
• Made Master Child package using variables and Execute package task in SSIS.
• Wrote VB.NET code for Script task to perform functions that are not available in the built-in tasks and transformations that SSIS provides.
• Worked on designing reports using SSRS 2012 mainly Parameterized reports and Sub reports.
• Printed contracts and reports from Quick Reports and Crystal Reports.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications
• Involved in validating the data in power BI.
• Optimized the performance of queries with modification in TSQL queries, established joins and created clustered indexes.
• Created parallel period, filter, ancestors and cross join MDX queries.
• Worked on QA the data and adding Data sources, snapshot, caching to the report
• Involved in troubleshooting at database levels, error handling and performance tuning of queries and procedures.
• Reviewed and documented existing stored procedures.
• Worked on writing complex sql queries for business logics.
• Involved on doing analysis of replication of tables and to recreate the Tableau report in Power BI.
• Worked on the data layer validation and fixes in validating the CDP and PDP of each page for different brands.
• Involved in working on Descriptions needed for IBM DA tables and their columns of source schema.
• Worked on finding campaign performance from IBM DA.
• Involved in validating the testing activities of upgrade and Identify the utilities that will be needed and install them.
• Created processes and automations to allow for quick testing of code prior to deployment of the weekly releases.
• Worked on Testing the Transactional emails, Ability to send email campaigns, Real time decision content of data feeds and Creation of data for Power BI reports.
• Worked on postman scripts validation of regression testing using postman.
• Used Postman Scheduler for validating, executing, scheduling and monitoring jobs.

Environment: Microsoft SQL Server 2000/2005/2008 R2 Enterprise edition, T-SQL, .Net, SSIS, SSRS,SSDT, Report Builder, Microsoft Visual studio, Windows server 2003, Internet Information Server (IIS), MS Excel 2007, Tealium, IBM DA, Postman, Power BI

Confidential - MA

MSBI Developer

Responsibilities:

• Transformed data from one server to other servers using tools like Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
• Used SSIS Scheduler for validating, executing, scheduling and monitoring jobs.
• Performing Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access, Oracle and DB2) and SQL Server as a part of Data Migration, Data Maintenance and other ETL tasks.
• Used SSRS to create, execute, and deliver tabular, matrix, and charts reports. Also Debugged and deployed reports in SSRS.
• Worked on DAX function in Power BI.
• Expert in web designing using HTML, CSS, XML and JavaScript to display reports on the server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Wrote multiple programs in Python to monitor virtual machine usage data using VMWare API calls.
• End to end experience in designing and deploying data visualizations using Tableau
• Implemented Script Task using C# to perform Validations.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, statement & using the TOP operator to limit the Select Statement in certain Queries.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Involved in performance tuning of the database and T-SQL queries using Explain Plan.
• Developed object-oriented programming to enhance company product management
• Created Ad-hoc reports using Report builder 2.0/3.0 in SQL SERVER 2008.
• Created Complex reports such as cascading parameterized reports, interactive display reports dashboards.
• Generated production reports, parameterized reports and regular reports using the tools SSRS.
• Built a Data Warehouse with Kimball methodologies.
• Created and rebuilt multi-dimensional cubes using SSAS to support business reporting and forecasting process.
• Written and reviewed functional specifications, performed unit and system tests, troubleshoot and implement logged bug fixes.
• Designed and Developed Technical specifications for the packages created, for future reference as per the client's request.
• Used SCRUM agile methodologies, test driven development and automated & slip-stream builds.

Environment: Microsoft SQL Server 2000/2005/2008 R2 Enterprise edition, T-SQL, SSAS, SSIS, SSRS, BIDS, Tableau, Microsoft Visual studio, Windows server 2003, Internet Information Server (IIS), MS Excel 2007, Power BI, Team Foundation server (TFS) 2010

Confidential - MA

SQL BI Developer

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).
• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created parallel period, filter, ancestors and cross join MDX queries.
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Provided Source to Target Mapping (STM) Excel spreadsheets database loading.
• Developed Normalized Logical Data Model (LDM) and de-normalized Physical Data Model (PDM) using ERWIN
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Worked on various tasks and transformations like Execute Sql Task, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Having hands on experience in DR Processes including Log shipping and Database Mirroring.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to director and analysts to be reviewed in Excel Sheet
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring during execution
• Created SSIS packages to migrate data from Oracle DB to SQL Server 2008.
• Data migration (Import & Export using BCP) from text to SQL Server 2008.
• Involved in database backup, recovery procedures
• Planned back up strategy for disaster recovery
• Responsible for log backups and restoration
• Worked with Dynamic Management Views (DMV) for improving query performance.
• Implementing all high availability techniques like clustering, log shipping, replication.
• Working experience with Column store indexes, table partitioning in SQL SERVER 2012.
• Working experience with in-memory concepts of OLTP databases in SQL SERVER 2014.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.

Environment: Windows2003 Advanced Server, MDX,ASP.NET, MS SQL Server 2005/2008/2012/2014 ,, Pl/SQL, Oracle 11g, Notes, SSRS, SSIS, Visual Studio 2008, Erwin

Confidential, NY

SSIS/ SSRS Developer

Responsibilities:

• Created Tables, Views, User Defined Functions and Stored Procedures for new and modified business requirements in SQL server and SSIS Servers.
• Written T-SQL Stored Procedures and queries for accessing Data from Teradata Database.
• Created various connection managers (OLE DB connection, flat file connection, ADO.NET connection, Analysis Services connection, Excel connection) available in SSIS to collect data from heterogeneous sources such as Oracle, SQL Server, flat files, excel to perform ETL process.
• Done ETL process extract, transform and load data from Excel sheets, Flat files to tables using SSIS and Data Flow Transformations.
• Experience in creating Reports from Web Services and used MDX on Cubes to create reports in SSRS.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements into ETL procedures.
• Created, tested, modified and scheduled SSIS packages to update the tables on a day to day basis.
• Extensively involved in designing and maintaining the SSIS packages to export data of Excel spreadsheets and flat files sources to SQL Server Database
• Optimization of stored procedures in SQL Server to improvise the speed of the application to display the data.
• Experience in Developing and Publishing Reports in SQL Server 2005 using SSRS (SQL Server Reporting Services).
• Created various kinds of reports involving Drill Down, Drill through Report, Parameterized Reports and Ad-hoc Reports.
• Designed the Sales and Manufacturing Summary reports in SSRS 2005 from the requirement document.
• Provided quick solution to Azure teams for self-servicing data maintenance operations, which uses SQL Master Data Services. Configured and setup SQL Server Master Data Services (MDS) for self-serving data maintenance across different teams.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008.
• Used Stored Procedures to retrieve reports data that accept parameters.
• Deployed packages in SQL server MSDB database.
• Used SSIS Documenter for documenting SSIS packages.
• Used SQL Profiler for debugging issue, performance tuning whenever necessary.
• Modified and created new stored procedures, views and SSIS packages for the existing ones to reduce their execution time.
• Reviewed and documented existing stored procedures.

Environment: MS SQL Server 2008R2, SQL Reporting Services, Oracle, Visual Studio 2008/2010, C#.Net, Crystal Reports 10, SQL Server Integration services, TFS/VSS, Azure, C#.Net, T-SQL, ASP.

Confidential

SSIS / ETL Developer

Responsibilities:

• Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
• Analysis, Design and data modeling of Logical and Physical database using E-R diagrams.
• Involved in database Schema design and development.
• Created efficient Queries, Indexes, Views and Functions.
• Enforced Security requirements using triggers to prevent unauthorized access to the database.
• Optimized the Database for best performance.
• Design and develop the payroll module using MS SQL Server 2008 R2.
• Installation and Administration of SQL Server 2008 R2.
• Migrated data from MS Access to SQL Server.
• Performance Tuning of the client databases for better performance on a regular basis.
• Responsibilities include writing of scripts for Database tasks, releasing Database objects into production.
• Designed SSIS packages to perform Extract, Transform and load (ETL) data from different sources like SQL server 2008, MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS
• Developed ETL SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Involved in designing ETL as a part of Data warehousing and loaded data in to Fact tables using SSIS.
• Produced operational reports in SSRS 2008 R2 i.e. drill-down, drill-through, dashboard and matrix reports. Responsible for ETL through SSIS and loading Data to DB from different input sources.
• Used ETL for data flow from different source files like XML, Excel, Tables, and Views to other databases and files with proper mapping.
• Implemented Complex Logging in SSIS Packages.

Environment: SQL server 2008/R2, MS VB Access, Windows 2003 Standard Edition, Microsoft Share point Portal Server, Visual Studio 2005, C#, VB.net 2005, .NET 3.0 SP2, SSRS, SSIS, DTS, SQL Profiler, VSS, TFS.