SUMMARY:

• Workflow analysis, Enterprise Modeling, Operational Mapping
• ETL Planning for Business Intelligence (data extraction, transformation and loading process design)
• Data conversion (data mapping, conversion process design)
• Process (Data Flow) and Data (ER) modeling
• Experienced with multiple Structured Methodologies

TECHNICAL SKILLS:

Programming Skills: PL/SQL Oracle (installed/maintained instance: created users, rebuilt tablespaces, install clients) SQL Server (T - SQL, light SSIS) C#/C#.net Visual Basic Microsoft Access/Excel/VBA

PROFESSIONAL EXPERIENCE:

Confidential

Enterprise Data Management Application Analyst

Technology: Microsoft (C#,SOAP,XML,WSDL,Visual Studio 2010, Oracle to 11g, SQL Server 2008, MSAccess/Excel). First 18 months as contractor, then converted to FTE

Responsibilities:

• Loaned to IT department to develop Oracle stored procedures for comparison of data between multiple database instances
• Heavy data analysis using linked data from multiple instances, heavy use of sql loader for data transfer
• Developed a desktop tool for Master Data Management analysts to perform analysis on account hierarchies, basically taking Dun & Bradstreet data and expanding for internal client. Technology is C# front-end, all data manipulation done in pl/sql stored procedures. Some java procedures to facilitate cross-schema DDL operations. Data was then downloaded to Excel via automation, then automatically run through Microsoft Bing api for web validation
• Developed an improved method to extract data for reporting from production database/warehouse. Using local copy of Oracle 11g, dblink, and pl/sql queries and procedures. Mentored client staff in use of pl/sql and technology
• Developed custom Web Parts/Services to connect to Siebel Analytics using a SOAP API and provide dynamic data access to for Sharepoint sites. Required building development area using Virtual PC/Windows Server 2003/WSS 3.0), then deploying to production server
• Various C# projects to load and manipulate large datasets into SQL Server
• Developed and executed some SSIS scripting, entry level in this tool
• Performed marketing data analysis (PWE, Penetration Analysis, etc). Analysis performed using Business Objects, Siebel Analytics, Market Insight, Excel 2007 and Access 2007. Data consolidation done using Excel/VBA.
• For Confidential, constructed prototype web pages to allow simplified querying of Siebel/Oracle data warehouse using C#.net
• Worked with backend tools (pl/sql, Siebel Analytics Admin tools) to facilitate large data extracts for reporting.
• Mentored team members in VBA coding (access, excel) and us of pl/sql tools (PLSQL Developer, TOAD)

Confidential

Information Systems Manager

Technology: Microsoft (SQL Server, ASP.NET, MSAccess/Excel)

Responsibilities:

• Responsible for taking all current record keeping/database systems, which were done in MS Excel, and migrating them to an internet based technology (MSAccess, .NET, SQL SERVER)
• Produce weekly metrics report, 44 pages of excel graphs & charts, data driven off of pivottables, heavy formulas, VBA code
• Data translation and extract from HR/accounting system via CITRIX based MSAccess custom reporting module
• Expert level in VBA coding in access, database design, etc. As Supervisor
• Provided customization/supplemental output on Oracle-based scheduling system
• Developed several in-house DB applications in MS Suite to automate processes
• Ran one of the busiest checkpoints in the airport, functioning as Senior Mentor and Trainer to new CSS on busiest shift
• Assisted in several new CSS
• Performed all required functions of Checkpoint Supervisor, as detailed in TSA SOP
• Served as liaison with TSA Screening Managers, SCC, Airline Management, Police and others as required to complete job functions

Confidential

Oracle Developer

Technology: Prototyped in MSAccess, Development in ORACLE 9i (Unix), including DEVELOPER and DESIGNER 6i

Responsibilities:

• Developed forms using Developer forms 6i
• Worked with DBA on schema and design changes
• Developed stored procedures

Confidential

Principal Information Engineer

Technology: VAX, Unisys, ORACLE (DEVELOPER, DESIGNER), POWERMART

Responsibilities:

• Analyzed legacy systems to identify current functionality and data elements, developed process and ER models of systems, using Oracle Designer 2000
• Developed Data Warehouse model for tables, created physical tables for DW
• Wrote data mapping specifications to be used by the ETL (Powermart) Team to migrate data from legacy databases to Compass Contract, included sample PL/SQL scripts to ensure exact conversion of data
• Created triggers and stored procedures to implement business logic
• Implemented menu security using Roles, set up user accounts, maintaining grants, synonyms
• Developed the entire Workload system from scratch

Confidential

Programmer

Technology: PARADOX (DOS), MSAccess/SQL Server, VISUAL BASIC/SQL Server

Responsibilities:

• Analyzed legacy systems to identify current functionality and data elements, developed process and ER models of systems, using Silverrun CASE tool for Data and Process models
• Constructed physical database, extracted and transformed legacy data, and built MSAccess front end to system as prototype
• Converted front-end modules to Visual Basic
• Installed SQL Server, reverse-engineered Access database using Designer, cleaned up data model and generated DDL to construct SQL Server database
• Converted and loaded data to final SQL server database

Confidential

Systems Analyst

Technology: PARADOX

Responsibilities:

• Review business processes and existing computer systems of clients and develop strategies and plans for conversion
• Provide onsite installation and implementation of hardware, software, tables, and network; including LANs, modems, hand held computer and cash drawer interfaces
• Perform Paradox and PAL programming necessary to convert existing data and customize software
• Develop requirements and coordinate customization with other development staff members
• Test, debug, modify, and maintain programs within base products as well as customized versions
• Develop and execute test plans and scripts for new product releases
• Prepare and customize user documentation and conduct

Confidential

Senior Technical/Business Consultant

Technology: VAX, ORACLE, TANDEM, IBM, PARADOX, LOTUS

Responsibilities:

• Built and maintained a database containing the prompts for early version of Pacific Bell s voice mail system using Oracle 3.0. Using early version of Oracle case tools, modeled database and generated application
• Supported end users at Pacific Bell and developed requirements for a TANDEM - based product to replace an existing Service Control Point in an SS7 networks; assisted engineering manager in Project Management
• Developed process and data models for distribution systems at Apple Computer during conversion from S/38 to VAX-based environment. Assisted user personnel in defining requirements for enhancements to the Distribution Requirements planning system
• Served as a technical liaison between business user groups and systems engineering staff to develop specifications and procedures for reporting subscriber usage of a PPO at Confidential
• Led a team of user and technical analysts to develop requirements for a real-time, PC-based Productivity Management system for the United States Postal Service
• Designed, developed and maintained a PARADOX database system for Fireman's Fund's Quality Assurance program
• Temp assignments during this period: (Spare Hat Program)
• Served as Administrator and project production coordinator for Fireman's Fund's annual insurance commissioner's reports, using a complex, LOTUS-based financial package. Provided Paradox support for corporate Quality Assurance Programs
• Developed and executed software test plans for Pillar Corporation's financial planning and reporting software

Confidential

Systems Analyst

Technology: IBM 30x, DBASE, LOTUS, SMARTCOM, XTALK

Responsibilities:

• ·Provided business and technical systems support to external customers of the Bank's Corporate Cash Management product and to other bank departments (marketing, money transfer, and branch operations). Developed documentation, materials, and specifications for modifications. Perform QA on new releases.

Confidential

Systems Consultant

Technology: DBASE, LOTUS

Responsibilities:

• ·Provided technical support and requirements definition assistance to a variety of clients including insurance companies and hospitals. Managed PC software equipment purchase and installations, trained customer staff, and supported staff after the completion of implementation.