PROFESSIONAL SUMMARY:

• 5+ years of IT industry experience in all aspects of analysis, testing, development and implementation of client/server applications. Experience covers all aspects of business Intelligence applications with strong background in developing a database and Data warehousing support systems.
• 4 years of experience in Designing and development of business Intelligence application with QlikView 9.x to 11.20
• Expertise in configuring QlikView Server, QlikView Publisher and QlikView Desktop and upgrading to the existing versions.
• Experience in design and development of QlikView for OLTP and OLAP Systems
• Experience in extracting Data from different sources like DB2, Experience in both development and administration of QlikView.
• SQL Server and integration of Hadoop, Teradata with QlikView.
• Experience with Creating QVD’s and Scheduled jobs for QVD extracts and report loads.
• Well versed with QlikView Schemas like Star and Snowflake Schemas andloading techniques Incremental, Buffer, Preceding, and Binary loads.
• Experience in creating scripts to resolve circular loops, Synthetic keys and Modeling issues in QlikView.
• Extensive knowledge in Sheet objects, Charts, exporting the reports to MS - Excel, handling the variables and aggregated functions of QlikView.
• Experience in writing SQL queries, Functions, Views and Stored procedures.

TECHNICAL SKILLS:

Databases: MS-SQL server 2008/05, Netezza, Maria DB.

Methodologies: Agile, SDLC, UML, Scrum

Languages: C, C++, Dot.Net, PL/SQL, SAP-ABAP

BI Tools: QlikView 9.0/10.0/11.20 , Informatica Power Center

Operating Systems: Windows Xp/7/8/10, Windows Server2003

Web Technologies: HTML, XML, JavaScript, VB Script.

PROFESSIONAL EXPERIENCE:

Confidential, North Brunswick, NJ

QlikView Developer

Responsibilities:

• Understanding source systems and Designing Data Modeling and Loading data from Multiple Data sources.
• Connected to SQL using OLEDB and ODBC data sources connector and tables.
• Crated POC to the client based on their requirement.
• Developed SQL scripts, database objects, Procedures and functions.
• Designed and developed extensive QlikView reports using combination of charts and tables.
• Installed, configured and deployed the application on QlikView server and Imported data from different sources like Sales force, SQL Server, MS Access, XML files and flat files using OLE DB/ODBC .
• Created link tables on the needed basis and as per the data.
• Created Master Calendar and worked with date fields as per the user needs.
• Applied mapping function to look up and fetch the required field.
• Used advanced scripting, set analysis, advanced aggregation functions and advanced charts for applications.
• Published dashboards on Access point. Deployed QVW's on the production server, Created Reload and Distribution tasks on QlikView Server/publisher.
• Wrote SQL Scripts to load relevant data in QlikView Applications.
• Research and troubleshoot technical problems and provided ongoing QlikView consultation to the development team.
• Establishing QlikView Environment setup, configuration and Implementation with the BI Support Teams.

Environment: Qlikview 9/10/11/20, SQL Server, Informatica Power Center, PL/SQL Developer, SQL Loader

Confidential, Chicago, IL

QlikView Developer

Responsibilities:

• Worked on the documentation for application development.
• Installed and configured QlikView Server Small Business Edition.
• Generated ODBC Connections to extract from data bases and store them in QVDs.
• Extracted data from multiple data sources (SQL Server, Excel) and designed data model.
• Implemented Star Schema and Snow Flake schema in designing the data model.
• Used Link Tables to avoid circular reference and Loop issues.
• XML external report request, Excel report, on demand report, HTML report using NPrinting.
• Developed Dashboards using different QlikView Objects Line Chart, Bar Chart, Gauge Chart, Pie Chart, List box, Multi box, Table Box, Container etc.
• Converted Excel and crystal reports to QlikView dashboards.
• Experience in reporting activities which involved Business score card, sales and operations report.
• Involved in User Training Sessions and Preparing Documentation.
• Involved in Production Support for QlikView applications Server. 
• Implemented Security involved in Deployment of QlikView  Applications.
• Automated and Scheduled data loads and Dashboard Applications weekly and Notifications by email to assigned users using Server.

Environment: QlikView 11, SQL Server 2008, SQL, HTML, Excel, CSV Files, NPrinting.

Confidential, Detroit, MI

QlikView Developer

Responsibilities:

• Designed and development of QlikView platform to integrate with Expandable Databases.
• Generated ODBC and OLEDB connections to extract data.
• Imported Data from Multiple data sources which also includes Web files, MS-SQL Server, MS-Excel through OLEDB and ODBC connections, Text, CSV files.
• Participation in enterprise BI strategy developments.
• Converted excel and crystal reports to QlikView.
• QlikView 9 Implementation and Integration.
• Wrote SQL Scripts to load relevant data in QlikView Applications.
• Implemented advanced SET analysis for aggregation calculations.
• Developing QlikView solutions and utilize them to develop complex reports and executive dashboard.
• Developed Dashboards using different QlikView Objects Line Chart, Bar Chart, Gauge Chart, Pie Chart, List box, Multi box, Table Box, Container etc.
• Documented Architectural Concepts and technical specifications.
• Create and Manage QlikView Scripts.
• Creating the data models, handling synthetic keys and circular loops.
• Experience in reporting activities which involved Business score card, sales and operations report.
• Involved in Training Sessions and prepared documentation.
• Implementing the reload tasks and distribution tasks using the QlikView publisher.

Environment: Teradata, QlikView11, Windows Server 2003, Ms-Excel 2010, Ms-Access 2010.

Confidential, San Diego, CA

SQL Developer

Responsibilities:

• Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms and standards. Developed Unit Test Plans.
• Prepared Business Requirement Specification that gives the comprehensive details about the requirements.
• Developed /modified oracle PL/SQL codes like stored Procedures, Functions, Triggers etc. based on technical and functional specification documents. Used Sub-Queries, Merge statements and joins extensively in stored procedures.
• Developed and modified scripts to create tables, views and executed them using SQL plus.
• Created SQL* loader control files for moving the data from flat files to staging area tables.
• Used Informatica power center manager to schedule the jobs.
• Prepared the procedures to update the internal structures to reflect the newly loaded data.
• Worked under the supervision of DBA and created database objects such as tables, views, sequences, synonyms, and table/column constraints, indexes for enhancement.
• Use of Explain plan, extensive usage of Indexes.
• Measuring and reporting response rates using Excel, PL/SQL scripts.
• Used Different functions such as Data & Time, Conditional, Aggregation functions, Analytic Functions.

Environment: Oracle 9i, TOAD, SQL Navigator, UNIX, Informatica power center manager.