Senior Engineer Business Intelligence Resume NY - Hire IT People

SUMMARY:

Leading an effort to create a BI self service environment for all enterprise data. The environment includes a Terdata database, Microstrategy BI tools and Informatica ETL software. The data is transformed into information that can be used to improve the customer experience and provide efficiencies in the call center and marketing/sales work flows.
Managed developers skilled in PeopleSoft using Application Engine to create data marts to be used in Cognos Powerplay Cubes. This job required technical hands on interaction as well as project management and being the customer liaison.
PeopleSoft EPM collects data from other PeopleSoft sources such as HCM, CRM and FSCM. The data is extracted and loaded into EPM. The data loader and data mart processing involves validation, data mapping and denormalizing. The tables output from the Data Mart processing are used as dimension and fact sources for the Cognos Powerplay Cubes. I have held Application Lead positions within FSCM and EPM.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Engineer Business Intelligence

Responsibilities:

Working as a Sr. Business Intelligence developer and architect building a Sales and Marketing self service environment. This role includes meeting with the business owners to set the requirements for the attributes and metrics desired. It also includes creating schema.objects: metrics, attributes, facts and report objects. Once the objects are created I showcase the enhancements to our business users through sample reports and dashboards. The design of the environment is based on Kimball concepts using star schemas. We use Object Manager to create our migration packages.
The environment has been implemented on Microstrategy 10.2 reporting front end. The data sourced from Oracle, Netezza and SQL Server.
Supported analysis of call center data and outgoing calling programs. I have four years of building Microstrategy reports for Appointment Notification, Automated Collections and Missed Appointment calling programs. Have 10 years of Cognos development experience including Report Studio, Framework Manager, Cube Builder and Administration.
Supported an internally built Customer Survey system which is now generating 40 million surveys per year. The resulting Microstrategy reports and dashboards are used for incentives and coaching of our Customer Services Reps and Technicians.
. Have certification in Microstrategy Project Design.

Confidential, NY

Manager Information Delivery

Responsibilities:

Managed a Business Intelligence group of Senior Professionals Responsible for specifications, coding and migrations in Peoplesoft FSCM, EPM and HRMS, COGNOS Powerplay, Impromptu. This role included meeting with the functional area managers to prioritize work and review status.
6 years experience in Designing, creating and maintaining Cognos Cubes and Report studio reports. Started with Cognos 7.1 and most recently worked in Cognos 8.3 including Transformer. Responsible for production support of 55 cubes produced daily for 1200 users.
8 Years experience Programming in PeopleTools, PeopleCode,Crystal, SQL, SQR, Application Messaging and Application Engine. Installation and Upgrade experience with Peoplesoft and Cognos.
Completed training in Peoplesoft PeopleTools, Application Engine, SQR, Asset Management, Billing, Order Management, Upgrade.

Confidential, NY

Senior Systems Engineer

Responsibilities:

Responsible for Specifications, coding and migrations in Peoplesoft Oracle Order Management.

Confidential

Senior Systems Analyst

Responsibilities:

Transitioned from Intern to Programmer using APL language, COBOL, Oracle and UNIX. Worked in several functional areas: Finance, Distribution, Budgeting, Payroll, Billing and Order Management.