Sql Developer Data Modeler
Resume:
D
Samuel Debela
***********@*****.***
Silver Spring, MD 20901
SUMMARY
6+ years of IT experience in Analysis, Design, Modeling, Development, Testing and Maintenance of Business Intelligence Applications. I have worked in different domains such as Finance and Mortgages. Using different versions of Microsoft SQL Services (SSMS, SSRS, SSIS, and SSAS) related tools. Meticulous SQL Developer with expertise in processing data and knowledge of various flowcharting techniques. An excellent understanding of database structures, theories, principles and practices. Superb problem-solving and analytical skills.
SKILLS
Professional Skill:
MS SQL Server 2019/2017/2016/2014/2012/2008, MS SQL Server Integration Service (SSIS), MS SQL Analysis Services (SSAS), MS SQL Reporting Services (SSRS), MS Access, MS Excel, MS Outlook, MS SQL Profiler, SQL Query Analyzer, Database engine tuning advisor, Power Designer, Erwin Data Modeler, MS Visio, T-SQL, Unix/Linux.
Code Analysis and Development
Regression Testing
Agile/Scrum Methodology
Database Management Software
Source and Version Control: Git, Github
Linux and UNIX
EXPERIENCE
SQL Server SSIS/SSRS Developer
Miami, FL
Integraconnect/ Feb 2019 to Current
Converted the legacy sequential SQL job to parallel processing using SSIS and reduced the execution time to 50%
Converted existing legacy reports to Microstrategy Reports
Tuning the SQL Agent job and SSIS packages
Performance Tuning (Index Design and Maintenance, Ability to read/interpret SQL Execution Plans)
Production Support
Bug fixing raised by QA and Clients
Creating the SSIS packages for a smooth data flow across different servers
Create reports in BI preview portal utilizing the SSAS Tabular via Analysis connector
T-SQL coding for creating procedures and other database objects
At the staging server, data was loaded from different sources like flat delimited text files, Extensively used store procedures and UDF functions such as scalar and inline functions for complex queries, Triggers, indexes involving multiple tables from different databases
Worked on Evaluation of SSIS packages and did error handling
Created SSIS packages with Error and Event Handling, Precedence Constraints, Break Points, and Logging
Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments
Created complex SSIS packages for data cleansing, involving various tasks such as for each loop, file system task, and multicasting
Interacted with the existing database developers and DBA to understand the existing schema
Thorough analysis, unit testing and integrated testing with other applications of database objects & T-SQL statements before deployment to the production server
SQL Jobs monitoring and troubleshooting
Designed and implemented UX for clients based on their needs and requirements
Proficient in designing, implementing and managing data structures and queries using Snowflake data warehouse technology
Experienced in utilizing Snowflake's cloud based architecture for data storage, analysis and storage.
Developed database dictionaries and schemas.
Designed and created database systems after reviewing end user's requirements.
Tested databases and performed bug fixes.
Designed, developed and implemented firmware to support embedded system product concepts.
Grew program capabilities seamlessly weaving more complex elements into product foundations.
Prepared charts and diagrams to illustrate system operation results to staff in other departments.
Prepared documentation for database applications
Conducted software trial runs to achieve desired results and confirm accurate information.
Used software and computer programs to compile and categorize data for daily use.
Developed technical specifications and plans, documenting details into user manuals for future reference.
SQL Developer
san jose, CA
Home Depot/ May 2016 to Dec 2018
Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implement the business rules and transformations
Data Analysis and Designed the logical and physical model architecture for database
Interacted directly with the various SME for gathering the business requirements
Involved in Design DW of Star Schema (Dimensional model and Fact tables) based on business
Convert data from Legacy system to SQL Database
Responsible for database development and performance tuning of the T-SQL queries using SQL Profiler and Activity Monitor
Involved in the maintenance of the existing cubes of the data warehouse by adding additional dimensions, user-defined hierarchies, and calculated members using SSAS 2008 and also wrote many scripts while developing the reports from the cubes using SSRS 2008
Implemented Auditing using triggers
Involved in scheduling backups of databases and logs and restoring them when necessary
Created schema objects, rules and granted roles to the users
Involved in Query optimization, Performance Tuning and Index Creation
Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)
Used SSRS to create reports, customized Reports, on-demand reports
Database Backup and restoring the database
Worked in Database Security, Replication, and Log shipping activities.
EDUCATION AND TRAINING
management Information systems
Unity University Aug 2011
Contact this candidate