Resume

Sign in

Data Developer

Location:
Arlington County, VA
Salary:
120.000
Posted:
January 08, 2020

Contact this candidate

Resume:

OBJECTIVE

SQL/ETL/SSIS Developer with over * years of experience in implementing database development and data management solutions in Microsoft SQL server, writing complex queries to develop database objects, developing and maintaining ETL frameworks, data modeling, developing data warehouse, database design, dynamic reporting platforms, business intelligence applications and solutions, data management and analysis. Looking for dynamic working environment and competent firm, where I can contribute and further advance professionally.

PROFESSIONAL SUMMARY

Over 5 years of experience in developing BI applications utilizing SQL server, BI stack, ETL Power BI SSIS.

Manage end-to-end change implementation planning including project management, issue management, and communications

Develop test plans and protocols for evaluation of system performance

Capacity to work with business units in analyzing business processes and recommending new ideas and/or efficiency opportunities

Develop user acceptance test scenarios, test scripts and results to validate configuration of the PDM system

Performs well under pressure; shows diplomacy, tact and good judgment when conflict arises

Collaborate with other IT and functional area personnel on routine and major system upgrades activity

Support internal and external audits

Developed parameterized reports which were used for making current and future business decisions.

Developed Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports and Matrix reports using SSRS.

Created reports that projected business goals for future.

Used table variables and Common Table Expressions (CTEs).

Worked closely with the offshore team in finding solutions to arising problems.

Identify the associated Store Procedures and parameters used for the reports.

Involved in job scheduling and alerts.

Database: MS SQL Server, MS Access, Oracle, DB2, PostgreSQL SQL Server 2012, T-SQL, SSMS, Excel, SSIS, SSAS, SSRS, SharePoint, Power BI, Tableau, TFS, DTA, SQL Profiler, MS Azure, Data Factory, Visual Studio, C#.

Programming Languages: T-SQL, PL/SQL, C, HTML, DHTML, XML, VB.NET, C#.Net

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Service (DTS), Tableau

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports, Report Studio, Report builder.

Database Tools: SQL Server Management Studio, Oracle SQL Developer

SQL Server Tools: SQL Server Business Intelligence Development studio, Enterprise Manager, SQL Profiler, Query Analyzer, Import & Export (DTS), SSAS

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP &OLTP, Adobe Photoshop, Abode Flash, Hyper-V Manager

PROFESSIONAL EXPERIENCE

SQL SQL/ETL/SSIS /Developer

Home Depot, Arlington Virginia December 2016 ā€“ present

Responsibilities:

Developed complex database objects like complex stored procedures and complex UDFs

Created database objects like tables, views, indexes and triggers in MS SQL Server that support relational and dimensional database models.

Developed script for data manipulation and ensuring data integrity.

Developed complex SQL queries, and performed optimization of databases and tuning of long running SQL Queries by using SQL Server Profiler and SQL Tuning Advisor.

Designed, developed and maintained a data warehouse

Involved in requirements gathering, logical and physical data modeling, developing fact and dimension tables, configuring ETL work flows to populate fact and dimension tables, and developed Cubes and reports for analysis.

Developed and automated SSIS packages to perform Extraction, Transformation and Loading (ETL) of data from various sources like Flat file, MS Excel, CSV, MS Access to SQL Server.

Created SSIS Packages by using advance transformations (i.e. Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate) and used Custom components such as Audit on Pre-Execute, Audit on Post-Execute and Statistics Logging Component.

Created Dynamic SSIS packages using complex expressions, variables and control flow components such as for each Loop Container to loop over a Directory to load inbound files coming daily.

Prepared the Migration document showing the paths for input and output files, configuration files, table scripts, stored procedures and SSIS packages.

Tested, Cleaned and Standardized Data to meet the business standards using Fuzzy lookup and Exact lookups and String manipulations.

Enforced the Business Rules to filter bad data from the system by using Complex T- SQL Statements, and implemented various Constraints and Triggers for Data Consistency.

Responsible for creating the reports based on the requirements using SSRS.

Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS).

SQL SQL/ETL/SSIS Developer

Pride Consulting Group, Alexandra VA 22304 June 2015 ā€“ October 2016

Responsibilities:

Planned and designed data collection and survey tools and performed data analysis.

Created and tuned database objects such as tables, stored procedures, triggers, views, indexes and joins in MS SQL server to support relational and dimensional databases.

Developed SSIS packages to Extract, Transform and Load (ETL) data from different sources into database; and to transfer data from various sources including MS Excel, MS Access, and Flat Files to SQL database.

Scheduled SQL Server jobs to load data periodically using SQL Server Agent.

Created ad-hoc reports and complex enterprise reports such as drilldown, drill through, parameterized and cascading reports using SQL Server Reporting Services.

Designed and created report templates, plots, bar graphs and pie charts; and scheduled periodical reports to run automatically.

Writing T-SQL queries and stored procedures, creating various database objects as well as optimizing T-SQL code for faster performance.

Query Optimization and Performance Tuning by analyzing execution plans, handling Index fragmentation and using SQL profiler and Database Tuning Advisor (DTA) tools.

Loaded data to the interface tables from multiple data sources using OLEDB, ODBC, ADO.NET connections.

Migrated SSIS packages from development and QA servers to production environments using SSIS XML configuration files, environmental variables, and deployment wizards.

Created report crucial stored procedures and functions to support reporting dataset manipulation.

Created Solution Architecture based upon Microsoft Azure PaaS Services

Designed solution for various system components using Microsoft Azure.

Developed T-SQL stored procedures, functions and views to implement the business logic for front end applications, reports as well as ETL processes.

Wrote custom T-SQL stored procedures and scripts to provide application functionality and tuned them by creating indexes and ensuring optimized query design.

Designed SSIS Packages to transfer data between servers, load data into database from various heterogeneous sources like SQL Server, Excel and CSV and archive data files.

Junior SQL/ETL/SSIS Developer,

Trade path plc Aramex International Zimbabwe RDS, Addis Ababa April 2014 ā€“ may 2015

Responsibilities:

Involved in complete Software Development Lifecycle (SDLC).

Created Database Objects like Tables, Stored Procedures, Views, Triggers

Created complex SQL stored procedures, Triggers, Functions, Views, Indexes

Used both System and User-Defined functions to enhance the functionality of my T-SQL code

Developed Dynamic SQL for user customizable queries to be answered by the SQL Server

Designed and deployed reports in MS SQL Server environment using SSRS report services configuration manager.

Developed T-SQL stored procedures, functions and views to implement the business logic for front end applications, reports as well as ETL processes.

Developed interactive and static reports, sub reports, drill through, drill-down reports using various features like Matrix, Table, Charts, Graphs and Dashboard.

Follow and contribute to database best practices.

EDUCATION

Bachelor degree Sā€™T Merry University Colleague,

Addis Ababa, Ethiopia



Contact this candidate