OBJECTIVE

Around 11 years of Data Warehousing experience building data Warehouse , designing models , dashboards , schemas using data modeling and DWBI tools like ERwin r7.1/7.2,Informatica Power center 9.0, Trillium , QlikView 9/10/11/11.20,Business objects XI R2/3.0/3.1 BI 4.0, Crystal reports 2008 , Xcelsius 2008 ,Cognos 8.3 , Corvu, Brio .

Data Modeling :

• Exposure in all phases of Software Development Life Cycle SDLC including Requirement Gathering, Development, Testing, Deployment , Documentation, Migration, Security management, Training and Production support.
• Involved in various projects related to Data Modeling, System / Data Analysis, Design and Development for both OLTP and OLAP Data warehousing environments.
• Knowledge in Planning, Designing, developing and deploying Data warehouses / Data Marts with experience of both relational multidimensional database design using Data Modeling tool Erwin Physical and Logical data models .
• Extensive experience in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified database design document with detailed description of logical entities and physical tables.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.

QlikView / Xcelsius

• Design and development of QlikView dashboards, scorecards, KPI and other reports using all the charts and GUI features available in QlikView.
• Deployment and administration of production QlikView reports and environment using QlikView Management Console and QlikView AccessPoint.
• Gained Expertise in designing and modeling in QlikView with complex multiple data sources relational designs.
• Expereience in creating ETL applications for QVD's and QlikView Scripting variables and File , Date , system , mapping and table functions.
• Used Xcelsius Visualization of dashboards to pull the data from the required reports to Excel sheet by using Universe as data source. QAAWS Web services, Live Office as a middle ware using Data feeding to Excel sheet.
• Exported Dashboards to BOE Server Exported visualization contents to various file formats pdf, ppt, and html, flash .

Business Objects :

• Hands on experience in designing and developing Universe, Business Objects Enterprise administration and thorough knowledge on Business Objects Enterprise Architecture.
• Extensive experience in writing Stored procedures, Materialized Views, Triggers, Complex Queries, Sub Queries etc. using both PL/SQL and Transact-SQL.
• Developed many Dynamic reports using prompt pages and in report customizations, including dynamic columns display and dynamic sorting and dynamic group by etc
• Hands on experience in migrating XI 3.1 to BI 4.0 including regression testing , report conversion and Universe conversion from .unv to .unx

Informatica :

• Experience in Informatica mapping specification documentation, tuning mappings to increase performance, proficient in using Informatica Server Manager to create and schedule workflows and expertise in Autosys.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Extensive experience in ETL design, development and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica Power Center.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.

Others:

• Worked and gained knowledge in creating and debugging nodes in IVR tool.
• Foundational Project knowledge working on Trillium Data cleansing tool .
• Ability to find solutions for Performance problems and to write complex SQL queries to verify data.
• Team lead experience to lead an offshore team as a part of a couple of reporting projects. Provided direction, training and mentoring to the offshore team in understanding the data and report creation.
• Experience in following the Change management requests, presenting the data in a simple, meaningful format by creating Charts, Power-point Presentations from Data..
• End User Training .
• Excellent Leadership, Analytical, Communication skills and the ability to develop creative solutions for challenging client needs.
• Good team person and efficient at working without much assistance.

Tools/Skill Set

OLAP Tools:

Dash boarding / Analytics: Xcelsius , CorVu

QlikView : QlikView Developer Tool,QlikView Publisher, QlikView Management Console and QlikView AccessPoint.

Business Objects: CMC,CMS, CCM, Universe Designer, IDT , Web Intelligence, Infoview ,Business View Manager , Import wizard, QAWS, Report conversion tool, UMT Crystal reports

Cognos: Framework manager , Report studio, query studio, Impromtu web report IWR

ETL Tool:

Informatica : Informatica Designer , Workflow Manager , Workflow Monitor , Autosys third Part tool

Databases : Oracle8i/9i/10g, SQL Server 2000/2005, DB2, MFGPRO, Red Brick DW, Netezza

Incident Management Tools: OVSC, Rational Clear Quest, Radar, PVCS, Serena Team Track, Quality Center, Heat system.

Languages : SQL .

Avaya Tools: IVR 5.2, Genesys.

Detailed Summary of Qualification

Worked as a Senior System Analyst at Confidential

Confidential Role: QlikView Architect.

