SUMMARY

• 12+ years of total professional IT experience in years with a thorough understanding of SDLC methodology.
• 7 + years of Business Intelligence (Business Objects/Crystal Reports and data warehouse) planning, engineering, and development expertise delivering best in class reporting solutions and actionable insights for CARGIL, Confidential, Confidential Wireless, Confidential Data Services & BlueShield of CA. Architected, designed, built, implemented and managed warehouses with >20TB of data, 3MM +customers and 2k users..
• Defined and outlined the BI Reporting strategic planning including roadmap, context diagrams, and process maps. Presented findings to the BI Executive Board (company Presidents / Vice Presidents) .
• Creative problem solver/engineer that excels in conceptualizing, analysis, and rapid development of Pre - sales, Proof of Concepts, and prototyping of industry and company specific data/information solutions.
• Working / reporting directly to / with the CIO, CFO, and Director of Operations, initiated, conceptualized, personally developed, and customized an EIS / Dashboard program / approach for President level reporting.
• Expertise in implementation, migration, security management and administrating Business Objects 4.0/BO XI R 3.1/R2.
• Integration /Publishing of reports in Client/Server Technologies and E-Commerce Applications for Supply Chain WMS, Financial, Pharma Inventory, Insurance, Banking, and Production systems.
• Broad industry familiarity with implementation experience of popular BI packages such as Business Objects, SAS, Crystal Reports, OBIEE, SAP HANA or other BI tools.
• Strong understanding of relational databases with hands on experience in SQL programming.
• Solid understanding of Data Warehouse methodology, dimensional modeling including Ralph Kimball's methodology.
• Capacity to use data to tell a compelling story, has ability to quickly translate requirements to prototype and get business buy- in.
• Self motivated with strong leadership and presence. Possess critical thinking, problem solving, interpersonal and collaborative skills, and decision-making skills.
• Expertise of implementing Business Objects, OBIEE solutions in one or multiple areas such as Health Care/Sales/Finance/Marketing/HR/Services.
• Experienced and strong understanding of process in one or more business areas such as Finance, Sales, HR & Marketing.
• Expertise in designing, developing Universes and hands on optimizing of Universes such as resolving loops and creating context.
• Strong database development and query knowledge including proficiency in SQL coding across standard relational environment (e.g., Oracle, Teradata, etc.). Expertise in writing and implementation of the SQL, PL/SQL Packages, SSIS, SSRS reporting, Triggers, Stored Procedures, Functions, views, Materialized Views and indexes at Database level.
• In-depth expertise in RDBMS tools ORACLE 10g/9.2/8.x/7.x, SQL Server 2000/2005 and application development tools VB.net, Visual Basic, HTML, etc.

TECHNICAL SKILLS

OLAP: Business Objects 4.0/ XI R 3.1/XI R 2/6.5.1/6.1/5 x

Reporting Tools: Crystal Reports 2008/XI R2/10/9.0/8.5, Xcelsious Engage 2008

ETL: Informatica, MS-DTS

Data Modeling Tools: ER-Win

Operating Systems: Windows 2003/2000/XP/NT/98/95, UNIX (Sun Solaris 10/9)

RDBMS/Databases: Oracle 11g/10g, SQL Server 2008/2005/2000 , MS Access

Appliances: SAP HANA, Teradata

GUI Tools: Visual Basic 6.0/5.0, Visual Studio .Net 2008 (Vb.Net,ASP.Net)TOAD,SQL Tool

Version Control Tools: Visual Source Safe, PVCS, Subversion, BO LCM, Tortoise

Applications/Web Servers: IIS-6/5, Tomcat, Web Logic, FACETS 4.8.1\4.6.1Tidal Batch Scheduler

Web Technologies: HTML, Java Script, ASP.Net

Packages /PM Tools: MS-Office 2007/2000/97 (MS Excel, MS-Word)Visio, Microsoft Project

Defect Tracking: MERANT, JIRA

PROFESSIONAL EXPERIENCE

Confidential - San Francisco, CA

SR Business Intelligence Lead

Responsibilities:

