SUMMARY

• Microsoft Certified Professional as certification in Microsoft Technology Associate (MTA) in MS SQL Server 2008.
• Overall 8+ years of experience years of IT, in the use and development, design, support and migrate of Microsoft SQL Server 2012/2016/2019 and SQL Server Business Intelligence tools (SSIS/SSRS/SSAS).
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server-based applications).
• Extensive experience as SQL Server Developer in utilizing triggers, cursors, functions and stored procedures.
• Strong technical knowledge in T-SQL including ETL, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Expertise in Database development for OLTP (Batch Processing, Online Processing), OLAP, ETL, Data warehousing, Data mining, DBMS and Data Modeling.
• Experience in creating fact and dimensional model in MS SQL server and Snowflake Database utilizing Cloud base Matillion ETL tool.
• Experience in Query tuning and performance-tuning using Clustered and Non-Clustered indexes on tables for faster query retrieval.
• Extensively worked on Normalized and de-normalized database design and RDBMS concepts to design Relational Database model as per Business requirement.
• Experience in developing Dashboard, Parameterized Reports, linked reports, Sub reports, Create complex Reports (ex: drill down reports using different objects), drill through reports using SSRS.
• Experience in Migrating databases from SQL 2008 R2 to SQL 2014 and Extraction & Migration of Data from heterogeneous data sources like MS Access, Teradata, and DB2 etc. to MS SQL Server and Snowflake database.
• High experience/comfort level interpreting ETL Data Mapping documents, transformation logic, reusable logic, etc.
• Ability to comprehend PHI and HIPPA compliance requirements and formulate solutions in a deadline-oriented setting.
• Excellent track record as a team player with TEMPeffective communication skills.
• Strong writing and documentation skills for the management and development.

TECHNICAL SKILLS

Databases: SQL Server 2019/2016/2012 , Teradata, Oracle 9i/10g, DB2 8.0.1, Snowflake Database, Databricks

Languages: SQL, T - SQL, PL/SQL, MySQL

SQL Server Tools: SQL Management Studio, Business Intelligence Development Studio, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, AWS

Operating Systems: Windows Server 2010/2008, UNIX, Linux

ETL: SSIS, DTS, BCP, Import/Export Wizard, BI Visual Studio, Matillion ETL

Data Modeling: Erwin Data modeler, ER Studio, MS Visio

Reporting Tools: SSRS, Crystal Reports Report Builder, VBA, Tableau and PowerBI

PROFESSIONAL EXPERIENCE

Confidential, Madison, WI

Data Engineer II

Responsibilities:

• Install and configured SQL Server 2014/2019, Visual Studio 2019 and configure Matillion ETL
• Create SSIS ETL packages in 2008R2/2019 to import data from SQL Databases to Snowflake Database
• Used different AWS Data Migration Services and Schema Conversion Tool along with Matillion ETL tool
• Design developed and maintained MS SQL Server 2008 and SQL Server 2019 environment.
• Work Together with other DWH Architect in assessing snowflake face and dimensional data modeling and applications.
• Performance testing of new environment and adjusting based on reporting, replication and ETL load
• Conversion of Tableau Reports where needed and Co-ordinate for Infrastructure and data base build up
• Defining user stories and driving the Agile board in JIRA during project execution, participate in sprint demo and retrospective
• Create and developed data load and scheduler process for ETL jobs using Matillion ETL package
• Build healthcare Tableau dashboard reports and support Tableau team with SQL queries.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Familiarity in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server
• Maintain code commit and score control using TFS and Google Code Commit
• Data analysis and data migration by transferring them using SSIS packages and later loafing the data into AWS Cloud Servers
• Reviewing the explain plan for the SQLs in Redshift and heavily involve in testing Snowflake data to understand best possible way to use the cloud resources
• Maintain Databases for development, testing and production environments and loaded scripts into google code commit
• Evaluate and select data warehousing tools for business intelligence, data population, data management, metadata management, and warehouse administration
• Make Use of AWS S3 buckets to extract raw data files to inject into Snowflake staging tables.
• Utilize Matillion and AWS Redshift for DW enactment of Epic Data Warehousing concept in Snowflake database
• Maintain excellent interpersonal and interaction skills with cross team and business users
• Establish bridge between users and customers with converting raw data to meaningful healthcare information

Environment: SQL Server 2008R2/2016/2019, Tableau SSIS, Query Analyzer, Database Engine tuning wizard, SQL Profiler, Redshift, AWS, Databricks,Snowflake Database, Matillion ETL, Jira, Confluence, Alation

Confidential, Madison, WI

Data Engineer me

Responsibilities:

