We provide IT Staff Augmentation Services!

Pl-sql Developer Resume

3.00/5 (Submit Your Rating)

Bryn Mawr, IL

Highly qualified, innovative IT professional with extensive experience in all phases of report development covering requirements analysis, design, development, deployment, and maintenance. Has heavy experience in conversion of older version of Crystal, legacy, MS-Access, and Excel reports. Has working knowledge of relational databases including creation of tables, views, stored procedures, triggers, SSRS and SSIS packages. Proficient in using MS Office Tools. Has good verbal and written communication skills. Has proven ability to interface with a wide range of business users and levels of management providing training, technical assistance, and software solutions. 

TECHNOLOGY SKILLS

Programming Language: VBA, VB6, C#, T-SQL,PL-SQL, HTML
Operating Systems: Windows 95, 98, XP, NT, Vista
Software: MS Word, Excel, MS Access, PowerPoint, Flow Charter, Paradox, Lotus123, Crystal Reports, MS Project, MS Visio 00, TOAD, ERWIN, Visual Studio 2003/2005
Database: SQL SERVER 2000/2005, Oracle 9i/10G, MS Access
Mainframe: OS/MVS, TSO/ISPF, CICS, VSAM, COBOL, EASYTRIEVE PLUS, DYL280, ROSCOE, VM/CMS, DB2

EDUCATION AND PROFESSIONAL DEVELOPMENT
  • B.A., majored in Accounting,
  • Introduction to Computer Science,
  • Structured Programming,
  • Visual Basic, Digital Education & Training,
  • Advanced MS Access, Catapult Training,
  • WorkFlo Programming and Application Dev
  • Oracle 10G – Application Development,
  • Visual Studio .Net Framework,
  • VB.Net and Visual C# programming,
  • SSAS,SSIS,SSRS Online Tutorials,
PROFESSSIONAL EXPERIENCE

Confidential, Bryn Mawr, IL 60631 7/2010 to 9/2010 
Client: Confidential, Chicago, Illinois 60607 
Tools: BOCrystal Reports 2008, Oracle 10G, Embarcadero Rapid SQL , 
Project: Crystal Reports and PL-SQL Development 

Worked with the Business Analysts and Project Managers to design and develop federal 
government mandated audit reports. These reports were used to interface with the in-house
web designed REV system. Reviewed report requirements and formatting. Reviewed the REV 
business needs and requirements and the REV database and data structure. Created and tested
stored procedures and verified dataset result. Designed and tested reports using different test parameters. 
Modified reports to resolve formatting issues and /or install new enhancements. Managed report issues and 
resolution tracking via the Mantise software system.

Confidential., Schaumburg, IL 60173 9/2009 to 6/30/2010 
Client: Confidential, Chicago, Illinois 60606 
Tools: Crystal Reports 2008, SQL Server, BO Enterprise XIR3, Yardi / Insight, Lawson Insight II,
Universe Designer, Elementool
Project: The Lawson Accounting System was decommissioned. Management needed to convert all canned 
financial reports to crystal reports.

Responsible for consulting with external users on business needs, translating business needs into
analytics/reporting requirements and interfacing with team members to ensure successful delivery of management
and transactional reporting and analytic solutions. Troubleshot data issues, validated result sets, recommended and 
implemented process improvements. Worked with the general ledger universe. Designed, developed reports 
which included different flavors of Balance Sheets, Income Statements, Net Asset Values, Actual vs Budget 
reports, Trial Balance, Account Analysis, Rolling 12-Month reports. Report design included formulas, parameters, 
List of values (LOVs), charts, drill downs, sub-reports, dynamic headings and functions. Other responsibilities 
included documentations, user training, managing report issues and resolution tracking via the Elementool 
system.

Confidential, Chicago, Illinois 60606 9/2008 to 3/2009
Client: Confidential, Chicago, Illinois
Tools: Crystal Reports 2008, Visual Studio 2008, SQL Server 2005, Eagle Pace Datamart, Eagle Portal
Project: Advent/AXYS Investment System was decommissioned. Canned reports need to be converted
to Crystal reports using data mart.

Heavily interfaced with Business Analysts on the development of various investment type reports. Developed
stored procedures to extract data for the reports. Validated result sets. Formattted reports in strict compliance with 
reporting standards. Report formats included PDF, EXCEL and HTML. Developed reports with graphs, sub-
reports which included formulas and calculations of portfolio market valuation, accrued income and dividends, pay 
downs, long and short term gain/ loss. Updated source control and uploaded files for deployment of reports to the 
Eagle Portal. Enhanced reports and resolved production report issues. Optimized stored procedures to perform 
high-speed operations on large-volume datasets.

Confidential. Naperville, IL 4/2008 to 7/2008
Crystal Reports Developer 
Tools: Crystal Reports 11.0, SQL Server 2005, Windows XP
Project: SQL and Crystal Reports Development

Designed and developed SSIS packaged by pulling data from different sources. Worked with the general ledger 
database. Developed Crystal reports for Project Cost Analysis and Financial reports. Met with end-
users to gather and document business requirements. Analyzed report functional design. Performed data 
analysis, data validation and cleansing. Developed complex stored procedures. Optimized report 
performance. Conducted user test acceptance. Migrated reports to the production environment.

