SUMMARY

• Over 7+ years of professional experience in IT industry with strong background in Analysis, Design and
• Development in the field of Database, Data warehouse and implementation of BI applications
• Knowledge of industry best practices in both business management and technology domains.
• Developed complex GUI reports using various Qlikview objects
• Experienced in QlikView Dashboard design, aggregation functions, Set analysis, use of SQL scripts.
• Extensive knowledge and experience in dealing with RDBMS including normalization, SQLs, Procedures
• Worked as a QlikView Technical Consultant for a wide variety of business applications.
• Experience in complete project life cycle including documentation, analysis, and development and testing.
• Always worked in close association with customers and a single point of contact for many major implementation projects.
• IT industry experience in Healthcare, Insurance, Manufacturing, Pharmaceutical and Financial with Functional knowledge in daily operation of these industries.
• Enthusiast and Experienced QlikView developer - the pioneered in-memory Dash boarding tool.
• Expertise in granting security according to privileges at department/position level
• Designed complex Data models using various databases, resolved Synthetic Keys issues.
• Installed and configured Governance Dashboards in order to optimize QVW.
• Familiarity with other products of Qlik Market like QV Expressor, QV Mailer.

TECHNICAL SKILLS

Operating System: Windows XP/ 2003, UNIX

Databases: Oracle 10g/11i, SQL Server, Teradata, Sybase, DB2, MS Access.

ETL Tools: QV Expressor, Informatica.

Business Intelligence Tools: Qlikview 10 & 11, Qlik Sense, Business Objects 4.1, WebICrystal Reports XI/ 2008, Xcelsius, SSRS, Toad 9.0 PROFESSIONAL EXPERIENCE

Qlikview Developer

Confidential - Livingston, NJ

Responsibilities:

• Lead the development of BI solution prototypes that demonstrate performance and usability to business and IT stakeholders.
• Design, develop, and test QlikView scripts to import data from source systems, data feeds, flat files
• Worked on Federal Template FR Y-14A, MIS reports, variance report.
• Prepared custom made reports, where users can select their own dimensions /expression and criteria
• Implemented security through database scripting as well as QMC/AP in order to restrict data as per users/group privileges.
• Automated data reloading job on periodical basis or on demand basis.
• Working on Supporting Documents like Income & Balance, wholesale, retail, PPNR statements.
• Work closely with functional business analysts to design and develop efficient and standards-based BI solutions using QlikTech's BI products that satisfy business information reporting needs

Environment: Qlikview 11, Qlik Sense, QMC, Access Point, Oracle 11g, MS Access, MS Excel

Qlikview Developer

Confidential - New York, NY

Responsibilities:

• Contributed to high-level strategic decisions around report designs, Data visualization and creative direction.
• Developed project documentation, testing materials, training materials, requirements gathering including downstream and upstream interface requirements and adhering to a project management methodology.
• Gather requirements using interviews, document analysis, workshops, business process descriptions, use business case scenarios, business analysis, task and workflow analysis Analyzed, transformed and optimized large data sets, built dashboards using flat files and RDBMS databases that will feed the dashboards.
• Implemented security through section access at row level, tab level, report level at single sign-on window.
• Report published, group generated, privilege granted through QMC and Access Point.
• Developed simple and complex reports including list, crosstabs and charts with drill-thru capabilities & report level calculations.

Environment: Qlikview 11, Oracle 11g, XML, MS Access, MS Excel

Qlikview Developer

Confidential - Indianapolis, IN

Responsibilities:

• Involved in Business requirements gathering and Preparation of Technical Specifications documents and Training guides.
• Created mock-ups showing the intended functionality, visual aspects of the dashboards to be developed.
• Developed dashboards pertaining to KPI monitoring using QlikView11.
• Developed complex QlikView scripts to build model, to support various KPIs and time comparison.
• Responsible for positioning and delivering QlikView projects and cross building applications into new and existing customer base.
• Worked as Subject Matter Expert (SME) for various projects. Taught the users to get along with Qlikview.
• Considering huge amount of records performed daily incremental reload.
• Participated in design workshops, providing technical insight and knowledge
• Performed time over time analysis of sales volume and revenue.
• Worked with QlikView 11, SQL, Excel files and flat files.
• Involved in production support based on the Remedy tickets modified/resolved the Reports.

Environment: Qlikview 11, Oracle, SQL Server, Access

Qlikview Developer

Confidential - New York, NY

Responsibilities:

• Design, development and deployment of traditional and operational business Intelligence reporting based on BRD.
• Delivered advanced/complex reporting solutions such as Dashboards and standardized reports using Qlikview 10
• Involved in the analysis, design, develop, testing, deployment and user training of analytical & transactional reporting system.
• Created KPI for higher authority persons in order to make decisions to optimize company's profitability.
• Worked and well versed with QV Server, QV publisher and Governance Dashboard.
• Modified report content and export reports in multiple formats based on user input.
• Involved in Writing SQL Queries, Views and Stored Procedures on SQL Server.
• Worked in a production support role where in typical issues have been intelligently resolved
• Fine tuning the performance of Database and reports.
• Performed quality coding to business and technical specifications
• Worked extensively on creating Alerts, Variables, Input Boxes, Calendars, Sliders

Environment: Qlikview 10, Business Object, Oracle 10g, SQL Server 2008, MS Access, MS Excel

Qlikview/Business Object Developer

Confidential

Responsibilities:

• Conducted meeting with business managers, end users on site and off site, visited Singapore site to gather the requirement in order to support them remotely
• Studied and analyze requirements, databases sources, applied parameters to control database for performance.
• Customization of application data capture for business end user reporting.
• Design and develop Crystal reports as per company's need, maintaining implementation, quality control testing and deployment.
• Created Dashboards using Qlikview using various components like List Boxes, Sliders, Buttons, variety of Charts, Book marks.
• Prepared effective KPI reports for various departments and different executives.
• Migrated whole parking reporting system from old (Sybase) to new (SQL Server 2008) with new advancement and criteria.
• Transformed data in visualization form to forecasting business using Business Object Xcelsius Dashboard & Web Intelligence

Environment: Qlikview 10, Business Object, Oracle 10g, SQL Server 2008, MS Access, MS Excel

Report Developer

Confidential - Silver Spring, MD

Responsibilities:

• Managing and publishing Crystal Reports using Crystal Enterprise
• Actively participating in the design and review of the new reports standards.
• Responsible for developing and maintaining Crystal Reports, development cycle of client requirements, analysis client needs
• Educated end-user about database construction through Data Dictionary
• Create business users(Doctors, Radiologist, Microbiologist etc), grants privileges
• Interact with business users and support them if any problem arise
• Running and testing required queries and reports before publishing and test the performance
• Maintained high level of customer satisfaction with custom reporting services from both internal and external customers.
• Involved in Creation of ad-hoc Crystal Reports, Created ODBC Connections, database Connections, stored procedure using oracle.
• Customized data by adding Filters Calculations, Prompts, Summaries and Functions
• Performed Data Modeling using Informatica 7.1

Environment: Crystal reports 10 & Xi, Business Object 3.1, Teradata 7.1, DB2, Excel, Remedy, Epic, Lotus Notes, Qlikview v10