WebFOCUS Developer

Rajesh Singh Negi

+91-880*******, ************@*****.***

PROFILE

Business Intelligence Consultant with 3.3 years of Business Intelligence (BI) experience in Development and Analysis of Enterprise BI application. Adept at designing and developing professional BI dashboards on the IBI WebFOCUS platform, also involved in the requirement and data analysis. I have performed tasks included report requirement and data analysis, report development for Self-Service Applications using a combination of FOCUS and SQL, creating GUIs with HTML and JavaScript, and troubleshooting end user and developer problems. I am a valuable team player with pleasant yet effective communication skills who welcomes new challenges. SUMMARY

• Experience in BI Application Development using WebFOCUS App studio and Info Assist+.

• Develop Self-service applications for enterprise wide implementation using WebFOCUS App studio.

• Develop responsive html application as well as BI Portal.

• Experience in preparing complex metadata and business views in order to enable self service capabilities using WebFOCUS Info Assist+.

• Experience with creation of Security groups and users with rules in the WebFOCUS Administration console.

• Experience with Report Scheduling and Report Bursting using WebFOCUS Report Caster.

• Working Understanding of IDM tool.

• Worked on WF restful web services.

• Understanding of the principles of Data Warehousing using fact tables, dimension tables.

• Ability to learn new skills, adapt to changing environments.

• Good Interpersonal and communication skills, willingness to work independently and with team.

• Working with multiple teams.

EDUCATION

Master in Computer Application

Management Education and Research Institute – New Delhi India Affiliated with: Guru Gobind Singh Indraprastha University

B.SC in Computer science

Delhi University

TECHNICAL SKILLS

Web Technologies HTML5, JavaScript, CSS, Restful Web services BI Tools WebFOCUS 8.X App studio, Info Assist+, Business Intelligence Portal, Dashboards, IDM 8.x, Data Quality Server, RSTAT.

Programming Languages FOCUS, C, PL/SQL, C++, Java, C#. Database Technologies SQL Server 2016, 2014, 2012, 2008 Oracle 11g.

ETL Tools IDM 8.X

Operating Systems Windows 7/8, Windows 10

Implementation Methodologies Agile and Scrum

Data Warehousing Fact and Dimensions, Physical and Logical Data Modeling Auxiliary Skills MS Office Suite

Software/Tools Android Studio, Eclipse, Xamarin,

MS Visual Studio, R studio, App Studio

RESEARCH PAPERS

● Big Data and Cloud Security.

Published

National conference on Emerging Trends in Information Technology “Cyber Security: Contemporary Threats and Solutions”.

● Cloud Security in Health Information System.

Published

3rd National Conference on Data Mining (NCDM 15-16). ACHIEVEMENTS

Achiever of the Quarter Q1 – 2018.

Silver Award Extraordinary performance – 2018.

PROFESSIONAL EXPERIENCE

1. CGI, Bengaluru

Period- Sept 2019 - Present

Role- Software Engineer

Project 1:

Project Name : Enterprise Data Lake

Client : Scotiabank

Role : ETL Developer

Duration : Oct 2019 – Present

Environment : Cisco Tidal Enterprise Scheduler, Unix, Python, Hive, Shell Scripting Description:

Scotiabank is Canada’s third largest charted Bank. Our responsibility is to maintain the ETL batch runs every day. Data is extracted from source location to HIVE database. Responsibilities:

Handling Client meetings.

Maintaining every day ETL batch.

Enhancing the code.

Adding new features to project.

Analysing data in HIVE.

Project 2:

Project Name : KS/KQ data repository

Client : Scotiabank

Role : ETL Developer

Duration : Oct 2019 – Present

Environment : I WAY Data Migrator, DB2

Description:

Scotiabank is Canada’s third largest charted Bank. Our responsibility is to maintain the ETL batch runs every day. Data is extracted from source location to DB2 database. Responsibilities:

Handling Client meetings.

Maintaining every day ETL batch.

Enhancing the code.

Analysing data in DB2.

Querying database for other teams.

2. Amtex Software Solution Pvt. Ltd., Gurugram

Period – Jan 2017 – Sept 2019

Role – Associate consultant Developer

Project 1:

Project Name : Experient

Client : Experient

Role : WebFOCUS Developer

Duration : March 2019 – Sept 2019

Environment : WEBFOCUS 8204, SQL Server 2016

Description:

Experient is one of the world's leading event management companies. We are developing Guided adhoc for their created template reports along with two dashboards. Also we are converting their views to cluster view in WebFOCUS.

Responsibilities:

Handling Client meetings.

Gathering requirements.

Guided Adhoc modern UI Development.

Creating complex Metadata structure.

Handling Team.

Gave KT to client and prepare handover documentations on Metadata. Project 2:

Project Name : Apollo Tyres

Client : Apollo Tyres

Role : WebFOCUS Developer

Duration : November 2018 – February 2019

Environment

: WEBFOCUS 8204, WEBFOCUS 8103, WEBFOCUS 8105, SQL Server 2016

Description:

Apollo Tyres is one of the leading tyre manufacturers in the world. We developed Finance and Operations analytics dashboard based on their sample data. This dashboard showcase most of the latest feature of WebFOCUS like Insights, In-Document Analysis and also providing solution for all the problem statement shared by client. We also developed Self Service customized drill down reports based on their Hierarchy on the data.

