Antoine Tchuente Fehem

ac28zt@r.postjobfree.com

Cell 717-***-****

PROFESSIONAL SUMMARY

Over 3 years of experience in IT as SQL Server Developer and strong work experience on

Business Intelligence tools.

Demonstrate professionalism, attention to details, collaborative nature and a quick learner. Strong communicator exhibited by working closely with users to identify and resolve problems. In addition to working well individually, an effective team player.

Strong analytical and problem-solving skills, Ability to work to deadlines, Results oriented Flexible, and Adaptable.

Experience in data migration between homogenous and heterogeneous system using Data Integration tools on various RDMS environment like - SQL Server 2012/2008/2005, and MS Access.

Experience in creating complex SSIS packages for ETL purposes using various transformations in SSIS 2012 and SSIS 2016. Also transformed data from various data sources to SQL Server using BCP and SQL.

Proven ability in defining Query for generating Drill down reports, Matrix reports, Chart reports and handling parameterized reports creating on demand and scheduled reports in SSRS 2012, SSRS 2016.

Experience in Performance Tuning and Optimization of queries and stored procedures.

Proficient in using SQL Profiler, Execution Plan and Performance Monitor. Skilled in performing Backups and Recovery, Replication, Security management, Jobs and working with Linked Servers.

Experience in Database Design and development of applications with Business Intelligence using SQL Server 2016/ 2012/2008/2005 (T-SQL), Integration Services (SSIS), Reporting Services 2005(SSRS).

Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop SQL Objects and maintain Stored Procedures and User defined functions.

Hands on experience in creating ETL packages using SQL Server Integration Services (SSIS 2005/2008/2012/2016).

Experience in migration of Data from various Data Sources such as Excel, Flat file, XML and SQL to MS SQL Server by using SQL Server Integration Services (SSIS) and DTS utility.

Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Drilldown / DrillThrough Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).

Proficiency in creating different types Parameterized Reports such as Cross-Tab, Drill-down, Drill-Through, Summary, Graph, Chart and formatting those using SSRS 2005/2008/2012/2016.

A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem-solving skills.

Excellent communication skills, analytical skills, understand business requirements in various domains.

Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Experienced in handling Slowly Changing Dimensions while loading data into data warehouse.

Experience in Building cubes using SSAS

EDUCATION & CERTIFICATION

Bachelor of Science, University of YAOUNDE (CAMEROON)

Certification SQL Server in few months but good work experience.

TECHNICAL SKILLS

Operating Systems Windows Server 2003/2003 R2/2008/2008 R2/2012/2016

Database Tools SQL Server Management Studio (SSMS), SQL Profiler, Query Analyzer, DTS Designer, Index Tuning Wizard, Data Modeling.

GUI Tools SQL Server Business Intelligence Development Studio, Visual Studio 2008R2/2010/2015

Languages T-SQL, PL-SQL, XML, VB Script, HTML

OLTP Tools SSIS-ETL

Source Control Tools Visual Source Safe 2015, Team Foundation Server 2010

PROFESSIONAL EXPERIENCE

UNFI (United Natural Foods Incorporated) York, PA

April 14/2016-Present

Junior Application Developer

United Natural Foods, Incorporated, also known as UNFI, is a distributor of natural and organic foods, specialty foods, and related products in the United States and Canada. The company distributes to grocery and natural food stores and is the primary distributor to Whole Foods Market. UNFI offers dry, refrigerated and frozen groceries, personal care products, supplements, fresh produce, perishables, and non-food items such as household cleaning products. It made the Fortune 500 list in 2016.

Worked with internal or external business partners.

Worked in an Agile (sprint and scrum) environment.

Translated business needs into technical code.

Generated database SQL scripts and deployed databases including installation and configuration.

Experience in economic and financial risk management platforms and advanced financial modeling.

Defining data dictionary & metadata management.

Experienced in documenting business, process and data flows.

