SUMMARY

• More than 10+ years of total IT experience including 7 years of experience in Database/Data Warehouse design, development & administration using Microsoft SQL Server 2012/2008R2/2008/2005, T - SQL, MSBI Tools such as Power BI, SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS), SQL Server Analysis Services (SSAS) in DEV, TEST and PRODUCTION environments with various domains like Financial, Health Care and Pharmaceutical.
• Good experience in Database Design and development of applications with Business Intelligence using SQL Server 2012 &2008, Integration Services (SSIS), DTS Packages, Reporting Services 2012 &2008(SSRS), and Implementation of Data warehousing, SQL Server Analysis Services (SSAS), MDX Queries, OLAP Cubes, Star Schema and Snow Flake Schema.
• Expert in Database Design, Data modeling, Development, Implementation, ETL and Reporting in
• SQL Server 2005/2008/2008 R2/2012/2014 with expertise on data normalization.
• Experience in software Analysis, Design, Development, Testing, Implementation and Production Support of Client/Server and Web based applications.
• Highly skilled in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package
• Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Sound knowledge of Data marts, Data warehousing, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using MS Analysis Services.
• Expertise in T-SQL (DDL, DML), Complex Queries, Tables, Views, Stored Procedures, Indexes, Cursors, User Defined Functions and Triggers. Extensive experience with SQL Server and T-SQL in constructing Business logic at back-end using Stored Procedures, views, indexes.
• Experienced in Installing, Configuring, Managing, Upgrading, Migrating, Monitoring and Troubleshooting of SQL Server SQL Server 2016/2014/2012 / R 2/2008/2005.
• Experience in extracting data from heterogeneous sources, transforming and Load functions from multiple OLTP systems into a single data warehouse using SSIS.
• Extensive experience in creating, deploying and monitoring SSIS packages. Good experience on Debugging Data Flow, Control Flow and Packages. Good Experience on Performance Tuning in SSIS Packages.
• Generated daily, weekly and monthly reports for the managers using SSRS
• Created Tabular, Matrix reports with and without parameters using SSRS
• Experience working on creation of various Reports using SQL Server Reporting Services (SSRS).
• Experience in Customizable dashboard pages, KPI Details reports, sophisticated scorecards, Time Intelligence, Reusable dashboard items, dashboard filters.
• Experience in creating dashboard pages, dashboard filters, and Performance Point reports by using Dashboard Designer and Power BI desktop.
• Experience in various operational Drill-through, Drill-down, and linked reports using SSRS.
• Experience in developing different kind of reports such a Sub Reports, Chars, Matrix reports, and Linked reports using SSRS, SQL Server Data tools for Visual Studio and Power BI desktop.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server.
• Experience in working with Excel applications to browse the data and create reports using pivot table, power pivot & power view.
• Excellent OLAP skills and designing cubes, populating data, optimizing cubes using SSAS.
• Expertise skills inCalculating MeasuresandCalculating Membersin SQL Server Analysis Services (SSAS) using multi-dimensional expression (MDX).
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, migrating, security management and production supporting on various platforms like Windows 2000/XP/ME/7/10, Windows Server 2000/2003/2008/2008 R2/2012.
• Strong troubleshooting, presentation, communication, interpersonal skills; and highly motivated with an ability to learn new systems and business procedures with hardworking and result oriented as an individual and in a team.

TECHNICAL SKILLS

Databases: MS SQL Server 2005/2008/2008 R 2/2012/2014/2016 , SSIS, SSAS, SSRS

Operating Systems: Windows 2000/XP/ME/7/10, Windows Server 2000/2003/2008/2008 R2/ 2012, Visual Studio 2005/2008/2010/2013

DBA: Database administration of MS SQL Server 2014, 2012, 2008, 2005, MS SQL Profiler, SQL Query Analyzer, MS SQL Server Index Tuning Wizard

Software Applications: MS SharePoint 2010, MS Office 2010, Norton Utilities, etc

Networking: TCP/IP, DNS, WINS, DHCP, FTP

Tools: Backup Utility, SQL Lite Speed, Visio, ERwin Data Modeler, SQL Server Data Tools, Power BI Desktop, Report Builder 3.0/2.0.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SQL Developer/MSBI

Responsibilities:

