SUMMARY:

• 6+ years of Total IT experience. Currently Working in Confidential as IT Analyst.
• Having 4+ years of experience in BI solution development & deployment (QlikView)
• Have worked for clients like Mahindra & Mahindra, Firestar Diamond, Trafigura, Confidential Ergo General Insurance & ICICI Prudential
• Have worked on QlikView Desktop Client of version 10, 11 (IR, SR). Good Hands on ETL, Data Modeling & Dashboard Designing
• Good knowledge & practice on QlikView Server and QlikView Publisher
• Knowledge in NPrinting.
• Provided L2 Support for Globe Telecom in Manila, Philippines.
• Good skills include COMVIVA5.2, SQL, UNIX and knowledge on UNIX Shell scripting.
• Good Knowledge in Software Testing.

TECHNICAL SKILLS:

Operating System: Windows 7,10/Unix/Linux

Database: Oracle 10g, MS SQL Server using Toad/ SQL Developer

Tools: / Methodologies: QlikView 10, 11, NprintingTOAD, Putty, SecureCRT (Tool for Unix and Linux),HP Openview - (Application and Network Management).BMC Remedy 7.6.OBIEE 10g (BI Reporting Tool)

PROFESSIONAL EXPERIENCE:

Confidential

Associate Software Engineer

Responsibilities:

• Working on QlikView Tool for Data Warehouse.
• Generation of KPI s and Dashboards as per the Business Requirements.
• Modeling the Data given in the form of QVD s and generating the script.
• Extracting, transforming and loading(ETL) data into QlikView applications
• Data was extracted from SAP and stored in the form of QVD s.
• Designing the Frontend/UI and Representing the Data in the form of Graphs, Bar Chart. Pie Chart, Radar Chart, Pivot Table etc.
• Performing the Set Analysis to generate the correct data required by the Client.
• Implementing Section access and Hidden scripting for the Application Security.
• Unit Testing the Data, Report, KPI and Dashboard and getting the Issues fixed before presenting it to the Business.
• Developed Sales, Symphony dashboard and the same were represented to the business users

Confidential

Responsibilities:

• Working on Oracle Business Intelligence Tool (OBIEE 10g).
• Developing Report such as OBI, BIP, Direct DB, Direct DB with dashboard prompts as per the Client Requirement.
• Involved in Unit Testing of Reports for the Sign offs to the Client. Preparing Test cases which helps in Unit Testing.

Confidential

Responsibilities:

• Carried out Transition Phases like Knowledge Transfer, Front Shadowing, Reverse Shadowing & so on. Learnt about ITIL v4 Processes.
• Providing L1 Support to different applications like AMAX, Customer Care & Billing, New Frontier etc. Generation of Reports during the activities.
• Handling File System & DB Thresholds.
• Generation & Resolving of Trouble Tickets with appropriate resolution in BMC Remedy 7.6

Confidential

Responsibilities:

• Operations of the E-Recharge Node (COMVIVA-PRETUPS 5.2 for the new telecom Operator Etisalat DB).
• Daily Report generation to keep a check on important statistics like Network Stock, Channel Partner Details, Channel Transactions, Subscriber level transactions, Commissioning issues etc. as per the Business Requirements.

Confidential

Responsibilities:

• Working on QlikView Tool for Data Warehouse.
• Generation of KPI s and Dashboards as per the Business Requirements.
• Extracting the data from Navision System and Storing it in the form of QVD s
• Designing the Frontend/UI and Representing the Data in the form of Graphs, Bar Chart. Pie Chart, Radar Chart, Pivot Table etc.
• Performing the Set Analysis to generate the correct data required by the Client.
• Unit Testing the Data, Report, KPI and Dashboard and getting the Issues fixed before presenting it to the Business.
• Assigning CAL s to the Business Users through QlikView Management Console.
• Scheduling the task for extracting the Data from Navision and Reloading of Application based on the completion of previous task.

Confidential

Responsibilities:

• Development of Finance Dashboard, RI Reports, Agent Performance Reports, Geo Target Reports & Retail MIS.
• Extracting the data from DWH and storing it in the form of QVD s
• Finance Dashboard
• Requirement gathering, Data Extraction & Data Modeling for FINANCE Module
• Includes Policy & Claims data which includes Policy Count, GWP, GEP, NEP, NWP, Claims Paid & Outstanding. Deriving Loss Ration for LOB, Vertical, Sub Vertical and Zone wise
• YTD and MTD reports sliced & diced on LOB, Vertical, Sub- Vertical, Branch, Line, Channel, State & Time.
• Generated IRDA reports which were sliced on Monthly, Quarterly, Half Yearly & Yearly basis
• Validated the reports with user data and submitted the same to IRDA within the guidelines provided.
• Published the reports to QMC and implemented Section access to provide access of reports to limited users.
• RI Reports
• Requirement gathering, Data Extraction & Data Modeling for RI Module
• Generated RI Bible Reports for MTD, YTD and Previous YTD and providing access to business users.
• Development of GIC Obligatory Report w.r.t U/W Year showing Premium, Commission, Claims Paid & OS Losses.
• Development of Triangulation Report w.r.t U/W Year showing Quarter-wise Premium, Commission, Claims Paid & OS Losses. Created Macro to extract different U W year-wise reports into single excel and FTP the same to shared path.
• Agent Performance Report
• Implementation of extraction logic for incremental data.
• Generated Reports for today ()-2 & today ()-3 w.r.t different Groups.
• Automated the developed Reports and distributing the same in PDF format.
• Retail MIS & GEO Target Reports
• Implemented Macro to generate Retail MIS & GEO Target Report which extracts data, store it into Excels.
• Created Batch files to auto reload the application and copy the generated Excels to shared drive
• Application deployment, Scheduling of task, CAL Assignments, PDF Distribution and Email Trigger were handled through QMC