We provide IT Staff Augmentation Services!

Technology Lead - Bi Architect Resume

SUMMARY:

  • 10+ Years of IT experience in enabling BI and Data warehousing solutions, as a part of Design & Development, Requirement Gathering, planning, execution, optimization and adhering to client specific compliance.
  • Technology Lead with excellent logical and analytical skills, enthusiastic, self - motivated, quick learner and team player with excellent communication, easy to work with, dedicated and interpersonal skills. Ensured successful execution, delivery and optimization of BI and data warehousing project which I have worked on.
  • 7+years of Tableau visualization experience.
  • Experience in releasing the build and managing the production and disaster recovery environment.
  • Experience as a team Lead, working with team members and business-IT support
  • Excellent verbal and written communication skills
  • Proficient in analyzing business requirements and translating them to technical requirements and architecture.
  • Expertise in doing the RCA (Root Cause Analysis) and resolving performance bottlenecks and enhance for optimization of the mappings, sessions and workflows.
  • Strong understanding of the principles of Data Warehouse, Dimension Tables, Fact Tables, Star schema and Snowflake schema modeling and implementing Data Marts, Operational Data Store (ODS).
  • Excellent communication skills with business and technical team to be a techno functional.
  • Self-motivated, proactive and a quick learner.
  • Working with industry standard of coding, performance tuning
  • Cross-trained on multiple Database, Business Reporting and Visualization tools.
  • Excellent working and conceptual knowledge of Sybase IQ, Oracle, SQL Server, PL/SQL, TSQL and reports, Stored Procedures, Functions, Triggers and Packages, UNIX Shell scripting and Windows Batch Scripting.
  • Extensive experience in SAP Business Objects with Administrative tasks along with Business Objects Universe development and business reporting with Desktop Intelligence, Web Intelligence and Crystal Reports.
  • Proficient knowledge on reports and dashboards creation on BIRST application which is an enterprise BI platform that delivers the speed, self-service, and agility front-line business workers demand, and the scale, security, and control to meet rigorous corporate data standards with low TCO via public or private cloud configurations.
  • Hands on experience with ER-win Data Modeler for designing logical and physical data models for Sybase IQ Database.
  • Intermediate level knowledge on Cloudera Hadoop and Big Data analytical tools like Impala and Hive.
  • Responsible for the whole software development life cycle activities of the system like debugging, testing, and deploying the applications, reviews of functional requirement documents, creation of technical documents, case studies and related test case documents.
  • Debugged, analyzed and fixed the issues found when upgrading from Sybase IQ 12.7 to Sybase IQ 15.3 and played a key role in production support by performing tests, trouble shooting, bug fixing and scheduling jobs to automate application execution in integrated systems environment.
  • Designed, developed and enhanced developer forms and reports as per business functional requirements.
  • Understanding and applying of managerial concepts and techniques in areas such as work planning, project management, delegating, coaching, mentoring and evaluating.

TECHNICAL SKILLS:

Conceptual Domain: Business Intelligence& Data Warehouse Methodology

Visualization Tools: Tableau, QlikView, BIRST, SAP Design Studio

ETL Tools: Alteryx

Business Reporting: SAP BusinessObjects, SAP Crystal Reports

Enterprise data Hub: Cloudera Hadoop

Programming Languages: PL/SQL, Oracle SQL PLUS, Windows Batch.

Database: Big Data Analytical Tool

Data Modeler: QA Tool

Other Applications: Microsoft Office Suite, Force-Explorer, PowerShell, Agility.

PROFESSIONAL EXPERIENCE:

Confidential

Technology lead - BI architect

