PROFESSIONAL SUMMARY:

●Over * years of experience in IT with expertise in MYSQL Developer with a proven record of strong database development and maintenance.

●Data warehouse developer using TERADATA(V2R5,V2R6,V12)

●Experience in implementing various BI/Data Integration Projects on different business domains like Health, Retail, Manufacturing and Telecommunications.

●Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.

●Good knowledge in RDBMS concepts, data models, Star/Snow Flake Schemas.

●Good understanding in database and data warehousing concepts (OLTP and OLAP)

●Demonstrated expertise in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS.

●Extensive experience in Views, Stored Procedures, Cursors and Triggers.

●Experience in migrating data from legacy system (text based files, Oracle, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).

●Experience in developing dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder.

●Experience in building ETL processes using SSIS packages by extracting data from various sources such as flat files, Excel files, legacy systems and loading into SQL server.

●Experience in creating Parameterized, drill-down, drill-through, sub-reports, matrix, tabular and Various Charts in Reports using SQL Server Reporting Services (SSRS).

●Good report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.

●Expertise with job scheduling using SQL Server Agent to perform hourly/daily/nightly updates.

●Good communication skills, analytical skills, understand business requirements in various domains.

●Creating Teradata workload manager with the proper portions and workloads based on service level.

TECHNICAL SKILLS

Operating Systems

Windows 8/7/Vista/XP/2003/, Windows Server 2008/2005/2003, Linux

Programming Languages

T-SQL, PL/SQL, HTML, XML, Oracle, C, .NET, VB.NET, ASP.NET,

ActiveX, MS Access.

Tools/Utilities

SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export, Visual Studio, Business Intelligence Development Studio(BIDS), Crystal Reports 9.0, ETL, IIS, Teradata

Database Design Tools

MS Visio, MS Access, MS SQL Server 7.0/2000/2005/2008/2008R2/2012/2014, DB2, MS SQL Integration Services 2012 /2010, MS SQL Reporting Service 2008, MS SQL Server 2014/2012 /2008R2/2008

BI Tools

SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Oracle BI Publisher,, MS Visio, Erwin, Crystal Reports 9.0/XI, SAP Business Objects

Software

MS Office Visio, MS-Project 2000, MS Office

Other Tools

JIRA,TFS, FTP, GIT, Genk ins, File Zillah, Load runner, Tomcat, MS Office like MS Word, MATS,MS Excel, MS Project, MS power point, Auto cad, 2020, and MS Outlook

PROFESSIONAL EXPERIENCE

UNITED HEALTH GROUP,

Data and Report Analyst Oct 2022–Present

Responsibilities:

Responsible for designing/developing, programming, maintaining data and business system.

Create and edit SQL store procedures

Develop and maintain SSIS packages. Accountable for all departmental batch job processes.

Create forms, set up and edit macros, and create and edit queries with MS Access.

Provide Ad Hoc analytical support to operations.

Support incidents, problems, enhancements, and projects for Risk Managements/Underwriting Applications working directly with end user.

Provide subject matter expertise on all data elements and report content

Wrote complex store procedure, views using T-SQL in Management Studio.

Implemented caching of reports and managed the report history in the Report Manager.

Identified the data source and created source to target mapping documents to be used by the packages in SQL Server Integration Services(SSIS).

Optimized the queries for efficient data retrieval by implementing indexes on the tables.

Marriott International, Bethesda, MD

SQL Developer Jan 2021–Oct 2022

Responsibilities:

Responsible for creating a Data warehouse for the organization as part of the migration project from IBM to Microsoft SQL Server.

Created SSIS packages to load data from flat files, csv and excel files in to the staging tables.

Created T- sql objects to load the data from the staging tables to the transaction tables.

Responsible for creating the data mart for various domains.

Creating SSIS packages to send the data in flat files to various vendors.

Working with the Business Analysts to gather the requirements and working with them on the mapping document.

Monitoring the production Jobs and working on post-production tickets (defects) and enhancements.

Working with the business to create SSRS reports by extracting data from the data mart.

Implementing OLAP cubes (Star Schema) for the business users.

Solely Responsible for deployment of objects (T-SQL, SSIS, SSRS) to all the regions (DEV, INT, ACC, PROD).

Environment: SQL Server 2008, T-SQL, SQL Server Management Studio, Visio, Excel Reports, Outlook, Service Center. ETL Tools Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS) Reporting Tools SQL Server Reporting Services […] MS Access, MS Excel, Crystal Reports, Business Objects4.0 Database MS SQL Server […] MS Access, Oracle 9i/8i Programming Languages T-SQL, PL-SQL,

New market International Inc. - Portsmouth, NH Oct 2018 to Dec 2020

SQL Server Developer

Responsibilities:

Developed and Maintain database Stored Procedures.

Developed SQL queries and support ad hoc requests for data.

Experienced with Team Foundation Server (TFS)

Devise T-SQL scripts for the SSRS reports

Identifying and troubleshoot business process or data quality issues that show up in the reports and subsequently communicate to resolve and eliminate problems.

Other MS SQL Server SSIS related duties were taken care.

Produce data transformation projects in SSIS

Setup data for appropriate testing, conduct timing and capacity testing to ensure production support capability.

Stored Procedures were used at DFT level to incorporate error handing in SSIS packages.

Data Migration has been done Oracle, Flat Files, and My DATA applications to SQL Server 2012 by using SSIS packages (Microsoft SQL server 2012).

Handled SDLC responsibilities in various releases for EMC application which involves millions of transactional data.

Incorporated Incremental way of loading data in almost all packages by efficiently using Staging and Target Databases

Created HTML reports by using Report Builder 3.0 which sends error records and corresponding counts to Production support team. Final Error report will be embedded in the body of e-mail

Worked as a SCRUM master for some Sprints and co-ordinated with team members about their duties. If they had barriers helped in resolving them by communicating to Business owners or SME's (Subject Matter Experts)

Extensively used File Processing methodology in a SSIS package if an interface depended upon Flat Files, EXCEL files, CSV files. Script Components played an important role in this task

Worked for Inbound and as well as Outbound Interfaces by SSIS packages (Microsoft SQL server).

Filtered data from Transient Stage to EDW by using Complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.

Successfully made Deployments by using environmental variable and SQL Server to all kinds of environments and had been set more scheduled jobs by using SQL Server Agent.

Developed documentation for all the Interfaces which are developed.

Environment: MS SQL Server 2012/2014/2016, MS Business Intelligence Development Studio(BIDS), MS SQL Server Integration Services (SSIS), MS SQL Server Reporting services(SSRS), MS SQL Server Analysis Services (SSAS), MDX,ETL, T-SQL Visual Studio 2010/2012 Report Builder 3.0, MS SQL Profiler Erwin Visual Source Safe, Sales Force.

GAVS, Washington, DC Apr’15 to Sep’18

MS SQL Server SSIS/SSRS Developer/ETL Developer

Responsibilities

●Created ETL SSIS packages both design and code to process data to target databases.

●Identify and resolve problems encountered during both development and release of the SSIS code.

●Debugging and troubleshooting the technical issues while implementing the applications.

●Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

●Created DTS Packages for extracting data from Flat Files, Excel, MS Access, Oracle and MS SQL Server 2000

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

●Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages and Updating and maintaining Visual Source Safe.

●Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.

●Responsible for data analysis, loading data from Data feed to Data Warehouse tables.

●Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

●Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

●Configured and maintained MYSQL database servers.

●Created views to display required information on user interface, and triggers to validate consistent data entry into the database.

●Designed implemented and supported database as well as custom developed.

●Support and Administer SQL replication for DB2 on Z/OS environment.

●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 by customizing URL Access.

●

●Designed different kinds of reports from scratch depending upon the requirements of the markets, vendors, providers and scanners.

●Documented all the work and all the process of integration and reporting services for further references

●Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC).

Environment: MS SQL Server 2012/2008R2, SSRS, SSIS, SQL Query Analyzer, SQL profiler, IIS 6.0,Enterprise Manager, Windows Server 2003/2008, DTS, Share Point Portal Server, HTML, XML, C#, .Net, ASP.NET, Visual Studio 2005/2010, MS Access, Crystal Reports, MS Excel 2007.

EDUCATION: Bachelors’ Degree in computer information system, Addis Ababa university

2007-2010

Bachelor’s degree in computer information system, Georgia state university

2017-2021

Contact this candidate