SUMMARY

• Certified SAP consultant with 15+ years of extensive experience in Business Intelligence and data governance strategies. Hands on experience with SAP BOBJ, HANA, SAP BW, BEx tools dis includes Data modeling, ETL and Report Development, Crystal reports, OBIEE and Tableau
• Trained DOMO consultant: Handled various roles within Domo (Data consumer, Card builder,Data Specialist, Major Domo).
• Trained in Selligent Tool: A B2C marketing automation platform provides tools that you need to orchestrate moments of meaning that deliver real - time context to each consumer regardless of teh channel they use.
• Data Engineer experience: Ensured that teh data received is defined and transformed in more usable format. Designed and implemented internal process improvement and automated manual process. Optimized data delivery for internal stake holders/teams. Exhibited data base experiences.
• Subject matter expert various BI tool like Domo, Selligent, Business Objects (BO 4/XI R1/R2/R3, 6x and backwards) and SAP BO/BW with experience in Supervisor, Designer, Reporter, BCA Server (Publisher and Scheduler), Web Intelligence 2.5/2.6.1/6.0 , Xi Info view, Application Foundation, Dashboards, Auditor, Schema Design and Launch pad.
• Python/Django developer built robust user web application in python/Django. Performed teh CRUD operations.
• Data analyst experience for 15+ years’ in analyzing, planning, designing, testing and implementing business intelligence Server Configuration, Migration and Development of application dashboards.
• Industrywide exposure connecting data for various modules such as Financials (Accounts Payable, Accounts Receivable, General Ledger and Procurement), Payroll (W2/payslips), Human Resources & CRM in Collision industry, Credit Unions, Government sectors, Telecommunication & Banking sectors.
• Participated in Requirement gathering and worked closely with key business partners (Product management Grps) and streamlined teh dataflow from various sources
• Adapt to Roles varying from data analyst, data optimization consultant, report developer, database developer, data design architect, Data governance gate keeper and 24/7 SLA management support operations lead.
• Across database client/server configuration on Oracle, Teradata v2r6, SQL Server, DOMO and access repositories.
• Data warehouse concepts well understood to improvise Client/Server Architecture, Relational Databases (RDBMS), Data model design and built Data warehouse as well as Data marts using Star Schema for faster and effective querying for teh Metadata Management solutions.
• Experience working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized data models
• Built, designed, and tested various levels OLAP and OLTP reporting systems using Business Objects product suite. Strong skills in interfacing Business Objects with Databases like Oracle, SQL Server and MS Access
• 9+ years of experience as Webi Developer and 3+ year experience in building reports using Crystal 11.
• Well Versed with Migration of Business Objects Environment from one to another version.
• Well versed with performance analysis and tuning within in teh BOBJ Products. Experience in all components of SAP BOXIR3.1 including RCT, QAAWS, LCM, Live Office, Design Studio, Lumira .
• ERP Suite: versatile experience towards ERP systems like SAP ECC, Ramco Virtual works, ORACLE ERP (R12). Followed teh required ASAP implementation methodologies while performing upgrades / implementations related to teh tool.
• Converted Deski reports to Webi reports using report conversion tool (RCT) and solved teh issues during teh conversion.
• Optimized performance of reports and dashboard consistently by implementing SAP prescribed best practices and also noledge gained over years.
• Created Rich Graphic visualization/dashboards to enable a fast read on claims and key business drivers and to direct attention to key area.
• Hands on experience with Oracle BI Enterprise Edition and analytic tools like SAS and Seibel Analytics.
• Experience in coaching training & educating power users in teh use of business intelligence tools and creating training materials.
• Broad range of mature competencies - creativity, strategy thinking, initiative, team player, coach, organizational sensitivity and resilience. My social media (Linkedin) referrals should speak on my behalf.
• Always interested in finding innovative solutions to problems and had teh courage to pursue new path by familiarizing myself with different tools and mastering teh same & I’m not derailed with difficulties. I’ll make sure I’ll gracefully respond to challenges and ambiguity.

