SUMMARY

• 8+ years of experience in IT Software Development Life cycle involving Business Requirement Analysis, Application Design, Data Modeling, Development, Testing and Implementation of Data Warehousing and Database Business Systems
• Hands on years of extensive experience in the field of Data Warehousing, Data Architecture, Data Modeling, Business Intelligence and reporting Applications (Qlikview).
• Extensive experience as QlikView Developer & Architect.
• Good knowledge in implementing and maintaining Dashboards and Scorecard Reports
• Strong working knowledge of Qlikview scripting, Set analysis, aggregation functions, multi - dimensional objects and layout and design including chart properties and formats.
• Strong knowledge in basic components of QlikView Enterprise like List Boxes, Multi Boxes, Tables, Charts, Current Selection Boxes, Buttons, Containers etc.. And experience in editing scripts for creating variables, fields, and calculated expressions, basic and aggregated functions.
• Experience in optimizing existing QlikView reports with a focus on usability, performance, flexibility, testability, and standardization.
• Design of QlikView applications using QlikView Data (QVD) files, different Databases and creating reusable variables.
• Trained the end users effectively to use the reporting tool (Qlikview), to build and customize their ad-hoc reports.
• Used Qlikview publisher to schedule data load, distribute Qlikview application, and manage security and access through Active Directory integration
• Having proven abilities in development, design, testing and production support for successful execution of projects on Qlikview.
• Expert in database development skills using SQL and writing Stored Procedures, Packages and Triggers.
• Ability to work in tight schedules with high quality and efficient in meeting deadlines.
• Excellent understanding and expertise in writing complex SQL (DDL, DML and DCL) queries to perform back-end testing.
• Strong experience in understanding Business Applications, Business Dataflow and Data relations. Exception ability to quickly master new concepts and capable of working in-group as well as independently.
• Excellent communication, presentation and interpersonal skills.

TECHNICAL SKILLS

Reporting Tools: QlikView 9.x, 10.x, 11.x seriesLanguages Visual Basic, Unix Shell scripting and SQL

Operating System: UNIX, Linux, WINDOWS NT/XP/7/2008 server

Software Development: Agile Methodology

BI Tools: Cognos10.X/8.4,(Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Power Play Transformer, Business Insight, Metric Studio), Business Objects 6.1, Actuate Reporting suite 10.0, VSS

ETL Tools: Informatics Power Center 7.x/6.x, SqlServer Integration Services(SSIS), Abinitio 2.1

Qlikview Tools: QlikView BI, OBIEE, SSIS, SSRS, Informatica

Databases: DB2, Oracle 10g/9i/8i, MS SQL Server 2000, TOAD, Excel and MS Access 2003. GreenPlum, Teradata.

Version Control: Motio, Share point, Visual source safe.

PROFESSIONAL EXPERIENCE

Confidential

Qlilkview Consultant

Environment: Qlikview 11.X Series, Oracle, SQL Server, SAP, Excel, and CSV files, DB2, QlikView Enterprise Server, QlikView Server and Publisher.

Responsibilities:

• Understanding user requirements and expectations. Providing end to end reporting solution.
• Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards.
• Assigned to create dashboards by extracting data from multiple databases, storing into QVD files, write load scripts, and develop UI according to user requirements.
• 2 Executive Dashboards Project Portfolio Management and Competitive TSR were created during the stint. Dealt with a data volumes ranging from 20 to 50 million records.
• Designed dashboards using the various sheet objects Current selection, list boxes, search, Straight table, Pivot table, Bar chart, Combo chart and so on.
• Optimizing existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.
• Used QlikView Functions (Date and Time, Join, Aggregation, Range, Ranking, Peek, Previous etc.) and Created Variables using LET, SET or control statements in the scripts.
• Document event trigger and field event triggers is created. Incremental reloading is implemented.
• Analyzed the database and provided detailed information on their operational and Forecast for future years.
• Performance tuning of dashboards was carried out to limit the response time.
• Successfully passed through the QA Environment and implemented on Production and post-production support.