Confidential group is one of the world's 20 leading pharmaceutical companies. The company has been committed to researching, developing, manufacturing and marketing novel products of high therapeutic value for human and veterinary medicine. This project is to create a planning tool/dashboard for Global Clinical Development Medical Affairs that will allow budget planners to easily modify trial parameters and immediately view the impact on costs at the study, project, therapeutic area, and Medical levels. This dashboard will use trial data and trial-related cost data imported from the Clinical Trial Management System CTMS to calculate projected costs. The tool will allow planners to easily create different scenarios and perform analyses to enable better decision making.

Responsibilities:

• Worked closely with Client in analyzing and documenting business requirements functional specifications about the requirements.
• Prepared an estimate and worked on Software design document to make the Client understand the development.
• Developed a very complex dashboard in QlikView 10 with QVD creators, Aggregated Model QVD Creator and stored the data in to QVD's.
• Developed a Dashboard using Hierarchy, List, Input Field, Table Box and Calendar Date objects.
• Developed a complex Macro code with dynamic update functionality for Insert and Delete commands in QV 10.
• Created a user session data with in the dashboard using a macro code.
• Used triggers as an interface between Hierarchy, User session data and charts.
• Worked on complex line charts with individual buttons to toggle based on selection in the view/ Edit panel.
• Implemented a section access in the dashboard for individual user security.
• Worked closely with COE team to understand their deployment process through the release management tool in QlikView server.
• Installed QV 11.2 in remote machine and tested the functionality.
• Worked on change requests to support the QV 11.2 functionality especially dynamic update functionality.
• Worked on line charts to display the baseline and updated line data based on selections in the hierarchy and user inputs .
• Prepared test cases to thoroughly test the functionality and modules in the Cost analysis planning dashboard.
• Prepared UAT document, production turnover document and deployment process document .
• Successfully planning to deploy the dashboard in production with zero bug free .
• Experience on testing the dev and QA servers and having a good knowledge on QV publisher and Access point.

Environment : QlikView 10 , QlikView 11.20 SR3 ,Excel.

Confidential Role: Application SME / Lead

Confidential engages in multiple insurance and investment management in the United States. It operates in five segments: Individual Markets, Employer Markets, Investment Management, Lincoln UK, and Lincoln Financial Media. The Individual Markets segment offers individual fixed annuities, including indexed annuities and variable annuities. The Employer Markets segment provides employer-sponsored fixed and variable annuities and mutual fund-based programs. The Investment Management segment offers various retail products, including mutual funds to individual investors.

Responsibilities:

Qlikview :

• Worked on design and development of QlikView dashboards, scorecards, KPI and other reports using all the charts and GUI features available in QlikView.
• Extraction of data from databases using Informatica and T-SQL. Extracted data stored in QVDs. Connecting to OBDC and OLEDB data sources.
• Deployment of QlikView documents using QlikView Management Console and QlikView Access Point. Use of QVS and QVD as and when required in the development process.
• Development and maintenance of QlikView Dash boards .
• Analyze business needs for Dashboards and other QlikView solutions and End-to-end design and implementation of QlikView solutions.

Business Objects

• Worked with Client in analyzing and documenting business requirements data specifications about the project for Universe design Reports.
• Prepared and reviewed high level estimates for all the requirements assigned to me with respective applications.
• Designing macro and micro level documents and working with client to seek their approval and reviews.
• Created complex Universes with different data providers to meet the Client requirement and used various join methods like Equi- join , Theta join, Outer join when creating universes.
• Implemented core / derived universes.
• Conceptualize and formalize several List, Chart, Cross tab, master-detail, Drill-Down and scheduling reports using WEB I and Info View and made available to the users
• Worked on the complex Reports to provide the interactive behavior outputs to the users. Created tabbed reporting with complex calculations/formatting.
• Involved in migrating the complete environment from BO XI 31 to BO XI 4.0 including servers , universes, reports . Educating business users with demo sessions on new features on BO 4.0.
• Involved in conversion of Universes for BO XI 3.1 Universe designer to BO BI 4.0 IDT .
• Use Universe Management Tool UMT for version control .
• Developed various mappings, mapplets, and transformations and was responsible for validating and fine-tuning the ETL logic coded into mappings.
• Simplified development and maintenance of ETL by creating reusable Mapplets and Transformation objects.
• Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Worked on adding the columns from tables and editing the nodes in IVR tool
• Scheduling and organizing stand-up meeting related to high priority technical issues to make sure the issues are solved with in the IBM SLA.

