NIHA PATTNAIK
** ********** ***** **** *********, NJ-08816 acw6ql@r.postjobfree.com 848-***-****
BI Programmer/Developer
Qlikview -12 Cognos 10.2 WebFOCUS 8 QA SQL
PROFILE
Over 3.5 + years of experiences as BI Programmer in Qlikview 12, Cognos 10.2, and WebFOCUS 8105.
Experiences in designing and developing Qlikview dashboards
Developed Qlikview objects like List box, Multi boxes, Statistical box, Straight tables, Pivot tables, Containers, Line charts, Bar charts, Pie charts, and Buttons.
Experiences in creating reports in Cognos using Framework Manager, Report Studios, experiences in security conversion and upgradation of Cognos, testing of reports and cubes.
Working knowledge of WebFOCUS 8105, App-studio, HTML canvas, WebFOCUS architecture
Experience working with Software Development Life Cycle (SDLC), in reviewing Business Requirements Document (BRD)
Exposure to all aspects of analytics/data warehousing solutions (Database issues, ETL development, data migration and reporting solutions)
Experience in developing and executing test cases, defect tracking, unit testing of reports, experience in Helpdesk / JIRA support
Highly motivated team player with excellent Interpersonal, Customer Relation Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities
Knowledge & Skill Areas:
-- Software Development Life cycle -- Requirement Gathering & Analysis
-- Technical & End User Documentation -- Software Testing and Troubleshooting
-- Problem Analysis & Resolution -- Project Team Work & Communication
-- Data Warehousing Solution & Data Modeling -- Business Intelligence
TECHNICAL
SUMMARY Reporting: Cognos 10.2.1, WebFOCUS 8105, Qlikview-12
Languages: VB Script, Java Script, FOCUS, SQL
Databases: MS SQL Server 2012
Operating Systems: Windows 7/8/XP, UNIX
Other Tools: JIRA, JAZZ, Lotus Notes 8.5, Ipswich WS_FTP
EDUCATION MASTER OF SCIENCE (M.S), MONTCLAIR STATE UNIVERSITY, NJ, US
Personal Development:
Qlikview -12 Cognos 10.2.2 Report Essential 1 & 2- WebFOCUS (Information Builders) SQL Developer Quality Assurance (QA)
EXPERIENCE
CHUBB &SONS, NJ June -2015-Present
BI Programmer, Qlikview Developer
US Totals Reports
Migration of WebFOCUS reports to Qlikview 12
Developed Dashboard for ‘US Totals Reports’
Developed Qlikview objects, created different charts, performed statistical calculation for all states
BI Programmer, Qlikview Developer
Producing Branch & Territory Reports
Migration of WebFOCUS reports to Qlikview 12
Developed Dashboard of ‘Producing Branch and Territory’
Developed Qlikview objects, created different Charts, performed statistical calculation for different Territory, Producing Branch and Sub Producer for all states
. BI Programmer, Cognos Developer
Monthly Claims Report
Reports are generated to access open, closed and pending claims for business users
Calculated Query for each claims were developed and Total Claims were calculated
Query and documentation were carried out in JIRA tool
BI Programmer, Cognos Developer
Cognos Upgradation
Upgradation of Cognos 10.2.1 to Cognos 10.2.2 performed
Published the packages of cpf file in the frame work manager of the Cognos 10.2.2
Reports and cubes are tested in Cognos 10.2.2. after publishing Packages
BI Programmer, Cognos Developer
Security Conversion of Cognos to LDAP
Security system ‘Cognos Series 7 security’, window 2003 server and access manager were converted to LDAP Name space, 2012 server and active directory.
Cognos 10.1 were converted to Cognos 10. 2.
Different reports and cubes had to be tested for different users in Cognos 10.2
BI Programmer, WebFOCUS Developer
Coverage Select Reports
Migration of WebFOCUS 77 to WebFOCUS 81 to better serve the business.
Developed 4 complex reports, many defined fields, filtered columns and drilled down
App Studio used to develop HTML launch page for all reports.
Application delivered to business by portals.
Environment: Qlikview 12, SQL Server, Excel files, WebFOCUS-8105, Cognos 10.2.1, Microsoft Office, Framework Manager, Report Studio, Manual Testing, JIRA, Access Manager, Active Directory, LDAP, App Studio, HTML Canvas, Text Editor, JAZZ, LOTUS Notes 8.5, Oracle
MEGATEK INTERNATIONAL LIMITED, FL 2013 - 2015
Cognos Developer
Enterprise Reports
This project was designed provide detailed reports to better analyze marketing trends of Chase Insurance.
Designed reports using report studio’s list, crosstab, and drill through
Involved in Unit Testing and Functional Testing of the completed reports.
Database Tester
Upgradation E- Business
Involved in test case design for functional, regression, and UAT testing.
Worked with SQL queries for data verification and validation
Environment: Cognos 10.2.1, Cognos Connection, Report Studio, Query Studio, Frame Work Manager, Microsoft Excel, Microsoft Word, MS SQL Server