SUMMARY

• Motivated professional who possesses a high degree of integrity and a willingness to assume responsibility.
• Ability to work independently or as a team member and manage complex projects to successful end.
• Well - organized problem solver who enjoys challenges. Skilled at applying a logical common sense approach to practical solutions.
• Communicate effectively when dealing with people of diverse interest and levels of authority.
• Diplomatic and tactful with professionals and non-professionals at all levels. Excellent organizational skills.
• Outstanding team player. Strong analytical and troubleshooting skills.
• Expert in the development in SSRS, Power BI, SAP Crystal Reports, dashboards and cubes, implementation of models and complex automatic reports. Managed reports subscriptions.
• Gather requirements, design, create, deploy, and support reports dashboards and cubes.
• Expert knowledge of People Tools and SQL.
• Advanced Excel skills. PowerPivot, PivotTable, Macros, VB, Lookups.
• Thorough knowledge of tables, data, and relational architecture of the PeopleSoft database.
• Database and Data warehouse administration and management. DB2, MS SQL Server, MySQL.
• Web-design and development database driven websites.

TECHNICAL SKILLS

• SQL Server 2014, SSRS, SSIS, SSAS, Visual Studio 2012 / 2013, SQL, T-SQL, PL/SQL, ETL, Tableau, SAP Crystal Reports, Cognos, SPSS, TM1, SCALE, Netezza, Team Foundation Server 2012, HRIS, Power BI, Birst, ILS, CLUE
• OLAP/MDX, Data Marts, Slicer Dicer, Clarity, Reporting Workbench, CDW, Clarity, Radar Dashboards, PeopleSoft HCM, People Tools 8.4x, SQL Server 2012, PS Query, nVision, SQR, Nolij, Soft Point, TruckMate 2015, MASS 500, Share Point
• PC Miler 25, XML, Brio, SAS, Sakai, Blackboard, ASP.NET, Visual Basic, C#, Easytrieve, ANSI C, COBOL, CICS, HTML, DHTML, CSS, ASP, JavaScript, MS Office, PowerPivot, Studio MX, Photoshop 4.0, Flash 4, MS Front Page, MS Access, MS Project 2016, Free Hand 8, Net Ware 5.0.
• Oracle, DB2, MS SQL Server, MySQL.
• Configuration and Troubleshooting, Installation, Upgrading and Diagnostics.

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. Database and BI Developer

Responsibilities:

• Provided daily application support, reports and dashboards development and modification for Softeon - Oracle, SQL, SSRS, ETL architecture and data modeling.
• Project Lead on converting CR reports to SSRS. Team Foundation Server 2012, SSIS.
• Developed Stored Procedures, Queries, Functions, Triggers and Complex Automated Reports. TFS, ETL, SQL Server 2014, SQL, SSRS, SSIS, Power BI, Visual Studio 2010.
• Design and develop data analysis and financial KPI dashboards and reports.
• Developed data warehouse queries to extract data for analysis and financial reports for customers from SQL Server 2012 including Full-Text Search, SQL, Crystal Reports XI.
• Developed OLAP cubes to extract data for HR analysis and KPI financial reports.
• Designed, developed, maintained Driver Manifest Database for drivers paychecks and special reporting. SQL Server 2008, SQL, Soft Point, MASS 500, Access.
• Designed, developed, maintained Budget Reports Database, KPI for financial reporting. SQL Server 2008, SQL, Access, Excel, PowerPivot, PivotTable.
• Managed 1000’s of reports, developed $10,000 report.

Confidential, Culver City, CA

Information Systems Manager

Responsibilities:

• Developed, maintained and enhanced queries in People Tools 8.4x for data extracts and special reporting. PeopleSoft, People Tools 8.4x, SQL, Crystal Reports, Access.
• Provided daily application analytics, support, upgrades and troubleshooting of PeopleSoft Campus Solution System for HR, Admissions and Records, Finance, Financial Aid and Student Accounts departments.
• Managing project assignments and application upgrades.
• Developed data warehouse queries to extract data for analysis and KPI financial reports from SQL Server OLAP cubes. SQL, MS Access, Excel.
• System Administrator for GSBM Nolij document imaging and workflow processing. Nolij, SQL Server 2008, T-SQL.
• Developed Stored Procedures and Reports using SQL Server Reporting Services 2008.
• Designed, developed, maintained, and updated code for GSBM Web applications.
• Developed, maintained and updated GSBM Web site. OmniUpdate, HTML, JavaScript.
• ASP.NET, VB.NET, SQL Server 2008, HTML, MS Access.
• Developed VBA Macros and maintained accounting and financial database applications. MS Access, SQL.
• Developed database queries to extract data for analysis and financial reports. MS Access, Excel, PowerPivot, PivotTable.
• Design, implementation and support of internal database applications. MS Visual Basic, SQL, MS Access, MS Excel, Pivot, Macros, MS PowerPoint, MS Word.
• Developed, maintained and enhanced programs in Easytrieve for data extracts and special reporting.
• Developed Stored Procedures, Triggers and Reports for Exeter SMS. MS Access, SQL.
• Wrote SQL Stored Procedures, Triggers and Views for MS SQL 2000 and Oracle by using Transact-SQL and PL/SQL.
• Web development. HTML, DHTML, Dreamweaver, MS Front Page, Flash, Photoshop, JavaScript.
• Debugged code and implemented program improvements. PeopleSoft, People Tools 8.4x, SQL.
• Analyzed business requirements and worked with users and IT to define appropriate solutions.
• Represented the PeopleSoft Campus Solutions system within GSBM.
• Created complex Excel reports for Finance department. Excel, PowerPivot, PivotTable.
• Prepared functional documentation and data code books related to the project.
• Participated in system testing and PeopleSoft upgrade to 9.x.
• Provided daily Nolij application support and reports for all GSBM departments.
• Maintained Nolij users information and assigned roles.
• Created PowerPoint presentations for faculty and staff.
• Processed data and created reports for Admission department.
• Installed software for faculty and provided technical support.
• Trained staff and faculty on new programs and applications.

Confidential, Santa Monica, CA

Database developer

Responsibilities:

• Designed implementation and support of internal database applications. Access, SQL, VBA.
• Web development utilizing HTML, DHTML, MS Front Page, MS Office 97.
• Processed data and created reports. Access, Excel.