SUMMARY

• 7 + years of strong IT experience in SQL Server 2019/2017/2016/2014/2012/2008 R2/2008 development & support;
• Strong Experience in Microsoft (MSBI) Business Intelligence, ETL Data Warehouse, OLTP & OLAP using SQL Server Integration Services (SSIS), Reporting & Analysis Services (SSRS & SSAS) and MS SQL Server (2008,2012,2014,2016,2017,2019).
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Clustering, T - SQL, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Extensive Experience in RDBMS concepts such as creating databases and various SQL server objects like schemas, tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE (common table expression), Table Variables and Stored Procedures.
• Developed physical data models, created DDL (Data Definition Language) scripts and DML (Data Manipulation language) scripts to manipulate the SQL Database.
• Good understanding of Normalization /De-normalization and database design methodology;
• Experience in data analysis SQL server database development and maintenance, data modeling that support day to day business operations and auditing of database for user transactions, login and database action and removing orphan users.
• Involved in Backups, Query optimization, Disaster recovery methods, High availability methods, creating Emails, jobs, alerts and in performance tuning, used SQL profiler.
• Experience in data migration (using tools like Bulk Insert, DTEXEC, and DTEXECUI) between different homogeneous/heterogeneous systems and SQL Server. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Involved in the development of scripts for loading the data into the tables in Enterprise Data Warehouse EDW and to load the data from source to staging and staging area to target tables using Fast Load, Multi Load.
• Having experience with SQL Server Database Replication
• Creating SSIS solutions for ETL and Business Intelligence process for Data Integration and Migration Services.
• Extensive Experience in ETL Data Warehouse Ralph Kimball Methodologies for supporting Data Extraction, Transformation and Loading processing using MSSQL Server Integration Services (SSIS) and Loaded process from Heterogeneous / Homogeneous Data Sources, performed Data Verification, Data Cleansing, Data Integration, Data Import & Export.
• Expert in merging Data from various complex Data sources, Populating Dimension and Fact tables in Data warehouses, Cleaning and Standardizing the data loaded into OLTP and OLAP databases using SSIS.
• Applied various Transformations such as Lookup, Fuzzy Lookup, Merge, Merge Join, Conditional split, Multicast, Derived column, Cache, Slowly Changing Dimension (SCD Type1, Type2, and Type3).
• Extensive Experience in Error handling and debugging coding issues and troubleshoot production problems;
• Expert in Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages;
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, Job Scheduling and SSIS Package Designer;
• Transformed data from one server to another using Conversion, Audit, Derived Columns, Lookups, Merge, Merge Joins, Slowly Changing Dimension;
• Construct daily ETL process using OPENQUERY Oracle database into Staging database using TSQL;
• Experience in creating ETL process, Data warehousing, Operations Data Store concepts, data marts and OLAP technologies, Including Star and Snowflake schema;
• Experience in design and implement processes for deploying, managing and extracting data for reporting using SQL Reporting Services SSRS.
• Experience in creating Report models for Adhoc reports, Drill Down, Drill Through, Parameterized, Cascading, Conditional, Table (List), Matrix (Crosstab), Charts, Sub-Reports, Indicators, Bar Graphs & Line Graphs, Dashboards, Ad-hoc and Crystal Reports using SSRS 2019/2017/2016/2014/2012.
• Created subscriptions to provide a daily basis report;
• Experience in Advanced Excel like Power View, Power BI, Power Pivot and Excel Data Connection
• Creating and changing the data visualizations in Power BI reports and Dashboards on client requests;
• Import data from different data source to create Power BI reports and dashboards;
• Involved in creating dynamic well-organized, accurate and insightful Power BI reports/dashboards to support strategic decisions;
• Experience pushing and pulling data from Azure blob;
• Experience in developing and deploying back end services to Azure clouds.
• Migrated on-premise SQL Server schemas to the cloud on Azure SQL Server DB and Azure VM and developed and maintained databases across both on-premise and cloud deployments.
• Hands on experience in creating Star Schemas and Snowflake Schemas
• Experience in defining data warehouse (star and snowflake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services. SSAS (Tabular and multidimensional modes);
• Having huge experience to use C#, visual basic.Net for script tasks and script components with variables in SSIS;
• Having a good experience using Git, GitHub, TFS, Devops for version control and source control;
• Having experience developing and implementing ETL solutions using Big Query;
• Experience with data modeling for OLTP and multi-dimensional databases using tools such as Erwin;
• Data Modeler with strong Conceptual, Logical and Physical Data Modeling skills, has experience with JAD sessions for requirements gathering, creating data mapping documents and queries
• Performed application level DBA activities creating tables, indexes and monitored and tuned Teradata BETQ scripts using Teradata Visual utility.
• Experience working with Teradata parallel transporter, Fast Load, Multi load, SQL Assistant, DDL and DML commands.
• Experience with Azure Data Factory to migrate from on premises into cloud
• Excellent communication, analytical, interpersonal, presentation, project management skills and ability to work with minimum supervision in large and small teams;
• Azure Data Factory(ADF),Integration Run Time(IR),File System Data Ingestion, Relational Data Ingestion
• Migration of on premise data (SQL Server/ MongoDB) to Azure Data Lake Store(ADLS) using Azure Data Factory(ADF V1/V2)

TECHNICAL SKILLS

OS: Windows XP/7/10, Windows Server 2016/12/08, UNIX/LINUX

Databases: SQL Server 2017/16/14/12 /08 R2, Oracle 11g/8.0i, MS Access 2000/8.0

Languages: T-SQL, PL/SQL, MDX, DAX, C#, VB.NET, XML, ASP.NET, .NET Framework, C#

Web Tools: C#.Net, ASP.Net, VB.Net, Visual Studio.Net, XHTML5, JavaScript, VB Script

ETL & Reporting: SSDT 2017/16/14/12 , BIDS 2008R2/08, SQL Server Integration Services (SSIS 2017/16/ 2014/2012/2008 R2), SQL Server Reporting Services (SSRS 2016/2014/2012 /2008 R2), Power BI, SQL Server Analysis Services (SSAS)

Others: MS Office, Crystal Reports XI, Visio, SQL Server Notification Services, Visual web developer, MS FrontPage, Windows Scripting Host, Erwin Data Modeler, MS Visual, SAS/Access, Crystal Reports SAP Business Objects, Micro Strategy, ER-Studio, Microsoft TFS, Microsoft GIT, MS VSS, HP Quality Center & Jira, TFS

PROFESSIONAL EXPERIENCE

Confidential

Lead SSIS/SSRS Developer

Responsibilities:

• Developed T-SQL Scripts to validate the data after the loading process. Modified and tested T-SQL stored procedures
• Written complex SQLs using joins, sub queries and correlated sub queries. Expertise in SQL Queries for cross verification of data.
• Transformer, Lookup, Merge, Join, Aggregator, Sort, Filter and Remove duplicates stages were extensively used to Cleanse/Transform the data extracted into staging.
• Modified and tested T-SQL stored procedures.
• Worked with subject matter experts to prepare source to target mapping document for the migration project.
• Developed data warehouse process models, including sourcing, loading, transformation, and extraction of source data.
• Used SSIS and extract transform loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application; Making changes to existing ETLs and building some new ETL processes.
• Using C#, visual basic.Net in SSIS script tasks and script components with variables
• Created packages using the various control flow tasks such as Data Flow Task, Execute SQL Task, Execute Package Task, File System Task.
• Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files.
• Create log file using like providers like XML, text file, SQL server.
• Experience work with cloud systems (Azure): pushing and pulling data from azure blob
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Developed/Deployed SSIS packages through package installation wizard, Bids Deployment, Management Studio Import to further automate data processes.
• Data Automation Using SSIS to automate data processes for input of information.
• Proficient in developing parameterized reports, chart, graphs, linked reports, drill-down reports using SSRS/Power BI;
• Involved in creating dynamic well-organized, accurate and insightful Power BI reports/dashboards to support strategic decisions.
• Created Parameterized, Crosstab, Drill Down and Summary reports by Using SSRS and created report snapshots to improve the performance of SSRS.
• Azure Data Factory (ADF), Integration Run Time (IR), File System Data Ingestion, Relational Data Ingestion
• Migration of on premise data (SQL Server/ MongoDB) to Azure Data Lake Store( ADLS) using Azure Data Factory(ADF V1/V2)

Confidential, Chicago, IL

(SQL\SSIS\SSRS\Power BI) Developer

Responsibilities:

• Worked with Business Users and Business analyst in gathering requirements and preparing the functional and technical documentation.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Temporary tables, table variables in Stored procedures to simply complex queries
• Optimized queries by analyzing different query options and indexing strategies.
• Developed T-SQL Scripts to validate the data after the loading process. Modified and tested T-SQL stored procedures
• Written complex SQLs using joins, sub queries and correlated sub queries. Expertise in SQL Queries for cross verification of data.
• Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the import and export of data using SSIS.
• Created ETL packages that reads Product, Vendor, and Order data from an FTP server into a SQL Server database. The solution also validated incoming Data and performs notifications when jobs complete.
• Created SSIS packages to load data from Heterogeneous sources like Flat files, CSV files and Excel.
• Implemented custom logging to keep track of the packages being run automatically. Configured the packages to run on different servers using Package Configurations.
• Created packages in SSIS with error handling using Event handlers.
• Used various transformations in SSIS like Lookup, Derived Column, Union all, Merge to modify the data which is stored in various forms efficiently.
• Using C#, visual basic.Net in SSIS script tasks and script components with variables
• Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files and scheduled SSIS packages using SQL Server Agent, Jams.
• Created SSIS packages to clean and load data to data warehouse.
• Created SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.
• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, 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 Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Individually authored, installed, deployed and managed reports using SSRS 2017.
• Generated drill through, drill down which projected data as per the user requirements using SSRS.
• Implemented Conditional formatting using Expressions in SSRS 2017.
• Created Parameterized reports using Text and Stored procedures as source in SSRS 2017.
• Deployed SSRS reports to share point server and used Excel services in Share point application.
• Managed subscriptions and data-driven report subscriptions to provide timely reports to the clients and end users, also created snapshots to reduce loading time.
• Converted more than 200 Tableau Maintenance, Finance, Lease reports to SSRS to support business user requirements.
• Created Power BI Visualizations and Dashboards as per the requirements.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Power BI.

Confidential, Houston, Texas

SQL/SSIS/SSRS Developer

Responsibilities:

• Run SQL Server SSIS packages to load and transform to the SQL Server data warehouse.
• Create SSIS packages for various migration project and provide step-by-step instructions for vendors how to run in and generated files from their Database
• Create Access DB templates to search data files for customers as needed, create SQL scripts to load users into an Oracle DB by querying the data warehouse for data.
• Multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Performed SSIS Development and support, developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File, and DB2 into the central OLTP database.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL codes and SQL joins for SSIS packages and SSRS reports.
• Extract, Transform and Load data from databases of systems like CRM, ERP and SharePoint
• Implemented various tasks and transformations for data cleansing and performance tuning of SSIS packages.
• Extracted and Loaded SharePoint Lists and Surveys Data into SQL Server Database with SSIS
• Collaborated on multiple projects using GITHUB.
• Worked extensively on system analysis, design, development, testing and implementation of projects.
• Extended SSIS Capabilities by Creating Custom SSIS Components for SharePoint.
• Configured SSIS packages with XML configuration file, Environment variable, Registry entry, Parent package variable and SQL Server table.
• Created SSRS and PowerBI reports sourcing from SSAS’s Multidimensional OLAP and Tabular model cubes with MDX and DAX.

Confidential, San Francisco, CA

SQL/SSIS developer

Responsibilities:

• Involved in database development and creating SQL scripts. Also experience writing complex T-SQL queries to support needs from business.
• Worked closely with customers and IT management and staff to provide application development and production support.
• Responsible for Data Migration of health insurance (Action) from Oracle to SQL server 2012 using SSIS via Microsoft management studio 2012 and writing some reports using Microsoft SQL server business intelligence studio.
• Defined High Level Data Architecture for ETL & BI Solutions & Framework Design, Prototyping, ETL Loading Strategy Definition, Data stage, Data Governance & RDBMS standards definition and enforcement, Definition of Data Stage Best Practices & Coding Standards.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Analyzing SQL data, identifying issues, and modifying the SQL scripts to fix the issues.
• Creating data models to improve efficiency and outputs and to reducing data redundancy
• Monitor applications and make sure they are accepted.
• Tuned and Optimized SQL Queries using execution plan and profiler.
• Used T-SQL to run daily tasks and provide daily report to business and IT at the end of each day.
• Experience in business process analysis, data modeling and ability to proactively identify, manage, and correct data quality issues.
• Experience gathering business requirements to perform data analysis, data extraction/delivery, source/target mappings and reporting
• Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.
• Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports.
• Created Parameterized, Cross-Tab, Drill Down and Summary reports by Using SSRS and created report snapshots to improve the performance of SSRS.