• Worked with the business analyst team to interview the business users and capture simple, moderate and complex business requirements.
• Collaborated with business technicians to research existing business and system processes.
• Responsible for analyzing business requirements and developing queries and reports using BO full client and info view to provide Web-enabled data analysis solutions to business clients.
• Developed POC project in SAP HANA Platform, Created Info spaces, Analytical, attribute& calculation views.
• Evaluated various BI tools such as Tableau, Qlikview & SAP VI.
• Hands on experience in On Site - OFF Shore development model. Handled projects as On Site lead.
• Implement security policies with Object Centric access restriction.
• Developed 121 complex and medium reports (such as Commissions, Account receivable, Clear Check, Provider & Member ship reports) against FACETS 4.6.1 /4.8.1 data source.
• Designed and developed 22 universes against HPXR Star Schema data model and Facets data model.
• Provided expert advice and education in the usage and interpretation of business data
• Communicated data nuances and insights to all levels of the company in a clear and concise manner, provided leadership in defining business-critical metrics and analyses that drives the business forward.
• Developed analytic standards for measuring performance within the business unit, leading teams to consensus around analytic approaches and development of reporting priorities across key initiatives. Ensured a consistent and efficient set of information and metrics permeates all levels of the supported business unit across the enterprise
• Instilled best practices using Business Intelligence tools and philosophies from front-line employee to executive leadership. Ensured that the Business Intelligence architecture evolves for continued fact-based decision making and sophisticated ad hoc capabilities.
• Monitored and managed requests from the business, Ability to query data requested by business users. Presented data that is easy to understand with proper documentation for successful user adoption
• Expertise in designing complex Crystal Reports using repository functions, formulae and arrays.
• Designed reports to support multi export formats such as exporting to pdf, Excel and Word without losing format of fields.
• Create, Design & maintain Universes. Optimize universes by creating contexts, views, resolving loops, fan traps and chasm traps. Create derived and aggregate tables, joins and set cardinalities for various universes.
• Configure & fine tune Web Intelligence Server, CMS.
• Created different types of reports like Master/Detail, Cross Tab and Chart Using WEBI XI and Crystal Reports XI. Used Slice and Dice and Drill down. As a part of report development created the reports using universes as a main data provider and using the Powerful business objects functionality's like @ functions, user response and formulae's.
• Used Prompts in the reports as well as the Universe to create more interactive reports for the users.
• Created complex reports using cascading prompts, decode objects and etc.

Environment: Business Objects 4.0/XI R 3.1, Crystal Reports 2008, SAS EG 4.3, SAP HANA,ORACLE 11g, Windows 2003 Server, FACETS 4.8.1/4.6.1 , Teradata 12, Merant, Subversion.

Confidential, Irving, TX

Business Objects Lead

Responsibilities:

• Worked with the business analyst team to interview the business users and capture simple, moderate and complex business requirements.
• Collaborated with business technicians to research existing business and system processes.
• Responsible for analyzing business requirements and developing queries and reports using BO full client and info view to provide Web-enabled data analysis solutions to business clients.
• Installed & configure BO XI 3.1 Enterprise Premium edition on Windows 2003 server.
• Configured IIS 6 according with BOXI R3.1/XI R2 Application Server in ASP .net Framework.
• Implement security policies with Object Centric access restriction. Implement data segregation policies.
• Upgrade and migrate BO XI R2 to BO XI R3.1 using Import Wizard. Configure & fine tune Web Intelligence Server, CMS.
• Set up single sign on authentication (SSO) using LDAP, Windows AD authentication for Business Objects users.
• Create, Design & maintain Universes. Optimize universes by creating contexts, views, resolving loops, fan traps and chasm traps. Create derived and aggregate tables, joins and set cardinalities for various universes.
• Create user groups, server groups, report folders, universe folders, calendars, events and categories using CMC.
• Created different types of reports like Master/Detail, Cross Tab and Chart Using WEBI XI and Crystal Reports XI. Used Slice and Dice and Drill down. As a part of report development created the reports using universes as a main data provider and using the Powerful business objects functionality's like @ functions, user response and formulae's.
• Used Prompts in reports to create more interactive reports for the Users.
• Used Prompts in the reports as well as the Universe to create more interactive reports for the users.
• Created complex reports using cascading prompts, decode objects and etc.
• Created Metadata Universe & custom view on CMS Data Base for Audit reports such as Failure, Daily run Reports and Success Fully run reports.
• Developed Custom Search engine for reports schedule to destination (email or unmanaged or ftp) with report name or recipient name using Business Objects SDK. Configured/customized Infoview for user friendly look.

Environment: Bo XI R3.1/R2, Crystal Reports 2008/XI/10, Web I, WIN 2003, Clear Case

Confidential - Walnut Creek, CA

