Hi,
I am a Senior Business Intelligence Professional with extensive experience in Information Technology industry - involved in analysis, design, coding, testing,
implementation, maintenance and production support of mission critical Business Intelligence Reporting solutions
I am Willing to relocate anywhere in US.
My first preference is for Corp to Corp contract positions as i am on H1B visa.
Please get back to me with suitable positions, if you are interested in my resume.
Thanks,
Sanjeev
Resume
KANDURI SANJEEV
sanjeevvrk@gmail.com
Summary:
• A Senior Business Intelligence Professional with extensive experience in Information Technology industry - involved in analysis, design, coding, testing,
implementation, maintenance and production support of mission critical Business Intelligence Reporting solutions
• Expertise in 4.x/5.x/6.x/XI (Broadcast Agent, Designer, Supervisor, CMC, Info View, Web Intelligence, Business Objects Reporter, Desktop Intelligence and ZABO)
• Experienced in Business Objects Universe Design with fact tables, aggregate tables and dimension tables.
• Versatile experience in creating complex reports with multiple data providers, unions, sub-queries, complex date objects, alerts and database functions.
• Good experience in Business Objects Installation, Deployment and good exposure in Business Objects Administration
• Strong experience in migration of reports from Business Objects 6.5 to Business Objects XI R2.
• Experience in using Dashboard Manager for the better performance of Business Activities
• Experience in Designing/Developing the User-Interface, Developing Canned/Ad-hoc Reports, Scheduling and bursting the reports using Broadcast Agent/
Scheduler.
• Exposure to SDLC in Data warehouses and Business Data marts with Star Schemas and Snowflake Schemas.
• Extensive experience using various RDBMS such as Oracle 8i/9i/10g, MS SQL Server and good experience in writing complex queries in SQL, PL/SQL
• Good experience in writing UNIX Shell Scripts and TOAD
• Good working knowledge of creating reports using Crystal Reports XI
• Experienced in interacting with users and functional people for gathering the business requirements.
• Excellent analytical, communication and leadership skills that are required to effectively work in the field of applications development and maintenance.
Technical Skills:
Business Intelligence: BOXI R1/R2(Desktop Intelligence, CMC, Designer, Web Intelligence), Business Objects 4.x/5.x/6.x (Business Objects, Supervisor, Designer, Broadcast
Agent, Web Intelligence, ZABO),
RDBMS: Oracle 8i/9i/10g, MS Access, MS SQL Server
Web: HTML, XML, ASP, JSP, & VBScript
Languages: SQL, PL/SQL, C, Java and Visual Basic
GUI: VB 5.0/6.0, Developer 2000
Other: TOAD, ERWIN, SQL* Plus, Visio, MS Office, Test Director, Data Stage, Data Integrator
OS: UNIX, Windows 95/98/NT/2000/XP, MS DOS
Professional Experience:
Fannie Mae, Washington DC Mar '07 to till date
Business Objects Developer
Project: Independent Price Verification System
Description: Fannie Mae is one of the premier mortgage industry clients in US and has been serving the American home mortgage industry from decades. The Company charter limits operations to activities related to housing, mortgages and related financial products. The financial products primarily include whole loans, mortgage backed securities, liquid investments, structured mortgage instruments, derivatives, guaranty fees, and debt.
The purpose of the Project "Independent Price Verification System" is to document the business requirements to build a reporting system that processes on a regular time interval basis, the independent verification for certain financial instruments that are required to be measured at fair value in the Company's financial statements.
Responsibilities:
• Interacted with the end users and business analysts to identify and develop business requirements and transform them into technical requirements.
• Analyzed the existing database and designed the Universe using Business Objects Designer Module.
• Involved in developing table joins, alerts and queries, creating prompts, parsing of the Universes, applying contexts and alias tables to removes cyclic
dependencies.
• Involved in resolving the loops, checked the cardinalities and Integrity of the Universes
• Responsible for creation of various reports which includes weekly reports, bi-weekly reports, reports by Group, reports by Product and Sub-product
• Test/Debug Business Objects Universe enhancements/modifications in Designer to include new objects, updated tables, and joins
• Was responsible for database connections, SQL joins, cardinalities, loops, aliases, views, parsing of objects and hierarchies
• Publish reports to user community through Business Objects Web Intelligence interface
• Created Ad-hoc reports using Business Objects functionalities like Cross Tab, Master Detail, Slice & Dice and Drill Down, etc.
• Created reports with multiple data providers and formatted them as per the report requirements given by the business users
• Responsible for documentation of various stages in development including Design, debug, maintenance etc.
• Created report templates for easy creation of ad-hoc reports
• Developed different types of reports with features like Ranking, Filtering
Environment: Business Objects XI R2 (CMC, Designer, DeskI), WebI (Reporter, Info View), Java, MS SQL Server 2000 Analyzer, Weblogic 9.0, Oracle 9i, Windows 2003,
UNIX
Danaher Motion Inc, NY Sep '06 to Feb '07
Business Objects Consultant
Description: Danaher motion is a leading industrial company which designs, manufactures, markets innovative products, services and technologies with strong brand names and also has significant market positions. The main objective of the project is to develop a Finance Tracking system for Danaher Motion, Inc. The project includes developing of various reports such as Financial Overview Sales, Financial Overview Margin, Financial Overview Summary, Financial Overview Average Store, and Financial Overview Inventory. These reports give complete information about the performance of the company over particular period of time.
Responsibilities:
• Involved in Full life cycle design and development of Business Objects reporting Applications.
• Use of Designer Module to implement Universes, joining between tables, creating prompts, Alerts and queries, parsing the Universes, applying contexts and alias
tables to remove cyclic dependencies
• Involved in creation of reports like, Reports by Group/Product/Sub product, Reports per Sales, Reports by Period and Bi-weekly reports
• Created database connections, SQL joins, cardinalities, loops, aliases, views, parsing of objects and hierarchies
• Involved in performance tuning of report execution in business objects.
• Test/Debug Business Objects Universe enhancements/modifications in Designer to include new objects, updated tables, and joins
• Used Business Objects Web Intelligence interface for Publishing reports to user community
• Conducted periodic user training for business users on slicing and dicing of power cubes, drill down techniques for extensive usage of the reports.
• Participated in Report Detail Design documentation review/analysis/modification.
• Responsible for Ad-hoc reports using Cross Tab, Master Detail, slice & dice and Formulas, etc.
• Updated the Universe as per the changes of the Database table structure and notified the users about changes made to the Universe.
• Checked Universes for Integrity and exported them to the Repository to make resources available to the users.
• Exported reports to different formats (Excel, PDF, word) based on the user requirements
Environment: Business Objects XI R2 (CMC, Designer, DeskI), WebI (Reporter, Info View), Java, Weblogic 9.0, Oracle 10g, Windows 2003, UNIX
INTTRA, NJ Feb '06 to Aug '06
Business Objects Analyst
INTTRA is a leading global provider of e-commerce solutions to ocean carriers and their customers. INTTRA works with customers to streamline and standardize their shipping processes. INTTRA specialize in applying their e-commerce knowledge of the shipping industry for the customers in local markets around the world.
Responsibilities:
• Developed reports for daily, weekly and monthly usages of the booking and shipping instruction products in the INTTRA portal.
• Developed new reports to view sailing schedules for all carriers at a given specific time.
• Performed system study and Interacted with the Business users and business analysts to identify and develop business requirements and transform them into
technical requirements.
• Involved in Migrating Reports, Universes from version 6.5 to Business Objects XI R2
• Resolved the loops and tested the designed universe in Business Objects Designer.
• Used Sql*plus commands to generate business objects reports using free hand sql as a data Provider.
• Extensively worked on formatting of the reports and developed the multidimensional reports in Business Objects by translating the business validations.
• Involved in various data marts from data warehouse and generated reports using Business Objects.
• Involved in performance Management by using Dashboard Manager in business objects.
• Performed Unit testing of the Designer and reports.
• Used SQL tool TOAD to run PL/SQL & SQL queries and validate the data pulled in reports.
• Extensive use of SQL, PL/SQL for Adhoc Reporting to validate the requirements and the functionalities
• Performed System Testing - Created Test Cases in Test Director, Tested the reports, logged in the Defects
• Used drill-down analysis in Business Objects, which will allow the users to view data at a more detail level.
• Evaluated, proposed and gave a demo on using Crystal reports XI as a platform for new developments in reporting for other support applications
Environment: Business Objects 6.5/XI R2, Web Intelligence, Designer, Supervisor, CMC, Broadcast Agent, Dashboard Manager, PL/SQL, Crystal reports XI, UNIX, SQL*Plus,
Oracle 9i, SQL Server 2000, PLSQL, TOAD, Windows NT
Lincoln Financial Group, Hartford, CT Dec '04 to Jan '06 Business Objects Analyst
Description: LFG has identified the need to report on assets under management and sales information Preferred Partner Program. The concept of this project is to quickly provide several initial reports to a small subset of users in an easily readable and manageable fashion via Business Objects.
Responsibilities
• Involved in requirements gathering from the business users to build the reporting application
• Analyzed the existing database and designed the Universes using Business Objects Designer Module.
• Created Universe, Classes, Objects, Measure Objects, Conditions and Joins.
• Involved in resolving the loops, using contexts and checked the cardinalities, Integrity of the Universes
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, Cross Tab, Master/Detail and Formulas etc.
• Developed complex queries using different data providers in the same report.
• Exported the Business Objects reports to WEBI to be viewed by all users on the intranet.
• Designed the layout for various Reports in Business Object and Integration of reports and involved in Coding, Reviewing, Formatting, Testing, Bug fixing &
Integration with different classes.
• Created and published reports through Web Intelligence.
• Distributing Documents inside and outside of the business using Broadcast Agent server (BCA) and administration for scheduling the Reports (like rep, pdf, excel
and html format). Exported the Universe/Reports to the Repository.
• Worked with supervisor module in creating users and users groups for different areas and setting privileges to them.
• Checked Universes for Integrity and exported them to the Repository to make resources available to the users.
• Created standard templates for future Ad-hoc reporting needs and Trained users on ad-hoc reporting.
Environment: Business Objects 6.5, Web Intelligence, Designer, Supervisor, Broadcast Agent, Oracle 8i/9i, SQL Server 2000, PL/SQL, Windows NT, UNIX
Alaris Medical Systems, San Diego, CA Oct '03 to Nov '04
Business Objects Developer
Description:
Alaris Medical Systems is a surgical and medical instruments manufacturing company. It is a world leader in intravenous drug delivery systems. The main motto of the company is "Medication Safety and the point of care".
Designed and Developed Universes for the Alaris data warehouse project. This project mainly focuses on the financial aspects. There are different modules like Accounts Payables, Accounts Receivables, Inventory, Fixed Assets, Purchase Orders, Order Entry, and General Ledger as per sales rep and agents associated with Alaris.
Responsibilities:
• Involved in various data marts from data warehouse and generated reports using Business Objects.
• Participate in report Detail Design documentation review/analysis/modification
• Did User Requirement Gathering and documented the same in Business Requirement Document
• Created Users and Users Groups and assigned profile to Users using Supervisor.
• Use of Designer Module to implement Universes on Financial Systems, linkages between tables, creating prompts and queries, parsing the Universes, applying
contexts and alias tables to remove cyclic dependencies
• Test/Debug Business Objects Universe enhancements/modifications in Designer to include new objects, updated tables, and joins
• Generated various reports like Accounts Receivable, Accounts Payable, Inventory, Fixed Assets, and Purchase Orders
• Created Ad-hoc reports using Business Objects functionalities like Cross Tab, Master Detail and Formulas, Alerts, Slice and Dice, Drill Down, @Functions, etc.
• Up gradation of reports from Business Objects 5.x to Business Objects 6.x
• Developed different types of reports with features like Ranking, Filtering.
• Used drill-down and slice and dice analysis in Business Objects, which will allow the user to view data at a more detail level.
• Published the Business Objects reports to WebI.
Environment: Business Objects 5.x/6.5.1(Supervisor, Designer, Business Objects), Broadcast Agent Publisher, WebI 2.7/6.5.2(Reporter, Info View), Java, Visual Basic,
Oracle 9i, UNIX, Windows 2000.
Genworth Financials, Stamford, CT Oct '02 to Sept '03 Business Objects Consultant
Description:
Commercial Real Estate (CRE) Business needs Loan Origination and Loan servicing data to perform their day-to-day business functions. It was imperative for the business to have timely, accurate, easy and flexible access to the Origination and servicing data for reporting and analytical purposes. Further, the various Commercial Real Estate systems, other Genworth internal systems and external vendor systems have data needs to support the business functions.
Responsibilities:
• Designed CRE Universe for Ad-hoc Reports for the Loan Origination Users (Mortgage Bankers, Producers, Risk and Closing Departments) and also generated
complex reports for them.
• Worked very closely with users, when designing the Universe for naming the objects and placing the objects
• Created canned reports for Servicing, Allocations, Accounting and Compliance departments, and scheduled through BCA.
• Generated pictorial views in the form of 2D, 3D and Pie Charts from existing Reports and Chart Wizard.
• Used Free Hand SQL for creating complex Reports
• Created Users and Groups. Managed users like resetting password, assigning privileges, enabling their ID's & managed Groups.
• Created Multiple Universe and document Domains.
• Created Complex Condition Objects, Complex prompts, and Nested prompts for easy reporting.
• Customized Infoview Home Page to access reports easier and faster.
• Interacted with the Quality team to create test cases.
• Exported reports to different formats (Excel, PDF, word) based on the user requirements
Environment: Business Objects 5.x, Broad Cast Agent, WEBI 2.x/6.5,Oracle 9i, SQL Server 2000, Windows 2000/NT
Solix, India April '01 to Aug '02
OLAP Developer
Description:
SOLIX is a public utility company. The Data warehouse was built to maintain material management Systems and managing data processing activities and system development pertaining to energy and fuel. This company has business centers across multiple locations and opts for standard Business Management. The report generation for different plans and rates as per the user requirements and business analysis will be shared online. Which can be worked as online transaction for the different location, the developed Business Objects reports will be scheduled to run at different times as per the business requirement in Broadcast Agent Server.
Responsibilities:
• Worked extensively in planning and developing technical and functional specifications.
• Designed and prepared Documentation for developer team.
• Extensively worked on designing and developing universes for reporting generation from different database.
• Worked with supervisor module in creating users and users groups for different areas and setting privileges to them.
• Generated the BO Reports using the universes as the main Data providers and writing the complex queries including Sub queries, Unions, Intersect and Aliases.
• Involved in creating complex reports in Drill mode and helped business users to analyze reports.
• Involved in the creating the reports on the web using the Business Objects 4.5, Web Intelligence 2.6 from the online Internet database and migrated from third
party database.
• Created several different types of reports inclusive of Master/Detail, Cross Tab with filters, conditions, calculations and new objects to support users'
requirements.
• Making the user resources more flexible as per the business requirements by exporting Universes and BO reports.
• Involved in setting, scheduling and running the Business Objects reports by using the Broadcast agent server.
• Exported reports to different formats (Excel, PDF, word) based on the user requirements
Environment: Business Objects 4.5, Designer, Supervisor, Broadcast Agent Server, Web Intelligence 2.6, Oracle 8i, SQL Server 2000 and Win NT.