Confidential, Oakbrook, IL 7/2007 to 12/2007 
Client: Confidential, Rock Island, IL 
Tools: SQL Server 2005, T-SQL, Crystal Reports 11.0, SSRS, SSIS, Windows XP
Project: Meditech System was to be decommissioned and management needed to convert all reports to Crystal 
Reports. A data mart was created to house the Meditech tables.

Gathered business requirements. Reviewed the Meditech data structures and tables. Converted Meditech reports
to Crystal reports. Worked with patient database which included treatment and diagnosis, billing, patient visit
history, insurance information, registration data, guarantor information, patient itemized statements with physician’s
comments. Created reports with sub-reports, parameters, formulas, aggregates and functions. Designed and 
developed SSIS packages for bringing data into the data warehouse. Validated and cleansed data. Developed 
new and ad-hoc reports using SSRS. These included reports with parameters, charts, matrix, tables, 
sub-reports and drilldowns. Created tables and views. Prepared How-To user guide. Trained end- users. Deployed 
reports to production. Installed and configured Crystal reports on end-user’s work stations. 

Confidential, Chicago, IL 6/2006 to 5/2007
Client: Confidential, Chicago, Illinois 
Tools: SQL Server 2005, T-SQL, Crystal Reports 11.0, Windows XP, MS Access 2003, Excel
Project: Account managers maintained their own Access databases and reported off of these. As a result,
the external reports did not synchronized on the reported figure on some accounts. Management decided 
to discontinue all Access databases and create a general ledger data mart and generate crystal reports 
off of this.

Reviewed the report requirement documentations and the data structure. Designed and developed new reports. Converted older version of Crystal, MS Access & Excel reports to new version of Crystal Reports. Developed stored procedure and SSIS packages. Created complex reports which included sub-reports, parameters, graphs, formulas, drill downs, functions, shared variables, aggregates and dynamic headings. Converted undocumented old financial reports to Crystal reports. Migrated reports to the production environment. Resolved production issues. Reports included different variations of financial statements. Half way on the project, I assumed a Business Analyst position. This included meeting with business users to gather report requirements and create report requirement documents. 

Confidential, Oakbrook Terrace, IL 5/2006 to 6/2006
Client: Confidential, Chicago, Illinois 
Tools: MS SQL Server 2000, T-SQL, Windows 2000, Excel
Project: Stored Procedures and report development

Worked with customer account database. Developed complex stored procedures. Validated data set results. 
Created ETL packages to move data to the data warehouse. Created new database tables. Created views using 
multiple joined tables. Interfaced with end-users to gather and document business requirements. Designed and 
developed reports. Optimized SQL codes. Collaborated with software development teams to ensure solutions 
conform to the enterprise architecture standards. 

Confidential, Chicago, IL 11/2005 to 12/2005
Client: Confidential., Lake Forest, Illinois 
Tools: MS SQL Server 2000, T-SQL, Windows XP, MS Access 2000/2003, Excel
Project: MS ACCESS APPLICATION DEVELOPMENT

Designed and developed a multi-user Access application regarding course and instructor training survey from a Zoomerang Application system. Consulted with business users regarding technical requirements and impact of complex business requirements. Conducted technical studies and evaluations of business requirements and recommended appropriate technological solutions. Developed functional specifications. Performed application design. Manipulated Excel files with VBA codes and macros. Designed, developed, and tested forms, queries, modules, statistical reports and switchboard. Split the database. Set up back-end on server and front-end on workstations. Assembled Access MDE files in version 2000 and 2003. Demonstrated system proto-type to users. Prepared application user guide. Trained users. Provided technical support.

Confidential, Aurora, IL 8/2005 to 10/2005
Client: Confidential, Chicago, Illinois 
Tools: MS SQL Server 2000, T-SQL, Crystal Reports 10.0
Project: The Kronos canned reports did not meet all management needs. Additional reports were needed.

Designed and developed custom Crystal Reports for the Kronos WorkForce Central Time Keeping System. Facilitated requirements gathering with stakeholders, defined user requirements, documented functional and non-functional requirements, and obtained agreement on vision, scope, and detailed requirements. Determined user demands and established priorities to ensure deadlines were met. Evaluated and reported on project timeline and recommended changes as necessary. Developed stored procedures, created views. Updated Kronos custom reports with new business requirements. Designed reports with emphasis on visual presentation. Set up reports on the Kronos System.

Confidential., Chicago, IL 06/2004- 03/2005
Client: Confidential, Downers Grove, Illinois 
Tools: MS SQL Server 2000, T-SQL, Crystal Reports 10.0, Crystal Enterprise, MSAccess, MS Visio, Excel 
Project: Crystal Reports development, MS Access Application and stored procedures

Developed ETL packages. Designed and developed stored procedures using multi-joined tables to prepare annuity sales, accounting, and financial data sets. Validated data result sets. Designed and developed reports. Deployed reports in Crystal Enterprise. Redesigned a front-end Access database and added a dental module. Consulted with business users regarding technical and business requirements. Wrote and prepared specifications, documentations, and system flow charts. Split-up an Access database sales reporting system into an Access front-end and an SQL server back-end. Developed technical design and created table structures. Mapped data between source systems. Designed and developed system’s proto-type. Demoed system to users. Trained end-users. Migrated system to production.

We'd love your feedback!