Skills

Oracle Business Intelligence, IBM Cognos 10, Tableau, Informatica, Oracle 10g, Oracle 11g, MSSQL 2000 and 2005, Teradata, PL/SQL, T-SQL, Erwin, Sun Solaris 9 and 10, Microsoft Excel Spreadsheet, Microsoft Access, Microsoft Visio, Microsoft Visual SourceSafe, Crystal Reports, Java Scripting, XML, ASP, ASP .NET, Web Services, Control-M

Experience

Confidential

Senior Quality Assurance Lead

• Lead QA analyst on Oracle and Teradata data warehousing projects
• Allocates work, mentors, and advises junior project QA members
• Develops SQL queries to validate data feeds from source to target
• Responsible for providing QA level of effort for new data warehousing projects
• Communicates with project manager, developers, and business users on a daily basis

Confidential

Business Intelligence Lead/Analyst

• Lead functional analyst acquiring business requirements from business and translating them for application development purposes
• Lead functional consultant, developer and architect on Oracle Business Intelligence Human Resource implementation
• Liaison with the Human Resources department to discuss enhancing and maintaining the HR Analytics platform
• Developed ad hoc reports based on business' needs
• Developed and designed test plan for all reports produced for business
• Enhanced and fixed the ETL process using Informatica
• Supported and designed security for the OBIEE product
• Lead project in migration of Tax Business Objects reports and architecture to Cognos 10
• Implemented and configured new Tableau reporting implementation

Confidential

Maintenance Project Lead

• Project lead for the maintenance team that is responsible for ongoing maintenance and continuous improvements of various versions of the MetraNet platform
• Point of escalation for higher priority customer issues
• Managed technical workload for four technical consultants
• Maintained project plan for monthly maintenance releases. The plan determined resource load and what can be fixed in a given period of time
• Provided ongoing maintenance and change request reports to executive team
• Worked with technical consultants to determine the estimated costs for change requests in time and effort
• Assisted in acquiring and documenting customer requirements for purpose of customization
• Reviewed design document for customer and QA review
• Reviewed QA test plans
• Lead and cycled customization process from design phase to development phase to customer/QA validation phase to deployment

Confidential

Technical Lead

• Technical lead on two global enterprise edition applications
• Delegated technical tasks to members of the technical team and reviewing technical changes made by team
• Worked with Business Analysts to develop Design Specifications
• Defined and/or assisted in the development of the Server installation and setup procedure
• Authored, reviewed and approved deliverables as identified in Project Plan
• Monitored the work assigned to the technical group to ensure adequacy and adherence to schedule
• Drove infrastructure/architecture decisions
• Lead the technical group through the installation, configuration and customization of the system software, so that the end state met requirements and design requirements
• Managed the system software OTSS and custom code according to the approved Configuration Management procedure
• Defined and/or assisted in the development of the Production Support Plan
• Technical architect for application having responsibility to design and code business requirements
• Documented non-functional business requirements
• Documented test scripts for testing in validated environment
• Documented configuration architecture, backup and recovery process, and archiving for two application projects
• Lead database developer on the two applications

Confidential

Database Developer/Administrator

• Set up MSSQL 2000 and 2005 and Oracle 9i and 10g development servers and Oracle instances for application development
• Assisted developers with the understanding of new PL/SQL features in 8i, 9i, 10g and all MSSQL versions
• Designed and developed stored procedure and triggers for financial and contract applications
• Migrated database designs from MSSQL to Oracle this included all database objects stored procedures, triggers, views and tables
• Prepared technical documents and function specification
• Maintained training, QA, and support servers and databases
• Assisted developers with SQL Plus and PL/SQL
• Provided customer support with respect to Oracle technical assistance and installation of SOFTRAX for Oracle
• Provided Implementation and Technical Services department with custom patches for customers with unique requirements

Quality Assurance Engineer

• Lead QA engineer for the Softrax enterprise product line
• On site visits to Softrax customers to assure nominal use of the product
• Database Administrator for Softrax support and QA departments
• Assured database quality in full suite of Softrax applications
• Documented manual and automated test cases for 100 percent nominal product testing

Senior Technical Specialist - Level III

• Main support contact for high profile clients
• Troubleshot financial, operations, professional services and taxing software
• Wrote and updated SQL and Oracle scripts, stored procedures, triggers, and views to analyze, report, and fix data
• Trained customers and co-workers on Softrax Applications Suite
• Worked with Microsoft SQL Server 6.5, 7.0, and 2000. Oracle 8i and 9i
• Supported GL, AP, AR, PA, Inventory, FRX, installations, purchasing, Order Processing, and Deferred Revenue management
• Restored Microsoft SQL Server and Oracle databases
• Installed Business Server, Inform, and Contrax applications for Softrax
• Created multiple database procedures and cursors
• Created and modified standard Softrax tables and triggers
• Monitored multiple Oracle development servers for spacing and usage
• Created several hundred data cleanup scripts for Oracle and MSSQL customers
• Assisted in the creation of DBHC Database Health Check scheduling program that resides on Softrax middle tier server
• Reviewed Oracle scripts for Softrax support department
• Converted pre-Softrax databases to Softrax databases for new client installs

Confidential

Senior Applications Consultant

• Supported, Installed, and trained hospitals in MEDITECH Pharmacy, MM, and Radiology
• Experienced with GL, A/R, BAR, Order Entry, Lab, and MIS modules
• Worked with both MEDITECH MAGIC and Client/Server product
• Supervised up 10 consultants in a given day