Sr. Data Analyst Resume
NyC
SUMMARY:
- Over 14 years of Professional Experience in the Analysis, Design, Development and Implementation of Relational Database (OLTP) and Data Warehousing Systems (OLAP) as Business Intelligence Reporter using tools like 8.1/9.0/9.0.1, Tableau, Business Objects 4.1,3.1, XI R2, 6.x, 5.x, Crystal Reports, Xcelsius 2008/4.5, QaaWS, Live Office, OBIEE, Informatica, and Data Integrator (BODS).
- Having 10 years’ experience in Business Objects Suite (6.x/XIR2/3.1), XCelsius, QaaWS, Live office, Import Wizard, Designer, Desktop Intelligence, Web Intelligence, Broad Cast Agent, Central Management Console/ Supervisor, Performance Management / Application Foundation, Java/.net Web - Intelligence, BO Developer Suite using SDK.
- Around 5 years of extensive experience as MicroStrategy Developer, Architect & Administrator building projects and creating reports and Dashboards using MicroStrategy 9.4.1, MicroStrategy Desktop, MicroStrategy Web, MDX Adapter, Office, MicroStrategy Intelligence Server and MicroStrategy Architect.
- Expertise in Desktop creating and integrating Microstrategy reports, objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) and Generic cubes.
- Extensively worked on designing schema and creating Facts, Attributes, Hierarchies and Transformations.
- Extensively worked on creating MicroStrategy Dynamic Dashboards with multi layout and used Widgets, Waterfall, Graph Matrix, Gauges, Micro charts Widgets and Grid/Graph.
- Worked extensively on VLDB Properties for performance tuning.
- Strong in conceptualizing and communicating enterprise data architecture frameworks for global enterprises for inter operation of data warehouses, middleware, and web applications.
- Expertise in planning, designing, developing, distributing and maintaining Universes.
- Expertise designing Xcelsius dashboards using QaaWS, Live Office, XML Connection, External interface connection, Flash Variables.
- Having good experience in Supervisor/CMC, Broadcast Agent and Auditor.
- Business Objects Server Administration and associated Server Products (Web Intelligence, Broadcast Server etc.) with Data warehouse.
- Created complex Ad-hoc reports using Business Objects and Web Intelligence tools.
- Experience in resolving the issues like loops and Traps using Alias and Context.
- Expertise in scheduling the documents using Central Management Console / Broadcast Agent.
- Very strong in Client/Server Architecture, Relational Databases (RDBMS), Data Modeling and Design and build the Data Warehouse, Data marts using Star Schema and Snow Flake Schema for faster and effective Querying for the Metadata Management solutions.
- Synchronized queries from multiple data providers used Drill-up, Drill-down, slice and dice features using Business Objects.
- Experience in developing Crystal Reports, Cross Tab Reports, Top N Reports for highlighting significant data, summary reports with drill-down capabilities.
- Expertise in Migration of universes/reports/users/groups/personal documents/inbox documents to Business Objects 3.1 previous versions and conversions of Reports.
- Hands on experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions and packages.
- Specialized in creating complex query reports using Oracle, SQL server, MS Access and various RDBMS.
- Expertise in Crystal Enterprise Architecture (Web component server, automated process scheduler, File repository server, Event server, Page server, Cache server, Job server).
- In-depth knowledge in working and implementation of Crystal Enterprise & Reports 7.0/8.0/8.5/XI.
- Around 6 years of programming experience using PL/SQL,SQL*Loader, ODBC, SQL Navigator, Toad, Visual Basic, Korn Shell, Unix Shell Scripting Win NT and Sun Solaris.
- Provided 24X7 support to the users.
- Unique ability to understand long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts. A strong team member with good communication skills.
TECHNICAL SKILLS:
Reporting Tools: MicroStrategy 8 .1/9.0/9 .4.1 Administrator, Architect, Desktop, Object Manager, Enterprise Manager, MicroStrategy ODBC test tool, Business Objects 4.1/3.1/XI r2/r1//6.5.1/6.1b/5.x (Designer, Reporter, Supervisor), Web Intelligence/Infoview 2.x, Broadcast Agent, Auditor, Application Foundation 6.51,Webi SDK,BO SDK using ASP and JSP, Brio, SAS, Crystal Reports XI, Xcelsius Designer4.5, OBIEE(Administration, Answers and Dashboard) and MicroStrategy 9.4.1 (Developer, Architect and Intelligent Server) .
ETL: Data Integrator 6.5/ XIR2, Informatica 7.1/8.1(Power Mart & Power Center)
RDBMS: DB2, Oracle 11g/10g/9i/8i, MS SQL Server2000/2005, Sybase ASE, Informix, Sybase IQ, Teradata Internet J2EE, XML, Java Beans, Servlets, JSP, ASP, VBScript, JavaScript
Languages: Java2, PERL, C++, C, VB, Shell Scripting
OS: Sun Solaris UNIX, Linux, Windows NT/2000.
Servers: WebLogic Application Server 8.1/6.1 / 5.1 / 4.5, WebSphere 7/5.1/4.0.2/3.02, TOMCAT5.0/ 3.2.1.
Tools: ERwin 4.1/4.0, MS Project, Jbuilder4, TOAD 6.5 and SQL Navigator 4.1
ERP: Oracle Applications 11i
PROFESSIONAL EXPERIENCE
Confidential, NYC
Sr. Data Analyst
Responsibilities:
- Involved in Requirements gathering by interacting with the Business Users.
- Responsible for design and architect the BI Application.
- Responsible for SSO integration with Oktha.
- Created Metadata Repository and Statistical tables, Intelligence Server and Project on MicroStrategy Desktop using the Configuration Wizard.
- Generated MicroStrategy Reports by creating Schema and Public Object like attributes, facts, hierarchies, metrics, filters, Transformations, custom groups and Consolidations.
- Used Administrator tool Object Manager to move the objects from one environment to another environment.
- Extensively worked with MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Administrator reporting basic using MicroStrategy Desktop and MicroStrategy Web.
- Involved in troubleshooting MicroStrategy prompt, filter, template, consolidation, and custom group objects in an Enterprise Data Warehouse team environment.
- Designed Prompts and Filters to generate reports in grid and graph mode
- Created Report Services Documents out of existing reports and customized them to reflect the Company's logos and color palette.
- Designed various prototypes of dashboards using MicroStrategy Visual Insight, which would give ability to the users to drill down to claim (lowest) level.
- Created more visual and look and feel dashboards by using Vitara plugins as part of POC.
- Created Dynamic Dashboards showing Company's yearly performance using various graphs and widgets.
- Created POC with R integration statistical analysis for Revenue Forecast.
- Created custom ‘What IF’ analysis dashboard for finance team.
- Experienced in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom Group objects in an enterprise data warehouse team environment.
- Created custom subscription solution for overage reports that will send the email to the partners and clients if usage reaches 75% and collection notices.
- Created dashboards with PowerBI as part migration.
Environment: MicroStrategy 10 /10.4/, Administrator, Architect, Desktop, Object Manager, Enterprise Manager, MicroStrategy ODBC test tool, PowerBI, Microsoft SQL Server, Aqua Studio, Tomcat and Windows.
Confidential, Wall St, NYC
Sr. Application Programmer/Technology Specialist
Responsibilities:
- Responsible for creating documentation for technical specifications of the Orchestria eCOMM project
- Prepared for Technical design document for BO to Microstrategy migration plan.
- Worked with Connectivity Configuration Wizard to configure the Metadata connectivity information, metadata DSN name etc.
- Interacted with users from different functional teams across the organization global to gathering requirements for developing reports and dashboards.
- Created different Project Sources for different environments DEV, UAT and PROD testing and development.
- Extensively worked on Developer to create Applications Objects, Reports and Dashboards.
- Created different schema objects like Attributes, Facts by using MicroStrategy Architect of the MicroStrategy BI Suite.
- Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
- Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports.
- Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
- Extensively worked on creating Dynamic Dashboards with multi layout and used custom Widgets built for desktop and Mobile for specialized dashboard.
- Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
- Worked in MicroStrategy Administration creating new users, roles, privileges, shared folders, access controls
- Working with support teams
Environment: MicroStrategy 8 .1/9.0/9 .4.1 Administrator, Architect, Desktop, Object Manager, Enterprise Manager, MicroStrategy ODBC test tool, Oracle 11g, Toad, WebSphere and Windows and Unix.
Confidential, Warren, NJ
Sr. Application Programmer /Technology Specialist
Responsibilities:
- Involved in the documentation of technical specifications of the COE Adhoc, Campus Recruiting and Lateral Recruiting Projects.
- Worked with Connectivity Configuration Wizard to configure the Metadata connectivity information, metadata DSN name etc.
- Interacted with users from different functional teams across the organization in gathering requirements for developing departmental dashboards and Key Performance Index corporate dashboards
- Created different Project Sources for different environments DEV, UAT and PROD testing and development.
- Extensively worked on Developer to create Applications Objects, Reports and Dashboards.
- Created different schema objects like Attributes, Facts by using MicroStrategy Architect of the MicroStrategy BI Suite.
- Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
- Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports.
- Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
- Created COE Ad-hoc reports by gathering specific requirements from the different users.
- Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
- Worked in MicroStrategy Administration creating new users, roles, privileges, shared folders, access controls Lists.
- Involved extensively in the overall life cycle of the Data Warehouse integration project.
- Implemented Row level and Columns level security.
- Extensively worked on creating Dynamic Dashboards with multi layout and used custom Widgets built for desktop and Mobile for specialized dashboard.
- Designed interactive and visually stunning Dynamic Dashboards using Report Services objects like Waterfall, Graph Matrix, Gauges, Micro charts Widgets and Grid/Graph combinations.
- Success fully implemented MDX cube for Essbase users.
- Implemented SSO Citi standard security for MicroStrategy users.
- Integrated MicroStrategy web logging through WFR application visa SSO.
- Involved in user training sessions for and assisting in UAT (User Acceptance Testing).
- Responsible to handle the production tickets.
- Prepared and documented the documents generated during the process were Requirements Specifications, Design Document, Project Planning, Change History, Unit testing documents, and System testing documents.
Environment: MicroStrategy 8 .1/9.0/9 .4.1 Administrator, Architect, Desktop, Object Manager, Enterprise Manager, MicroStrategy ODBC test tool, Oracle 11g, Toad, WebSphere and Windows and Unix.
Confidential, Warren, NJ
Sr. Application Programmer /Technology Specialist
Responsibilities:
- Responsible for HR Dashboard, Leader Scorecard, Cube, COE and Standard reports applications requirement analysis, functional and technical specification, architectural design, and implementation.
- Designed Business Objects Universes for star schema data models.
- Designed architecture & set up for development, production & test repositories
- Involved in implemented Migration process for Business Objects XI r2 to 3.1, such as readiness assessment and deployment plan, Migration and system Upgrades, Deployment services
- Responsible for gathering the Dashboard requirements, Designing, and developing the Reports using Xcelsius 2008.
- Designed complex dashboards using Xcelsius and integrated with Java application.
- Designed Xcelsius dashboards using QAAWS, Live Office, XML Data, Flash Variables, Web Services and External Interface Connection.
- Developed Xcelsius dashboards for presentations, live data dashboards with alerts, Calculators, Historical data comparisons, what if analyzers for real time understanding of changes in business and embedding of dashboards into webpage.
- Implemented user security by using Citi security architecture add user program.
- Created Webi and Deski reports for HR Dashboard and Leader Dashboard detail reports
- Designing Universes for various business needs and resolved Chasm trap, Fan traps using Contexts & Aliases.
- Created complex Web I reports by linking objects from different data providers and using Merge Dimension Option.
- Worked extensively with the major functionality of BO like Breaks, Alerter, Filters, Sorts, and Query Prompt and Drill filters.
- Tuned SQL & universes for trouble shooting of reports for data accuracy and reports for better performance using SQL Explain plan.
- Worked extensively on Import Wizard and LCM in Promoting the Universes/Reports based on the SDLC Process(Dev UAT PROD)
- Used Business Objects SDK (Java) to build applications that enable users to browse the Enterprise Repository, export reports, and handle scheduling tasks.
- Integrated Xcelsius Dashboards, Webi reports to Java application using BO SDK, JAVA/J2EE.
- Developed User interface application using Java, J2EE, JSP, HTML, Java Script, HTML, Servlets, Struts frame work and BO SDK.
- Integrated Webi reports, Dashboards and BO Scheduling with Java application using BO SDK’s.
- Created users and groups in the CMC Central Management Console and grated permissions based on their usage levels.
- Created Formulae in Crystal Syntax to be used in the report and converted the formulae to custom functions if they were used in other reports.
- Created reports that include options such as Grouping, Sorting, Drill-down, Parameter prompts.
- Created report templates, developed Ad-hoc reports, complex reports (e.g. reports from multiple data sources, drill down capabilities by using Crystal Reports, WEBI).
- Created Linked, Unlinked, Parameterized and On-demand details reports for various business needs, reports scheduled for different file based / schedule based events, distributed in email, PDF and HTML format.
- Developed Voyager Workspace reports for multi-dimensional analysis.
Environment: Business Objects XIr2/3.1/4.1, Web Intelligence, Web Intelligence Rich Client, Crystal Reports 2008, Xcelsius Designer 2008, QAAWS, Live Office, WebServices, Voyager, BO SDK, WEDI SDK, RAS SDK, Java, J2EE, JSP, Servlets, Struts, Java Script, XML, Oracle 10g/11g, TOAD, PL/SQL, Excel, WebShere, WebLogic, Tomcat, SharePoint, Windows and UNIX
Confidential, San Jose, CA
Sr. Business Objects SDK Consultant
Responsibilities:
- Actively participated in team meetings for business requirement analysis, functional and technical specification, architectural design, and implementation.
- Designed Business Objects Universes for star schema data models.
- Developing complex universes by using advanced features like aggregate aware, Conditions and hierarchies.
- Responsible for gathering the report requirements, Designing, and developing the Reports using Webi and Web Intelligence SDK.
- Responsible to migrate the PL/SQL reports into WebI reports.
- Created Webi and Deski reports and extensively used Web Intelligence Rich Client to analyzing the sales performance by stores, divisions, Regions and Area.
- Developed UI using JSP, HTML and Java Script to submit the user report parameters and columns.
- Developing the JSP pages to submit the report parameters and report columns by using Report Engine SDK.
- Developed Lookup Reports using Webi and integrated this lookups into the main JSP Page using Java code.
- Developed SDK code for scheduling the reports from the Java Application.
- Customized WEBI with WEBI SDK and integrated with java portal to get the complete functionality.
- Generated WEBI reports using Business Objects Web Intelligence to popup in Java Server pages.
- Created Portal for all the reports.
- Deploying and testing the JSP and Servlets.
- Design and development of User Interfaces using JSP, (J2EE), XML, XSLT, HTML and CSS.
- Testing of Reports according to the functional requirement and deploying over web.
Environment: Business Objects 3.1, Web Intelligence, Web Intelligence Rich Client, Informatica, Administration, BO SDK, WEDI SDK, RAS SDK, Java, J2EE, JSP, Servlets, Java Script, XML, Teradata, Oracle 10g, TOAD, PL/SQL, Excel, Tomcat, Windows and UNIX
Confidential, Roanoke, VA
Sr. Business Objects Consultant
Responsibilities:
- Responsible for Commercial business report requirement analysis, functional and technical specification, architectural design, and implementation.
- Designed Business Objects Universes for star schema data models.
- Designed architecture & set up for development, production & test repositories
- Involved in implemented Migration process for Business Objects XI r2 to 3.1, such as readiness assessment and deployment plan, Migration and system Upgrades, Deployment services and Education delivery.
- Responsible for gathering the report requirements, Designing, and developing the Reports using Crystal Reports 2008.
- By using Linking Universe created master and child universes for Commercial and Merchandizing.
- Developing complex universes by using advanced features like aggregate aware, Conditions and hierarchies.
- Implemented user security by using Entitlement Table.
- Created Webi and Deski reports and extensively used Web Intelligence Rich Client to analyzing the sales performance by stores, divisions, Regions and Area.
- Designing Universes for various business needs and resolved Chasm trap, Fan traps using Contexts & Aliases.
- Created complex Web I reports by linking objects from different data providers and using Merge Dimension Option.
- Worked extensively with the major functionality of BO like Breaks, Alerter, Filters, Sorts, and Query Prompt and Drill filters.
- Tuned SQL & universes for trouble shooting of reports for data accuracy and reports for better performance using SQL Explain plan.
- Worked extensively on Import Wizard in Promoting the Universes/Reports based on the SDLC Process(Dev UAT PROD)
- Used Business Objects SDK (Java) to build applications that enable users to browse the Enterprise Repository, export reports, and handle scheduling tasks.
- Created users and groups in the CMC Central Management Console and grated permissions based on their usage levels.
- Created Formulae in Crystal Syntax to be used in the report and converted the formulae to custom functions if they were used in other reports.
- Created reports that include options such as Grouping, Sorting, Drill-down, Parameter prompts.
- Created report templates, developed Ad-hoc reports, complex reports (e.g. reports from multiple data sources, drill down capabilities by using Crystal Reports, WEBI.
- Created Linked, Unlinked, Parameterized and On-demand sub reports for various business needs, reports scheduled for different file based / schedule based events, distributed in email, PDF and HTML format.
- Created Crystal reports and live data Xcelsius dashboards from EDW data via OLAP kit and QaaWS.
- Developed Xcelsius dashboards for presentations, live data dashboards with alerts, Calculators, Historical data comparisons, what if analyzers for real time understanding of changes in business and embedding of dashboards into webpage.
- Created various dashboards to measure the Store sales performance by year, quarterly, period and weekly using Xcelsius Designer.
- Implemented Java Portal to access the Webi and Crystal Reports.
- Involved in user training sessions for and assisting in UAT (User Acceptance Testing).
- Trained in OBIEE to create the dashboards.
- Crated Repository in OBIEE and developed reports using Answers.
- Worked on Universes and Connection management process.
- Responsible to handle the production tickets.
- Prepared and documented the documents generated during the process were Requirements Specifications, Design Document, Project Planning, Change History, Unit testing documents, and System testing documents
Environment: Business Objects XIr2/3.1, Web Intelligence, Web Intelligence Rich Client, Crystal Reports 2008, Crystal Xcelsius Designer 2008, QAAWS, Voyager, Data Stage8, SalesForce.com, OBIEE, Administration, Answers, Dash Boards, Rational ClearQuest, BMC Remedy, BO SDK, WEDI SDK, RAS SDK, Java, J2EE, JSP, Servlets, Struts, Java Script, XML, DB2, Oracle 10g, TOAD, PL/SQL, Excel, WebShere, Tomcat, SharePoint, Windows and UNIX
Confidential, Plano, TX
Sr. Business Objects/ETL Consultant
Responsibilities:
- Responsible for business requirement analysis, functional and technical specification, architectural design, and implementation.
- Used Informatica Designer for developing mappings, using transformations, which includes aggregate, Update Strategy, lookup, Joiner and Router.
- Involved in the development of Data Mart and populating the data marts using Informatica.
- Created and Monitored Sessions and Batches using Informatica Work Flow Manager.
- Implemented performance tuning with the Transformations, Sessions and on the Source Databases to load the data efficiently in to the target.
- Responsible to run Informatica jobs in PROD, UAT and DEV environments for every standalone Periods and events.
- Designed Business Objects Universes for star schema data models.
- Created derived tables in Universe.
- Created/Administered users/user groups/Security in Supervisor/CMC.
- Created OMA WEBI and DESKI reports for to analyze the CMMI standards.
- Created DESKI reports for PMO’s.
- Handling the production CR’s.
- Ported the PPQA and OT Application onto MVC Model 2 Architecture in Struts Framework for Scalability & Performance QA.
- Developed the Java Server Pages for PPQA and OT teams using JSP, HTML, DHTML, CSS and Ajax.
- Generated XML documents from the data in the database. Used XSLT to render the XML documents on Client
- Extensively used JavaScript for client side validations and for capturing dynamic events.
- Deployed web components in the WebSphere Server.
- Provided reports direct access from PPAQ and OT applications using single sign on.
- Created the PPQA Compliance WEBI reports.
- Created WEBI reports for OT.
- Implemented single sing-on & security layer with row level restrictions.
- Implemented dynamic prompts and cascading list of values.
- Created alerts in the WEBI reports to get the Efficiency reports dynamically.
- Creation of different types of DESKI and WEBI reports, such as master/detail, cross tab and chart. Use of filters, conditions, calculations, etc.
- Customized business objects Web Intelligence, Universe, Desktop Intelligence with java SDK, webi SDK, Universe SDK and Desktop Intelligence SDK.
- Designed custom JSP pages and integrated with WEBI interface.
- Use of Analyzer and Explorer to view reports from different prospects (Slice and Dice, Drill down).
- Experience on Fixing Bugs.
- Created various dashboards to measure the project and organizational performance of CMMI standards using Xcelsius Designer.
- Created the stored procedures and views to get the data from OMA Data mart.
- Updated UNIX scripts according to the business requirements.
Environment: Business Objects XIr2, Crystal Xcelsius Designer4.5, QAAWS, Informatica Powercenter8.1, Web Intelligence, SAP BW, Control - M (Web), Starteam, Perigrean service center, Quality Center, BO SDK, WEDI SDK, RAS SDK, Java, J2EE, JSP, Servlets, Spring, Struts, Java Script, XML, MySQl,Oracle 10g, TOAD, PL/SQL, Excel, WebShere, Tomcat, Linux, Windows and UNIX
Confidential, DC
Sr. Business Objects SDK Consultant
Responsibilities:
- Actively participated in team meetings for business requirement analysis, functional and technical specification, architectural design, and implementation.
- Crating the SVG files in US Circuit level and District level using Inkscape and also customized the SVG files.
- Installed and configured Business Objects XI r2 using Web sphere as Application and Web Server.
- Deployed Business objects with IBM Web sphere for a Service Oriented Architecture.
- Created Universe connection with MySQL and Informix Data base.
- Design and creating the Universe objects with Java Script using SVG and JSP files.
- Involved in Gathering the requirements and Designing the Reports using Crystal Reports XI R2.
- Created various formulas for the calculations in the crystal reports.
- Defined Crystal reports with sub reports, link reports with drill drown functionality.
- Created Crystal Reports using Crystal Reports for Eclipse.
- Customized WEBI with WEBI SDK and integrated with java portal to get the complete functionality.
- Generated WEBI reports using Business Objects Web Intelligence to popup in Java Server pages.
- Created DESKI reports for US Circuit level.
- Writing the JSP pages to Display the SVG files in WEBI report, And also updating the SVG files using selected rages and color by the user from WEBI.
- Designed and implemented a Print appliance system. Extensively utilized RAS SDK for scheduling crystal reports and report printing with high performance.
- Created Color picker using Java Script and CSS to apply the colors to the map (SVG files).
- Designed and implemented to display the Legend on SVG files by using JSP. This Legend will display the selected ranges and selected colors.
- Written a servlets to improve the performance of SVG file while displaying in WEBI reports.
- Deploying and testing the JSP and Servlets.
- Designed and developed web interfaces and business logic using Jakarta Struts Framework (MVC architecture), J2EE, JSP, Servlets, Java Beans, JDBC, Java Script, HTML, DHTML and XML Technologies.
- Design and development of User Interfaces using JSP, (J2EE), XML, XSLT, HTML, DHTML and CSS.
- Testing of Reports according to the functional requirement and deploying over web.
- Modified Shell scripts to run the reports.
- Migrated application from MySQL to Informix database.
- Moved the application from Development environment to UAT environment.
- Conducted user training session on Mapping Solutions.
- Designs Xcelsius dash board for staffing reports.
Environment: Business Objects XIr2, Crystal Xcelsius Designer4.5, Crystal reports XI, Web Intelligence, Eclipse for Crystal reports, BO SDK, WEDI SDK, RAS SDK, Java, J2EE, JSP, Servlets, XML, MySQl, Informix, SQL, PL/SQL, Excel, Inkscape, WebSphere, Tomcat, SharePoint, Windows and Linux
Confidential
Software Engineer
Responsibilities
- Responsible for development of Technical design documentation for reporting system.
- Installation & Configuration of Business Objects XI/11 Enterprise Suite of Products.
- Imported data from Business Objects 6.5 & Crystal Enterprise to Business Objects Enterprise XI.
- Created linked and unlinked Sub Reports to create applicants experience/Qualifications reports.
- Published reports on the web using Crystal Enterprise 10.0 and Crystal reports 10.0.
- Extensively involved in creating Parameters and Record Selection Formulas to allow the users to filter the Data
- Extensively involved in writing various formulas for Calculations and combining the data.
- Involved in writing Custom Functions to be used in other Functions.
- Created formulas using Crystal and basic syntax.
- Installed and set the Central Management Server, Processing Servers & Report Application Server.
- Defined User Accounts, groups & set up administrator privileges
- Published Objects with the central management console.
- Implemented dynamic prompts and cascading list of values.
- Worked on Business views and Universes to Business Objects XI.
- Defined business objects standard can reports & ad-hoc reports.
- Implemented row level restrictions with supervisor for security purpose
- Scheduled crystal reports and Implemented dynamic cascading prompts.
- Mentored other IT staff & Conducted Corporate training for end users on Business Objects XI
- Implemented the architecture of the modules according to the J2EE standards. (Presentation-tier, Business-tier, Integration-tier).
- Developed the application Using Struts frame work and validations using Validation frame work.
- Extensively used JavaScript for client side validations and for capturing dynamic events.
- Design and Development of GUI using JSP’s , JSTL, Tiles, HTML, DHTML, CSS and JavaScript.
- Bug fixing and debugging the application.
- Deploying the application in Web Sphere application server.
- Customized business objects Web Intelligence, Universe, Desktop Intelligence with java SDK, webi SDK, Universe SDK and Desktop Intelligence SDK.
- Created Crystal Reports using Crystal Reports For Eclipse and Customizing the created reports according to the requirement using Enterprise SDK, RAS SDK and Viewers SDK.
Environment: Business Objects XIr2/XI/6.5, Crystal reports XI, Web Intelligence, BO SDK, WEDI SDK, Eclipse for Crystal Reports, Java2, J2EE 1.4, WebSphere5.1, Servlets, JSP, JDBC, Struts, Tiles, Validate Frame work, JSTL, JavaScript, HTML,DHTML,CSS, JDBC, Swings, XML, Oracle 10g, SQL, PL-SQL, Rational Rose (UML), Log4j, Clear Case, Datastage, UNIX, TOAD, and Windows.