Environment : Business Objects XI 3.1, BI 4.0,QlikView 10/11, Oracle SQL, Informatica 9.0.1, Main frames, Db2, Import Wizard, UMT, IVR, Genesys, WINSCP, HP Load runner, Quality center, Heat system, RPM .

Confidential Role: Sr Qlikview and Business Objects Consultant/Lead

Confidential, a Prudential Financial company, is among the largest group life and disability insurance carriers in the nation, and has a strong, ongoing focus on long-term care insurance.

Customer One: The newly established product and service governance teams have established objectives that require a Customer Needs focus and a Consistent Servicing Experience across products. A need has been established for a Right Touch customer centric model.

Life Enrollment: Life Enrollment is to define the systems enhancements necessary to support the creation of a Life Enrollment Data mart. Life Enrollment data, including both Case Level and Individual Web Enrollment, Sales Reporting and Adjustments data and Pricing Assumptions will be received into GIDW at various times during the month.

Small Business Reporting : The purpose of this requirement is to define the data elements for Small Business which will be received from SPARC system and the data will be further passed to GIDW via GIS application.

Responsibilities:

• Designed an applications to support the Funding and dashboard style of layouts using different components of QlikView Enterprise like List boxes, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc
• Developed QlikView Dashboards using Chart Box Drill Down, Drill up Cyclic Grouping , List, Input Field, Table Box and Calendar Date object.
• Developed KPI's and set analysis applications.
• Experience in QlikView Functions Date and Time, Keep, Join, Mapping, String input Fields etc...
• Migration from QlikView Enterprise v9 to QlikView v10.
• Developed User Interactive Sheets Reports as business needs.
• Writing SQL Scripts to load the relevant Data in QlikView Applications.
• Developed Macros, SET ANALYSIS to provide custom functionality in QlikView Applications.
• Implemented Security involved in Deployment of QlikView Applications.
• Created dashboard style of layouts using different sheet objects like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Created QVD's updated on timely basis as database updates.
• Developed ETL Scripts while loading the data, resolving loops ambiguity joins.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.
• Performance tuning by analyzing and comparing the turnaround times between SQL and QlikView.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher.
• Developed QlikView Applications using SSIS Data.
• Involved in up-gradation of QlikView environment from QV 10 SR1,SR3,SR4
• ,QEMC SR3 QV 11.0 versions.
• Business Objects
• Involved in all phases of Software Development Life Cycle such as Development, Testing, Administration and Production.
• Worked as Business Analyst in providing information to end users with their day to day data requirements and designing BRDs Business Requirement Documents .
• Debugging Stored procedure in SQL for performance tuning of reports in BO .
• Worked on Triggers , referential integrity , Storage migration , Partitioning , Indexing , Materialized views, Purging , overlapping processes and security for performance tuning.
• Created Dimension Model for the reporting system by identifying required Dimensions and facts using Erwin
• Conducted design discussion and meeting to come out with appropriate data mart at the lowest level of grain for each of the dimensions involved.
• Optimization and Formatting of the Existing Universes for easy understanding for the Users. Implemented Standard Naming convention across Universes and Reports.
• Helped users in solving adhoc query issues, building adhoc reports, setting up report schedules in Info view.
• As a part of Universe development, created Classes, different kinds of Objects, cardinalities, Strategies, resolving loops using Aliases and Contexts.
• Conducted Design reviews with analyst and content developers to create POC for the reports.
• Created views in SQL and derived tables in the universes to meet the BO report design requirements.
• Modified and corrected many existing reports/universes as per the change requests from users.
• Created a large number of Full Client and Web Intelligence reports. Functionalities such as Slice and Dice, Drill mode and Ranking, complex IF statements, Where Clauses were used for Multidimensional Formatting.
• Reports were created using multiple data-providers. Reports involved Current Date-Prior Date, Weekly, Monthly, Quarterly comparison.

Environment : Erwin r7.1, Business Objects XIr2, Oracle Sql developer, Toad db2, Import Wizard, Team track, PVCS.

Confidential Role: Sr DWBI Consultant

Applications : Business Objects and Informatica

