PROFESSIONALSUMMARY:

• Over 8 Years of IT experience in all aspects of Business Intelligence applications with a strong knowledge in database development, Data Warehousing, and Business Intelligence
• Broad knowledge of software development, Business Analysis and Business Intelligence for collaboration with various teams to affect a seamless transition of knowledge and requirements in a SDLC Process.
• Proven capabilities with the development and design of QlikView applications.
• Created and organized jobs for QVD extracts and report reload in QEMC.
• Proficient in Installing and Configuring QlikView Desktop, QlikView Server and QlikView Publisher.
• Capable of effectively working with Data Warehousing and business intelligence tools for developing various reports using QlikView.
• Worked from end - to-end implementation of QlikView dashboard deployment.
• Having extensive experience in Sheets and Sheet Objects in QlikView. Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts, and Bookmarks etc.
• Created the reports using charts like Pie, Bar, Line etc. Charts are used in making reports more user-friendly in analysis purposes.
• Interaction with Business users during the various stages of project lifecycle to identify various KPI's and designed solutions to enhance business decision making.
• Expertise in Incremental Load.
• Handled large data volume by periodic backup taken by using incremental load of QVDs
• Created report task and scheduled them to run at specific interval in QlikView Enterprise Management Console.
• Reduced data using simple reduce and loop and reduce in QlikView Publisher.
• Built dashboard using complex expressions, set analysis, variables and functions.
• Optimized Dashboard with help of QlikView best practices and Techniques.
• Expertise in ODBC and OLEDB data sources and building complex load scripts.
• Skilled in handling and analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
•  Expert in database development skills using SQL and writing Stored Procedures, Packages and Triggers
• Worked in close association with customers for gathering requirements and effectively analyzing them.
• Proven capability in designing and creating database objects such as Tables, Views, stored procedures, and functions in SQL Server based on logical design model and business requirements.
• Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Expert in analysis, design, development, customization, implementation and testing of software applications and products.
• Exceptional analytical, inter-personal and communication skills with clear understanding of business process flow

TECHNICAL SKILLS:

Analytical Tools: QlikView 9X/10X/11X/12 Qlik Sense3.1, 2.0/2.1/2.2.4 SSRS, Informatic Center 9.0/8.6.1/8.1.1/7.1/7.0/6. X.

Database Technologies: Oracle9i/10g/11g, DB2, SQL Server 2005/2008, Sybase and MS Access.

ETL Tools: Informatica, Data stage, SSIS

Languages: Java Scripts, SQL, PL/SQL, UNIX, HTML, VB Script, Shell Scripting.

ETL: Informatic, IBM Infosphere DataStage.

Operating Systems: Windows (XP,10,7, NT/2000), UNIX.

Methodologies: Waterfall/Agile software development, Kimball/Inmon

Application software: Adobe Works, MS-Office Suite

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

QlikView/ Qliksense Developer

Responsibilities:

• Involved in the Requirements gathering, analyzing, and documenting business requirements and data specifications.
• Extract a heavily normalized data set and build a data model with Link Table and Master Calendar to connect the various fact tables with the master tables.
• Design, Develop and test several scripts of QlikView and import data from different data sources
• Design and develop QlikView/Qlik Sense security, account reports.
• Testing the QlikView dashboards to meet customer requirements.
• Ensure that the QlikView server processes continue to run and operate in the most efficient manner in all the authorized environments.
• Data Validation and analysis based on the data pulled into QlikView.
• Application was built based on guidelines set in prototype proof of concept.
• Developed dashboard tab with overall details of health care products and additional tabs for information on performance details, summary, budgets, call activity and call & change details.
• Implemented conditional expressions and dimensions for some charts to show different metrics in the same chart based on selections by users.
• Developed and designed the dashboards with different types of charts in Qlik view Designed visualizations like pie chart and bar chart.
• Documented the technical part in Qlik view, so that it can be reviewed and shared with the team and also can be used for later purpose.
• Involved in creating publisher tasks for data extraction, reload and loop & reduce based on territorial hierarchy.
• Improved the overall performance of the application by redesigning the data model applying some best practices and performance tuning techniques.
• A powerful custom, conditional report and comparative analysis sheet were built to enable users to perform further analysis. This feature is newly available in QV 11.
• Deployed applications on production server and setup automated data reloads
• Identify customer needs and work collaboratively to determine business requirements.
• Involved in Technical Documentation detailing the use of data model on backend and different charts and variables on front end.
• Creating support transition documents with details of all publisher jobs and the order in which they need to be run. Impact and solutions document with details of probable problems that may arise and the solution to fix the issue.
• Expertise in QlikView Management Console.

Environment: QlikView12/11.2, QlikSense 3.1, Microsoft SQL Server, Oracle, SAP, Excel files, Flat Files, MS Access, SSIS.

Confidential, Nashville TN

Sr QlikView Developer

Responsibilities:

• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Conducted Feasibility Analysis with the technical support team for the migration of legacy database to MySQL database to implement web-based solution.
• Used Oracle/SQL Server as backend and QlikView script for ETL Operations for extracting, transforming & loading data into QV applications or into QVD files to speed up the loading process into QV application.
• Manage/Schedule QlikView applications using QlikView Management Console (QMC)/ QlikView Enterprise Management Console (QEMC).
• Deploy & Maintain QlikView Applications into the development, UAT, and Production environments.
• Configured QlikView Server /Publisher. Scheduled jobs, & security.
• Eliminated Synthetic keys, ambiguous relationships and closed loops. Designed proficient dashboards according to the requirements.
• Enhanced existing dashboards with new functionalities and established a secure environment using QlikView Section Access.
• Created charts as per the customer requirements on Quarterly, Monthly and Yearly for report analysis.
• Involved in Production support and maintenance.
• Provided user training to get familiarity on using QlikView Applications
• Experience in using triggers and actions to provide certain functionalities.

