Candidates About

 

Binoy Sharath.A.S.

 

PROFESSIONAL SUMMARY

Ø  Having over 16 years of IT experience (QlikView,Informatica,Oracle,SQL Server,Teradata).

Ø  Having 5 years of experience as QlikView Developer

Ø  Hands on experience in analysis, design, development of Dashboards using QlikView

Ø  Eminent with Functional Areas like Pharmaceutical, Healthcare, Banking and Finance.

Ø  Extensively worked with QlikView Server Enterprise Edition to Develop reports for good analyzing Purpose.

Ø  Extensive experience in extraction, transformation and loading of Data directly from different heterogeneous source system like flat files, Oracle, SQL-Server

Ø  Good communication skills and technical documentation skills.

Ø  Good working experience on Qlikview Objects like Pivot Table, Straight Table, BarChart, ComboChart, LineChart, Multibox, Container.

Ø  Having good knowledge on optimization techniques in Qlikview.

Ø  Having experience on optimizing the Queries and converting these queries into Qlikview script.

Ø  Hands on experience with thorough knowledge of scripting, data source integration and advanced GUI development in QlikView.

Ø  Exceptionally well organized, strong work ethics and willingness to work hard to achieve employer’s objectives.

Ø  Solid understanding of Data Warehousing concepts. Strong experience in design & development of Business Intelligence / Data warehouse reporting.

Ø  Strong experience in designing and developing dashboards using QlikView by extracting data from multiple sources (SQL-Server, Flat files, Excel, QVD).

Ø  Extensive experience with QlikView sheet objects, scripting, and optimizing applications and building qvd’s and qvw’s.

Ø  Strong understanding of Dimensional Modeling technique, Multi-Dimensional Database Schemas like Star, Snowflake Schema, Fact and Dimensional tables, Section Access, Set Analysis in QlikView and DW concepts.

Ø  Proficient in Informatica - Source Analyzer, Warehouse Designer, Mapping Designer and Transformation Developer and Oracle,SQL Server,Teradata.

 

TECHNICAL SKILLS

Tools                          :   QlikView 10, 11, 12 QlikView Server and Publisher

ETL Tool                        :    Informatica Powercenter 9.5

Languages                  :    SQL, VB Scripting

            Database                    :    Oracle 11g, SQL Server 2014, Teradata

            OS                               :    Windows XP/2007, Win 2003/08/2012Server, Linux, Unix

           Exposure                      :    QlikSense, Tableau 8.2

        

EDUCATION

Ø  Masters in Computer Management from Pune University, India.

Ø  Bachelor of Science from Calicut University, Kerala. India.

 

PROFESSIONAL EXPERIENCE

 

Ø   Worked as Sr.Software Engineer for  ETS TECHNOLOGIES, Bangalore, India from JUNE 2007 to MAY 2018

Ø  Worked as Software Engineer for MBS software, Bangalore, India from April 2002 to May 2007

 

Projects

 

Project #1:

 

Sales Analysis Dashboard

Client                          :   Pfizer

Environment              :   QlikView11, Oracle 12c

Duration                     :   Nov 2016 to May 2018

Description: Pfizer maintains the information about sales, profits and contacts of customers. Using Sales Analysis database, the system will analyze the sales and Inventory and generates reports for Sales Partner wise, Region wise in month wise, Quarter wise and year wise. The resulting model gives us an idea about growth in profit, prediction about increase in sales. This dashboard completely gives an analysis of Compliance Summary where we can measure the data Quality. This Dashboard uses these reports to do trend analysis, data processing and quality checks on the distributors’ data.

 

Responsibilities:

Ø  Created Dashboard using different components of QlikView like List boxes, Multiboxes, slider, buttons, charts (Bar, Line, Combo, Gauge, Scatter, Straight/Pivot table) etc.

Ø  Extracted information from disparate data sources like Excel, QVD, flat files etc. by using different ETL script statements like Resident, Concatenate, Join, Keep, Mapping Load, etc.

Ø  Implemented set analysis, what if analysis.

Ø  Extracted data from Oracle, SQL Server Databases, MS Excel and load data into QVDs (Raw QVDS).

Ø  Involved with the QlikView team in gathering and analyzing business requirements from various sources, ensuring the business needs and delivery feasibility.

 

Project #2:

Inventory & Sales    

Client                          :   Hutchison telecom, Australia