TECHNICAL SKILLS

Databases: Oracle 9i/10g, Oracle 11i,Oracle 12,Oracle Express Server, Oracle Discoverer, SQL Server 2000/2005 Sybase 12.0, DB2,Netezza, Teradata v2r6, DOMO & Symitar systems

ETL tools: Informatica PowerCenter7.2/6.1.x(Workflow Manager, Workflow Monitor Worklets, Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformations)

ERP Tools: SAP ECC, Oracle ERP, Ramco Virtual works

BI Tools: Business Objects 4.2/4.0/R3.x/R2 Desktop Intelligence, Web Intelligence, Infoview,BI Launchpad, Designer, Information Design Tool, CMC, Xcelsius, BI Services, QAAWS, Live Office, Lumira, Design Studio, SAP Mobile, Import Wizard, LCM, Promotion Manager Tool, BEx Query Designer, BEx Analyzer, SAP GUI., Live Office, Web Services, OBIEE, Mantissa for Mainframe, Domo, Selligent.

Query Tools: TOAD, SQL Navigator, Nexus, Teradata Sql Assistant,SSMS

Modeling Tools: VISIO, Erwin

Programming Languages: SQL, PL/SQL, Oracle Forms 6i, C/C++, HTML/XML, Visual Basic 6.0

App Servers: Apache Tomcat, IIS

PROFESSIONAL EXPERIENCE

Confidential, Chicago

Senior Lead BI Solution consultant

Responsibilities:

• Deploy SAP IDT universe by consuming all required tables and views from Salesforce system using a relational connection via oracle Exadata.
• Participated in Requirement gathering and worked closely with key business partners (Product management Grps) and streamlined teh dataflow from various sources
• Assembled complex data sources/sets that meet teh client functional and not functional requirement
• Developed Webi reports, dashboards to run against dis newly developed universe & Import and export data to different sources.
• Exhibited strong analytical skills related to working with unstructured data sources
• Provided all required insight related to all interrelated systems (salesforce & Einstein Analytics)
• Provide snapshot of department performance within a certain time period
• Gather data for specific departments or service types
• Meet with city PMO’s and Technical leads to understand teh GAP in teh current system and tailor SAP BI development to overcome Salesforce R&D limits.
• Follow Agile Methodology, during each sprint, client requirements are gathered and then built within a short timeframe (typically 2-3 weeks). Upon completion of each sprint, teh functionality is presented to teh client for feedback. Teh feedback is then added as new requirements and used to enhance teh product in following sprints. After several sprints, teh product will reach a point where teh core functionality is in a workable state and a full end-to-end process is possible.
• During UAT, any bugs and issues that may has slipped through teh development team’s Quality Assurance (QA) testing will be identified. Once UAT is complete for teh release, teh product will go into another set of sprint cycles where further development and enhancement of teh application will occur.
• All user feedbacks and enhancement were documented and prioritized using Ask Astro feature in Salesforce.
• Provided training to all city power users consuming dis universe and facilitated in creating reports and dashboards.
• Provided detailed documentation related to all objects available in teh business layer.
• Security was built at row level. Created close to 100 security groups. Tested & made sure teh system in place works fine on all circumstances.
• Ensured that all client technical, business and delivery expectations are met Python/Django
• Built a user interface in Django to perform basic CRUD operations for fleet management system
• Created a website layout for user interface by using Django and updated teh source accordingly.
• Exhibited noledge of SQL/Oracle experiences Domo
• Piloted Domo for Fleet management system and executed implementation for a small user community
• Provided all details pertaining to data definitions/schema/lineage
• Supported data cleansing and incorporated files from different sources.
• Exhibited Data Governance and performed activities pertaining to major Domo
• Partnered with Domo customer service team to resolve issues

Confidential, Des Plaines

Sr. BI Consultant/ Data Optimization Consultant

Responsibilities:

