Divya

Cell: 309-***-****

ad2j1c@r.postjobfree.com

Summary:

With 7+years of technical experience, including 4 years of specialization in the Business Intelligence / Data Warehousing Technologies, specifically with Business Objects and Crystal Reports, Informatica Power Center, Oracle, Teradata, SQL Server, DB2, Weblogic, Tomcat and Business Objects Administration.

My roles have included:

Full life cycle BI operations management

Product Installations/ upgrades/ migration

Business Objects Universes & WebI Reports, Crystal and Dashboards Development

Operational / QA/ & User acceptance testing

Data Integration implementation/ operations and training

Technical training delivery (including extensive curriculum development)

BI Team Lead / System Management

Business / Technical Requirements Analysis and Development

During the past 5 years I have specialized in Business Objects Xi3.1/XiR2/4.0 & operations management on the Business Objects/Crystal Reports platform.

Business Objects Experience

Played the role of Business Objects Development/ Administrator for the BCBSE, TX operational reporting system.

Experience in development of Universes, modified existing universes, added new objects to existing Universes and working on the procedures for the development of reports.

Responsibilities included development of new reports, modification of existing reports, and ongoing user support. Production environment included fifteen clustered servers and in excess of hundreds of reports.

Advanced knowledge of reporting technologies including Crystal 2008, Web Intelligence, Desktop Intelligence, Xcelsius, Performance Management, Crystal reports included advanced SQL, dynamic cascading parameters, business views, and universes.

Analyzed System infrastructure and prepared the project plan to make the Business Objects system resources available to all end users in quick time and with high performance.

Installed and configured the Business Objects Enterprise X3.1/XiR2 products on UNIX machines

Strong experience in Upgrading / Migrating Business objects from 6.5 to XIR2, XIR2 to XIR3.1 and defining the infrastructure, server architecture, high available failover systems, redundant server design and also implementing SSO integration using BO XIR3 features.

Advanced experience with Business Objects XI R3 Central Management Console (CMC) including creation of Business Objects folders, documents, reports, user groups, profiles, schedules, publications, and security rights.

Advanced SQL skills connection to a variety of data bases including MSSQL 2005, Oracle 9 & 10g, and Teradata.

Involved in the full life cycle of projects including requirement gathering, development, unit testing, code migrations, user acceptance, and documentation.

ETL Experience:

Over 3 years of experience in the Analysis, Design, Modeling, Development Implementation and deployment of Data Warehouses/Data Marts, Client/Server Applications, Multidimensional Analysis and OLAP Reporting

Experience in Data Warehouse development working with Extraction/ Transformation / Loading using Informatica Power exchange / Power Center and Business Objects Data Integrator with Oracle, SQL Server and Heterogeneous Sources

Strong experience in Installing, Configuring and Administration of Informatica Power Center Client tools - Designer, Repository manager, workflow manager/monitor and Server tools – INFORMATICA Server, Repository Server manager.

Data modeling experience using Star Schema/Snowflake modeling, OLAP/ROLAP tools, Fact and Dimension tables, Physical and Logical Data modeling by using ERWIN 4.0/3.x.

Good knowledge on data warehousing concepts like Star Schema, Snow Flake Schema, Type1, Type2 and Type3, Slowly changing dimensions.

Expertise in Application Development with full lifecycle experience of implementing large Client/Server Applications

Database Experience:

- 24/7 systems support of the Business Objects reports and database servers for the organization, database development tasks, and assistance to software engineering staff for database related activities.

Created indexing and procedural improvements that increased system uptime by over 100% over a period of 3 months.

Substantial development experience in creating Stored Procedures, PL/SQL, Packages, Triggers, Functions and Query optimization.

Worked with development staff to fix both hardware and software issues.

Environment consisted of multiple databases SQL Server 2000, Oracle and Teradata in both development and production with databases ranging from 1 gig to over 100 gigs. The environment included internal as well as web access to high availability transactional data in a clustered environment.

Data warehousing Technologies:

ETL Tools SQL Data Transformation Services, Informatica

Data Modeling Erwin

OLAP MS Sql Analysis 2000, Business Objects Designer 4.1/5.1.5/ 6.0/ 6.1b, 6.5/XI R2

Reporting/DSS Business Objects 4.1/5.1.5/6.0/6.1b, 6.5, XI R2/XI R3 and 4.0, Web Intelligence, Info View, CMC, ZABO, Crystal Reports 10/XIR2/XI 3.0/XI 3.1

Technical Skills:

Operating Systems UNIX, Windows NT, LINUX, Windows 95/98/XP/2000/2003/2008

Databases Oracle 8/9i/10g, SQL Server 7.0, MS Access

Languages Java (J2EE), PL/SQL, C

Internet

Technologies JSP, XML, XSL, HTML, JavaScript, HTML, DHTML, ASP, VB Script, MTS, IIS

Development Tools Visual Basic 5.0/6.0, Visual Interdev, Crystal Reports

Education Qualification:

Bachelor of Engineering in Information Technology, India

