SUMMARY

• Over Eight years of total IT experience with emphasis on development of data warehouse and Business Intelligence solutions and functionalities using Qlikview and Cognos
• Strong knowledge & experience in all phases of Software Development Life Cycle (SDLC) such as Developing, Testing, Migrating, Administrating, Security management and production support.
• Good experience on software applications development, ETL and BI applications.
• Extensive experience in Qlikview 9.0/10.0/11.0 with expertise in developing innovative applications for the business users.
• Extensive experience on Cognos 8 BI, TM1, Framework Manager, Report Studio, Analysis Studio, Query Studio, Metric Studio), Power play Transformer, and Cognos Report Net.
• Experience in installation and configuration of Cognos 8 on client - server architecture.
• Expert in designing and developing professional reports such as list report, crosstab report, chart report, dashboard report Burst report using Report studio.
• Experience in generating reports using Joins, Union, Intersect, SQL in Report studio.
• Experience in metadata modeling (Relational, Dimensional) using Framework Manager in layered approach such as Presentation layer and Physical layer.
• Experience in creating Global Filter.
• Created complex reports using features like Prompts, Cascading prompts, Detail and Summary filters, Conditional blocks, Master-detail sections, Drill- Through, Page set, Render variables, Boolean variables and conditional string.
• Experience with Qlikview sheet objects and installing Qlikview 11 Publisher and Server in production and test environment.
• Good experience in installing and configuring Qlikview Desktop, Qlikview Server and Qlikview Publisher.
• Good Knowledge in Data Modeling, Star Schema/ Snow Flake, Dimensional and FACT tables.
• Proficient in optimizing, debugging and testing SQL queries.
• Strong experience in design & development ofBusiness Intelligence and Data warehousereporting.
• Strong experience in Dimensional Modeling using Star Schema, Identifying facts ad Dimensions, Physical and logical data modeling using ER-Modeling.
• Strong Data analysis to ensure accuracy and integrity of data in the context of Business functionality.
• Extensive experiences in analysis, design and development of distributed web based and desktop based applications, data modeling, ETL, reporting / data analysis systems and BI solutions.
• Good Knowledge on ETL tools like SSIS and Informatica Power Center.
• Team Oriented individual with a result driven attitude, Strong interpersonal and communication skills in effective information exchanged and interaction with clients at all levels of management.

TECHNICAL SKILLS

Business Intelligence Tools: QlikView 9.0/10.0/11.0 IBM Cognos8.x, 10.x, SSRS,, OBIEE Microstrategy 9x/10.

Databases: Oracle 11g/10g/9i, MS SQL Server 2008/05, DB2, MS Access 2000.

Programming tools: C, SQL, PL/SQL, HTML and Java-Scripts.

ETL Tools: Informatica Power Center 8.x/7.x., SSIS, SSRS.

Data Modeling Tools: Erwin, Toad.

PROFESSIONAL EXPERIENCE

Confidential, MN

SR. Qlikview Developer

Responsibilities:

• Involved in Business requirement gathering and Participated in Joint Application Development (JAD) process with different Business Segments in designing Qlikview Applications.
• Worked with business analyst to gather requirements.
• Extracted data from the SQL Server database wrote SQL load scripts and used joins to join the tables.
• Developed a Star Schema Data Model that suits the business requirements by eliminating synthetic keys and circular loops.
• Developed Dashboard using Bar Charts, Line Chart, Text Boxes and List Boxes.
• Used Alternate States and Set Analysis to get the needs of the end users.
• Used QVD generator QVW file to create the QVD’s. In the QVD generator file the data is imported from the SQL Server.
• Used Macros and Extensions in the dashboard developed.
• Used Document level and Field level triggers based on the requirements.
• Extensively involved in gathering the User-Requirements from the End-Users and documenting end to end process.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio
• Worked extensively on relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Used Dimensional modeling (DMR) and Relational modeling techniques technique to develop FM models.
• Create Transformer cubes using Cognos Framework manager packages as source.
• Created Dashboards comprising of list reports, cross-tab reports and chart reports using underlying multiple
• Configured the Security with Active Directory
• Creation and Maintenance of User, User groups and Roles.
• Good experience in using the QlikView functions (Trim, Match, Like, String etc..)
• Implementing the Section access to the application developed and then deploying it to the server.
• Involved in enhancement of existing dashboards with new functionalities.
• Involved in analyzing the existing data model, script logics and ETL logics for the existing dashboards.

Environment: Qlikview 11,IBM Cognos 10.2, SQL Server, Team Foundation Server, MS Excel.

Confidential, Memphis, TN

Qlikview Consultant

Responsibilities:

• Developed load scripts to work with multiple data sources (DB2, Flat Files, Excel).
• Developing a model that suits the business needs and also adheres to the needs of the end users.
• Developed QlikView Dashboards using Charts (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Data Island.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc ).
• 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.
• Developed Business Requirement Documents based on Client’s Requirements.
• Developed and managed dimensionally Modeled Relational model (DMR) using Framework Manager.
• Defined the keys, Joins, cardinalities and global filters in Framework Manager.
• Used package level security and folder level security.
• Developed Burst reports, Drill through, Master Detail, List, Chart, cross tab and complex reports (which involves Joins, Unions, Prompts, Report Library, Table of Content, Report Layout, template, Dashboards etc) in Report Studio based on the business requirements involved Multiple Prompts in Report Studio
• Developed Query studio Packages for Ad-Hoc reporting.
• Worked on enhancements to existing Cognos reports in Report Studio & models in Framework Manger
• Migration of reports from Cognos 7 to Cognos 10.1
• Created query studio reports using Custom Grouping option.
• Applied conditional formatting for hiding the data, and highlighting the data
• Incorporated Layout Component Reference in the new reports.
• Created Cascading prompt and repromptable prompts to view report
• Coordinated with offshore team for Migrations.
• Importing data from SQL Database and using SQL scripts to join the data tables and pull the required data.
• Deploying the Qlikview reports onto the Qlikview servers and Publishing the reports on Access Point.
• Used various charts and set analysis functions to generate desired outputs.
• Involved in Business requirement gathering with different Business Segments in designing Qlikview Applications.
• Developed Qlikview applications by analyzing business data as per client requirements.
• Involved in creating logical and physical model of the database using Erwin.

Environment: Qlikview 11, SQL Server, SSIS, Oracle, OBIEE, Erwin

Confidential, Dallas, TX

Sr. BI Consultant ( Cognos/Qlikview)

Responsibilities:

• Worked as a developer using Qlikview 10.
• Deploying Qlikview dashboards to servers.
• Developed QVD’s and used them as data source for the development.
• Developed SQL Scripts, database objects, procedures, functions and packages.
• Created a secure environment using QlikView Section Access.
• Implemented QlikView desktop and publisher, managed user authentication, established publisher tasks, streamlined loading procedures and reviewed log.
• Interacted with customers to collect the business requirements.
• Wrote complicated SQL queries.
• Designed & developed reports using Cognos 10.1.1 Report Studio, Query Studio and Analysis Studio.
• Created various List Reports, Grouped Reports, Cross Tab Reports, Charts and Drill- through Reports using Conditional Formatting, multiple Prompts and queries, Filters, Slicers, master-detail relationship, aggregation function.
• Created reports in Analysis Studio by using cubes and multi dimension models.
• Developed Dashboards Using Business Insight and Business Advanced Insight and created Drill through reports from Dashboard to all summary reports and Summary to Detail reports.
• Scheduled and distributed reports to the end users by schedule management in Cognos connection. Implemented bursting and event trigger function when it’s needed.
• Analyzed the reports which are in SSRS format and implemented these reports to Cognos Report Studio.
• Developed Cognos Portal integration & Cognos portal design.
• Customized Cognos Connection with appropriate reports and security measures.
• Collected Data from different databases then stored into qvd files.
• Writing the complicated scripts and worked on buttons drill down charts and set analysis etc.
• Developed several complicated datamodels using Qlikview.
• Developed various Qlikview applications.
• Deployed Qlikview Dashboards to servers and implemented daily loads.
• Implemented Incremental Load in Qlikview Servers.

Environment: Qlikview 10, Informatica 8.1, Oracle 11g, Windows XP/7

Confidential

ETL/BI Developer

Responsibilities:

• Experience in Informatica PowerCenter 7.x and 8.x.
• Extensively used Informatica-Power Center for extracting, transforming and loading into different databases.
• Experienced in different stage ofETL processes such as Extraction, Cleaning, Transformation and Loading using Informatica PowerCenter (Versions 7.x/8.x/9.1/9.5) involving wide variety of different data sources/targets non-relationalDatabases such as Flat files, Cobol Files, and other relational sources such as Oracle, SQL Server, Flat files, Teradata and DB2.
• Analyzed the logical model of the databases and normalizing it when necessary.
• Involved in identification of the fact and dimension tables.
• Wrote PL/SQL stored procedures and triggers for implementing business rules and transformations.
• Good understanding and practical knowledge of Business Intelligence&Relational Database Management Systems concepts.
• Proficient in databases including Oracle, SQL server, DB2 & Tera data.
• Developed transformation logic as per the requirement, created mappings and loaded data into respective targets.
• Created Source and Target Definitions in the repository using Informatica Designer Source Analyzer and Warehouse Designer.
• Used Mapping Designer to create mappings.
• Replicated operational tables into staging tables, to transform and load data into the enterprise data warehouse using Informatica.
• Created and scheduled Worklets, configured email notifications. Set up Workflow to schedule the loads at required frequency using Power Center Workflow Manager, Generated completion messages and status reports using Workflow Manager.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Used salesforce CRM application for performing data mapping as per project requirement.
• Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse
• Documented Data Mappings/ Transformations as per the business requirement.

Environment: Informatica Power Center 7.1.3, Oracle 9i, PL/SQL, Toad, SQL Plus, Erwin, UNIX, Tivoli.