Data warehouse Developer

ISAAC DAVID, SQL Server SSIS/SSRS Developer

Mobile: 214-***-**** Email: *************@*****.*** Residence: Plano, Texas CAREER PROFILE: Innovative, competent and results driven IT professional offering advanced understanding of software development cycle (SDLC) including requirement gathering, data analysis, design, development, implementation, and testing and deployment coupled with 2+ years of experience as a Microsoft Business Intelligence Developer. Recognized throughout career for demonstrating the ability to organize and complete complex projects, delegate assignments to staff as well as meet deadlines in high-volume workload environments. Vastly adept at building strong relationships and implementing strategies to improve processes and drive overall performance. My overall goal is to expand my career brand by obtaining a position as a Data Warehouse Developer, ETL Developer, Data Engineer or Data Analyst where my expertise can be utilized to bring value. CORE COMPETENCIES AND SKILLS

PROFESSIONAL EXPERIENCE

Novedea Systems Inc Plano, Texas

SQL Server SSIS/SSRS Developer September 2019 to Present

Achieves goals by designing and developing the staging databases as well as loads data from heterogeneous sources to staging and from staging to the target tables applying different transformations in-between.

Held accountable for designing SSIS packages using several transformations to perform data profiling, data cleansing and data transformation.

Analyzes the data to implement incremental/delta load using a merge statement.

Extracts data from various source files like Excel, XML, and Flat files and loaded the data to a SQL Server DB target table.

Utilizes SSIS transformations such as lookup, derived column, data conversions, conditional split, SQL task, script task, send mail task etc.

Orchestrates process to create parameterized reports, drill down, and drill through reports using SSRS.

Held accountable for creating dashboards, Tabular, Matrix reports (crosstab or pivot), Charts and graphs as per customer requirement using SSRS.

Rendered report in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and manage subscription.

SQL Server SSIS - ETL Developer August 2018 to September 2019

Achieved goals by actively working on all processes related to the development, implementation, administration, and support of the SSIS ETL.

Held accountable for being involved in business analysis and technical design sessions with business and technical staff to develop requirements document and ETL design specifications.

Successfully wrote various technical documents, including Business Requirements, Functional and Technical Specifications, Data Flow and Process diagrams.

Used SSIS to create ETL packages to validate, extract, transform and load data to the data warehouse database from various sources like Text Files, XML, Excel, and Access DB.

Created complex SSIS packages with error handling capabilities using various data flow task transformations (conditional split, data conversion, look up, merge), tasks (execute SQL, data flow, script, send mail tasks) and containers (sequence container, for loop, for each loop container) etc.

Analyzed the data to implement incremental load using merge statement and overseen the migration of large amounts of data from OLTP to OLAP using SSIS ETL tool.

ID

AREAS OF EXPERTISE

Program Testing Software

Database Management Software

Programming Languages

Operations Management

Strategic Planning/Execution

Resource Utilization

Performance Measurement

Process Improvement Initiative

Staff Training and Development

Operating Systems

Data Entry and Analysis

Technical Research and Analysis

Troubleshooting: Software and

Hardware Issues

Strong Decision Making Abilities

Collaborative Teamwork

Emotional Intelligence

Business Intelligence

Time Management

Analytical and Critical Thinking

Exceptional Communication Skills

Accountability

Analytical and Critical Thinking

High Attention to Detail

Obello Solutions Plano, Texas

Data Engineer Intern December 2017 to July 2018

Achieved goals as a Data Engineer Intern by overseeing database development as well as gathering, specification and data mapping document for development of SSIS ETL projects.

Implemented process to configure SQL DB mail to send automatic e-mails when SSIS packages fail or succeeded.

Held accountable for performing efficient tuning of SQL source for data load as well as utilizing stored procedure for improved query performance as necessary.

Served as a collaborative team member within both project management and software development life cycles (SDLC) including analysis of business functions, testing and documentation as required by end-users.

Utilized SSIS to create ETL packages (.dtsx files) that validated, extracted, transformed and loaded data to data warehouse database and processed SSAS cubes that stored the data in aggregated format for analysis.

Recognized for designing a parameter driven report utilizing Microsoft T-SQL and SSRS as well as communicated project status with management.

Demonstrated core leadership abilities by assisting team in redesigning the existing reporting process to develop and distribute financial reports to top management and various stakeholders more efficiently. TECHNICAL SKILLS

T-SQL:

Recognized for efficiency in creating SQL Server database objects such as tables, stored procedures, indexes, views, constraints, user defined functions etc.

Demonstrates a solid understanding referential integrity between primary and foreign keys and applies extensive knowledge in SQL query optimization and performance tuning tools like SQL profiler, Data base engine tuning advisor. SSIS:

Demonstrates extensive skill in using SQL Server Data Tools (SSDT) to create SSIS ETL solutions.

Skilled in SSIS ETL migration from different sources such as files (Flat file, XML, Excel etc.) and databases (Oracle, SQL Server, MySQL etc.) to a target file or database destination.

Extensive experience in Error handling, precedent constraints, break point and check points.

Great understanding of the data warehousing concept (OLTP and OLAP respectively) using dimension model. SSRS:

Extensive experience in creating various SSRS report using visual studio (SSDT), troubleshooting slow running reports, creating table and matrix reports as well as report dashboards.

Recognized for being highly skilled in creating drill down and drill through reports, parameterized and sub reports as well as ability to deploy reports to the report server and give security permission to the end users. SSAS:

Experienced in logical and physical dimensional modeling, ER modeling, star / snowflake schemas, fact and dimensional tables and operational data store (ODS).

Developed multi-dimensional objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS). EDUCATION, CERTIFICATIONS AND TRAINING

Computer Science Associate degree; Dallas College Richland Campus

Querying Data with T-Sql (70-761); Microsoft Certified Technology Specialist

Certified SQL BI/EDW Developer; Colaberry School of Data Science & Analytics – Plano, Texas

AWS Cloud Practitioner

Contact this candidate