Masters in Computer Science-USA

Projects:

The University of Iowa Hospitals and Clinics, Iowa City IA Oct ‘13 - Present

Application Developer (EPIC Report Developer)

Responsibilities:

Certified in EPIC Clarity Reporting Tools,ADT Admin/Fundamentals, Reporting Workbench, Radar Dashboards, Crystal Reports 2014/2015

Responsible in design, build, testing, validation and ongoing support of clinical.

Responsible for obtaining and maintaining in-depth knowledge of the software functionality, and acquiring knowledge of the clinical workflows to be implemented on the system.

Experience with Epic Clarity data models and Crystal report writing.

Developed complex Epic Reporting Workbench reports for the ADT application as per the end users requirement using EPIC HYPERSPACE.

Developed WEBI/Crystal reports for Clinical Applications

Involved in the preparation of reports and analyze existing portfolio for trends and performance including SQL optimization and automation; and extract existing data to manipulate/calculate/format into presentable forms, including charts, and graphs tables, etc.

Advanced reporting experience using EPIC Hyperspace and Clarity tools.

Involved in training and interacting with the end users in communicating reporting requirements for ADT/Prelude tools

Developed complex reports for Environment Services and Transportation

Experience with Tableau and SQL in building census reports.

Environment:

EPIC Hyperspace, Crystal Reports 2008/2011,SQL Server,SSIS,BO 3.1/4.1,BO Universe

Principal Finance Group, Des Moines IA Feb ‘13 – Sep ‘13

Business Objects Developer/Data Analyst

PFG is a nationally known investment manager and provider of 401k plans, mutual funds, retirement plans,insurance,investment and banking products.

Responsibilities:

Responsible for end to end requirements starting with developing models in SAP BI and ending with reports in 3.1 and 4.0 BO.

Expert in Business Objects Reporting Tools like Universe designer, Report Builder and setting up Administration rites to the end users.

Worked on Business Objects 4.0 tools suite including Information Design Tool (IDT), Web Intelligence and Dashboard Designer on BI Platform.

Worked with the Sales and Purchasing functional teams for gathering requirements and Design Workshops for collecting dashboard and reporting specifications.

Designed and developed .unx universes using Information Design Tool.

Developed WEBI report for RIS (Pension) department to replicate transaction reports.

Worked on multiple projects in maintain and developing the reports using Agile methodology.

Developed and maintained queries with Restricted Key figures, Calculated Key figures, Selection, Formulas, Variables, Conditions and Exceptions.

Expert in performance tuning and complex query development.

Generated BO exclusive reports in BEx Query Designer using filters, calculated key figures, and restricted key figures.

Scheduled the report by setting the run-time parameters and charted by customizing the options.

Designed Webi reports with BW Billing Condition BEX queries as data source

Worked on different WST’s and involved in support activities on weekly basis.

End to End testing for all the 4.0 BO reports developed going from ECC to BW to Business Objects

Worked along with the testing team to derive test cases for efficient Data reporting.

Environment:

SAP Business Objects Enterprise BI 4.0 (Dashboard Designer, IDT, Universe Designer, Web Intelligence, Crystal Reports Enterprise, Explorer),SAP BW 7.3, SAP BO Data Services 4.0, Oracle 10g, Teradata

Client: USAA, TX Jan ’12 – Feb ’13

Business Objects & Support Developer

Description: USAA offers worldwide insurance, investing, banking and other financial services to people and families that serve, or served, in the United States military.

USAA has expanded to offer banking and insurance services to past and present members of the Armed Forces and their immediate families. The company is one of the pioneers of direct marketing and most of its business is conducted over the Internet or telephone using employees instead of agents.

Responsibilities:

Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Extensive application knowledge on different IBM tools like Unica, Ephiphany which involved in developing complex and derived reports in 4.0.

Implemented the ETL process and business logic by using PL/SQL.

Gathered Users Information and Security levels and monitoring there access levels accordingly in BO 4.0 and other environments.

Monitoring the daily job scripts for loading the data about business transactions from source systems to EDW,CSDM

Presented the SAP Mobile platform using the SBO Explorer application on the Apple iPad.

Provided training for end users for generating their own Adhoc reports in 4.0/3.1 environments.

Involved in Unit Testing and Integration Testing.

Involved in documenting the changes to the universe and reports functionality

Designed and developed complex Universes as per report requirements of business analysis.

Worked on Performance management to meet the requirements of higher level analysis.

Involved in basic ETL job process using Control-M cycle.

Modified the existing Universes by Adding the new objects, Tables and created Derived tables

Created New charts and variables according to each the Business requirement.

Created reports in Desktop Intelligence, WEB Intelligence and followed scheduling process according to the Business requirement

Expertise in generating and resolving complex issues in the reports that involved linking tables from a wide variety of data sources, including Microsoft Excel spreadsheets, Oracle databases.

Worked on Universes Query Panel, Prompts and Report Layout and re-formatting according to the company standards.

