SUMMARY

• 6 years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2016/2014/2012/2008 R2 in Development, Staging and Production Environments on various business domains.
• Experience in MS SQL Server with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and T - SQL.
• Exposed to all phases of software development life cycle SDLC including in-depth knowledge of Agile methodology, Enterprise Reporting Life Cycle, SQL Server Migrations, Change control rules, problem management and escalation procedures.
• Excellent in the Design of ETL DTS Packages& SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split etc.
• Good knowledge of Data Marts, Data warehousing, OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer
• Experience managing Big Data platform deployed in Azure Cloud
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing
• Strong experience with SQL Server and T-SQL in constructing complex stored procedures, triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, exceptional handling, and data integrity.
• Delivered BI reporting using Power BI, Reporting Services (SSRS) and Tableau.
• Experience with SQL Performance tuning and transaction analysis.
• Strong experience in MS SQL Server with SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS) and Power BI.
• Expert in generating Drill down reports, Parameterized reports, Linked reports, Ad-Hoc reports, Sub reports and filters, and charts using SSRS.
• Experience in providing SSRS server level, Item level Security & Accessibility to various reports.
• Expert in generating Drill down reports, Parameterized reports, Linked reports, Ad-Hoc reports, Sub reports and filters, and charts in SSRS 2016/2014/2012/2008
• Knowledge on SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes.
• Experience in using versioning tools like Visual Studio Team Services (VSTS), Microsoft Team Foundation Server (TFS) and Visual Source Safe (VSS).

TECHNICAL SKILLS

Database: SQL Server 2005/2008/2012/2014 , MS Access 03/07, Oracle9i, 10g

Operating Systems: Windows XP/2000/2003/Win XP/Win 7

Programming Languages: T-SQL, HTML, C#, VB, VBA, VB.Net, PL-SQL

BI Suite: SSIS, SSAS, SSRS, PowerBI, Tableau

Database Tools: SSMS, MS Access, MS Visual Studio, Toad, BIDS Helper 2008 v1.5.

Project Methodologies: SDLC, Agile, Scrum, Waterfall

PROFESSIONAL EXPERIENCE

Confidential, Warren, MI

SQL Server BI (SSRS /SSIS) Developer/ Power BI Developer

Responsibilities:

• Gathering the requirement and analyzing the source to upstream the data.
• Interaction with clients and users to gather the business requirement and analyze the downstream data file to downstream the data from source system to existing data warehouse.
• Designed a complex SSIS package for importing data from SQL Server 2016.
• Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge and Merge joining, Pivot and Unpivot Control Flow Transformations
• Implemented slowly changing dimensions to maintain Historical Data in Data warehouse.
• Created packages in SSIS with error handling and event handling.
• Implemented data views and control tools for guarantee data transformation using SSIS.
• Created SSIS packages to provide consolidated information in user-defined dashboards 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 Text file and CSV files to data warehouse.
• Created a lot of complex stored procedures, triggers, functions, indexes, views with T-SQL statements in SQL Server Management Studio (SSMS).
• Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and chart.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities
• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell
• Created applications to load data from Azure storage blob to Azure SQL, to load from web API to Azure SQL and scheduled web jobs for daily loads
• Automated the SSIS packages even it fails during daily activity.
• Experience in migrating data from on-premise SQL Databases into Cloud Azure.
• Designed, deployed, and maintained of various SSRS Reports.
• Experience in writing custom code expressions in SSRS.
• Created and managed database objects and efficiently such as tables, views, clusters, indexes, stored procedures, functions and triggers, and referential Integrity.
• Wrote the expressions in SSRS wherever necessary
• Involved to write complex T-SQL queries and Stored Procedures for generating reports.
• Defined parameters for parameterized Reports using SSRS.
• Designed and developed various Service Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS.
• Successfully worked with Report Server and configured into SQL Server 2016.
• Involved in the analysis, design, development, testing, deployment and user training of analytical and transactional reporting systems.
• Implemented Report Snapshots to improve the performance of SSRS reports.
• Extensively worked on TFS (Team Foundation Server) for version control.
• Created and modified stored procedures, triggers, functions, and other database objects.
• Scheduled Automatic refresh and scheduling refresh in Power BI service.
• Tuned SQL queries using execution plans for better performance.
• Worked with the development teams to document the transformation rules for data migration for reporting purposes using Python and SQL.
• Scheduled Packages using SQL Server Agent Jobs to execute at specified time on weekly and monthly basis

Environment: MS SQL Server Management Studio 2016/2012 (SSMS), MS Visual Studio 2017, SQL Server Integration Service (SSIS), SQL Server Reporting Services (SSRS), SQL Profiler, SQL Server Agent, T-SQL, Jira 7.6, Azure SQL, Azure Storage Explorer, Azure Blob

