QlikView, QlikSense , MSBI stack lead Programmer
JP Morgan Chase & Co.
Total years of experience :16 years, 7 Months
Exceptional organizational, analytical and time management skills
Excellent ability to translate client requirements into effective solutions
Developed Executive, Analytics and daily dashboards in QlikView delivered through the web, AJAX.
Developed complex financial dashboards like Capital Management (B3S, B3A, Modified Advanced Capital, Blended Capital, RWA’s), Stress Testing dashboard (forecasted Baseline, Adverse, Severely Adverse, FED vs Internal), Travel & Expense (Airfare, Lodging, Entertainment, Client Spent, missed savings, Actual VS Budget ), Client Experience (Ease of doing business)
Designing the data model in QlikView to accommodate the application requirements.
Implemented complex nested aggregations using SET Analysis, Calculated Dimensions, Master Calendar, and Link Tables.
Implemented the complex security based on multiple fields using Section Access (granular key’s)
Used Complex charts, YTD, MTD, QTD trends, Svg Maps, Word Cloud & .QVS files.
Implemented incremental load having an option to delete and retain the data based on business requirements
Mentored staff new to QlikView via one-on-one discussions, group training and code reviews
Considered the QlikView Expert for the Business Development Team
Developed various ETL solutions using SSIS sourcing Oracle, CSV and SQL
Responsible for Enterprise Business to Retail & Corporates
Develop business plan and processes for Corporate Sales
Develop and deploy Sales Management System with focus on relationship management
Driving teams for Monthly and Quarterly targets
Handling all new franchise enquires
Maintaining MOV (minimum order value)
Effective stock management
Responsible for customer satisfaction
Responsible for focus on process adherence
Tracking competitor activities
Facilitate intra departmental activities viz. pre-sales, service delivery, operations etc
Management of ARPU.
Churn Management
Effective management of team of 25 people for target realization.
Ensure that targets are achieved proactively with the help of DMS software developed indigenously.
Responsible distribution and placement of all the products.
Increase the market share and meet the revenue goals of the company
Worked on existing projects based ASP.Net handling requests for change, defect/ bug correction
Create Unit Test cases, Integration Test Cases, System test cases
Involved in Defect Prioritization.
Perform Unit, Integration testing (manual), System Testing, Functional Testing
Involved in end to end CMMI level 3 assessment of the Software Division team
Development of process improvement tool
Worked as configuration controller and was responsible for version controlling of CI’S
Creating directory structure in VSS as per PMP (CM Plan)
Giving access rights to the folders created
Baseline the CI’s at every milestone
Circulation of Audit findings
Creation of Staging & Integration testing environment
Projects:
Security Admin
Technology Used (ASP.Net, SQL 2003)
Project Description:
Raise work requests as Projects, Incidents and BAU for Hardware, Software, folder access Profiles etc
Follow the defined business flow for approval, rejection of requests
Assignment of the request that are in the queue to different analysts
Transfer the requests to concerned departments
Trigger alerts, if SLA researches the defined limit
Provide reports for analysis
Provide admin rights for access to various modules
Leave Management System
Technology Used (ASP.Net, SQL 2003)
Project Description:
Leave management of all the employees starting from applying till approval/rejection
Functionalities like Optional leave, Sick leave and remaining leaves that can be enchased/ taken