SUMMARY:

• IT industry experience in all aspects of Business intelligence applications with a strong background in Database development, Data Warehousing /Decision support systems and Business Intelligence.
• Experience in database design & development, database programming, data modeling, business process analysis, and application development.
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC). Experience in Planning, Analysis, Design, Implementation and Maintenance using QlikView.
• Good expertise with the development and design of QlikView applications.
• Experience in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• In-depth knowledge of it industry best practices in both business management and technology domains.
• Experience in working with Data Warehousing and business intelligence tools for developing various reports using QlikView.
• Expertise in Installing and Configuring QlikView Desktop, QlikView Server and QlikView Publisher.
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Worked in close association with customers for requirement gathering and effective analysis.
• Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products.
• Excellent analytical, inter-personal and communication skills with clear understanding of business process flow.

TECHNICAL SKILLS:

BI Tool: QlikView, Cognos, Informatica, QlikView Expressor

Web Technology: HTML, DHTML, Java Script, VB Script, HTML, JSP, ASP, XML

Languages: C, C++, VB, Core Java, JSP, J2EE, XML, EJB, FoxPro, VB/ASP.NET

Databases: Oracle (9i, 10g), SQL2000, MS SQL server 2005, FOXPRO Data bases

Reporting Tools: MS SQL Server Reporting Services, FoxPro Reports, Crystal Reports, QlikView, Business Objects

Office Tools: MS Excel/Access/PowerPoint/MS Word Toad, SQL Developer, Visual Source Safe6.0

Operating System: Windows-XP, Windows 2000/2003, Linux, UNIX, Solaris

PROFESSIONAL EXPERIENCE:

Confidential, Sparks, MD

QlikView Developer

Responsibilities:

• Designed Frontend objects like Line, Bar, Pie, Straight, Pivot Tables and other sheets objects like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Kept an active participation in business requirement and design review session as well as kept a close interaction with other developers/designers
• Pulled data from multiple databases and build a data model by removing circular loops and synthetic tables.
• Created different publisher tasks like reload tasks, reduction tasks and distribution tasks using QlikView Management Console
• Wrote SQL Scripts with preceding Loads to extract relevant data in QlikView Applications
• Performed analytics as per the requirement using advanced charts and tables
• Designed graphs and visuals to summarize data, identify outlying data points, and perform other exploratory data analysis
• Used appropriate functions like Apply Map, Resident Load, Concatenate, Variables and so on.
• Extensively worked with advanced scripting, set analysis, VBScript, as well as advanced aggregation functions
• Used functions Date and Time, Keep, Join, Mapping, and String & input Fields etc.
• Created User Conditions and Filters to improve application user experience
• Effectively identified and troubleshot any technical issues.

Environment: s: QlikView 11.x, Oracle 9i, Flat files, MS Excel, Windows Server, QlikView Expressor

Confidential, Dallas, Texas

QlikView Developer

Responsibilities:

• Worked with Business Analyst and the Business user to identify the user requirements, business reporting needs, layout, and developed the architecture of prioritized reports.
• Actively participated in the design, architecture and development of user interface objects in QlikView applications.
• Created Dashboard reports to track all the way through ship to final acceptance phases.
• Developed executive dashboards in QlikView delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Installed, configured and deployed the application on QlikView server and Imported data from different sources such as Oracle, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC.
• Created different complex sheets and sheet objects based on client requirements.
• Created List boxes, Statistic boxes to show the statistics of the sales held on different products in different years.
• Showed the statistics in bar charts and pie charts as per the client needs.
• Added dimensions to a bar chart and turning bar chart into a multidimensional pivot table.
• Created multi boxes, table boxes, and input boxes to fetch data based on the input given.
• Created Layout themes and applied it to several documents.
• Used advanced scripting, set analysis, VBScript and JScript macros, advanced aggregation functions and advanced charts for applications.
• Involved in performance tuning of dashboards to limit the response time and enhance the functionality.
• Enhanced and translated existing dashboards in SSRS into QlikView and worked extensively with the set analysis.
• Successfully passed through the QA Environment and implemented on Production and currently working as post production support.

Environment: Qlikview 10.0/11, Oracle, SQL Server, Informatica8.6, Toad 9.6.1/SQL Developer, SQL Loader

