Cognos Business Analyst, Database Administrator And Developer Resume
Nyc, NY
SUMMARY:
- System Administration Experience
- AIX, Solaris, HP - UX, NT/2000, VAX/VMS, AS/400, OS/390 MVS
- Database DBA, Apps DBA & Developer Experience
- 20 yrs Oracle, 8 yrs Oracle Apps, 5 yrs DB2, 5 yrs SqlServer, 5 yrs Access3yr Model 204, 3 yr Teradata Technical Writing
- EDI Manuals/User Guides/Workflow for Mellon Financial
- Black Box Catalog User Guides & Product Descriptions (PT Contract 1993-1995)
- 20 yrs of writing Technical Documentation for Applications DevelopmentContent & Web Site Development
TECHNICAL SKILLS:
Development Tools: Oracle Developer Forms & Reports, Oracle Designer, JDeveloper, Visual Age for Java, Crystal Reports, ERWIN, ER/Studio, TOAD, BTEQ, SQL*LOADER, SQL Navigator, SQL Query Analyzer, Enterprise Manager, Fastload, MultiLoad, Synon, DataJunction & Informatica
Programming Experience: SQL (20yrs), PL/SQL (8), HTML (10), Javascript (4), Java (2), XML (2), COBOL, Visual Basic, FORTRAN
EMPLOYMENT HISTORY:
Confidential, Nyc, NY
Cognos Business Analyst, Database Administrator and Developer
Responsibilities:
- Installed and maintained multiple Oracle, SQL Server, Cognos, Apache, Jboss systems.
- Installed and configured Cognos 8.4.1 Business Intelligence.
- Created Models from multiple data sources in Cognos Framework Manager.
- Created Dashboards and Reports using Report Studio, Analysis Studio and Event Studio.
- Assisted Java Developers in skinning Cognos for customers using Cognos SDK and Mashup Services.
- Programming with SQL, PL/SQL, SSIS and T-Sql
- Business and Data Analyst. Wrote requirements to customize the product based on customer requests.
- Data Modeling of ERP Schemas for Customers EDI and Middleware systems.
- Custom XML and XQUERY develoment.
- Maintained Laboratory Servers
Confidential, Columbus, OH
Consultant - Business Analysis
Responsibilities:
- Identified & Analyzed Cobol/DB2 programs for conversion to Oracle.
- Created ETL Design Documents.
- Created Oracle & DB2 Queries.
- Created Visio Diagrams for the existing Cobol processes and the new ETL processes.
Confidential, Cleveland, OH
Senior Consultant - Business / Data Analysis
Responsibilities:
- Identified & Analyzed Data Sources for ETL processes including Legacy Systems and Confidential Dynamics Navision.
- Data Profiling and Quality Analysis of Source Data.
- Created automated Data Quality processes for feedback to source systems and users.
- Created ETL Design Documents, ETL Maps & Processes
- Installed & used Pervasive Business Integrator.
- Installed SQL Server 2005 & Navision Financials on Windows.
- Tuning & Troubleshooting of Navision/SQL Server Performance problems.
- Installed Oracle 10.2 on Windows & Solaris.
- Created External Tables & PLSQL Stored Procedures.
- Oracle 10.2 Performance Tuning & Troubleshooting.
- Created reports with Oracle Reports Builder and Cognos 8.3 (Framework Manager, Analysis Studio, Report Studio, Query Studio, PowerPlay Studio).
- Installed Oracle 11G and Oracle Warehouse Builder.
- Used Oracle Warehouse Builder to migrate ETL processes to 11G.
Environment: Oracle 10/11g, Informatica Power Center 8.1.6, Pervasive, OWB, UNIX Shell Scripts, SQL, PL/SQL, SQL*PLUS, MS SQL Server 2005, T-SQL, TOAD, ERWIN
Confidential
Business and Database Analyst
Responsibilities:
- Documentation and Analysis of Client Databases (Oracle, Sql Server, Essbase, DB2, Sybase) to plan for server consolidation.
- Conducted in-person and remote client interviews.
- Enhanced ASP/SQL Server consolidation tools.
- Installed SQL Server 2005 on Windows.
- Developed T-SQL scripts for IBM SCON toolset.
- Tested IBM SQL Server consolidation tools.
- Tested IBM consolidation tools.
Environment: Oracle, Sql Server, Essbase, DB2, Sybase, T-SQL, ASP.NET
Confidential, Minneapolis, MN
Infrastructure and Database Analyst
Responsibilities:
- Analyzed existing IT infrastructure and databases.
- Submitted recommendations to client.
- Installed Windows Server 2003 Cluster.
- Installed Sql Server 2005 Cluster, SAC, Reporting Services.
- Migrated databases from Sql Server 2000 to Sql Server 2005.
- Modified VB & Access front ends to use the new cluster.
- QA & Testing of the Applications and Cluster.
Environment: SQL Server 2000/2005, SAP, Access
Confidential
Sr. Developer Analyst
Responsibilities:
- Emergency review of McKesson Software problems.
- Submitted problem analysis and proposed solutions to vendor.
- Upgraded to Oracle 10.2.
- Reinstalled McKesson software.
- Applied new procedures and parameters.
- QA of implemented solution.
Environment: Oracle 10G, McKession Software
Confidential, Denver, CO / St. Louis, MO
Business Analyst, Data Analyst, Database Administrator
Responsibilities:
- Reverse Engineered existing Mutual Funds Software to move to an SOA.
- Identified & Analyzed Data Sources for ETL processes.
- Data Profiling and Quality Analysis of Source Data.
- Created automated Data Quality processes for feedback to source systems and users.
- Developed Requirements for Investment Analysis Databases & Applications.
- Created Design Documents for the new SOA.
- Installed Oracle 10.2, designed Financial & Investment Databases.
- Wrote PL/SQL stored procedures.
- Implemented Oracle Streams and Oracle Text structures & processes.
- Troubleshooting and tuning of multi-tier .Net and Oracle development.
Environment: Oracle 9.34/10G, ASP.NET,ERWIN,TOAD,STREAMS
Confidential, Pittsburgh, PA
Business Intelligence Analyst
Responsibilities:
- Functional & Technical Analysis and Documentation for Claims Processing projects.
- Teradata ETL & Development with Queryman, BTEQ, FastExport, MultiLoad.
- Database & Application Performance Tuning.
- Data Quality Analysis of EDW & Source System Data.
Environment: Teradata, Oracle, MS Project, ERWIN, Visio, Access.
Confidential, Twinsburg, OH
Oracle Developer & DBA
Responsibilities:
- Project to replace Mainframe Marketing and Order Entry Systems with Web based software.
- Functional & Technical Requirements Analysis for a Marketing & Order Entry Web/CICS Replacement Project.
- Oracle 9i & 10G Database Design & Performance Tuning.
- Oracle PL/SQL Programming. CICS, SQL Loader, Cobol.
- Some Visual Studio .Net, ASP.NET & ODP.NET Programming.
Environment: MVS, CICS, VTAM, ORACLE, ASP.NET
Confidential, Portland, OR / San Diego, CA
Remote DB2 v8.2 DBA
Responsibilities:
- Project to document a DB2 based application, upgrade and tune the database and application, and implement Disaster Recovery using HADR.
- Database & Application Analysis & Review
- Implemented Database modifications for LOB Logging & Log Shipping.
- Disaster Recovery Planning & HADR implementation.
Environment: MVS, CICS, VTAM, ORACLE, ASP.NET
Confidential, New Kengsington, PA
Systems Analyst
Responsibilities:
- Systems Analysis and review of Java/Oracle application implementation.
- Data quality analysis and cleansing of ERP data.
- Recommendations for tuning of the prograns, network, and databases.
- Recommendations for ETL with legacy databases.
Environment: ORACLE, JAVA, ASP.NET
Confidential, Arcade, NY
Datawarehouse Architect
Responsibilities:
- Business Requirements Analysis for the Datawarehouse.
- Datawarehouse design and implementation at a Confidential subsidiary.
- Installed SQL Server 2000 and Analysis Services on multiple Windows 2003 servers.
- Designed and implemented Datawarehouse DDL.
- Database Analysis, Design & Problem Resolution.
- ETL of data from production Unix systems to the SQL Server.
- Data Profiling and Quality Analysis of Source Data.
- Created automated Data Quality processes for feedback to source systems and users.
- Created Stored Procedures, ActiveX programs, and DTS packages.
- Implemented Replication, Backup & Recovery & Disaster Recovery.
- Wrote Technical Documentation and programs to automate documentation.
Environment: SQL Server, Unix, ASP.NET, DTS
Confidential, Penn Hills, PA
IVR Developer
Responsibilities:
- Temporary developer position customising IVR and WMS software.
- Custom programming for IVR and WMS systems integration.
- Reviewed Requirements Documents and customized Confidential software products using VB6 and SQLServer 2000 T-SQL Stored Procedures.
- Implemented Workflow changes using Confidential Talkman/TaskBuilder software tools.
Environment: SQL Server, VB6
Confidential, Fairbanks, AK
Oracle Functional & Technical Analyst
Responsibilities:
- Cleanup of an Oracle 11.5.9/9.2 Quickstart Installation
- Analysis and resolution of startup problems primarily with Oracle Grants, AP, PA, and GL modules.
- Reviewed requirements & parameters for installation and setup with users.
- Implemented changes to eliminate incompatible parameters.
- Cleaned up Interfaces and Workflow.
- Ran Oracle Diagnostics, initiated TARS and applied patches.
- Redesigned Oracle Discoverer reports.
- Wrote custme SQL & PL/SQL to fix problems unresolved by TARS for Payroll and Accounts Payable.
- Trained users in basic Oracle Financials functionality.
Environment: Oracle Public Sector Financials 11.5.9, Oracle 9.2, Discoverer.
Confidential, St. Louis, MO
Business & Data Analyst
Responsibilities:
- Requirements Definition, Design Specifications, and Project Coordination for ETL of Financial and Financial Management Data for Confidential & subsidiaries.
- Analysis of source systems data and metadata on Oracle, Teradata, DB2 databases and other sources including Oracle Financials 11.5.9.
- Validation of Source Data, creation of Requirements Documentation, review and update of ERWIN Data Models and Metadata, development of Mapping Rules and Transformation Logic, creation of Detailed Design Documentation
- Reviewed the SEI Capability Maturity Model and presented recommendations necessary to meet the CMM Level 2 Requirements
- Used OLAP Tools including Microstrategy, Business Objects, Cognos, MS Analysis Services, Essbase and Oracle Financial Analyzers to generate data loads & reports for the DW Integrated and Reporting Layers.
Environment: Teradata, Oracle, DB2, ERWIN, Informatica, Test Director, CMM Level 2
Confidential, Pittsburgh, PA
Oracle DBA and C Developer
Responsibilities:
- Project to upgrade inhouse developed Steel Manufacturing Operations software to meet new customer requirements.
- Modified the database schema for new tables and fields.
- Modified PLC Level 2 and PLC Level 3 programs.
- Created new C programs, stored procedures and triggers.
Environment: Oracle, VMS, C
Confidential, Pittsburgh, PA
SQL Server DBA and ASP.Net Developer
Responsibilities:
- Customization of several local small business websites.
- Dreamweaver modifications to websites.
- SQL Server 2000 DBA and ASP.Net Development
- Conversion of Access and Excel applications into SQL Server and ASP.Net applications
Environment: Dreamweaver, Visual Studio .Net, Sql Server 2000 and Windows 2000
Confidential, Bentonville, AR
SQL Server DBA, Developer & Biztalk Server 2004 Developer
Responsibilities:
- Technical Resource for integrating applications with BizTalk Server 2004, Teradata, DB2, Informix & SQLServer
- Requirements analysis for Enterprise Application Integration with Biz Talk Server 2004
- Analyzed Client Interfaces, SQL Queries, programs.
- Created SQL Server 2000 Tables and Stored Procedures to load and hold parsed data from the Biztalk Orchestrations and created Stored Procedures to retrieve the requested data from multiple RDBMS and return the data to the Orchestration pipelines
- Troubleshooting, testing, tuning of the new Biztalk Retail DSS Systems and interfaces.
Environment: Teradata, Oracle, DB2, Informix, SQL Server, Biztalk Server 2004
Confidential, Pittsburgh, PA
Network Technician
Responsibilities:
- Installation of network print servers and printers at U.S. Confidential 's Office coordinated with Lockheed-Martin and Wharton Consulting.
- Requirements Analysis and Project Planning to migrate Bank Customer Transaction Data from a legacy system using ETL tools, Banctec Software, NCR Unix and Windows Server.
Confidential, Pittsburgh, PA
Network Engineerring Technician
Responsibilities:
- Removed old hardware from bank branches, installed new personal computers, cabling, routers and servers
- Switched offices from Token-Ring to Ethernet
- Installed images on PCs, tested applications
- Troubleshooting, user testing and problem resolution.
Confidential, Pittsburgh, PA
Instructor and Courseware Designer
Responsibilities:
- Integration and Support of Great Plains Financial Software with other COTS software and custom in-house development
- Creation/Installation of SQL Server v7 databases, views, tables and stored procedures using Enterprise Manager & SQL Query Analyzer
- Performance tuning of T-SQL queries, Access, FRx and Crystal Reports and Citrix XP Applications
Confidential, Pittsburgh, PA
Technical Writer / Programmer
Responsibilities:
- Documentation project for EDI, ACH & Wire Transfer.
- Also developed a Java application to automatically generate documentaion from existing Oracle and Access databases.
- Development of Financial Services documentation for EDI, ACH, Wire Transfer
- Documented workflows for all functions in the EDI department and created user guides and procedures for each employee workflow.
- Developed an EDI Documentation System to automatically capture information from the Mainframe and Unix EDI systems and provide GUI interfaces for manual data entry using Access, Java, Oracle and Crystal Reports with the Harbinger/Peregrine Trusted Link EDI and OS/390 RemEDI systems
Confidential, Dallas, TX
Project Leader / Teradata & Oracle Developer & DBA
Responsibilities:
- Analysis and Requirements Definition for interfaces to the datawarehouse, including the Converges P2K Billing System, extracts to other datawarehouses and Operational and Management Reporting
- Worked with Convergys and other vendors to identify and troubleshoot problems.
- Data mapping & modeling of the existing and new systems
- Database & Application design and tuning.
- Extraction, transformation and loading (ETL) of data to & from several multi-terabyte DB2 and Teradata datawarehouses and Financial Systems using SQL*Loader, Informatica, DataJunction
- Report design using Cognos Impromptu, Transformer & Powerplay, Crystal Reports, Business Objects, Oracle Financial Analyzer, Oracle Forms & Reports, Express, Discoverer. HTML, Javascript.
- Oracle PL/SQL & Java stored procedures.
- Upgrade of Oracle Financials from 10.7 to 11i and the integration of Oracle Financials and Manufacturing Supply Chain Modules with the Data Warehouse.
- Functional requirements for Financials & Supply Chain upgrade including Workflow & API’s.
Environment: Oracle, Teradata, DB2, Queryman, Toad, Korn Shell, Perl, Informatica, Java, JDeveloper, Oracle Designer 2000, Oracle Developer 2000, Connect Direct, Cognos, Business Objects, Express, Discoverer, Crystal Reports.
Confidential, Olean, NY
Project Manager / Data Modeling, Developer & DBA
Responsibilities:
- Created the Project Plan and made staffing recommendations.
- Managed the programming and DBA staff in the implementation of the project plan and development of the test system
- Trained contractors in Oracle DBA and VB 6.
- Recommended, obtained approval, and purchased project software. Analyzed the Engineering Configuration software and planned for the conversion of VB6/DAO code and 1000+ Access tables to VB6/ADO/Oracle
- Supervised the installation of Oracle, ER/Studio (Data Modeling), and DataJunction (ETL) and Citrix software
- Created the Data Model in ER/Studio, created VB Scripts in ER/Studio to handle mass changes between the Access DDL and Oracle DDL, added keys and constraints, generated the Oracle objects from the Data Model
- Created ETL conversion routines in DataJunction to extract, transform, and load the data from Access to Oracle. Developed test procedures and supervised the conversion and testing of the new system. Identified bugs and solutions.
Environment: Oracle, Access, VB6