OBJECTIVE:

To obtain a challenging position as an information systems professional that will enable me to utilize and expand my current skills and allow for continuing career growth.

TECHNICAL SKILLS:

RDBMS/DBMS: MS SQL Server 2000/2005/2008 R2, Informix, IBM mainframe Universe, MS Access

Languages/Tools: BusinessObjects Enterprise XI 3.1, Crystal Enterprise, Crystal Reports, BusinessObjects Web Intelligence, BusinessObjects Mobile, BusinessObjects Xcelsius 2008, BusinessObjects Universe, BusinessObjects Business Views, Concur, Kofax, Basware, SharePoint, FTP, Windows PowerShell, Query as a Web Service, HTML, CSS, ASP, ADO, VB script, Java script, ColdFusion, MicroStrategy, Cognos Impromptu, Adobe Photoshop, Unix, Aix, Informix 4GL, Informix SQL, PL/SQL, Visual Basic, COM, SHIMS, MS SSIS, SQL Server Business Intelligence Development Studio, SSRS, MS Data Transfer Services, MS Internet Information Services

PROFESSIONAL EXPERIENCE:

Enterprise Application Architecture

Confidential, New York

• Managed development of ESB BizTalk interface projects; evaluated business requirements, analyze source data, functional design, development, QA, UAT, deployment, and documentation.
• Lead the redesign of global ESB solution to stabilize existing interfaces and established a global strategy for ESB interfaces. The strategy included using single receive port for same data source, implementing BizTalk Business Activity Monitoring (BAM), Error handling standards, modifying Full data loads to delta data loads and defined development coding standards.
• Created functional specifications for interfaces including data object mapping from source system to destination, evaluating system dependences, cross reference new request for reusability, and data object definitions.
• Guided BizTalk developers in the creation of SQL Stored Procedures and Views to insure correct data receives and sends.
• Identified master data flows for Master Data Management and established corporate data standards and principles.
• Defined employee life cycle processes to improve global HR onboarding and termination data quality.
• Documented Enterprise Application Global landscape; created Landscape diagrams, defined landscape in Iteraplan.
• Defined Demand Process/Change Request flows to improve change management procedures.
• Established architecture strategies, architecture blueprint documentation, and integration strategies.
• Evaluated how new applications architecture fit in to the global application landscape.
• Responsible for designing and implementing GDPR solution for ESB interfaces.
• Owner of the Global Kofax solution. Responsible for new country roll outs, user training, user support of all Kofax applications (Scan, Quality Control, Validation, and Batch Manager), documentation, system configurations, user permissions, mail box configurations, Kofax batch class creation, QA testing, technical support, and customization of Kofax projects.

Business Systems Analyst

Confidential, New York, New York

• Administered finance reporting web site (CSP) for Crystal Reports. Used Crystal Enterprise 10.0 to manage reports and user permissions.
• Generated many Crystal Reports querying data from in - house custom-built solutions and MS Dynamics SL databases. Created Crystal Reports and publications for emailed bursting reports in BusinessObjects XI 3.1.
• Developed web forms for data input in to DataMart and online reports with ASP.
• Created several SSIS packages to populate custom DataMart, perform data cleansing, export data to flat files, and send email notifications with DBmail.
• Managed and customized internal Business Portal in SharePoint. Administered user permissions on SharePoint sites on expense reports and Timekeeper webparts for MS Dynamics SL. Created new sites for business users. Created custom site Theme with Cascading Style Sheets and modified Master Page.
• Technical lead on the implementation of the North America Concur Travel and Expense solution.
• Designed custom interfaces to import and export data fields for the Concur solution. Defined data mapping of required Concur fields from both MS Dynamics SL and SAP databases. Automation of the interfaces utilizes Windows PowerShell, Task Scheduler, CuteFTP and OpenPGP encryption.
• Performed Concur Administrator role, created customization of audit rules.
• Created custom Cognos data warehouse reports.
• Project lead for the migration of the custom Concur interfaces source from MS Dynamics SL data to SAP data.
• Implemented the North America AP Automation system which was an integrated solution consisting of Basware and Kofax technologies.
• Performed Administrator role of the Basware system and managed customizations to the Basware configurations and business rules.
• Executed data searches in MS Dynamics SL (7.0) maintenance screens to verify data quality. Created store procedures on the MS Dynamics SL DB for reporting. Developed SQL statements on the MS Dynamics SL DB to validate data quality.

IT Data Analyst

Confidential, Troy, MI

• Administered BusinessObjects XI site, users, user groups, folders, objects scheduling, servers, LDAP authentication, Universe access, application settings, tools setup, Tomcat, email SMTP using Central Management Console, Instance Manager, Central Configuration Manager, and Publishing Wizard.
• Created Business Objects reports using Crystal Reports XI, Web Intelligence, and Xcelsius accessing both IBM mainframe and SQL server data.
• Developed Business Objects Universes, Business Views, and Query as a Web Service for data access.
• Created and maintained corporate intranet web site including web site search engine, documents distribution, and company news articles.
• Programmed database driven reports, user reports menus, and reports data access using HTML, ASP, ADO, VB script, and Java Script accessing both IBM mainframe and SQL server databases.
• Created online forms, online quizzes, email notifications, and data management programs using HTML, CSS, ASP, VB script, and Java Script.
• Designed and maintained SQL server databases and data marts for reporting needs.
• Created SQL server Data Transfer Services that extracted, transformed, and loaded (ETL) production data from both the IBM mainframe and SQL server databases to populate reporting databases and data marts.
• Maintained SSIS packages for invoices data warehouse.
• Built a MS Access database including queries, front end, input forms, macros and reports to manage JDL University.
• Created IBM mainframe Universe ODBC compliant dictionary fields modifying both Proks and Basic programs for reporting and used AIX commands to monitor users, data files, and server processes.

Information Consultant

Confidential, Livonia, MI

• Created ASP web pages to display, insert, update, and delete data from SQL Server databases. Used VB script to determine appropriate actions, error checking and generated ADO record sets. Setup web sites in MS IIS. Created web page mockups using Adobe Photoshop for client approval. Modified cascading style sheets to insure consistent look and feel throughout a web site.
• Created DLL components using Visual Basic to perform both business and data logic. Installed COM objects in component services.
• Designed and developed a resource management tool for administrating and manipulating a web sites layout using ColdFusion and a SQL database.
• Generated monthly and single policy prompted notification letters and summary reports with Crystal Reports accessing an Oracle database. Modified intranet ASP web pages to run Crystal Report through a browser using Crystal Smart Viewer an Active-X component.
• Developed productivity and inventory reports using Crystal Reports. Analyzed Yantra system and Oracle database connectivity needed to generate Crystal Reports.
• Created custom Cognos Impromptu reports for both student services and finance. Manipulated and updated data in an Informix database using both Pentamation software and ISQL. Created forms and reports using ISQL. Instructed Impromptu training courses for beginner users. Setup Impromptu user security and modified database catalog.
• Designed and developed a resume builder for the Internet. Created a resume database and web applications using HTML and ColdFusion.
• Year 2000 solution for a Man-Trak system using an Informix database. Created a scan process to identify potential date related issues. Modified 4GL and C source code to correct misused data variables.
• Created a process to generate multiple sales orders for a specific group of customers using Informix 4GL.
• Converted a production system to a 4380 NCR machine. Modified make files, recompiled source code, recompiled ace reports, and recreated library functions.
• Developed a human resource management Data Warehouse. Designed the data model and created front end queries for flexible data retrieval.
• Designed and created an education center reservation system using Informix-4GL. Responsible for enrollment programs, screens and reports.