Confidential, Las Colinas, Texas

QlikView Developer

Responsibilities:

• Working with the user community and senior management to identify the business reporting needs and also develop the architecture of prioritized reports by role that would have the most positive impact on the business
• Analyze customer requirements and develop proposals of technical solutions as needed.
• Developed SQL Scripts, database objects, procedures, functions and packages.
• Installed, configured and deployed the application on QlikView server and Imported data from different sources like SAP BW, Sales force, Oracle, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC.
• Worked on data modeling and developed different complex models as per given user requirement without any closed loops, Synthetic tables and ambiguous relationships.
• Mainly designed and developed Qlikview software applications and complex server-based Qlikview dashboards from scratch to support reporting and Business Intelligence initiatives.
• Used advanced scripting, set analysis, VBScript and JScript macros, advanced aggregation functions and advanced charts for applications.
• Designed Executive Sales Analysis Dashboard that offers fast and flexible access to all key information across the enterprise.
• Designed a comprehensive and easy to use Mortgage analysis dashboard for client to keep track of Sales representative performance, and efficiency of converting customer leads into revenue.
• Implemented security using QlikView section access technology that dynamically hides selected areas of the dashboard depending upon user privileges.
• Provided ongoing QlikView consultation to the development team.

Environment: Qlikview 10.0/11, Oracle, SQL Server, Informatica 8.6, Toad 9.6.1/SQL Developer, SQL Loader and Sun Solaris.

Confidential, Texas

Qlikview Developer

Responsibilities:

• Developed Qlikview applications by analyzing business data as per client requirements.
• Involved in creating logical and physical model of the database using Erwin.
• Created schema objects like tables, views, indexes. Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Written new stored procedures, functions and T-SQL queries and modifying existing ones as per new business requirements.
• Connected to different ODBC, OLE DB data sources (SQL Server, DB2, Oracle, and SAP BW) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of Qlikview.
• Worked with Qlikview administrator to optimize Qlikview performance.
• Worked on Automation &scheduled QVW document refreshments using Qlikview Publisher.
• Also developed Canned Reports, Customized Reports, On-Demand Reports and Ad-Hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created Drill down reports which give all the details of various transactions like closed transactions, pending approvals, and summary of transactions and scheduled this report to run on quarterly basis using SSRS (Reporting services).

Environment: Qlikview 8.5, MS SQL Server 2005, SSIS, SSRS, T-SQL, PL/SQL, Oracle 9i, SQL, DB2, UNIX, Microsoft Visio 2003, MS-Access 2000 & Windows XP Professional, VB Script.

Kaiser Permanente, Carona, CA

SQL Developer

Responsibilities:

• Modified report wherever needed as per the suggestions given by business analyst and analyzed the existing Actuate and SQR reports.
• Migrated actuate code of data extract to PL/SQL equivalent and created PL/SQL functions, packages, procedures and joins.
• Coordinated with the client to make sure that there is not much change during the migration of the reports.
• Assessed the pros and cons of migration and conveyed the same to the Business Analyst.
• Created Cross-Tab, Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Written stored procedures for those reports which use multiple data sources.
• Converted the Actuate and SQR reports to SSRS without any change in the output of the report.
• Enhanced the existing reporting functionality by using the advanced features of SSRS.
• Created different types of reports such as parameterized reports, matrix report, charts etc.,
• Tested (manual) the reports after migration to make sure that the SSRS reports serve the exact business purpose as that of existing Actuate reports.
• Extensively used Share Point.

Environment: SQL Server 2005 Enterprise, Crystal reports, SQR, SSIS, SSRS, SSAS, Windows Enterprise Server 2003, IIS 6.0, Erwin, Visual studio 2005, Share Point (WSS3).

Confidential

SQL Developer

Responsibilities:

• Designed, implemented and administrated SQL Server 2000 databases.
• Implemented Constraints (Primary Key, Foreign Keys Check and Not Null/Null) and fine tune Indexes on Tables.
• Create and Modify Stored Procedures, Triggers, Views according to the business.
• Developed various reports to validate the data between source and the target systems.
• Design of ETL processes to transfer customer related data from MS Access, excel to SQL Server.
• Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.

Environment: SQL Server 2000, SQL Profiler, Data Transformation Services, and T-SQL.