SUMMARY

• Over 7+ Years of IT experience in all aspects of Business intelligence applications with a strong background in Database development, Data warehousing /Decision Support Systems and Business Intelligence.
• Expertise in Full Life Cycle Development including Planning, Analysis, Design, Implementation and Maintenance using Qlikview.
• Installed, Configured and deployed the application on QlikView server and Imported data from different sources like Teradata, Oracle, SQL Server, XML files, QVDs and flat files using OLE DB/ODBC.
• Developed complex dashboards from scratch to support reporting and Business Intelligence initiatives.
• Wrote complex expressions using Set Analysis.
• Designed Extract Scripts to generate QVDs for faster and efficient data reloads and also designed Data Model which supports front end apps.
• Implemented security using Section access that dynamically hides selected areas of the dashboard depending upon user privileges.
• Managed Qlikview Reporting environment which includes Qlikview Server/Publisher and Desktop.
• Expertise in using MicroStrategy 9i/8x product suites including MicroStrategy Desktop, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server.
• Expertise in CreatingSchema Objects(facts, attributes, Hierarchies, Transformations) to DevelopUserObjects.
• Expertise in DevelopingUser Objects(filters, prompts, metrics, Custom Groups, Consolidations) to develop Documents and reports.
• Expertise in CreatingDocumentfrom multiple Datasets likeGrid and graph.
• Expertise in creatingDocumentsandDrill Reports.
• Expertise in creatinginteractivedashboard Reports and Scorecardsto view personalized reports based on user requirements.
• Involved in MicroStrategy Narrowcast Server objects likeService, Schedule, Subscription set and Information Objects.
• Having knowledge in Data Warehousing concepts such as Dimensional Modeling( Star Schema & Snow Flake Schema), Data Marts, Fact and Dimensional tables.
• Having knowledge using DBMOTO ETL Tool & Informatica Power Center to create Transformations, Mapping for the ETL.
• Experienced with Multiple Databases like Oracle, SQL Server and Teradata.
• Exposure to client interaction, user - requirement analysis and User support.
• Team player with good interpersonal and communication skills and the ability to work in a team environment.
• Excellent multitasking capability, efficiently plan and prioritize projects with strong technical and business management skills.

TECHNICAL SKILLS

Business Intelligence: QlikView 11x/10/9x (Desktop, Server Publisher, Access Point), Nprinting for qlikview(14.1.03) MicroStrategy 9x/8x (Desktop, Web, Intelligence Server, Narrowcast Server, Object Manager, Dashboards)

Databases: SQL Server 2000/05/08/12, Oracle 11g/10g/9i/8i, MS ACCESS, Teradata 12x/V2R6.

Web Technologies: HTML, XML

Languages: Oracle and SQL.

ETL Tools: HIT Software DBMoto (V7x/8), Informatica Power Center 8x/7x

Operating Systems: Windows XP/NT/2000/98 & Windows 7

PROFESSIONAL EXPERIENCE

Confidential, Augusta, GA

QlikView Architect & Analyst

Responsibilities:

• Extensively worked to confirm and clarify requirements and business logic.
• Analyzed the reporting requirements with the business users and came up with the technical specifications.
• 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.
• Working with the management to identify the business reporting needs and also develop the architecture of prioritized reports by role that would have the most positive impact on the business
• Analyze customer requirements and develop proposals of technical solutions as needed.
• 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.
• Setting access permissions and assigning CALs based on users.
• 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.
• Involved in ERP system upgrade from MOVEX RPG to M3 JAVA system. For that upgrade designed qlikview applications required for the upgrade.
• Trained Distribution Center, Planning and Purchasing & Finance Teams on how to use qlikview applications.
• Worked on production tickets for the applications which are in production.
• Testing dashboards and data validation.

Environment: QlikView 11x/10(Desktop, Server/Publisher, Access Point), Nprinting for qlikview (14.03.), SQL Server/ 2008/12, AS400 ( Iseries), Windows XP/7, ERP system M3 Java & MOVEX RPG.

Confidential, Raleigh, NC

QlikView & MicroStrategy Tech-Lead/Onsite Coordinator

Responsibilities:

• Working with the management to identify the business reporting needs and also develop the architecture of prioritized reports by role that would have the most positive impact on the business
• Analyze customer requirements and develop proposals of technical solutions as needed.
• Migrated projects from MicroStrategy to Qlikview.
• Imported data from different sources like Oracle, SQL Server, MS Access, XML files, QVDs and flat files using OLE DB/ODBC.
• Developed Extract Scripts for generating the QVDs & Data models for the front end presentations using Binary Load.
• 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 complex 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.
• Used complex set Analysis, designed interactive charts like bubble, line, bar & Trellis etc.
• Configured and deployed the applications in the access point using QlikView Server/Publisher.
• Used to setup security using Section Access.
• Scheduled QVW reloads on Server/Publisher by creating tasks in the Source Documents. Used Loop and reduce concept for creating multiple apps based on the field.
• Created ops monitor apps for monitoring the refresh of the apps for checking if there are any failures. And used to troubleshoot the failures.
• Monitored the work done by offshore team
• Trained offshore team members and users on best practices and general “how to” procedures.

Environment: QlikView 10(Desktop, Server/Publisher, Access Point),Report Services,Dashboards, Teradata, MS-Excel, Oracle 10g, Windows XP/7.

Confidential, Grand Rapids, MI

MicroStrategy Developer

Responsibilities:

• Involved in Dimensional Data Modeling (Star Schema, Snow-Flake Schema)DataArchitecture, Business and Data Analysis.
• CreatedSchema Objects(facts, attributes, Transformations, hierarchies) and application objects (filters, prompts, metrics, Custom Groups, Object Prompts, Reports).
• Created Object Prompts, transformational metrics, Advancedfilters, custom groupsand used them for complex reporting purposes.
• Created three types of reports that is Dashboard Analysis Reports, Ad-hoc Reports and Enterprise Reports.
• Involved in the Creation Document from multiple Datasets like Grid and graph.
• Having knowledge in customizing SQL Query by setting VLDB settings at Different levels of Database Instances, Report and Metrics.
• Created different reports using different reporting features likeDrill-down, Drill-up, Drill-through, Prompts, filters.
• Involved in Maintenance and support for the project and end users.
• Extensively involved in Database Performance Tuning.

Environment: MicroStrategy 9i/8x, Report Services,Dashboards, Informatica 8.1/8.2/8.5/7 x, MS-Excel, Teradata, Oracle 10g, Windows XP/7.

Confidential, Topeka, KS

MicroStrategy Developer

Responsibilities:

• Ability to examine a problem from various angles and develop appropriate solutions that successfully balance Business goals, user needs and Technology constraints.
• Participated in the Schema Design like Star Schema and Snow Flake Schema.
• Involved in the creation of Schema Objects like Attributes, Facts, Transformations .
• Developed the necessary Application Objects for the project like Prompts, Filters, Custom Groups and Metrics.
• Involved in migration of objects from Development to QA and QA to Production Environments using Object Manager.
• Used Narrowcast Server to Deliver Reports.
• Set-up the narrowcast environment and createdservicesusingsubscriptionsets, schedules, Information objects.
• Design, Develop, Test and Implement MicroStrategy reports.
• Optimized Reports to improve the performance.
• Analyzed Business Requirements and interacted with the Business Analysts for designingad-hoc reports.
• Developed various Simple and Compound Metrics, Attributes, Facts, Hierarchies, Prompts, Filters etc.
• Worked along with MicroStrategy knowledge base to troubleshoot any report related issues.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

Environment: MicroStrategy 8x/7.5.1 (Desktop, Narrowcast Server, Object Manager) SQL Server, Oracle 9i.

Confidential

Oracle Developer

Responsibilities:

• Create Users and Responsibilities for Security.
• Involved in design of the application system.
• Involved in developing E-R diagrams, creating tables.
• Enhanced and developed several forms and reports using developer 2000
• Designed and developed library files (PLL) that are commonly used across the application
• Involved in design and development of Menu module
• Created database triggers to validate the complex integrity.
• Created stored procedures, functions and packages for implementing major functions of the system.
• Wrote scripts for populating the database tables with test data.
• Testing and documentation.
• Involved in design and development of Menu module
• Created database triggers to validate the complex integrity.
• Created stored procedures, functions and packages for implementing major functions of the system.
• Involved in design and development of Menu module
• Created database triggers to validate the complex integrity
• Wrote scripts for populating the database tables with test data.

Environment: Oracle 7.3, SQL, PL/SQL, SQL*Net, Windows NT/95, SQL*Loader, Import, Export.