Confidential, Omaha, NE

Report/Dash Board

Environment: and Development Tools: QlikView 11.0, Cognos BI 8.4/10.1.1, db2, TOAD4.5, MS-excel, MS-Word, SharePoint

Responsibilities:

• Understanding user requirements and expectations. Providing end to end reporting solution.
• Involved in software evaluation for the Bank. Evaluated Tableau and QlikView. Recommended QlikView
• Presentations and Training to different user community on dashboards
• Build dashboards using QlikView. Implemented QlikView best practices. Designed data model using database connection and excel files. Build multiple layers of QVDs, created transformations, build hierarchies and so on.
• Resolved synthetic keys in the model. Used various Load statements viz. Inline, Resident, CrossTable and so on.
• Created multiple tab dashboards. Created Pivot tables, Trend graphs, Bar graphs, Stacked Graphs, containers and so on. Created links to access Cognos reports from the dashboard. Created customer search. Used variables to show and hide objects based on user selection.
• Build Frame manager models/packages. Designed FM model in layers viz. database layer, presentation layer, Adhoc Layer and so on. Created relationships, used shortcuts, role playing dimensions and so on. Created standard filters in the FM model to be used in all the reports. Designed reporting packages for report authors and Adhoc packages to be used by end users in Query studio.
• Build reports using Cognos package and native SQL. Created List reports, crosstab reports, and reports with conditional formatting and so on. Published cubes to be used in Analysis studio by end-users.
• Developed dashboards using Cognos Business Insight.
• Developing data extraction guidelines from multiple systems, data architect and data modeling.
• Building relationships with cross functional teams. Negotiations and interactions to ensure quality and on time delivery of systems.
• Responsible for managing user’s expectations, status communications to stakeholders. Providing estimates, monitoring the development.
• Performed UAT and successful production migrations and handover to production support to close the projects.

Confidential, FL

Principal Consultant

Environment: and Development Tools: Cognos 8 BI 8.4 (Framework Manager, Cognos Connection, Report Studio, Query Studio, and Analysis Studio, Power Play Transformer), Business Objects 6.5, Oracle 10g/Oracle ERP, JAROS. Qlikview 11, NPrinting, Microsoft SQL server 2012, Windows Server 2008.

Responsibilities:

• Work collaboratively with the business users and reporting teams
• Optimized existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time.
• Currently assigned to create dashboards by extracting data from multiple databases, storing into QVD files, write load scripts, and develop UI according to user requirements. simplifying complex expressions in the front-end, improving layout structure
• Designed various Frontend objects like Line, Bar, Pie, Straight, Pivot Tables and other sheets objects like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Design and deliver effective visualizations.
• Build and maintain Qlikview applications.
• Troubleshoot issues and find the effective solutions.
• Worked on generating PDF, Word and PowerPoint Reports using NPrinting
• Designed data models based on the client requirements and without any ambiguous or Synthetic tables.
• Stored the tables as QVDs and used Scripts to generate appropriate fields that help in modeling the data according to the requirements.
• Oversee the development of Qlikview applications
• Define and maintain architecture and development standards for the Qlikview environment
• Maintain and execute the technology roadmap for the Qlikview environment
• Effectively identify and remediate issues and risks that impact the performance and reliability of the Qlikview solution.
• Ensure consistency across applications as they are developed.

Confidential

QlikView Developer

Environment: Qlikview 11.0, SQL Server 2005/2008, TSQL, MS Access, Visual studio 10 BIDS, Teradata, Windows XP/2003 server, HTML, Excel

Responsibilities:

• Involved in business requirement gathering and development of functional and technical specification documents.
• Gathering data sources like QVD files, Excel, Oracle & Teradata DWs, binary QVW, Inline & txt files in developing the QlikView Data Models.
• Connected to different ODBC, OLE DB data sources (SQL Server, MS Access, Oracle, Teradata) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of Qlikview.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date Island.
• Developed KPI s and set analysis applications.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the Qlikview publisher.
• Worked on modeling data as per business requirements. Eliminated Synthetic keys, ambiguous relationships and closed loops.
• 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.
• Automated and scheduled daily/weekly/monthly data loads of QVW documents using Qlikview Publish and notified load status by email.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Qlikview.
• Optimizing existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front - end, improving layout structure.
• Enhance existing dashboards with new functionalities and Tune ETL scripts for better performance.
• Build reusable macros to control Qlikview objects for ease of use by the users.
• Research and troubleshoot technical problems and Provided ongoing Qlikview consultation to the development team.

Confidential

QlikView Developer

Environment: Qlikview 10/11, Oracle, SQL Server, TeraData, SAP, Excel, CSV files, Enterprise Management Reporting Portal, DB2, Cognos, Informatica, QlikView Enterprise Server, QlikView Developer, Autosys, Apache, Aajx, JavaScript, Flex, Flash, Java, ASP.NET, Agile Scrum.

Responsibilities:

• Gathered, Analyzed, and transformed business requirements of the Client into logical and physical BI solutions.
• Provided technical leadership in QlikView BI/DW design, dashboard and KPI metrics design, data modeling, QlikView SAP integration, QlikView scripts development, QlikView Set Analysis, and QlikView Server/Publisher setup/configuration.
• Participated in project planning, documentation, budgeting, and requirement analysis.
• Applied Scrum methodology in the system development process.
• Worked with cross functional team and business user to develop Business requirement document(BRD), define key performance indicators(KPIs) and identify data sources.
• Conducted requirements gathering and developed strategy maps and roadmaps for delivering Data Analytics and BI Reporting via QlikView in-memory technology
• Designed and developed QlikView software applications and server-based QlikView dashboards from scratch to support BI initiatives.
• Hands-on experience in setting up new task and troubleshooting existing task setup and other issues.
• Designed and developed BI Reporting solution enabling users to effectively utilize the tools to create Analytical Reports, Dashboards, and Scorecards, helping clients align KPIs performance metrics to strategic drivers and priorities.
• Identified data sources and targets for data modeling and solution architecture.
• Implemented new production methodologies that resulted in optimizing employee's time to finish the tasks, thus enhancing employee efficiency.
• Created automatic schedulers to reload the data as per requirements.
• Developed predictive analytics and forecast models to help clients gain deeper insights on existing data and information, improve business performance, and shape the future of the companies.
• Worked closely with the development team to understand functionality, resolve issues and provided feedback for the UML diagrams.
• Extracted data from multiple complex hierarchies from cross table flat files and websites.
• Provided ongoing QlikView consultation to the development team.

Confidential

SQL Server Developer

Environment: SQL Server, SSIS, SSRS, Erwin, .Net Frame Work, XML, MS Access, Excel, C#, ASP .Net, ER Studio, performance point Server.

Responsibilities:

• Filtered inaccurate data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency.
• Worked on performance monitor counters for monitoring SQL Server environment.
• Managed indexes, statistics and optimizing queries by using execution plan.
• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data using Erwin.
• Designed DTS Packages to transfer data between servers, load data into database, and deploy the data, scheduled the jobs to do these tasks periodically.
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Extracted the data from Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS .
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Performed data cleansing by creating tables to eliminate the dirty data using SSIS.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS in Business Intelligence Development Studio (BIDS).
• Designed and developed various types of reports using SSRS and rendered them in front end applications like Excel and .net.
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML, .doc and CSV using SQL Server Reporting Services (SSRS).
• Used MS Access for smaller databases to create the tables and generate the reports.
• Created score cards with advanced set of dashboards using MS Office Performance Point Server Dashboard Designer that feature executive summary measures.
• Scheduled SQL Server Agent Jobs to run every day to update changes in the base tables.
• Resolved various performance issues by running DBCC command.
• Performed daily tasks including backup and restore from disaster recovery by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler.