Candidates About

 

Professional Summary:

Ø  An experienced professional IT consultant with around 11 years of experience in Analysis, Design, Development, Deployment in Data warehousing and using Business Intelligence Tools.

Ø  Experience with different BI tools like QlikView, Qlik Sense, Cognos and Spotfire.

Ø  Working as QlikView Lead for a team of 4 including 2 offshore resources.                                                                                                                  

Ø  7 years of experience as a Senior QlikView Developer and Administration.

Ø  1 year of experience as a Qlik Sense Developer.

Ø  3 Years of experience as a Cognos Report Developer.

Ø  Created a POC using Tableau.

Ø  Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team member.

Ø  Upgraded the Dev, QA, Production QlikView environment from 11.2 SR3 to 11.2 SR13.

Ø  Documented each step by step of the upgrade process and stored it in share point for future use.

Ø  Completed Annual QlikView DR Test with successfully and documented the testing process.

Ø  Created a POC using Spotfire and ADS.

Ø  Good experience in the Administration and support of the applications.

Ø  Used power shell scripts to deploy the application into QA and production and to move the qvw files across the environments.

Ø  Upgraded the Dev, QA, Production QlikView environment from 11.2 SR3 to 11.2 SR13.

Ø  Completed annual QlikView DR test with successfully.

Ø  Documented each step of the upgrade process and DR testing process and stored it in share point for future use.

Ø  Created multiple dashboards using QlikView functionalities and QlikView Objects.

Ø  Created few dashboards using Qlik Sense and deployed the dashboard across different environments.

Ø  Created few maps and charts in Qlik Sense to analyse the different repair shops inventory over geographic level.

Ø  Worked with Pivot tables and combo chats using Qlik Sense.

Ø  Extensively worked with Storey Telling feature.

Ø  Have worked on IBM Cognos tools like Framework Manager and creating reports in Cognos Reporting Studio and Query Studio.

Ø  Worked as a technical lead with Onsite and Offshore team with size of 4 with conducting weekly status meetings to make sure to meet the deadlines.

Ø  Providing End-User/Customer training in the QlikView product and delivered solution(s).

Ø  Supporting QlikView deployments with support team.

Ø  Conducting weekly meetings with the team to discuss on the status of on-going projects and the issues if any.

Ø  Have excellent skills on QMC by maintaining source documents and user documents folders and created tasks and scheduling those tasks by based on a schedule, on event from another task. Etc.

Ø  Having proficiency in moving the QlikView reports from one environment to another by maintaining consistent folder structure and by using global variables across different environments.

Ø  Has part of innovative ideas I have given a suggestion to Chrysler higher management to replace the daily status report of support tickets insisted of an excel to replace it with an automated QlikView dashboard.

Ø  Created the QVD Library, which will provide information about all QVD’s on Server like Source QVW, Record Count, Fields in QVD and I have automated it to run daily after business hours to pick and new tables, QVD’s across all the QlikView applications.

Ø  Having good skills in the NPrinting and created some excel reports using NPrinting in current project.

Ø  Have worked on Migrating QlikView 10 reports to QlikView 11.

Ø  Involved in Optimization of QlikView Dashboards with a focus on Visualization, usability, Performance, Long-term, Flexibility, Accuracy and Standardization

Ø  Work on internal QlikView initiatives and Mentoring Jr. QlikView Consultants.

Ø  Migrated several Cognos reports to QlikView

 

 

Technical Skills:

Tools & Technologies	QlikView: QlikView11&10, Developer Console, QlikView Management Console, QlikView Access Point, NPrinting, Qlik Sense Tableau: Tableau Desktop, Server Cognos: IBM Cognos 8, Cognos 10 Reports, Cognos Framework manager, Cognos Powerplay Transformer TIBCO Spotfire: Spotfire 6.5, ADS
Languages	SQL, Vb.net, C++, Java
RDBMS	DB2, SQL Server
Web Technologies	Web Services, HTML
Operating systems	Windows7/XP/Vista, Windows 2000/2003/2008 Server, Linux, UNIX.