Environment              :   QlikView11, Oracle 11g.

Duration                     :   Apr 2015 to Oct 2016.

Description:    Hutchison principal activities include networked IT services, local national and international telecommunications service and higher-value broadband and internet products and services. Hutchison consists principally of four lines of business: Hutchison Global Service, Open Reach, Hutchison Retail and Hutchison Wholesale. Wizard Analytics primarily caters to the reporting requirements of Wizard application. Billing, Order Processing, Services, Activity and Asset area of wizard application are covered to provide key business measures and inference to the users. Various dashboards/reports on the above mentioned areas are available for the users. Additionally few users (Power users) are provided Answers access in Analytics where in the user has the freedom to construct their own reports based on their business requirements.

Responsibilities:

Ø  Extensively used QlikView Enterprise Edition for designing implementing reports.

Ø  Data Modeling is key to success of dashboards/reports was the built with minimal support.

Ø  Extracted data from Flat files, Oracle and enhanced according specification documents.

Ø  Created Dashboard using different components of QlikView like List boxes, Multiboxes, slider, buttons, charts (Bar, Line, Combo, Gauge, Scatter, Straight/Pivot table) etc.

Ø  Extracted information from disparate data sources like Excel, QVD, flat files etc.. by using different ETL script statements like Resident, Concatenate, Join, Keep, Mapping Load, etc.

 

Project #3:

FIS

Client                                    :   ING Group

Environment                        :   Qlikview 11, SQL SERVER 2008

Duration                               :   Mar 2014 to Mar 2015

Description:   ING offers personal and business banking services. The company offers checking, savings, individual retirement, health savings, and money market savings accounts, as well as certificate of deposit. Its loan portfolio includes mortgages, real estate, business, construction, insurance premium financing, home equity, and community lending. The company offers online banking, electronic statement, online bill pay, financial software, telephone banking, visa check card, credit card, merchant, lockbox and mobile banking. Its financial services include personal investing, retirement planning, life insurance, long-term care and disability and wealth and estate services include investment management, comprehensive financial planning.

Responsibilities:

Ø  Extracted data from SQL Databases, MS Excel and load data into QVDs (Raw QVDS).

Ø  Data Modeling is key to success of dashboards/reports was the built with minimal support.

Ø  Created Dashboard using different components of QlikView like List boxes, Multiboxes, slider, buttons, charts (Bar, Line, Combo, Gauge, Scatter, Straight/Pivot table) etc.

Ø  Extracted information from disparate data sources like Excel, QVD, flat files etc.

Project#4

ACER Sales Metrics

Client                          :   ACER

Environment              :   QlikView 10, Oracle 11g.

Duration                     :    Mar 2013 to Feb 2014

Description: ACER manufactures Laptops. ACER uses these reports to do trend analysis, data processing and quality checks on the distributors’ data. The reports were further used to do Market Based analysis and these reports plays a major role in enabling various stores to view the data at a lowest level and help them to make decisions to bring more revenue to company with new policies.

Responsibilities:

Ø  Gathering and analyzing the business requirement document.

Ø  Developing, enhancing, re-engineering, maintaining and supporting QlikView applications

Ø  Develop all kind of Graphical reports like various chart and Dash board.

Ø  Modifying the Existing Set expressions as per the client requirements.

 

 

Project # 5

 

Client              :   JP Morgan Chase Bank.

Title                 :   CLC (Chase Loan Center)

            Role                 :   ETL Developer

            Environment   :  Informatica,Oracle,SQL Server,Teradata

           Duration         :  24 months

           

JPMorgan Chase & Co. (NYSE: JPM) is a leading global financial services firm with assets of $1.4 trillion and operations in more than 50 countries. The firm is a leader in investment banking, financial services for consumers, small business and commercial banking, financial transaction processing, asset management, and private equity.

A component of the Dow Jones Industrial Average, JPMorgan Chase has its corporate headquarters in New York and its U.S. retail financial services and commercial banking headquarters in Chicago. Under its JPMorgan and Chase brands, the firm serves millions of consumers in the United States and many of the world's most prominent corporate, institutional and government clients.

Chase Loan Center gives detailed information about Loans and Advances providing bank to its customers. Chase Loan Center provides a single system to import or enter loan data underwriting and registering with Chase. Also, customer can relock and extend rates online.

Responsibilities:

 

 

