PROFESSIONAL SUMMARY:

• 4 years of strong experience in the IT industry as a MS SQL Server Developer and Azure Data factory include experience in design, development, and implementation of database systems using MS - SQL Server 2014/2012 for both OLTP & Data Warehousing Systems applications with various business domains like Financial, pharmaceutical and manufacturing
• Good hands on Azure Data Factory
• Good experience in Confidential Flows
• Expert in T-SQL development to write complex queries by joining multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions
• Moving data from Kusto DB to Azure SQL DB with the help of Confidential Flows
• Create automated workflows with the help of triggers
• Pumping data between Excel and Servers using Flows
• Scheduled Jobs in Flows and ADF Pipelines
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance
• Experience in Performance Tuning and Query Optimization
• Expert in maintaining Error logging using Exceptional Handling in T-SQL and SSIS
• Used Azure Download/upload tasks to download and upload blobs.
• Experience in upgrading SQL Server software to new versions and applying service packs and shot fixes and unattended Installation
• Experience in using profilers and performance monitor to monitor SQL Server
• Expertise in creating visualizations and reports using Power BI
• Expertise on creating multiple kinds of Power BI Reports and Dashboards
• Good knowledge of System Development Life Cycle (SDLC)
• Created Reports with complex formulas and to query the database for business Intelligence
• Experienced in maintaining Event Handlers, Created Configuration and Connection Managers
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), creating Dynamic packages for Incremental Loads
• Experience in enhancing and deploying the SSIS Packages from development server to production server by using package configurations
• Expert in using tools like Bulk Insert Task (BCP) in SSIS
• Experience with logical and physical data modeling, FACT and Dimensional tables and database design using Data Modeling Tools like Erwin, MS access and Confidential Visio
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services
• Created shared dimension tables, measures, hierarchy levels, cubes and aggregations on MS OLAP/ Analysis Server
• Developing reports on SSAS & SSRS on SQL Server 2014/2012 Sound Experience and understanding of SSAS, OLAP cube and Architecture
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, drill through, Parameterized, Cascading, Conditional, Table, Matrix, Chart, and Sub Reports
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling

TECHNICAL SKILLS:

Databases: SQL Server 2014/2012/2008/2008 R2/2005, Oracle 8i/9i/10g/11g, MYSQL

Database Tools: SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Power BI, Data Transformation Services (DTS), Power View, ETL, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio(BIDS), SQL CMD.

T: SQL, MDX, C, C++, VB 6.0, PL/SQL, C# 4.0, Shell Scripting, LINQ, ASP.NET, UML, XML, XMLA, J2SE/J2EEOLAP SQL Server Reporting Services (SSRS), SSAS, SSIS, Crystal Reports 9.0/8.5, OLAP, Erwin, Tableau, Power BI

Change Management Tools: Tortoise SVN, Visual Source Safe (VSS), Team Foundation Server (TFS)

Operating Systems: Windows Server 2000/2003/2008/2012 , MS DOS, Unix, Linux.

Data Modeling Tools: Visio, Erwin, Red gate, Lite speed

Cloud Technologies: AWS, Azure (ADF V1 and ADF V2)

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, Washington

ADF SQL BI Developer

Responsibilities:

• Building the pipelines to copy the data from source to destination in Azure Data Factory (ADF V1)
• Worked on creating dependencies of activities in Azure Data factory
• Creating Stored Procedure and Scheduled them in Azure Environment
• Monitoring Produced and Consumed Data Sets of ADF
• Creating Data Factories in Azure Data factory
• Successfully creating the Linked Services on the source and as well for the destination servers
• Moving data from Kusto DB to Azure SQL DB with the help of Confidential Flows
• Created automated workflows with the help of triggers
• Pumping data between Excel and Servers using Flows
• Scheduled Jobs in Flows and ADF Pipelines
• Migrating the data from different sources to the destination with the help of ADF V1
• Creating Pipelines with GUI in Azure Data Factory V2
• Scheduling Pipelines and monitoring the data movement from source to destinations
• Transforming data in Azure Data Factory with the ADF Transformations
• Creating Multiple Data Sets in Azure worked in migration of SQL Server 2008/2012/2014 to SQL Server 2017.
• Used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Create Master Package to run different other ETL in one Master package.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Trouble shoot any kind of data issues or validation issues
• Created stored procedures using Common Table Expression (CTE) and various types of UDF functions Developed Complex T-SQL queries, common table expressions (CTE), stored procedures.
• Provide support of production applications by trouble-shooting issues, and developing, testing and migration of Data Bases.
• Moving CSV files from Azure blob to Azure SQL Server
• Creating views as feed for Power BI Reports
• Self-Service PowerBI with a Tabular model as a backend is the product that provided huge value in Data Discovery
• Most of the work done is selling a product in PowerBI to C-level executives.
• Design-Oriented PowerBI reports that are good for DataStories
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Gathering requirements from the client managers and implementing them as tasks as per requirements
• Debugging the scripts which were developed by the other team mates
• Delivering the workloads before the deadlines
• Understand the business processes and application functionality relevant to their area as well as an understanding of related applications in adjacent areas.
• Author technical design of functional specifications and progress the solution from design though the software development life-cycle to implementation. Has a strong understanding of, and ensures adherence to, the IT processes and standards required.
• Provide production support of applications in production by trouble-shooting issues, proposing solutions, develops and tests fixes, and migrates solution.
• Develop and unit test application programs as specified in Technical Designs.
• Obtain code reviews from Senior Application Developer and ensure that all programming standards and policies are adhered to.
• Obtain Technical Designs and Unit Test plan reviews from Senior Application Developer and perform Tech Designs and Unit Test plan reviews of other developers.

