SUMMARY

• 8 years of IT industry experience in all aspects of Business intelligence applications with a strong background in Database development, Data Warehousing Systems and Business Intelligence.
• 5+ years of experience in Designing and Development of Business intelligence applications with Qlikview 9.0/10.0/11/11.2.
• Ability to offer End - to-End solution starting from the requirement gathering, Design, Development and Deployment of Business Intelligence applications.
• Experienced with Agile methodology in quick providing analysis and visualization for business users.
• Strong Experience in UI design by using different QlikView sheet objects including multiple chart types, trends, KPI’s, custom requests for Excel, Export and fast change.
• Expertise on extracting QVD ‘S from different Data Sources.
• Expertise on database such as creation of data models, star schema, snowflake schema, fact and dimensional table.
• Strong experience in Qlikview Product family such as Qlikview Desktop Client, Qlikview Management Console, Qlikview Server.
• Strong Experience in Loading Data using Scripts like automate QVD’s, Calendar Object, custom scripting to implement SQL Functionalities.
• Experience in using ETL Tasks such as data cleansing, joins, aggregation tables using Qlikview
• Implemented Best Practices & Developed ETL scripts to resolve circular Relationships, Synthetic keys.
• Involved in Optimizing existing QlikView dashboards with a focus on usability, performance, long-term, flexibility, and standardization.
• Experience with Oracle Application Modules - Account Payables, Order Management, Purchase Order, Account Receivables, General Ledger. Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Strong skills in designing and developing applications on the Microsoft .Net platform using .NET Framework, Architecture Concepts, Visual Studio.NET (C#, ASP.NET, VB.NET).
• Excellent working knowledge in RDBMS concepts, SQL, PL/SQL, SQL Server.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel Power View
• Expert in Unit, System and User Acceptance Testing and Performed Data Validation for all the reports and dashboards generated from various database sources.

TECHNICAL SKILLS

Business Intelligence Tools: QlikView 9.0/10/11/11.2 , SSRS, SSIS.

Languages: SQL, PL/SQL, C, C#, VB.NET, HTML, VB Script

Database Technologies: Oracle12c/11g, MS SQL Server 2012/2008/2005 , MS SQL.

Operating Systems: Windows 7/8, Windows XP, UNIX.

Domains: Healthcare, Financial, Manufacturing and Sales

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow Flake Modeling, FACT and dimensions tables, Physical and Logical Data Modeling.

Others: MS Access 2013, MS-Excel 2013, MS Visio 2010, MS Power Point, MS Word, Oracle SQL Developer.

PROFESSIONAL EXPERIENCE

Confidential, Rochester, MN

Sr. QlikView Developer

Responsibilities:

• Involved in understanding and transmitting the business requirements for the project, and translating these into functional specifications.
• Worked with Business Analyst and the Business users to identify the user requirements, business reporting needs, layout, and developed the architecture of prioritized reports.
• Created Dashboard reports to track all the way through ship to final acceptance phases.
• Implemented SECTION ACCESS for the applications.
• 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 dashboards with Qlikview sheets objects which include List boxes, Statistic boxes, and containers, different charts (bar charts, scatter charts, Block charts and pie charts) to show the statistics of the sales held on different products in different years.
• Extensive use of SET analysis expressions in charts, shown the critical KPI’s in gauge charts and Implemented binary load and hidden script
• Created Layout themes and applied it to several QVW’s.
• Worked on Qlikview functions like AGGR, PICK, MATCH, Date and time, Keep, Join and Mapping.
• Used advanced scripting, Alternate states for comparative analysis, set analysis, VBScript macros, advanced aggregation functions, advanced charts for applications and Document chaining.
• Created static reports using straight tables and pivot tables with spark lines and mini charts
• Involved in performance tuning of dashboards to improve the response time for the users accessing the documents via access point by reducing the size of the QVW.
• Performed unit testing and integration testing by applying the test cases and involved in User acceptance test.

Environment: Qlikview11.0/11.2, QEMC, SQL Server 2012, Oracle 11g, Windows 2008 server, QViewer, MS- Excel, MS-Power Point, VB Script.

Confidential, Irvine, CA

Sr. QlikView Developer

Responsibilities:

• Project requirement gathering, coordination with business analysts and pre-sales teams.
• Managing data gathering, cleansing and maintenance.
• Creating/designing QlikView Dashboard. Used Section access and Sheet access to make the application available to desired users.
• Developed various QlikView Data Models by extracting and using the data from various sources like QVD files, MS SQL DB, Excel, and Flat Files.
• Developed Drill through Dashboards which enabled users to drill down between dimensions.
• Used the functionality of linking universes so as to have the flexibility to use the objects in one Universe in another.
• Performed Binary Load on Existing QVW’s files.
• Designed and developed Dash Boards using Qlikview Sheet Objects.
• Worked on SQL Tuning and Optimization of the reports.
• Involved in script management, script functions, script variables, inline load, QVWS, QVD’S.
• Performing Unit and Integration testing, validation and sanity checks on the deliverables.
• Post Production support/maintenance and optimizing existing QlikView reports with a focus on usability, performance, flexibility, testability and standardization
• Installed IE plugins and trained the end users to use the reports using Qlikview tools.

Environment: QlikView11, SQL Server 2008, Windows Server 2008, Microsoft Visio.

Confidential, Minneapolis, MN

QlikView Consultant

Responsibilities:

• Requirements gathering, Impact Analysis and solution designing to in corporate the Business requests.
• Developed different dashboard with a complex database system behind it, which includes extracting data from the database, storing into QVD files, load scripts, and develop UI according to user requirements.
• Implemented Macros, Filters, Variables, Set Analysis, Aggregate functions and Mapping functions to achieve user requirements.
• Created reports using Qlikview functionalities like combined queries and KPI formula’s.
• Interacted directly with the end users for requirements gathering during complete offshore support.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView Publisher.
• 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.
• Designed, developed, implemented and tuned multiple QlikView applications for the Sales, IT and HR departments.
• Optimized the script and logic of analysis.
• Monthly Activities- Data refresh, Job Scheduling and Data validations.
• Participated in Developing reports, security and deploying to end users.
• Server maintenance, Bug fixes, New User Access, enhancements followed by testing and deployment.

Environment: QlikView 10, Excel, MS SQL Server, Oracle 10g, DB2, PL/SQL.

Confidential, Dallas, Texas

QlikView Developer

Responsibilities:

• Strong understanding in creating Dashboards for the required KPI’s in Qlikview.
• Created various Flags based on users requirements.
• Dashboards included customer detail drilldowns, threshold gauges, alerting mechanisms and pop report.
• Developed load scripts to work with multiple data sources (SQL, Flat Files, Excel, and MS Access).
• Performed different tasks such as repeat tasks, reload tasks and distribution tasks using the Qlikview Publisher.
• Trained End Users on Using Qlikview Tools.
• Designed application for Sales & Marketing Modules that Generates GUI Report for easy access through the data.
• Created dashboard style of layouts using different components of Qlikview Enterprise such as Listboxes, Multiboxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.
• Performed testing of dashboards for functionality, data, performance, look and feel.
• Managed schedules and reloading of Qlikview data model QVDs and QVWs through Qlikview Enterprise Management Console (QEMC).
• Involved in Script development, script functions, script variables, inline load, QVWs, QVDs, set analysis and section access.

Environment: Windows 2000 Server, Qlikview 9, Oracle 10g, SQL Server 2005, MS Office.

Confidential, East Chicago, Indiana

SQL/PLSQL and VB.net Developer

Responsibilities:

• Modified report wherever needed as per the suggestions given by business analyst and Analyzed the existing Actuate and SQL 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..
• Coordinated with the client to make sure that there is not much change during the migration of the reports.
• Designing and developing .Net application using VB.Net as the code behind.
• Developed SQL queries to fetch data as per the business requirements with proper tuning techniques.
• Created checks and constraints to maintain data integrity across the data in the database.
• Involved in interfacing and transacting data from SQL Server using ADO.Net with VB.Net, ASP .Net and presenting it to XSL tree.
• Faxing/ Emailing/printing the proposals through their respective LANID’S
• Worked on Microsoft Team Foundation Server for version control, individual task status and Database server project.
• Email Notifications and call-out support on errors.
• Performed unit testing and integration testing by applying test cases and also written test cases by using Test Driven Methodologies.

Environment: .Net Framework, SQL Server 2005, Team Foundation Server (TFS), VB6, VB.Net, T-SQL, PL/SQL, Visual Studio 2008.

Confidential

SSIS and SSRS Developer

Responsibilities:

• Responsible for Analysis, Design and Development
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
• Handling Production issues and modifying the code according to the requirement.
• Created SQL Server Integration Service (SSIS) packages between enterprise databases and Third party data source to transfer data.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler
• Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler
• Giving the production support and maintenance.
• Bug fixing based on issue generated by the client.
• Involved in Unit & Functional Testing.

Environment: SQL Server 2005, SSIS, SSRS, Query Analyzer, Database Engine tuning wizard, C#, MS Access, MS Excel, Windows Server 2003 Enterprise Edition, HTML.