Taiye Ojo

Sanford, FL *****

404-***-**** addju4@r.postjobfree.com

MS SSRS Crystal Report

PenServ Plan Service, Inc. West Columbia, SC September 2018 – February 2020

Designed and implemented best practices for report development and deployment.

Developed from simple ad-hoc reports to complex multi-sub reports including dashboards.

Gather report requirements and develop effective communication line with report users.

Ability to develop new reports and optimized existing report both at the back-end query and front-end design layout.

Strong knowledge of both relational database concepts and multidimensional cube.

Experience in TSQL query including creating complex database and table joints using industry best practices.

Experience identifying, working with and securing PII and PHI data utilizing HIPAA best practices.

Ability to dive in, research and get familiar with existing business documentations and processes.

Experience in pivot table, v-lookup, h-lookup, data-table linking, sub-reports, drill down and summary reports, and cross-tab reports.

Create, deploy and execute SSIS packages to extract, transform and load data from a source to destination.

Experience using custom assembly to retrieve specialized functions to use in reports.

Train and assist users in generating reports and using prepared reports and templates.

Responsible for analyzing and interpreting data relevant to the core business operations to better align reporting solutions that are accurate and achievable.

Knowledge of Standard and Data Driven Subscription.

Experience working with users to resolve defects.

Experienced in Agile delivery methods – 2 or 3 weeks sprints.

MS BI SSRS Crystal Report

City of Boulder, CO.

Mondo, CO May 2018 – August 2018

Design and develop custom reports to meet the business needs using SSRS and Crystal Report tools.

Ability to create various types of reports including parameterized reports, linked reports, snapshot reports, cached reports, ad hoc reports, click through reports, drilldown reports, drill through reports, sub reports and more in SSRS and Crystal Report.

Maintained and enhanced existing reports including troubleshooting discrepancies in existing reports and suggest fixes.

Communicating with business users to help identify requirement and develop solutions to meet business needs.

Ability to effectively translate user requests into reporting specifications.

Assist users in creating report specifications and quickly gaining good understanding of current business metrics.

Experience in closely working with business users to gather the requirements and work with technical team to understand dataset and data source.

Analyzed and developed reports to satisfy design requirements from other departments and external clients.

Ability to independently dive in and research fields, tables, and database with less supervision or guidance.

Knowledge of PowerView, PowerPivot, Power Map, and Power Query.

Knowledge of Power BI to develop interactive data visualizations using drag and drop canvas. knowledge of DAX, MDX, relational and multidimensional database concepts.

Strong analytical and problem-solving skills. Aptitude for innovation, working independently and thinking "outside the box".

Experience working in an agile environment with scrum, planning, continuous integration.

Ability to work under pressure and to independently handle multiple projects and deadlines

Maintained and organized report suite and ad-hoc SQL scripts; including developing and optimizing custom reports, SQL Scripts and queries.

Analyze feedback; develop and implement strategies for improvement.

Ability and willingness to learn new applications and business processes.

MS SSIS SSRS Developer

United States Dept. of Agriculture – APHIS, Fort Collins, CO. May 2015 – May 2017

Developed custom SQL queries to extract, manipulate, and calculate data to fulfill reporting requirements.

Ability to interact with report users (veterinary physician) to identify report needs and effectively translate those requirements into meaningful technical specifications.

Strong experience in designing reports from the scratch or enhance existing reports.

Ability to create simple to complex SSRS reports utilizing industry standard and practices.

Created adhoc reports, executive dashboards, subreport, embedded reports, summary report, dynamic matrix, lists, advance charts, pivot table, cross tab etc.

Experienced in independently gathering report requirements needed to design and develop reports for users of all levels including top management.

Ability to listen and the experience in quickly understanding business needs and expectations.

Maintained report repository and report deployments in Microsoft Dynamics CRM.

Test reports to ensure accuracy in line with business user requirements.

Perform code review and validate completed reports with users.

Experience working with multiple databases and difference report models.

Utilized SSIS packages in performing ETL tasks related to data transformation.

Worked with data warehouse team to ensure data required for reporting needs are captured in the enterprise data warehouse.

Performed report distribution to various destinations like Microsoft excel, PDF, RTF, CSV, TTX, XML, CRM Dynamics, HTML and directly to email with attachment (.rdl files).

Created data driven PDF in SSRS and Reporting Viewer Control.

Experience using custom assembly to retrieve specialized functions to use in reports.

Designed and maintained database report using Microsoft office excel and access.

Used visual studio to perform a broad range of data migration tasks from multiple sources.

Used report manager to handle securities; and apply security to files and folders.

Performed Analytical and Operational reporting services.

MS SSRS Crystal Report Writer

DSL Edmonton, Canada January 2013 – May 2015

Proficient in SSRS/Crystal Report writing- created simple to complex report projects.

Designed and maintained database report using Microsoft office excel and access.