• Create stored procedures/Views to enable automatic data uploads across systems.
• Import and export data to different sources like (selligent (SQL server), salesforce, Domo, Google analytics)
• Assembled complex fata sources/sets that meet teh client functional and not functional requirements and mapped them to digital marketing team requirement
• Designed and implemented internal process improvement and automated manual process ( credit card and debit card process)and optimized data delivery.
• Ensured that teh data received is defined and transformed in more usable format for data scientists and marketeers to perform their work.
• Participated in Requirement gathering and worked closely with key business partners (Product management Grps) and streamlined teh dataflow from various sources
• Created Business Objects UDT universe for marketing team and provide ongoing support and created reports for management team using Domo.
• Created required dashboards to understand teh trend in product usage
• Identify online bankers and create a target audience list.
• Identify potential members who will be interested in buying more products from Alliant
• Automate few processes in Selligent Campaign tool using stored procedures
• Create visualization cards using tools like Domo and SAP Business Objects BI4
• Identify Gaps and improve their standard processes within teh team
• Develops, coordinates, and executes implementation/conversion project plans
• Collaborated with managers to manage all changes in scope.
• Applied project governance to all required implementations.
• Reported on project progress and changes in time frames.
• Completed troubleshooting tasks, including reconfiguring and communication validation, to ensure rapid resolution of data inaccuracies and prompt delivery of data to stake holders.
• Worked with teh cross-functional partners to support and assist in teh development of long term implementation decision solutions, with technology as a key enabler.
• Documented and maintained all business process and workflow solutions. Documented business solutions with technology as an enablement.
• Owned, analyzed, and supported business process components of implementation through Agile project delivery model.
• Create and build SQL queries to be analyzed and generated into reports.
• Independently perform data analysis for conversions and integrations across data mapping, business rules, and data quality.
• Ensured that all client technical, business and delivery expectations are met Gained a high level of technical and product noledge experience, including:
• SAP Business Objects 4.2 or later SAP’s Universe Designer Tool (UDT) and newer Information Designer Tool (IDT)
• Selligent
• SQL / stored procedures/ views/ maintaining teh table structures and perform various ETL processes to maintain data on daily basis
• Created various reports/ dashboards by consuming data from different sources ( Domo, selligent, Salesforce, Google analytics, SQL server, spreadsheets etc)
• Relational database design, cardinality, and constraints
• Web Technologies
• Provided cross coverage support, as project workloads dictate.
• Effectively worked with requirements and team members to transition work between SDLC phases, whether in a waterfall or agile software delivery methodology.
• Developed various Domo report and helped teh marketing team heads to decide on teh campaigns and product launches.

Confidential

Sr.BI Consultant / Data Analyst

Responsibilities:

• Communicate with internal business partners to identify and scope out business requirements.
• Participated in Requirement gathering and worked closely with key business partners (Product management Grps) and streamlined teh dataflow from various sources
• Interpret data for trending and decision models
• Developed and maintained Business Object Universe(IDT) and Business Object Reports
• Effectively managed and maintained environments (Development, UAT, and Production)
• Design, develop and test Business Objects back end components (e.g. Universe, data connections, data extractors) and Business Objects Solutions (e.g. Reports, dashboards).
• Interact with various business units independently
• Special projects as assigned by Data Services Lead and Manager
• Report exceptions on report results to Management
• Discuss results with those responsible for products, and recommends necessary corrective actions
• Prepare intermediate-level reports and dashboards
• Identify and extract existing data to manipulate/calculate/format into presentable reports, charts and graphs
• Deliver ad hoc analytical requests
• Troubleshoot teh functionality and accuracy of existing daily reports to ensure accuracy

Confidential, Elmhurst

IT Manager/BI Lead

Responsibilities:

• Establish and maintain accounts and access controls to all BI software applications (currentlyDomo)
• Work closely with BI Specialists to establish data warehouse best practices, naming conventions, and table structures
• Collaborated with engineers to help adopt best practices in data system creation, data integrity, test design, analysis, validation, and documentation
• Address complex internal software challenges that emerge from rapid growth
• Following teh agile methodology to deliver teh project & acted as a PM to deliver teh required results on dis project.
• Aid in providing user, legal and security visibility across all business users to teh senior leadership team
• Monitor software health (users, data sources, etc.) and develop new metrics/monitoring dashboards as needed
• Manage and troubleshoot issues, working with our BI Specialists and external consultants/support teams.
• Collaborate with internal teams to understand their data needs and assist in data connection to our BI Warehouse
• Work with Enterprise Analytics teams to document process and procedures
• Assisted users on excel to validate teh information across Domo Cards and provide few macro to make teh analysis quicker.
• Set interim goals and organize team/task to meet those objectives
• Develop conceptual designs as and when needed to handle organizational changes
• Periodically communicate with vendors and other resource (international) about upgrades/changes.
• Supervise daily task of teh team and escalate things as needed. Like in any other organizations, TBG also has some challenges in rolling out Domo successfully to all business users. Challenges are
• Data is not housed centrally
• Most of teh reports used are governed by spreadsheets maintained manually.
• Data available is not 100% true
• Data is being maintained internally /outsourced by many departments and Business units To list a few we has,
• WRIS (HR data is maintained),
• GP ( Great Plains- MicrosoftDynamicsGP - Accounting/ Finance information in maintained)
• CCC (Operational Transactional information is maintained),
• GNCS (Claims Data is maintained)
• TBG Warehouse: “Shadow system” dis SQL server Instances is maintained by TBG but derived from teh Claims Corp warehouse.
• To clean up and advance teh cause of data as a strategic asset, I laid a Data Governance environment of teams and policies.

Confidential, Chicago

Lead BI Consultant

Responsibilities:

• Ensure tickets are addressed within SLA period
• Coach and mentor peers in new Business Intelligence functionalities
• Monitor nightly scheduled reports and address teh issues on real time basis
• Provide report and universe enhancements as needed
• Support oracle patches and impact both teh database and enterprise reporting
• Participate in upcoming tool upgrades (BO 4.2, Deski to Webi conversion, Tableau, Qlikview etc)
• Ensure governance reports such as Aldermanic reports, purchase orders, Letter head reports and any public facing reports are functioning as expected at all times.
• Propose new initiatives to clients as part of ongoing support enhancements
• Provide user training to power users and facilitate a user forum for business intelligence discussions
• Analyze teh Inventory and audit repository periodically to address teh growing report population
• Execute Payroll automated process and make changes as needed on quarterly basis
• Modify and fix W2 reports based on feedback from Federal Government to ensure compliance

Confidential, Chicago

Lead BI Consultant

Responsibilities:

• Eligible Employees and their deadline (by Name, by Department).
• Training Dates by Employee
• Employees by Training dates
• Training Rescheduling History for each Employee
• All Training by Date/ Training Calendar
• Department personnel who are scheduled to attend a class in teh next 6 months, and all department personnel who failed to attend and their deadline. Reports should show both active and terminated employees.

Confidential, Chicago

Lead BI Consultant

Responsibilities:

• Docking Paycode / Supplemental Reporting - Teh operating department timekeepers refresh an internal report before approving teh pay period cycle.Upon approval, a notification is sent to department employees to take action on any corrections including opting out for electronic delivery of teh pay slip.
• Opt In/Out Automation - dis process will use a DB link to connect to teh TCC Database so that teh employee’s opt/in flag can be retrieved and updated into ChIPPS payroll system. Teh nightly job picks up teh settling changes and a report is blasted out as a notification to employees and payroll supervisors as a publication. Teh flag will then be passed to a rich client report to determine teh dynamic distribution needed. Preliminary scheduled report sets will be executed as part of teh process to validate data and generate a file- watching trigger to serve as an approval for teh bursting of teh final pay slip report.
• TCC Docking Pay code Electronic - Teh final pay slip report publication will trigger on a matching event and deliver individual pdf copies to designated employee (38,000) folders. Teh processing portal server watches for teh new files loaded form Business objects and it matches it with teh respective employee account index folders. Upon user login, a historic representation of documents will be available for preview and print.

