We provide IT Staff Augmentation Services!

Data Engineer Ii Resume

Madison, WI

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

Hire Now