SRAVAN KUMAR

acn88h@r.postjobfree.com Cell: 505-***-****

Summary:

• 7+ Years of IT experience in all aspects of Business intelligence applications with a strong

background in Database development like SQL, Data Warehouse, Business Objects and Qlikview.

• Expertise in designing and modeling of QlikView with complex multiple data sources (SQL, Flat

Files, Excel and Access) relational designs.

• Experience with QlikView sheet objects including Pivot, List, Multi box, multiple charts types,

Trends, KPI’s, custom requests for Excel Export, and Fast Change and objects for Management

Dashboard reporting.

• Experience in optimizing applications by using QVD’s, removing non key fields and script

variables (Loading phase).

• Experience in designing QlikView Document/User Setting, Layouts to make consistent and

professional optimized look to clients.

• Proficient in migrating reports from different platforms (such as Excel, Actuate, and SQR) to

Qlikview.

• Proficient in implementing Business needs and Batch process in backend using Stored Proc

and Functions.

• Provided training sessions on the use of QlikView to analyze organizational data.

• Experience in loading data from different data sources Oracle 10g/9i/8i/8.x, PL/SQL, SQL,

TOAD, and SQL Server 7/2000.

• Excellent logical, analytical & debugging skills.

• Possesses good leadership qualities, good Interpersonal skills, team-working attitude, takes

initiatives and very proactive in solving problems and providing best solutions.

• Strong understanding in creating Dashboards, scoreboards for the required KPI’s in QlikView.

• Developed load scripts to work with multiple data sources (SQL, DB2, AS400, Excel, and Share

point site).

• Developed production-grade QlikView reports and dashboard to meet business requirements in

timely manner.

• Designed an applications for to support the lending process 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

• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView

Publisher

• Involved in up-gradation of QlikView environment from QV 10.0, QV 11.0 versions. Did end to

end Unit Testing when migrating the applications.

• Designed, developed, implemented and tuned multiple QlikView applications for the Sales, IT,

Manufacturing, Purchasing & Finance Qlikview applications.

• Wrote SQL Scripts, procedures and views which are required for Qlikview projects.

• Configured and deployed the application on QlikView server and Imported data from different

sources like Oracle, SQL Server, MS Access, XML files, QVDs and flat files using OLE DB/ODBC.

• Schedule QVW reloads on server and troubleshoot errors and failures.

• Worked on data modeling and developed different complex models as per given user

requirement without any closed loops, Synthetic tables and ambiguous relationships.

• Mainly designed and developed Qlikview software applications and complex server-based

Qlikview dashboards from scratch to support reporting and Business Intelligence initiatives.

• Worked on dashboards related to Sales Analysis, Production over time and implemented

performance tuning that offers fast and flexible access to all key information across the enterprise.

• Testing dashboards and data validation.

• Expertise in using incremental loading for automatically loading data into QVD's when

database updates.

• Expertise in using triggers for advanced functionality of variables and high performance of

front end applications.

• Expertise in using resident load to load data faster by reading from memory.

Technical skills:

Databases: SQL Server 2008/2005/2000, Oracle, Teradata.

Tools: Qlikview, SQL Server Reporting Services (SSRS) and

Business Objects XIR2/3.1/4.0/4.1.

Languages: C, SQL, PL/SQL, T-SQL.

Operating system: Win 9x/ NT/2000/XP/Vista, MS-DOS, UNIX, Windows 2003 server.

Utilities: Ms Word, MS PowerPoint, MS Excel.

Professional Experience

Client: Bristow Group, Titusville, FL Nov 13 to present

Role: QlikView Sr. Developer

Responsibilities:

• Involved in Requirement gathering & designing QlikView applications.

• Worked with the team to identify the business reporting needs and studied current reporting

practices outside of QlikView through pivot tables.

• Participated on business requirement document preparation.

• Rebuild dashboard applications on both frontend UI and backend, developing scripting

templates, UI design and coding standards, design guidelines, migration strategy and

implementation plan.

• Developed different dashboard with a complex database system behind it, which includes

extracting data from the database, storing into QVD files, write load scripts, and develop UI

according to user requirements.

• Connected to different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to

create and schedule different complex reports as per given business requirement by leveraging the

basic components of QlikView.

• Maintained and administered source documents, source documents sets, and user

profiles and executed resource management services like Access point resources, distribution

folders. Monitor user access to manage the limited number of licenses.

• 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.

• Designed and created the dashboard reports for Executive board of company.

• Developed scripts for data reloading, mapping and transformation

• Conducted UI visualization improvement on Usability and User Experience (UX)

• Modified existing reports using QlikView.

• Maintained and updated the dashboard reports as required by client.

• Performed incremental loading for automatically loading data into QVD's when database

updates.

• Expertise in using triggers for advanced functionality of variables and high performance of

front end applications.

• Installed, configured and deployed QlikView application on top of Oracle DB.

• Conducted and guided QlikView BI application global roll out, managed QA Testing, User

Acceptance Testing (UAT), software update, migration deployment and parallel run, stabilizing

the server platform and application to achieve the steady state for transitioning.

• Designed dashboards identifying the KPIs and to support the time comparison between

budgets and actual.

• Designed Executive Sales Analysis Dashboard that offers fast and flexible access to all key

information across the enterprise.

• Implemented security using QlikView section access technology that dynamically hides

selected areas of the dashboard depending upon user privileges.

• Maintained user guides and documentation for QlikView applications.

Environment: Qlikview 11, Oracle, SQL Server, Excel, CSV files, Enterprise Management Reporting

Portal, DB2, QlikView Enterprise Server, IBM Tivoli.

Client: 3M, St. Paul, MN Apr 12 – Oct 13

Role: Qlikview Sr. Developer

Responsibilities:

• Developed Qlikview applications by analyzing business data as per client requirements.

• Involved in creating logical and physical model of the database using Erwin.

• Created schema objects like tables, views, indexes. Used DDL and DML for writing triggers,

stored procedures, and data manipulation.

• Written new stored procedures, functions and T-SQL queries and modifying existing ones as

per new business requirements.

• Connected to different ODBC, OLE DB data sources (SQL Server, Oracle, and SAP BW) and

flat files to create and schedule different complex reports as per given business requirement by

leveraging the basic components of Qlikview.

• Created and managed ETL script generation using QlikView Script Builder Application.

• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView.

• Created dashboard style of layouts using different components of QlikView Enterprise like List-

boxes, Multi-boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.

• Presented QlikView applications to various levels of user.

• Designed application for Sales & Marketing Modules that Generates GUI Report for easy access

through the data.

• Worked with Qlikview administrator to optimize Qlikview performance.

• Worked with Qlikview administrator to optimize Qlikview performance.

• Worked on Automation & scheduled QVW document refreshments using Qlikview Publisher.

• Performed incremental loading for automatically loading data into QVD's when database

updates.

• Expertise in using resident load to load data faster by reading from memory.

• Also developed Canned Reports, Customized Reports, On-Demand Reports and Ad-Hoc

reports and involved in analyzing multi-dimensional reports in SSRS.

• Created Drill down reports which give all the details of various transactions like closed

transactions, pending approvals, and summary of transactions and scheduled this report to run on

quarterly basis using SSRS (Reporting services).

Environment: Qlikview 10/11, MS SQL Server 2005, SSIS, SSRS, T-SQL, PL/SQL, Oracle 9i, SQL,

UNIX, Microsoft Visio 2003, MS-Access 2000 & Windows XP Professional.

Client: AvMed, Miami, FL Jan 11 – Mar 12

Role: QlikView Developer

Responsibilities:

• Work directly with business users to define and prototype Qlikview Applications.

• Work with senior management to plan, define and clarify dashboard goals, objectives and

requirement.

• 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.

• 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.

Environment: QlikView 10, OBIEE,Informatica, Oracle, Windows NT & Sun Solaris, QlikView Server

and Publisher, QlikView Developer, Real-Time BI Analysis, Microsoft SQL Server, SSIS, SSRS, Oracle

Database, SAP Business Objects.

Client: Farmers Insurance, Los Angeles, CA Jul 09 – Dec 10

Role: Business Objects Developer

Responsibilities:

• Studied the business processes & gathered requirements from Business Analysts and Business

Users.

• Updated and maintained existing Universes based on changing user requirements and based on

changes in data source.

• Designed and developed Universes by defining Joins, Cardinalities between tables, and linking the

existing Universes.

• Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are

retrieved.

• Worked on creating Derived Tables, Aggregated Tables using Aggregate Awareness concept,

creating Indexes, views to increase the performance of the universe.

• Created multiple universes and resolved Loops by creating table aliases and contexts.

• Implemented Security Features of Business Objects like row level, object level and report level to

make the data secure.

• Created Complex Reports using Reporter module in Desktop/Web Intelligence functionalities like

Slice and Dice, Drill Down, @Functions, Cross Tabs, Master/Detail, and Formulae.

• Generate pictorial views in the form of 2D, 3D & Pie Charts from existing Reports & Chart Wizard.

• Worked on Developing Standard & Multi-Dimensional Web Reports using features like Drills,

filters, Sort, Rank, Sections, Breaks, Alerts, merge Dimensions, sub queries and Multiple Data

Providers.

• Exported reports into XL, PDF, CSV and XML formats as per the client requirement.

• Created custom LOV's which help the end users while picking the values from the prompts.

Environment: Business Objects XI R2, Designer, Web Intelligence XI, Data Integrator XI, Desktop

Intelligence, Live Office, SQL Server 2005, Oracle 9i, Sybase PL/SQL.

Client: North East IT Ventures, India May 07 – Jun 09

Role: SQL Developer

Responsibilities:

• Created standard filters, prompts, calculations, and conditions in Catalog.

• Defining join conditions, table aliases and views for the user requirement

• Created Joins, folders, reusable filters, pre-calculations, prompts.

• Updated Impromptu Catalog by adding tables and creating new joins

• Developed drill through reports, developed filters, conditional formats and prompts using Prompt

manager.

• Created IQDs are used as data sources in power play Transformer to generate Transformer models.

• Created various Impromptu reports (List, Cross-Tab and Drill through) and Power play Reports.

• Published Impromptu reports and Power play reports to Upfront.

• Scheduling Impromptu web reports in upfront.

• Clarified the requirements by talking to the user groups and accordingly modified the functional and

technical specifications.

• Developed / modified Oracle PL/SQL codes like stored procedures, functions, triggers etc based on

technical and functional specification documents.

• Developed / modified scripts to create tables, views and executed them using SQL Plus.

• Developed / modified scripts to rectify data errors and executed them using SQL Plus.

• Ran batch jobs for loading database tables from flat files using SQL Loader.

• Prepared unit test cases and executed the same.

• Good understanding of TOAD and OOPS concepts.

• Used SQL* loader to load data into the databases.

• Oversaw installations, upgrades of SQL 2000, SQL 7.0 to SQL 2000.

Environment: Access Manager 7.2, Oracle 8i, PL/SQL, SQL*Loader, ODBC, Windows NT, UNIX .

Contact this candidate