Project Manager Sql Server
Resume:
Michael Jones
Email: abqnom@r.postjobfree.com
Address: ***** **** *****
City: Orland Park
State: IL
Zip: 60462
Country: USA
Phone: 708-***-****
Skill Level: Experienced
Salary Range: $85,000
Willing to Relocate
Primary Skills/Experience:
See Resume
Educational Background:
See Resume
Job History / Details:
Michael J. Jones
15406 Lisa Ct, Orland Park, IL 60462
(h) 708-***-****
(m) 708-***-****
abqnom@r.postjobfree.com
Senior Database Developer experienced in data modeling, SQL programming, ETL transformation, data warehousing, software development life cycle (SDLC), project management, business requirements, design and analysis. Attention to details, disciplined in prioritizing and resolving critical challenges with timely delivery.
AREAS OF EXPERTISE:
Databases: MS SQL Server, Sybase, Oracle, IBM DB2
Languages: T-SQL, PL/SQL, Java, ASP.NET, C#, Visual Basic, UNIX shell scripting
Tools: Informatica ETL, DB Artisan, Visual Studio, Eclipse, SDLC, MS Project, Siebel CRM, Erwin Data Modeler, SQL Server DTS, Business Objects, AutoSys, Savvion Workflow, Enterprise Control System (Control-M), Crystal Reports, Visio, SharePoint Portal
Platforms: MS Windows, UNIX (Solaris), Linux
Industry Experience: Banking, Sales, Marketing, Compliance, Call-Center, Consumer Packaged Goods and POS (Point of Sale) Retail
PROFESSIONAL EXPERIENCES:
Morgan Stanley Investment Management, Chicago, IL
2000 - 2013
Senior CRM Database Developer / Business Systems Analyst
Managed both in-house ASP.NET and Siebel CRM databases and applications for over 700 users.
* Database design administrator for four CRM Databases running SQL Server, Sybase, DB2 and Oracle. Coordinated quality assurance testing and enterprise deployments.
* Managed CRM infrastructure and SDLC (software development lifecycle). Responsible for business continuity, critical path analysis, reporting, risk and change management procedures.
* ASP.NET CRM software developer and trainer for 10 off-shore developers and support staff.
* Partnered with Sales management and SME`s as Business Systems Analyst. Documented business and functional requirements, Statement of Work, technical designs and test plans.
* Designed and Developed SQL Server Database for Marketing Approval Management System.
* Designed and developed both CRM and European SICAV ETL Informatica workflows.
* Managed four ETL applications with over 60 Informatica workflows using AutoSys schedule, and UNIX shell scripts and Netcool Alerts.
* Managed over 100 Business Objects BI reports and saved $20K per year in infrastructure costs.
* Integrated new central contact and client data services saving business $100K annually.
* Increased Data Warehouse overnight batch performance by 200%.
* Onboarded support teams and increased developer productivity by 30%.
* Integration EmailLabs marketing campaigns data into CRM front end and backend databases.
* Integrated and supported three 3rd Party vendors applications using SQL Server, DTS, T-SQL, Reporting Services, ASP.NET, Informatica and AutoSys
Database Design Administrator
Responsible for developing, maintaining, and enforcing database development standards of www.MSIM.com Global Product Database. Administered replication between internal database and DMZ Databases. Managed logical design and change management scripts using CA Erwin Data Modeler and Sybase Turnover tools.
Project Manager for Compliance Workflow Tool
Developer and Project Manager for firm`s Compliance marketing materials approval system using Savvion Java workflow platform saving firm over $100,000 a year in printing expenses. Managed and trained two developers. Requirements gathering, website wire-framing, webinar meetings with clients in New York, London and Chicago offices, and coordinating user acceptance testing. Tools included Savvion Workflow, Java, MS Project, FrontPage, LiveMeeting and SharePoint.
The Quaker Oats Company, Chicago, IL
Business Intelligence Developer and Analyst
1998 - 2000
Provided technical expertise and support for delivering Quaker's Syndicated Data to Marketing and Sales teams. Supported AC Nielson Excel VBA add-ons and Visual Basic Cooler Pro Space management software.
* Full Life Cycle Development experience in Quaker's Business Intelligence reporting system. Work directly with clients to document reporting specifications. Work closely with other developers to design, test and implement new reporting structure using Business Objects.
* Upgraded the Gatorade business unit category and plan-o-gram management tool using Visual Basic. Able to deliver application in time for the fall 1999 planning session
* Usage Trend Analytics - Developed database to track and report trends and exceptions of firms` syndicated data using Visual Basic and MS Access.
Information Resources, Inc., Chicago, IL
Database Developer and Point of Sale Communications Specialist
1992 - 1998
* Designed and implemented helpdesk application to track all Decision Support Data and issues in central database reducing research and troubleshooting time by 33%. Application designed in Visual Basic and Microsoft Access.
* Redesigned outdated Access databases for growing multi-user environment.
* Developed ad-hoc database queries and reports for users.
* Developed and automated applications for electronic communication of market research data from 1000 clients nationwide.
Ace Hardware Corporation, Oak Brook, IL
Point of Sales Trainer and UNIX Support Analyst
1990 - 1992
Install, trained and supported point-of-sale systems for Ace Hardware stores on in PACE software (point-of-sale, inventory and accounting software).
EDUCATION
* DePaul University: Enrolled in Graduate Program - College of Computing : Business Information
* University Of Illinois: Bachelor of Science, College of Business Administration
Majors: Information Decision Sciences & Marketing - June 1990
Contact this candidate