Work History

Work History
Nov 2009 - Dec 2014

Senior Consultant

Capgemini
  • Performed detailed analysis of source system data and modeled that data in to QlikView.
  • Responsible to Design, develop, and maintain QlikView scripts, its frontend and access rights.
  • Interpret written business requirements and technical specification documents.
  • Work directly with business units to define and prototype QlikView Applications using agile and evolutionary prototyping development techniques.
  • Design and Develop Qlikview Role-based application, its solution specification and security implementation covering KPIs from Orders, Inventory, Sales and Finance. Coordinate and work closely with Qlikview architects to follow best practices.
  • Extracting, transforming and loading data from multiple sources and integrate into QlikView applications. The data is staged in .qvd files and then loaded by one or more qvw application.
  • Managed un-structured sources like excel files with data integrity issues and standardized those as much as possible through close co-ordination with business process owners and accessing their regional data marts to minimize integrity issues.
  • Leveraged existing security solution that requires user’s access right information to be retrieved from external excel file on the fileshare. This greatly reduces administration as number of users was fairly large.
  • Coordinate with QlikView Admin team, to loop, reduce and distribute applications on access point web portal.
  • Collaborate extensively with business to build a 360 degree Customer Insight data mart, implementing it on Oracle 11g platform and maintain design documents. The data mart is pre processed data platform for data mining.
  • Data evaluation and Preparation of hundreds of attributes using Oracle sql and Pl/Sql for Analysis-Base-tables that mainly include Customer Profiles and Subscription Profiles to facilitate Predictive modeling and Data mining on SAS platform.
  • Performance tuning of Sql queries and database objects such as tables, indexes, views packages and procedures.
  • Develop and enhance Extraction, transformation and loading interfaces from disparate sources to Data-warehouse using Pl/Sql and propriety ETL tool similar to Sql*Loader.
Nov 2007 - Nov 2009

Sr. Analyst/ BOBJ Architect

WNSGS Pvt. Ltd.
  • End-to-End lifecycle implementation of Business Objects XIR2 Enterprise, service packs, hot fixes and version upgrades on Windows Server. Configuration, Administration, Auditing and trouble-shooting of all BO servers/services.
  • Complete migration/replication of reports, universes, folders, users, user rights from one environment to the other (Dev, QA, and Production) in BOXIR2.
  • Implemented SSL Authentication and Configured End to End SSO by Windows AD authentication with Kerberos, NTLM and Site Minder.
  • Managed Enterprise wide Users, User rights, User Profiles, Folders, Categories, Security, Group Level and Folder Level rights, Row Level, Object Level security in CMC & Universe, Role based Scheduling and Publishing of reports.
  • Responsible for Creating, refreshing & scheduling Metrics, creating interactive analytics, creating personal dashboards, corporate tiered dashboards and adding compound analytics through Dashboard Manager, distribution of dashboards as per Role or Region.
  • Responsible for Measuring and tracking Key Performance Indicators (KPIs) and representing them in graphical interactive Dashboards.
  • Responsible to Export and import data, graphs to MS Excel through Crystal Xcelsius 4.5 using QAAWS for detailed analysis.
  • Have used charts, alerters, selectors, applied formatting and added graphics & animations in Xcelsius for end user analysis.
  • Designed and Developed MIS reports suitable for multi dimensional analysis by using various techniques like slice and dice, drill up, drill down, drill through, setting alerter, setting hierarchies, sorting, cascading prompts, and creating master-detail
  • Designed and Developed complex reports featuring Cascading Prompts, multiple disparate data sources, Union, Intersection, Merged dimensions, designed reports using Mobile BI (MOBI) and live office
  • Improved the performance of reports by tuning Queries, Universes by using Index Awareness, Aggregate Awareness, Short Cut Joins, and Derived Table, multi-pass sql queries.
  • Designed and developed customized SSO enabled Infoview portal application using Java based BOE-SDK to handle highly complex reports while improving performance.
  • Gained exposure to other SDKs like REBEAN – Java SDK, Desktop Intelligence SDK and Universe Designer SDK
  • Utilized openDocument and openAnalytic feature for web integration/url reporting.
  • Developed ETL routines in SSIS to consolidate data from multiple disparate sources (excel, SQL database, Oracle, csv etc.) in order to provide consolidated view to Management from different business processes.
  • Done a POC on rigorous Security solution so as to enable multiple clients to use a shared BOE server.
Jun 2005 - Sep 2007

Sr. Software Engineer - BO Developer

Nucsoft Ltd.
  • Developed some business critical reports like Tax-Form16A report for India’s corporate customers, Interest advice report, Ageing-Analysis-Report.
  • Developed and enhanced canned operational reports based on universe and complex Free hand SQL reports.
  • Incorporated various reporting techniques like slice and dice, drill up, drill down, drill through, setting alerter, setting hierarchies, sorting, cascading prompts, Cross-Tabs, charts, creating master-detail/section report.
  • Involved in number of enhancements which also includes modifications to complex universes and migration of reports to newer version.
  • Optimized FH-SQL report performance by analyzing ‘explain plan’ and using Oracle ‘Hints’
  • Responsible for designing the Universe, created Contexts and Aliases for resolving loops in the Universes to improve performance.
  • Linking the Kernel-Derived or Master-Derieved Universes to share common objects. Updating and maintaining Universes based on changing user requirements and data source change.
  • Optimized the existing Universe by creating oracle views, materialized views and used them in universe.
  • Extensive use of Oracle Stored Procedures while creating reports, modifying existing procedures as per the report specifications

 

Education

Education
Sep 2004

Bachelor of Engineering

Mumbai University, India

 

Skills

Skills

OS

Basic Unix, Basic Windows Server

Web/Application Servers

Tomcat, IIS

Development tools

Toad, Sqlplus, SQL Server Management Studio (SSMS), SQL Navigator, Business Intelligence Development studio (BIDS), Netbeans, SubVersion (svn), Team Server Foundation (TSF)

Languages

PL/SQL, T-SQL, Qlikview’s AQL, Core Java

ETL

SSIS, Fileldr+Pl/Sql (proprietary)

BI

QlikView 10/11 developer, SAP Business Objects XIR3.1/R2 Universe design, Web Intelligence and Administration.

Databases

Oracle 10/11g, SQL Server 2005/2008 R2   

Certifications

Certifications

References

References