Ø  Involved in Requirements gathering.

Ø  Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer and Transformation Developer.

Ø  Imported data from various sources transformed and loaded into Data Warehouse Targets using Informatica.

Ø  Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.

Ø  Extensively used Transformations like Router, Aggregator, Source Qualifier, Joiner, Expression, Aggregator and Sequence generator.

Ø  Scheduled Sessions on the Informatica Server using Workflow Manager and Workflow Monitor.

Ø  Worked with different sources such as Oracle, MS SQL Server and flat files.

Ø  Knowledge of slowly changing dimension tables and fact tables.

Ø  Writing documentation to describe program development, logic, coding, testing, changes and corrections.

Ø  Optimizing the mappings by changing the logic to reduce run time.

 

 

Project #6

 

Client                   :  JP Morgan Chase Corporate Investment Bank

Title                      : JPMC-CIB

Environment       :  Informatica,Oracle,SQL Server,Teradata

Role                     :  ETL Developer

Duration              :  24 months

 

Description:

 The biggest US banking magnet JP Morgan Chase’s Corporate Investment Banking arm wanted their three complex banking applications migrated from developer to .Net environment. The application had about 400 forms and 250 reports of various complexities.

 

 

Responsibilities:

 

 

Ø  Understanding the User Requirement Specifications.

Ø  Developed number of informatica mappings, mapplets and reusable transformations to facilitate one time, daily, monthly and yearly loading of data.

Ø  Used various transformations in informatica.

Ø  Created tasks and workflows in the workflow manager and monitors the sessions in the workflow monitor.

Ø  Implemented exception handling/error handling and Restart-Recovery logic to subject area wise loads.

Ø  Developed Informatica mappings for TYPE 1 Slowly Changing Dimensions.

Ø  Responsible for identifying test case scenarios for unit testing.

 

 

Project #7

 

Title                     :  Commercial Bank of Dubai –Internet Banking (CBD-IB)

           Duration             :  24 months

           Role                    : ETL Developer

           Environment      : Informatica,Oracle,SQL Server

 

Description:

            Commercial Bank of Dubai –Internet Banking (CBD-IB) is an online banking application. CBD-IB has four main modules and each main module contains its own Sub modules.

a)    ACCOUNT INFORMATION           b) CUSTOMER SERVICE

c)    INFORMATION MODULE             d) CHANGE PASSWORD

 

 

Project # 8

 

Title                    :  MedRural.com     

Duration            : 12 months

Role                    : Developer

Environment      : Oracle,D2k, Forms, Reports , SQL*Loader

 Description:

MedRural.com is a complete health based portal. It aims at taking the modern medicine to the doorstep of common men. It empowers the doctors, practicing medicine with the information on latest trends in the fields of medicine & surgery. This project has 4 main modules 1) Health Care Professionals 2) Lab operation 3) Billing 4) Your Health.

Project # 9

     Client                              :  Henri Cardiac Centre

     Title                                 :  Hospital and Payroll 

     Duration                          :  36 months

     Role                                  : Developer

     Environment                   : Oracle,D2k, Forms, Reports , SQL*Loader

   Description         :

Hospital and Payroll Management System provides full automation of the hospital including the payroll management of the employees. It provides the facility of different types of report generation on demand, backup of whole database and scheduling of services, Doctor Appointments, In-Patient, out-patient and payroll on the basis of database that keeps the information about Patients, Consultants, Ward, Organization, Area, Material, Department and Various types of services provided by the Hospital. It was divided into six modules:’ In Patient Module’, ‘Out Patient Module’, ‘Lab’, ‘Inventory Management’, ‘Payroll’ and ‘Pharmacy’.

 

 

 

 

 

Project #10

Client              :   Atlantic Duncan’s

Title                 :   Ethosbaby.com

            Duration         :   24 Months

            Role                 :  Developer

            Environment  : Oracle,D2k, Forms, Reports , SQL*Loader

   

 

Description: Ethosbaby.com is an online shopping website for baby care products. Customers can purchase goods, which they want online. Search facility exists for quick search of goods available and cost of each product. The shipping cost of the ordered products depends upon the weight of the order and national and international orders. Credit/Debit cards will be charged once the order has been dispatched. Administrators can dynamically update the quantity and cost of goods available and they can also and add new products to the existing database. Data will be stored in backend with Oracle Database.