Worked extensively with the major functionality of BO like Breaks, Ranks, Alerter, complex Calculations, and filters, Sorts, Query prompts, open doc calls and cascading prompts.

Knowledge on Informatica and Data stage to create ETL processes.

Expertise in developing Xcelsius Dashboards using Live Office and QWAS.

Environment: Business Objects XIr2/r3 4.0,SQL Developer, Designer,Xcelsius, Info View, CMC, Web Intelligence XIr2/XIr3/4.0,Data stage, Windows XP Professionals.

Client: Fannie Mae, TX July ’10 – Jan ’12

DA/Business Objects Developer

Description: The corporation purpose is to expand the secondary mortgage market by securitizing mortgages in the form of mortgage – backed securities, allowing lenders to reinvest their assets into more lending and in effect increasing the number of lenders in the mortgage market by reducing the reliance on thrifts. It contains several applications which maintains all the loan portfolio.

Responsibilities:

Technically Lead Projects in providing estimates, assigning development tasks providing coding best practices in developing highly scalable and reusable applications.

Worked on different applications that stored loan numbers, form numbers and property details wherein which generated complex reports according to the Business Users.

Mapping the database fields after developing the reports or after adjusting report as per the client requirement

Defined the security model in Enterprise XiR2 and XI3.1

Gathered the Users Information and Security levels in BO 6.5 to implement the new Security in BO XI R3

Involved in documenting the changes to the universe and reports functionality

Designed and developed Universes as per report requirements of business analysis.

Tuning SQL query performance, working with data warehouses, managing metadata, and developing Web services using DB2.

Created reports with Desktop Intelligence, WEB Intelligence and scheduling them on Monthly, weekly and daily frequency as per the reports need.

Expertise in generating reports by linking tables from a wide variety of data sources, including Microsoft Excel spreadsheets, Oracle databases, Business Objects, Enterprise business views, and local file system information using Crystal Reports 2008.

Worked with single Business Objects universe mapped to multiple data sources and optimally federates queries against individual sources directly using Data Federator.

Worked on Informatica to create ETL processes.

Expertise in developing Xcelsius Dashboards.

Created Contexts and Aliases for resolving Loops in the Universes.

Created canned Reports and Dashboard Reports for entire Business and separate divisions

Worked on Performance management to meet the requirements of higher level analysis.

Managed Users, Groups and their access privileges on the documents

Upgraded the Business Objects products from 6.5 to BO XIR3 using Import and export wizards.

Environment: Business Objects XIr2/r3, DB2, Designer, Xcelsius, SAP BW/BI, Info View, CMC, Web Intelligence XIr2, DB2, Informatica, Windows XP Professionals, SAP ECC.

Projects:

Client: BCBSE,(ITSS-FL) TX April ’09 – June ’10

Business Objects/DA/Support Developer

Description: The purpose of this ICU Dashboard project is to develop and implement of a data repository of clinical and financial information for all PPMC ICU patients to provide the ICU clinicians with the capability of effecting meaningful care decisions to improve the outcome of care for their patients.

Responsibilities:

Involved in Full life cycle implementation of the Enterprise Data Warehouse.

Involved in gathering the requirements from Business Managers for reports development

Designed specification documentation and get the approval from Business Managers about the reports layout.

Worked on Designing and developed the Dimensional Data Models for the implementation of successful Enterprise Data Warehouse (EDW).

Exported the universes to the CMS while making resources available to the end users.

Managed Users, Groups and their access privileges on the documents

Generated complex reports from different data sources like Sql,Tera data,SAP BW using Webi.

Did Performance tuning of the reports, optimization of queries and bug fixing in the reports by reverse Engineering methodology

Upgraded the Business Objects products from 6.5 to BO XIR2 using Import and export wizards.

Migrated Business Objects lower version(6.5) documents, Universes and their connections, User privileges and their access levels into Business Objects XI Release 2.

Worked on Informatica data mappings for tuning and to resolve the data issues of the BO reports performance and data loading

Created various complex List Reports, Grouped Reports, Cross tab Reports, Chart Reports and Drill-Through Reports.

Customized data by adding prompts, Filters, Calculations, Summaries and Functions.

Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.

Involved in developing complex, and significant operational problems which occur with improperly designed ETL tools like Data integrator and Informatica

Developed complex spreadsheets in online using Xcelsius Dashboards

Extensively involved in Reconciliation process and Recovery process for capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively.

Troubleshooting the existing workflows in Informatica Power Center based on the validation required by the client from Business Objects reports and dashboards.

Monitoring the daily job scripts for loading the data about business transactions from source systems to EDW

Written PL/SQL stored Procedures and Functions for Stored Procedure Transformations.

Environment: Business Objects XI3.1/XI R2, Business Objects Universe Designer, Central Management Console, Infoview, WEBi, Import Wizard, EPM, Xcelsius, Informatica power center, Oracle10g, PL/SQL Developer, SQL Server 2005, XML, UML, Windows XP, Linux, Harvest Version control.

Contact this candidate