Responsibilities:

  • Responsible for creating efficient design and developing User Interaction dashboards using Tableau Desktop 10.3.1 while using multiple data sources joins.
  • Worked on evaluation and analysis of Hadoop cluster and different big data analytic tools including Hive and Impala .
  • Involved in the development of the Hive/Impala scripts for extraction, transformation and loading of data into other data warehouses.
  • Connected Tableau directly to Hortonworks Data Platform through Hive interface so that business users can quickly find insight with Hadoop deployment.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
  • Leading a team of 4 resources at onsite and offshore included.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
  • Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
  • Gathered user requirements, analyzed and designed software solution based on the requirements.
  • Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
  • Defined best practices for Tableau report development and effectively used data blending feature in tableau.
  • Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
  • Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
  • Good SQL reporting skills with the ability to create SQL views and write SQL queries.
  • Lead the design and development of analytical projects designed to understand key business behaviors that drive customer acquisition, retention, and engagement
  • Partner with the Technology teams to deliver a stable and highly available reporting platform
  • Plan and implement the overall analytics and business intelligence strategy.

skills utilized: Tableau, Alteryx, Cloudera Hadoop, Microsoft SQL Server 2017, Microsoft Office Suite.

Confidential

Technology lead, TABLEAU consultant

Responsibilities:

  • Built database framework of extracting uncleansed data from Amazon Redshift database.
  • Used Alteryx for cleansing and manipulating the raw data and storing transformed data to SQL server for business reporting and Tableau data source refresh.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Building, publishing customized interactive reports and dashboards , report scheduling using Tableau server.
  • Effectively used data blending feature in tableau .
  • Defined best practices for Tableau report development.
  • Executed and tested required queries and reports before publishing.
  • Having good ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and parameterized using Tableau .
  • Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently. of Tableau reports / Dashboards .
  • Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
  • Created story showing the performance of each sales rep since sales territory assignment.
  • Going through Report Specification Documents and Understanding the User requirements.
  • Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports .
  • Created of dashboards for business groups like finance and sales. Data extraction, creation of calculated fields, calculated measures, filters, sets, parameters and bins and action filters.
  • Involved in designing and publishing visually rich and intuitive Tableau dashboards for executive decision making.
  • Created Sets, Groups and Data Bins as per user requirements. Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts etc.
  • Provided support for Tableau developed objects and understand tool administration.
  • Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
  • Created Custom Hierarchies to meet the Business requirement in Tableau .
  • Lead a team of 5 resources at onsite and offshore included

skills utilized: Tableau, Alteryx, Amazon Redshift, Microsoft Office Suite, Microsoft SQL Server 2017.

Confidential

Technology lead, BI consultant

Responsibilities:

  • Extensively using Alteryx & Tableau tool to provide data-as-a service.
  • Collaborating with Business with continuous follow-ups and start-ups with sample data sharing and feedbacks.
  • Lead a team of 5 resources at onsite and offshore included
  • Being a Techno functional , understanding the Business needs and changes and updating the same technically and document the same in the Share Point for further reference.
  • Data Preparation using Alteryx-mappings the above requirements.
  • Developed YoY, QoQ, MoM reports which compare the enterprise savings activity parameters from the previous years, quarters and month in a fiscal year .
  • Built parameters and input controls to give users control over certain values .
  • Combined multiple dashboards into a single story to enhance the visual appeal of the report.
  • Worked on Proof of Concepts to decide Tableau as a BI strategy for enterprise reporting.
  • Received data and records in various format in regards of operation information and connect data source to Tableau for visualized analysis.
  • Developed Scorecards/Reports for the system using Tableau.
  • Used landing page with navigations to provide quick access to target dashboards .
  • Translated business needs into data analysis, business intelligence data sources and reporting solutions for diverse types of information consumers.
  • Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
  • Prepared Dashboards using calculations, parameters in Tableau and created calculated fields, groups, sets and hierarchies etc.
  • Used excel sheet, flat files, CSV files to generated Tableau ad-hoc reports .
  • Used various join types (left, inner, right, outer joins) based on business requirements.
  • Used techniques like data blending which brings data from multiple data sources into a single view in Tableau .
  • Designed and developed graphic rich visualizations with Drill Down and Drop-Down menu option.
  • Visualized data by creating Charts and Graphs (bar graphs, line charts, pie charts, Tree maps, Bubble Charts, Waterfall Charts, Bump Charts, Funnel Charts, and Bollinger Charts) based on client's need.
  • Used symbol maps, filled maps and other map options to plot geographical data.
  • Created Tableau field maps feature with specific geographical roles.

