We provide IT Staff Augmentation Services!

Sr. Tableau Developer/bi Lead Resume

5.00/5 (Submit Your Rating)

Weehawken, NJ

PROFESSIONAL SUMMARY:

  • 9+ years of experience in System Designing, Analysis, Application Development, Maintenance, Implementation and Project Management.
  • Experience in requirements gathering and interacting with the business users and transforming the Business Requirements to functional specs as per the Best Practices.
  • Hands - on with creating solution driven views and dashboards by developing different chart types including Heat/Tree/Geo Maps, Line/Bar/Pie Charts, Scatter Plots, and Bullet Graphs in Tableau Desktop versions 6, 7, and 8.1,9.
  • Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
  • Experience including technical support, troubleshooting, report design and monitoring of system usage.
  • Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
  • In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
  • Preparing Dashboards using calculations, parameters in Tableau 7.0/8.1.
  • Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
  • Utilized all Tableau tools including Tableau Desktop, Tableau Server, Tableau Reader, and Tableau Public.
  • Experienced in troubleshooting and performance tuning of reports and resolving issues within Tableau Server.
  • Experienced in Tableau Server administration including setting up Active Directory users and groups, giving appropriate permissions for viewing published dashboards and scheduling data refresh instances.
  • Experience with Business Objects modules like Designer, Web Intelligence,Desktop Intelligence, Rich Client, Crystal Reports, Import Wizard, Migration Wizard, Query As A Web Service (QAAWS), Dashboard Manager, Publishing Wizard, Central Management console, Xcelsius 2008.
  • Experience and thorough knowledge in BOE architecture, Services Process Flows, Content, Security, Scheduling and Publishing.
  • Strong technical and working experience with Crystal Enterprise Administrator Launchpad, Crystal Management Console, Crystal Configuration Manager, Crystal Migration Wizard, Crystal Publishing Wizard and e-portfolio.
  • Prepared different financial reports such as consolidated income statements and balance sheets using Crystal Report and Web Intelligence.
  • Expert in Installation and Configuration of Business Objects Product Suite.
  • Analysis to design the Universes and Business Objects Reports to support the user requirements.
  • Involved Conceptual,Logical data modelsbased onSource system analysisand then builtPhysical data modelsincluding tables, primary keys, foreign keys, indexes, views, Stored Procedures and data types.
  • Ability to design, code, debug, document and support efficient computer applications and tools consistent with established specifications and business requirements.
  • Developed templates for data mapping and facilitated workshops with cross functional business users to understand complex legacy systems data structures, mapping data into to-be BO data warehouses and developed conversion/transformation rules.
  • Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analyses and data management services.
  • Experience with multiple RDBMS including Oracle 11g/10g/9i/8i/7.x, MS SQL Server 2008/2005/2000, DB2, Sybase, MS Access and associated SQL Dialects such as PL/SQL.

TECHNICAL SKILLS:

Reporting Tools: Tableau 6/7/8/9, Desktop/Server, Business Objects 4.1/4.0/3.1/XI R2/XI/6.5/6.1 (Central Management Console, Central Configuration Manager, Central Management Server, Desktop Intelligence, Import Wizard, Publishing Wizard, Web Intelligence, Xcelsius, Designer, Info View, Performance Manager, Dashboard Manager), Crystal Reports 2011/2008/XI/10.0/9.0/8.5, Oracle Reports 10g, SSRS 2005/2008, IBM Cognos 8.4, SAS

Databases: Oracle 11g/10g/9i/8i/7.3, MS SQL Server 2008/2005/2000/7.0, IBM DB2 UDB 8.0/7.0, Teradata V2R5/V2R3, Sybase 12.x/11.x, MS Access 2000

ETL: Business Objects DI, Informatica (Power Mart & Power Center)8.1/7.x/6.x/5.x, Data stage 8.x/7/x, SQL Server SSIS/ DTS

Data Modeling: Erwin, TOAD, Pl/SQL Developer, SQL* Navigator, SQL*Loader

Programming Languages: VB Script, C, C++, C#, ASP.NET, ADO, VB.NET, Java, SQL, PL/SQL, T-SQL

Servers: Web Logic Application Server 6.1 / 5.1, Web Sphere 4.0.2/3.02, Apache, TOMCAT

Operating Systems: Linux, UNIX, Sun Solaris UNIX, Windows NT/2000/2003

PROFESSIONAL EXPERIENCE:

Confidential, Weehawken, NJ

Sr. Tableau Developer/BI Lead

