We provide IT Staff Augmentation Services!

Bi Developer Resume

PortlanD

SUMMARY:

  • 10+ years’ experience as Full Stack Business Intelligence Developer and Data Warehousing dealing with large complex data scenarios.
  • Strong skills with Tableau and Qliksense data scripting for scalability / maintainability, optimization.
  • Experience in bigdata using AWS Redshift with technologies like AWS Athena, Quicksight.
  • Experience using AWS Cloud Storage and Computing technologies such S3, AWS Athena.
  • Experience with RDBMS concepts and hands on working skills with SQL server and PostgresSQL.
  • 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 Tableau and 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 Tableau and Qliksense Applications.
  • Experience in converting/migration projects from Qlikview to Qliksense.
  • 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: Tableau 9x, QlikSense and Qlikview 11.

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

Operating Systems: Windows 7, Vista, XP, UNIX

Scripting: JavaScripts, Angular 2, Python

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

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

Office Applications: MS Outlook, Visio, MS Project

PROFESSIONAL EXPERIENCE:

Confidential, Portland

BI Developer

Environment: Tableau, AWS Resdshift, SQL Workbench, AWS EC2, Map R Apache DRILL.

Responsibilities:

  • Participated in multiple end to end implementations which consists of gathering requirements from multiple user groups, analyzing Business Requirements Documents (BRD’s), preparing high level and low level design documents, Development, Support.
  • Participated in Business Requirement Documents review, Functional Requirements Documents Data Model
  • Reviews to understand the requirements and to prepare the necessary design documents accurately.
  • Played key role in Performing Analysis, Design and development of multiple Tableau dashboards and deployed in multiple environment (Dev/Stage/Production).
  • Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks
  • Worked a great extent with the design and development of Tableau visualizations which includes Preparing
  • Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies etc.
  • Created solution driven Tableau dashboards by developing different chart types including Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, and Histograms in Tableau Desktop
  • Created Tableau workbooks with calculations, parameters, Quick Filters.
  • Worked on generating various Tableau workbooks and dashboards extracting data from various sources such as Oracle, SQL Server and data files using data blending and joins.
  • Created parameters for Prompts in Calculations for various Tableau workbooks and dashboards
  • Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
  • Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
  • Reviewed SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
  • Created Tableau Scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps using show me functionality.
  • Executed and tested required queries and data before publishing Dashboard to Tableau Server.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
  • Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key
  • Performance Measures (KPI) and Measure.
  • Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
  • Coordinated the DEV work efforts to offshore team.
  • User Adoption training to the end - users on Tableau desktop.
  • Followed Agile Scrum process to streamline development process with iterative and incremental development.
  • Performed Tableau administration function like Migration of Tableau Workbook and Dashboard from one server /environment to others.

Confidential

BI 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 Dashboards and Reports.
  • Involve in the finalization of the design of data model with various transformations-ETL.
  • Gathering data from various sources QVDs files, parquet files, S3 buckets, Redshift, CSVs, txt, QVF, Binary QVW, Inline & xls files in developing the Qlik Data Models.
  • Implement scripts to avoid circular loop and ambiguity join while preparing the data model.
  • Developing Qlikview/Qliksense Dashboard using various sheet objects (charts, tables, radio buttons, multibox, input box, list box).
  • Implementing several Qlik functions (Date and Time, Keep, Join, ApplyMap, String & Input Fields).
  • Developing User Interactive Sheets & Reports as business needs.
  • Developing Qlikview/Qlkisense 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.
  • Written complex expressions using SET ANALYSIS and various Qlikview/Qliksense functions
  • Implement Actions/Triggers in the Qlikview interface.
  • Used master calendar/As Of date concept for time related dimensions and a strong source control methodology for tracking changes.
  • Involved in Deployment of Qlikview/Qliksense Applications into the server.
  • Working knowledge of Qlikview Server, Qlikview Publisher, and Qlikview Enterprise Version
  • Entitlement and data level security for dashboard using SECTION ACCESS.
  • Implemented Qlikview dashboards distribution to business users using Section Access to dashboards.
  • Testing Applications, reports using review checklists, Data quality for Quality Assurance before delivering to the end users.

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

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

V3 Security/ 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

Rapid - DSO Analytics / 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

Bio-CSO/ 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, MicrosoftVisio, Qlikview Publisher, Qlikview Server 9.0.

Confidential

Bio-CSO/ 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

HirePro-AMS/ 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

HireCraft/ 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 to load data dynamically and implemented incremental Loading of data.

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

Hire Now