PROFESSIONAL SUMMARY:

• Over 9+ Years of Professional Experience in the field of IT with prominence on SAP Business Objects (BOBJ)/ Business Intelligence (BI)/Tableau including 3 full life cycle implementations in BI 3.5/7.0.
• Extensively worked on end to end process of BI/DW and Analytics development in finance, retail, manufacturing, insurance and healthcare domain.
• Proficient in all phases of Software Development Life Cycle ( SDLC ) including Requirements gathering, Analysis, Design, Data Conversion, System Implementation, Performance Tuning, Testing and Support.
• Hands on experience on Tableau, SAP BO Explorer, Sap Lumira, BO Analysis for OLAP/Office .
• Architected Power BI Visualization Layer for the Refining Stake Holders / SME’s to analyze the Labor Allocations, Gatelog, Cost Analysis and safety Hrs.
• Hands - on experience with Data Extraction, Transformation and Loading of data from multiple sources into Data Warehouse using BO Data Integrator and BO Data Services.
• Extensive experience in working with Business Objects 4.1 Launch Pad, WebI, Dash Boards, Data Services, Universe Designer and Crystal Reports.
• Adept in using of Data Services Designer, Job Server Manager, Repository Management, Access Server, Data Services Management Console in Business Objects Data Services (BODS).
• Expert in generating Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports by using Chart expert of Crystal Reports.
• Experience in ETL (IBM DataStage, ODI), data mining, data automation, database programming.
• Having good experience on Oracle Data Integrator Designer ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse.
• Well versed with BI and Enterprise Data warehouse and dimension modeling concepts - start schema, Late arriving dimensions, SSIS Design Patterns, Dashboards, Analytics, KPIs, extensively implemented in large scale multi-terabyte BI/DW and Big data projects.
• Experience in creating Repositories, designing Universes, Full Client/WebI Reports, publishing and scheduling using Broadcast Agent for publisher and scheduler .
• Primary strengths include SAP BO 4.2 SP2 , UDT, IDT , BO XI R3 /R2/6.x, CMC, Designer, Import.
• Application development using SQL Server, SSRS, SSIS, MS Access .
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau .
• Wizard, Crystal Reports , Web Intelligence, Performance Management
• Strong experience with OLAP Reporting in BW/BI and implementation of BeX Analyzer .
• Good understanding of Data Modeling using BW Extended Star Schema .
• Involved in managing of Info cube , which involves Info cube content, performance issues like Indices, Statistics , compression of InfoCube and rolling up the data to the aggregates.
• Hands-on experience with SAP BOE XI Central Management Console (CMC), Central Configuration Manager (CCM), Universe Designer, Web Intelligence (WebI), BO Dashboards, Crystal Reports, Xcelsius dashboards, Web Intelligence Rich Client, Desktop Intelligence (DeskI) .
• Experienced in migration of on-premise infrastructure environment to AWS cloud using cloud formation, EBS.
• Extensively used User conditions, Filters, Functions, Variables, Sort, Ranks, Drilling, Slice and Dice, Alerters, Sub queries, prompts for creating efficient Business Objects reports.
• Experienced in working with database systems including SQL, Oracle and Access.

ORGANIZATIONAL STRENGTHS:

• Committed to understand organizational missions and to understand ethics and public.
• Excellent in organizing information, people or things in a systematic way.
• Effective in demonstrating skills in team building and in managing workflow.
• Ability to understand creative processes and capable of systems thinking.
• Highly motivated and a quick learner with a positive attitude and great interpersonal skills.
• Dedicated well-organized team player with solid research and reporting skills.
• Skilled and fostering relationship with people from diverse background.
• Capability to adapt to new situations, settings and to tolerate change well.

TECHNICAL SKILLS:

ETL: Business Objects (BO), Data Integrator (BODI), SAP BO 4.2/4.1/4.0/XI3.2/3.1/3.0 (Designer, Data Services Repository Manager, Data Services Server Manager, Management Console), SAP BO Data Integrator XIR2/11.7/11.5, SQL 2008 R2 SSIS.