Understanding of systems development life cycle including issue, risk and scope management.

Advanced SQL, Access, and Excel skills. High comfort level with consolidating and joining data using Left and Right Outer Joins, Inner joins, creating formulas.

Experience in Creating Tables, Views, CTE's, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.

Develop queries to retrieve and analyze data from multiple tables in the database. Find tables using Database diagrams in SQL server, establish relationship in multiple tables using Primary and Foreign keys.

Compiled data from multiple sources, which may include simple data mining and imports data into Spreadsheets/ Databases.

Centralized data collection by developing methods for database design and validation reports.

Presented monthly and quarterly projects and reports to management team utilizing MS-PowerPoint.

Deployed and configured the reports in the Report Server.

Involved in Migration of few objects from various Applications to Mach5 using Migration Wizard.

Create various Stored Procedures to validate the data from the source and update/insert the records into target tables

Wrote various T-SQL stored procedures and Triggers to carry out various tasks

Work closely with Report analysts and operation staff for support in problem resolution and root cause analysis

Environment: SQL Server 2012/2014(SSMS), SQL Server Business Intelligent Development Studio 2014(BIDS).

ES3.LLC (York, PA)

December 2014-March 2016

SQL Server – BI – Developer (SSIS, SSRS, SSAS)

ES3 was founded on the principle that there was a better way to deliver products. 18 years later, the industry agrees. We’ve used our head start to hone our innovative thinking and operational excellence, and to create further advancements, continuously improving our services. ES3 is more than a third-party logistics provider. We’re your partner in shortening the supply chain to make it faster, greener, and more collaborative, without adding cost. Together we collaborate, grow, and win to sustain success and prepare for the future.

Worked with internal or external business partners to recommend business intelligence solutions.

Worked in an Agile (sprint and scrum) environment.

Created database objects, complex queries and stored procedures to support the ETL process of loading data files received from clients.

Automated the ETL process from T-SQL queries to SSRS for dynamic reporting using SSIS.

ETL Development, Database design, data storage and management of data that can be used for analysis and presentation.

Designed efficient ETL processes using Microsoft SQL Server stored procedures & SQL Server Integration Services that imports Claims data from various sponsors.

Identified cause for ETL job failures and rectify the issues using Log in SSIS.

Optimized SSIS packages and stored procedures that improve the processing speed of large files.

Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).

Used various Transformations and Tasks in SSIS Dataflow, Control Flow to load and manipulate data.

Involved in ETL architecture enhancements to increase the performance using query optimizer. Implemented Event Handlers and Error Handling in SSIS packages.

Implemented Slowly Change Dimensions in SSIS to update data.

Built dimensional and Fact tables in SSMS.

Troubleshooting ODBC and OLEDB connection issues in SSIS packages.

Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task, Merge and Merge join, Union All, Lookup, and Send Mail task etc.

Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

Carried out edit checks to edit data based on certain conditions like filtering records with nulls, bad/incomplete SSN, incomplete phone numbers and zip codes.

Utilized SSRS Reports from different source formats and satisfying clients by representing reports and presentations.

Produced parameter driven, matrix, sub-reports and integrated report hyperlink functionality to access external applications.

Generated matrix reports, tabular, drill-down, drill-through, sub reports, chart reports, multi parameterized reports.

Developed parameterized dashboards and reports with SQL Server Reporting Services (SSRS).

Administrated and scheduled mailing subscriptions on SSRS reporting server.

Build Multi-Dimensional Cube with KPI (Key Performance Indicator).

Generated OLAP Cube for Analyst propose.

Understanding of systems development life cycle including issue, risk and scope management.

Experienced in documenting business, process and data flows.

Relational database experience.

Environment: SQL Server 2012/2014/2016 (SSMS), SQL Server Business Intelligent Development Studio 2008R2/2012/2016(BIDS), MS Excel 2016.

Contact this candidate