Professional Experience:

 

Client: Penske Truck Leasing.                                                                                                                     Jul’17 – Till Date

Location: Reading, PA, USA.                                                                              

Role:  Sr. QlikView Developer

Project: Rental Admin

       Penske Truck Leasing Co., L.P. is a joint venture of Penske Corporation, Penske Automotive Group, and Mitsui & Co., Ltd. Headquartered in Reading, Pennsylvania. The firm serves customers in North America, South America, Europe, Asia, and Australia; among its services are full-service commercial truck leasing, truck fleet maintenance, truck rentals, and used truck sales. I am part of the Rental admin team and this team takes cares about Rental Utilization Measures and customer activity across US and Canada, I am developing multiple dashboards for them to track the utilization measures and customer activity across different regions.

Responsibilities:

·         Getting the requirements from customer and discussions on the time lines and target SLA’s.

·         Helping the team to understanding the requirements and business logic and project deadlines.

·         Conducting regular meetings with the team for any open issues, resolution ideas and bottlenecks.

·         Reviewing the code developed by the offshore team/other teams before promoting to QA and PROD.

·         Loading the data from different data sources (Oracle, Excel files) to create load scripts.

·         Created model with Extract, Transformation and Data Model in Qlikview.

·         Created transformation and data model as per the business need using different loading and data transformation techniques.

·         Created few KPI’s using set Analysis  to understand total truck count across different status.

·         Designed pivot tables, combo charts, Pie charts to understand different district’s business over the period.

·         Designed and developed QlikView dashboards using different Charts (Drill Down, Cyclic Field grouping), Sheet Objects (List Box, Input Field, Table Box, Calendar & Date etc.)

·         Created different kind of tables (Pivot, Straight) to analyse daily Rental/Lease utilization data across different regions.

·         Monitoring and cleaning of the QMC on timely basis to maintain load balance on the server.

·         Maintaining the Tenant Space on the server, usercals and controlling the QMC access for document administrators on Development environment.

·         Completed annual QlikView DR test with successfully and documented the testing process.

·         Deploying the code from Development environment to test environment and provide developer support for UAT teams till the code moves to production.

·         Designed best suitable UI to achieve user requirement in simple and user-friendly interface of reports

Created few combo charts for Assembly dashboard which will use for business to analysis the assembly line.

 

Client: GE Aviation.                                                                                                                                       Dec’15 – Jun’17

Location: Dallas, TX, USA.                                                                   

Role:  Sr. QlikView Developer

Project: ATO Engine Dashboard

       GE Aviation is a world-leading provider of jet engines, components and integrated systems for commercial and military aircraft. GE Aviation has a global service network to support these offerings. We have built a dashboard to track the orders for different types of engines for commercial and military, to monitor the inventory and the back order, this dashboard also used to monitor different stages of manufacturing of engines starting from vertical start to test complete phase and the dashboard is used for to calculate the On-Time Deliveries.

 

Responsibilities:

·         Active Lead role for team of 4 including 2 offshore resources.

·         Reviewing the code developed by the offshore team/other teams before promoting to QA and PROD.

·         Getting the requirements from customer and discussions on the time lines and target SLA’s.

·         Helping the team to understanding the requirements and business logic and project deadlines.

·         Used power shell scripts to deploy the application into QA and Production and back up of existing application and for deleting application content.

·         Monitoring and cleaning of the QMC on timely basis to maintain load balance on the server.

·         Upgraded the Dev, QA, Production QlikView environment from 11.2 SR3 to 11.2 SR13.

·         Documented each step by step of the upgrade process and stored it in share point for future use.

·         Worked with QlikTech during the upgrade for multiple issues (Usercals lost, QMC slowness, Access Point hang…etc)