BI Tools:: Business Objects XI 4.2, IDT, Universe Designer, Desktop Intelligence, BI Launch pad, Web Intelligence/Info view Publishing Wizard, CMC, Live Office, EPM Dash boards, Crystal Reports 2008/XI/10/9.0, MS Tableau 8.1/9.1/2018.1/2018.3

ETL Tools: : Informatica 9.1/8.5/7.1, BO Data Services XI 4.2/3.2, BO Data Integrator 11.5

RDBMS: Oracle 11g/10g/9i/8i, PL/SQL MS SQL Server 2000/2005, Tera data V12, IBM DB2 V8

Data Modelling:: Dimensional Data Modelling, Star Schema Modelling and Snow-Flake Modelling, FACT and Dimension Tables, Physical and Logical Data Modelling.

Front End Tools:: Erwin 4.1, TOAD

ERP:: SAP R3, SAP BW/BI 7.0

Operating Systems: UNIX, Linux, AIX, Solaris, MS-Dos, Windows NT 4.0/2000/2003/2008 r2/XP/Vista/7

Databases: Oracle, Teradata, Sybase, DB2, MS Access, MS SQL Server 2008 R2/2005

Professional Certifications: Business Objects Certified Professional

Microsoft Certification in MS: Sql server

PROFESSIONAL EXPERIENCE:

Confidential, Lansing, MI

SAP BI/BOBJ/Tableau Consultant

Responsibilities:

• Gathering requirement and design discussions and implement the Agile methodology; analyze business requirements/user problems to determine the feasibility of applications or designs within time and cost constraints.
• Optional best practices for business to validate the data and implement master data governance.
• Developed the Universe using Information Design tool BO (IDT) and Web Intelligence Reports and developed derived tables for complex Sql in Universe.
• Convert reports from custom applications to Business Objects.
• Worked on extracting the data PL/SQL from different legacy sources and excel files.
• Worked on different master data objects like class characteristics, work center, task list etc.
• Performed post load validation procedures after loading the data into SAP and validated the results with business.
• Java/Unix UI integration with Business objects Webi reporting tool.
• Integrated Webi reporting to ColdFusion.
• Created queries in design studio for planning SVP, Store Count, and shipment pattern of modeled and planned shelf price growth by material.
• Working with Aqua data studio and IBM bd2 database.
• Involved in the brain storming sessions with business from source to target mapping/business process re-engineering sessions.
• Proactively identify project risks and create feasible solutions. Escalate cross-functional issues and identify SMEs required for resolution.
• Work with other team members to track test scripts and defects in defect management tool and working with new tools in BO 4.1/4.2.
• Interact with project managers, database administrators, network administrators, and application users - all belonging to different departments and divisions of Jackson National to ensure the smooth running of the application.
• Worked with business in different mock cycles to obtain zero tolerance for bad data.
• Obtained 100% clean data to the business with lookup, mandatory, format and business validation procedures.
• Access data though virtual tables using Smart Data migration Access from Sybase and Oracle DBs.
• Designed, Created, and implemented Universes, Interactive Analysis Reports, Web rich Client, Crystal Reports, and Dashboard Designer Dashboards using best practices
• Develop profiling queries/validation programs to cross check all the data before and after the data loading.
• Created Pre-Canned and Ad-hoc reports using Business Objects Web Intelligence (Webi) Rich Client by utilizing BICS Connection and Universes.
• Responsible for migrating of BEx queries into BO Webi reports extended to Xcelsius Dashboards.
• Extensive experience with Webi in creating queries and reports that further used in the Dashboard Designer.
• Created complex Crystal reports in IDT depending on client requirement.
• Communicate effectively with Jackson National stakeholders on the progress of development and quality deliverables required for a given project.
• Updated the mapping documents and performed gap analysis from source to target. And worked in an Agile Methodology.
• Created global variables, substitution parameters and local variables for all the jobs to promote the conditional execution of part of code and to improve performance.
• Built calculated columns and increased performance of query’s in Power BI desktop by utilizing data analysis techniques.
• Work closely with the Business Analyst to develop the visual analytics for the given data and make it available online and on Web products.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created Advanced Charts using Tableau Desktop like Box and Whisker plots, Bullet charts, Waterfall charts for measuring the Sales growth by different departments within the company
• Create Tableau worksheets, design, develop dashboards and publish.
• Working with large volumes of datasets and loading delimited files into tableau.
• Develop Scripts to load data into tableau and work with multiple data connections by data blending.
• Expensively worked on parameters, Pareto charting, mapping, calculations, demographics and geographic fields.
• Worked with string functions, date calculations and swapping dimensions with parameters.
• Design and develop layout themes, develop field groups and cyclic displays.
• Constantly monitor the accuracy of the data and modify the measures as per the business requirements.
• Worked with tabadmin and tabcmd commands for managing access controls and server configuration.
• Worked closely with Java UI team to integrate Tableau reports to company web portal.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau

Environment: SAP Business Objects 4.2, Tableau 8.0/8.1, MS Excel source, Actuate, DB2, SAP ECC target, SAP Design studio, SAP BO, UDT, Webi SQL Server, and Windows.

Confidential, SFO, CA

SAP BI/BOBJ/Tableau Consultant

Responsibilities:

• Understanding the user requirements and prepared technical specification documents for all reports.
• Create sustainable and efficient visualizations, emphasizing usability and good design practices
• Work with end users to gather requirements, overlaying an analytics perspective
• Involved in working with Business or Functional users and translating Functional Specifications into ETL technical field specifications.
• Expertise in working with new tools in BO4.1/4.2 Design Studio 1.2 and Lumira.
• Developed, Tested, Promoted and Maintained the WEBI Reports, also had modified the existing reports based on user requirements.
• Scheduled Web Intelligence, Desktop Intelligence & Crystal Reports to Email, FTP, File System and Business Objects Inbox for Customers.
• Involved in the process of implementing Data quality tools using BODS jobs.
• Used Oracle Data Integrator ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database and Oracle EBS interface tables.
• Developed scd type 2 jobs for delta loads using bods.
• Creation and implemented Adhoc reporting system using Business Object Universe.
• Implemented custom hierarchies for flexible reporting to drilldown the data to lowest granularity.
• Developed complex reports with multiple data providers (Merged Dimensions), unions, sub-queries, complex date objects, breaks, sections, alerts and database functions.
• Used Restricted and Calculated Key Figures, Virtual Key Figures, Formulas, Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in the Query Designer.
• Created monthly and summary reports in WEBI 4.0 for the different domains like Finance, Marketing and HR domains.
• Developed the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.0 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.
• Created Hana column and Analytical Views and developed webi reports.
• Developed the Webi reports based on Spill datawarehouse and RBDMS Applications.
• Migrated BO 3.1 webi reports to BO 4.1 version using Upgrade Management Tool.
• Modified BW queries in to generate WEBI reports using BI Launch Pad in BO to meet user requirements.
• Developed WEBI reports on SAP Bex Queries using BICS in Webi Rich client.
• Created monthly and summary reports in WEBI 4.0 for the different domains like Finance, Marketing and HR domains.
• Scheduled all BO Reports in CMC by creating the events for these reports.
• Created Marketing and Finance Dashboards for FP&A, Inventory Management and Cost Center Accounting data.
• Created critical visualization using Business Objects Crystal Xcelsius for the Business Dashboard Used Crystal Report’s to feed data to Crystal Xcelsius Visualization an XML file as a data source.
• Created complex dashboards on Bex Queries using Query Browser in Dash board designer 4.0
• Built Test Scripts and Training modules for end users.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Created different views in workbook to visually analyze data.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created External filter, internal filter and Context filter to improve performance.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Created Marketing and Finance Dashboards for FP&A, Inventory Management and Cost Center Accounting data.
• Presented the Dashboard to Business users and cross functional teams, define KPIs (Key Performance Indicators), and identify data sources.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Created parameters and quick filters. Created sets to display top products based on their sale.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.