• Installed and configured SQL Server 2008R2/2014/2016
• Created SSIS ETL packages in 2008R2/2016 to import data from SQL Databases and flat files to MS SQL Database
• Designed, developed and maintained MS SQL Server 2008 and SQL Server 2017 environment.
• Collaborated with other DWH Architect in evaluating data modeling and applications.
• Ensured accuracy of data by defining and building necessary audits and controls.
• Designed and developed data load and ETL jobs using SSIS package scheduled in SQL Job Agent.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in Performance Tuning and Query Optimization.
• Experienced in using ETL tools in (SSIS) MS SQL 2008, MS SQL 2005 and DTS in MS SQL 2000
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Data Loading Experience in SQL Server 2008 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
• Data analysis and data migration by transferring them using SSIS packages and later loafing the data into AWS Cloud Servers
• Use Business Intelligence (BI) tools for conversion, migration and relocation of complex data and data files from Oracle/Teradata Database System to MS SQL Server
• Create ETL (SSIS) packages to develop jobs to extract, transform and loading data into data warehouse
• Practice Reporting tools like SSRS and PowerBI to convert data into meaningful information
• Day to day Profile database structure to identify the size, structure, and data types, etc. in MS SQL Server
• Provide test driven data design to enhance the data quality and play crucial role in data management requirement
• Maintained Databases for development, testing and production environments and loaded scripts into TFS.
• Analyze user requirements, functional and technical specifications, preparing test plans.
• Deliver and communicate HealthCare Database maintenance plans with DBAs and Data operation teams

Environment: SQL Server 2008R2/2014/2016, SSIS, SSRS, Query Analyzer, Database Engine tuning wizard, SQL Profiler, Redshift, AWS. Tableau, Jira

Confidential, Denver, CO

MS SQL Server / BI Developer

Responsibilities:

• Installed SQL Server 2008R2/2012/2014, DB2 and Teradata 10 and Configured OLEDB, Attunity Teradata, ODBC and Oracle drivers.
• Created ETL packages in 2008R2/2010 to import data from Teradata, DB2, Oracle, MS Access and flat files to SQL Database
• Used various control flow tasks like FTP, BCP, Bulk insert task, Transfer job task, Send Email Task etc. and different data flow tasks.
• Practiced SSIS script task, Exemplify, Look up transformations and data flow tasks using T- SQL.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Designed and developed data load and ETL jobs using SSIS package scheduled in SQL Job Agent.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Created complex stored procedures, Triggers and user defined functions using joins and cursors to facilitate efficient data manipulation and data consistency.
• Involved in Database Migration from SQL Server 20082 to SQL Server 2014.
• Migration of Databases Using Generate Script Wizard and PowerShell
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Converted Teradata Data Query into Oracle SQL Query for SSIS Packages and converted SAS ETL into SSIS packages
• Support product teams with the complex SQL Query design, development and implementation of automated reporting and using Tableau dashboards
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Maintained Databases for development, testing and production environments and loaded scripts into SVN.
• Analyze user requirements, functional and technical specifications, preparing test plans.
• Deliver and communicate HealthCare Database maintenance plans with DBAs, BI teams and Kaiser Administration personnel.

Environment: SQL Server 2008R2/2012/2014, Teradata 13.0,Oracle 10g, Tableau 10.5, PowerBI, DB2 8.0.1, SAS, SSIS,SSRS, MS Access, Query Analyzer, Database Engine tuning wizard, SQL Profiler, Jira

Confidential, Ann Arbor, MI

MS SQL Server Developer

Responsibilities:

• Performed Server installation and configuration using SQL Server 2008R2/2012/2014
• Written SSIS packages in 2008R2/2010 to pull data from SQL Server and exported to various data sources like Flat File, MS Access, Oracle etc. and vice versa.
• Created complex stored procedures, Triggers and user defined functions using joins and cursors as required for SSIS packages.
• Expertise in Database creation (DDL, DML, DCL), Query tuning and performance tuning.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Created SSIS packages to import data from MS Access, Excel to SQL 2008 R2.
• Manage and build the departmental Report distribution system and automated report creation
• Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
• Built different types of chart reports using Crystal Reports for the business requirement like column chart, Pie Charts.
• Proficiently created Reports based on the requirements using SSRS 2008/2012.
• Proficiently scheduled the Subscription Reports with the Subscription Report wizard.
• Excelled in deployment and generation of Reports.
• Automatic Scheduling reports from crystal reports to Crystal Report Scheduler (CRD).
• Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Generated Report Models using Model Designer, to enable the business users to build ad-hoc reports using Report Builder.
• Involved in designing reports and delivering them by any of the delivery methods like standard subscriptions, data-driven subscription, URL access etc.
• Coordinated with DBAs and other BI teams concerning HealthCare Relational Database management.

Environment: SQL Server 2008 R2/2012, SSIS, SSRS, Query Analyzer, Database Engine tuning wizard, MS Access, MS Excel, Crystal Report 8, Windows Server 2008R2/2012

Confidential, LA

HR Data Analyst/Graduate Assistant (Internship)

Responsibilities:

• Installed and Configured MS Access and SQL Server 2005/2008 successfully.
• Learn HR database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Created and maintained Databases for development, testing and production environments.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Analyzed Data using MS-SQL, My SQL tool to build Reports and Form formats using Microsoft tools
• Assisted with assembling HR Data for superior and paradigm Reports in obligatory Report format
• Facilitated in payroll department in functioning of HR related technique for New hiring process
• Abet students in Business Department and Library’s Computer laboratory
• Collected and analyzed data from research by condensing numerous data into specific reports
• Counseled library in implementing Dewey Decimal System utilizing university Database

Environment: SQL Server 2005/2008, Query Analyzer, MS Access, MS Excel, Windows Server 2008R2/2012