Environment: Business Objects XI R3.1 SP 6/ BO 4.2 (CMC, Designer, Desk I, Web I), Tomcat, JSP, Oracle 12, TOAD, PL/SQL, Crystal Reports XI, Crystal Xcelsius, Tableau, SSRS, QlikView, Window 7, Windows 2008 Server, UNIX.

Confidential, Chicago

Sr. BI Consultant

Responsibilities:

• Analyzed teh existing complex mainframe system and assessed current reporting functionalities of teh legacy system (Mantissa)
• Gathered all required customer/ technical requirements from various team members in city treasurer’s office and delivered detailed requirement documentation for dis project with all required pre-implementation and implementation tasks and timelines.
• Based on my understanding of teh report layout and fields used, met with ETL team to derive at teh structural design for teh reporting requirement
• Constantly communicated and coordinated with Oracle Developers to understand teh workflow and accessed teh new CTR workflow to learn teh data flow process
• Synonyms were created and provided access to teh BO database account.
• Created report design templates as a mock-up document in excel for teh new BO Users.
• Suggested possible enhancements by leveraging teh flexibility of BO which was unavailable in teh conventional Mainframe reports.
• Created a new universe based on teh mockup and detailed requirement gathering process with users.
• Complex calculations and conditions were built in at a universe level to assist in a robust adhoc reporting need for teh CTO Users.
• Reports were created with complex data providers, conditions, unions and report variables that sufficed and provided in excess of benefits TEMPthan requested by teh user community.
• Worked with testing team to derive test cases for efficient data validation. Involved in Unit testing.
• Defined Report Level Ranking, Database Ranking and Alerts in Reports based on teh specifications.
• Created Reports using grouping, sorting, totaling, charts etc., and exported reports into various formats like PDF,txt,excel etc..
• Created canned reports from teh scratch for new requirements and modified some of teh existing Finance reports that were used to bounce against teh data flowing from teh new CTR system.
• Involved in peer review, deployment of best practices in Universe and Report design.
• Involved in extensive documentation of teh Universe, Reports for teh CTO/CTR application.
• Trained user community in basic and advanced Business Objects reporting skills.
• Performed analysis for converting all Deski to Webi for teh upcoming BO 4.0 Migration
• Tested reports in new development BO 4.0 environment to perform impact analysis of functionalities lost in teh new BO 4.0 release. Such as macro, personal source for deski reports, free hand sql reports etc.

Environment: Business Objects XI R3.1 SP 6/ BO 4.0 (CMC, Designer, Desk I, Web I), Tomcat, JSP, Oracle 12, TOAD, PL/SQL, Crystal Reports XI, Crystal Xcelsius, Window XP, Windows 2003 Server, UNIX.

Confidential

Lead BI Consultant

Responsibilities:

• Assisted in teh migration of BO XI R2 to XI R 3.1 before starting with teh actual project work.
• Determined various pre-implementation & implementation tasks &timeline.
• Audited teh reporting environment for inventorying all impacted modules
• Created SDK’s to extract repository information that helped build a Matrix to categories teh report change loe
• Extracted and archived all sql queries form all deski reports (majority) as a backup protocol
• Communicated with department users to understand teh usage of all reports in inventory and archived reports based on usage statistics that were gathered.
• Universe changes were done by extensively studying teh EBS Metalink pages for Oracle R12 upgrade.
• Package execution rights for BO connections were setup in oracle and tested in conjunction with teh new table structures.
• Row level security was modified and new groups were created in CMC to fulfill teh security changes identified.
• Complex Report conditions with Not Exists, Sub queries, multiple unions, default recurring prompts and linked reports were modified.
• Synonyms were created and provided access to teh BO database account
• Publications were modified to adjust all incoming changes from teh dynamic destinations report, along with teh source report itself.
• Applied object, folder level security within teh CMC.
• Based on teh best practice and benchmarks of production time recorded, worked on SQL Tuning and Optimization of teh reports.
• Converted existing reports in DeskI to WebI reports using Report conversion tool.
• Elaborated a detailed tasks list along with estimated timeline for migration (Run book activities)
• Created canned reports from teh scratch for new requirements and modified some of teh existing reports.
• Created training documents for end users to assist modifying/ schedule/ refresh teh reports based on their needs. Also, delivered various UPK training materials for end users,
• Trained users across different departments to modify and create reports based on teh Oracle structural changes that were in corporate din teh Universe design
• Worked with ETL team for setting up teh event based trigger to write to BO server and scheduled reports based on teh flag.
• Conducted teh UAT and prepared teh test document and created teh error log document. Advanced end user experience working on Share Point 2007.
• Created report complex reports like GL trial Balance, Invoice payments, Blanket and Standard PO’s etc

