Name: MULUWORK WORKU

PHONE :703-***-****

Email:ad3jxx@r.postjobfree.com

SUMMARY

• 8+ years of overall IT experience in database development and Database system Microsoft SQL Server. Administration, Design, Development, and Support of MS SQL Server 2008-R2,2016,2014, 2012 and Development Environments

• 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 2017,2014,2012.

• Highly proficient in the use of T- SQL for developing complex Stored Procedures, indexes, Tables, Views, User Defined Functions, Relational Database models, Data integrity

• Extensive experience in designing de-normalized data warehouse including Star Schema, Snow Flake 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.

• Hands on experience in configuring Data Flow source and destination connection strings

• Expertise in designing SQL Server SSIS packages to import and transform data between databases and external data sources.

• Data Mapping 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.

• Extensive experience in implementing event driven Error handlings and package logs.

• 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.

• Hands on experience on developing Page level Reports, Dashboards, and Stories Using Microsoft Power BI.

• Experienced to translate reporting and analytical needs into technical solutions.

• Strong interpersonal & communication skills, Competitive analytical, logical, and problemsolving 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, and deployment.

• Performed Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.

• Worked with different source control systems like TFS and GIT, which are integrated with IDE to maintain shared environment for code and deployments within the team.

• Experience (DBT)data transformation tool that uses select SQL statements. It allows you to create complex models, use variables and macros (aka functions), PROFESSIONAL EXPERIENCE

Software Guidance & Assistance, Inc., (SGA) January 2023- present SSRS Developer

Tarrytown,NY

Responsibilities:

. Designing and developing reports: SSRS developers create reports using Microsoft SQL Server Reporting Services based on user requirements.

. Data analysis: They analyze data sources to ensure data accuracy and completeness.

. Database maintenance: SSRS developers maintain the database schema, including designing, developing, and testing database objects such as stored procedures and views.

. Report deployment: They deploy reports to production environments, ensuring that reports are accessible to users.

. Report customization: They customize reports to meet user-specific requirements. . Troubleshooting: They troubleshoot issues related to report development and deployment.

• Write, test and deliver reports.

• Provide weekly status reports.

• Meet with the customer to understand and gather business requirements and reporting needs.

• Maintain knowledge of database schema and data dictionary.

• Document report specifications, adhering to design principles and coding standards.

• Work with business analysts, clinical analysts, and end users to review and refine report specifications.

• Write complex reports

• Validate the results.

• Meet with customer to review and test reports and obtain customer approval that report meets business needs.

Tools & Technologies:

SQLServer2019, Visual Studio

MCIC Vermont LLC August 2020 to December2022

SQL Server (SSIS/SSRS) Developer New York

,Ny

Responsibilities:

• Involved in installing and maintaining MS SQL Server 2016/2019.

• Created Data Model or the Marketing Information System Team using Erwin.

• Created SSIS package for loading the data coming from various interfaces like OMS, Orders, Adjustments and Objectives and also used multiple transformation in SSIS to collect data from various sources.

• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.

• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.

• Scheduled and maintained daily and monthly loads of OMS, Orders, Objectives and Adjustments data through jobs, tasks, and alerts.

• Created stored procedures to build Fact tables in data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and create super user reports using (SSRS).

• Using SSAS created OLAP cubes for data mining and created reports from OLAP cubes using SSRS.

• Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP) environment for accessing and translating data into understandable and usable business information using SSAS.

• Created SSIS packages for File Transfer from one location to the other using FTP task.

• Created Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions according to the requirements of the project.

• Using reporting services (SSRS) generated various reports. ENVINORMENT: Windows XP, Windows 2012, Terminal Server, T-SQL, BCP, SQL Jobs, SQL Server Management studio, SQL Server 2016/2019, SSIS, SSRS, SSAS, Ascension Health Remote Oct 2018 to July 2020

SQL/ETL SSIS Developer

Baltimore, MD Responsibilities:

.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 complex SQL queries, and performed optimization of databases and tuning of long running SQL Queries by using SQL Server Profiler and SQL Tuning Advisor.

• Troubleshooting and corrects production ETL issues.

• Optimizing stored procedures, T-SQL, views, and functions for the best performance.

• Refining and automates regular SQL processes, track issues, and document changes.

• 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.

• 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.

• Designed, developed and maintained a data warehouse

• Creating Tabular reports with SQL Server Reporting Services (SSRS).

• Generating parameterized reports, drill down drill through reports

• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.

• experience working Databricks Access control lists (ACLS) to configure permission to access

. Databaricks SQL alerts, dashboards, data, queries, and SQL warehouses. Tools Used: MS SQL Server 2014/2016, SSDT, SSIS, SSRS, T-SQL, Excel Humana Inc Delray Beach, Florida April 2016 to Sep 2018 TSQL/ ETL Developer

Responsibilities:

• Created SSIS packages to migrate data from different data sources to data warehouse.

• Successfully extracted transformed and load data into data warehouse.

• Design, code and maintain new and existing

• Complex T-SQL stored procedure design, coding, troubleshooting and performance tuning

• Created packages by testing and cleaning the Standardized Data by using tools in Data Flow complex T-SQL stored procedures, triggers and functions Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.

• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.

• Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources. …..

• Involved in enhancing and deploying the SSIS Packages from development server to production server.

• Established ETL design practices for optimization and performance of packages and Parameterized SSIS.

• Create low level design and ETL design doc according to requirement.

• Analyze existing ETL jobs and find the gaps.

• Experience Correct testing defects and support all testing, including but not limited to: Development Integration Testing, System Testing, User Acceptance Testing, End-to-End Testing, and Performance Testing.

• Identify application bottlenecks and opportunities to optimize performance

• Performed data analysis for the existing data warehouse and changed the internal schema for performance.

• Created multiple database objects such as UDFs, stored procedures, and temp objects as per the business logic.

• Wrote and tested SQL queries utilizing inline views, dynamic SQL, and merge statements.

• Built and analyzed indexes to bring down processing times and improve performance.

• Created constraints in both the production and relational data warehouse databases to enforce business rules.

• Involved in identify and track slowly changing dimensions from heterogeneous sources.

• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2012.

• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2012.

• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.

• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).

• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.

• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.

• Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard.

• Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.

• Experience with Python coding, designing, debugging application projects on the server-side or front-end (depending on company & scope of role) Tools & Technologies: SQLServer2012, SQL Server BI Development Studio (BIDS) 2012,TFS, Oracle 9i/10g, Visual SourceSafe, T-SQL, Autopsy’s, MS Access, Windows XP/2007 Server. EDUCATION: Bachelor Degree

Contact this candidate