skills utilized: Tableau, Alteryx, Microsoft SQL Server 2012, Microsoft Office Suite.

Confidential

TECHNOLOGY LEAD - BI Consultant

Responsibilities:

  • Converting high-level design specifications to detailed functional and technical specifications
  • Worked on creating Universes using the Business Objects and connected to the database using ODBC.
  • Created queries for multidimensional analysis using Slice and Dice, Drill Down, Drill By and Drill Through.
  • Worked onDesk-i, WEB-iand InfoView enviornments to create and modify the existing Business Objects reports
  • Submitted and presented the reports in user-defined formats like Tabular, Master Detail, and Cross Tab.
  • Upgraded Business Objects Universes, User groups, and reports from Version 5x to 6x.
  • Performed release management of Business Objects reports using Broadcast Agent Server.
  • Designed, tuned and optimized the Star Schema to implement core database.
  • Scheduled and monitor different session of loading data using Power Mart Server Manager.
  • Lead a team of 16 resources at onsite and offshore included.
  • Trained end users in basic and advanced ad hoc reporting skill.
  • Maintaining and updating database models, generating or modifying the database schemas Data Mapping and DWH loading Use case analysis. Database coding and implementation.
  • Used workflow manager for session management, database connection management and scheduling of jobs
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
  • Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
  • Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop for business analysis.
  • Involved in created stored procedures, views, and custom SQL queries to import data from SQL server to Tableau.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
  • Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.
  • Ability to work quickly and under tight delivery deadlines with focus on details.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.
  • Worked on other Visualization tools such as Business Objects Design Studio and BIRST to support the existing customer platforms. skills utilized:
  • Tableau, SAP Business Objects, SAP Design Studio, BIRST,SAP Crystal Reports, SAP Sybase IQ, Oracle Database, Microsoft SQL Server, ER-win Data Modeler, SalesForce.com, Windows Batch, Microsoft Office Suite.

Confidential

Business Intelligence - Center of Excellence senior software engineer

Responsibilities:

  • Worked to translate business information requirements into technical data definitions while working closely with business analysts to understand and document business needs for decision support data.
  • Worked with panel of Business analysts and data modelers during the design and development of data warehouse/data marts.
  • Created database objects like Tables, Indexes, Procedures and Views etc.
  • Written Procedures and Functions using Dynamic SQL and written complex SQL queries using joins, sub queries and correlated sub queries.
  • Involved in coding of data extraction scripts as per technical specifications.
  • Experience in writing Materialized Views.
  • Writing Database Programs using PL/SQL based on new Measures.
  • Tuning the SQL statements for optimal performance.
  • Responsible for modifying/integrating new objects to the Business Objects Universe.
  • Involved in Development, Testing and Maintenance of the System.
  • Responsible for troubleshooting the errors that occurred when the production and testers hit a roadblock.
  • Creating/expiring Reference Data based on the Design documents.
  • Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers using Sybase IQ 15.3.
  • Created Batch processes to run automated data extraction processes.
  • Developed Batch scripts to create FTP Jobs.
  • Built Crystal Report and Salesforce procedures to extract data as per business requirements.
  • Created database table which merges data from Sybase IQ database and Salesforce database and generate an extract based on which BIRST Reporting and Dashboards needs to be built as Business frontend.
  • Regularly explored areas for continuous improvement items in the project scope and deliver them on time.
  • Worked for automations of manual processes via batch processes. With the introduction of automated processes manual efforts of the team tremendously reduced and customer request were fulfilled in much faster time and significant count in ticket reduction due to manual data loads.

skills utilized: SAP Business Objects, SAP Crystal Reports, SAP Sybase IQ, Oracle Database, Microsoft SQL Server, Salesforce.com, Windows Batch, Microsoft Office Suite.

Hire Now