Responsibilities

  • Involved in full project lifecycle of SDLC and coordinated with all project teams.
  • Interacted with Subject Matter Experts & End Users and gathered business requirements.
  • Acted as liaison between Business Intelligence and Business User groups to relay change requests.
  • Actively participated in Business Intelligence standardization to create Oracle database that can be used for development of various Tableau reports/ dashboards.
  • Analyzed requirements for various reports, dashboards and created the same using Tableau desktop server.
  • Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.
  • Mentored business power users to create reports/dashboards using tableau desktop.
  • Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
  • Developed of key indicators and the appropriate tracking reports with graphical and written summations to assist in the quality improvement initiatives.
  • Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
  • Created customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
  • Created and modified Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
  • Created Table of Contents (TOC), a common navigation page which had all the links to various dashboards.
  • Make use of filters and making them local and global accordingly.
  • Publish the developed dashboard, reports on theTableauServer so that the end users having access to the server can view the data.
  • Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
  • Played an important role in coordination with the entire team and managing the time estimates for the entire project.
  • Modified, maintained and developed the Stored Proceedures to develop new enhancements.
  • Used SQL tools like Toad, Pl/SQL to run SQL queries and validate the data in the warehouse and marts.
  • Ensured on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.
  • Oversee the performance of Design to develop technical solutions from Analysis documents.
  • Provided post implementation production support.

Environment: Tableau Desktop 8.1/8.2/9, Tableau server / Administrator, PL/SQL developer, Oracle 11g, Microsoft Excel 2010, Windows 2007 server, UNIX.

Confidential, Peapack, NJ

Sr.Tableau Developer/BI Report Developer

Responsibilities:

  • Interacted with business users and performed Gap Analysis of Client requirements.
  • Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
  • Worked with the report development Manager and other team members on report requirements based on exiting reports/dashboards in Excel, timelines, testing, and technical delivery.
  • Worked closely with business power users to create reports/dashboards using tableau desktop.
  • Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
  • Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
  • Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
  • Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
  • Developed various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
  • Actively involved in Setting up Tableau Environment.
  • Creating Visualizations in tableau using Excel, DW and SharePoint data.
  • Involved in report tuning, caching, specifying query governing thresholds, and report optimizations
  • Actively participated in clarification meeting with the Clients.
  • Created Test Cases and documented the Test Results.
  • Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
  • Designed, developed and implemented universes using Business Objects and Web intelligence.
  • Exported the universes and Crystal Reports to the Repository to make resources available for the migration from UAT to Production.
  • Making the user resources more flexible as per the business requirement by exporting Universe and Crystal Reports reports.
  • Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau Desktop 8.1/8.2, Tableau server / Administrator, SAP Business Objects 4.1/4.0, Crystal Reports 2013/2011, SQL developer, Oracle 11g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server.

Confidential, Blue Bell, PA

Sr. Data Analyst/Tableau Developer

Responsibilities:

  • Involved in reviewing business requirements and analyzing data sources form Excel/Oracle for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
  • 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.
  • Responsible for creating reporting data model as per the requirements.
  • Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
  • Created Heat Map showing current subscribers by color that were broken into regions allowing business users to understand where we have most customers vs. least customers.
  • Projected and forecasted future growth in terms of number of sales based on the products by developing Area Maps to show details of which products are being sold the most.
  • Converted charts into Crosstabs for further underlying data analysis in MS Excel.
  • Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle 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 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.
  • 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.
  • Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
  • Involved in migration of Reports from BIRT to Tableau.
  • Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
  • Expert knowledge of various report writing tools such as Crystal Reports and/or SQL server reporting services.
  • Knowledge of building and maintaining OLAP cubes.
  • Created VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
  • Assisted with automation of finance department’s manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.
  • Responsible for timely implementation of data requests related to business systems from CMS events provides a high level of service to all internal and external customers.
  • Contributes to a positive teamwork environment.

Environment: Tableau Desktop 7 & 8.1, Tableau Server, Business Objects 4.0/XI 3.1, Crystal Reports 2011/ 2008/XI/10.0, MS Office Suite, Oracle 9i/11g, MS Excel, PL/SQL developer, TOAD, VB script, C#, Web Sphere 4.0, Web Logic Application Server 6.1.

Confidential, NJ

Tableau Developer/Sr. Reporting Consultant

