SUMMARY

• 5 plus years of experience in Database Design, Development and maintenance of database applications using SQL Server 2012/2014/2016
• Some exposure with AWS cloud services i.e EC2.
• Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedures consumed at various stages of migration/cleansing process, reports or data validation.
• Proficient in writing complex T - SQL (DDL, DML), new features like CTE, Ranking Functions, TOP(n), PIVOT, XML PATH,SQL, Physical, logical database design and Performance tuning.
• Good knowledge in Software Development Life Cycle SDLC and Software Testing Life Cycle STLC on Agile Scrum, Waterfall, V-Model and Agile Environments.
• Experience in AGILE Methodology projects.
• Expertise in Power BI, Power BI Pro, Power BI Mobile.
• Strong experience in MS SQL Server with Business Intelligence in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS).
• Experience with Azure Data Factory, Azure Data Bricks, Azure Synapse as we are in the process of going to Azure Cloud.
• Knowledge in all types of Database Migrations with most versions of SQL Server.
• Developed U-SQL scripts for processing massive amounts of data in a familiar environment which is mainly used for Azure Data Lake Analytics.
• Experienced in Data Extraction, Transformation and Loading (ETL) between Homogeneous and Heterogeneous Systems SSIS.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in SQL Server Integration Services (SSIS).
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).

TECHNICAL SKILLS

Databases: MS SQL Server 2016/2014/2012 , Oracle 10g/9i/8i, DB2

Cloud: AWS, Azure

Apache Spark: Spark dataframes, Spark Sql (Self learning)

Business Intelligence Tools: SQL Server Data Tools (SSDT), SQL Server Integration Services (SSIS), BIDS, SQL Server Reporting Server (SSRS)

Languages: C#.net, Asp.net T-SQL, PL/SQL

Applications: MS-Office, MS-Project

Operating Systems: MS DOS, Windows XP, 7,10

ETL Tools: Native Tools (SSDT, BIDS, DTS and SSIS Export/Import)

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

SQL/SSIS/SSRS Developer

Responsibilities:

• Involved in complete SDLC life cycle during requirement collection, analysis, design and development of BI solutions.
• Participated in all the agile planning, daily standup meetings and gave the updates.
• Used SSIS and T-SQL stored procedures to transfer data fromOLTP databases to staging areaand finally transfer into data warehouse.
• Created very complex SSIS Packages with considering all the best practices like error handling, logging, configurations, deployments, maintenance.
• Deployed SSIS packages to various environments like Dev, QA, UAT, PT and production using indirect XML and SQL server configurations.
• Involved in several ETL processes such data cleaning, data validation, data aggregation, data transformation and Data Loading.
• Used efficient optimization techniques to design ETL Scripts.
• Unit tested the developed ETL scripts, created test SQLs, and handled UAT issue
• Rolled out documentation for the ETL Process, Early Data Inventory, and Data Profiling
• Worked on ETL Design for developing optimized ETL scripts
• 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 C# 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
• Used various Data Flow Transformations, like Lookup, Derived Column, Data Conversion, Union All, Multicast and Copy Column while developing the packages.
• Scheduled and executed SSIS Packages using SQL Server Agent configuration in XML and used them to deploy packages into SQL server
• Created various SSRS Reports involving variety of features like Graphs, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters using MS SQL Server) as a source systems
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
• Extensively worked on OLAP cubes using SSAS.
• Created and Managed OLAP Cubes using SSAS
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Maintained the physical database by monitoring performance, integrity and optimized SQL queries for maximum efficiency using SQL Profiler.
• Monitored Scheduled jobs and alerts.
• Deployed the packages in the Production server and schedule the packages according to the requirements.

Environment: MS SQL Server 2016/2017, Team Foundation Server, Microsoft SharePoint Server, (SSIS) SQL Server Integration Services, (SSRS)SQL Server Reporting Services, Visual Studio 2013, Windows XP, T-SQL, Azure

Confidential, Phoenix, AZ

Database/BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Involved in creating SSIS packages for transforming data from warehouse to mart, to import data from source systems, or transfer data from one server to another.
• Developed, monitored and deployed SSIS packages.
• Designed SSIS packages to efficiently handle data from various external sources by using various Data Flow and Control Flow transformations like Derived Columns, Condition Split, Execute SQL Task, Data Flow Task, Bulk Insert, Send email and FTP Task etc. and loading the data at the desired location and in the desired form
• Created Time Dimensions on OLAP Cubes using SSAS.
• Created different Power BI reports utilizing the desktop and the online service and schedule refresh.
• Experienced in developing Power BI reports and dashboards from multiple data sources using data blending.
• Used various sources to pull data into Power BI such as SQL Server, oracle.
• Involved in installation of Power BI Report Server .
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Successfully migrated data between different heterogeneous sources such as flat file,
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

Environment: Microsoft SQL Server 2012/2014 Enterprise edition, T-SQL, SSIS, SSRS, SSAS, Microsoft Visual studio 2013.

Confidential, Charlotte, NC

Jr. SQL Developer

Responsibilities:

• Developed Advanced SQL queries and stored procedures to generate data reports. Dug into database details to ensure appropriate data filters, randomizations, and stratifications are applied based on business requirements.
• Have successfully delivered 40 data sample reports on time in all 2-month delivery cycles.
• Pulled data across multiple database servers (Oracle, DB2, SQL Server, Sybase, and Access etc.). Connected data sources by Business Intelligence tools (SSIS etc.), linked database objects (linked server, database link etc.), and inline queries (OPENDATASOURCE, OPENROWSET, OPENQUERY etc.).
• Built extract, transform, and load (ETL) process to migrate data from multiple types of data sources (SQL Server, DB2, Oracle, Sybase, Excel, Flat files, SharePoint, Email Boxes, etc.) to destination database server by using SSIS packages, VBA, and Export/ Import wizard.
• Prepared and updated documentations (Data Analysis Forms, Data Mapping File, Business Requirement
• Description, Procedure Documentations File, Population Files, Data validation form, etc.), to ensure all procedures and knowledge are traceable in future cycles.
• Presented excellent work attitude and communication skills with multiple teams/ departments.
• Analyzing different user requirements and coming up with specifications for the various database applications
• Developing database applications which are automated
• Planning and implementing capacity expansion in order to ensure that the company’s databases are scalable
• Identifying issues with the database and resolving them
• Installing and configuring the necessary components so as to ensure that the database is accessible
• Diagnosing and resolving database access and checking on performance issues.

Environment: SQLServer2008, SSIS, SSRS, SSAS, Power BI, Visual Studio 2008/2005, Team foundation Server, Tableau, MS SharePoint, C# .