SUMMARY

• 8+ years experience as Full Stack Business Intelligence Developer and Data Warehousing dealing with large complex data scenarios.
• Strong skills with Qlikview/Qliksense data scripting for scalability / maintainability, optimization.
• Experience in bigdata using AWS Redshift with technologies like Athena .
• Experience using AWS Cloud Storage and Computing technologies such S3, AWS Athena.
• Experience with RDBMS concepts and hands on working skills with Oracle/SQL server and Postgres.
• Worked with GIT and Version control tools SourceTree.
• Used JavaScripts and Angular 2 while working with QlikSense mashups.
• Experience using SQL queries along with experience in writing and optimizing SQL queries.
• Working Experience with large data warehouse systems, dimensional modeling.
• Experience in data extraction experience using SQL (ETL) with Linux.
• Experience in reviewing and analyzing the Business Processes, Business Process Flows and implementing Qlikview/Qliksense Solutions.
• Experience working on Direct Discovery with RedShift, ClikHouse dealing with billions of row data sets.
• Tested Applications, reports using review checklists, Data quality for Quality Assurance prior to making delivery to end users. Have experience using JIRA.
• Provided Implementation & Production Support for Several Qlikview Applications.
• Good knowledge on Data warehouse concepts and principles like Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.
• Worked as a team good member and maintained good coordination with the team and supervisors.

TECHNICAL SKILLS

BI Tools: QlikView and QlikSense

Database Servers: AWS Redshift, Apache DRILL, PostgreSQL, MS SQL Server, Oracle

Operating Systems: Windows 7, Vista, XP, UNIX

Scripting: JavaScripts, Angular 2

Programming: SQL, PL/SQL, C and C++

Bigdata concepts: AWS Redshift, S3, AWS Athena, EC2,Apache DRILL

Office Applications: MS Outlook, Visio, MS Project

PROFESSIONAL EXPERIENCE

Confidential - Portland

QlikSense BI Developer

Environment: Qlikview 11, Qliksense,Resdshift, SQL Workbench, AWS EC2, Apache DRILL.

Responsibilities:

• Involve in the Requirement gathering with client and prepare the technical specification.
• Prepare the high level design and discuss with client to finalize the same.
• Analyze the various sources for the planned Dashboard and Reports.
• Involve in the finalization of the design of data model with various transformations.
• Gathering data from various sources QVD files, xls, Oracle, Binary QVW, Inline & txt files in developing the Qlikview Data Models.
• Implement scripts to avoid circular loop and ambiguity join while preparing the data model.
• Developing Qlikview Dashboard using various sheet objects ( charts, tables, radio buttons, multibox, input box, list box).
• Implementing several Qlikview functions (Date and Time, Keep, Join, Mapping, String & Input Fields).
• Developing User Interactive Sheets & Reports as business needs.
• Developing Qlikview Dashboards using various Charts (Pie, Bar, Line, Combo, Gauge, Radar, Pivot table, Straight table) with Drill Down & Cyclic Grouping, List, Table Box and Calendar & Date Island.
• Implementing Set Analysis in providing custom functionality to Qlikview Applications.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.

Confidential - Salt Lake City

CreditLEAD / Qlikview Developer

Responsibilities:

• Involve in the Requirement gathering with client and prepare the technical specification.
• Prepare the high level design and discuss with client to finalize the same.
• Analyze the various sources for the planned Dashboard and Reports.
• Involve in the finalization of the design of data model with various transformations.
• Gathering data from various sources QVD files, Excel, Oracle, Binary QVW, Inline & txt files in developing the Qlikview Data Models.
• Implement scripts to avoid circular loop and ambiguity join while preparing the data model.
• Developing Qlikview Dashboard using various sheet objects ( charts, tables, radio buttons, multibox, input box, list box).
• Implementing several Qlikview functions (Date and Time, Keep, Join, Mapping, String & Input Fields).
• Developing User Interactive Sheets & Reports as business needs.
• Developing Qlikview Dashboards using various Charts (Pie, Bar, Line, Combo, Gauge, Radar, Pivot table, Straight table) with Drill Down & Cyclic Grouping, List, Table Box and Calendar & Date Island.
• Implementing Set Analysis in providing custom functionality to Qlikview Applications.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.

Environment: Qlikview 11, Oracle 11g, TOAD, Windows 2007.

Confidential - New York

Qlikview Developer

Responsibilities:

• Involve in the Requirement gathering with client and prepare the technical specification.
• Prepare the high level design and discuss with client to finalize the same.
• Analyze the various sources for the planned Dashboard and Reports.
• Involve in the finalization of the design of data model with various transformations.
• Gathering data from various sources QVD files, Excel, Oracle, SQL Server, Binary QVW, Inline & txt files in developing the Qlikview Data Models.
• Implement scripts to avoid circular loop and ambiguity join while preparing the data model.
• Developing Qlikview Dashboard using various sheet objects ( charts, tables, radio buttons, multibox, input box, list box).
• Implementing several Qlikview functions (Date and Time, Keep, Join, Mapping, String & Input Fields).
• Developing User Interactive Sheets & Reports as business needs.
• Developing Qlikview Dashboards using various Charts (Pie, Bar, Line, Combo, Gauge, Radar, Pivot table, Straight table) with Drill Down & Cyclic Grouping, List, Table Box and Calendar & Date Island.
• Implementing Set Analysis in providing custom functionality to Qlikview Applications.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.

