Resume

Sign in

Microsoft Office Sql Server

Location:
Fort Collins, Colorado, United States
Posted:
December 28, 2017

Contact this candidate

Resume:

Taiye Ojo

**** **** **., **** *******, CO *****

404-***-****

ac3uah@r.postjobfree.com

MS SSRS Crystal Report Developer

United States Department of Agriculture – APHIS, Fort Collins, CO. Quantum Infotech/Technik IT Solutions. May 2015 – May 2017

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

Experience working with business as an analyst to develop report requirements.

Ability to design reports from the scratch or enhance existing reports.

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

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 distribute reports to users and top management.

Maintained report repository and report deployments in Microsoft Dynamics CRM.

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

Tested reports to ensure accuracy in consonance with corporate laid down procedures.

Created new report from scratch; modify and optimize existing reports.

Designed Ad-Hoc reporting, access database including report models for multiple users.

Microsoft SQL Server Integration Services SSIS: creating, deploying and executing packages including ETL.

Create reports for users and perform data analysis to ensure data meets users’ need including translating underlying data into beautiful sensible Tableau visualizations.

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

Experience with Tableau in analyzing financial data and understand demand forecast and trend.

Performed report distribution to various destinations like Microsoft excel, PDF, RTF, CSV, TTX, XML, crystal report read only, HTML and directly to email.

Experience creating Report Viewer and Exported PDF. Created data driven PDF in SSRS and Reporting Viewer Control.

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

ProV International IT Service 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.

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

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.

Generate PDF files from reporting services report viewer control.

Designs, builds and tests SSIS data transformation packages

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

Microsoft SQL Server Integration Services SSIS: creating, deploying and executing packages including ETL.

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 2010 – 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.

Working experience with VMware – virtualization of MSSQL.

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.

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

Crystal Report 2008, 2011 and 2013

Microsoft CRM Dynamics 2013 and 2016

Microsoft Access database / Microsoft Excel

Tableau Version 9.3 – 10.3

Microsoft Power BI

Windows 2008 and 2012 Server.

MS Share points.

EDUCATION

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

Professional MBA – December 2018.

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

Bachelor of Business Administration, Major: Managerial Science.

Georgia Perimeter College, Georgia.

Associate of Science Degree, Major: Business Administration.

Alpha Beta Gamma- International Business Honors.

Dean’s List.

CERTIFICATION

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