| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Atlanta, GAEMAIL AVAILABLEPhone # PHONE NUMBER AVAILABLEProfessional 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/19Excellent 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 measuresStrong 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 / CertificationsCertificate in SQL BI/EDW Colaberry School of Data Analytics (TX, United States)SAP BW/ HANA BI CONSULTANT GROUPBachelor of Science Degree in Geography and Regional Planning. Delta State University, NigeriaTechnical Competencies:Operating Systems & EnvironmentsServer 2012/2014/2016Databases (RDMS)SQL Server 2012/2014/2016, MySQL, Access, Oracle 9i,SAP HANA,Snowflake,Azure SQLAdministrative, Modeling, Tuning & TroubleshootingSQL Server Management Studio (SSMS), SQL Profiler, SQL Server Agent, Windows SchedulerBusiness IntelligenceSSIS, Integration Services Catalogs, Power BI, Import/Export Wizard, SSAS, SSRS, Report Manager, Report Builder, SAP BWIntegrated Development EnvironmentsSQL Server Business Intelligence Development Studio (BIDS), Visual Studio 2015/2016, SAP BWLanguagesT-SQL, C, VBScript, DAXSource ControlTeam Foundation Server (TFS),JIRA, Azure DevOpsProfessional Experience:GRIFFIN GLOBAL TECHDates: JULY 2023 to DateRole: Power BI EngineerResponsibilities: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 BICreated 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 ReportsWorked with data modelers in building SSAS Tabular model for report development in Power BIExperience working with analysis services, Snowflake, Azure Database, Share Point, SQL databases, and data warehouses in creating reports in Power BIModeled data into Star and Snowflake schemas to meet specific requirements and business logicUsed 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 reportingMaintained existing database and BI systemsCarried 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 IssuesWorked with Business Analyst in requirements Gathering.Insight Global (DirecTV)Dates: May 2022 to DateRole: Senior Power BI DeveloperResponsibilities: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 reportsCreated 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 AccuracyDeveloped 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 ServicesDates: Jan 2021 May 2022Role: Data Report DeveloperResponsibilities: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 SolutionsDates: Jan 2016 Jan 2021Role: Power BI/SQL DeveloperResponsibilities: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 userInvolved in planning, defining, and designing database based on the business requirements documentImplemented 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 ConsultDates: APR 2014 DEC 2015Role: 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 troubleshootingPerformed capacity planning and growth prediction for client audit dataQuery tuning based on query execution plans, statistics, and profilingCreated code based solution for application error involving composite key manipulationCoded optimization objects including hierarchical flattening functions, strategic indexes, and staging tables as well as data and file partitioningWorked 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 performanceCreated XML schemas to update user tables and system objects for company data dictionaryServed 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 2013ROLE: ERP Functional ConsultantResponsibilities:Provide solutions to meet the need of clients.Conduct baseline requirement definitionsPerform baseline requirement definitions analysisCoordinate Oracle and SAP application configurationProvide status report on work doneMaintain positive collaboration with other Consultants and support Staff.Constantly looking for ways to add value to the ClientHOBBIESSwimming, reading, singing, meeting people and surfing the internetREFERENCES.To Be Presented on Demand |
