SUMMARY

• Confidential is a Manager / Solution Architect with nearly 14+ years of experience in designing, developing, integrating, delivering and migrating applications in various organizations. His collaborative, team - enabling delivery style constantly meets budget & schedule has led to his involvement in several major recovery efforts. His industry experience including: Utilities, Energy, Mining, Manufacturing, Finance, Retail, Services, Telecom and Pharmaceutical.
• He is known for his Strong Leadership in enterprise IT service delivery and ability to articulate value - led service opportunities to both business & IT executives to address technology, data and business process issues related to capturing value through the use of mobile & analytics based applications.
• Anil technical expertise & divergent thinking in SAP Business Objects, HANA, Tableau & QlikView suite of tools helped clients to overcome complex business predicaments. He recently published two innovative solutions that changed the way of implementing BOBJ& QlikView tools in a traditional BI & BPC integration Stack.
• Anil did manage projects worth 5 M$ and successfully delivered them on time and within budget.
• Passionate, detail-oriented, analytical, and well-rounded professional, have 13+ years of experience in SAP BW/BI/BOBJ with proven proficiency in Architecture, Data Modeling, ETL, Data Analysis, Performance Tuning, Reports (including BEx & BOBJ4.0 tools like Dashboard’s, WEBI, Explorer) and Enhancements, and delivered high performance, error handling included end-to-end automated, solutions, to achieve operational excellence.
• Expertise includes but not limited to Business Analysis, Data Warehousing, Report Design, Dashboard Designs and Development with Extensive experience in SAP Business Objects Tableau 8/9.1, LUMIRA BOBJ 4.0, XIR3.01, R2, R1, 6.x 5.x Business Objects Dashboard 4.0, SAP HANA, SAP BPC NW 10.0, Business Objects Explorer, Analysis for OLAP, Analysis for Office, SAP BI, BEx Query Designer, BEx Analyzer, QlikView 10 & 11.2.
• Extensive experience in Data Modeling, Extraction, Cleansing, Loading, Scheduling, Monitoring, Delta Management, Reporting,troubleshoot issues with data integrity and User & Security administration.
• Experienced in one full life cycle implementation of SAP BW on HANA for a Global CPG Industry, involving in sizing the SAP HANA database, reduce the data size from 15 to 9 Terabytes through cleansing & archiving the data, migrating to HANA database, realign BW data models leveraging HANA capabilities without breaking any operations of Business.
• Proficient in developing high performance HANA models, created advanced Attributes View, Analytical (Standard, Scripted) Views, and unifying Calculation Views. Skilled in using Data Services (BODS) & full knowledge to use SLT (SAP Landscape Transformation) for data loading purposes.
• Effectively used BW Workspace designer when an Adhoc analysis needed for what if scenario quickly leveraging HANA published local file data in BW & modeling with BW objects through Composite Providers.
• Facilitated Workshops with management, users and other stakeholders to define the project as per the business needs.
• Deep understanding of data architecture, data acquisition, data integration, MDM, Content Management and data mining with the ability to challenge technical subject matter experts to think outside the box.
• Experienced in Training & Supporting end-user reporting needs using Business Objects.
• Strong leadership, commitment, teamwork, planning and monitoring skills.
• Ability to adapt to new technologies very quickly.

TECHNICAL SKILLS

Business Intelligence: Tableau 8.0/9.1, SAP Lumira, HANA, QlikView, Business Objects 4.1/ 4.0 XI R3.1,XIR2/6.X/5.X (Supervisor, Designer, Business Objects, Web Intelligence 6.x/2.7 Broadcast Agent, Info View and ZABO), Dashboards, Crystal Reports, XCelsius 2008, Analysis for Office, Explorer, Analysis for OLAP

Tools: Crystal Reports 9.0/8.x, SAP BW 3.5/3.1C/3.0B/2.1C., BPC NW 10.0

Databases: SAP HANA 2.0 Oracle 9.x/8.x/7/x, SQL Server 2000, Netezza, DB2, MS Access.

ETL: Business Objects Data integrator, Informatica 6x, 7x.

Data Modeling: Erwin 4.1.

Languages: PL/SQL, JSP, HTML.

Operating Systems: Windows NT/XP/00/98/95, MS-DOS, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

Data Virtualization Architect /Solution Architect

Responsibilities:

