Senior Obiee Lead Resume
St Louis, MO
SUMMARY:
- Highly - motivated experienced analyst with an exceptionally strong track record of proven professional and academic success. Enthusiastic, energetic, and dedicated self-starter who has consistently ranked as a top performer and is driven to exceed expectations. Strong client facing communication skills at all levels, within global as well as entrepreneurial environments. Deeper technical expertise in OBIEE, Salesforce, Pipeline and BMC Remedy.
TECHNICAL SKILLS:
Technology and Tools: XML Pad, Ultra Edit, Benthic Golden, Putty, Informatica Workflow Manager, Test Director, Microsoft Office, (Visio, Project, Outlook, Word, Excel, SharePoint, PowerPoint), PeopleSoft CRM, PeopleSoft Finance, Salesforce Service Cloud (CRM), LDAP, Microsoft 2003/XP, Vista, Windows 7, UNIX, Mac OS X, MS Office Suite 2003/2007/2010 , Symantec Endpoint Protection, CAD, Photoshop, MS Server 2003, Active Directory, LAN/WAN, TCP/IP, VOIP, VPN, MS Access, MS Visio, MS Project, PGP, Track-It, Snagit, VMware, Remedy, Novell Services, Lotus Notes, Altiris Carbon Copy, GoToMeeting, Ventrilo, Spark, Clonezilla, OTRS, Sharepoint 2003/2007, Altigen IP 705, ShoreTel IP 560, Sophos, Google Suite
Programming skills: (Basic) - SQL Server XML, DAT, TOAD
PROFESSIONAL EXPERIENCE:
Confidential, St. Louis, MO
Senior OBIEE Lead
Responsibilities:
- Monitored ETL batch jobs and did performance tuning
- Debugged complex SQL queries.
- Carried out hands on DAC scheduling and monitoring
- Conducted root cause analysis and resolved the issues within SLA.
- Presented permanent solutions to IT.
- Estimated efforts and carried out some ITIL support processes.
Confidential, Fargo, ND
OBIEE Developer (OBIEE 11g)
Responsibilities:
- Effectively interacted with the end users for requirement gathering and defined requirement specifications document
- Assisted with the upgrade of OBIEE10g to OBIEE11g
- Worked extensively with Physical Layer, Business Layer and Presentation Layer.
- Created numerous executive level reports. 'Dashboards' were generated to provide insight into the financial data.
- Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables, created Kimball Matrix
- Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
- Built Business model and established relationships & Foreign Keys Physical & Logical between tables.
- Created business reports using BI Answers as per requirements.
- Generated various Analytics Reports using global and local filters.
- Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
- Added users and configured security in web logic console of OBIEE 11g.
- Managed security privileges for each subject area and dashboards according to user requirements
- Setting up LDAP authentication to enable SingleSign on for Users in Development environment leveraging Analytics Repository.
- Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
- Created workflows for full load and incremental loads to be used by DAC, worked with two offshore developers to ensure delivery and accuracy
- Assembled subject areas and created execution plan and accommodated the new Informatica mappings.
- Monitoring Incremental & Full load through DAC.
- Trained End Users and Pilot Users about OBIEE Tools.
- Responsible for installing, configuring, developing, support and maintenance of the BI APPS.
Confidential
Information Technology Specialist
Responsibilities:
- Served as liaison to the business community, to ensure that its needs are fully understood by the project team.
- Supported the development in Salesforce and associated systems (namely Compass: in house ticketing submission system)
- Researched and understood force.com capabilities to recommend best design/implementation approaches to meet business requirements
- Provided Ad hoc support work for the group sales team
- Managed Global Market Assignment in Pipeline
- Created Reports and configured Dashboards to detail Sales Team Performance
- Integrated existing helpdesk process flows into the Remedy Service Desk modules.
- Implemented business requirements as they pertain to BMC Remedy applications.
- Interacted with customers and partners to solve critical software problems or issues
- Created numerous surveys using Google Forms for wide ranging business needs
- Lead enterprise wide new hire deployment and iPad Sales class
- Administrator for enterprise wide antivirus and acted as liaison with AT&T for Data plans
- Daily troubleshooting not limited to phones, printers and network connection issues
- Prepared users for migration to Windows 7 and making sure existing data was backed up and transferred
- Identified hardware, operating systems, applications and device drivers
- Cross d with the hardware requirements for Windows 7 and prepared image repositories
- Analyzing and reconciling existing licensing usage patterns and costs
- Helped determine what would be included in our Common Operating Environment (COE)
- Deployed our COE and back up user data during the migration
- Ensured that the migrated Windows 7 systems are patched and secured as quickly as possible
- Simplified the provisioning process by reducing image updates and maintaining images
- Scheduled staff to ensure Help Desk coverage during normal business hours and on-call support as required
- Responsible for assuring users are provided efficient and timely first and second level support on a 7x24 basis
- Monitored the problem management database and follow up directly with the Information Technology Director to ensure the timely resolution of problems
- Maintained a central source of information enabling Help Desk staff and support technicians to recover outages with minimal disruption to expected service levels
Confidential
Level II Support Specialist
Responsibilities:
- Created and updated schedules in Microsoft Project
- Performed gap analysis on business requirements for new Customer Relationship Management system (CRM)
- Conducted multiple process mapping sessions for a enterprise wide Digital Assets Library Project
- Documented processes using Microsoft Visio based on process mapping sessions with multiple department representatives
- Prepared deliverables required for multiple projects according to the System Development Life Cycle (SDLC) & Project Management Life Cycle (PMLC)
- Gathered business requirements for information system projects
- Created PMLC deliverable templates to be used in future projects of Project Management Office (PMO)
- Performed User Acceptance Testing for a web based registration system
- Organized and conducted business requirement feedback sessions for new CRM based on gap analysis
Confidential
Business Technology Consultant
Responsibilities:
- Created new contacts, client accounts, and troubleshoot account problems
- Assisted in process improvement projects and make system automation recommendations
- Maintained client relationships with timely and professional email correspondence
- Set up administrator access to Blackboard support website
- Terminated customer accounts by uninstalling products and terminating access to Blackboard products
- Conducted data maintenance in PeopleSoft
- Routed purchase orders to appropriate departments
Confidential
Customer Service Representative
Responsibilities:
- Handled various accounting transactions and reconciliation tasks within the branch’s IT domain
- Provided account status data whenever requires and handled client facing enquiries
- Informed customers about various services that included innovative technologies
- Supported Online Banking as well as International Money Transfers in a client facing as well as telephonic setting
Confidential
Information Technology Specialist
Responsibilities:
- Monitor and support medium sized Intranet network, used by over 1100 students, faculty, and staff.
- Provide Level I support by diagnosing hardware, software or maintenance issues.
- Ensured user compliance with Confidential IT policies