For the given job description <<Role: Lead Data EngineerLocation: RemoteDuration: Long Term 8 to 10 years of experience working in data engineering, business intelligence or related field delivering large scale data platforms and services. Ideal candidate will have the following skills: A successful history of manipulating, processing and extracting value from large, disconnected datasets. Expertise in data modeling, data access and data storage techniques. The candidate should have foundational knowledge of dimensional modeling to build a data warehouse Strong experience building transformational logic using SQL on relational SQL and NoSQL databases. Skills using DBT framework for data transformation is plus Robust programming skills and strong experience with Python to ingest, transform and load the data Experience building and optimizing big data data pipelines, architectures and data sets using tools like Airflow. Experience with AWS cloud services: EC2, EMR, RDS, Redshift>> the resume: <<SummaryExperienced Tableau Engineer with critical analytical& statistical knowledge in developing Tableau Dash Boards, Performance Tune and prepare insightful Tableau reports. Built and published customized interactive reports, dashboards, and report scheduling. In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server. Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage. Performed data audits, data profiling activities, providing strategic data to BI teams. Familiar with Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment. Working knowledge in Windows Servers, API, Network technologies with Active Directory, SAML for authentication. Strong knowledge in SQL, PL/SQL, XML, Python programming and understanding of Data modeling (Dimensional & Relational) concepts Experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint. Involved in Trouble Shooting, Performance tuning of reports, tuning long running SQL and PL/SQL queries for better performance and resolving issues. Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports. Involved in upgrading Tableau platforms in clustered environment and performing content upgrades. Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions. Expertise with data architecture, data interoperability and data analytics using Tableau and SQLs Experience in different project methodologies - Waterfall, and Agile/SCRUM Self-starter with ability to motivate teamwork and lead competently in diverse groups. Decision making ability to make sound Engineering, Management judgment. Innate problem solver, able to intellectually articulate business problems, identify critical problems, and achieve targeted results Worked closely with ETL developers and stakeholders to assist them with their agile development life cycle. Excellent Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling. Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch. Very proficient in working with large Databases in DB2, Oracle, Teradata and SQL Server. Experience in data modeling with high proficiency in using Erwin for Dimensional Modeling (Star and Snowflake schemas). Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using. Experience in data modeling with high proficiency in using Erwin for Dimensional Modeling (Star and Snowflake schemas). Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT and dimensions tables, physical and logical data modeling.
HighlightsBI Tools				: TableauETL Tools          : Informatica, Data Stage, Microsoft SQL Server Integrated ServicesRequirements Management      	: Requisite Pro, Microsoft Office (Word, PowerPoint   Excel)Change Management          : HP Open View, CA Service Manager, Lotus Notesamp; Service ManagementFront End Tools          : Microsoft Project, Microsoft Office, Visible AnalystDatabases          : Oracle 9i, SQL Server, DB2, Sybase, Teradata, MS AccessetcDocument management          : Visual Source Safe 6.0, Share point, Ultra Edit, DocumentumDefect management tool          : HP Quality center 10.0Programming Languages          : C, C++, HTML, SQL, PL/SQL, XML, Python, C#Data modeling          : ERwin, ER Studio, MS Visio Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.Prepared several analytical reports comprised of different data modeling techniques such as time series analysis, financial modeling, and trend mapping and supported in MATLAB programmingCollecting data, text standardization and performing text mining using different python libraries to create clusters and classify to compare the results and improve search of the platformEnvironments: SQL/PL-SQL, ETL, Oracle, Windows Server, VMware, Active Directory, Virtualization, Linux, Systems Engineering, Servers, Cisco Systems Products, Microsoft Exchange, MS Office Suite, MS Visio, HTML, MS Access, MS SQL, JavaScript, HTML/HTML5, CSS3, DOM, XHTML, AJAX and jQuery, Bootstrap, AngularJS, SQL Server, SSIS 2008, SSRS 2008, DB2, T-SQL, Oracle and SSMS, Asp.Net, C#, J-Query, MATLAB, Cognos 8.4,10.1 connection MS Office Suite, MS Visio, HTML, UML, C++, Java, MS Visual Basic, VB Script, Test Director, Client Server, Windows XP, MS Access, MS SQL, .NET, Agile, SOA
Experience01/1toPresentTableau Developer /Data AnalystAlteryx Inc.|,OR,Develop various Tableau dashboards and analytical reports and solutions for marketing efforts on medical products and business groups, using Calculations, Filters, Parameters and complex statistical analytics features of Tableau.Work on technical strategy, provided hardware and software configuration, understood client-wide BI implementation project, design and develop visualizations as per requested by CEO and CFO Adjust views/dashboards after initial POC presentation to CEO and CFO.Create views and dashboards on end client's sales data.Produce powerful dashboards using pie, bar, geo, and line charts that are viewed daily by CEO and CFO.Developed and modified database procedures, functions, packages to enhance and improve functionality using PL/SQL.Design and development of Tableau software applications to support reporting and Business Intelligence initiatives, using data analytics, visualization, reporting using OLAP (Online Analytical Processing), data mining, SQL, UNIX, Linux, and Java portal technologies; Perform Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump.Design and develop workbooks, global filter page, and complex parameters based calculations.Create action filters, parameters and calculate sets for preparing dashboards and worksheets in Tableau Access and transform massive campaign datasets through filtering, grouping, aggregation, and statistical calculation.Develop Tableau workbooks from multiple data sources using Data Blending.Work with team of developers to design and develop BI solutions on various marketing and campaign KPIs.Responsible for the design and development of data warehouse, analytics and visualization to meet the big data needs of various products and businesses.Design and deploy rich Graphic visualizations with drill down, and drop down and parameters from ERP databases and complex Dashboard and Storyboard Attributes, Hierarchies, Transformations, Filters, Prompts, Calculated fields, Sets, Groups.Created, organized and formatted reports, folders and other contents on Cognos Connection portal.Involved in migration of Cognos adhoc reports to Tableau workbooks.Converted business requirements into technical specification and design for Reporting Database/data mart, and Adhoc/standard reporting using Cognos 8BI.Perform query search via SQL knowledge and understanding of Data modeling (Dimensional & Relational) concepts Design different front-end forms & dynamic pages using CSS, HTML & given functionality with JavaScript, HTML5, CSS, JavaScript, JQuery, Angular.js Environments: Tableau Server, Tableau Desktop, Agile/Linux, HTML5, CSS, JavaScript, JQuery, Angular.js, Java Portal, PL/SQL, Windows Server, Oracle 10g/9i, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA SCRIPT, J2EE,PL/SQL, Tomcat, MS Visio, MS SQL, Teradata, IBM Cognos 8.4,10.1 connection.01/1to01/1Sr. BI Consultant/ Tableau DeveloperGalaxy Solutions|,CT,Created and assisted users in Tableau dashboard development.Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters, Trend Lines, Statistics, and Log Axes.Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.Developed and designed User Interface using JavaScript, HTML/HTML5, CSS3, HTML5, jQuery, SASS, and AngularJS Performed relational database design and normalization, client-server development, OLAP analysis using pivot charts Migrated Cognos dashboards to Tableau showing Year over Year comparison of different key metrics, Premiums Vs Losses, IBNR etc.Developed Cognos Reports in compliance with user reporting standards Created Tableau extract files for improving the performance.Implemented various Validation Controls for form validation and implemented custom validation controls with JavaScript validation controls.Wrote DDL or DML SQL commands, visualizations in Tableau, to improve data quality, analyzed complex data systems and document data elements, data flow, relationships and dependencies describing what/how/where/why data is stored and how to access the data.Created SSIS packages using C# scripting, script components and script tasks for various Control Flow Tasks and Data flow.Worked with DBAs in order to schedule SSIS packages as jobs either daily, weekly, monthly.Wrote complex PL/SQL queries and designed SSIS packages to load the data into warehouse.Use various SSIS transformations such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.Created the test environment for Staging area, loading the Staging area with data from multiple sources.01/1to01/1Business Intelligence Analyst|City,STATE,Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.Prepared Tableau dashboards using advanced features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.Created detailed technical design documents.Created Data Model for interface.Performed Logical and Physical data modeling within Tableau Server Experienced in Tableau Server Infrastructure: Installation & configuration of Tableau Server in clustered environment and REST API implementation.Involved in the production support and enhancement of the Sharepoint databases.Redesigned standards and procedures and bills of material tables.Created data maps using Informatica Power Exchange 5.1.2.Extensively used lookup, Expression, Aggregator, Normalizer transformation Performed Informatica code reviews.Created ETL design for real time data processing.Designed and implemented Informatica maps, workflows, schedules and scripts.Implemented mapping level data auditing and error handling, source to target mapping.Performed performance tuning of Informatica mappings and databases Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.Wrote stored procedures/Triggers/Views in SQL server and Oracle Developed implementation plans for the SAP modules PP and PP-PI.Implemented Material Variant, Object dependencies, Variant Table, Functions, Variant Pricing, Order BOM and also managed implementation of PP and PP-PI design on SAP 4.7C release Experience in designing Business View Manager, Business Objects universes, complex Crystal and BO reports both Full and Thin Client Reports.Developed reports using Business Objects Web Intelligence to cater Ad-hoc reporting needs.Created reports using Business Objects functionalities like Queries, Drill Down, Cross Tab, Master Detail and Formulae's.Used SQL Server Integrations Services (SSIS) to extract data (ETL), and quickly load data into SQL Server table, and handle data quality issues.Used SQL Server Reporting Services (SSRS) - Reporting Services Components and Business Intelligence Development Studio (BIDS) in order to design and develop reports.Worked in Windows Servers, API, Network technologies with Active Directory, SAML for authentication Environments: SAP BW/BO, SAP Business Objects XI R2 SP2,XIR 3.1 SP3, Designer, Infoview, Web Intelligence, Data Stage 8.1,Sql, PL/SQL, SQL server 2008, Xcelsius 2008,Live Office, Oracle 10g, Windows Server 2003,Clear Case,Clear Quest.MS Excel, MS SQL Server 2008/12 R2, Win Server 2008 R2, Active Directory, Oracle, Windows Server, VMware, Virtualization, Linux, Systems Engineering, Servers, Cisco Systems Products, VMware ESX, Microsoft Exchange, MS Office Suite, MS Visio, HTML, MS Access, JavaScript, HTML/HTML5, CSS3, DOM, XHTML, AJAX and jQuery, Bootstrap, SASS, AngularJS.08/2016to11/2016Business AnalystNA|City,STATE,Worked as a Data Analyst/ Business System Analyst and assisted the project manager in defining the Scope, Best Practices, Schedule, Business Change Management, and Develop Feasibility Study Report for Preliminary Study of the Project and Budget of the Project.Assisted the team members with documentations like Business Requirement Document and Use Case Specification Document by using DOORs, and Best Practice initiatives.Assisted in Data Analysis by Data Mapping then worked with the design team in the designing of the Databases with extensive use of ERDs for Data Validation, Data Modeling, Data Migration, Reference Data Analysis, and Data Conversion.Designed and developed Use Case Diagrams, Activity Diagrams and Sequence Diagrams by using MS Visio.Created a Decision Support System via Dimensional Modeling by ensuring appropriate FACTS tables, DIMENSIONS tables, attributes, and entities in order to generate MEASURES as required in Data Warehousing (EDW) and Data Migration by business users.Resource monitoring and repository Audit reporting.Worked on Backup and restoration.
EducationExpected intotoBachelor of Science|Chemical EngineeringOklahoma State University,Stillwater,OklahomaGPA:Chemical Engineering
Skills.NET, Asp.Net, Active Directory, Ad, Agile, AJAX, Analyst, API, Audit reporting, auditing, Backup, basic, big data, Budget, BI, Business Intelligence, Business Objects, C, C++, Change Management, charts, Cisco, Client Server, client-server, CMS, Cognos 8.4, Cognos, CA, hardware, content, Crystal, CSS, CSS3, Client, Data Analyst, Data Analysis, Data Conversion, data processing, Data Migration, data mining, Data Modeling, Data Validation, data warehouse, Databases, Database, Data Stage 8.1, Data Warehousing, Decision Support, designing, DIMENSIONS, DML, Document management, Documentum, DOM, DOORs, Edit, ERP, ERwin, ETL, XML, Feasibility Study, features, financial modeling, forms, Graphic, HP, Open View, HTML, HTML5, IBM, DB2, Informatica, J2EE, Java, JavaScript, JAVA SCRIPT, JQuery, J-Query, Linux, Lotus Notes, marketing, MATLAB, Access, MS Access, C#, MS Excel, Excel, Exchange 5.1.2, Microsoft Exchange, Microsoft Office, MS Office Suite, Office, PowerPoint, PP, Microsoft Project, Sharepoint, Share point, Win, Windows, 3.1, Windows XP, Word, migration, Modeling, Network, OLAP, Oracle 9, Oracle, PL-SQL, PL/SQL, page, Pricing, Programming, Python, Quality, Quest, real time, relational database design, reporting, Requirement, sales, SAP BW, SAP, SAP 4.7, Servers, scripting, scripts, script, Visual Source Safe 6.0, Specification, Sql, MS SQL Server, MS SQL, Microsoft SQL Server, SQL Server, Statistics, strategy, Sybase, System Analyst, Systems Engineering, Tableau, tables, Teradata, Test Director, Tomcat, T-SQL, Trend, UML, UNIX, upgrades, upgrading, User Interface, Validation, VB Script, View, Visio, MS Visual Basic, Web Intelligence, Windows Server, XHTML>>. The result is, 

Fit assessment: Good Fit