SUMMARY:

Information Systems professional with over 27 years of experience seeking a challenging senior level analyst position with a company where my skill set will enhance their goals and objectives.

TECHNICAL SKILLS:

Databases: MS SQL Server 5 - 2008, Oracle 7-11, PostgreSQL 9.x, MS Office Suite

Languages/Tools: Actuate (all components) 3.x-8.x, Business Objects, Eclipse, ETL Actian/Pervasive 8-10, Pentaho DI 5.x, SSIS, HTML, Java SE/EE, Java Script, JSP, Liferay, Shell DOS, Korn/C, SAS, SQL PL/SQL, T-SQL, VisualStudio

Operating Systems: AIX, HP-UX, Solaris, Windows 3.0-10

App/Web Servers: IIS, Tomcat, Confidential Web Application Server (Websphere)

CASE: Designer 2000, Embarcadero, ERWin, Confidential Rational Application Development Suite, MS SSMS, TOAD, RequisitePro

Methodologies: Gane/Sarsen, Yourdon/DeMarco, UML/UMP, Rational Unified Process, Six Sigma, Agile SCRUM

Version Control: ClearCase, Envy, PVCS/Serena, SourceSafe, CVS, Bitbucket

PROFESSIONAL EXPERIENCE:

Confidential

Sr ETL Developer/Lead/Data Analyst

Responsibilities:

• Collaborate with data teams to establish data requirements of the Oracle EBS system
• Create complex views from data requirements for data retrieval from EBS
• Develop PL/SQL specs/packages as APIs to Oracle EBS system
• Collaborate with Salesforce.com team to establish custom data model
• Establish mappings from EBS tables to Salesforce.com cloud (Hadoop) custom objects
• Develop and implement Actian/Pervasive (v10) maps and processes to retrieve data from the Salesforce.com cloud load the Oracle EBS system through EBS APIs
• Develop and implement Actian/Pervasive maps and processes to retrieve data from the EBS system views and load/update the Salesforce.com cloud
• Install, configure and maintain Actian/Pervasive Data Integrator on development and production platforms
• Release, package, deploy and schedule all integrations in the production system and maintain/tune integrations as needed
• Create patch releases to fix and/or modify integrations as required in the production systems
• Provide expertise/mentoring to the ETL team
• Establish test plans from functional requirements
• Perform data analysis of MS SQL Server SSIS integrations and provide Pervasive configurations/APIs through T-SQL stored procedures/functions/scripts to aid in the migration of financial collection systems, reconciliation and reporting using SSMS and VisualStudio
• Create integrations using FICO’s DM9 framework writing complex SQL code.
• Create and deploy DJARs and write shell scripts to execute deployments.
• Data analysis/modeling/development/administration and ETL/BI development
• Produce/Consume web services through SOAP and REST APIs to produce target output.

Sr Developer/ETL Lead

Confidential, Ft. Detrick, MD

Responsibilities:

• Perform data analysis and establish logical/physical data modeling of the data warehouse (snowflake) and data mart (star) using ERWin
• Establish formal mapping documents (ICD) for approval by government
• Using Pervasive (v8-9) and Oracle PL/SQL, develop ETL strategies for loading 200+ text file data feeds to the data warehouse (snowflake) and data marts (star)
• Develop/Implement PL/SQL specs/packages and views writing complex SQL code to interface with JMAR data and optimize ETL integrations
• Perform query optimization using execution plan statistics
• Create data access objects in Java to execute Oracle PL/SQL and/or views to interface with web application
• Collaborate with BI team to migrate Actuate reports to Business Objects
• Java development (EJB) for file transferring, decompression, SOAP web services and control of ETL processes
• Web portal development using Java, Liferay Portal, ICEfaces, OC4J and Tomcat
• Managed/Modified Tomcat configurations as required
• Install and configure Tomcat instances in development, test and production environments to support migration efforts
• Collaborate with functional analysts to establish test plans from requirements
• Configuration manager/build engineer for all software components and deployments using PVCS.

Confidential

Senior Consulting Data Analyst/Developer

Responsibilities:

• Modify/upgrade Actuate reports written for Maximo v4 to v6 using Oracle back-end
• Customize Maximo portal (JSP, Java Script, Java Servlets, Struts) as required
• Extend functionality of standard Actuate reports and libraries
• Analysis of legacy application written in C++ to re-engineer solution in Java using Confidential Rational suite
• UML application solution adherence to RUP guidelines using Confidential Rational Software Architect

Confidential

Senior Systems Consulting Analyst/Developer

Responsibilities:

• Extensive use of Rational RequisitePro for requirements and high level design artifacts
• Establish traceability matrices between use cases and business requirements and lead/train/mentor analysts in the proper usage of the RequisitePro tool
• Logical/Physical data/object modeling of OLAP database using Rational Software
• Actuate(BI), Forte, AWK, ETL and Oracle PL/SQL development.

Confidential

Senior Consultant

Responsibilities:

• Perform data analysis from business requirements consulting with stakeholders
• Logical/Physical data modeling of OLAP/BI database utilizing Oracle/TOAD tools
• Establish requirement use cases and sequence diagrams for development teams
• Analyze Maximo/Actuate interface to aid in SQL enhancements of reporting templates
• Modify, develop and extend Maximo/Actuate libraries and templates to enhance the development of complex reports and accommodate project requirements
• Customize Adaptive Reporting/Maximo portal (JSP, Java Script, Java Servlets, Struts) and train/mentor project team in Actuate/portal best practices.
• Manage the implementation and deployment of standard and custom reporting products for external clients
• Troubleshoot test/production issues, modifying Oracle PL/SQL and reporting code during SDLC before final production release
• Version control and configuration management

Confidential

Actuate Team Lead

Responsibilities:

• Enforce SDLC for implementation of Actuate reports according to corporate standards utilizing OOA/D reuse principles and the Six Sigma methodology and mentoring existing Business Analysts in requirements best practices.
• Establish migration path from Actuate version 5 to 8 and develop new intranet solution
• Reconfigure Actuate development, test and production report servers, Actuate Portals, Report Cast and web/app servers to enhance web reporting performance
• Modify corporate Actuate libraries framework to facilitate user requirements and reuse
• Logical/Physical data modeling for meta-data (OLAP/BI) for SQL Server 2000 implementation
• Extensive SQL tuning of DB2 queries
• Develop advanced Actuate reports as assigned and lead/train/mentor full-time Actuate staff in Actuate and database best practices and performance by enhancing 500+ existing reports.

Confidential

Team Lead

Responsibilities:

• Establish SDLC process for implementation of Actuate reports according to corporate standards utilizing OOA/D principles and UMP
• Logical/Physical data modeling for data warehouse/data mart (OLTP/OLAP) utilizing Oracle Designer 2000
• Establish data migration path from Confidential data feeds and apply data cleansing protocols using customized ETL processes and Oracle PL/SQL
• Install and configure Actuate development, test and production web and report servers and Active Portals to accommodate intranet web reporting requirements
• Develop corporate Actuate libraries framework to facilitate user requirements and reuse
• Customize Actuate Servlets to interface with Siebel and enable single sign-on capability
• Customize Actuate portal (JSP, Java Script, Java Servlets, Struts) as required
• Extend/Develop Java classes that interface with report server using SOAP API
• Develop advanced Actuate reports as assigned from Siebel generated data sources.
• Train/Mentor full-time staff in Actuate and database design best practices.