Technical summary
8 Years of experience in Business Objects XI R3/R2, 6.5, Web Intelligence, Desktop Intelligence, Universe Designer, Central Management Console, Crystal Reports 2008, XI R2/R1, Crystal Xcelsius 2008, 5.3/4.5 (QAAWS, Live Office), Qlikview, Oracle, SQL Server2000/2005, DB2, SAP BW, R/3 and Access. Extensive experience in Creating Standard, Cross Tab, Drill Down, Sub Reports, Label Reports, Chart Reports using reporting tool. Excellent data-analysis skills and ability to translate specifications into a working Universe and Report. Administration experience using Central Management Console (Creating users, Groups, setting securities and migrating content and structure from the BIAR files using IMPORT wizard). Strong experience working with SQL programming including Stored Procedures, Partitions and Packages. Worked with Business Analysts and End users to document report requirements and translate those to functional designs. Created Design Specification documents for the reports. Experience using Command and Stored Procedures for the complex reports. Created Report Templates for developing reports faster. Experience performing Unit Testing and Performance Testing for the reports. Experienced in Data Warehouse Concepts and Methodologies. Experience using Query Analyzer, SQL Developer, TOAD for Oracle, Squirrel for DB2 interface tools. Experience in Migrating projects from Xcelsius 4.5 to 2008. Experienced in developing Xcelsius dashboards for key performance indicators and scorecards. Involved in publishing Xcelsius dashboards to WEB and PDF Experience in different Business verticals like Healthcare, Financial and Retail industries. Ability to work with client to identify data sources and their availability, data extraction, processing, program construction, and testing skills, proficient with multiple extraction, transformation and load tools. Experience interacting with End Users and Customers to gathering requirements. Knowledge in using Star Schema and Snow Flake Schema Data Models. Proficient in administering Job Scheduler using Cron, Autosys on UNIX machines. An intelligent and responsible software developer, fast learner, good technical abilities and skills developed by a strong work ethic and self-learning. Ability to work Independently and also as a Team Technical Expertise:
Tools : Business Objects 6.5, XI R3/R2, Crystal Repots 2008, XI R2/R1
Databases : Oracle 10g/ 9.x/ 8i/ 7.x, SQL Server 6.5/7.0, DB2 UDB
8. x/7.x, Teradata V2R6 /V2R4, Teradata Utilities T-Pump, Fast load, Multi Load, BTEQ, DB2, MYSQL
Languages: SQL, PL-SQL, Java, C, C++, C#
Operating System : Windows XP/Server 2003/NT/2000, DOS, UNIX, Linux, SOLARIS
Education : Bachelor\'s Degree
Professional Experience:
Confidential,HERNDON, VIRGINIA Oct 2009 – Present
Business Objects Developer
Confidential,is a leading provider of nationwide medical data abstraction, analysis, and verification solutions for the U.S. healthcare industry. MedAssurant was originated in 1998 and headquartered outside of Washington, D.C. in Annapolis, Maryland.
Responsibilities:
Created complex reports and company standard for the reporting needs. Created pilot Universe and developed reports in Web Intelligence. Worked on Business Objects 4.0. Gathered requirements from business users and translated those into technical specifications. Involved in a multiple projects and met all the deadlines. Created Claims, patient adjustment and doctor’s revenue reports using Web Intelligence reports. Used complex formulae in all reports to calculate mathematical figure in reports. Created Prompts, Conditions and Filters to improve the Report generation. Also used Alerts to improve the readability of the Report. Extensively used Breaks and Sections for better navigation purpose. Created Derived Tables for Universe design to meet specific results in WebI. Business Objects XIR3 Installation and Configuration. Administered Users, Groups and reports using Central Management Console. Involved in Migration of BO from XI R2 to XI R3 using Import Wizard. Used Share point for reports deployment and to share the reports. Created Cross Tab, Sub Reports, Chart and standard reports using Web Intelligence and Crystal Reports. Created parameters, formulae on records and groups in Crystal reports. Created Xcelsius dashboards using Microsoft Excel file as Data Source. Migrated Xcelsius dashboards from Version 4.5 to 2008. Used row level security to secure the data, based on user access. Created formulae and formatted cells in the Microsoft Excel files to feed the dashboards. Created and scheduled jobs in SQL Server Agent to run the stored procedures. Extensively performed Manual testing process to ensure the quality of the software and Involved in Build verification testing to meet the business rules. Fixed bugs/issues found in UAT/Prod Environments while testing. Created brand new reports using Views and Stored procedures. Scheduled reports to run daily, weekly & Monthly on Enterprise. Migrated Views and Reports from MySQL database to SQL Server 2005 database. Worked closely with the Database Administrator to create and update the fields necessary in the Crystal reports and build new schemas. Environment: Business Objects XI R3, Xcelsius 2008, Crystal Reports 2008/XIR2, SQL, Views, Stored Procedures, SQL Server2005, MySQL.
Confidential,TX Sep 2007 – Aug 2009
Business Objects Developer
Confidential,is the nation\'s leading healthcare services company. McKesson vision is to help create a healthcare system where quality is higher, mistakes are fewer and costs are lower. As the nation\'s leading healthcare services company, they provide pharmaceuticals, medical supplies and technologies that make healthcare safer while reducing costs. McKesson touches virtually every aspect of healthcare. It is the largest pharmaceutical distributor in North America. Every day they distribute one-third of the medicines used in North America, supplying more than 25,000 U.S. healthcare locations from Wal-Mart to the Department of Veterans Affairs to community pharmacies.
Responsibilities:
Creating new reports in BO from existing crystal reports version10. Analysis of business problems and planning the Universe solution, Designing the Schema, Building the Universe and distributing the Universe to users. Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved. Generated reports from multiple databases in Web Intelligence. Worked with Web Intelligence Rich Client. Created Hyperlinks and Dashboards to Drill Down for Detailed Analysis Reports. Designed Universes using different Data Sources. Performed integrity testing of the Universes (Universe Structure checking, Object parsing, Joins parsing, Conditions parsing, Cardinalities checking, Loops checking and Contexts checking) after any modifications to them in terms of Structure, Classes and Objects. Implemented Web Intelligence Reporting on Universes and developed Ad-hoc/Complex Reports. Exported the universe to the Repository to make resources available to the users. Created Universe on Oracle for Power Procurement Business Unit and Teradata for Smart Connect project per user requirement. Involved in Migration of BO from XI R2 to XI R3. Supported the application by solving the trouble tickets, which was created by the users. Monitored and solved the issues encountered in Universes and reports while migration and tested before moving to production. Coordinated with Business Objects Deployment and documented the entire project. Involved in production support role 24/7 to resolve the issues. Involved in installing Business Objects, creating Repository, Users, User Groups and prioritizing Security Levels for Users and User Groups. Used Microsoft Excel in Xcelsius. Involved in testing functionality to ensure all features have been migrated successfully. Environment: Business Objects XI R2/R3 (Administrator, Designer, Desktop Intelligence, Web Intelligence, CMC & Info View), SQL, PL/SQL, TOAD, Oracle 10g, Teradata, Xcelsius and Windows 2003.
Confidential,MN June 2005 to Aug 2007
Report Developer
Law Financial Services
Confidential, is an international provider of food, agricultural and risk management products and services. With 153,000 employees in 66 countries, the company is committed to using its knowledge and experience to collaborate with customers to help them succeed.
Responsibilities:
Created Universe using designer. Created Ad-Hoc and On–Demand reports for the Users. Used Dashboard Manager and performance Manager for some reports. Extensively implemented @functions like @prompt, @select, and @where to increase user flexibility and ensure integrity of universe design. Implemented Cardinality settings, Joins and Global Filters in Universe. Built Powerful Queries by creating and applying complex conditions and sorts, User Objects, LOV’s, Combined Queries, Free Hand SQL and Semantically dynamic calculations. Extensively used Web Intelligence through Info view interface to generate reports. Created Cross Tab reports and chart report using Web Intelligence. Combined multiple reports into a single report in Web Intelligence. Performed Unit Testing for the reports before sending them to UAT Created charts and chart drill down options in Xcelsius. Used Live Office to pull data from existing reports. Created highly formatted reports to visually represent data. Used row level security to secure the data, based on user access. Did enhancements to the existing dashboards in both Business Objects and Xcelsius to fulfill the requirements. Modified combination charts, Icons and map components in the dashboards. Interacted frequently with the accountant and global controller for the dashboard fixes and enhancements. Environment: Business Objects XIR2, PL/SQL, Views, Stored Procedures, SQL Server2005, SAP BW, R/3, Xcelsius, Live Office, MS Excel, MS Access.
Confidential,India Jun 2004 – Apr 2005
Oracle Developer
Responsibilities:
Actively involved in the full Software Development Life Cycle (SDLC) of the application Developed number of Java classes to be used as the interface, accessing the back end database through ODBC Involved in Application Development, Implementation and Production Support Performed database design, analysis and development including referential integrity constraints and triggers to avoid duplication Defined and composed primary and foreign keys in the Database Normalization Process and developed procedures to provide additional authentication Generated reports from SQL* Plus and Oracle Reports for Marketing and Management staff. Worked on optimizing and tuning SQL and PL/SQL code Environment: Oracle 7.x, Forms 4.5, Reports 2.5, PL/SQL, SQL* PLUS, SQL *Loader, UNIX, HTML, and Windows NT/2000, SQL Server 2000, Crystal Reports.
Privacy Policy
