SUMMARY

• Over 10 years of experience in Information Technology with a focus in Business Intelligence Business Objects area serving both Private sector and Government Contracts.
• Worked extensively with Business Objects Enterprise Suite, Data migration, Data cleansing, Data profiling, ETL Processes, Data mining, Data audits, Webi Reporting, Tableau desktop and server.
• Expert in designing, implementing, distributing and maintaining Business Objects Universes, Deski reports and Web Intelligence reports, Tableau Desktop and Server.
• Excellent administration skills to manage the environment, server, users, groups and security setup for BOE/DI/DQ/Tableau tools.
• Good experience and knowledge of Data warehousing RDBMS concepts including OLAP, dimensional modeling using Star Schema and Snow-Flake Schema designs.
• Specialized in creating complex query reports using Oracle, SQL Server 2008 and 2012
• Experience in debugging and performance tuning of Business reports and ETL jobs
• Involved in Full life cycle analysis, design, networking, development and deployment of Business Objects reporting Applications with Web Intelligence and Broadcast Agent

TECHNICAL SKILLS

LANGUAGES DEVELOPMENT TOOLS:

Languages: VB, C, C , Java, Asp, SQL, PL/SQL

Reporting Tools: Business Objects 4.1, 3.1, XI R2, CMS, CMC, Crystal Reports, Web Intelligence Rich Thin Client, Publisher, Desktop Intelligence XI 3.1/ XI R2/6.x/5.x Supervisor, Designer, BO Reporter, Web Intelligence, Rich Client, LCM ,Dash Board Manager, Infoview, BCA, BO Auditor, Xcelsius 2008

ETL Tools: Data Integrator, MS SQL Server

Internet Technologies: ASP.Net, HTML, XML, PHP

NETWORK SYSTEMS TECHNOLOGIES: Web Server: IIS, Apache

DATABASE MANAGEMENT SYSTEMS TOOLS: Oracle, MS SQL Server, Sybase, MYSQL

DATA MODELING SYSTEMS TOOLS: Microsoft Visio, Erwin 3.5

PROJECT MANAGEMENT Microsoft Project, Microsoft Office, SDLC, Scrum

SUBJECT MATTER EXPERTISE OTHER SKILLS: Business Objects Development, Business Analysis, Data Analysis, Gap Analysis, Dashboard Creation for Performance Management, Report Generation Performance Tuning, Data Warehousing, ETL Extract/ Transform/ Load Processes, Oracle Database Administration, Production Support

PROFESSIONAL EXPERIENCE

Confidential

Senior Associate

• Lead a team of 4 developers and 2 Business Analysts in Universe Design, WEBI Reporting, Xcelsius dashboard design and a migration of WEBI Reports, Folders, Category, and Universe from BO 3.1 to BO 4.1.
• Perform business analysis of client data processes and procedures.
• Design database schemas and resulting SQL scripting to support business intelligence needs.
• Served as and worked with a Database Administrator DBA to create and manage physical database in MS SQL Server
• Design and implement ETL processes to populate data models.
• Install, configure BO 3.1 and 4.1 and develop reporting within the SAP Business Objects platform.
• Build role-based user security models for data access in SAP Business Objects
• Design and develop Transact-SQL stored procedures to integrate BO with MS SQL.
• Perform unit, integration and system testing of software solutions.
• Support acceptance testing of software solutions.
• Perform configuration management of software solutions, including release promotion.
• Perform regression testing of production-promoted solutions.
• Manage operational solution performance via application and data tuning.
• Enhance operational solution as new business features are illuminated.
• Define maintain Data Naming and Data Definition Standards.
• Create Maintain Conceptual Logical Data Models.
• Implement Section 508 accessibility tool in both BO environment 3.1 and 4.1
• Utilized Agile/Scrum software development methodology in implementing both software application and report development.

Confidential

Senior Lead Business Objects Developer/Administrator

• Led a team of 3 developers and 1 Business Analyst in Universe Design, WEBI Reporting, and Xcelsius dashboard design. Migrated WEBI Reports from BOXIR2 to BOXIR3 upgraded Business Objects XIR2 to 3.1 with repository migration tool and Import Wizard. Set a new BO 3.1 and BO 4.0 Environment.
• Successfully installed and configured Business Objects 4.0 and 3.1 on Staging Environment, Applied Service Pack and fix pack.
• Clustered the servers successfully to make the Business Objects Environment Highly Available and ensure FAILOVER works efficiently.
• Used Import Wizard and Upgrade Manager to migrate all the objects from BO XIR2 to BO 3.1 and to BO 4.0
• Tested all the reports that are migrated and analyzed the performance of the BO 3.1and BO 4.0 using Load Runner by creating many virtual users.
• Maintained the whole environment TEST, DEV and PROD along with 8 main servers.
• Scheduled repository backup and tuning the Business Objects servers for a better performance.
• Performed server management tasks, using Central Configuration Manager CCM and Central Management Console CMC including the configuration of servers including File Repository Servers, Web Intelligence Job and Report Servers, etc.
• Applied patches, hot fixes, critical fixes, service packs and testing/applying security patch.
• Involved in Data Modeling with Erwin both Physical and Logical Design
• Designed the Universe with the ability of adhoc reporting for users
• Defined Access Restrictions and priorities in the universe for User groups with various levels of confidentiality and applied security features of Business Objects.
• Applied Drill Filters, sorts, breaks and multiple Tab reports with charts, crosstabs format, master/detail report.
• Designed and developed interactive Dashboards using Xcelsius 2008.
• Performance tuning on dashboards by optimizing number of LO connections and applying LA Fix by replacing jar files on the Tomcat Server.
• Documented the design of Universe, detailed classes / objects information, WEBI Reports and dashboards, and all changes made using macro enabled excel for future reference.

