SUMMARY:

• Highly - motivated and resourceful IT professional, with a record of developing and supporting successful IT projects and solutions, primarily in the financial services sector. Consistently recognized as able to improve organizational effectiveness and efficiency through leadership that aligns the business processes and Enterprise applications to realize cost savings, accelerate performance, and sustain strategic flexibility.

PROFESSIONAL EXPERIENCE:

Confidential, Warren, NJ

MicroStrategy Consultant

Responsibilities:

• MicroStrategy Team Lead and Architect for the Global Financial division reporting into all the CFOs of Confidential . Directed onsite and offshore team in the development financial reporting. This was achieved by using reporting metadata, intelligent cubes, blending and complex metrics. Handled migrations using Object Manager and cube publishing using Command Manager.

Confidential, New York, NY

MicroStrategy Consultant

Responsibilities:

• Converted several Excel spreadsheets into MicroStrategy 9.3 Web Dashboards. This involved loading the data into SQL Server as a view, adding the view to MSTR and creating all the required objects and mappings for the datasets. Administration responsibilities included creating users, adjusting VLDB properties, changing ODBC connections, and troubleshooting performance issues.
• Worked with the offshore team in creating policies for migrations, folder structures and object naming conventions.

Confidential, Jersey City, NJ

IT Consultant

Responsibilities:

• Created an Executive Dashboard using MicroStrategy business intelligence software. The dashboard provided executive management with performance and trends for the premium finance business. Users are able to select details at the corporate, regional, account executive and sales representative levels. Year over Year and Month over Month data are presented in bar graph, while trend data is represented in a line graph, where the user can select one to ten years of monthly data.
• Converted all Informatica ETL SQL syntax from Oracle to MS - SQL Server. Regression tested all MicroStrategy reports due to the conversion.
• Converted all Oracle datamarts to SQL Server 2005. Included creating tables and migrating data.
• Reversed engineer Onyx CRM and created scripts to extract data, for the migration to MS - CRM. Used Informatica ETL to move the data.
• Created SQL procedures to extract agency data and insured financials from Sybase, for the migration to SQL Server 2005. Wrote UNIX shell scripts to execute the extract procedures in the monthly batch.
• Project Manager for decommissioning an online notice archive and to import notices from outsourcing vendor to a new internal application.

Confidential, Jersey City, NJ

IT Consultant thru CSW Consulting Specialists

Responsibilities:

• Converted all Informatica reports to MicroStrategy reports, including technical documentation. Maintained MicroStrategy security groups and Narrowcast subscription services. Worked with MicroStrategy on creating a CBT for in house personnel. Tested online help created by internal Department.

Confidential, Jersey City, NJ

IT Consultant thru CSW Consulting Specialists

Responsibilities:

• Wrote the master documentation for interfacing generic quote data from agency management systems and the financing application.
• Project Manager and Business Analysis for creating a new premium finance agreement with AON.
• Created release notes.
• Created Project Charter for new development change control policies.
• Created and implemented change control policies and procedures, using Borland’s StarTeam change management software, across three development teams.
• Wrote requirements for outsourcing the online notice application for the Direct Bill company entity. Worked closely with Bowne (R.R. Donnelley) on web page design.
• Designed new website for the Direct Bill company entity, using an interactive user interface mockup, designed in Visio.
• Provided quality assurance for the Life Insurance Premium Financing entity.
• Created a Wiki data room for gathering details on all applications, for the sale of Confidential . corporate entities.

Confidential, Jersey City, NJ

IT Consultant thru CSW Consulting Specialists

Responsibilities:

• Served as subject matter expert, for the creation of a new financing application. The project required the analysis, reverse engineering of current application and documentation of all departments within the client. Acted as the liaison between the business units and IT for the translation of deliverables. Performed due diligence for the acquisition of a premium finance software company. This purchase would have replaced the need for creating a new application.
• Created a Visio diagram for each corporate entity infrastructure, for the purpose of identifying key applications for the disaster recovery plans.
• Performed quality assurance testing and impact analysis on several new PowerBuilder and UNIX releases, related to invoicing, quoting, ACH, quote contingencies and disbursements.
• Wrote specifications for a front end holiday maintenance schedule, using Visio for mockup user interface.
• Wrote technical specifications for interfacing the Canadian business entity with Dun & Bradstreet’s corporate rating system.

Confidential, Jersey City, NJ

Assistant Vice President, Information Services

Responsibilities:

• Manager of the Business Analysis and Quality Assurance teams for insurance Premium Financing, Direct Bill, Life Insurance Financing, and lease-based asset lending. Conducted hire/fire, performance reviews; Sarbanes-Oxley compliance monitoring and adherence, business-case evaluation, systems business analysis, and project management.
• Enhanced the change control procedures by adding additional details to the change request database. This enabled the CIO to quickly know the status of each project and who currently was working on it.
• Project Manager for over 500 application changes a year, supporting 12 different applications spread over five companies within A.I. Credit. Five of the 12 applications were new start ups. Oversaw the development and deployment of an agency-based Web-quoting application and a Web information portal.
• Integrated online installment payments with the back-office application. Infused integrated agency management software into the Web-quoting application. Merged the Puerto Rican business database with the corporate database. Designed the Sarbanes-Oxley (SOX) test plans and implemented the testing.

Confidential, New York, N.Y

I.T. Consultant thru CRW Business Solutions

Responsibilities:

• Managed the Y2K application upgrade for one of Confidential & Company’s subsidiaries, including hands on development. The scope of this project was to analyze the current partnership accounting application and rewrite the application using client/server technology, identify any of the existing shortcomings and comply with Confidential ’s Y2K standards.