Developed custom SQL queries to extract, manipulate, and calculate data to fulfill reporting requirements.

Ability to comprehend business needs and transform them into technical specifications.

Optimize existing report and dashboard settings to meet users and management’s day to day reporting needs.

Strong knowledge of relational database concepts. Used data-table-linking and visual linked tables and performed complex joints.

Gather report requirements needed to design and distribute reports to users and top management.

Test reports and dashboards to ensure accuracy in consonance with corporate laid down procedures.

Experience in pivot table, v-lookup, h-lookup, data-table linking, sub-reports, drill down and summary reports, and cross-tab reports.

Knowledge of various Database Connections Expert: Access/Excel (DAO), ADO.NET (XML), ODBC (RDO), OLAP, OLE DB (ADO), Database files etc.

Designs, builds and tests SSIS data transformation packages.

Managed data sources, datasets, report data pane and publish report to the report server.

Experience documenting report development and deployment process.

Used visual studio to perform a broad range of data migration tasks from multiple sources including MS SQL Server, MS Access/Excel, flat files etc.

Used report manager to handle securities; and apply security to files and folders.

Knowledge of ticketing system like service Now and Remedy

Train and assist users in generating reports and utilizing prepared reports and templates.

Create calculated fields, dynamic grouping and field sorting, embedded formulas, running grand and sub totals.

Designed Sub-report, drill down and summary reports, cross-tab reports, and parameterized reports including Ad-hoc reports.

Used T-SQL to create queries to extract, manipulate and calculate data to fulfill reporting requirements.

Responsible for analyzing and interpreting data relevant to the core business operations to better align reporting solutions that are accurate and achievable.

Database Administrator (Microsoft Certification ID: 10223730)

Mckesson ALBING Engineering -AEG Resources Los Angeles CA. July 2011 – December 2012

Install, configure, and manage Microsoft SQL database. Responsible for database size between 750 GB and 1 TB.

Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.

Provide administrative support on production, development and test servers.

Database monitoring and tuning including optimizing query.

Responsible for daily, weekly, monthly and quarterly system check.

Proactively monitor, identify, and resolved server problems to avoid impact on the business.

High volume transaction monitoring, detecting lock contentions (lock and blocks).

Created DTS Packages for data import and export and scheduled jobs for backups.

Create and manage SQL server logins and server roles, user and database roles; and ownership chains.

Support developers in optimizing database objects, stored procedures, triggers, views and functions.

Schedule Jobs and Alerts using SQL Server Agent including monitoring scheduled job.

Job scheduling and monitoring.

Partner with application architects and developers to design and implement designs while ensuring that all expected results are delivered to end customer.

Strong experience in performance tuning, database optimization, disaster recovery and database security.

Partner with operational DBAs to ensure database performance, reliability and SLAs are met.

Document all application database designs and processes.

Perform database tuning using the tuning advisor and other third party tools.

Analyze queries and other performance bottlenecks that may be related to the database tier.

Responsible for applying and testing patches.

Proven analytical, evaluative, and problem-solving abilities.

Working experience with change management and configuration policies.

TECHNICAL SKILLS SUMMARY

Microsoft SQL Server 2008, 2008R2, 2012, 2014 and 2016.

MS SQL Report Services (SSRS) 2008, 2008R2, 2012, 2014 and 2016.

MS SQL Integration Services (SSIS) 2008, 2008R2, 2012, 2014 and 2016.

MS SQL Analysis Services (SSAS) 2008, 2008R2, 2012, 2014 and 2016.

Microsoft Office Suite XP, 2003, 2007, 2010, 2013 and 2016.

Visual Studio 2012, 2013, 2015, and 2017

Crystal Report 2008, 2011 and 2013

Microsoft CRM Dynamics 2013 and 2016

Microsoft Power BI

Windows 2008 and 2012 Server.

Microsoft Share points.

Relius

EDUCATION/ TRAINING

Colorado State University, Graduate School- College of Business. Fort Collins, Colorado.

Professional MBA – December 2019. Business Administration (In Progress)

Georgia State University, Robinson College of Business, Atlanta, Georgia – May 2011

Bachelor of Business Administration, Major: Managerial Science. (Completed)

Georgia Perimeter College, Georgia.

Associate of Science Degree, Major: Business Administration. (Completed)

Further Training: New Horizons Computer learning Center.

Implementing SQL Data Warehouse – 2017 - 2018

Developing SQL Data Models – 2017 - 2018

Alpha Beta Gamma- International Business Honors.

Dean’s List.

CERTIFICATION

Top Secret Clearance (Current).

Microsoft Certified IT Professional ID: 10223730:

PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 [E359-8186]

Microsoft SQL Server 2008, Implementation and Maintenance [E359-2901]

Georgia State Property and Casualty License:

State Licensed ID: 726431.

References available upon request

Contact this candidate