SUMMARY

• Over 8+ years of professional experience in working with projects driven on SQL Microsoft Business Intelligence tools, Data Warehousing and ETL processes.
• Expert in T - SQL Microsoft BI stack(T-SQL,SSIS,SSRS,SSAS)
• Experience in all phases of the Software Development Life Cycle (SDLC).
• Proficient in relational database modeling(Conceptual, Logical and Physical Modeling) and normalization
• Strong RDBMS concepts and experience in creating and maintaining Stored Procedures, Views, Functions, Triggers, Indexes, and Constraints.
• Designed, developed and implemented variousSSISPackages and deployed using Deployment Wizard.
• Experienced in ETL from various heterogeneous data sources like Access, Excel, and CSV, flat files using connectors, tasks and transformations provided by SSIS.
• Proficient in creating dynamic SSIS packages for Incremental Loads and used change data capture (CDC) control task that makes efficient data loading.
• Experienced in Configuring Batch Logging, Error Logging, event handlers and Connection Managers in SSIS.
• Good hands on experience on performance tuning ofSQLserver for handling transactions at high volume.
• Experienced in migrating data from one SQL Server version to another.
• Highly experienced in database server performance tuning and optimization of Complex SQL queries.
• Experienced in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Experience with data security and privacy by datasets.
• An excellent team player & technically strong person who has capability to work with business users, project managers, team leads and architects, thus maintaining healthy environment in the project.
• Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

RDBMS: SQL Server 2005/ 2008/2008 R2/ 2012/2014,2016 DB2

Database/ETL Tools: SSIS, SSAS, SSRS, Informatica Cloud, Snowflake Computing, Microsoft Azure

Reporting: SQL Server Reporting Services (SSRS), Report Builder, cognos, tableau

Languages: VB.NET, C#, C++, T-SQL, E-SQL

MS-Office: Microsoft Office Tools

Operating Systems: Windows Server 2000, 2003, 2008, 2008R2, 2012

Tools: Backup Utility, Litespeed for SQL Server, Visio

PROFESSIONAL EXPERIENCE

Confidential, Dayton, OH

SENIOR SQL/SSIS Developer

Responsibilities:

• Worked as a seniorSQLdeveloperto write complex queries like Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQLcode andSQLjoins for applications.Created and developedSQLserver jobs onSQLServer Integration Services (SSIS) packages to automate the execution of the packages at a particular time depending on requirements.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.(used CTE, temporary tables, user defined table types in codes developed)
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008/2012.
• Created Complex ETL Packages usingSSISto extract data from staging tables to partitioned tables with incremental load using Visual Studio.
• Implemented custom logging to SQL server audit tables to track the package processing and table processing
• Scheduled SSIS packages for running monthly/weekly/daily feeds from and to various vendors using SQL server Agent.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task and various transformations
• Integrated SSIS packages with the windows batch to trigger the SSIS package.
• Used TFS for source code management of developed codes/version control,
• Created expressions inSSRSto provide flexibility to users by providing them with variety of Options for seeing the business information in tables/charts etc.
• Debug through C#.NET code to troubleshoot production issues and created unit test methods for validation of codes developed.
• Developed custom DLL with C#.NET to implement SFTP for secure file transfers
• Worked in creating and developing several interfaces using C#.Net, VB.Net and ASP.Net
• Good Experience in using SSIS Script task transformation to create complex transformation logic using C#.Net
• Created Alerts/log entries for successfully completed and failed jobs
• Rebuilding/Reorganize indexes and running Database Consistency Check Commands (DBCC).
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Coordinated and attended every day standup/scrum/agile meetings and weekly sprint meetings to evaluate completed work.
• Ensured HIPPA and regulatory compliance rules are addressed for all data movement
• Worked on Agile Methodology and Microsoft Team Foundation Server (TFS)

Environment: MSSQLServer 2016, Excel,SQL,T-SQL,SSIS,SSRS, Microsoft Visual Studio 2014, Microsoft Visio, Teradata, Informatica, TeamCity, Octopus, Agile/Scrum, TFS.

Confidential, Baltimore, MD

SQL/BIDeveloper

Responsibilities:

