PROFESSIONAL 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 Snowflake 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, HTML, XML

Tools: Business Intelligence Development Studio (BIDS), SQL Profiler, SQL Query Analyzer, SQL Server Management Studio, SQL Server data tools (SSDT), SQL Server Analysis Services (SSAS), Git Bash, AWS

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

Reporting Tools: SQL Server Reporting Services (SSRS), Power BI, 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, NC

SQL / SSIS Developer

Responsibilities:

• A new package needs to be created and existing packages need to be added for run upgrade advisor. This would give report of any foreseen issues that need to be fixed such as obsolete functions, stored procedures, keywords, integrations tasks, etc.
• The issues as notified need to be fixed by either removing the obsolete functionality and replaced with either new tasks of SQL or shift logic to use alternate technologies such as PowerShell, SQL Cmd prmpt, Visual Basic C#.
• Once package conversion to 2016 is complete, the package needs to be tested on QA environment. Depending on complexity of package this may involve multiple source test files involving .txt, .csv, .xml files that would be triggered on day-to- day basis to update the trade management data such as custom taxes, currency exchange rates, port rates.
• Logic flow of package needs to be validated by checking tables through SSMS and manually executing T-SQL commands. Additionally, the sub-tasks also need to be cleared of any warnings and errors.
• The next phase of the project would involve tuning the package for Performance optimization, better execution time and resource utilization.
• In this phase the code of each component will be tested in terms of resource utilization such as I/O, Memory and Execution time.
• The changes as required will be made either in database table structure or through TSQL code or Visual Basic code where optimization is possible.
• Once changes to code is complete, each package again goes through QA test phase to ensure each package is bug free and meets all design requirements of production.
• Build code by connecting to Visual Studio 2019 loaded on centralized server through established VPN per Confidential established security protocols.
• Connect to centralized TFS to build database objects as required. This may involve stored procedures, functions, views or any other objects that are identified.
• Any code that is completed and verified needs to be checked-in to TFS to be moved to next level of QA. On QA, the code needs to be checked for various true/false inputs to check for any vulnerabilities that may exist.
• If any vulnerabilities are identified a respective bug needs to be raised so it can be tracked by project team to ensure such bug is fixed prior moving on to next environment. There are several environments that code needs to be passed before going on to production such as DEV/QA/UAT/SIT/Production.
• Once code is passed the code needs to be deployed onto next environment for respective testing criteria and additionally, the existing code also needs to be updated for better performance optimization.
• This would involve bring in PROD data to lower environment for LOAD testing and Performance tuning.
• Each code will be run against several test environment to measure identifiers such as Execution time, resource utilization.
• IO Statistics, TIME ON characteristics of each code will give full reports of each object and indexes for every line in code.
• The optimization is undertaken including but not limited to making changes in code, indexes, statistics as required.
• Execution plan will also to checked for missing indexes, statistics information and other details.
• New indexes will be created depending on Impact analysis on code execution report.
• The report will be generated by running custom code to fetch requested details.
• Such indexes/views created will be run across multiple platforms to ensure there isn’t any impact to production servers.

Project Environment: Microsoft SQL Server 20012/2019 R2 Enterprise edition, T-SQL, SSIS, SSRS, SSDT, Microsoft Visual studio, Git Bash, AWS, Python, SharePoint.

Confidential, IL

SQL / MSBI Developer

Responsibilities:

• Develop system applications to Confidential coding standards and quality. Worked as a senior database developer in creating complex Stored Procedures, CTE, tables, views, joins and other statements for application.
• Collaborate with business teams to develop high-level system narratives, storyboards, and user interface prototypes.
• Integrated and Extracted Source Data using SSIS ETL tool and stored procedures from SQL Server.
• Designed and Developed new structure for revenue and cost data by adding changes to the existing SSIS package and Stored procedures that will be consumed by the Cube.
• Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements.
• Worked on ETL packages with different data sources (SQL Server, Flat Files, Excel source files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Created various reports for analysis of revenue, claims, customer interactions and shipping data using Excel, SQL Server Reporting Services, Power BI.
• Develop system test plans, ensure software quality assurance (SQA) standards are achieved, and validate that business goals are accomplished.
• Troubleshoot and resolve end-user issues with systems and reporting tools
• Understanding Source system data issues with Source System Owners and designing to handle all the gaps.
• Created SQL Queries based on the logic of the existing cube to analyze the raw data of the base tables as per the business requirement.
• Re-write the SQL query logic to increase the performance of the SSIS packages as part of the FDM cube Refresh.
• Troubleshot and debugged pre-existing ETL packages using breakpoint and checkpoint to facilitate stability and reusability; used XML configuration and SQL Server table configuration to prepare deployment-ready packages.
• Optimized the performance of queries with modification in SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Work on Tabular Modeling Development and Multidimensional Modelling Development using SSDT.
• Implements restart able strategy and error handling techniques to recover failed sessions and capture the incorrect data into reject tables for business user’s analysis
• Actively participated in designing the SSIS Package Model for initial load and incremental load for extracting, transforming, and loading data from various RDBMS and Non-RDBMS systems.
• Designed configurations, logging/auditing, package error handling, data error logging and checkpoint in SSIS Package model.
• Use Analysis service processing task to process the analysis cube in SSAS after DW run.
• Resolved query defect, data conflicts and inappropriate use of data.
• Participate in design discussions in data model structure with data modeler.
• Monitor all business requirements and validate all designs and schedule all ETL processes and prepare documents for all data flow diagrams to maintain for any dependent systems or future needs.
• Document all test procedures for systems and processes and coordinate with business analysts and users to resolve all requirement issues and maintain quality for same.

Project Environment: Microsoft SQL Server 2012/2017 R2 Enterprise edition, T-SQL, SSIS, SSRS, SSDT, SSAS, Microsoft Visual studio

Confidential, IL

SQL BI 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.
• 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.
• 24/7 on-call support for the production environment.
• Reviewed and documented existing stored procedures.
• Worked on writing complex sql queries for business logics.

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

Confidential, VT

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.

Project 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 as per the client's request.
• Used SCRUM agile methodologies, test driven development and automated & slip-stream builds.

Project 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 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.

Project Environment: Windows2003 Advanced Server, MDX, ASP.NET, MS SQL Server 2005/2008/2012/2014, Oracle, 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.

Project 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.