• Resolving tickets, writing complex queries, create and maintaining views, functions and stored procedures to/and build reports and add functionalities to an application.
• Develop documentations, supporting the creation and managing of an application routine process.
• Creating, deploying, monitor and maintain SQL jobs and reports for data accuracy/freshness.
• Writing relational and multidimensional database queries and complex SQL queries based on Support and Customer insights requests
• Highly skilled in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package Configurations, Logging, System and User-definedVariables for SSIS Packages.
• Working with application developers and administrators to eliminate bugs and fix preventable issues.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures. Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Created a CRM Entity Modification tool, functional diagrams, and workflow diagrams. Updated design documents as necessary to reflect changes necessitated by change requests and implementation issues (MS Dynamics CRM).
• Data integration management between core business applications and data lakes, data marts, and staging databases. Multi-dimensional cube modeling and reporting using (Data warehouse / data mart modeling and implementation).
• Design and Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them. Using MDX created calculated members for customized calculated measures.
• Involved in creating calculated members, named set, advanced KPI’S for theSSAScubes.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed dashboards and various operational interactive Drill-through, Drill-down, and linked reports, Sub Reports, Chars, Matrix reports, and Linked reports using SQL Server Data Tools, Report Builder and Power BI desktop.
• Defining and documenting data dictionaries as needed.

Environment: MS SQL Server 2016/2014/2012 , MS SSAS,SSIS, SSRS, Report Builder 3.0, T-SQL, Windows Server 2012, SQL Profiler, MS Office 2013, Power BI desktop, Erwin 9.6, SharePoint 2013

Confidential, Florida

SQL Developer

Responsibilities:

• Design, plan, implement and develop reporting and analytic solutions.
• Design, implement and develop data visualizations. Meet with business stakeholders to clarify and document reporting requirements.
• Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS, Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
• Involved in SSIS ETL Transformation for de-normalization of data sources using UNPIVOT and UNION.
• Creating, deploying, monitor and maintain SQL jobs and reports for data accuracy/freshness.
• Writing relational and multidimensional database queries and complex SQL queries based on Support and Customer insights requests
• Create Power BI reports and scorecards for business stakeholders and analyze data for insights and opportunities. Working with external BI teams for inquiries & data governance accuracy.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures. Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Created a CRM Entity Modification tool, functional diagrams, and workflow diagrams. Updated design documents as necessary to reflect changes necessitated by change requests and implementation issues (MS Dynamics CRM).
• Data integration management between core business applications and data lakes, data marts, and staging databases. Multi-dimensional cube modeling and reporting using (Data warehouse / data mart modeling and implementation).
• Design and Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them. Using MDX created calculated members for customized calculated measures.
• Involved in creating calculated members, named set, advanced KPI’S for theSSAScubes.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed dashboards and various operational interactive Drill-through, Drill-down, and linked reports, Sub Reports, Chars, Matrix reports, and Linked reports using SQL Server Data Tools, Report Builder and Power BI desktop.
• Defining and documenting data dictionaries as needed.

Environment: MS SQL Server 2016/2014/2012 , MS SSAS,SSIS, SSRS, Report Builder 3.0, T-SQL, Windows Server 2012, SQL Profiler, MS Office 2013, Power BI desktop, Erwin 9.6, SharePoint 2013

Confidential, Silver Spring, MD

SQL Developer

Responsibilities:

• Experience with all phases of software development life cycle (SDLC) and project methodologies
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources through ETL tool
• Multi-dimensional cube modeling and reporting using (Data warehouse / data mart modeling and implementation)
• Design and Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them
• Using MDX created calculated members for customized calculated measures
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
• Generated daily, weekly and monthly reports for the managers using SSRS
• Involved in creating calculated members, named set, advanced KPI’S for theSSAScubes.
• Conducted quantitative analysis of financial data to forecast revenue, identify future trends, and risk associated with capital expenditures by creating cubes (SSAS)
• Utilized pivot tables to provide structure to reports in proper format like months etc
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Created reports and scheduled using SSRS to support Financial Planner to deliver informational sales presentations to potential clients
• Developed various operational Drill-through, Drill-down, and linked reports using SSRS
• Developed different kind of reports such a Sub Reports, Chars, Matrix reports, and Linked reports
• Designed, deployed, and maintained of various SSRS Reports in SQL Server.