Confidential

Lead Business Objects Developer

• Performed requirement gathering, analyzed the new requirements, wrote the functional requirement documentation and estimated man-hours.
• Worked with BO Designer, Infoview, Web Intelligence, Web Intelligence Rich Client, Desktop Intelligence, CMC, CMS, LCM and Crystal Xcelsius.
• Worked with Business Objects XI 3.1/XI R2 Administration e.g., Creation of Users , Groups and controlling their rights to reports, security set up at folder level, group level, Installation, Windows AD Configuration, Certification to use server authentication
• Worked with Business Objects Security Viewer to create and view existing security setup
• Installed and Configured Business Objects Enterprise Suite, DESKI, Rich Client, Webi Server, Life Cycle Manager Implementation.
• Implemented Single Sign-On utilizing Windows Active Directory Authentication.
• Executing system test and validating the applications against defined requirements according to the documented scripts and success criteria.
• Oversee data mapping, migration, testing and conversion of Data Warehouse redesign in conjunction with core banking system replacement GFS Unisys-Mainframe to a new FIS Core banking system
• Developed data models using Erwin and MS Visio. Designed and developed data mart to produce logical and physical snapshot models. Designed ER diagrams, logical model relationship, cardinality, attributes, and, candidate keys and physical database capacity planning, object creation and aggregation strategies for Oracle and MS SQL per business requirements using Erwin
• Defined Calendar, based on user requirement and scheduled reports. Modify report content and export reports in multiple formats, based on user input.
• Participated in recursion, unit and QA testing of the screens that were developed. Tested the reports thoroughly created by other developers, as per the report specifications.
• Used Central Management Console and Infoview to manage users, objects, security at both user level and object level as well as scheduling the reports.
• Gathered required information from Business users and created universes for Sales, Decision Support System, Operations, Budget and Forecast using Business Objects XI 3.1/ XI R2.
• Provided Tier-3 production support for Business Objects reports and universes
• Created Classes, Sub Classes, Objects, Hierarchies and List of Values LOV's in the Designer and exported the universe into Repository.
• Wrote documentation for Universe and Reports
• Utilize LCM to create document source and Publishing reports.
• Developed functional requirements and data specifications for ETL Process
• Used Data Integrator XI R2 for migrating data from various databases to the Data Warehouse
• Extensively worked on creating Dimensional Data Model for New Business from Operational Data Sources
• Created Jobs, Workflows and Data Flows according to their Business and implemented their business logic.
• Implemented Business Rules in Data Flow mappings to Load Datawarehouse
• Monitored Jobs with Data Integrator Web Administrator
• Performed Performance tuning of Web Intelligence Servers, Tomcat and LCM.
• Implemented Service pack, Feature Pack and LA fix installation to optimize server performance.
• Converted reports developed in Desktop Intelligence to Web Intelligence reports utilizing Report Conversion Tools.

Productivity Analyst

• Involved in various business operations and helped the organization to achieve cost-effective production with increased quality, efficiency and satisfied customer service.
• Perform in-depth analysis of branch productivity and profitability to identify opportunities to maximize the value of the branch network.
• Developed detailed reports to evaluate data for branch networks using SQL, Excel and Business Objects.
• Participated in data mapping, testing and conversion of Data Warehouse redesign.
• Analyzed and validated data conversion, new table creation for banking core system replacement to be pared with the bank's business need.
• Crafted multiple web site pages for documentation, best practices and banking information for branch employees.
• Utilized divisional intranet site as a report publishing portal for repots from vendors and manually created Excel reports.
• Worked with multiple environments such as UAT Development and QA and Production
• Generated Web reports, using Business Objects Web Intelligence
• Exported reports into various formats like PDF, Excel, and Word for the convenience of the end users
• Provided training on Business Objects to more than 1,000 Peoples United Bank employees

Confidential

Technical Support Analyst

• Provided technical support to customers over the phone and by e-mail regarding domain registration, domain renewals, domain transfers, web hosting Unix, Windows , e-mail setup Outlook, Outlook Express, Eudora, Netscape , Primary and Secondary DNS services, domain forwarding, email forwarding and other related duties.
• Troubleshot streaming video issues Real media, MPEG, Windows Media Player
• Troubleshot to assist clients with technical issue on web hosting.
• Regularly documented support-related material as required -Escalate support-related issues to Team Leader and Customer Support Manager as appropriate.
• Installed troubleshoot Web hosting and various applications on Windows UNIX platforms.
• Participated in a 24X7 on-call rotation, monitoring and working on network and server issues until they are resolved
• Configured/Maintained/Troubleshot/Updated Windows Server 2003, MS Exchange 2003, IIS servers and Linux Servers.
• Configured/Maintained/Troubleshot/Upgraded hardware/software of Servers, Switches and Workstations.