• Designed and implemented the ETL processes usingSSISwhich involved collection of data from sources likeSQLServer 2012/2014/2016.
• Developed and deployedSSISpackages, configuration files, and schedules job to run the packages to generate data in CSV files, Flat files.
• Automated File Transfer Processes and mail notifications by using FTP Task and Send Mail task in packages.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.(used CTE,temporary tables, user defined table types in codes developed)
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Used Performance Monitor andSQLProfiler to optimize queries and enhance the performance of database servers.
• Created Error and Performance reports onSSISPackages, Jobs, Stored procedures and Triggers.
• Developed impactful reports usingSSRS, MS Excel, Pivot tables and Tableau to solve the business requirements.
• Involved in creating database objects like Tables, Stored Procedures, Views, and user defined functions for this project.
• Developed queries using joins, unions, sub-queries, date and time functions, correlated sub-query etc.
• Gathered requirements from the end user and involved in developing logical model and implementing requirements inSQLServer 2014.
• Primarily responsible for developing applications inSSISas per Business Rules and features of the tool.
• Used Control Flow Tasks like forEach Loop Container, ExecuteSQLTask, Bulk Insert Task, File System Task and Data Flow Task.
• Assisted in creatingSSISpackages using MicrosoftSQLServer 2014 database sources, Oracle 11g database, Flat Files, Excel files and CSV files.
• Developed Data Source, Data Source View to create a logical view of the data to be placed in OLAP Cubes usingSQLServer Analysis Services (SSAS) projects.
• Developed tabular models for reporting, came up with design based on requirements and volume of data, whether to develop SSAS OLAP cube or Tabular Model.
• Created calculated columns using DAX to display in Dashboard.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
• Maintained and optimized the existing databases; monitored database performance and growth, performance tuning, generated reports according to the business requirements usingSQLServer.
• Monitored performance and optimizedSQLqueries for maximum efficiency.
• Created Star Schema for OLAP cube generation and extensively worked dimension modeling for analysis service using SSAS.
• Responsible in developing the Star Schema in a Data Warehouse design.

Environment: SQLServer Integration Services (SSIS),SQLServer Reporting Services (SSRS), MSSQLServer Analysis Services (SSAS), T-SQLServer, DAX, Windows 7, MS Office, Toad, Excel, Agile, PowerBI, Visual Studio 2012

Confidential

Business analyst/Application Developer

Responsibilities:

• As junior business analyst Developed technical solutions to business problems, to advance a company’s sales efforts, begins with defining, analyzing and documenting requirements. gathered information about customers booking online as application developer Successfully installed and configured MSSQLServer 2005 on the production server.
• Automated the migration of data from Oracle DB to MSSQLServer 2005 DB using MicrosoftSQLServer Migration Assistant (SSMA).
• Migrated the entire schema, as well as, data into MSSQLServer 2005 and also validated the migration process to ensure that it has been successfully migrated.
• Designed Drill down, Drill through, and Parameterized reports usingSSRS.
• Deployed generated reports onto the Report Server to access it through browser.
• Designed, reviewed, and created primary objects such as views, indexes, views and stored procedures.
• Worked with User Defined Functions and Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that had the least update to improve the query performance.
• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs
• Experience in creating multi-dimensional cubes using SSAS and designing DW Schemas.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2012.
• Created Calculate Member in MOLAP cube using MDX in SSAS 2012.
• Implemented user based subject selection (Role based security) in Power Views, Power Pivots andSSRSusing DAX, MDX andSQLqueries.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Performed error and event handling: precedence Constraints, Break Points, Check points and Logging, re-running the failedSSISpackages using checkpoints.
• DesignedSSISPackages to extract, transfer, load (ETL) existing data intoSQLServer from different environments for the SSAS cubes.
• Modified theSSISpackages for adding the new columns in the SSAS cubes and used Pivot transformation to pivot the data.
• DevelopedSSISpackages, which extract the data from Oracle source, which involves developing the code in oracle from the scratch.
• DevelopedSSISpackages to extract the data fromSQLserver tables and import the data to excel files.
• Worked with Business Analysts and Users to understand the requirement.
• Improved the performance of theSSRSreports by tuning theSQLserver code and modifying theSSISpackages associated with the reports.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.
• Work with the end users to ensure that the reports are working as per the Business requirements specified

Environment: MSSQLServer 2005/2008, Visual Studio-2006, T-SQL, DTS Designer, MS-Office, MS-Excel, VSS, SSRS,SSIS