Responsibilities:

● Client Meeting and gathering the requirements.

● Data validation.

● Creating cluster metadata.

● Implemented Info Mini, In-document analysis and Insight in WebFOCUS.

● Implemented Data level security.

● Developed Info App application.

● Developed charts and reports from the master file and perform Unit testing.

● Developed drill down reports.

● Creating complex reports with parameter pages.

● Migrated Reports and HTML from 8103 to 8204m.

Project 3:

Project Name : Doyon

Client : Doyon Limited

Role : WebFOCUS Developer

Duration : August 2018 – November 2018

Environment : WEBFOCUS 8202m, SQL Server 2016, SAGE Description:

Doyon Limited Developed Finance Application to keep track of its financial aspects. We Developed dashboard that provides, in one quick glance, a holistic overview of the health of a company. Project was based on creation of Finance Dashboard which includes creating reports and charts with conditional drill down based on User login. We have also implemented very complex Breadcrumb navigation which is fully interactive. Also created very precise Financial reports like balance sheet, P&L statements. Responsibilities:

● Gathering the requirements.

● Data validation.

● Creating cluster metadata.

● Implemented Application Level and Data level security.

● Developed charts and reports from the master file and perform Unit testing.

● Analyzing the current reporting structure of Doyon.

● Data mapping and calculations.

● Implemented Breadcrumb Navigation on the Application.

● Created customized drill down reports for report and graph.

● Created responsive HTML Pages for dashboards.

● Gave KT to client and prepare handover documentations. Project 4:

Project Name : Modere

Client : Modere

Role : WebFOCUS Developer

Duration : June 2018 – July 2018

Environment : WEBFOCUS 8202m, D3JS, SQL Server 2016, JSON Description:

Modere delivers innovative products-personal care, health & wellness, and household care. Our products are a better alternative and safe for your family. We have build couple of highly customized visualizations for Modere using D3JS, compound reports to help them display associate hierarchy and sales invoice. Responsibilities:

● Gathering the requirements.

● Analyzing the Data.

● Creating SQL Function to get Hierarchical JSON Data.

● Working on Collapsible Tree D3JS Chart.

● Integrating D3JS Chart inside WebFOCUS.

● Developed Invoice reports.

Project 5:

Project Name : Helzberg Diamonds

Client : Helzberg Diamonds

Role : WebFOCUS Developer

Duration : February 2018 – May 2018

Environment : WEBFOCUS 8202, Netezza

Description:

Helzberg Diamonds is a jewelry retailer founded in 1915 by Morris Helzberg that has 210 stores in 36 states. We helped Helzberg Diamonds in remediating the existing charts, reports after they upgraded their WebFOCUS version and we also developed new store operations and merchandising SKU view analytics dashboards. These are developed using the WebFOCUS page designer. Responsibilities:

● Analyze the requirement document.

● Analyzing the data mapping.

● Creating the Cluster Master file.

● Develop charts and reports.

● Unit testing.

● Migrating Reports and Html pages.

● Applying data level and page level security.

● Worked with Page Designer in WebFOCUS.

Project 6:

Project Name : Bi Store

Client : Internal

Role : WebFOCUS Developer

Duration : October 2017 – January 2018

Environment : WebFOCUS 8201m, SQL Server 2014, IDM Description:

We created standard Bi dashboards for particular domains like education, healthcare, sales etc. The Database structure behind these dashboards will be generic to any client can just plug and play the data to generic database and visualize it on the dashboard. Responsibilities:

Analyzing data warehouse database design for different domains.

Development of attractive responsive dashboard.

Creating and Managing the ETL flows for different domains.

Worked on Generic Data Warehouse design.

Develop chart and Reports.

Project 7:

Project Name : KGP Logistics

Client : KGPCo

Role : WebFOCUS Developer

Duration : July 2017 – September 2017

Environment : WEBFOCUS 8201, SQL Server 2014

.

Description:

KGPCo is the USA’s largest communications product distribution and service solution provider in the telecommunications industry. We have developed a BI application for KGP where-in we developed a collaborative BI portal with 4 dashboards for four of their main Business Units and a Self-serviced Ad-hoc report Which is highly customized and parameterized report that allows users to develop their own reports as per the need. User level and Tab level security is also implemented. Responsibilities:

Analyze the requirement document.

Developed charts and reports.

Fixed UAT issues.

Data Testing.

Project 8:

Project Name : NLP mobile application

Client : Internal

Role : WebFOCUS Developer, Xamain Developer

Duration : February 2017 – June 2017

Environment : WEBFOCUS 8201, Xamarin, SQL Server 2014, Web Services, JSON Description:

NLP Mobile Application is a cross platform application which gives user to see the specific BI content like charts or reports in any Mobile platform i.e. Android, IOS and Windows. Users can easily access the BI content in there smart phones anywhere anyplace. Responsibilities:

● Analyze the requirement document.

● Implementing Voice Module system.

● Creating and managing the database.

● Creating and managing Web services in ASP .net.

● Customizing the theme of Android application.

● Converting Natural Language to WebFOCUS code.

Contact this candidate