Business Objects Lead Administrator /Developer

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Installation and configuration of XI R2 (CMC, CCM, Info View) using IIS 6 application server on Windows 2003 platform.
• Design and develop Crystal Reports using the cross-tab, sub-reports, charts and Top N reports for highlighting significant data, summary reports with drill-down capabilities.
• Design various charts and graphs such as bar chart (side by side, stacked), line graphs, pie -charts etc by using Chart Expert of Crystal Reports.
• Design Crystal Reports using Dynamic Parameters, LOV and Business Views.
• Expertise in designing complex Crystal Reports using repository functions, formulae and arrays.
• Designed reports to support multi export formats such as exporting to pdf, Excel and Word without losing format of fields.
• Develop standalone dash boards using Xcelsius exporting to .pdf via Live Office and QAWS using panel containers, accordion menu and tab set components.
• Created what-if reports/dash boards using Slider component.
• Created dash boards with dynamic visibility.
• Created management reports, audit summaries and KPI statement reports using Xcelsius.
• Upgrade and migrate BO XI R2 using Import Wizard and also from Crystal Enterprise 10 to BOXI R2.
• Set up single sign on authentication (SSO) using LDAP, Windows AD authentication for Business Objects users.
• Develop custom search engine with capability to search scheduled reports by report name or recipient name using Business Objects SDK. Develop custom Info-view using BOXI R2 .Net SDK. Develop multi reporting bursting manager using .Net SDK.
• Implementation of BO XI R2 in cluster environment. Implementation of disaster recovery process.
• Configured BOXI R2 and Crystal Reports for Java bean based data sources or Java Bean based reports. Wrote scripts to debug or trouble shoot RMI connection issues /Java Bean report issues.
• Create user groups, server groups, report folders, universe folders, calendars, events and categories using CMC.
• Implement and practice data security and Business Objects security disciplines.
• Developed complex ETL (Extract/Transform/Load) procedures using PL/SQL packages, stored procedures, views and cursors.
• Design and develop auditor views from CMS audit tables to track failed and daily ran reports.

Environment: Bo XI R3.1/R2, Crystal Reports 2008/XI/10, Web I, Xcelsius Engage 2008, Windows- 2003,Business Objects 6.5, Oracle 10g/9i, Db2, Remedy 6.0, SQL Tool 4.0, ASP, IIS 6, Visual Source Safe, Java Script, VERITAS Storage Replicator, BO LCM, Sub Version (Tortoise SVN), JDK 1.5(J2EE), HTML, CSP, VM Ware ESX, Live Office, MS Excel 2003

Confidential - Walnut Creek, CA

BO XI / Crystal Enterprise Administrator /Report Developer

Responsibilities:

• Worked with the business analyst team to interview the business users and capture simple, moderate and complex business requirements.
• Installation and administration of BO XI R2. Upgrade and migrate BO 6.5 to BO XI R2. Upgrade and migrate Crystal Enterprise 10 to BO XI R2.
• Design and develop complex financial and marketing reports using cross tab, charts, sub-reports, custom repository functions and complex formulae using Crystal Reports 10
• A responsibility also includes integration of data quality tools Melissa Data with Crystal Reports development and maintaining financial systems Mas-90/ Mas-200.
• Used stored procedures and views for accurate data representation in reports. Designed Ad-Hoc and Drill Down Crystal Reports as per requirement in design.
• Create custom Crystal Reports repository common functions. Design reports using Business Views and LOV .
• Develop custom eportfolio using Crystal Enterprise / BO XI R2 SDK in .net frame work.
• Develop custom scheduler to burst published report using BO XI R2/ Crystal Enterprise SDK.
• Develop custom audit page to tack user access, failure and daily ran reports using SDK.
• Created various types of reports of type standard, cross tab, drill down, sub reports, form type, letter and label type etc using Crystal Reports.
• Designed and analyzed reports using Crystal Report reporting tool.
• Regularly synchronized the QA and development environments with production reports.
• Deployment of reports in BO Enterprise Server and provide solutions to distribute reports to corporate executives and other key members of decision making teams via email, ftp and un-managed disk using CMC.
• Extensively used CCM and CMC for Business Objects Server management. Expanded BO environment by adding new CMS as cluster members to existing CMS.
• Provided security in the universe by updating the SQL to recognize and authenticate the BO user while querying.
• Implement security features of Business Objects like objects level, folder level and report level to make the data secure. Provide the security access management by creating users/groups.
• Analyzed existing database and created universe. Detected cardinalities and checked for integrity of universes. Optimized universes by creating context, views and resolving loops.
• Implement Active - Active CMS DB replication and file repository replication using VERITAS Storage Replicator for file system back up.
• Develop DTS package, stored procedure and cursors using T-SQL in SQL Server 2000.