Confidential, Houston, TX

SQL BI Developer (SQL Server / SSIS/SSRS)/ Power BI Developer

Responsibilities:

• Worked with Business Analysts and Users to understand the requirements.
• Extensively worked on Data Flow tasks like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Used SQL Server Package Configuration technique to make Dynamic configurations.
• Used Text Files/ SQL Server Table Logging for all SSIS packages.
• Developed Power BI reports using query logic based on business rules.
• Creation, Development and Maintenance of SSIS Packages and SSRS Reports
• Developing Power BI Dashboards using Power BI Desktop and Power BI Pro.
• Created calculated columns, complex Measures in Power BI Desktop using DAX to show data analysis techniques.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS
• Designed DAX queries in accessing cubes and hands-on experience in query structuring, performance optimization.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS
• Extracted Data from various Heterogeneous Databases such as Oracle and Access database, DB2, flat files to SQL Server 2016/2014 using SSIS.
• Used SSIS to create ETL packages to validate, extract, transform and load data into the data warehouse and data marts.
• Worked with various SSIS package Transactions, restart ability and roll back techniques.
• Created Tables, Indexes, Constraints, Views, Stored Procedures, Triggers.
• Optimizing Stored Procedures and long-running SQL queries using indexing strategies and query optimization techniques.
• Schedule the packages to keep extracting the data from OLTP at specific time intervals.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Used SQL Server Agent for scheduling jobs and alerts.
• Deployed the packages to production using XML package configuration.

Environment: MS SQL Server Management Studio 2016/2014 (SSMS), SSRS, SSIS, MS Visual Studio 2015, MS Excel 2016(Power Pivot), Tableau 10, DB2(11.1/10.5), SQL Server Agent, Oracle 12c (12.1), .NET, XML

Confidential, Austin, TX

SQL Server SSRS/SSIS Developer/ Power BI Developer

Responsibilities:

• Created an SSIS Package (works for transactional and canonical data that works as a template for every interface).
• Created Automated Job steps to process daily and weekly Data.
• Created various complex SSIS packages and deployed to Development, QA and Production environments.
• Extensively used various Red gate tools.
• Used SQL Compare for comparing and deploying SQL objects.
• Used SQL Data Compare for comparing and deploying data.
• Developed BI applications reporting tool SQL Server reporting services (SSRS) and SQL Server integration services (SSIS).
• Used SQL Packager for comparing and deploying SQL objects with or without data.
• Source control that keeps the team in sync with easy access to the latest database version.
• Worked closely with the Business team during the development of the Interfaces.
• Created Technical specification documents for each SSIS package developed.
• Administered and monitored SSIS packages.
• Defined report layouts and created Parameterized, Drill down, Drill through and Aggregation reports in MS SQL environment using SSRS.
• Extensively used various SSIS objects like Control Flow components, Data flow components, Connection Managers, Shared Data sources.
• Efficiently used Configuration files for changing the connection managers while deploying packages to different servers.
• Created DTEXEC and DTEXECUI batch files to run various interfaces.
• Created several Linked Servers to load data into different locations.
• Used Dynamic SQL for different variables while developing SSIS packages.

Environment: MS SQL Server Management Studio 2014/2013 (SSMS), MS Visual Studio2013/2012, T-SQL, SQL Server Integration Service (SSIS), SQL Server Reporting Services (SSRS), Redgate Tools, TFS 2013, SharePoint 2013

Confidential

SQL Server SSIS/SSRS Developer

Responsibilities:

• Created a lot of complex stored procedures, triggers, functions, indexes, views with T-SQL statements in SQL Server Management Studio (SSMS).
• Involved in designing and managing schema objects such as Tables, Views, Indexes, Stored Procedures, Triggers and maintained referential integrity using SQL Server Management Studio.
• Processed ETL to transfer data from remote data centers to local data centers using SSIS. Cleansing, messaging of the data is done on the local database.
• Designed an ETL strategy to transfer data from source to landing, staging, and destination in the data warehouse using SSIS and DTS (Data Transformation Service).
• Developed SSIS packages to export data from Excel/Access to SQL Server, automated all the SSIS packages and monitored errors using SQL Server Agent Job.
• Used reporting service (SSRS) created several reports based on cube and local data warehouse.
• Prepared reports using SSRS (SQL Server Reporting Service) to declare discrepancies between user expectations and service efforts involved in scheduling the subscription reports via the subscription report wizard.
• Interacted with subject matter experts in understanding the business logic, implemented complex business requirements in backend using efficient stored procedures and flexible function.

Environment: MS SQL Server Management Studio 2008 R2/2012 (SSMS), SQL Server Integration Service (SSIS), SQL Server Reporting Services (SSRS), MS Visual Studio 2012, SQL Server Profiler, SQL Server Import/Export Wizard, MS Office 2010.