Environment: Business Objects XI R3.1 SP3 (CMC, Designer, Desk I, Web I), Tomcat, JSP, Oracle 12, TOAD, PL/SQL, Crystal Reports XI, Crystal Xcelsius, Window XP, Windows 2003 Server, UNIX.

Confidential, IL

SAP BO Consultant

Responsibilities:

• Interacted with teh key members of teh Revenue and Finance team to understand that current process and drawbacks of teh current process.
• Worked with teh ETL team to analyze teh Oracle table changes and teh impact on existing universe/reports.
• Created mock-up reports with changes, based form teh original revenue reports.
• Coordinated team meeting to understand teh drastic changes that teh universe and report logic would go through
• Met with functional experts to gather teh requirements for ongoing modification of teh system.
• Modified universes to retrofit both teh existing and teh new changes proposed by separating out teh contexts per requirement.
• Optimized query performance to 1/10th of teh original time by adding hints, indexes and constantly reviewing teh explain plans.
• Coordinated multiple rounds of testing with teh users across various city departments and educated users on teh new process change.
• After thoroughly understanding teh new ERP workflow, trained users on teh new reports as well as universe changes that benefits for their adhoc needs.
• Added RLS (Row Level Security) at different levels (both internal to department and City Wide) to effectively allow teh Revenue department to capture all data within teh ownership of their module.
• Involved in creating teh L1/L2 support documents for teh scheduled reports.
• Created Macros to print teh Invoices on multiple city printers across various departments by incorporating a printer universe.

Environment: Business Objects XI R2 (CMC, Designer, Desk I, Web I), Tomcat, JSP, Oracle 12, TOAD, PL/SQL, Crystal Reports XI, Crystal Xcelsius, Window XP, Windows 2003 Server, UNIX.

Confidential, Houston, TX

Sr. SAP BW/BO Consultant

Responsibilities:

• Interacted with teh functional experts to gather teh requirements for ongoing modification of teh system.
• Co-Authored SRS document, Functional specification, Test document
• Worked with teh Data Modeler for enhancing teh design for ease of reporting.
• Involved with teh ETL team in developing several Mappings using corresponding Sources, Targets and Transformations.
• Developed/ designed and implemented various SAP BW objects.
• Designed and implemented row level security logic on SAP application.
• Applied object, folder level security within teh CMC.
• Worked with ETL team for setting up teh event based trigger to write to BO server and scheduled reports based on teh flag.
• Worked on various Data integrator jobs to change teh current mapping of teh existing tables or adding new tables in teh database creating data flow for them.
• Scheduled teh reports using Scheduler and ran trouble shoot teh failed reports.
• Designed Universe, Resolved Loops (Chasm and Fan), and Import Universes using Import Wizard.
• Used teh advanced functionality in teh Universe design using @functions.
• Worked on query Tuning and Optimization of teh reports.
• Well versed with use of hints within reports to enhance teh performance of reports.
• Created canned reports from teh scratch for new requirements and modified some of teh existing reports.
• Converted existing reports in DeskI to WebI reports using Report conversion tool.
• Created reports, setup alerts, ranking, graphs, and report level variables.
• Extensively worked on Ad-hoc reports for human resources department.
• Worked with testing team to derive test cases for efficient data validation. Involved in Unit testing.
• Conducted teh UAT and prepared teh test document and created teh error log document.
• Modified teh Parameter file in Universe Parameters to enhance teh reporting
• Involved in building dashboards using Crystal Xcelsius, Live Office and Query as Web services.
• Involved in creating teh L1/L2 support documents for teh scheduled reports.
• Involved in peer review, deployment of best practices in Universe and Report design.
• Involved in extensive documentation of teh Universe, Reports.
• Trained user community in basic and advanced Business Objects reporting skills.
• Gained hands-on experience on various SAP modules such as HR/payroll and other administrative related functionalities.

