SUMMARY:

• Have 7.5 years of IT experience in Business Intelligence and Data warehousing with extensive knowledge in Business Objects and Tableau
• Experience in Interacting with Business users to analyze the business process and requirements and transforming requirements into screens, documenting and rolling out the deliverable.
• Interact with client engagement team, work on new project proposal and responsible for deliverables that are being completed within the base lined time scale.
• Expertise in design, deployment and maintenance of BI tools in UNIX (AIX & Sun Solaris), Linux and Windows platforms.
• Have experience in configuring SAP Integration kits, PeopleSoft Kit, LDAP and Active Directory.
• Good knowledge in designing BusinessObjects Security model according to the business requirements and standards.
• Excellent analytical, problem solving, decision - making and presentation skills with ability to co-ordinate activities in a fast-paced team environment.
• Self-motivated, adaptive to new technologies, analytical, problem solving, team player with good interpersonal and communication skills with a strong emphasis in BI Infrastructure.
• Provide adequate knowledge transfer sessions to the new members in the team.

PROFESSIONAL EXPERIENCE:

Confidential, Columbus OH

BI Architect/Manager

Environment: SAP Business Objects, Teradata, DB2 & Tableau 8.x, Windows Server 2008

Responsibilities:

• Involved in Server Administration, Configuration, Maintenance of Tableau Servers
• Monitoring Tableau Background tasks, server activity and User activity.
• Tableau version Upgrade from 8.0.6 to 8.1.8
• Troubleshoot Tableau worker services and gateway services in case of performance or server not responding.
• Working with Tableau vendor for product bugs and license key renewal.
• Working with APPMAP team to package the Tableau desktop version for software distribution to BI Developers.
• Collaborate with end users, project stakeholdersto onboard new project to Tableau BI Environment.
• Migration of BO Symantec layer from DB2 to Teradata (Around 200 Universes)
• Supervise a team of 10 members (Including contractors) who are responsible for universes and reports conversion.
• Created Project plan for EDW BO Reports rationalization and Application Decommission.
• Identified BOE Objects by running audit reports and cleanup of obsolete Objects, users, user groups, connections and universes.
• Collaborate with end users, project stakeholders and support partners to identify needs, goals, and business models.
• Assess the current state of BO Universe and Report usage and identify opportunities for improvement and best practice recommendations.
• Migrated the applications from version BO XI 3.1 to BO BI 4.0 using Upgrade Management Tool and BO XI R2 to BO XI 3.1 using Import Wizard.
• Experience in Scheduling the processes and administering the BO activities in Business Objects XI 4.0/3.1/R2.
• Review the performance of the associates working in the project at the time of appraisal.
• Provide Status and Progress reviews to Executive sponsor.
• Created Effort and Schedule Estimates, Project plans weekly and Monthly status reports.
• Involved in screening new profiles, Co-ordinate to Onboard team members, build project team and setup onsite offshore co-ordination model.

Confidential, NY

BI Lead Administrator

Environment: SAP Business Objects, Microstrategy, Oracle, Sun Solaris

Responsibilities:

• Performed BOXI R2 SP6 to BOXI 3.1 SP4 upgrade and BO 3.1 to BO 4( in sandbox)
• Responsible for server sizing, configuration, space estimation, and complete architecture of new R3 environments.
• Developed Upgrade plan and involved in overhaul of BOXI environment.
• Performed report rationalization, new user group creations and cleanup of obsolete reports, users, user groups, connections, universes and other BOE Objects etc.
• Performed BOE objects migration from XI R2 to XI 3.1 using Import Wizard.
• Coordinated with UNIX team for server build and installation of Apache, Tomcat 6, and Siteminder.
• Created UNIX scripts for automating log file cleanup, server restarts, etc.
• Performed periodic cleanup of Audit database (DB team co-ordination) and File system pruning.
• Designed and configured security for BOXI R3. This included setup of LDAP (Sun Directory Server) and SSO (Webgate & OIM) as well as BOXI User Groups, Access levels, universe and folder access, etc.
• End to end MSTR implementation in Linux servers.
• Designed security model in MSTR
• Co-ordinate with BO Developers and BA’s to convert reports from BO to MSTR
• SSO and LDAP implementation in MSTR
• Successful deployment of Microstrategy BI DEV, TEST, UAT and PROD Environments.

Confidential

BI Administrator

Environment: SAP Business Objects, Teradata, SQL Server, QlikView, Windows

Responsibilities:

• Move to Prod(BOE Objects and Qlikview Applications)
• Involved in BO XI 3.1 Upgrade Activities
• New BOE Objects creation (E.g.: Folder, category, calendar) and assigning rights to the respective groups
• Import User groups
• Password update in crystal reports DB settings
• DSN Creation/update
• BOE Objects Deletion/Backup
• Troubleshooting BOE server services
• BO server services monitoring
• Fixing performance related issues
• Incident Handling (Providing solution to the users from BO end for errors).
• Deployment of Qlikview jobs to Production environment.
• Monitoring QV Jobs and QV Servers
• IIS service monitoring.

Confidential

BO Administrator

Environment: Business Objects, AIX UNIX, Oracle 10g

Responsibilities:

• Responsible for administering a dozen of applications hosted in BOXI R2 SP4 BI Platform.
• Installation, Configuration and maintenance Of Business Objects XI R2 SP4 in UNIX Box
• Migration from BOXI R2 SP2 to BOXI SP4/BOXI 3
• Deployed BOXI R2 SP4 in web logic 9.2
• Solving P1 Tickets like server down issues and Report deletion.
• Universe Migration from DEV to UAT and UAT to PROD
• Report Migration from DEV to UAT and UAT to PROD
• Handling the green zone for applying Fix pack LA 43, LA 48 and C++ Run time library patches.
• Business developers and solving the queries by having a Net meet with them.
• Clearing the log files from BO logging directory.
• Raising CASE to SAP for any clarifications on BO SDK file modification or Product Bugs.
• Configured the trace log files in BO BI 4.0.
• Troubleshooting security related issues and fix minor bugs encountered in BO XI security model.

Confidential

Support Engineer/ Windows Backup Admin

Environment: BO Crystal Reports, Windows

Responsibilities:

• Involved in Analysis of reporting requirements.
• Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Modified the universes and implementing data access restriction according to the business needs.
• Created classes with Dimension, Detail & Measure Objects and specified the hierarchies.
• Modifying the existing Universes by Adding new objects
• Created daily, weekly, monthly and quarterly reports for the management team and finance team
• Administering Windows 2000 and 2003 server.
• Taking weekly backups from Oracle server in a tape drive
• Troubleshooting IBM Servers.