PROFESSIONAL SUMMARY:

• Over 10+ 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
• Experience in complete project life cycle including documentation, analysis, and development and testing.
• Using Qlik Sense created personalized, interactive data visualizations, reports and dashboards from multiple data sources with drag - and-drop ease.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and variety of parameterized dashboards using Tableau.
• IT industry experience in Healthcare, Insurance, Manufacturing, Pharmaceutical and Financial with Functional knowledge in daily operation of these industries.
• 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.
• Heavy interaction with offshore teams, including design and development even before/after business hours for deployments

TECHNICAL SKILLS:

Operating System: Windows XP/ 2003, UNIX

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

ETL Tools: QV Expressor, Informatica.

Business Intelligence Tools: Qlikview 10 & 11, Qlik Sense, Tableau, NPrinting, Business Objects, WebI, Crystal Reports XI/ 2008, SSRS, Toad 0, Cognos

PROFESSIONAL EXPERIENCE:

BI Developer

Confidential, New York, NY

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, Delivered through NPrinting along with securities.
• Design and developed data models, dash boards using Qlik Sense.
• 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
• Collaborate with developers and business analysts in developing new reports and dashboards.
• Developed various data connections from data source; Created complex formulas and calculations within Tableau to meet the needs of complex business logic for report and dashboard development .
• Work closely with functional business analysts to design and develop efficient and standards-based BI solutions using QlikSense BI products that satisfy business information reporting needs

Environment: Qlikview 11, Qlik Sense, NPrinting, QMC, Tableau, Business Object, Cognos, Oracle 11g, SQL Server

BI Developer

Confidential, Indianapolis, IN

Responsibilities:

• Involved in Business requirements gathering and Preparation of Technical Specifications documents and Training guides
• Perform data/systems analysis to determine best BI solution (reports, dashboards, scorecards, data cubes, etc) using Tableau
• 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.
• Plan, run, and manage meetings with internal and external clients (onsite and offshore) as well as run with and complete important project initiatives.
• 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, Tableau, Oracle, SQL Server, Teradata, Toad

BI 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, Sybase, Toad

BI Developer

Confidential, Pea pack, NJ

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
• Heavy interaction with offshore teams, including design and development and periodic after business hours deployments
• 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: Business Object 3.1, Crystal Report 2008, SQL Server 2008, Xcelsius, SSRS, Qlikview v10

BI 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, Informatica

Confidential

Reports Developer/Analyst

Responsibilities:

• Closely interacted with designers and software developers to understand application functionality and navigational flow and keep them updated about Business user’s sentiments
• Performed reports migration from version 8 to 10 covering all criteria
• Created different type of reports including Cross-tab, Conditional, Drill-down, and Sub reports.
• Created reports include formatting options such as Grouping, Sorting, and Drill-down.
• Performed team leader role in few projects
• 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 2000.
• Involved in all team meetings involving users and other team members.
• Designed Complex reports using sub reports, cross tabs using Crystal syntax with extensive usage of Local, Global, and Shared variables at report formulas.

Environment: Crystal Reports 8.0 & 10, SQL Server 2000/2005, Business Object, Visual Basic 6.0, MS Access, MS Excel, XML and Windows NT, SSRS, SSIS