• Scheduled workshops to gather requirements for Virtualization Layer with various business teams.
• Assisted in the architecture, development, implementation, and the coordination and planning of all of the data and reporting strategies with internal and external stakeholders.
• Acted as a data point of contact and execute tasks including but not limited to: user management, security, configuration and customization, work flow and approval management, communication templates, analytics reports, data management, audits, etc.
• Closely worked with iteration managers, product owners, release managers to ensure cross team capacity and resource allocations that required to meet project delivery schedules on time and in budget.
• Closely worked with Enterprise Architecture, Solution Architects and Design Leads to establish roadmaps conforming to enterprise standard and technology vision.
• Proactively worked to identify, communicate and resolve project issues and risks that interfere with project execution or success across teams and stakeholder groups.
• Provide oversight and architecture guidance during solution design and delivery phases of SDLC in alignment with reference architectures & business strategies.
• Partnered closely across Enterprise Architecture team as a community of practice to leverage common architecture frameworks, share & collaborate on tools and templates, and ensured reference architecture materials are actionable by IT team members and always aligned with business strategy
• Developed process & infrastructure to manage data source requirements for process measures (input, process, and output), data warehouses and databases and retrieve data independently as needed from various platforms.
• Defined, develop, and evangelized self-serve, ad-hoc reports and dashboards that meet the needs of disparate audiences across the team and support the rhythm of the business.
• Worked with the Change management team in identifying the users for Denodo 5.5 training across the organization.
• Worked with infrastructure team in building the Dev, QA and prod Denodo Environment with Load balancing & failover strategy in place.
• Responsible for configuring the Denodo data base with Kerberos authentication, User authorization and authentication.
• Developed Denodo Views (Base, Derived, Combined, selection, Union & Final views)
• Integrated Denodo with SAP Business Objects & Tableau Environments
• Created Business Objects universe on Denodo Views.
• Migrated the VQL files between environments & implemented security.
• Trained users with Denodo 5.5 & 6.0 functionality.

Confidential

BI Manager (Practice Lead)

Responsibilities:

• Designed HANA models to provide analytics solutions on Business KPIs.
• Designed solution for Data Security and Access model.
• Identified and created attribute, measures, and hierarchies.
• Configured BODS Data connections for data and metadata import.
• Performed data modeling activities and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model inHANAStudio.
• Worked on real-time data replication from SAP ECC in to HANA Using SLT replication.
• Worked in data replication from SAP & Non - SAP Data Sources using BODS 4.0.
• Worked on POC to create a real-time text Analysis using Twitter feeds and created a dashboard on top of HANA Views, (Analytical, and Attribute & Calculation Views).
• Worked on Smart Data Integration in SAP HANA SP08.
• Created BOBJ Universes on top of SAP HANA Standalone DB.
• Imported Native BW Model in to HANA and created BOBJ Explorer reports on top of HANA Models.
• Integrated Tableau with SAP HANA Data Base and created dashboards.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets forTableauserver logons and security checks.
• Supported enterprise wide deployment and developed object security with 2 tier architecture.
• Worked a great extent with the design and development ofTableauvisualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies etc.
• Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms inTableauDesktop.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableauserver logons and security checks.
• CreatedTableauworkbooks with calculations, parameters, Quick Filters.
• Worked and generating various workbooks and dashboards extracting date from various sources such as Oracle, SQL Server and data files using data blending and joins.
• Created parameters for Prompts in Calculations for various workbooks and dashboards
• Developed workbooks and dashboards usingTableauVisualizations like Heat maps, Pie Charts, Dual Axis workbooks and Charts, Bar Graphs, Scatter Plots, Trending and Forecast dashboards, Waterfall Charts, Geographic maps using local and global filters.
• Administer and support a multi-tierTableauinfrastructure including upgrade analysis and planning, security administration, release management, capacity planning, troubleshooting, performance tuning, and general systems maintenance
• Experience Implementing ProactiveTableauEnvironment Health Checks and Performance Threshold Alerting
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktop by connecting live/dynamic and static datasets.
• Performed admin tasks such as creating users, Groups and implementing LDAP Authentication in QA and Production environments.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer.
• Scheduled data refresh onTableauServer for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Confidential

MDM & MDG Lead

Responsibilities:

