SUMMARY

• 5 + 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. Good at working with Data Warehousing and business intelligence tools for developing various reports using QlikView BI.
• Expertise in Installing and Configuring QlikView Desktop, QlikView Server and QlikView Publisher.
• Experience in server - sizing, clustering and load balancing to ensure scalable and robust BI implementations.
• Extensive experience with Data Analysis and evaluation of KPIs. Worked closely with business owners/stakeholders and provided recommendations on leveraging BI tools to make data-driven decisions.
• Establish standards for reporting, data modeling and visualizations.
• Provided recommendations to carry out performance tuning of applications to ensure optimal performance dashboards and applications.
• Experience in working through numerous cycles involving UAT and validation. Worked in close co-ordination with validation teams to design test cases. UAT cycles are designed to test applications for data, functionality and performance.
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Interacted with Customers for requirement gathering and effective analysis.
• Supported all phases of a project life cycle including analysis, design, development, testing, deployment of solutions, and postproduction support/maintenance functions.
• An organized professional with excellent communication and interpersonal skills.
• Self-motivated and enjoy working in a technically challenging environment. Have excellent Communication and interpersonal skills.

TECHNICAL SKILLS

BI Tools: QlikView BI, QlikSense, OBIEE, Business Objects.

Databases: MS SQL Server, Oracle, DB2, Teradata

Data Modeling Tools: Erwin, Visio 2000.

Operating Systems: Windows 95/98/2000/XP/NT, UNIX.

Languages: SQL, PL/SQL, C, Python

PROFESSIONAL EXPERIENCE

QlikView Administrator / Architect/ Developer

Responsibilities:

• Deployed QlikView Enterprise Framework (QEF) for IT department.
• Recommended and helped to create Multi- Tier QVD architect depending upon Applications.
• Worked as a QlikView Administrator which include maintains the QMC, Configure tasks; manage the licenses, Implemented Security for applications (Included Section Access, Dynamic Data Reduction and Document level security).
• Installed, Migrated and clustered new Servers, Monitored Metadata for QlikView Servers and Publisher using QlikView Governance Dashboard.
• Demo and restructured application for Mobile Devices.
• Recommended best Practices for Data Modeling, Design and Development of applications.
• Worked with Supply chain, Supply Operation, Pharmacy and IT as Subject Matter Expert (SME)
• Helped the Business User for Navigation the Qlikview Reports and taught users and Developers.
• Currently, working with 24 Core and 96GB RAM server and few more are in procurement process.
• For initial user acceptance of the tool, there are 110 Named CALs 20 Doc CALs, 2 Session CALs.

Environment: QlikView 11.x, SQL Server, TeraData, NPrinting

Confidential, Allentown, PA

QlikView-Developer

Responsibilities:

• Responsible for gathering Business Requirements and defining KPIs.
• Extracted data from the HR module of SAP using SAP connector.
• Developed dashboards depicting HR Data at Forest Labs. Dashboards are used by the Executive tier for critical decision making.
• Dealt with data size of 30 MB handling a volume of 1 million records in the fact table.
• Worked on QlikView Server and Publisher, to manage user access, schedule refreshing of documents, mount completed applications.
• Performed server sizing. Applications were refreshed on a monthly basis and used by a group of 60 users.
• Managed user access and security by implementing Section Access. Scheduled loads and distributions tasks using QlikView Publisher.
• Dashboards served to track KPIs such as Headcount, Vacancies, Turnover and Promotions within the organization.
• Trending and Point-in-time reporting techniques were used to monitor KPI s through the dashboard. Extensive use of Set Analysis and flags was made for reporting.
• By use of Star-Schema and adherence to best practices in QlikView, optimum performance of the dashboard was ensured.
• Calculation and defining server sizing for optimal performance of QlikView dashboards.

Environment: QlikView 11.x, SAP Connector, SAP HR Module.

Confidential, NYC, NY

QlikView-Developer

Responsibilities:

• Involved in development of existing legacy reports intoQlikViewapplication.
• Analyzed requirements, design functional and technical specs from documentation of QlikView application requirements from end users
• DevelopedQlikViewDashboardsusing Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, Statistics Box, Multi Box and Calendar & Date Island
• Configured and deployed the application onQlikViewserver and Imported data from different sources like Oracle, SQL Server, XML files, QVDs and flat files using OLE DB/ODBC.
• Designed data model inQlikView. Created multiple layer QVDs to get the desired data model
• Resolved synthetic keys.Used Mapping load,Apply Mapto get descriptions in fact table based on Id’s. Used resident load, preceding load, cross table and so on.
• Created Combo charts, showed reference line on the charts to show the baseline Goals.Created gauge charts, mini charts. Created containers, Search object and Current selection box
• Used variables to do calculations. Used variables in Set Analysis in expressions.Used Set modifiers. Used alternate state to do comparative analysis.
• Performed different tasks like extraction, reload tasks, reduction and distribution tasks based on Market drill-down using theQlikViewPublisher.

Environment: QlikView 10.x (Upgraded to version 11), Oracle, SQL Server2008, MS-excel, MS-Word.

Confidential, Warren, NJ

QlikView-Developer

Responsibilities:

• Responsible for data analysis and documentation. Created various PoCs to introduce QlikView as a BI dashboarding tool to the Institutional Clients Group (ICG) at Confidential .
• Understood the requirements from the users. Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards.
• Managed QlikView reporting environment which includes QlikView Server, QlikView Publisher and QlikView Desktop.
• Used advanced scripting, set analysis, VBScript and JScript macros, advanced aggregation functions and advanced charts for applications.
• Performed requirements gathering, including KPI selection and BRD development.
• Created mock-ups showing the intended functionality, visual aspects of the dashboards to be developed.
• Developed dashboards pertaining to KPI monitoring using QlikView 10.
• Developed complex QlikView scripts to build model, to support various KPIs with time over time and trending analysis.
• Worked on 7 dashboards for marketing and finance.
• Performed trending and variance analysis on stock-related data.

Environment: QlikView 10, Oracle, SQL Server, SQL Loader.

Confidential, Santa Clara, CA

Business Analyst and Report Developer

Responsibilities:

• Responsible for supporting various technological aspects in BI implementation.
• The KPI s monitored by reports pertained to product sales analyzed by various dimensions such as Region, Customer Demographics, Doctors prescribing, price range of products.
• Worked step by step with the business to produce the needed business requirements.
• White boarded closely with the business in order to map out the most valuable visualization elements on the reports and dashboards.
• Created ad-hoc reports from SQL queries based on user requirements.
• Assisted client on useful business cases to display on the reports.
• Reports development to display useful customer, product related information. Developed 10 reports during the stint.
• Got a detailed understanding of business functionality and took the responsibility of preparing the Functionality Test Plan which was used by testing team in their testing process.
• Worked with Business Objects as reporting and Dashboarding tool, and SQL Server as the database.

Environment: SQL Server, Visio, MS Excel, Business Objects

Confidential, NJ

Business Analyst and Report Developer

Responsibilities:

• Designed and developed the programs in business intelligence tools that support client requirements
• Designed and developed SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Trained and managed developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.
• Conducted code walkthroughs and review peer code and documentation.
• Worked with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
• Developed project management solutions and process efficient projects for customers with suitable technology
• Developed and maintained proper levels of documentation and contribute to documentation and accounting activities.