Responsibilities:

  • Requirements Gathering and Business analysis
  • Familiarized the business, its strategy and implementation.
  • Gathered User and Owner requirements; analyzed and documented them.
  • Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
  • Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
  • Involved in created stored procedures, views, and custom sql queries to import data from sql server to tableau.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
  • Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.
  • Ability to work quickly and under tight delivery deadlines with focus on details.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.
  • Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
  • Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
  • Designed and customizing data models for Data warehouse supporting data from multiple sources on real time.
  • Provided report generation solution to the clients using different versions ofCrystal Reportsbest suited for the business requirements.
  • Bug fixing and enhancing existing reports. Making changes to the reports that are created in earlier versions to Crystal reports 2008.
  • Developed Stored Procedures, Views to extract, manipulate and calculate information to fulfill data and reporting requirements.
  • Modified the existing reports by addingnew logicand deletingexisting logicas the line of Business changes periodically.
  • Coded Business logic in C#, VB.NET.
  • Created VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
  • Designed and developed MS Access user interfaces with user validations using VBA.
  • Created numerous dashboards in Tableau Desktop based on the data collected from Mobile Banking App by importing and blending data from MS Excel and CSV files along with Oracle SQL Server Databases.
  • Created detail and summary reports used to fold/Unfold sections corresponding to Breaks in current blocks.
  • Publish the reports in Crystal Enterprise Development environment and follow up with business users on getting the sign off for the reports developed.
  • Participated in bi-weekly crystal developers meeting where we discussed about the issues and solutions we had/found during last 2 weeks so that this helped all the crystal developers to be on one page.
  • Designed Test cases for UAT of Reports for end users.
  • Trained Users on techniques to create reports using Crystal Report Designer & deployment of Reports using Crystal Enterprise.

Environment: Tableau Server 7.0/6.1, Tableau Desktop 7.0/6.1, Business Objects 4.0/XI 3.1(Designer, Web Intelligence, Web Rich Client, Xcelsius 2008, QAAWS, Central Configuration Manager, Central Management Server, Import Wizard, Publishing Wizard), Crystal Reports 2011/ 2008/XI/10.0, Crystal Enterprise, SSRS 2005/2008, DB2 UDB, Oracle 11g/10g/9i, MS Access 2010, PL/SQL developer, TOAD, VB script, C#, Visual Studio 2008, Web Sphere 4.0, Web Logic Application Server 6.1.

Confidential, Columbus, OH

Report Programmer

Responsibilities:

  • Extensively involved in setting a new BO 3.1 Environment.
  • Successfully installed and configured Business Objects 3.1 on Staging Environment, Applied Service Pack and fix pack.
  • Clustered the servers successfully by distributing the Business Objects Services effectively between all the servers to make the Business Objects Environment Highly Available and got the “FAILOVER” to work efficiently.
  • Used Import Wizard tool to migrate all the objects from BO XIR2 to BO 3.1.
  • Tested all the reports that are migrated and analyzed the performance of the BO 3.1 using Load Runner by creating many virtual users.
  • Resolved the performance issues in BO 3.1
  • Installed and Configured BO 3.1 on Production Environment of different regions.
  • Maintained the whole environment (TEST, DEV and PROD) along with 8 main servers.
  • Experience in scheduling of repository backup and tuning the Business Objects servers for a better performance.
  • Configured File Repository Servers, Crystal Report Job, Cache and Page Servers, LOV Job server, Web Intelligence Job and Report Servers, Desktop Intelligence Job, Report and Cache Servers, Destination Job Server, Program Job Server, and Event Server.
  • Applying patches, hot fixes, critical fixes, service packs and testing/applying security patch.
  • Requirement Collection, Documentation & high-level design.
  • Configured Crystal reports 2008 to develop reports using Custom Coded functions.
  • Updated and maintained Universes to meet new reporting requirements.
  • Trained end users in understanding the reports. Functionalities such as Slice and Dice, Prompt, Drill mode and Ranking were used for Multidimensional Formatting.
  • Created multiple universes and resolved Loops by creating table aliases and contexts.
  • Created Repository with multiple universe and document domains for Development and Test
  • Environments and distributed the BO Main key among the enterprise.
  • Created graphs/charts for the reports, Created Master Detail and Cross Tab Reports.
  • Extensively involved in using of formulas fields, parameter fields, Group selection, record selection, and Crystal syntax in Crystal reports.
  • Created hyperlinked reports using open doc function.
  • Created reports from multiple data providers based on the requirements.
  • Used query as a web services and live office for automation of Dashboards.
  • Created dashboard using crystal Xcelsius.
  • Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
  • Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
  • Documented all the differences between the two Versions XIR2 and XI 3.1, for the end users to understand the new environment effectively.
  • Assisted with automation of finance department’s manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.
  • Involved in developing applications using Java, J2EE and Struts
  • Designed and developed various complex reports such as Tabular, Cross-tab, Pie Chart reports, Sub Reports, Drill down reports, and Drop down reports using MS Reporting Services (SSRS) and involved in managing the subscription and authentication of these reports.
  • Responsible for writing the SQL queries for the data validation and testing the reports.

