Helen Zewdu
SQL Server SSIS/SSRS Developer
Charlotte,NC
Summary
Over 10+ years of in-depth experience in database Design, Modeling, development, administration, and maintenance of SQL Server 2016/2014/2012/2008R2 large scale databases. Expert in writing T-SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration. Proficiency in creating different types of Reports such as Crosstabs, Drill-down, Summary, Parameterized, Sub reports and formatting them using SSRS. Experience with T-SQL, Integration Services (SSIS), Reporting Services (SSRS). Assisted in development of ETL architectural standards and provided guidance and conducted trainings to Architects. Crystal Reports development focusing on website/email tracking, database queries and accounting. Strong Knowledge in Enhancing and Deploying the SSIS Packages from Development Server to Production Server. Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data. Created SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors. Knowledge in migrating DTS packages, reports, and analysis services projects from SQL Server 2000 to SQL Server 2005. Highly experienced in database server performance tuning and optimization of Complex SQL queries. Launching the report builder for ad hoc reports. Complete knowledge in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance. Accomplished in creating Packages, scheduling Jobs, and sending Alerts using SQL Mail. Extensive experience in Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore procedures. Implemented different Replication Models like Snapshot, Merge, Transactional and Database Mirroring. Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Joins, Constraints, DDL, DML, User Defined Functions to implement the business logic and created clustered and non-clustered indexes. Good Knowledge in designing Database Models using UML, MS Visual studio, and Erwin. Ability and willingness to learn new technology and deliver results in a timely manner. A well-organized, goal-oriented, highly motivated effective team member.
Overview
10
10
years of professional experience
4
4
years of post-secondary education
Work History
MS SQL Server SSIS / SSRS Developer
Wells Fargo
06.2021 - Current
- Develop original and/or complex code or provides coding guidance
- Develop solutions that can leverage existing development/tools as well as create solutions that act as building blocks for future development
- Analyze business requirements, designs and write technical specifications to design SSIS, SSRS, SQL stored procedures, OPS tools
- Verify program logic by preparing test data, testing, and debugging of programs
- Participate in overall systems testing
- Develop, execute, and maintain automation suite of test scripts
- Perform application support and troubleshooting, provide guidance and direction to colleagues
- Assure quality QA, security and compliance requirements are met for supported area and oversee updating and testing of the business continuation plan
- Ensure compliance with all SDLC policies and procedures including effective planning of all changes in advance to ensure all required lead times, SDLC checkpoints, etc
- Are met
- Perform peer Review: - is to verify whether the work satisfies the specifications for review, identify any deviations from the standards or requirements that stated on US, and provide suggestions for improvements
- Perform QA: - I have analyze the requirements, define the parameters that determine if the product meets their needs, and create a set of testing cases and scripts
- These are then used to ensure that the client is getting what they want
- VB6, Office, Oracle, MS SQL OLAP Developer MS SQL 200x, T-SQL, DTS, OLAP, MDX, SSAS, SSRS, SSIS, Analysis, Reporting, Integration Oracle 8/9/10, PL-SQL, TOAD, SQL Loader, Forms, Reports, DWH, ETL development creating table, views and indexes updating, inserting and deleting data in relational databases using SQL queries
- Created Triggers (Instead -of and for/ After) for Auditing Purpose
- Created Views and Indexed Views for the Performance Tuning
- Created automated T-SQL scripts to process summary database transactions that run off-hours
- Developed stored procedure, triggers and functions in T-SQL that were used to invoke transfer of data and dimensions from fact tables to target tables using ETL processes
- Created Linked Servers to retrieve data from other databases
- Monitored and modified Performance using execution plans and Index Tuning
- Involved in preparing detailed technical documents
- Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system
- Involved in code review and preparing unit test cases
- Worked with different Control Flow elements like For Loop Container, For Each Loop Container etc
- Designed, developed and deployed SSIS packages, ETL workflows and SSRS reports
- Generating complex Transact SQL (T-SQL) queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc
- Draw lineage diagram at high level to understand technology from start to end point, and understand what technologies are and how they connect
- Scheduled the SSIS packages to run at different intervals to load the data into SQL Server
- Involved in Maintenance and Deployment of SSIS Packages
- Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS)
- Developed Tabular, drill down, parameterized, cascaded and sub-reports using SSRS
- Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS
- Used Query Analyzer, Index Wizard, DB Engine Tuning and SQL Profiler for performance tuning
- Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions
- Migrate SQL server to 2016 from 2012
- Re-write the store proc that has slow performance running due to poor joining statements
- Create no cluster index based on the procedure if it’s required
- Build a technical requirement for already created procedures
- Re-run all migrated SQL object to make sure running smoothly and check the result set with Previously result set
- Identifying long-running queries, scripts, and tuning
- Created Complex Stored Procedures and automated them using SQL Server Agent.
SQL/DWH Developer
AA Prestige Transportation
01.2016 - 05.2021
- Involved with Query Optimization to increase the performance of the Report
- Developed Reports for business end users using Report Builder with updating Statistics
- Create charts and pivot tables in Excel
- Established ETL design practices for optimization and performance of packages and Parameterized SSIS
- Updated functional specification and technical design documents
- Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS
- Analyze existing ETL jobs and find the gaps
- Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, views and SQL joins and statements for applications
- Designed an OLAP system with the help of ERWIN to visualize data structure
- Extracted data from heterogeneous sources and transferred to OLAP using SQL Server Integration Services (SSIS)
- Create low level design and ETL design doc according to requirement
- Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task
- Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets
- Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS
- Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS using Visual Studio 2010
- Problem identification, troubleshooting, resolution, and index tuning databases
- Created Alerts for successful or unsuccessful completion of scheduled Jobs
- Worked as a SQL developer to write complex queries like Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications
- Gather business requirements from users and translated them as technical specs and design docs for development
- Actively involved in requirements gathering/analysis meetings with Business and provide description about the analysis and approach
- Created and developed SQL server jobs on SQL Server Integration Services (SSIS) packages to automate the execution of the packages at a particular time depending on requirements
- Extensively used SSIS to move data from text files to SQL Server
- Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load using Visual Studio
- Proficient in usage of SSIS Control Flow items (For Loop, execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot)
- Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS
- Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server
- Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, transactions, and package configurations.
MS SQL Server SSIS / SSRS Developer
Ally Bank
02.2014 - 11.2015
- Requirements gathering, Analysis and Design of all the client requirements
- Performed Data Modeling 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 SSIS to upload amortization schedules sent by the client in .CSV format on to the staging tables, which were used for doing all the calculation
- Then the data was moved to the core tables and the staging tables were deleted
- 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
- Managed Alerts for successful or unsuccessful completion of scheduled Jobs
- Used Crystal Reports to track successful/unsuccessful sent emails, emails that were read, click-through and demographical 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
- Created SSIS/DTS packages to copy tables, schemas, views to extract data from Excel
- Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
- Create complex DTS Packages in SSIS for Data load from CSV/Excel Sheets with more than 200 columns and with different file layouts to SQL Server database
- Developing Stored Procedures and Functions used for inserting, updating, or transforming data
- Developing complex T- SQL queries used for data investigation
- Creating table indexes and constraints to ensure data integrity and enhance query processing
- Sourced data from various types of relational databases, flat files, excel files
- Developed SSIS packages with various tasks like - FTP, file system, for each loop, execute package, data flow task, execute SQL task, custom script task, data mining task
- Business Information tools and programming/query languages creating reports in Microsoft SQL Server Reporting Services and creating SSIS packages
- Care data structures and business practices
- Managing projects using Software Development Life Cycle
- Reporting, analytics or database administration writing queries against relational databases experience pulling information from relational databases.
Education
Bachelor of Science - Information Technology
Debre Brhan
02.2004 - 10.2007
Skills
Databases Tools SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS) ETL Tools Data Transformation Services (DTS) Export/Import, SQL Server Integration Service (SSIS)
Enterprise Manager, SQL Profiler, Teradata, Query Analyzer, SQL Server 2008 SQL Server 2005
Management Studio, DTS, SSIS, SSRS, SSAS, Index Analyzer
Database: MS SQL Server 2012,2008R2,2008,2005, 2000, MS-Access
Language: PL/SQL, T-SQL, VBNet (C#, VB)
Operating system: -Windows XP/NT/2000, DOS, Windows Server 2008
Tools: -Erwin, Microsoft Visual Studio 2012/2008/, Microsoft Project Server 2007, ProClarity
Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP
Reporting Tools: SSRS (SQL Server Reporting Services), SSAS, MS excel, power BI, Crystal Reports
ETL Tools: SSIS (SQL Server Integration Services), BI Studio, Import/Export Wizard, SQL Mail, DTS, BCP
Business Tools: Word, Excel, PowerPoint, Access, Outlook, G-suits, JIRA, Waterfall, WordPress
Experience with Atlassian Software Tools; Jira, Bitbucket, Bamboo and Confluence
Certification
Microsoft SQL Server Implementation and Maintenance
Years Of Experience
10 years
Current Role
Sr. BI and ETL Developer/ MS SQL Server SSIS / SSRS Developer
Reading and Gardening
Gardening is fun and relaxing for me way to get in touch with nature
I enjoy reading I prefer reading fiction
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
MS SQL Server SSIS / SSRS Developer
Wells Fargo
06.2021 - Current
SQL/DWH Developer
AA Prestige Transportation
01.2016 - 05.2021
MS SQL Server SSIS / SSRS Developer
Ally Bank
02.2014 - 11.2015
Bachelor of Science - Information Technology
Debre Brhan
02.2004 - 10.2007
Similar Profiles
PATRICIA M. SCHERERPATRICIA M. SCHERER
Regional Bank Private Banker II at Wells Fargo Bank / Wells Fargo AdvisorsRegional Bank Private Banker II at Wells Fargo Bank / Wells Fargo Advisors
Andrew S. HollenbachAndrew S. Hollenbach
Collateral Valuation Analysis at Wells Fargo Home Mortgage and Wells Fargo Bank NACollateral Valuation Analysis at Wells Fargo Home Mortgage and Wells Fargo Bank NA
Laxmikanth ChittampallyLaxmikanth Chittampally
Senior Operational Processor at Wells Fargo India Solution PVT Ltd, Wells FargoSenior Operational Processor at Wells Fargo India Solution PVT Ltd, Wells Fargo
Mayank OberoiMayank Oberoi
Financial Accounting Associate/ Alteryx SME at Wells Fargo International Solutions Private LTD (Wells Fargo)Financial Accounting Associate/ Alteryx SME at Wells Fargo International Solutions Private LTD (Wells Fargo)
Samantha CottonSamantha Cotton
Manager at Mellow MushroomManager at Mellow Mushroom