• Worked with the Client in defining the Project as well as Scope requirements.
• Configuration & Cleansing of various areas including master data, purchasing, Inventory Management, Invoicing, and Vendor Management.
• Setup Pricing and conditions for contracts and purchase orders.
• Performed exhaustive unit test runs on test director for different scenarios.
• Worked on special procurement types such as Subcontracting, Third Party, Stock Transfer using Stock Transport Order, Service PO's /Contracts based on requirement for different business scenarios.
• Implemented data cleansing and data governance methodology by working closely with the customer and understanding AS-IS process and defined TO-BE process.
• Worked with Global Data coordinator for a timely extraction, cleansing and delivery of Mater Data to be loaded.
• Supporting the activities of Customer, Pricing, Vendor and Material
• Worked with Back to Plant, Truck Invoicing, Credit & Collections, and Taxation teams to identify and streamline the process.
• Worked & managed the team in defining the Master Data KPI’s for Customer, Pricing, and Material & Vendor Master Data.
• Scheduled workshops with data owners to understand the complexity of data.
• Designed and demonstrated the data integration strategy from different source systems
• Worked with the users in defining the dashboard standards as per Linde branding team.
• Installed the Tableau 8 server and client versions in Linde environment.
• Configured Tableau Desktop & created connection to SQL Server, Oracle databases/
• Created dashboard for Customer & Pricing Master Data Team using Tableau Desktop.
• Published the Dashboards to the Enterprise Tableau portal.
• Extensive Client interaction for Data Synchronization and Enhancements in Foundation andMDM Systems.
• Addressed the steering community questions at Final Scope Validation.
• Worked & managed the team to Developed Documentation (Configuration, Execution of Scripts for Integration Testing, Training Document and Business Process Procedure Documentation), End user training.

Confidential

Business Intelligence Delivery Manager / Solution Architect

Responsibilities:

• Acted as the liaison between different streams of BI technologies as well as business facing roles within BI to brainstorm and come up with the best solutions for clients.
• Design, prototype, document, and source new metrics and attributes that contribute towards advanced analytics
• Project Planning - Identified all subject areas, break them down to detail level and estimated time to complete each task. Provided both high level and detail level estimations to management.
• BI Assessment - Assessed current BI architecture, identified all possible areas of concerns and provided high-level direction and technical recommendations, that enables clients to address potential issues sooner in the development lifecycle and reduce negative future impact.
• Leading application architecture designing activities, includingBusinessArchitecture, Logical Architecture and Physical/ Technical Architecture with data architecture and security framework, while translatingbusinessrequirements into system and application design.
• Worked in project budgeting and developed project plan for the current ongoing project.
• Tool assessment: Analyzed various Business Objects tools such as WEBI, Dashboards, Explorer, Design Studio and Analysis for Olap, Office, and finalize the appropriate tool set based on the business requirements.
• Manage the team with their deliverables and provide updates to the Management.
• Create Universes, BEx queries, reports, Dashboards to facilitate the business needs.
• Documented and presented a white paper about creating WEBI reports against BPC Transient queries.
• Implemented New Solution of accessing BPC Data Model’s using BI Tools.
• Create WEBI Reports on top of BPC Data Model’s.
• Developed Calculation & Analytical Views in Side HANDA - SIDE CAR Data Base for reporting purpose.
• Created Universes on top of SAP HANA Data model to accommodate business needs for specific reporting purpose in BO 4.1 environment.
• Work with security team in finalizing the security needs based on business requirements.
• Created Dashboards using SAP Design Studio for the O&E team and trained the users in building the dashboards.
• Proof of Concept SAP Lumira (using Sources Excel, BEx, open hand SQL, inner and outer joins)
• Created Data sets in Lumira using HANA Analytical View, BOBJ Universes and designed visualization for the O& E team
• Work with the Infrastructure team in Sizing the Business Objects Landscape to accommodate the business needs.
• Developed the training manual for enterprise wide users.

Environment: BOBJ XI R 4.1, Crystal Enterprise Edition, Tableau 8 /9, HANA, SAP Design Studio, QlikView 11.2, Lumira, SAP 7.3, SAP BPC NW 10.0,BO Analysis for Office and Olap, SAP FICO, SAP PM, SAP EC, SAP SD SAP EHSM, Windows 2008 R2, Win 7

Confidential

BI Manager

Responsibilities:

• Worked with Clients in gathering requirements.
• Designed the strategy for business objects Upgrade from BO XI R 3.1 to BO 4.0
• Identified the reports and universes that are required for the Migration.
• Created a migration plan to list out the steps involved in migration.
• Perform inventory audit and cleanup, to ensure that only the required content is upgraded
• Configured and initiated the Repository Diagnostic tool to identify the inconsistencies between the FRS & CMS Repository
• Identified the set of reports and universes that cannot be migrated using the upgrade Management tool.
• Migrated the identified reports & Universes to BI 4.0
• Migrated .unv universes to .unx (UDT to IDT)
• Migrated WebI Reports from BOXI R3.1 to BI 4.0.
• Worked on rebuilding the entire security model in BI 4.0
• Used the Report Conversion tool to convert some migrated reports in to Spanish and Italian Languages.
• Tested and validated the migrated reports and universes to make sure everything is working as desired.
• Migrate Xcelsius and Crystal reports from BI 3.1 to BI 4.0 using the upgrade management tool.
• Worked closely with the Basis team in creating the profiles that are necessary for BOBJ integration.
• Imported the BW Security profiles in to BOBJ 4.0 and assigned them to the user group & profiles.
• Perform the integration between BW 7.3 and Business Objects.
• Configured LDAP Security in BO 4.0
• Created users & Groups and implemented security in BO 4.0
• Implemented the BI Load balancing & failover strategy in QA & Production environment.
• Educated & trained the users about the new features in BI 4.0.
• Worked with Clients in gathering requirements.
• Organized and managed the requirements workshop sessions at different clients.
• Worked with internal team members in writing RFP’s and RFI’s
• Work on doing demo presentations with the clients.
• Analyzed present issue’s with the existing client designs and provided solution architecture.
• Worked in Resource management, Project Management, Budget/Financial Management.
• Worked in project budgeting and developed project plan for the current ongoing project.
• Created Requirements tractability Matrix for all Identified RICEFWD’s.
• Worked with Technical Architecture team in designing the Technical architecture for the proposed solution.
• Created Solution Architecture design document for the current project scenario.
• Worked collaboratively with the IT Security and Governance team, ensure problem management discipline is used to identify and reduce/eliminate persistent incidents.
• Implement agile development practices to rapidly develop relevant solutions with full engagement of requirement owners
• Scheduled & Managed requirements workshops to gather requirements for Information delivery frame work
• Created project plan, resource plan, and deliverables plan by phases for information design team.
• Analyzed routines for data reconciliation and for providing solutions to remedy tickets.
• Worked extensively on Performance Tuning.
• Worked with Stake Holders and Business User’s in creating functional design documents based on the requirements gathered.
• Effectively manage the ongoing queue of operational BI requests to ensure adequate service levels.
• Ensure effective ongoing communication to all stakeholders regarding BI project and operational work.
• Installed, configured STI Dev, QA & Production Environment including Clustering.
• Created WebI Reports using BICS connectivity.
• Created BOBJ Universe Using IDT & UDT.
• Created BEx Query’s.
• Created Crystal reports on top of BEx Queries.
• Modified existingCrystal reportsbased on the User requirement and created formulas for thereports.
• Developed ParameterizedreportsandcrystalSubReports
• Created projects, Work Flows & Data Flows using BODS 4.0 Sp4
• Scheduled and monitored BODS Jobs.
• Worked with Client in building the COE team along with Confidential offshore team during the HyperCare phase of the project.
• Helped Confidential BI Practice in conducting pre-hire screening process.
• Mentor & Coach BI Analysts, Consultant in Confidential SAP Practice.

Environment: BOBJ XI R 4.0, Crystal Enterprise Edition, SAP 7.3, BO Analysis for Office and Olap,, SAP PM, SAP EC, SAP SD, Windows 2008 R2, Win 7

Confidential, TX

Business Objects Solution Architect

Responsibilities:

• Involved in requirements gathering Workshops from the business users to build the application.
• Extensively interacted with business in understanding and gathering the requirements.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Closely worked with the Data Architect team in designing the Data Model.
• Plan, manage and provide technical expertise as it relates to upgrades and implementations of Enterprise IT systems,
• Conduct and coordinate competitive research to evaluate the effectiveness of business processes and identify opportunities for change and improvement.
• Created complex Ad-hoc reports using Business Objects and Web Intelligence tools.
• Developed some crystal reports based on specific business needs.
• Created Groups, Users and profiles in Business Objects CMC.
• Implemented security at the universe level.
• Worked with the security team implanting the fail over & load balancing in production environment.
• Worked with support team in maintaining and supporting the environment.
• Trained the Business Users in report creation and also new features of Business Objects XIR3.1.

Environment: Oracle 10.x, Endur 9.2 / 5.0, Business Objects XI R 3.1 Sp2, Web Intelligence, Win XP

Confidential, TX

BI Lead

Responsibilities:

• Involved in requirements gathering from the business users to build the application.
• Extensively interacted with business in understanding and gathering the requirements.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Created Webi Reports & Universes for AP, AR, OTC and Treasury team’s.
• Designed and developed Universes by defining Joins, Cardinalities between tables, and linking the existing Universes.
• Developed Standard Reports, Charts, Drill Through Reports, Cross tab Reports, List Reports, and Summary Reports.
• Wrote SQL queries and validate the data accuracy in Universe & WebI Reports.
• Created Groups, Users and implemented security.
• Implemented security at the universe level.
• Exported Business Objects reports to WebI to be published on the Intranet.
• Did SQL performance tuning & debugged the derived tables / materialized views to understand the issues in the join criteria.
• Created dashboards using Xcelsius 2008
• Created Xcelsius dashboards using Live office, QAWS, XML data Providers.
• Trained the Business Users in report creation and also new features of Business Objects XIR2.

Environment: Oracle 10.x, Oracle Apps, Business Objects XI R2 Sp4, Web Intelligence, Noetix, Win XP, Xcelsius 2008

Confidential, TX

BO Lead / Business Analyst

Responsibilities:

• Involved in requirements gathering from the business users to build the application.
• Extensively interacted with business in understanding and gathering the requirements.
• Worked with Data Modeler & Solution Architect in decision making regarding the supporting Platform
• Worked with Architects in finalizing the Environments
• Designed and developed Universe by defining Joins, Cardinalities between tables, and linking the existing Universes.
• Developed Standard Reports, Charts, Drill Through Reports, Cross tab Reports, List Reports, and Summary Reports.
• Created & Configured the New database using SQL server 2005
• Launched BEx Report to the Web and generated PDF file.
• Experienced in using BEx Information Broadcasting to distribute the right information to the right people at the right time.
• Involved in optimizing the queries and created reports using BEx Analyzer and Web Application Designer to develop Web Reports

Environment: Oracle 10.x, SQL Server 2005, SAP BW 3.2, ECC 5.0, SAP BI 7, Business Objects XI R2, Web Intelligence, MS Visio, Win XP.

Confidential, Austin, TX

Business Objects Lead

Responsibilities:

• Designed and developed Universes by defining Joins, Cardinalities between tables, and linking the existing Universes.
• Created WebI Reports for finance team to identify the vendors and pending balances, PnL reports.
• Created several Classes, Objects, Conditions, and Measure objects.
• Resolved table-linking problems like Chasm traps and Fan traps using Aliases and Contexts.
• Created Master/Detail, Cross Tab and various Chart reports, and exported them to the Corporate Repository.
• Created WebI reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @functions, Cross tab, Chart, Master/Detail, Formulas, etc.
• Developed hierarchies to support drill down reports.
• Fixed some issues in already existing universes.
• Wrote SQL queries to test the universe and reports for data accuracy.
• Trained and educated the users with the new changes in the universe and reports.

Environment: Business Objects 6.5.1, BO XIR2, Web Intelligence, Teradata, Oracle 10g, Windows XP (Professional), Windows 2003 server

Confidential, TX

BI Architect / Business Analyst

Responsibilities:

• Involved in requirements gathering from the business users to build the application.
• Worked with the Business Objects Shared Services team in building the new staging environment.
• Classified the reports and universe and users that need to be migrated to the BO XIR2.
• Migrated universes and reports from BO 6.5.1 to BOXIR2 using Import Wizard.
• Used the Import wizard to import existing user accounts, groups, categories, WebI documents, universes, connections and universe restrictions to BO XIR2 environment.
• Created groups and created users in new BO XIR2environment.
• Resolved that issues that came across the migration of reports.
• Recreated complex reports in the new BO XIR2 environment that failed during the conversion process.
• Worked with the team in recreating the security in the new BO Xi R2 environment.
• Imported the Universe and reports from BIAR files Using Import Wizard.
• Used the Publishing wizard to export different document types as objects to different folders in CMC.
• Converted Full Client reports to Web Intelligence Reports, using Report Conversion Tool and run them successfully upon refreshing.
• Involved in configuring the environment along with the support team.
• Worked with support team in maintaining and supporting the environment.
• Trained the Business Users in report creation and also new features of Business Objects XIR2.