Environment: Business Objects 3.1/XIR2, Crystal Reports XI/2008, Xcelsius 2008, Designer, Publication Wizard, Import Wizard, Dashboard Manager, Tableau Desktop, Tableau Server, Reporter, Designer, Business Query, BO SDK, Web Intelligence 2.x/6 and Info View, SSRS 2000, Windows XP, server 2003, Oracle 9i/10g, DB2, Teradata, Informatica Power Builder 8.6, Erwin Tool.

Confidential, Hartford, CT

Crystal Reports Developer

Responsibilities:

  • Responsibilities include direct interaction with the user for getting specifications, draft specs, generating new report according to the specs and giving it to the user for verification and drafting the Crystal Reports in the Corporate Intranet.
  • Provided support for maintenance of the Track Wise system: user account management, staticdata management (selection values), data management for record resets (TR resets), loginissues, system issue using web admin and other Track Wise tools in Track Wise System.
  • Involved in analyzing multi-dimensional reports in Crystal Analysis
  • Installed & deployed Business Objects crystal Integration Pack.
  • Conversion of crystal reports version 8.5 to Crystal reports XI
  • Modified already existing reports and converted into Crystal Reports XI.
  • Developed several Complex Reports (various features used include multiple groupings, drilldowns, parameter fields, formulas and conditional formatting) using Crystal Reports.
  • Designed Complex reports using sub reports, manual cross tabs using Crystal syntax with extensive usage of Local, Global, and Shared variables at report formulas
  • Displayed reports for users on web browser by e-launch pad, e-portfolio using Crystal Enterprise
  • Involved in the preparation of SR (Service Requests) along with the Business people after a thorough discussion of the Business and System requirements.
  • Interacted with users in resolving the Help Desk Tickets (HD).
  • Defined security for people Soft users at Application level, OS level & at data level.
  • Installed and set the Central Management Server, Processing Servers & Report Application Server.
  • Set up of Users, Groups, User Ids, Single sign-on, Report viewing privileges for Users are done in Crystal Enterprise
  • Defined User Accounts, groups & set up administrator privileges
  • Published Objects with the central management console
  • Extensively involved in using of formulas fields, parameter fields, Group selection, record selection, and Crystal syntax in Crystal reports
  • Assisted in the identification, planning, implementation and support of various Business Intelligence initiatives and supported Business-critical analyses. Also translated business requests into reporting and analytical deliverables.
  • Collaborated with the QA team to create and execute system test plans and user-acceptance testing.
  • Created complex reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drill-down reports, analysis reports, data reports using latest version of crystal reports.
  • Conducted analysis and generated tables, listings and graphs using SAS.
  • Worked with business users to develop reporting and data requirements and also performed ad-hoc queries as necessary.
  • Performed business and data analysis activities to design and develop reports from the reporting databases.
  • Published reports via. Publishing Wizard and Management Console.
  • Provided technical assistance by responding to inquiries regarding errors, problems and technical questions. Trained end users and technical support staff as required.
  • Developed SQL queries to extract, manipulate and calculate information to fulfill data and reporting requirements.

Environment:Crystal Reports XI/8.5, Crystal Enterprise, Business Objects XIR2/6.5/6.1 (Import wizard. CMC, Info view, Web Intelligence 6.1, DESKI), Tableau Desktop, Tableau Server, SAS V8, Data Integrator, Dashboard Manager SQL, PL/SQL, SQL*Loader, Windows 2000/NT, Oracle 9i, Oracle CC&B

Confidential, Hartsville, SC

Crystal Reports Developer

Responsibilities:

  • Interacted with Business Users and Business Analysts to gather the Requirements and Business logics.
  • Involved in Writing Detailed Level Documentation for reports and Universe design.
  • Involved in the designing and Building of Universes from different data sources like Teradata, Oracle/SQL Server.
  • Linked Universes to share the Universes, which had common dimension tables and the classes and objects.
  • Applied row level and object level securities to different groups and users using Designer component.
  • Resolved loops by creating alias and contexts to remove the cyclic dependencies between the tables.
  • Resolving join path Problems like ‘Chasm Trap’ and ‘Fan Trap’ and loops by creating Context and Aliases.
  • Modified Universes with pre-calculated aggregates from summary tables.
  • Created cascading list of values to enable cascading prompting in the reports using Designer.
  • Generated reports using free-hand SQL, which had complex Business Logics.
  • Involved in postproduction Support and gave training to the end users to create ad-hoc reports.
  • Created full client and Web Intelligence reports. Modified the existing by adding new columns based on the result set.
  • Created Web Intelligence reports with more than 10 data providers and synchronized the data using the merge dimensions option.
  • Created cascading list of values to enable cascading prompting in the reports using Designer.
  • Designed, developed and tested the reports based upon data generated by enterprise transaction, financial, and customer information systems using Business Objects connected to Oracle 10g/11g data sources.
  • Published Crystal Reports to Business-Objects Enterprise System using publishing wizard.
  • Generated dynamic cascading values in the process of building Crystal Business Views.
  • Created interactive Dashboards and Business Presentations with Crystal Xcelcius using QAAWS.
  • Created new Universes specifically designed for creation of Dashboards.
  • Created local variables with complex logics in the reports for calculating the metrics in the canned report.
  • Created complex formulae in the Web I report to dynamically change the column that need to be displayed in the table depending on the prompt values
  • Used advanced functionalities like Optional prompts, Hyper-linking.
  • Used Hibernate framework for the backend persistence.
  • Tested the report data by comparing with the data from the report with the SQL outputs from the database to ensure the quality of reports generated.
  • Designed Test cases for SIT and UAT of Universe and Canned Reports for end users.
  • Ensured the quality and timely delivery of all the important complex canned reports, and Involved in migration and testing of Objects to PROD environment from DEV through QA environment using Import Wizard.

Environment: Business Objects XI-r2, Web Intelligence, Desktop Intelligence, Crystal Reports 10.0, TOAD, Oracle 10g, MS SQL Server 2000, SQL, Oracle Application Server, BEA Web logic, Java, J2ee, JSP and PL/SQL.

Confidential

Report Developer

Responsibilities:

  • Responsible for fitting Business Objects into the Information Architecture of the company as well as supporting business users and developing new and maintaining existing Universes.
  • Installed and configured Web Intelligence & Broad cast Agent server on AIX 4.3
  • Developed CAN reports with PIE charts, BAR charts.
  • Upgraded business objects from 4.1.4 to 5.0.
  • Migrated repositories and domains and all user security structures.
  • Migrated reports, scripts and universes and web intelligence 2.0 to 2.5.
  • Designed universes with BO designer and implemented row level restrictions with supervisor.
  • Designed VB interfaces and integrated BO Full client reports.
  • Written VBA macros and BOSDK for automation of execution of BO reports
  • Scheduled reports with BAS.
  • Created Excel applications (VBA, Macros) to import historical data which include multiple databases and perform various statistical analyses, charts and graphs.
  • Plan, coordinate and execute Business Objects 5.0 deployment for End users.
  • Train user community in basic and advanced Business Objects reporting skills.
  • Provide ongoing administration for the Business Objects 5.0 environment.
  • Customized WebI prompts.
  • Developed Budget reports for different level of users.
  • Developed Budget vs. Actual reports for different periods in Oracle reports.
  • Created power users for different departments and assigned as Designers and Supervisors.
  • Defined several categories for different set of reports.

Environment: Business Objects 6.5, Crystal Reports 8.5, web Intelligence 2.5, ZABO, BCA VBA, BOSDK, Oracle 8.0

Confidential

Business Objects report Developer

Responsibilities:

  • Designed and developed primary database objects (tables, views, indexes).
  • Created tracking mechanisms to promote database changes from development to testing, testing to production, which saved database promotion time for the customer.
  • Developing SQL queries to check/update the database
  • Created Reports using Business Objects with different data providers.
  • Design and implemented process for migrating existing data from MS Access to MS SQL Server.
  • Recommended improvements to existing application for performance and scalability requirements.
  • Analyzed, designed and created reports for users Using Business Objects.
  • Going through the clients requirements and coming up with database design and application architecture.
  • Involved in building Conceptual and Physical Data Modeling of the application using Erwin.
  • Wrote complex stored procedures and triggers using Transact SQL.
  • All drilling functionality within the core reporting tool, giving users the ability to easily drill down into greater detail within a report, or up into higher levels of aggregation.

Environment: Business Objects 5.0, Crystal Reports, SQL Server 2000, Erwin, DTS, MS Access, Oracle, Java, XML, HTML, Windows 2000.

We'd love your feedback!