·         Opened multiple tickets with QlikTech and closely worked with them on the post upgrade issues raised by different developers.

·         Developed an assembly Dashboard using Qlik Sense.

·         Transformed the data in Qlik Sense load scripts as per the business need.

·         In Qlik Sense load scripts used preceding load and Resident load for data transformation.

·         Designed pivot tables, combo charts, Pie charts using Qlik sense to understand different assembly lines progress over the period.

·         Worked with Pivot table and Straight Table to display overall quarter/year level OTD performance of different kinds of repair parts.

·         Designed best suitable UI to achieve user requirement in simple and user-friendly interface of reports

Created few combo charts for Assembly dashboard which will use for business to analysis the assembly line.

 

 

Client: Chrysler LLC.                                                                                                                                       Aug’12 – Nov’15

Location: Chrysler LLC, Auburn Hills, MI, USA.                                                                          

Role:  Sr. QlikView Developer/Lead- Business Intelligence

Project: Shared Services

                CI QlikView Dashboard is a comprehensive data discovery tool. The vision of this application is to host vehicle

 Characteristics from various Data sources. The application retrieves competitive information from multiple sources and

supports Product Planners search through the competitive landscape, performs competitive product analysis, compares

different competitive products for various specifications and attributes and enables Product planners to improve

efficiency, increase productivity with greater accuracy. This tool could be used by anyone interested in competitive

analysis and target setting.

                                            

Responsibilities:

·         Developed some excel reports using NPrinting tool.

·         Requirements gathering, Impact Analysis and solution designing to incorporate the Business requests.

·         Conducting weekly meeting with the team for status of the project for any open issues and discussing the possible solutions for complex requirements.

·         Creating mock up with the sample data.

·         Provided  KPI’s (Penetration) using set analysis.

·         Generated Reports using Global Variables, Expressions and Functions for the reports.

·         Reviewing the code which is developed by Jr Consultants in team and providing guidance on best practices for QV.

·         Encouraged team to provide innovate ideas which we will replace manual activities.

·         Participating with an active role in account level meetings to provide the status of the project.

·         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 (DB2, Oracle) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of QlikView.

·         Designed and developed QlikView dashboards using different Charts (Drill Down, Cyclic Field grouping), Sheet Objects (List Box, Input Field, Table Box, Calendar & Date etc.) and extensions

·         Used QlikView Functions (Date and Time, Join, Aggregation, Range, Ranking, Peek, Previous etc.) and Created Variables using LET, SET or control statements in the scripts

·         Developed Set Analysis providing custom functionality in QlikView Applications

·         Creating mock up with the sample data. Created model with Extract, Transformation and Data Model in Qlikview.

·         Created some Excel reports using NPrinting as per customer requirement.

·         Worked on modelling data as per business requirements. Eliminated Synthetic keys, ambiguous relationships and closed loops. 

·         Automated and scheduled daily/weekly/monthly data loads of QVW documents using QlikView Publisher and notified load status by email. 

·         Maintained and administered source documents, source documents sets, and user profiles and executed resource management services like Access point resources, distribution folders and email servers. 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. 

Environment: DB2, QlikView 11, Flat files, Data stage, SQL Server 2008, Microsoft Windows XP Professional, 2007 and UNIX.

 

Client: Chrysler LLC.                                                                                                                                         Sep’10 – Jun’12

Location: Hyderabad, India.                                                                               

Role:  Qlikview Developer- Business Intelligence

Project: Warranty Claim Analyzer (WCA)

The QlikView Warrant Claim Analyzer application essentially brings together information from the Warranty, PRAS, QNA

 and Transmittal systems. The Claim Analyzer displays data in such a way that it makes it easy for the user to spot

 potential issues for which there is a GAP. The Warranty Claim Analyzer is a new ICT developed application intended to

be a corporate  solution replacing the existing Microsoft Access departmental application. This current tool (Access) has a

base of  approximately 150 users, mostly engineers, CAG advocates and CST team members who use the Claim Analyzer

