PROFESSIONAL SUMMARY:
Over *+ years of extensive work experience as a SQL Server Developer and in-depth proficient experience in OLTP, Operational Data Source (ODS), and Dimension Modeling, Performance Tuning, Data warehouse, OLAP and Database technologies.
Experience in design, development, coding, and testing of business and commercial applications in MSSQL Server 2017/2016/2014/2012, MS Access, .NET Script, Windows 8/10.
Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.
Over 6 years of extensive experience in T-SQL Programming in developing Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) XML and Complex Queries on SQL Server 2012/2014/2016/2019.
Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.
Excellent in High Level Design of ETL SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Execute SQL Task, Data Flow Task, and union all.
Experience in some basic development of coding in VB.NET, C# while working with SSIS.
Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation, and loading.
Over 5 years of experience in utilizing ETL tools, including SSIS, DTS and Data Stage and ETL Package design.
Experience in extracting and transforming data using Import/Export wizard, Bulk Insert, Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
Experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance.
Exposure in using Team Foundation Server (TFS) as a source control, source repository and project tracking solution.
Developed several Ad-hoc reports according to the customer requirement and the Cubes using SSAS and MDX.
Developed complex Stored Procedures and views to generate various Drill-through, Drill through reports, parameterized reports and linked reports using SSRS.
Experienced in writing Parameterized queries for generating Tabular reports, Formatting report layout, sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2012/2014.
Good knowledge on latest BI tools like Tableau.
Worked on Power BI and prepared dashboards using Tableau to make it more attractive.
Deployed and generated reports on to the server using the Report Builder 3.0 tool in Report Manager.
Experience with Data Marts, Data warehousing, OLAP, Star Schema Modeling, Snow-Flake Modeling, facts, dimensions, partitions, Tables using MS Analysis Services 2012.
Good Experience with SSAS OLAP Cubes and Data Mining.
TECHNICAL SKILLS:
Cloud Technologies: Microsoft Azure
Databases: SQL Server 2008/2012/2014/2017, Azure (Cloud Server), Access.
BI Tools: SSIS, SSAS, SSRS.
Operating Systems: Windows Server 2007, 2010, 2013, Windows 8/10/NT/XP/Professional, MS-DOS, Red Hat Linux
Version Control: TFS/GIT/SVN
Languages: T-SQL, C/C++, HTML, XML, VBScript, C#.Net, PowerShell, VB.Net, XML, MS Access, HTML.
PROFESSIONAL EXPERIENCE:
Client: Aflac Inc, Tampa, FL
Sr. SQL Developer
Feb 2021 – Present
Responsibilities:
Participate in development and creation of Database and prepared the complete data mapping process based on business requirements.
Create new and evolving data integration projects and data extracts.
Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, CTE’s to implementing the business rules and transformations.
Involved in testing and debugging stored procedures.
Troubleshooting performance issues and fine-tuning queries and stored procedures.
Tracked progress of project by maintaining constant communication with senior management staff within client’s company and internally.
Extract and transform data using Import/Export wizard, Bulk Insert, Bulk Copy Program (BCP), Data Transformation Services (DTS) and ETL process using SSIS from flat files, excel files and SQL server Database.
Developed Stored Procedures and Functions to implement necessary business logic for data extraction, data load and transformations and reports.
Responsible to build Reports for different Markets and ADHOC reports as per request.
Created, scheduled, modified, and performed troubleshooting in many different SQL Jobs using SQL Server Agent.
Deployed, scheduled the reports, and send the output via email in report manager.
Provided 24/7 Production Support for the maintenance & scheduling of reports.
Documented all the work and all the process of integration and reporting services for further references.
Collaborated regularly with stack holders and translated business requirements to business intelligence data solutions and recommendations for business decisions.
Worked with Bitbucket version Control to maintain the different versions of Code, back out Scripts, and SSIS Packages.
Oversaw software developers progress on applications and applied principles of Agile/Scrum methodologies to keep project on track.
Environment: SQL Server 2017/2014, MS Azure, Report Builder 3.0, Business Intelligence Studio (SSIS, SSRS), Agile Project Management tool, Jira, Bitbucket, AHA roadmap software, C#.NET, T SQL, Linux and Windows Server environments, MS Excel.
Client: Segue Technologies Inc, Arlington, VA
Sr. SQL Developer
Jan 2019 – Feb 2021
Responsibilities:
Create Entity Relationship (ER) Diagrams to the proposed database.
Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
Work with the database developers, software developers and Development Lead, to architect and implement new features and solutions for customers.
Develops and supports database architecture and development to create and enhance the Enterprise Applications.
Developed various T-SQL stored procedures, triggers, views, and adding/changing tables and Table valued Functions as per the requirements.
Identify and write best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server.
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 different kinds of transformations using SSIS (SQL Server Integration Services)
Develop mapping specifications, Source to target mappings and ETL development.
Develop the workflow and dataflow of SSIS ETL processes to support many different file structures and business processes.
Perform tasks related to performance tuning of ETL jobs.
Data loading workflow design and custom enrichment development using leading ETL tools.
Researched and designed and implemented scalable applications for information identifications, extraction, analysis, retrieval, and indexing.
Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
Used clustered and non-clustered indexes to improve the performance and shorten the execution time of SQL queries.
Designing Visualizations in Tableau 9.2
Responsible to build Reports for different Markets and ADHOC reports as per request.
Documented Back out Implementation Plan for all the work done and created the CMD files.
Worked with Team foundation server version Control to maintain the different versions of Code, RDL Files, back out Scripts, CMD files & SSIS Packages.
Provided 24/7 Production Support for the maintenance & scheduling of reports.
Environment: SQL Server 2017/2014, MS Azure, Tableau, Report Builder 3.0, Business Intelligence Studio (SSIS, SSRS), Agile Project Management tool, C#.NET, T SQL, Linux and Windows Server environments, MS Excel.
Client: Keurig – Reading, MA
SQL Developer
Sep 2017 – Dec 2018
Responsibilities:
Develops and supports database architecture and development to create and enhance the Enterprise Applications.
Analyzed queries performance with SQL query analyzer, optimized the performance of queries by removing unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
Work with the database developers, software developers and Development Lead, to architect and implement new features and solutions for customers.
Participate in development and creation of Data warehouses.
Performance tuning of database systems.
Develops and supports database architecture and development to create and enhance the Enterprise Applications.
Work with development and IT teams to troubleshoot data or performance problems.
Participated in to design ETL architecture and processes records from different locations, and successfully met challenges of extremely high volume of data.
Create cubes in SQL Server Analysis Services.
Responsible for generating different types of daily and weekly Reports based on specifications and user's requirements using SSRS.
Documented all the work and all the process of integration and reporting services for further references.
Environment: SQL Server 2014/2016, SSIS, SSRS, Microsoft Operation Manager, SQL Query Analyzer, ODBC, Agile Project Management tool, VBScript, Windows 2000/XP/7, MDX.
Client: Driscoll’s - Watsonville, CA
SQL Developer
Jan 2016 – Aug 2017
Responsibilities:
Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers form the existing diversified data sources.
Participated in developing Logical design of database incorporating business logic and building entity relationship (ER) diagrams.
Experienced in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and complex joins and sub queries in SQL Server Management studio (SSMS) 2008.
Used Team Foundation Server and Visual Source Safe as a version control tool.
Developed logical queries to not triggering email limit error for ETL batch jobs.
Created Jobs in SSIS and was responsible for ETL job scheduled to run daily. Solved the issues associated with ETL Data Warehouse Failure.
Prepared the complete data mapping for all the migrated jobs using SSIS.
Perform tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
Environment: MS SQL Server 2012, Microsoft Visual Studio 2010, Team Foundation Server (TFS), MS VISIO, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), MS Excel, Microsoft Office SharePoint Server.
Client: Verizon - Dallas, TX
SQL Developer
Sep 2014 – Nov 2015
Responsibilities:
Involved in gathering business requirements and development of data modeling to facilitate business and operational needs.
Improved the performance of the SQL server queries using query plan, covering index, indexed views and by rebuilding and the indexes.
Troubleshooting performance issues and fine-tuning queries and stored procedures.
Involved in testing and debugging stored procedures.
Designed, built, and tested SSAS Cubes on SQL Server.
Created Excel workbooks to enable Cube (SSAS) access for business users.
Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations
Use package configuration to migrate SSIS package from one environment to other.
Designed Extraction Transformation and Loading (ETL) process using SSIS to extract data from flat files, excel files and SQL server database.
Designing Visualizations in Tableau 9.2
Environment: MS SQL Server 2008/2012, SSIS, SSAS, SSRS, TFS, Windows 2003/2008, Deployment Wizard, Visual Studio 2010, MS Excel 2007, Tableau, C#.Net.
EDUCATION:
Bachelor’s Degree: Engineering Haramaya University