Environment: SAP BO 4.1/4.2, SAP BODS 4.2, Oracle 9i/10g/11g, Web Intelligence, crystal reports 2016, Tableau 9.3., Power BI, PL/SQL, S/4 HANA.

Confidential, Pontiac, MI

SAP BI/BOBJ Consultant

Responsibilities:

• Gathering requirements from Business Users to prepare functional specification and develop technical Specification
• Designed Best Practices documentation for Business Objects 4.0(IDT, BI Launch Pad, Administration)
• Developed BO Security models (Developer User, Power User, and Refresh User) to access BO Environment.
• Provided Training to business Users how to execute reports and developing reports for Adhoc users.
• Troubleshooting universe design and webi/crystal reports.
• Developed HR Reports and Universe (IDT, UDT) and BICS top of SAP BW systems.
• Creating Cardinalities, Contexts, Joins and Aliases for resolving Loops
• Checking the Integrity of the Universes.
• Developed WebI reports providing an easy-to-use interface with powerful query features. This reduced the report backlog and ensured business decisions were made in a timely manner.
• Migrated BO 3.1 webi reports to BO 4.0 version using Upgrade Management Tool.
• Installed Crystal Xcelsius designer and created dashboards. Created WSDLs using query as web services and implemented WSDLs into Xcelsius dashboards
• Developed derived tables for complex Sql in Universe.
• Involved in developing the highly tuned SQL in TeraData and Oracle database environments.
• Created Hana column and Analytical Views and developed webi reports.
• Modified Universe after analyzing areas of business and user requirements.
• Developed complex reporting and formulas.
• SQL tuning of reports to increase performance.
• Upgraded the BO 4.0 environment to BO 4.1
• Created Projects, Work Flow, and Data Flows and applied business logics to pull the data from source to Target.
• Created Jobs in Data Services to load the data from spread sheet in to Data warehouse and also made this job incremental.

Environment : Business Objects XI R2/XI 3.1/4.1, IDT, BI Launch Pad, BO Designer, Web Intelligence, Desktop Intelligence, SAP BODS, HANA, Crystal Reports, Oracle 11g , Windows XP/2007.

Confidential, Wichita, KS

Business Objects/ Tableau Consultant

Responsibilities:

• Developed .unx file using 3 layer architecture (.cns, .dfx, .blx) stored in Project with IDT tool
• Created Secured (.cnx) connection in IDT(Information Design Tool)
• Designed Data Foundation (.dfx) using multiple data sources using IDT
• Inserted calculated columns in tables at Data foundation level
• Defined Business rules (Joins, Alias & Contexts) in Data Foundation
• Published Data Foundation and Secured connection to Repository
• Created Business Layer using Data foundation and defined @functions @aggregate aware, @select, @prompt, @where in the creation of dimensions, measures and conditions
• Configured Parameters and LOV in Data foundation
• Customized Business layer by assigning row level and column level security using security editor
• Created connections to BEx queries and BW Info providers using Business Intelligence Consumer Services (BICS) in IDT
• Implement Aggregate awareness, hierarchy functionalities are developed in Business Layer(.blx)
• Created the Classes, objects, detail objects, measures and filters in universe by using Universe Design Tool (UDT).
• Designed snowflake, star and multiple star schemas in universe
• Determined the fallback locale in linked universes, created the contexts and defined derived tables.
• Involved in the implementation of Business Objects 4.1
• Developed the complex webi reports and crystal reports
• Testing, maintaining and supporting the universes, webi reports and crystal reports.
• Updated the universes with derived tables, alias tables and contexts.
• Solved the traps and loops in universes.
• Converted the reports from DESKI to WEBI using the report conversion tool.
• Manually converted the Deski reports to webi reports which cannot be completely converted by the report conversion tool.
• Used the different data sources Universes, Custom SQL and Excel.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Presented the Dashboard to Business users and cross functional teams, define KPIs (Key Performance Indicators), and identify data sources.
• Completely converted the partially converted reports by the report conversion tool.
• Solved the ranking issue in conversion by manually ranking objects.
• Updated the contexts and solved the structural error in the cross tab.
• Converted the complex reports with 30 tabs with different data analysis crosstabs and graphs.
• Updated the universe for some of the Custom SQL in report by creating the derived tables.