Environment: MS SQL Server 2016/2, MS SSAS,SSIS, SSRS, Crystal reports, T-SQL, MS Access, DTS, FTP, SQL Profiler, VB.Net, MS Excel, ASP.Net, Erwin 9.6, SharePoint 2013, Power BI desktop

Confidential, Addis Ababa, Ethiopia

Sql Developer

Responsibilities:

• Manage and resolve trouble tickets for database-related issues submitted by customers.
• Debugging of application and parsing theSQL query within the SQLIndex Tuning Wizard.
• Develop and maintain database functionality to support multiple SQL databases.
• ETL processes include migrating data from a DB2 database toSQL Server. Implemented high availability on the various servers usingreplication/mirroring.
• Performed routine DBA activities like backup and Data recovery, Data security, Data Migration, Performance Tuning, Data Integrity analysis, User Management, Creation of SSIS packages for data loading and applying service packs.
• Used stored procedure in a backup and restore process to copy data from Development node to a production node.
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Rebuilding / monitoring the indexes at regular intervals for better performance.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA), Disaster Recovery tools.
• Implemented Data partitioning, Error handling through try-catch statement, and CTEs.
• Day-to-Day administration of SQLServers on Standalone and Cluster Environments.
• Performing Health checks and monitoring performance of the Production Servers.
• Support enhancements and install bug fixes following proper scheduling.
• Strictly adhere to data security policies and procedures.

Environment: SQL Server 2008/2012 Enterprise Manger an SQL Profiler, Windows Enterprise Server 2012, .NET, Microsoft Visio, Microsoft Reporting Services, disaster recovery tools and technologies

SQL Developer

Responsibilities:

• Collected business requirements from users and translated them as technical specs and design docs for development.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc. on various database objects to obtain the required results.
• Used Data profiling task to analyze the quality of the customer data from various sources and created SSIS packages to store consistent data in central repository.
• 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.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Created different Parameterized Reports (SSRS 2005/2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Created Linked reports, Ad-hoc reports and etc. based on the requirement. Linked reports are created in the Report Server to reduce the repetition of the reports.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Used Merge in development, test and production for changing the referenced data.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.

Environment: SQL Server 2008/2008 R2/2005, .Net Framework 2.0, C#, .Net, Asp.Net2.0, JavaScript, Windows 2000, Windows 2003 Server, MS TFS, MS-Access.

Confidential

SQL Developer

Responsibilities:

• Experience with all phases of software development life cycle (SDLC) and project methodologies
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Designed and implemented complex SSIS package to migrate data from multiple data sources.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources through ETL tool
• Design and Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them
• Using MDX created calculated members for customized calculated measures
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
• Conducted quantitative analysis of financial data to forecast revenue, identify future trends, and risk associated with capital expenditures by creating cubes (SSAS)
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Created reports and scheduled using SSRS to support Financial Planner to deliver informational sales presentations to potential clients
• Developed various operational Drill-through, Drill-down, and linked reports using SSRS
• Developed different kind of reports such a Sub Reports, Chars, Matrix reports, and Linked reports
• Designed, deployed, and maintained of various SSRS Reports in SQL Server.

Environment: SQL Server 2005/2008, Windows 2008 Server, SQL DB Access, Performance Monitor, Backup Utility

Confidential

Network / Server Administrator

Responsibilities:

• Take a key role in the installation and administration of Windows Server 2008
• Updated and configured PCs with new hardware and other components.
• Installed Windows and configured to LAN with strong skills and experience
• Frequently tested and debugged in-house developed software.
• Visited client’s offices to ensure highest quality of service.
• Installing, configuring and administrating Windows Server 2003 and LAN infrastructures; maintaining and troubleshooting software and hardware’s.
• Implementing ICT management systems and strategies, effective functioning of hardware and software packages, networks administration and facilitation of knowledge building and knowledge sharing.
• Troubleshooting Software, Hardware and Network issues.
• Excellent communication, analytical, and problem-solving skills.
• Develop and hosting a dynamic website
• Installing, configuring and troubleshooting LAN/WAN networks.

Environment: Windows Server 2000/2003, MS Office 2003/2007, Windows 98/2000/XP