SUMMARY:

• 7+ years of IT industry experience in all aspects of Business intelligence applications wif a strong background in Database querying, Data Warehousing /Decision support systems and Business Intelligence.
• Hands on years of extensive experience in the field of Data Warehousing, Data Architecture, Data Modeling, Business Intelligence and reporting Applications (Qlikview).
• Comprehensive noledge and exposure to different phases of Software Development Life Cycle (SDLC).
• Strong working noledge of Qlikview, Set analysis, aggregation functions, multi - dimensional objects and layout and design including chart properties and formats.
• Strong noledge 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.
• Design of QlikView applications using QlikView Data (QVD) files, different Databases and creating reusable variables.
• Experience inQlikViewServer and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Developed ETL Scripts to resolve Circular Relationships, Synthetic Keys & Modeling Issues.
• Expertise in designing and modeling of QlikView wif complex multiple data sources (Oracle, SQL Server, Flat Files, Excel and Access) relational designs.
• Planning project activities viz. scoping, estimation, tracking, change management, delivery management & post implementation support
• Trained the end users effectively to use the reporting tool (Qlikview), to build and customize their ad-hoc reports.
• 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.
• 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.
• Proven abilities in conducting feasibility assessment by coordinating wif support & technical teams & developing effective automation solutions for testing of applications
• In-depth noledge of industry best practices in both business management and technology domains.

TECHNICAL SKILLS:

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

Databases: DB2, MS SQL Server 2012 and Oracle

Tools: / Utilities: HP Loadrunner, Jmeter, Performance Center

Configuration Mngt Tools: VSS

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

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Qlikview Developer

Responsibilities:

• Understanding user requirements and expectations. Providing end to end reporting solution.
• 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.
• Optimized existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time.
• 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.
• Developed KPI’s and set analysis applications.
• Troubleshoot issues and find the effective solutions.
• Designed data models based on the client requirements and wifout 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.
• Experience in transformation of external data sources to QVD’s and from QVD’s to QVW reports
• Developed dashboard which gives overall health of all the servers viz. No of users logged in, Usage of a particular application daily/weekly/monthly which helps in capacity planning, different reload tasks status.
• 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

Environment: Qlikview 11, Microsoft SQL server 2012, Windows Server 2008.

Confidential, North Carolina

QlikView Developer

Responsibilities:

• Work directly wif business users to define and prototype Qlikview Applications.
• Work wif senior management to plan, define and clarify dashboard goals, objectives and requirement.
• Design, Develop, Test, debug and implement Qlikview solutions based upon specified requirement.
• Extract, transform and load data from multiple sources into Qlikview applications.
• Created QVD’s & updated on timely basis as database updates.
• Deploy applications on production server and set up automated data reloads.
• Create PDF push reports using Qlikview report editor.
• Developed ETL Scripts while loading the data, resolving loops & ambiguity joins
• Using Qlikview Functions (Date and Time, Keep, Join, Mapping, String and input Fields etc.)
• Developed User Interactive Sheets & Reports as business needs.
• Created Dashboards style of reports using Qlikview components like List Box, Slider, Buttons, Charts and Bookmarks.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Implemented Star & snowflake schema (confirmed dimensions).Writing SQL Scripts to load the relevant Data in Qlikview Applications.
• Developed Macros, SET ANALYSIS to provide custom functionality in Qlikview Applications.
• Design, Build, Test, Debug the Qlikview application in QV Test server environment.

Environment: Oracle 10 g, Excel, QlikView 10.0, Windows Server 2008 R2

Confidential, Chicago, IL

Qlikview Developer

Responsibilities:

• Worked wif the finance teams to identify the business reporting needs and studied current reporting practices outside ofQlikViewthrough pivot tables.
• Participated on business requirement document preparation.
• Participated in Scrum stand up meetings.
• Created SQL Stored Procedures and Views to fetch the data from database to build reports.
• Designed and created the financial dashboard reports for Executive board of company.
• Modified existing reports usingQlikView.
• Re-use the existing QVDs, new tables as QVDs and scripts to generate appropriate fields that help in modeling the data according to the requirements.
• Design of complex charts and trends which will provide Year on Year, Month on Month and Week on week analysis.
• Maintained and updated the dashboard reports as required by client.
• Analyzed the external financial and regulatory reporting, intercompany and internal management reporting needs of the business process.
• Created and maintained OLE DB/ODBC connections for all environments.
• Developed hierarchical business model for company codes, account numbers, line of business, treaty/plan, customers and adjustment periods.
• 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 usingQlikViewsection access technology that dynamically hides selected areas of the dashboard depending upon user privileges.
• Maintained user guides and documentation forQlikViewapplications.
• Installation/Configuration ofQlikView10

Environment: QlikView10.0, Oracle, SQL Server, SAP, Excel.

Confidential

Project Engineer

Responsibilities:

• Developed dashboards pertaining to Revenue and Sales monitoring using Qlikview 9.0 SR6.
• Managed and distributed application using Qlikview Publisher.
• Participated in user discussions to understand the user requirements, layout, and look and feel of the dashboards to be developed.
• Performed analysis, documentation, for calculation for various attributes.
• Worked wif Various Qlikview Objects to develop Applications
• Performed testing of dashboards for functionality, data, performance, look and feel.
• Promoting dashboards to production environment and manage user access.
• Design and deliver effective visualizations using best Practices.
• Involved in User Sessions and Production Support of applications.

Environment: Qlikview 9.0, MS SQL Server 2005, PL/SQL,Oracle 9i, SQL.

Confidential

Performance Test Engineer

Responsibilities:

• Collecting requirements from the stake holders and translating them into measurable non-functional requirements.
• Creating performance test plans detailing requirements for Benchmark and Load testing.
• Involved in designing Load Testing scenarios based on the non-functional requirement and SLA for various modules.
• Coordinating wif the client business analysts, application architects, development team, technical team and PMO to resolve any project requirement wif respect to application performance.
• Gathering baseline statistics for each individual component by testing them separately.
• Developing simulation scripts using HP Loadrunner - Web and Siebel-Web protocol.
• Executing multiple test using Performance Center to identify Performance bottlenecks.
• Monitoring the Response times, Throughput, Bandwidth usage and other server metrics during the test was running.
• Analyzing the test results and preparing the preliminary report consisting of the response time, scalability point and threshold level of the application.
• Preparing final executive summary report at the end of the engagement.
• Preparing comparative study of the performance of the application before and after the Siebel up gradation made.
• Involve in preparing and presenting weekly status reports wif clients.

Environment: Manual Testing, HP Loadrunner, Jmeter, SQL Bugzilla.