Environment : Business Objects XI R2/XI 3.1/4.1, IDT, BI Launch Pad, BO Designer, Web Intelligence, Desktop Intelligence, Crystal Reports, Oracle 11g , Windows XP/2007.

Confidential, Fort Myers, FL

Business objects/Tableau Consultant

Responsibilities:

• Gathering requirements from Business Users to prepare functional specification and develop technical Specification
• Worked as an administrator in creating users and folders and managed access privileges in windows
• Performed Admin tasks like monitoring DB services, monitoring BO server running with optimal performance.
• Some daily admin tasks included verification BO user logins and security checks testing availability of all universe connections, monitoring day to day scheduled jobs.
• Designed Best Practices documentation for Business Objects 4.0(IDT, BI Launch Pad, Administration)
• Analyzed Business Objects Old Universes and Reports. Designed and developed new Universe and Report as per the requirements.
• Migrated Universe and Reports from BO XIR3.1 to BO 4.0.
• Creating Cardinalities, Contexts, Joins and Aliases for resolving Loops
• Checking the Integrity of the Universes.
• Developed derived tables for complex Sql in Universe.
• Modified Universe after analyzing areas of business and user requirements.
• Developed complex reporting and formulas.
• SQL tuning of reports to increase performance.
• Created Analytics and Dashboards using Performance Manager to enable executives track progress and compare current and historical performance against established targets.
• Created single or multi line chart for showing tendency over a period particularly used in revenue history using Dashboard.
• Generated Tableau dashboards for e-bills and paper bills comparison.
• Created monthly and summary reports in WEBI 4.0 for the different domains like Finance, Marketing and HR domains.
• Created graphical representation of reports such as Bar charts, 3D charts, Pie charts, Column chart, Line chart, Bubble chart using Dashboard 4.0.
• Used Xcelsius for presenting dashboards to End users.
• Created Revenue Dashboard, Sales figure Dashboard using Dashboard.
• Exported Xcelsius to repository to make it available for users through info view.
• Implemented Open Doc to drill down to detail webI report from Xcelsius Dashboard.

Environment : Business Objects XI 3.1, 4.0, IDT, Tableau, BI Launch Pad, Web Intelligence, Oracle 10g, Informatica, Xcelsius

Confidential, Billerica, MA

SAP BI/BOBJ Developer

Responsibilities:

• Requirement gathering by working with business users, Financial Analysts, Project managers, and involved in analysis and creation of architecture that can be considered 'best practice' and scalable.
• Hands on experience working within an IT/Technology organization.
• Involved in Business Process Management (BPM) activities like Process Design, Process Monitoring and Process Execution.
• Created UI Documents as supporting documents for the Business Requirements Documents.
• Developed Excel formulas for testing and verification of insurance premiums, forward/backward traceability of functional requirements.
• Developed complex mappings in Data Integrator to load the data from various sources into the Data Mart, using different transformations like Query, Table Comparison, Merge, Pivot, Reverse Pivot, Lookup, Key Generation, History Preserving, Date Generation, Map Operation and Validation etc.
• Extracting data from legacy systems into SAP data stores.
• Created Data Flows for dimension and fact tables and loaded the data into targets in DW.
• Tuned Data Integrator Mappings and Transformations for the better performance of jobs indifferent ways like indexing the source tables and using Data transfer transformation.
• Participated in Business Objects 4.0 up gradation Project.
• Involved in building and designing Universes and resolved Loops and Traps using Contexts and Aliases.
• Created Aggregate awareness functions on multiple summary tables to improve the query performance.
• Updated Universes as per the changes of the Database table structure and notified the users about changes made to the Universe.
• Involved in Migrating Business Objects system from version XI R2 to Business Objects XI 3.1/4.0.
• Set up Universe level conditions to restrict data based on report requirements.
• Created reports using Business Objects functionality’s like slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s.
• Used Import Wizard to migrate reports from one environment to another environment.
• Worked with Multiple data providers including Personal Data files, Stored Procedures and Freehand SQL to create reports.
• Configured Local, Central and profile repositories and repositories are associated to the Job server.
• Created Users in Data services management console and assigned roles based on the requirement.
• Supported Production environment and fixing the issues raised by the jobs while running in production.
• Designed the universes by creating the Business Objects data model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects which are grouped into classes.
• Created different types of reports like Master/Detail, Cross Tab and Chart.
• Developed various full client and thin client reports using Business Objects and Web Intelligence.
• Wide usage of Drill mode and Slice and Dice techniques to modify the reports in accordance with the user’s analysis needs.
• Worked extensively on Designer, Web Intelligence (WebI), Desktop Intelligence (DeskI), Crystal reports, Central Management Console (CMC) and Developments of Crystal Xcelsius components Grids, Pie charts, Bar Charts and developed the animation actions for those components.
• Created QWS connectivity to WebI for refreshing Xcelsius with current data.

Environment: SAP Business Objects Data Integrator XI 3.1, Information Steward 4.1 , Business Objects XI3.1/4.0 (Designer, Business Objects DeskI, CMC), Web Intelligence XI 3.1, (WebI), Info View, Dashboards 4.0/Xcelsius 2008, JIRA, Oracle11g/10g, SQL, TOAD, MS Access, Excel, Windows NT/2000.

Confidential, Tallahassee, FL

SAP BI/BOBJ Consultant

Responsibilities:

• Elicited requirements from the business stakeholders using various requirement gathering techniques such as: end-user interviews, job shadowing, questionnaires and involved in analysis and creation of architecture that can be considered ‘best practice’ and scalable for implementation of project deliverables.
• Designed, developed, maintained and tested the single/multiple source Universes.
• Created Universes and developed the WebI reports and dashboards using IDT (Information design tool).
• Created WebI Reports connectivity through BEx Queries for Hierarchical Data.
• Used Contexts and Aliases to resolve the loops that were caused because of the conformed dimensions.
• Defined various restrictions for the Universes to restrict key information.
• Created MTD, YTD and PTD reports that helped in providing a sound analysis for Investigations.
• Used Open Document functionality extensively to create hyperlink sub-reports, to allow for mixing of summary and detail data.
• Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components.
• Created Complex Drill down reports with integrated summary information in the data warehouse which were useful in identifying Child and Adult Investigations.
• Extensively used Calculation contexts, Variables, Breaks, Sections, Ranks and Alerts in the creation of reports.
• Created Sub Reports, Cross Tab, Graphs, Charts, Ranking, Alerts for Children Scorecard Reports.
• Analyzed and identified ways to improve the performance of Reports and Universes.
• Developed Adding/Changing Logos and Customizing InfoView Web Page.
• Helpdesk Troubleshoot: User Access, report Subscription, BOE Password problem issues, Resolving High priority tickets.
• Administrative Tasks of BOE in Dev/UAT/Pilot/Production such as creating users, giving access, managing services, scheduling reports.
• Scheduled CBC (Community Based Care) user Reports to FTP Server.
• Created (. biar Files) migrated Users, Groups, Universes, Reports from One Region to another region using Import Wizard/Upgrade Management Tool.
• Worked directly with Agency Health Care Administration (AHCA) for Data Exchange.
• Developed Health Care Reports for children like Child Welfare Pre-Paid Mental Health Program (CWPMHP) Enrollment, Psychotropic Medications Claims Validation Match and Child in Care Provider Billing.
• Designed and developed ETL processes using shell scripting, TeraData SQL and utilities that populated newly modeled strategic data marts.
• Developed test plans and created test scripts to perform Unit testing and System testing of the Universes and reports.
• Created Projects, Work Flow, and Data Flows and applied business logics to pull the data from source to Target.
• Developed complex mappings in Data Integrator to load the data from various sources like Tables, Flat Files, and Excel Sheets into Data Mart using different Transformations like SQL, Query, Merge, and Table Comparison.
• Moved the projects from DEV to ST, ST to UAT and UAT to Production.
• 24/7 Production/On Call Support for BOE Reports, Servers and BODS Jobs.
• Worked Closely with AutoSys Scheduling team to Schedule Reports and ETL (Batch) Jobs.
• Involved in helping the users throughout the UAT phase.
• Used ClearQuest and ClearCase for Change and Version Control Management.
• Provided Business Objects information sharing sessions and training to the Users.

