SUMMARY

• 13+ years of experience in the field of software services for Business Intelligence, Analytics, Reporting and Dashboard Development.
• My expertise includes QlikView, Qlik Sense, NPrinting, Actuate, Birt, Maximo, Teradata, Oracle, PL/SQL, SQL Server and Visual Basic.
• Having knowledge on Qlik Sense data visualization. Attended corporate workshop on Qlik Sense.
• Extensive experience in analysis, design, development, customizations and implementation of various software applications
• Proficient in analyzing and translating business requirements to technical requirements and architecture.
• Exposure to various domains like Finance, Health Insurance and Manufacture domains.
• Possess good client communication experience across various regions.
• Have hands on experience with Maximo frameworks with BIRT2.3.2.
• Currently working (8+ Yrs.) in Confidential & Confidential Ltd, India currently deputed in USA since 2014.
• 5.1 years’ experience in Confidential, deputed in IBM Bangalore as an Oracle Consultant.

TECHNICAL SKILLS

Database: Oracle 8i/9i/11i, DB2, Teradata, Sybase, SQL Server

BI Tool: QlikView 11.0, 11.2, Qlik Sense, Actuate 7.0/8.0/9.0/11.0 , Eclipse BIRT 2.3.2/4.2, Cognos 8.0, SSRS.

Operating Systems: Windows 98/XP, 2000

Languages: C, C++, SQL, PL/SQL, Visual Basic, Shell scripting, UNIX

Others: Maximo 6.2.3/6.2.8/7.5 , Maximo V7RI

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Working with Business SMEs to analyse the requirement.
• Come up with design proposal and run it through design authority discussion, to get approval.
• Working with documentation for deployment approval, scheduling jobs, production support and development for QlikView and QlikSense reports.
• Working on different phases in dashboard building(qvd generation, transaction, data modeling, dashboard design, test cases building, performance testing, validation, support to pass UAT etc.) involved end to end support and future enhancement.
• Working with offshore team to involve into various analytical work, for futuristic proposal.
• Working with product owner for end to end solution. Deep learning on backend Data flow of Policy, Submissions, different region’s cut - off on business day, monthly report generation and validation.
• Working with Organizational reference hirer Key, Segments, Brokers, Accounts, Product etc.

Confidential

Responsibilities:

• Working as a /with Business Analyst to implement several thoughts or views in QlikView design tool.
• Design Tier1, 2, 3, 4 structures in Qlik for any new requirements as par Confidential standard. Also identify the scope of improvement at the time of file/QVD structure building.
• QVD generation, Performance enhancement of existing dashboard and implementing standard practice across all dashboards.
• Optimization of QlikView data load.
• Dashboard enhancement and maintenance.
• Create Project Support(KT) documents, Data Mapping Documents
• Scheduling the reload of QlikView reports in QMC.

Confidential

Responsibilities:

• Understand the requirement and reporting to VRO (Volcker Rule Office) with data analysis in dashboard.
• QlikView dashboard interface design, development and maintenance.
• Data Model design for QlikView dashboard.
• Multi-tier QVD generation.
• Performance enhancement of existing dashboard and implementing standard practice across all dashboards.
• Optimization of QlikView data load.
• QlikView dashboard enhancement and maintenance.
• QlikView report generation and enhancements with QlikView Report Builder.

Environment: QlikView 11.20, Autosys, Oracle 11i.

Confidential

QlikView Senior Developer

Responsibilities:

• Recognizing its influence as one of the world’s leading media companies, with assets that include national television networks, local TV and radio stations, interactive and outdoor media and a publishing house, Confidential Corporation strives to use its power and reach for the public good.
• Working on understanding of existing Actuate report. Design document to implement those logic in SSRS.
• Co-ordination with offshore team. Designing report template on SSRS, decoding Prepare system test case document, perform System Testing Deploy newly developed rdl file into share point and configure to run.

Environment: Actuate 8, SSRS, Toad, Oracle 8

Confidential, Minneapolis

Project Lead

Responsibilities:

• Worked on understanding of more than 100 complex Actuate report running on Maximo environment in many application like Assets, Finance, Inventory, Purchasing, Security etc.
• Worked closely with maximo migration team to understand the new features and configuration to implement on newly develop report on eclipse birt 2.3.2.
• Worked on understanding of concept running report from Maximo 6.2.8 with the help of Maximo V7RI. Involved in designing, developing and release reports in Maximo.
• Uploading report in Maximo V7RI and perform system testing in 6.2.8 environment. Co-ordination with offshore team.

Environment: Actuate 8 Birt 2.3.2, Maximo 6.2.8, Maximo V7RI, Oracle 11i.

Confidential

Project Lead

Responsibilities:

• Most natural gas in the U.S. must be processed before it reaches the marketplace (companies) and end-users (people like us).
• Confidential is the link between natural gas being produced at a wellhead and then filling society’s need for energy and by-products.
• Gathering requirements from client and analyzing Implemented the required changes on the corresponding reports, there 8 highly complex were restructured based on new logic, design and additional requirement. Involved in designing, developing and release reports in Maximo.
• Closely monitor all newly and old release report after Maximo 7.5 upgrade
• Involved in creating the stored procedures. Involved in application unit testing. Involved in setup and deployment reports in client environment
• Clarify with proper root cause after analysis in both report and database side.
• Report upload, create new user, role, job execution, Report scheduling, on demand report execution, report Archiving and all other actuate server activities.
• Performance tuning, SQL query enhancements, code enhancements to achieve performance targets
• Investigate various PRODUCTION issues in actuate servers and provide proper solution.
• Involve on creation of system testing and report testing document for the purpose of actuate report conversion either on Cognos or OB.
• Involve on creation of statured report design document with all various parameter, purpose of if and group clause used in report.
• Support team to get convert actuate report to OB and Cognos.
• Monitoring various load activities.
• Work on ticket raised by support team.

Environment: Actuate v8,iServer, Oracle 8,Toad

Confidential

Actuate Senior Developer

Responsibilities:

• Understand the Actuate report and prepare Technical Design Document.
• Convert Actuate report in Cognos BI tool.
• Deliver new and complex high quality Actuate reports to clients in response to varying business requirements.
• Provided various optimized solutions to existing reports and improved the productivity.
• Worked on Report Bursting, Frame work development, Fetching data from various data sources such as Teradata, Sybase, Oracle etc.
• Job execution, Report scheduling, Report Archiving in Actuate iServer
• Migrated various versions of Actuate reports to Current version 9 Performance tuning, SQL query enhancements, code enhancements to achieve performance targets Interpret the EXPLAIN command output and optimize the SQL’s

Environment: Cognos 8.0, Actuate v9 and Actuate v8,iServer, Teradata