Sql Server Software Development

kragha efe

Atlanta, GA

***********@*****.***

Phone # 404-***-****

Professional Summary:

An Information Technology professional possessing a thorough understanding of the software development life cycle (SDLC) including requirement analysis, requirement gathering, design, development, implementation and testing and deployment with over 5 years of experience as a Microsoft Business Intelligence Developer. A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem-solving skills able to quickly adapt into the given role and deliver results early.

Familiar and very experienced with the Agile Methodology of Software Development.

Strong experience in using the Microsoft BI Stack (SSIS, SSRS, SSAS and SQL). Worked with SQL server 2012/14/16/19

Excellent backend skills in creating SQL objects such as Tables, Complex Stored Procedures, Effective Functions, Views, Indexes, Triggers, Rules and SQL Performance Tuning to facilitate efficient data manipulation and consistency.

Experienced in creating complex SSIS and DTS packages for ETL purposes. Data Migration from various type of sources (Excel, flat file, csv, XML, OLTP DB etc.), Data Conversions, Data Extraction/ Transformation/Loading (ETL) using DTS and SQL Scripts.

Experience in configuring SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors. Expert in troubleshooting SSIS packages using a variety of techniques/tools.

Experience in designing and developing considerable number of reports in SSRS using the data from ETL Loads, Proficient in developing Drill through and Drill down reports, parameterized reports, Linked reports, Sub reports, Matrix reports, and Chart reports using MS SQL Server Reporting Services (SSRS)

Good understanding of SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.

Experience in Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS)

Created OLAP applications with OLAP services in SQL Server and built multi-dimensional cubes.

Knowledge of Azure Fundamentals,

Good knowledge of Data Marts, operational data store (ODS), OLAP, Star schema modeling, Snowflake modeling for fact and Dimension tables.

Experience in Microsoft Power BI Suite (Power Query, Power Pivot, Power BI Pro, Power BI Desktop), Microsoft Excel Pivot Table, and Data Models to gather information from multiple sources and deliver information to the end user.

Working knowledge of building statistical KPI reporting dashboards with predictive analysis.

Excellent DAX Skills and the ability to create and troubleshoot complex calculations and measures

Strong troubleshooting and problem-solving skills. Strong ability to prioritize multiple tasks.

Excellent communication skills, proactive, self-managing and teamwork spirits.

Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem-solving skills.

Education / Certifications

Certificate in SQL BI/EDW – Colaberry School of Data Analytics (TX, United States)

SAP BW/ HANA – BI CONSULTANT GROUP

Bachelor of Science Degree in Geography and Regional Planning. – Delta State University, Nigeria

Technical Competencies:

Operating Systems & Environments

Server 2012/2014/2016

Databases (RDMS)

SQL Server 2012/2014/2016, MySQL, Access, Oracle 9i,SAP HANA,Snowflake,Azure SQL

Administrative, Modeling, Tuning & Troubleshooting

SQL Server Management Studio (SSMS), SQL Profiler, SQL Server Agent, Windows Scheduler

Business Intelligence

SSIS, Integration Services Catalogs, Power BI, Import/Export Wizard, SSAS, SSRS, Report Manager, Report Builder, SAP BW

Integrated Development Environments

SQL Server Business Intelligence Development Studio (BIDS), Visual Studio 2015/2016, SAP BW

Languages

T-SQL, C, VBScript, DAX

Source Control

Team Foundation Server (TFS),JIRA, Azure DevOps

Professional Experience:

GRIFFIN GLOBAL TECH

Dates: JULY 2023 to Date

Role: Power BI Engineer

Responsibilities:

Successfully Implemented over 6 Power BI Projects from Scratch for Various Clients,

Optimized engineering processes by implementing innovative solutions and streamlining workflow.

Reduced project completion time with efficient resource allocation and effective communication strategies.

Collaborated on interdisciplinary teams to develop creative, cost-effective solutions for complex projects.

Enhanced product performance by conducting thorough failure analysis and recommending improvements.

Participated in regular code reviews, ensuring high-quality standards were consistently met across all development efforts.

Worked closely with clients to gather requirements and translate them into technical specifications for implementation.

Built data visualization Dashboards and Reports using Microsoft Power BI

Created reports and dashboards in Microsoft Power BI with visuals that track KPIs.

Migrated SSRS Paginated Reports from Legacy Systems into Power BI.