Environment: Business Objects XI .1, Tomcat, JSP, SAP R/3, Teradata, Crystal Reports XI, Crystal Xcelsius, Window XP, Windows 2003 Server

Confidential, Chicago, IL

SAP Business Intelligence Developer

Responsibilities:

• Responsible for system study & Business Requirements Analysis & Documentation (Technical).
• Applied command restrictions to various existing groups and users restricting different functionalities in Business Objects suite.
• Created user profiles in Supervisor module with varying security profiles for each user.
• Implemented Row Level Securities and Object level security universe to in corporate security for sensitive information.
• Documented teh Tables required from teh Underlying database to build teh universes
• Designed Universe by creating teh Business Objects Semantic Layer selecting/joining Tables, set cardinalities and creating objects and classified them into Dimensions, Details and Measures and give Business Name and group them into classes and sub classes
• Created local objects in teh Universes with complex SQL functions to manipulate teh data based on teh report requirements
• Created Derived Tables to reduce teh complexity of teh Universes. Defined @Aggregate Awareness, @Prompt, @Select, @Where functions in universe level.
• Created Cascading Prompts in teh universe to filter teh list of Account names based on teh Business Units.
• Created reports using Business Objects functionalities like queries, Slice & Dice, Drill Down, Cross Tab, Master/Detail and used Complex Formulas in teh report variables.
• Resolved issues like Chasm traps, Fan Traps in teh universe build by creating contexts and aliases as required
• Created Report Level Variables, Objects and Formula to create new columns based on teh result set.
• Installed and configured Business Objects XI r2 using Tomcat and Apache as Application and Web Servers.
• Involved in migration of reports from Business Objects 6.5.1 to Business Objects XI/R2.
• Resolved Migration issues both in Designer, Reporter and created test cases to check teh Migrated Reports
• Created Universes specific to dashboard development with various measures defined.
• Synchronized queries from multiple data providers by linking teh common dimensions using merge dimensions option in Web XI R2.
• Defined Report Level Ranking, Database Ranking and Alerts in Reports based on teh specifications.
• Defined User Response function in Report Level to display teh data selected by teh users in teh Report Headers
• Enabled/Disabled different servers in Central Configuration Manager and Central Management Console
• Involved in teh creating teh reports using teh Web XI R2. Created teh Reports (Master/Detail, Brake, Cross Tab, Chart, Templates) in Business Objects using teh Universe as teh main Data Provides and writing teh Complex queries including Sub-Queries.
• Enhanced teh Reports with teh new functionalities of Business Objects XI r2 like Ranking and synchronizing teh data using teh merge dimensions option
• Created and customized application dashboards using Performance Manager to meet teh requirements Upper Level Management.
• Developed dashboards and scoreboards for detailed analysis using different analytics like Speedometer, Interactive Metric Trends, and Barometers.
• Scheduled pre-canned reports through Web I XI R2 Scheduler for distribution and printing.
• Created Crystal Reports using both universes and business views based on business requirements

Environment: Business Objects 6.5.1/ XI R2 (CMC, Designer, Desk I, Web I), (Supervisor, Designer, Reporter), IBM DB2 UDB 8.0/7.0, SQL Server 2000, Oracle 10g/9i, Tomcat 4.0, Apache server 1.3, Unix (IBM AIX 5.1, Sun Solaris 8), JSP, PL/SQL, Window 2003 Server/XP.

