| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
SUMMARY15+ years of programming, database design (logical and physical), development, testing and implementation.15+ years of cumulative experience working with MS SQL Server 2008, 2008R2, 2012, 2014, 2016 and 2017, Oracle.Experience with .Net Technologies (.NET Framework, MS Visual Studio .NET, ADO .NET, ASP.NET MVC, VB.NET, C#)15+ years of experience working with Microsoft Access and Excel.15+ years of experience working with the Microsoft Visual Studio Platform.7+ years of experience using Power BI5+ years of experience using Cloud platforms and technologies like Microsoft AZURE, HadoopExperience in application development using Microsoft .NET, Informix and Oracle data management and enterprise-wide application development software as well as several leading third generation programming languages.Very proficient with Microsoft Visual Basic, C#, SQL, Python, and Transact-SQLIn-depth knowledge and experience of writing SQL and T-SQL script modules, simple to complex stored procedures, triggers, self-join queries, error handling codes, etc.Experienced in migrating from SQL Server 2000 to SQL Server 2012.Experienced in migrating from Microsoft Access to SQL Server, Oracle, MySQL, Dbase and vice versa.Microsoft Certified Professional in Querying Microsoft SQL Server 2012In-depth knowledge and experience of Financial, Accounting, Payroll and Fiscal information systems analysis and modeling.COMPUTER SKILLSLanguagesProficient With: Microsoft Visual Basic, C#, SQL, Transact-SQL, DAX and MDX, Python, RFamiliar with Microsoft Visual C, C CSS, Java,SoftwareDevelopment Platform: Microsoft Visual StudioData Manipulation Tools: Power BI, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Data Tools (SSDT), SQL Server Management Studio (SSMS), HadoopDatabase Management System: Microsoft SQL Server, Microsoft Access, ORACLE, MySQL, DB2, AZUREOperating Systems: Microsoft Windows (XP/Vista/7/8/10), Microsoft Windows Server 2012 R2EXPERIENCEBusiness Intelligence Consultant for Insight Global Apr 2021 - PresentAs a PowerBI SME assigned to Octo Consulting Group, I lead a team of 4 to build a PowerBI dashboard to assess performance of all services at the U.S. Department of Health & Human Services.In addition, I lead my team to migrate Octos data warehouse to the cloud using AZURE technologies.Duties and responsibilities include (but is not limited to):Collected business requirements from users (mainly data team that were keeping manual legacy Excel reports) and converting them into technical requirements for the BI team.Build multiple PowerBI dashboards from scratch to support client.Wrote simple to complex DAX queries to compute data.Trained the client team on how to maintain and administer dashboards.Created a Microsoft Azure SQL Database for Octo Consulting Group.Leveraged Azure Data Factory (a cloud ETL service) to migrate data from Octos on-prem database to the cloud.Business Intelligence Architect for Amur Equipment Finance Sept 2019 March 2021For the Sales department, I built a Vendor Dossier dashboard, a reporting application by which the Sales department could assess all vendors bringing business to the company by measuring their performance over a period. This dashboard helped identity and eliminate poor performing vendors while incentivizing good performing ones.Duties and responsibilities included (but, not limited to):Collected business requirements from stake holders and converting them into technical requirements for the BI team.Build a new SQL Server 2014 Datawarehouse from scratch.Developed core functionality with the ASP.NET MVC Framework (C#, ASP.NET)Wrote complex queries: including views, stored procedures, functions, and triggers.Developed new ETL solutions using SSIS.Developed BI solutions using SSRS, SSASBuilt dashboards using Power BI.Wrote simple to complex DAX queries to create calculated columns, calculated tables, and measures SSAS cubes and PowerBI models.Wrote simple to complex Python scripts to support our predictive models.Design and Developed Web Services using ASP.Net, Web API.Troubleshooted existing Databases, ETL and BI solutionsUsed Hadoop and Python to process business data to and from AWS cloud platform for predictive analysis and machine learning to support the Customer service department.Business Intelligence Architect for Mariner Finance Mar 2018 - Jul 2019As a contractor, I helped build a new SQL Server 2014 data warehouse which helped the company achieve its goal of keeping a single source of truth for all financial reporting as opposed to the multiple redundant sources, error prone reporting system they were struggling with before I joined their data team.Duties and responsibilities included (but, not limited to):Collected business requirements from stake holders (mainly accountants, sales representatives) and converting them into technical requirements for the BI team.Performed dimensional data modeling and data mapping.Wrote complex queries: including views, stored procedures, functions, and triggers.Developed new ETL solutions using SSIS 2017Developed BI solutions using SSRS 2017, SSAS 2017, Excel with Power PivotBuilt dashboards using Power BIWrote simple to complex DAX queries to compute data.Troubleshooted existing Databases, ETL and BI solutionsTook turn with teammates on a weekly basis to maintain Night Operation Automated Jobs.Document solution in JIRAPerform code versioning with GitKrakenUsed Hadoop and Python to process business data to and from AWS cloud platform for predictive analysis and machine learning to support the Customer service department.Database Developer for Convergenz Mar 2017- Feb 2018As a contractor assigned to the Federal Aviation Administration, my main mission was to troubleshoot and improve existing database infrastructure to make reports faster.Duties and responsibilities included (but, not limited to):Performed dimensional data modeling and data mapping.Wrote complex queries: including views, stored procedures, functions, and triggers.Developed new ETL solutions using SSIS 2016Developed BI solutions using SSRS 2016, SSAS 2016, Excel with Power PivotBuilt dashboards using Power BIWrote simple to complex DAX queries to compute data.Document solution in JIRAPerform code versioning with GITETL Engineer for Robert Half Technology May 2015- Feb 2017As a contractor, I helped develop the business intelligence infrastructure (Data warehouse, SSAS cubes, SSRS Reports) of client Bacchus Importers which improved the decision-making process of their Accounting and Sales department.Duties and responsibilities included (but, not limited to):Leading a team of 4 database junior developers through the steps required to deliver a robust BI solution (Analysis and data mapping, data warehouse development, ETL work, Cubes design and dashboard design).Conducting weekly or bi-weekly peer review meetings to coordinate and stimulate team efforts.Designed and developed multiple modules using .NET MVC 4.0Collecting business requirements from clients and converting them into technical requirements for the BI team.Providing data analysis, database design, programming (C#), testing and implementation support to the development team.Analyzed, designed & developed large scale distributed system using .NETCoordinating with database administrators staff regarding data warehouse development, migration of data either manually or using ETL (Extract, Transform and Load) processes, revision and update of data marts and cubes, procedure development, troubleshooting, system configuration, security administration, and account setup.Developing data models and data maps for data warehouse system.Developing processes and applications for centralization and transformation of data from local agencies-wide systems to the data warehouse system using SSDT and SSMS.Implemented input validation using the ASP.NET Input Validation Controls.Writing SQL and T-SQL script modules involving simple to complex functions, stored procedure, triggers, self-join queries and error handling codes in both SQL and T-SQL.Developing and maintaining data marts, data cubes, queries, and reports.Assisting end users and programmers with data warehouse related issues like data source connections with the ADO.NET technology (C#), report design, subscription and data import/export from/to Microsoft Excel Worksheets using SSRS and SSMS or code.Initiates processes and documentation of data warehousing system; develops procedures to ensure security and integrity of data.Keeping current with the latest technology by self-training and performing Microsoft TechNet virtual lab.Providing effective recommendations for the overall information system upkeep.BI Developer for VA Data Center Jun 2010 - Apr 2015As a full-time employee working for the data team, I mostly helped maintaining and optimizing existing database and reporting infrastructure which overtime significantly reduced the downtime in business operation.Duties and responsibilities included (but, not limited to):Collecting business requirements from stake holders (mainly accountants and sales representative) and converting them into technical requirements for the BI team.Providing data analysis, database design, programming, testing and implementation support to the development team.Developing data models and data maps for data warehouse system.Writing SQL and T-SQL script modules involving simple to complex functions, stored procedure, triggers, self-join queries and error handling codes in both SQL and T-SQL.Involve in bug fixing, production support issue of previously developed Windows application using Win forms, C#, VB.NETDeveloping and maintaining data marts, data cubes, queries, and reports using ORACLE tools.Develop ETL processes to transfer data from production databases to the data stage.Perform data cleansing operation on data stage and transferring cleansed data to the data warehouse.Designing tabular and multidimensional applications to support reporting activities.Browsing OLAP cubes with Microsoft Excel and Power Pivot.Designing reports and dashboards with SSDT, Report Builder and Crystal Report.Keeping current with the latest technology by self-training and performing Microsoft TechNet virtual lab.Providing effective recommendations for the overall information system upkeep.EDUCATIONUniversity of Maryland University College, College Park Maryland 2019Master of Science in Data AnalyticsUniversity of Maryland University College, College Park Maryland 2016Bachelors Degree in Computer ScienceUniversity Institute of Technology Ngaoundere, Cameroon 2004Associate degree in Computer EngineeringCERTIFICATIONSMicrosoft Certified Professional 2014 Exam 461 Querying Microsoft SQL Server 2012Microsoft Technology Associate 2013 Exam 361 Software Development Fundamentals Exam 364 Database Fundamentals |