Converted Existing Tableau Reports to Power BI Reports

Worked with data modelers in building SSAS Tabular model for report development in Power BI

Experience working with analysis services, Snowflake, Azure Database, Share Point, SQL databases, and data warehouses in creating reports in Power BI

Modeled data into Star and Snowflake schemas to meet specific requirements and business logic

Used Data Analysis Expressions (DAX) in creating calculated measures, columns, and filters in Power BI and SSAS tabular model used in report creation.

Create views, stored procedures, CTEs, and functions using TSQL, which was used extensively in optimizing data extraction and performance optimization.

Used Power Query to clean, shape, transform, and model data to meet business requirements for reporting

Maintained existing database and BI systems

Carried out performance tuning and worked with Back-end developers to review stored procedures to improve performance.

Worked closely with key customers to troubleshoot and resolve data and report related Issues

Worked with Business Analyst in requirements Gathering.

Insight Global (DirecTV)

Dates: May 2022 to Date

Role: Senior Power BI Developer

Responsibilities:

Wrote and optimized SQL statements to assist business intelligence practices.

Monitored assessment software for performance, security and database availability throughout lifecycle.

Assessed platform statistics to create customized, data-intensive BI analytics.

Designed customized data collection models for specific visualization tasks.

Involved in creation of various Business Intelligence/ Analytical Dashboards utilizing Power BI with global filters, calculated columns and measures using complex DAX calculations and transformations using Query Editor & Power Query Formula Language (M).

Worked on Power BI dashboards using stacked bars, bar graphs, scattered plots, waterfall charts, geographical maps, Gantt charts using show me functionality.

Publishing of various kinds of live interactive data visualization dashboard reports and workbooks from Power BI Desktop to Power BI servers.

Implemented Role Level Security and Incremental refresh on created dashboards and reports

Created Workspace and Apps for effective management and sharing of reports and dashboards.

Managed a repository of re-usable data visualization templates and views.

Supported the Business Intelligence/Analytics data analyst with the understanding of business and data requirements and iteratively designs visualizations for initial concepts and prototypes that can be presented to customers for feedback.

Conducted Training sessions for Power BI users and created the documents for end users.

Transformed Large datasets and complex data structures.

Made use of M Language and Data Query for data cleansing and transformation.

Collaborated with Stakeholders to gather requirements and create Business requirement documents.

Designed, developed, and maintained ETL Processes when required.

Testing and Debugging ETL processes to ensure Data Accuracy

Developed intelligence-sharing dashboards, providing company-wide access to collected data.

Directed implementation of new business intelligence tools, selecting appropriate solutions, and aiding in corresponding onboarding processes.

Collected data from wide-ranging sources. like Snowflakes, ServiceNow, Azure, Microsoft SQL Database etc.

Liaised with DevOps team to integrate business intelligence assets into future development lifecycles.

Developed and managed dashboards using Power BI and SSRS.

Generated reports updated spreadsheets and presented results.

Planned, designed and implemented diverse business intelligence solutions.

CO-OP Financial Services

Dates: Jan 2021 – May 2022

Role: Data Report Developer

Responsibilities:

Work independently, provide guidance and training to other data reporting developers, as well assist and lead strategic projects as related to data reporting, data triage, master data management, and other related data initiatives.

Lead medium to larger enterprise level data reporting projects and provide recommendations on building enterprise and client solutions that drive value.

closely partners with business, operational teams and clients to meet the needs for data and reporting in multiple platforms including recurring data extracts, SQL Server Reporting Services (SSRS) reports and Power BI data visualizations, as well lead the distribution strategy for data and report delivery.

Transform business and client data requirements into meaningful data extracts, reports and data visualizations while meeting CO-OP marketing and client user experience standards. Identify gaps and recommend best practices where opportunities exist to streamline or enhance business and client data and reporting needs.

Conduct reviews of peer data and reporting development to ensure solutions meet PCI and other regulation standards, are built for performance and meet development best practices.

Develop enterprise and client level reporting solutions in Powe BI and SSRS.

Design and create enterprise level report delivery solutions within Power BI and SSRS that support both CO-OPs internal needs as well as client needs.

Document development efforts as required by CO-OP change management practices.

Develop and design solutions with security as a critical design requirement for data, systems, and applications. Ensure all development work is reviewed by a senior peer.

