Bi Developer/ Qlikview Developer Resume
NJ
SUMMARY:
- Around 4 years of experiences as BI Programmer in Qlikview 12, Cognos 10.2, and WebFOCUS 8105.
- Work with technical and end users to understand business requirements and identify data solutions
- Designed and developed Qlikview dashboards
- Knowledge of Loading data from flat files( Excel, CSV) Oracle, MS Access and SQL Server
- Developed Qlikview objects like list box, multi boxes, statistical box, straight tables, pivot tables, different charts (line, bar, pie) for data visualization.
- Developed QlikView chart (Drill Through, Cyclic Grouping)
- Knowledge of Best data models Practice in QlikView, various loading technique.
- Knowledge of set analysis expressions, security models for Qlikview Applications: section access/ AD user groupings security, alternate state, extension, Key Performance Indicator(KPI)
- Knowledge of Qlikview administration and architecture
- Designed and developed reports in Cognos using framework manager, report studios
- Experiences in security conversion, upgradation of Cognos, testing of reports and cubes.
- Working knowledge of WebFOCUS 8105, App - studio, HTML canvas
- Knowledge of Star and Snowflakes schema
- Experience working with Software Development Life Cycle (SDLC)
- 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
TECHNICAL SKILLS:
SUMMARY Reporting: Qlikview-12, Cognos-10.2 WebFOCUS-8
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
PROFESSIONAL EXPERIENCE:
Confidential, NJ
BI Developer/ Qlikview Developer
Responsibilities:
- Developed Dashboard / Key Performance Indicator(KPI)for ‘US Totals Reports’
- Created various metrics and reports to identify Process failures (Incident Management)
- Loaded Script from external Excel sheet and developed QWV and then QVD files.
- Created List box for dimension and Straight Table data association of Coverage, Premium of Month, Year and Inforce.
- Created Bar chart for Premium and Coverage as measure.
- Designed and developed Dashboard for Producing Branch & Territory Reports.
- Loaded Data from Oracle DataMart by OLEDB connection
- Identification of Critical Success Factors (CSF) across the platform, provide the KPIs of metrics
- Developed Qlikview objects List Box for producing branch, Territory and Agent for different state, date and type of Coverage.
- Developed bar chart as cyclic group, performed statistical calculation for premium and coverage for different Territory, Producing Branch and Sub Producer/ Agent
- Unit Tested Reports and wrote Technical documentation.
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
Confidential, FL
BI DeveloperResponsibilities:
- Designed reports using: report studio’s list, crosstab, and drill through, Involved in Unit Testing and Functional Testing of the completed reports.
- Innovated ideas for metrics for customer and identified key areas for Key Performance Indicators (KPIs), strategic measures.
- 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: Qlikview 11, Cognos 10.2.1, Cognos Connection, Report Studio, Query Studio, Framework Manager, Microsoft Excel, Microsoft Word, MS SQL Server.