Environment: Qlikview 11, SQL Server 2005, Oracle 11g, MS Access 2010, Windows 2007.

Confidential

Qlikview Developer

Responsibilities:

• Involve in the Requirement gathering with client and prepare the technical specification.
• Prepare the high level design and discuss with client to finalize the same.
• Analyze the various sources for the planned Dashboard and Reports.
• Involve in the finalization of the design of data model with various transformations.
• Gathering data from various sources QVD files, Excel, Oracle, SQL Server, Binary QVW, Inline & txt files in developing the Qlikview Data Models.
• Implement scripts to avoid circular loop and ambiguity join while preparing the data model.
• Developing Qlikview Dashboard using various sheet objects (charts, tables, radio buttons, multibox, input box, list box).
• Implementing several Qlikview functions (Date and Time, Keep, Join, Mapping, String & Input Fields).
• Developing User Interactive Sheets & Reports as business needs.
• Developing Qlikview Dashboards using various Charts (Pie, Bar, Line, Combo, Gauge, Radar, Pivot table, Straight table) with Drill Down & Cyclic Grouping, List, Table Box and Calendar & Date Island.
• Implementing Set Analysis in providing custom functionality to Qlikview Applications.
• Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.

Environment: Qlikview 11, SQL Server 2005, Oracle 11g, MS Access 2010, Windows 2007.

Confidential

Qlikview Developer

Responsibilities:

• Involve in the Requirement gathering with client and prepare the technical specification.
• Analyze the various sources for the planned Dashboard and Reports.
• Created Dashboards style of reports using Qlikview components like List Box, Slider, Buttons, Charts and Bookmarks.
• Developed extensively Alerts, Variables, Input boxes and Calendars.
• Gathered & loaded data into Qlikview from various data sources (SQL SERVER 2005, Oracle 10g .CSV and Excel files).
• Included the enhancement scripts to the existing QV scripts and performed the actual load to test the overall functionality of the application.
• Coordinated with ETL team and performed integration testing to check data discrepancies.
• Analyzed the existing Qlikview data model and script logics the existing Qlikview applications.
• Executed the scripts and checked the incorporated script changes in the application.
• Developed SQL Scripts in validating data from different data sources.
• Developed User Interactive Sheets & Reports as per business needs.
• Generated reports using triggers.
• Trained the end users effectively to use the reporting tool.

Environment: Qlikview 9.0/8.5, SQL Database, Windows Server 2003, Microsoft Visio, Qlikview Publisher, Qlikview Server 9.0.

Confidential

Business Analyst & Report Developer

Responsibilities:

• Effectively communicated with Business Users for Data Requirement and Data Analysis Documents.
• Designed and Developed form layouts as per user specifications.
• Developed reports as per the business requirements.
• Implemented various Exception handling cases for proper flow of data into database.
• Developed user interfaces, menus and coded different PL/SQL objects for Forms and Reports.
• Executed the scripts and checked the incorporated script changes in the application.
• Developed User Interactive Forms as per business needs.

Environment: Oracle 8i, SQL, PL/SQL, Oracle Forms, Reports, SQL*Plus.

Confidential

Business Analyst & Report Developer

Responsibilities:

• Developed SQL Queries for data retrieval from various database objects including tables and views.
• Used SQL*Loader to load the data from flat files and CV files into the database.
• Developed PL/SQL Stored Procedures, Functions, Packages, Cursors, Triggers and Records to implement business rules into application.
• Developed new reports from scratch using Oracle Reports 6i.
• Implemented Event Triggers to perform business logics in the background of Forms and Reports.
• Developed complex stored procedures for making transactions effectively transparent.
• Extensively used built in Oracle packages like DBMS SQL and other packages.
• Developed user interfaces, menus and coded different PL/SQL objects for Forms and Reports.

Environment: Oracle 8i, SQL, PL/SQL, Oracle Forms, Reports, SQL*Plus, SQL Tuning

Confidential

Business Analyst & Report Developer

Responsibilities:

• Effectively communicated with Business Users for Data Requirement and Data Analysis Documents.
• Developed PL/SQL procedures to extract and load data for weekend batch processing.
• Involved in creation and updates of several SQL packages and Procedures.
• Implemented various Exception handling cases for proper flow of data into database.
• Implemented PL/SQL scripts using Ref cursors in order to load data dynamically and implemented incremental Loading of data.

Environment: Oracle 8i, PL/SQL, SQL* Loader, TOAD, Windows XP