Environment: BO XI R2/ Crystal Enterprise 10/9.0, Windows 2003/ XP, IIS 6/5, SQL Server 2000, Mas-200/90

Confidential - Minneapolis, MN

Crystal Enterprise Administrator/ Data Intelligence Support

Responsibilities:

• Involved in migration of MyEureka Reports to Crystal Reports 10.
• Headed and helped the decision making team to finalize the Crystal products after analyzing their MyEureka reports.
• Played key role in developing, implementing and demonstrating the successful pilot project using Crystal.
• Designed and analyzed reports using Crystal Reports reporting tool.
• Designed custom reports, setting up parameters, sub-reports, and drilldown reports, using Crystal Reports.
• Installation and administration of Crystal Enterprise.
• Set up NT authentication as well as Enterprise authentication for all users.
• Installed and configured Crystal Enterprise server in cluster environment.
• Designed and implemented ad-hoc reports, extracting data from an Oracle database.
• Implemented Crystal Enterprise development environment by installing Crystal Enterprise on IIS 5.0 web server.
• Performed technical analysis and design of platform and user interface.
• Deployed and tested the Crystal Reports on Crystal Enterprise-10 environment.
• Created several complex cross tab reports using Crystal Reports.
• Designed financial reports using Crystal Reports with Oracle 9.i.
• Designed Crystal Reports using formatting function in files.
• Installed report application server and upgraded RAS reporting environment to Crystal Enterprise.
• Designed and modified the database tables and wrote complex SQL queries, stored procedures, triggers and data modeling in Oracle 9.i and Teradata.
• Involved in integration with Visual Basic -6.

Environment: Win 2000, Windows XP, Crystal Reports 10.0; Crystal Enterprise 10.0, Crystal RAS, Crystal Reports Designer, Oracle 9i, Oracle 9i, My Eureka Reports and Vb-6

Confidential - Ann Arbor, MI

T- SQL Programmer/Application Developer /Report Developer

Responsibilities:

• Involved in software requirement analysis and design.
• Designed the schema MS-SQL Server 2000.
• Involved in SQL Server administration, database back-up, installing and configuring and managing databases.
• Involved in Forecast Management Engine development, Report / Filter Engine development and GUI design.
• Designed Crystal Reports using stored procedure and views. Used sub reports and formulae for accurate data representation in reports. Used Crystal Reports formula editor for writing formulae as per requirement in design.
• Designed and developed reports using cross tab, mail label and charts.
• Developed and customized the base canned reports like direct, group summary and performance rating distribution for the compensation planning module.
• Integrated and published the reports with Crystal Enterprise, RAS and ASP. Net.
• Dynamic, multiple selection and sort-based reports are developed by using Crystal Reports 10.
• Produced discrete, multi and range parameter based reports and formula based group reports.
• Integrated and mapped the similar reports with different data sources and databases.
• Depend upon the requirement and functionality sub reports and on-demand sub reports were created for compensation planner application module.
• Wrote data base connection classes, transactions classes for update, delete and insertion.
• Wrote store procedures, triggers and user defined functions.
• Used MS Data Grid control for displaying transaction history of web form. Also used pagination and grid events. Used ADO.Net for database transactions.
• Used XML adapter to import and export data from XML documents.
• Designed and developed web forms using ASP.Net on VS.Net IDE and used nUnit framework for unit testing and automated testing using Win Runner as per requirement.
• Used .Net Inter-Op features in development of reporting and filter engine.
• Wrote client side functions in JavaScript.
• Developed result set export function to various formats such as Excel, Word, etc.

Environment: VB. Net, Asp. Net, MS-SQL Server 2000, XML, Windows 2003 Server, Crystal Reports 10, Crystal Enterprise 10.0/9.0, IIS 6, Visual Source Safe, Java Script

Confidential, NC

Application Developer / Report Developer

Responsibilities:

