| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
Washington, DC || (Street Address ) - 515- 3656 || EMAIL AVAILABLE || https://LINKEDIN LINK AVAILABLE
PROFESSIONAL SUMMARY
Over 7+ years of experience working as ETL/SSIS/SSRS/Power BI Data Engineer and have solid
experience working on OLTP and OLAP applications in creating different database objects (like
tables, views, indexes, stored procedures, functions, and triggers), Data modeling, data integration
(Using SSIS, ADF), Data visualization (Using Power BI, Tableau, SSRS), configuration and
managing reports using different technologies.
Extensive knowledge in ER Diagram and design of logical and physical data modeling using Erwin
tool and Visio.
Expert in planning, modeling, designing, developing, implementing, administering, and
maintaining Microsoft SQL- Server, Visual Studio 2019/2017/2014.
Highly proficient in the use of T- SQL for developing complex Stored Procedures, indexes, Tables,
Views, User Defined Functions, Relational Database models, Data integrity and SQL joins.
Extensive experience in designing de-normalized data warehouse including Star Schema,
Snowflake Schema, and data flow diagrams.
Extensive experience in creating and using Stored Procedure, Views, Triggers, schemas, and
Complex queries on SQL Server Management Studio.
Experience in writing complex SQL queries involving multiple table's inner and outer joins, stored
procedures.
Expertise in designing SQL Server SSIS packages to import and transform data between databases
and external data sources.
Data Mapping is based on business requirement for ETL with source to target data mapping with
physical naming standards, data types, domain definitions, and corporate meta-data definitions and
worked on Data Conversion using SSIS.
Expert in creating Dynamic SSIS Packages with Parameters, local and environmental variables,
XML configuration and check points.
Expert in creating data visualizations such as dashboards, parameterized reports, drill down reports,
and interactive reports using SQL Server Reporting Service.
Strong interpersonal & communication skills, Competitive analytical, logical, and problem-solving
skills, Strong management, administrative and leadership skills to work in team.
Expert ETL design, Expertise in migrating data from MS-Access, MS-EXCEL, and other external
data sources.
Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing,
debugging and deployment.
Performed Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to
production environment.
Tools And Technologies
RDBMS Azure SQL database, SQL Server 2019/2016/2014/2012
Languages\Tools Visual Basic, PowerShell, C#, T-SQL, Java, python, .Net
Modeling Tools MS Visio and Oracle SQL Server Data Modeler
ETL Tools SSIS, Azure Data Factory, Azure Databricks, Azure Synapse, Informatica Cloud
Visualization Power BI Desktop, Power BI service, Tableau, Report Builder, Visual Studio
Analysis Tools SQL Server Analysis Server (Tabular and Multi-Dimensional)
Version control apps GitHub/Git, TFS
EXPERIENCE
SQL/ETL Database Developer Aug 2022 - Present
Citibank Tampa, Fl
Identify and resolve problems encountered during both development and release of the SSIS code.
Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables
with incremental load.
Created packages in SSIS with error handling and worked with different methods of logging in
SSIS.
Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging
and Production environments.
Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for
SSIS Packages.
Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML
files etc.) and then loaded the data into destination tables by performing complex transformations
using SSIS/DTS packages.
Used ETL to implement Slowly Changing Dimension to maintain historical data in Data
Warehouse.
Designed, developed, and maintains real-time processing applications and real-time data
pipelines to make data available for consumption reports and advanced analytics.
Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other
T-SQL code and SQL joins for applications following SQL code standards.
Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for
performance.
Used Power BI different components/functionalities like power query, DAX, data models,
Datasets, Dashboards, KPI Scorecards, implementing row-level security and configuring
gateway.
Created and scheduled SSIS Jobs using SQL Scheduler, SQL Server Agent for daily, weekly, and
monthly loads.
Created Stored Procedures to transform the Data and worked extensively in T-SQL for various
needs of the transformations while loading the data.
Used SSIS to upload amortization schedules sent by the client in CSV format onto the staging tables,
which were used for doing all the calculations. Then the data was moved to the core tables and the
staging tables were deleted.
Wrote new code and modified existing code, conducting complete end-to-end unit tests on data
and data pipelines.
Created views to display required information on user interface, and triggers to validate consistent
data entry into the database.
Experience in report writing using SQL Server Reporting Services (SSRS) and creating various
types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting.
Designed different kinds of reports from scratch depending upon the requirements of the markets,
vendors, providers, and scanners.
Developed and updated technical documentation.
SQL/ETL Developer Jun 2019 - Jul 2022
Neighbor Works America
Washington, Dc
Requirements gathering, Analysis and Design of all the client requirements.
Designed and implemented database schemas and data models to meet specific business requirements,
resulting in a 20% reduction in data retrieval times.
Performed Data Modelling and Developed logical and physical model using Erwin and
implementing them to SQL server.
Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential
integrity, and provide additional application functionality.
Created SSIS packages using various data transformations like fuzzy lookup, derived column
transformation etc. to migrate the old Bills information, Customer Information, Contracts
Information, and other important data.
Used Crystal Reports to track logins, mouse overs, click-through, session durations and
demographic comparisons with SQL database of customer information.
Designed, coded, and implemented ad hoc reports using existing report models in SSRS.
Identified the Data Source and defined them to build the Data Source Views.
Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized
reports using Variables, Expressions and Functions for the reports.
Used Crystal Reports to track successful/unsuccessful sent emails, emails that were read, click-
through and demographic comparisons with SQL database of customer information.
Performed Index analysis for tables and came up with more efficient solutions to use Clustered and
Non-Clustered Indexes for significant performance boost.
Optimized SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
Involved in testing, bug fixing and documentation for the project.
Generated test data and tested database to meet the functionalities deliverables in the project
documentation and specifications.
Developed incremental loading using MERGE statement in SQL server 2008R2.
Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-
SQL statements using SQL profiler.
Used Execution Plan and Database Engine Tuning Advisor to optimize queries and enhance the
performance of databases.
Strong team player, providing technical expertise, mentorship, and collaboration within Agile Scrum
or Kanban teams.
Optimized the database by creating various clustered, non-clustered indexes and index views.
Ensured to generated and delivered quality reports to customers in timely and accurate manner.
Developed standard reports and functional dashboards based on business requirements.
Generated reports for internal and external customers for business performance monitoring and
business decision making.
SQL/SSRS Developer Oct 2016 - May 2019
Conduent Raleigh, NC
Make improvements to already existing data models, developed new data models with goal of creating
Power BI products that would offer much more interactive content and insightful visuals.
Leveraging expert knowledge of Power BI/DAX/Power Query designed while building several
dashboards for Executive Analytics.
Ensures quality assurance by developing strategies including testing, auditing, data usage, and data
ownership models.
Create, design, maintain and update reports, dashboards, and other content, and accompanying
documentation.
Connecting various applications to the database and writing functions, stored procedures, and triggers.
Importing data from various sources (flat file excel, raw file and various database) and exporting to various
destination using SSIS (2008
Creating databases and schema objects including tables, indexes, and applied constraints.
Developing visual reports, KPI scorecards, and dashboard using power BI desktop.
Have knowledge of database fundamentals such as multidimensional database design, relational database
design, and more.
Proficient in creating and maintaining complex reports using Crystal Reports and SSRS.
Skilled in data processing using Microsoft SQL Server, including ETL processes and data modeling.
Highly adaptable, with a track record of quickly learning new technologies, processes, and solving
complex business problems.
Engaged actively in Agile ceremonies, including daily stand-ups, sprint planning, retrospectives, and
product demonstrations.
Collaborated with cross-functional teams to understand and address database-related requirements.
Assisted in ETL processes using SQL Server Integration Services (SSIS) for data extraction and
transformation.
Conducted performance tuning, query optimization, and indexing to enhance database efficiency.
Environment:
MS SQL Server 2019/2016/2014/2012/2008R2, SSRS, SSIS, Power BI, Azure Data factory, SQL Query
Analyzer, SQL profiler, MySQL, Windows Server 2011/2010, DTS, Share Point Portal Server, HTML, HTML5,
XML, C#, .Net, ASP.NET, Visual Studio 2019/2017/2014, MS Access, Crystal Reports 2013, MS Excel 2010.
EDUCATION
Bachelor s in computer science
Addis Ababa University
|