Environment: Business Objects XI 3.1/4.0, Designer/Information Design, BI Launchpad/Info View, WebI Rich Client, DeskI, CMC, CCM, Import Wizard, Crystal Reports 2008/2011, Dashboard Design/Xcelsius, BEx Queries, Business Objects Data Services XI 3.2, Data Services Designer, Data Services Integrator, Data Services Management Console, AutoSys, IBM Clear Case, Clear Quest, Windows 2003 Server, IBM-DB2.

Confidential, Seattle, WA

Business Objects/Crystal Reports Consultant

Responsibilities:

• Involved in Requirement gathering by working with business users, Business Analysts, and involved in Design and implementation of project deliverables.
• Used Crystal Reports for designing of reports and multi grouping of data at report level as per client requirement.
• Displayed pie charts, bar graphs more understandable for top-level management using Analyzer in the reports.
• Deployed reports in Crystal Enterprise and setup of Scheduling, Publishing is done. Set up of Users, Groups, User Ids, Single sign-on, Report viewing privileges for Users are done in Crystal Enterprise.
• Extensively involved in using of formulas fields, parameter fields, Group selection, record selection, and Crystal syntax in Crystal reports.
• Displayed reports for users on web browser by e-launch pad, e-portfolio using Crystal Enterprise.
• Extensively involved in SQL coding creating complex queries, Views, Stored procedures, Functions to give better results at Crystal Reports.
• Involved in CR’s (Change Request) Issues and resolving them in an estimated time period.
• Creation of packages, procedures, functions and triggers to boost the application performance.
• Created stored functions to manipulate table values before fetching it to the reports using queries.
• Converted existing Excel Reports and MS Access to Business Objects Reports.
• Defined and created classes, objects, conditions, users and measure objects to capture complex formulae.
• Created variables, formulae, grouping objects, and inserting prompts at report level.
• Designed and developed BODI scripts for data transformations.
• Created, validated and executed jobs to transfer data from various sources to target.
• Hands on experience in creating Query Transform, Map Operations, Table Comparison, Merge, Case, SQL and Validation of Transforms in order to load data from source to Target Systems.
• Created Projects and maintain them using Management Console.
• Created various transforms and cases to clean the data.
• Created Projects, Work Flow, and Data Flows and applied business logics to pull the data from source to Target.
• Maintain different Databases in data sources of SAP Business Objects Data Services.
• Used SAP and Non-SAP systems to pull the data using SAP Business Objects Data Services.
• Tuned Data Integrator Mappings and Transformations for the better performance of jobs indifferent ways like indexing the source tables and using Data transfer transformation.
• Utilized/managed various components of Business Objects Enterprise (BOE) XI 3.1 - Web Intelligence Rich Client, Central Configuration Manager (CCM) - Central Management Server (CMS), and BW Publisher for Crystal Reports reporting from Business Explorer (BEx).
• Worked extensively on Designer, Web Intelligence (WebI), Desktop Intelligence (DeskI), Crystal reports, Central Management Console (CMC) and Developments of Crystal Xcelsius components Grids, Pie charts, Bar Charts and developed the animation actions for those components.
• Tuned Data Integrator Mappings and Transformations for the better performance of jobs indifferent ways like indexing the source tables and using Data transfer transformation.
• Architected the Web Deployment strategy for Business Objects Web Reports using Web Intelligence, ZABO, automated document Scheduling and Publishing using Broadcast Agent.
• Doing production support and fixing the issues raised by the jobs while running in production.

Environment: Business Object Xi 3.0/3.1/3.2 Info View, Xcelsius 2008, Crystal Reports 9, Business Objects Data Integrator (BODI), Business Objects Data Services XI 3.1 Oracle, SQL Server.