• Involved in user requirement analysis and system design.
• Designed and developed web forms (for Web Top Application), win forms (Client /Server Data Processing Module) as per requirement using VB. Net, implemented MS data grid control for displaying respected data before and after each transaction done in corresponding page and also provided paging and other data grid events.
• Production and managerial reports were designed and developed using Crystal Reports features like sub-reports, formulae and various report templates.
• Designed graphical reports using Crystal Reports chart feature. Designed customized report templates.
• Integrated Crystal Reports with VB.Net.
• Developed sob scheduler using VB.Net.
• Used Sax Comm. control to communicate with serial ports via Vb.Net win application using Inter-Op features.
• Developed GMTS (Global Management Tracking System) to escalate alerts or page messages in hierarchical manner in department until it receives response.
• Designed integrator module for integration with third party applications like ERP (JD Edwards, Karen soft), MRP by exporting data in to XML or fat files via .Net and at the same time loading data from XML and fat files or text files.
• Written common validating functions using JavaScript for client side validations and Vb.net for server side validations.
• Used nUnit framework for unit testing and automated testing using Win Runner as per requirement.
• Developed data access utility, which connects to SQL Server database, retrieves data into datasets and also updates database with datasets. Provide transactional support. Wrote stored procedures, triggers, user defined functions and views.

Environment: VB. Net, Asp. Net, MS-SQL Server 2000, Crystal Repots 10/9.0, Java Script, Windows 2003 .Net Server, Win Runner 7.0

Confidential

Responsibilities:

• Involved in software requirement analysis and design.
• Designed the schema MS-SQL Server 2000.
• Designed various reports using Crystal Reports 8.5. Used charts for graphical representation of data.
• Designed Crystal Reports using stored procedure and views. Used sub reports and formulae for accurate data representation in reports. Used Crystal Reports Formula Editor for writing formulae as per requirement in design.
• Designed and developed Win-forms using Vb.Net on VS.Net IDE, and used nUnit framework for unit testing and automated testing using Win Runner.
• Used MS Comm. control to communicate with serial port using .Net Inter-Op features.
• Developed an interface to integrate with third party applications by extract, transform and loading concept either from XML or from text files via .Net.
• Stored meta data in SQL Server 2000 using ADO.Net.
• Used MS Data grid and Fly Tree control for displaying of data.
• Wrote data base connection classes, transactions classes for update, delete and insertion.
• Used MS-Project and Visio for system design and project planning.
• Created dimensions and facts in physical data model using Erwin tool.
• Used Informatica Designer to create complex mappings using different transformations to move data to a data warehouse.
• Developed mappings in Informatica to load the data from various sources into the data warehouse, using different transformations like Source Qualifier, Look up, Aggregator, Stored Procedure, Update Strategy, Joiner and Filter.
• Created repository and set up groups and users for different departments; and also managed user profiles using Informatica Repository Manager.

Environment: VB.Net, MS-SQL Server 2000, Crystal Repots 8.5, Informatica Power Center 7, Basic Data Collector Serial Device, Windows XP, MS Project, Visio and Win Runner

Confidential

Application Developer / Crystal Reports Developer

Responsibilities:

• As member of 20 involved in analysis, design, development, unit testing and implementation of various modules.
• Designed around 75 reports, which contains sub reports, formulae and complex design patterns using Crystal Reports.
• Designed graphical reports using Crystal Reports.
• Integrated Crystal Reports with Visual Basic using Crystal Reports API.
• Designed schema for MS-SQL Server.
• Designed and developed required stored procedures and database triggers.
• Developed UI with Visual Basic-6 and ASP as per requirement.
• Used XML for dynamic menu items based on user privileges.
• Used JavaScript for validations.
• Developed printing module (OCX component) to print pre-formatted reports from client web pages.

Environment: VB.6, ASP, Crystal Reports 8, MS-SQL Server 2K, VB-Script, JavaScript 1.2, XML Win- NT

Confidential

Application Developer / Crystal Reports Developer

Responsibilities:

• Involved in software requirement analysis and design.
• Designed the schema MS-SQL Server 2000.
• Designed various reports using Crystal Reports 8.
• Designed and developed UI with Visual Basic 6 and also involved in unit test.
• Integrated DMM (Data Management Module), Advantech 1620 PCI card to capture signals from PLC and Sensors.

Environment: VB-6, MS-SQL Server 2000(Upgraded from SQL Server 7), Crystal Repots 8, Data Management Module and Windows 98

Confidential

Software Engineer

Responsibilities:

• Designed schema for Oracle 8 database.
• Design and develop reports using Crystal Reports 8.0.
• Designed and developed required stored procedures and database triggers.
• Involved in user requirement analysis that includes analyzing user interface design and creation.
• Developed user interface using Visual Basic.
• Developed COM components for database connection.

Environment: Visual Basic 6, Java (JDK 1.3), JSP 1.2, HTML, Tomcat, Oracle 8, Crystal Reports 8.0/7, Win-2000