Environment: QlikView 10(SR4)/11, QlikView Server and publisher, Oracle 11g, QlikSense, printing, QlikMaps, Tableau 8.x, SQL Server 2008 R2, MS Access, MS Excel, Flat Files, Windows Server 2008, .CSV Files, agile environment.

Confidential, Springfield,MO

Qlikview Developer

Responsibilities:

• Actively participated with business users and functional team to understand the reporting requirements and worked on all phases of the project.
• Supported in modifying, testing and implementation of existing reports.
• Imported data from different sources like Oracle, SQL Server, MS Access, XML files, QVDs and flat files using OLE DB/ODBC.
• Developed scripts for data reloading, mapping and transformation by using joins, concatenations, resident loads and temporary tables.
• Performed redesign of the existing QlikView BI associative model to improve availability, scalability and performance by eliminating synthetic keys and circular loops in the data model.
• Optimized existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.
• Implemented multiple levels of hierarchies such as sales, product, partner, customers and service hierarchy etc.
• Worked with various Sheet Objects, Charts (including Drill Down and Cyclic field grouping), Table box, Lists, Input box, Master Calendar.
• Implemented Incremental load for the update of QVD’s.
• Implemented section access, section authorization and sheet access to make the application available to desired users.
• Was actively involved in server migration and the fresh QlikView installation process.
• Used booking, revenue applications, created 4-year forecast model, and successfully implemented in QlikView.
• Considered best practices of QlikView and created heat map and KPI graphs.
• Creating section access code and binary loads for un-compromised security and quick reloading of applications.
• Involved in performance tuning of dashboards to limit the response time and enhance the functionality.

Environment: QlikView 9.0/10.2, Oracle 10G/11G, SQL Server 2008, CSV Files, Windows 2008 Server.

Confidential, Germantown, MD

ETL Developer

Responsibilities:

• Participated in business requirement walk through, design walk through and analyzed Business requirements.
• Performed Verification, Validation, and Transformations on the Input data before loading into target database.
• Involved in designing the process flow for extracting the data across various systems.
• Developed ETL routines using Informatica Power Center and created mappings involving transformations like Lookup, Aggregator, Ranking, Expressions, Mapplets, connected and unconnected stored procedures, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers.
• Extensively used ETL processes to load data from various source systems such as SQL Server, Teradata and Flat Files, XML files into target system SQL Server by applying business logic on transformation mapping for inserting and updating records when loaded
• Using the Power Exchange for Change Data capture (CDC) option to capture the data whenever the inserts, updates, and deletes underlying these events as soon as they occur and transfer in to multiple targets without intermediate queues or staging tables
• Extensively used Informatica Workflow Manager and Workflow Monitor to develop, manage and monitor workflows and sessions.
• Used the database partitioning and Informatica partitioning for better performance when working with the huge data.
• Responsible to design, develop and unit test the mappings.
• Migration from DEV to QA using Repository Manager..
• Performed Unit and Integration Testing and validates results with Business Analyst and end users.
• Documented each stage of the project and attended status meeting every week.

Environment: Informatic Power Mart (Designer 8.x, Repository Manager 8.x, Workflow Manager 8.x), Oracle, PL/SQL and UNIX.

Confidential

SQL/ ETL Developer

Responsibilities:

• Extensively used Informatica- Power center for extracting data from various source systems like database, flat file etc., transforming and loading into data mart.
• Designing different Mappings according to Requirements.
• Worked on Informatica tool Source Analyzer, Data Warehousing designer, Mapping Designer, Workflow Monitor, Workflow Manager and Repository Manager.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas.
• Used the Mapping Designer to map the sources and target.
• Worked extensively on different types of transformations like Source qualifier, Expression, Filter, Aggregator, Lookup, Sequence generator, Router and Joiner.
• Created Reusable mapplets and Reusable transformations to leverage the coding efforts
• Created email notifications. Set up Workflow to schedule the loads at required frequency using Power Center Workflow Manager, Generated completion messages and status reports using Workflow Manager.
• Identifying & removing the Bottle Necks, Tuning the Mappings and Sessions for improving performance. 1
• Fixing production bugs and issues.

Environment: Informatic Power Mart (Designer 8.x, Repository Manager 8.x, Workflow Manager 8.x), Oracle, PL/SQL and UNIX.

Confidential

SQL/ ETL Developer

Responsibilities:

•  Modified report wherever needed as per the suggestions given by business analyst and Analyzed the existing Actuate and SQR reports.
• 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.
•  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.
• Involved in Performance tuning and Query Optimization.
•  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
• Assessed the pros and cons of migration and conveyed the same to the Business Analyst.
• Used SQL Developer to Load / Extract data into and from Excel files.
• Written stored procedures for those reports which use multiple data sources.
•  Conducted impact analysis and designed structures to enhance performance.
• 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. 

Environment: MS SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Integration Services 2008, SQL Analysis Services 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, ERWIN.