SUMMARY

• Extensive experience with Data Analysis and evaluation of KPIs.
• Development, enhancement, re - engineering, maintenance and support of QlikView applications.
• Hands-on experience in end to end development of QlikView projects.
• Managed installation/version upgrade of QlikView and monitored licensing to users.
• Adept at solving complex problems through a systematic approach that uses innovation and partnering combined with project management principles to maximize return on investment (ROI).
• Experience 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.
• Capable of leading a small group of developers. Adept at coordination and delegation of tasks.
• Good knowledge of Data Warehouse and BI Infrastructure.
• Reporting and Dash Boarding experience.
• Strong Analytical and Problem Solving Skills.
• Strong Communication and interpersonal skills

TECHNICAL SKILLS

• QlikView
• SQL
• Informatica
• Tableau
• C
• C++
• C#
• HTML
• Java Script
• CSS
• SQL Server
• Teradata
• Oracle 10g/11g
• MySQL
• ASP.NET
• Wordpress
• Right Now CRM

PROFESSIONAL EXPERIENCE

Senior QlikView Developer / Administrator

Confidential, MI

Responsibilities:

• This QlikView Project is for Finance Department, which includes Revenue, Closings, Viability, Cost and Gross Margin.
• Worked with a team of five onshore Members, three offshore QlikView developers and one Database Admin.
• Analyzed the database and provided detailed information on their operational and Forecast for future years.
• Several KIP’s were integrated to give Final Loan Scorecard from Agent Score, Asset Quality, Risk, Compliance, Profitability, Funding Ratio, and Funding Volume.
• Multiple levels of Hierarchies are implemented such as Verticals, Product, Region, Partner, Customers and Service Hierarchy etc.
• Maximum Application size is 4.5 GB, with 56 Revenue related fields, 200 million rows and associated with 98% data density.
• Worked with 40 core processor with two 1TB RAM server and two 256GB RAM servers, having monthly refresh.
• Was actively in the Server migration and the Fresh QlikView Installation process.
• Multiple tier of QVD architecture is implemented depending upon the complexity of the application and the final application reload duration was 4 Hours.
• The application is used by 46 Named CALs and 30 Document CALs licensed users with additional session licensed users as needed.
• Task set up are done using QEMC and created architecture for the interdependent applications and execute in proper order.
• Ad hoc excel reports are created based on the business user requirements.
• Forecasting model is created by using booking, revenue applications and created 4 year Forecast model and successfully implemented in QlikView.
• Worked with QlikView 11.x, SQL Server, TeraData, Excel, CSV files.

Senior QlikView SME / Developer / Administrator

Confidential, CA

Responsibilities:

• 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.
• Recommended best Practices for Data Modeling, Design and Development of applications.
• Demo and restructured application for Mobile Devices.
• Created Project Management and Business Requirements Document (BRD) and created test cases and memory foot print (RAM usage) for few applications. Set up NPrinting for distribution of Reports.
• Helped the Business User for Navigation the Qlikview Reports and taught users and Developers.
• Develop and evolve the overall vision for Enterprise Information Lifecycle including data strategy, architecture, rationalization, quality, metadata and advanced analytics to support strategic business initiatives
• Recommended and helped to create Multi- Tier QVD architect depending upon Applications.
• Was part of the team in estimating the server sizing, performance tuning.
• Worked with Supply chain, Supply Operation, Pharmacy and IT as Subject Matter Expert (SME)
• Worked with 24 Core and 96GB RAM Server.
• For initial user acceptance of the tool, there are 210 Named CALs 20 Doc CALs, 2 Session CALs.
• Worked with QlikView 10.x, SQL Server, TeraData, DB2, Informix, MySQL, MS Access, EssBase, Excel, CSV files.

QlikView Developer

Confidential, KY

Responsibilities:

• Understanding the requirements from the users. Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards.
• This Project is related to marketing analytics, concern about the marketing of various insurance products and accepted pattern of the customers.
• Leading team of 4 Member, which includes two offshore Qlikview developers, one Database Admin.
• Providing executives and operational users with powerful analytic capabilities and detailed information on their operational and marketing performance.
• The Process was Agile and strict time line oriented. Worked closely with Project manager and scrum master.
• Created PDF push reports based on ‘loop and reduce’. Alternatively, wrote VB scripts to perform the same (based on requirement of user). Monthly distributed to specific user group via email, through publisher.
• Extracted data from multiple complex hierarchies from cross table flat files and websites.
• Application size is 39MB, with 178 demographic fields, 5 million rows of census data, associated with 95% data density.
• Created Heat map with alert mechanism. Various KPI graphs were drawn. Kept eye on Qlikview best practices.
• Worked with 32 core processor with 200GB RAM server, having daily refresh. 2-tier QVD architecture is implemented and the final application is taking 27 second to reload.
• The application is used by 20 CAL licensed user, with additional session licensed users.
• Document event trigger and field event triggers is created. Incremental reloading is implemented.
• Created Document for the project planning and production Interface Documentation.
• Four dashboards were created, along with helping other team to create Qlikview reports.
• Successfully passed through the QA Environment and implemented on Production and post production support.
• Worked with QlikView 10.x and 11.x, SQL Server, Oracle, Netezza, Excel, CSV files.

QlikView Developer

Confidential, CA

Responsibilities:

• Interacted with end-users to collect requirements and acquire the necessary domain knowledge to become a subject matter expert. Trained and provided support to end users.
• Performed analysis, documentation, for calculation for various attributes.
• 3 Executive Dashboards depicting Sales and Inventory data were created during the stint. Dealt with a data volumes ranging from 20 to 50 million records.
• Worked on Qlikview Server and Publisher, to manage user access, schedule refreshing of documents, mount completed applications.
• Created PDF push reports and setup email distribution on QlikView Publisher 9.
• Reviewed QlikView error logs and provided production support.
• Performance tuning of dashboards was carried out to limit the response time to well under 5 seconds.
• Helped end users to design test cases and worked through multiple UAT cycles.
• Promoting dashboards to production environment and manage user access.
• Calculation and defining server sizing for optimal performance of QlikView dashboards.
• Worked with Qlikview 9.x, upgrade to 10.x, SQL Server 2008, Excel files, flat files.

QlikView Developer/Business Analyst

Confidential, NY

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 Confidential . 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 with extensive use of SET Analysis.
• By use of Star-Schema and adherence to best practices in QlikView, optimum performance of the dashboard was ensured.
• Performed data validation and worked with users through the UAT cycle. Dashboard was subject to rigorous testing to ensure that data, functionality, look and feel, and performance complied with user requirements.
• Calculation and defining server sizing for optimal performance of QlikView dashboards.

Business Analyst and Report Developer

Confidential

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