to identify new and emerging ordinary quality issues especially in the first three months of ownership (3 MIS).

 

Responsibilities:                     

·         Requirements gathering, Impact Analysis and solution designing to incorporate the Business requests.

·         Understanding the business functionality & Analysis of business requirements.

·         Created dashboards which switch between applications, which is created using transition states.   

·         Reports Validation against Database.

·         Improved the overall performance of the application and redesigned data model applying QlikView performance tuning techniques

·         Trained End Users on Using QlikView Tools.

·         Developed KPI’s and set analysis applications.

·         Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts and Bookmarks

·         Maintained both File and Data Level Security and implemented Data Reduction

·         Involved in Performance Tuning & Deployment of QlikView Applications

·         Automated QlikView jobs in QlikView Publisher and rolled out to QlikView Access Point and administered Security using Active Directory

·         Deploying the code from Development environment to test environment and provide developer support for UAT teams till the code moves to production.

Environment: QlikView 10 &11, DB2, Microsoft Windows XP Professional, UNIX

 

Client: Bristol-Myers Squibb                                                                                                                                Apr’08 -Aug’10

Location: Mumbai, India.                                                                    

Role:  IBM Cognos Developer- Business Intelligence

Project: Supply Data warehouse (SDW)

                    BMS is a pharmaceutical company focused on the development, manufacturing and marketing of prescription drugs used in the treatment of selected respiratory diseases and allergies. The aim of this project is to provide numerous computer-generated reports and custom analysis to BMS with actionable conclusions, including demographic breakdowns such as size of vendor and number of contracts negotiated with BMS per year.

                                      Supply Data warehouse is an effort to integrate all the business of BMS into a single warehouse. The base area after staging is in 3rd Normal form and upon that the business layer which is in dimension model for reporting purpose. ETL for staging,Reporting is done in Cognos. This data warehouse application is for supply chain management and it is used for measuring performance. This Cognos reports are used to track the shipments, shipment of drug details and container information and the database is DB2.

 

Responsibilities:

·         Source data analysis and identified business rules for data migration and for developing data warehouse.

·         Developed transactional reports in Cognos report studio for the Supply chain for Chrysler LLC as a part of the analysis of the suppliers.

·         Prepared framework model for the Supply Data warehouse as a part of the supply chain management Program.

·         Automated the reconciliation of invoices from Source Interfaces to the Data Warehouse in DB2 which was appreciated by the client.

·         Optimized the query of the reports for the various cognos reports in order to reduce the execution time of the reports from 4 minutes to 1 minute 30 seconds(approx.)

·         Implemented security on the Object based and Data based security in Cognos environment using third-party security provider ADS(Active Directory Server).

·         Handled the responsibility of release manager for Cognos code and contributed to establish a steady process for deployment of code using CVS.

·         Queries are written to facilitate the supply of data to verify Project artifacts results.

·         Involved in Unit Testing, System Integration Testing, Functional Testing and User Acceptance Testing.

·         Involved in performance tuning of the data load in production.

·         Creation of adhoc Cognos reporting to meet user needs.

Environment: IBM Cognos 8 Report Studio, SQL Server, Cognos Framework manager, Cognos Server Administration

 

Client: Exelon Corporation                                                                                                                                   Jan’07 –Mar 08’

Location: Mumbai, India.                                                                    

Role:  IBM Cognos Developer- Business Intelligence

Project: Sales and Controlling (S&C)

Exelon Energy Delivery serves about 1.5 million electricity and 430,000 natural gas customers in Southeastern Pennsylvania through PECO Energy. Exelon’s most important analytical reports are based on sales and statistics that allow in-depth analysis of consumer behavior patterns in terms of revenue and consumption. By applying Business Intelligence, the Sales and controlling departments discover which customer segments achieved these revenues.

 

Responsibilities:

·         <span style="font-family:Calibri, 'san