Environment: MS Access DB, Kusto DB, Azure Data Bases, Confidential SQL Servers, Visual Studios, Azure Data Factory Version1 (GA) and Azure Data Factory Version2 (In Preview), SSIS, SSAS, SSRS and Power BI. T-SQL, JSON, C#, U-SQL, Shell Scripting, Python, Confidential Flows.

Confidential, South filed, MI

SQL BI (SSIS/SSAS) Developer

Responsibilities:

• Created/Updated Views, Stored Procedure, Triggers, User Defined Functions (UDF) and Scripts using T-SQL Code.
• Extract Transform Load (ETL) development using SQL Server 2008, SQL 2012 Integration Services (SSIS).
• Experience in moving the data from heterogeneous data sources like oracle, xml etc. to SQL using SSIS.
• Used different transformations like fuzzy lookup, derived column transformation etc. using SSIS.
• Worked on various possible performance-related issues including Database Tuning with the sole intention of achieving faster response times and better throughput.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Create and optimize complex T-SQL queries and stored procedures to encapsulate reporting logic
• Created SQL Server Reports using SSRS 2012.Identified the data source and defined them to build the data source views.
• Worked on debugging Reports and deploying Reports.
• Scheduled the Reports to run automatically.
• Designed rich dashboards with Power BI and prepared user stories to create compelling dashboards to deliver actionable insights.
• Experience in handling Tabular Data Modeling in SSAS.
• Created reports in Power BI Desktop and published to portal utilizing the SSAS Tabular via Analysis connector.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008R2.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008R2.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and parameterized reports using SSRS 2012.
• Created subscription for the windows file share and implemented three layer securities for the reports, SSRS website, and in the Intranet web application.
• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs
• Used Multi-dimensional expressions (MDX) to present the date asked by the user, to simultaneously query on different dimensions.
• Developed Analysis Services Project. Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS. Responsible for identifying and defining Data Source and Data Source views. Created cubes and defined the dimensions.
• Designed different type of STARschemas using ERWIN with various Dimensions like time, services, customers and FACTtables.
• Involved in database design to create STARschema using Dimensional and Fact tables.
• Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS.
• Used Performance Point Server to create interactive reports with an ability to drill down into details.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Experience in Performance Point Server powerful visualization tools, including the Decomposition Tree, Perspective View and Performance Map, to drill down, cross drill, pivot, chart, and investigate data.
• Created SSIS packages to migrate data from Oracle DB to SQL Server 2008R2.
• Created stored Procedures for Reports generation.
• Performed Documentation for all kinds of reports and DTS and SSIS packages.
• Designed and implemented stored procedures and triggers for automating tasks.
• Developed data interface layer using ASP.NET and C# for data access.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS and Crystal Reports with .NET applications.
• Involved in the design, development and implementation of web user interfaces using C#. NET, ASP.NET
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
• Filter and sorting data using Power View in Excel 2013.
• Tested applications for performance, data integrity and validation issues.
• Worked on gathering requirements from Business Users, Analysts by scheduling meeting at regular basis.

Environment: SQL Server 2014/2012, SSIS, SSAS, SSRS, MDX, OLAP, XML, MS PowerPoint, MS SharePoint, MS Project, MS Access 2007/2003, Informatica, .NET, C#, Agile Programming, ASP.NET, C#, Shell Scripting, Oracle, Crystal Reports.

Confidential

SQL BI (SSIS/SSAS/SSRS) Developer

Responsibilities:

• worked in migration of SQL Server /2014.
• Used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Create Master Package to run different other ETL in one Master package.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Trouble shoot any kind of data issues or validation issues
• Created stored procedures using Common Table Expression (CTE) and various types of UDF functions
• Developed complex T-SQL queries, common table expressions (CTE), stored procedures, and functions used for designing SSIS packages.
• Designed dynamic SSIS Packages by passing project/Package parameters to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• SQL Server 2008 Reports Writer and performed complex SQL report writing and design.
• Used SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, and SQL Server Visual Studio.
• Create different SSRS Reports based on the user’s requirement. All kinds like ad-hoc reports
• Used Jasper Reports as a reporting tool.
• Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using SQL Server Reporting Services 2012.
• Design the ETL for the data load.
• Designed SSIS Packages to transfer data from various sources of the Company into the database that was modeled and designed.
• Develop reports using MS Power BI , enhancing pivot tables and charts with power pivot.
• Created reports using crystal reports.
• Maintained and updated Jasper reports.
• Bug fixes in SSIS, SSRS and stored procedures as necessary.
• Used C# and VB Scripts in ETL Packages where ever necessary.
• Developed web based ASP.NET internet applications
• Worked in an agile scrum methodology.
• Scheduling the jobs to run for ETL using SQL Server Agent.
• Worked on writing the T-SQL code for the historical data to pull per specification requirement.
• Designed and developed the reports to the requirements using Tableau and Power Map .
• Created Informatica mappings with T-SQL procedures to build business rules to load data.
• Played roles like production support of SSIS and SSRS jobs.
• Perform T-SQL tuning and optimizing queries for and SSIS packages.
• Created SSIS process design architecting the flow of data from various sources to target.
• Created numerous simple to complex queries involving self joins, correlated sub queries, CTE's for diverse business requirements.
• Worked on Incremental Loads using concepts like Checksum and Column to Column compare.
• Scheduling SSRS jobs and production support.
• Use of SharePoint 2014 and TFS to store all the related work and report the same by creating Tasks in TFS

Environment: SQL Server 2012/2014 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), VB Script, ASP.NET, T-SQL, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MDX, Erwin, Informatica, MOSS 2007, MS Project, MS Access 2008 & Windows Server 2008, Oracle.