Confidential provides incremental business values with Analytics CoE, Advanced Analytics providing new and innovative capabilities. SDW customized solution represents fundamental shift in analytical capability for AETNA using IBM's Health plan data model HPDM including migration of legacy EDW to SDW and provide a reduce cost SDW support model. SDW solution framework is going to address the design, build of a data warehouse and analytical solutions using IBM's BI Reference Architecture.

Responsibilities:

• Worked with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Leading team consisting of ETL, Data base and BI Reporting tool Developers.
• Coordinating Onshore offshore team assignment on Deliverables.
• Scheduling and organizing stand up meeting related to high priority technical issues.
• Involved in building The ETL architecture and source to target mapping to load data into data warehouse.
• Created sessions, configured work flows to extract data from various sources, transformed data and loading into data ware house.
• Modified existing mappings for enhancements of new business requirements.
• Involved in performance tuning at source, target, mappings, sessions and system levels.
• Provided sessions on the usage of the External Metadata functionality to the Power Users which enables the customized data reporting.
• Developed Conditional Formatting, Conditional Blocks Using String, Boolean and Language variables
• Prepared the Presentations/User Guides to the End Users as part of the training
• Worked closely with Client in analyzing and documenting business requirements data specifications about the system for Universe, Reports.
• Designed, developed and maintained Universes for supporting Adhoc and canned reports.
• Involved in the creation and formatting of the Universes.
• Creation of Row-level, object level filters. Extensive use of pre-defined conditions to limit the repetitive use of conditions, automating prompts, and in a way improving the performance of the reports.
• Created a large number of Full Client and Web Intelligence reports. Functionalities such as Slice and Dice, Drill mode and Ranking were used for Multidimensional Formatting.
• Created different types of ad hoc reports- Master/Detail reports, Cross Tab reports and reports involving bars Charts.
• Involved in trouble shooting testing and performance tuning of the existing and new reports.
• Worked with Customer in clarifying resolving defect raised in Clear quest.
• Involved in Unit testing data testing and used Db2 to validate the data in Reports.
• Finding work-around for various issues posed by the user requirements.

Environment : Erwin r7.2, Informatica power center 8.6, BOXI R3.1,Oracle SQL , Toad , IVSC

Confidential Role: SAP Business Objects Xcelsius Developer

Confidential has a very strong domestic base and a well recognized international presence. Both businesses viz agricultural chemicals and specialty performance chemicals are poised for much faster growth by partnering/joint ventures for manufacturing, marketing and research and development activities with prospective companies across the world.Scope of the project is to centralize the functionality of its system by introducing SAP. This implementation includes the replacement of the existing BAAN and other systems in to SAP.

Responsibilities:

• Installation of SAP Business Objects Edge BI 3.1, Xcelsius 2008 and post installation activities.
• Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications about the system for Universes, Reports and Dashboards.
• Build Exported new universes to the Repository to make resources available to the users for ad-hoc report needs as per the user requirement from SAP BI queries and cubes.
• Developed critical reports like drill down, Slice and Dice, for analysis of Sales and purchases in Plant and headcount in payroll.
• Created complex reports containing charts showing the revenue, sales, turnover and operating income done by different divisions including sub-reports, graphical reports, and formula base and formatted reports according to user requirement.
• Used data manger to establish connections between Query as a Web service and Xcelsius to define inputs and outputs to dashboard.
• Created a CEO Dashboard using Xcelsius 2008 by gathering all the required information from all modules showing all KPI's in speedometer, Charts, sliders and selectors.
• Application rights in CMC-Provided setup rights to all users to access them WEBI, DESKI and Info view.
• Provided In house training for end users for generation their own report.

Environment : Business Objects Edge BI 3.1, Xcelsius 2008, MS Office, SAP BW,Toad

Confidential Role: QlikView / Business Objects Developer

The project is for Confidential, which is a global manufacturer and marketer of high quality, brand-name products for consumers throughout the world. The corporation has operations in 58 countries and markets branded products in nearly 200 nations. Collectively, these brands generate more than 13 billion in annual net sales.

Responsibilities:

• Business requirements gathering , data understanding , data preparation , modeling , model testing and deployment/ reporting
• Designing QlikView document / User setting . layouts to make consistent and professional optimized look to clients .
• Developing QlikView Sheet objects including multi chart types , KPI's , Trends , Custom request for excel export and objects for management dashboard reporting.
• Explore data for accuracy and consistency.
• Manage program structure and smooth execution of multiple projects.
• Managed 75 QlikView reports replacing the entire legacy excel based reporting
• Development using Set Analysis, QlikView functions and QlikView scripting.
• Design and Development of AutoSys schedules for QlikView Dashboards to Business Users .
• Performing the UAT of the developed QlikView applications under varying conditions and analyzing the behavior of the system under multi user environment.
• Providing QlikView training to clients. The training type either a developer training or a user training depends on the requirements of the client.

Business Objects :

• Created complex Universes with different data providers to meet the Client requirement.
• Involved in migration from BO XI R1 to BO XI R2 older BO 5.1.6 to BO XI with team.
• Created Web Intelligence reports. Functionalities such as Slice and Dice, Drill mode and Ranking, complex IF statements, Where Clauses were used for Multidimensional Formatting
• Involved in configurations, setup and access such as Job servers configuration and testing, mail exchange server setup and Universe, Dual designer, Web I designer and Web I knowledge user access.
• Created reports in BRIO CorVu with Drill functionality when specifically requested by user.
• SPOC for connectivity issues which involves tracking, analyzing and coordination for connectivity issues across partitions interlocking with Sara Lee connectivity team for better understandings in terms of connectivity.
• I have worked with our counterpart HP, installing applications in Citrix and VDI environment and other required access to applications done in GP phase itself.
• Prepared AID and ASCP documents for applications and got signed of by Sara Lee SME.
• Used Incident Management tools like OVSC, RADAR for validating those after resolving the Issues.
• Involved in Disaster recovery document preparation for all applications handled by me and also maintaining backup plans for the team for all applications CorVu, Brio handled by us to avoid delivery gaps on time.

Environment : Qlikview 8.2/8.5/9, Business Objects XI R1/R2, CorVu , Brio , Radar, PVCS, MFG PRO

Confidential Role: QlikView Developer

Confidential Involves to identify high-level current future reporting requirements for Dashboard.. To replace, the multiple Gaming BI legacy systems Excel reporting, with QlikView

Responsibilities:

• Once the requirements are collected then we created SRS document ,planned the scope and schedule of the project
• Performing Coding, generating Unit Test Reports and developing the qlikview application on the basis of the SRS document
• Collecting inputs from client on the changes in the specifications and making appropriate changes in the schedule and incorporating the changes in the qlikview application..
• Qlikview application is developed then as per client requirement setting up the environment Using QlikView server and analyzing through web browser
• Performing the UAT of the developed qlikview applications under varying conditions and analyzing the behaviour of the system.
• Testing the reports tabs for data accuracy and resolve defects in development Level.

Environment: QlikView 8.2 , MS Excel

Confidential Role: Business Objects Application Developer

Responsibilities:

• Involved in the complete front end cycle of the projects. Understanding user requirements, designing of universes and reports, Testing
• Designed Micro level Document AID based on client requirement
• Designed, developed and maintained Universes for supporting Adhoc and canned reports.
• Involved in checking the Pulse of Citrix creation of groups for users based on requirement
• Involved in the creation, corrections of the Universes.
• Creation of Row-level, object level security to the objects based on the requirement specification
• Creating extensive use of pre-defined conditions to limit the repetitive use of objects, conditions, prompts, and in a way improving the performance of the reports.
• Involved in developing detail reports using Various Cross tab reports, Tabular reports and Detail reports with Drill-through functionality.
• Involved in discussions in understanding of the data model and plan to design the universe based on the business logic.
• Involved in Unit testing after developing the reports also prepared test cases
• Used Toad to cross check the data in the reports
• Worked on production support for scheduling the reports.
• Worked with testing team to make the understand the report logic based on requirement specification
• Resolved defects or trackers raised by testing team.
• In house training

Environment : Business Objects 6.5,BOXIR2,Toad,SQL Server DB2, Crystal Reports 2008

Corporate Training by IBM and Oracle

• Cognos 8.3v, Data warehousing concepts, Dimensionality modeling concepts-5 day class room training by IBM..
• UNIX Basic shell scripting-3 day class room training by IBM
• Oracle Business Intelligence Enterprise Edition OBIEE in Reporting and Building Repositories at Oracle University.
• Oracle Database 10g at Oracle University.
• Netezza class room training by IBM.