Adhere to Agile principles and philosophies (Scrum or Kanban, as applicable) in fulfillment of the role.

Collaborate within the direct team in accordance with Team Agreement, Definition of Ready, and Definition of Done.

Work as a cross-functional team member in an Agile setting to help complete and deliver the team commitments.

Collaborate across teams and across business areas in the spirit of an Agile mindset.

Fulfill the role in the spirit of the Agile Manifesto, with emphasis on delivery of incremental value with frequent iterations and feedback loops.

Regular and reliable attendance.

Responsible for reporting risks that are identified to the appropriate team and/or management. Additionally, responsible for managing, monitoring and reporting risks within the scope of your work area, to include, but not limited to Information Security risks.

Mortek Solutions

Dates: Jan 2016 – Jan 2021

Role: Power BI/SQL Developer

Responsibilities:

Worked with business teams to gain a rich understanding of their business, analytical, and reporting needs, including the identification of critical metrics.

Performed detailed data analysis to determine the structure, content, and quality of the data through examination of source systems and data samples.

Worked closely with a team of technical and non-technical staff and consultants to iterate through versions of the deliverables.

Involved in creation of various Business Intelligence/ Analytical Dashboards utilizing Power BI with global filters, calculated columns and measures using complex DAX calculations and transformations using Query Editor & Power Query Formula Language (M).

Worked on Power BI dashboards using stacked bars, bar graphs, scattered plots, waterfall charts, geographical maps, Gantt charts using show me functionality.

Publishing of various kinds of live interactive data visualization dashboard reports and workbooks from Power BI Desktop to Power BI servers.

Managed a repository of re-usable data visualization templates and views.

Supported the Business Intelligence/Analytics data analyst with the understanding of business and data requirements and iteratively designs visualizations for initial concepts and prototypes that can be presented to customers for feedback.

Conducted Training sessions for Power BI users and created the documents for end user

Involved in planning, defining, and designing database based on the business requirements document

Implemented after insert, update and delete triggers to simultaneously populate multiple tables at once.

Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.

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

Created SSIS packages to extract the data from multiple sources like Excel, XML and OLTP and consolidate them into staging tables.

Maintained SSIS packages for production and test environment for incoming source application files.

Scheduling Jobs and Alerting using SQL Server Agent.

Used Merge statement in SQL to only populate data warehouse tables with non-existing records.

Used script component in SSIS (utilizing C# script) in order to validate source columns for each package.

Used multiple SSIS transformations such as: data conversion, derived column, conditional split to cleanse and validate data.

Mac Jason Consult

Dates: APR 2014 – DEC 2015

Role: ETL Developer.

Responsibilities:

Database development utilizing Microsoft SQL Server OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation, and Loading). Database Administration including, backups, recovery, database maintenance.

Handled development for reporting team involving coding, security, code reviews, metadata implementation, and replication troubleshooting

Performed capacity planning and growth prediction for client audit data

Query tuning based on query execution plans, statistics, and profiling

Created code based solution for application error involving composite key manipulation

Coded optimization objects including hierarchical flattening functions, strategic indexes, and staging tables as well as data and file partitioning

Worked with development teams in the design of physical databases and in modification..

Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.

Proficient in SSIS process design architecting the flow of data from various sources to target.

Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases .

Designed SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.

Generated and Deployed ETL SSIS packages both design and code to process data to target databases.

Used efficient task objects/connections/work flows in packages based on data volumes and data sources.

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

Created XML schemas to update user tables and system objects for company data dictionary

Served as a team member in Project Management and Software Development Life Cycle (SDLC) including analysis of business function, testing and documentation, and planning for redesign or transition to another platform.

Tools and Technologies:

SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), ETL, SSAS, XML, MS Excel, Agile.

Norahome System ‘N’ Solutions Ltd. FEB 2010 – MAY 2013

ROLE: ERP Functional Consultant

Responsibilities:

Provide solutions to meet the need of clients.

Conduct baseline requirement definitions

Perform baseline requirement definitions analysis

Coordinate Oracle and SAP application configuration

Provide status report on work done

Maintain positive collaboration with other Consultants and support Staff.

Constantly looking for ways to add value to the Client

HOBBIES

Swimming, reading, singing, meeting people and surfing the internet

REFERENCES

.

To Be Presented on Demand

Contact this candidate