Manager Sql Server
Resume:
Rashmi S
********.******@*****.***
SUMMARY:
• 7 years of IT experience in implementing Data Warehouse applications and Business Intelligence applications.
• Extensively used Business Objects Enterprise Xi3.1/XiR2/Xi/6.5, Informatica Power Center, and SQL Server 2008/2005/2000, SAP BW, Oracle 10g, Teradata and DB2.
• Expertise in performance tuning of loading the OLTP Transactions and integration of the data into Data Warehouse(EDW) and data marts.
• Worked on integration of SQL Server, SAP, Oracle, Teradata, XML, Flat file source systems into the Centralized Data Warehouse.
• Installed and configured the Business Objects Enterprise Xi3.1/XiR2 on Windows and UNIX machines.
• Strong experience in Upgrading/Migrating Business Objects from 6.5 to XIR2, XIR2 to XI3.1 and defining the infrastructure, server architecture, capacity planning, virtualization of nodes, high available failover systems, redundant server design and also implementing SSO integration using BO XIR3 features.
• Support and lead administration of BO environment and other BI tools, designing Universe, publishing & Scheduling the reports and dashboards to end users based on their security levels in a BI environment using Central management Console (CMC).
• Designed the universes from the sources SAP BW, Oracle, Teradata and SQL Server.
• Experience on identifying the metrics, Key Performance Indicators for Dashboards development.
• Created OLAP reports, Web I reports, Crystal reports, Adhoc reports and Dashboards.
• Worked on Business Objects 6.5.1, and 5.1: Supervisor, Business Objects Reporter, InfoView, Web-Intelligence 6.5, ZABO and BO Broad Cast Agent Scheduler.
• Experienced in migrating the BO info objects from Dev to test and test to production.
• Implemented Data Cleansing, Transformation Scripts, Stored Procedures/Triggers and necessary Test plans to ensure the successful execution of the data loading processes.
• Designed and implemented the Star Schema/Snowflake schema methods, identifying the dimensions, measures, Hierarchy levels, Fact and Dimension tables.
• Substantial development experience in creating Stored Procedures, PL/SQL, Packages, Triggers, Functions and Query optimization.
• Experience in resolving on-going maintenance issues and bug fixes, and performance tuning of reports.
• Good communication and user interaction skills and an ability to interpret economic and business logics in data warehousing perspective with a strong understanding of Database design and data architecture principles.
EDUCATIONAL QUALIFICATION:
Masters in Information Technology
Bachelors in Computer Science
Technical SKILLS:
Reporting Tools Business Objects 5.1.5/6.0/6.5, XIR2, XI3.1, XI 4.0, Web Intelligence, Universe Designer, Desktop Intelligence, Infoview, CMS, CMC
ETL Tools SAP BW, Informatica Power Center 8.1.1/7.1/6.5, SQL Server 2000/2005, DTS Packages and SSIS.
Databases Oracle10g/9i/8i, MS SQL Server, IBM DB2, BW, Teradata V2R6/V2R4, Sybase 12.0/11.x, PL/SQL
Programming C, C++, SQL, PL/SQL, XML, UNIX Shell Scripting
Data Modeling Dimensional Data Modeling using Star & Snow Flake schema, Erwin 4.5/4.0/3.5/3.0 and Oracle Designer 2000
Operating Systems Windows Server 2003/2000/NT/ XP, Solaris 10,UNIX and DOS
PROJECT EXPERIENCE:
Client: Kaiser Permanente, Pasadena, CA Aug’11 – Till Date
Role: Sr.Business Objects Developer
Responsibilities:
• Involved in Full life cycle design and development of Business Objects Enterprise Applications.
• 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.
• Designed and developed Business Objects reports as per the Business requirements.
• Created Classes and Objects (Measure, dimension and detail) in the universe.
• Used Designer Module to implement Universes, Joins between Tables, and created prompts and queries, parsing of Universes, and created Contexts and Alias Tables to remove cyclic dependencies.
• Resolved Chasm traps, Fan traps and Loop problems.
• Designed and Maintained Universes and exported them to the repository.
• Developed Complex Reports (Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts).
• Created reports using standard company templates. A few of them were created based on the Department requirements.
• Formatted reports as per the user’s requirements using all the facilities in Business Objects, which allows the users to analyze the data.
• Gathered report requirements from business end users/clients and assisted business partners in retrieving business information from data warehouse and resolved any SQL query issues.
• Created user Prompts, conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Worked extensively with the major functionality of BO like Breaks, Alerter, Filters, Sorts, and Drill filters.
• Created Drill-Through Reports to provide users with more detailed information and query linking.
• Provided extensive support for the users on application usage and trained users in the functionality of the software.
• Developed the dynamic and customized prompts based on the hierarchy level information for predictive analysis of the reports.
• Identified the Metrics and sub metrics, Key performance indicators (KPI’s) for Dashboard development.
• Exported the reports and dashboards into centralized database to access them for daily business analysis.
• Created Dashboards to monitor business performance, insightful analytics, and role based dashboards with dashboard manager.
• Managed Users, Groups and their access privileges on the documents.
• Monitoring the daily job scripts for loading the data about business transactions from source systems to EDW
• Created Stored Procedures while generating the reports in CMC.
• Tuning SQL query performance, working with data warehouses, managing metadata, and developing Web services using DB2
Environment: Business Objects XI 3.1, Business Objects XI 4.0, Central Configuration Manager, Central Management Console, Infoview, WEBi Rich client, Desktop Intelligence, Import Wizard, Xcelsius 2008, SAP BW, Oracle 10g, Microsoft Excel, Windows XP.
Client: Siemens, Philadelphia, PA May’10 – July’11
Role: Sr. Business Objects Admin/Developer
Responsibilities:
• Identified and road mapped the Business Requirements (functional & technical) with the Business users, which acted as a base for the project initiation and implementation.
• Worked closely with the users in gathering the report requirements.
• Helped manage risk analysis and mitigation plans, status reports, and client presentations; prepared business process models, defined milestone deliverables, and established critical success factors.
• Analyzed the data model for the modifications in the Universe.
• Extensively used Business Objects Designer to design and maintain Data warehouse Universe.
• Migrated, upgraded and test the Business Object XIR3 content/environment
• Setup, execute, and test the assigned programs utilizing BO XIR3 Webi and DeskI tools
• Troubleshoot BO XI installation and migration issues.
• Created Reports using Multiple Universes which are on different RDBMS and successfully migrated them to production.
• Implemented row level security and column level security to the Reports.
• Created derived tables in the Universe for performing complex calculations and functions.
• Created universes and resolved Loops by creating table aliases and contexts.
• Administrating Business Objects and Crystal Enterprise
• Design complex Crystal, Web Intelligence and Desktop Intelligence Reports.
• Used Import Wizard tool to migrate all the objects from BO XIR2 to BO 3.1
• Train users to use the tool and create Ad-hoc business objects reports (With my own documentation)
• Worked with the ETL team in populating the necessary tables and data for the development of universe.
• Modified the Universe based on the report requirements
• Created contexts for resolving the loops in the Universe.
• Created crystal, WEBI reports using complex calculations and variables.
• Created Dashboards using Xcelsius for the reports
• Created queries of universe and published them as web services to provide dynamic data for the dashboards
• Enabled/Disabled different servers in Central Configuration Manager and Central Management Console.
• Performed Server Management Tasks, using Central Configuration Manager (CCM) and Central Management Console (CMC).
• Worked on WEBI for adhoc reporting purpose.
• Responsible for scheduling and report bursting of the reports.
• Trained end users in understanding the reports. Functionalities such as Slice and Dice, Prompt, Drill mode and Ranking were used for Multidimensional Formatting.
• Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
• Created custom dates for the publication of the reports.
Environment: Business Objects 3.1/XIR2, Tomcat 5.5.20/5.0.27, Xcelsius 2008, Crystal Reports 2008,HP Quality center, Remedy, Life Cycle Manager, Import Wizard, Unix, Windows AD, LDAP, Apache Web Server 2.2, IIS, Microsoft Excel, Windows 2008, Windows 2003, Oracle10g, Sybase, Erwin 4.0.
Client: Omni Care, Covington, KY Feb’08 –April ’10
Role: Sr. Business Objects Developer
Responsibilities:
• Requirements Gathering and Business analysis
• Gathered Customer, User and Owner requirements; analyzed and documented them.
• Designed and customizing data models for Data warehouse supporting data from multiple sources on real time.
• Setup hierarchies in the Universe for providing drill down options in the reporting environment.
• Created Sets, Metrics, Rules, using Set Analyzer and Dashboard Manager.
• Created and customized application dashboards using Application Foundation and used balanced score cards and speedometers.
• Linked two universes sales and customer using kernel approach.
• Created multiple universes and resolved Loops by creating table aliases and contexts.
• Worked with database connections, SQL joins, cardinalities, loops, aliases, materialized views, views, aggregate conditions, parsing of objects, LOVs, and hierarchies.
• The universes were frequently tested for validity and correctness of inferred SQL.
• Created reports on development data to test the functionality of universes with a group of power users.
• Scheduled reports to business users and owners using Broadcast Agent.
• Created reports using WEBI, DESKI, full client.
• Knowledge of Crystal Reports reporting system including Crystal Server reports distribution infrastructure.
• Created graphs/charts for the reports, Created Master Detail and Cross Tab Reports.
• Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
Environment: Business Objects XIR2/6.5/6.1, Data Integrator, Dashboard Manager, Xcelsius, Web I 6.1, DESKI, JSP, SQL, PL/SQL, Erwin,TOAD,DB2,SQL*Loader, UNIX Shell Script, DB2, Windows 2000/NT, ORACLE, PL/SQL, SQL Enterprise Manager
Client: Community Health Systems, Franklin, TN Oct’ 06 – Jan’ 08
Role: Business Objects Developer
Responsibilities:
• Designed and developed Business Objects Universes to support the new sales reporting requirements of business users.
• Automated document Scheduling, Publishing and Distribution for WebI and Desktop Intelligence clients, using the Central management Console (CMC).
• Designing and implementation of Universes using Business Objects Designer.
• Analyzed the existing database and designed the Universes using Business Objects Designer Module for generating reports.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Exported the universes to the Repository to making resources available to the users.
• Generated reports using business Objects Report Designer.
• Created parameterized crystal reports and customized existing reports for presentations using Summary reports, Detail reports, Cross-Tab reports and Sub-reports.
• Assigned the privileges to users using Central Management Console (CMC).
• Created and customized application dashboards using Performance management to meet the requirements of higher level analysis.
• Developed dashboards and scoreboards for detailed analysis using Xcelsius 2008.
• Troubleshooting and customization of reports after upgrade.
• Created complex reports by linking data from multiple sources, using functionalities like Slice and Dice, Drill Down, Master Detail, etc.
• Extensively worked with local Repositories, Central Repositories, Job Server and Web Admin client tools.
Environment: Business Objects 6.5.1/XI R2 Central Management Console, Supervisor, Designer, Desktop Intelligence, Crystal reports, Infoview, WEBI, SAP BW, Oracle 9i, PL/SQL Developer, Sybase, SQL Server, Teradata, Windows 2000.
Client: Qwest Communications, Denver, CO Feb’05– Oct’06
Role: Jr.Business Objects Developer
Responsibilities:
• Designed Universes by defining joins, cardinality between tables, linked the existing Universes using BUSINESS OBJECTS 5.1.
• Developed complex universes by using advanced features like aggregate aware, Conditions and hierarchies to Perform linking of universes by Kernel method to optimize the universe development and performance improvement.
• Interacted with the Business Users to analyze the business process and gathered the requirements made necessary changes to schema objects to fulfill their reporting and business needs.
• Develop the Dashboard presentation using the Business Objects and Crystal Xcelsius.
• Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Created complex reports using multiple queries and involved in tuning the reports in order to increase the accessing speed.
• Published existing reports to corporate intranet through Web Intelligence.
Environment: Business Objects 5.1, SQL Server, Broadcast Agent, Xcelsius, SAP BW, Oracle 8i, PL/SQL, Info View, Excel, Application foundation, Tomcat 4.x, Apache, Windows 2000.
Contact this candidate