Environment: Oracle 9.x, Business Objects 6.5.1, BO XIR2, Voyager, Web Intelligence, MS Visio, Windows XP (Professional).

Confidential, TX

BO Lead / Business Analyst

Responsibilities:

• Involved in requirements gathering from the business users to build the application.
• Extensively interacted with business in understanding and gathering the requirements.
• Designed and developed Universes by defining Joins, Cardinalities between tables, and linking the existing Universes.
• Developed Standard Reports, Charts, Drill Through Reports, cross tab Reports, List Reports, and Summary Reports.
• Created several Classes, Objects, Conditions, and Measure objects.
• Resolved table-linking problems like Chasm traps and Fan traps using Aliases and Contexts.
• Developed hierarchies to support drill down reports.
• Exported Business Objects reports to WebI to be published on the Intranet. Created thin client reports through InfoView.
• Trained the Business Users in report creation and features of business objects.

Environment: Oracle 10.x, Business Objects 6.5.1, Web Intelligence, MS Visio, Crystal Xcelsius, Win XP.

Confidential, NC

Sr. Business Objects Developer

Responsibilities:

• Involved in requirements gathering from the business users to build the application.
• Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections.
• Rewritten the Cognous reports in Business Objects.
• Worked on BODI migration from 6.5 to XIR2.
• Installed and configured the new Data Integrator environment.
• Migrated all BODI jobs from the old environment to new environment.
• Modified and tested some jobs as per the new requirements.
• Designed dashboard for the sales team for forecasting.
• Involved in migration and deployment of the universes and reports across multiple domains.
• Resolving loops using contexts and aliases to remove the cyclic dependencies.
• Interacted with the users to analyze the changes for improvement they needed in existing reports, and developed the reports to satisfy their needs and requirements.
• Educated end-users and provided technical support

Environment: Oracle 9.x, Business Objects Data Integrator 6.5/ XIR2, Business Objects XIR2, Crystal Reports, BO Performance Manager, Web Intelligence, Windows XP (Professional), HP UNIX.

Confidential, Peoria, IL

Sr. Business Objects Developer

Responsibilities:

• Studied the business processes and gathered the requirements from Business Analysts and Business Users.
• Created Test Cases, Usability cases, developer training materials for Business Objects XI R2.
• Reports were mainly related to the production environment and dealt with different aspects like Yield, Loss, and Work in Progress that made use of current as well as historic data.
• Designed and developed Business Objects Data Integrator jobs to extract data from various source systems.
• Tested and Validated BODI ETL Jobs.
• Monitored Daily BODI ETL schedules.
• Involved in performing logical modeling, and data ETL processes.
• Modified and tested some jobs as per the new requirements.
• Monitored and Scheduled the BODI Jobs in new environment.
• Designed and developed Universes by defining Joins, Cardinalities between tables, and linking the existing Universes..
• Wrote SQL queries to test the reports & universe before releasing it to the users.
• Documented and trained the business users.

Environment: SQL Server 2000, Business Objects XIR / 6.x, Web Intelligence, BCA, Windows Server 2000 (Professional).

Confidential, IL

Business Objects Developer

Responsibilities:

• Studied the business processes & gathered requirements from Business Analysts and Business Users.
• Designed and developed Universes by defining Joins, Cardinalities between tables, and linking the existing Universes.
• Created several Classes, Objects, Conditions, and Measure objects.
• Created queries to extract data from an Oracle database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality.
• Exported reports to Excel based on the user requirements.
• Validated Test Plans and Documented the Defects.
• Wrote SQL queries to test the reports.
• Wrote SQL Queries to test the universe.
• Educated end-users and provided technical support.

Environment: Oracle 8.x, BO 6.x/5.x, Web Intelligence, Sun Solaris 7.0, Win2000.

Confidential

Oracle Developer

Responsibilities:

• Involved in preparation of Design Documents.
• Built external mapping to transfer Old data from database to Oracle Data warehouse. This included writing PL/SQL procedures and SQL cursors.
• Gathering Software Requirement Specification from the users.
• Identified and reviewed the design outputs against the design input requirements.
• Developed procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements.
• Involved in the production support of the system for 6 months to stabilize and efficient uploading/downloading of data across various cities.