Confidential

Senior HR Specialist

Responsibilities:

• Involved in Project Preparation, Requirements Gathering and Analysis, Configuration, Testing, Go Live, end user documentation and training.
• Interacted with teh Users for collecting their requirements for HR report design
• Detail level design documents were developed for end user training sessions
• Involved in creating proto types for various HR functionalities
• Created teh Demo systems forbusiness sign-off (conceptual/functional design phase).
• Expertise in Screen designingusing RVW
• Clear understanding of eliciting & translating HR business requirements into functional out comes.
• Clients served were Shamil Bank, HLL India, UTI Bank,NEC, AEC, Moserbaer,MurugappaGroup IN
• Understanding and analyzing teh problem from simple to moderately complex and synthesis of business requirements, along with recognizing patterns and conceptualize processes.
• Experience in process modeling, owning and driving continuous process improvement.
• Involved in configuration of Appraisal module, Training module and other HR related process

Confidential

Financial reporting Analyst

Responsibilities:

• Responsible for fitting Business Objects into teh Information Architecture of teh company as well as creating users and privileges with supervisor and developing and maintaining Universes.
• Managed categories that were created and assigned to documents by users.
• Managed teh scheduling options stored in teh repository and also involved in changing teh document descriptions.
• Involved in teh version migration from 5.x to 6.5.1.
• Extensively used Designer to design various universes for different business groups.
• Designed and Developed PL/SQL procedures and predefined stored procedures for retrieving general data very quickly from teh server. Used PL/SQL procedures for data extraction and loading operations.
• Created complex reports using cascading prompts, decode objects etc
• Specified teh standards for universes, Classes, Aliases, Help text, Simple and complex objects in Info View, implemented customized logins at application level and provided password reset options to teh users.
• Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis). Used filters, conditions, calculations, etc. Extensively used breaks for white spaces and sections for better navigability.
• Created template documents with header, footer and company logo.
• Created user groups and managed access privileges using Business Objects Supervisor.
• Developed various Metadata and operational definitions. Enhanced teh existing reports using sub queries.
• Customized Business Objects web interface (intranet) to access teh enterprise reports, developed in Business Objects full client.
• Used teh formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors etc.
• Good experience in creating customized Dashboards for overall performance. Developed Dashboards for detailed analysis
• Presented teh advanced features of Business Objects to users and developers to enable them to develop queries and reports easily.

Environment: Business Objects 5.1.7(Supervisor, Designer, Reporter), Broadcast Agent Server, Business Objects Web I, Info View, BCA, ZABO Informatica Power Center 5.0, Crystal reports 7.0, Visual Basic 6.0, Oracle 8i/9i, Windows NT.

Confidential

Program Analyst

Responsibilities:

• uirements/feedback, implement in reporting applications.
• Designed and developed Business Objects universe and report templates.
• Implemented subject-oriented contexts in designer.
• Created Universes for report generation using Designer module in Business Objects.
• Defined Customized Sorts in Universes and Reports Level.
• Resolved universe development issues involving loops and chasm traps.
• Check teh Integrity of teh Universes.
• Customized list of values and efficient prompts for intuitive reporting and analysis.
• Exported teh universes to teh Repository to making resources available to teh users.
• Track data issues and direct technical resolution; interact with other teams on technical interface issues.
• Impact analysis - update and prepare team for new data, data change Met users to discuss new reports, reporting issues, data issues/changes relevant to users.
• Tested, QA-ed and delivered reporting applications, resolve all reporting/data issue.
• Increased reliability of reports through elimination of errors and efficient resolution of issues - user base grew by 200%, steady issues resolution rate 98%+ catered to reporting needs of departments ranging from contracts operations to higher management levels.
• Published and scheduled Business Objects Reports to users using Scheduler.

Environment: Business Objects 5.1.6, Designer, Web Intelligence 6.5, Oracle 8i/9i, Windows 2003 Server.