Sr. Bi Developer/ Data Analyst Resume
JacksonvillE
SUMMARY:
- Over 7 years of experience in Oracle, SQL and PL/ SQL Administration, design, analysis, development and implementation of various applications in Client/Server OLAP environment using BI Tools.
- Ability to work with several types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.
- Delivered BI Reporting solutions in Tableau Desktop/Server, SSRS and PowerBI.
- Experienced in Tableau Desktop/server 10.x,9.x,8.x
- Expert in creating and developing Power BI Dashboards in to rich look.
- Extensive knowledge on PL/SQL scriptsfor Data loading and Data extraction
- Experience in creating different visualizations/Dashboards using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
- Experience in using unique features of Tableau Desktop like Filters, Parameter, Actions, Calculations (logical, String, Table, Aggregate functions) and formatting the reports/dashboards (Layout Containers, Annotations, Mark Labels etc.,)
- Experience Tableau Administration including Installation, Configuration, Upgrade, technical support, troubleshooting, report design and monitoring of server.
- Experience in creating users, groups, sites, projects etc., and managing licenses, data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
- Effectively worked withData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniques.
- Involved inTrouble Shooting, Performance tuning of reportsand resolving issues withinTableau Serveranddashboards.
- Experience in creating tableau utilities using Tabadmin/Tabcmd, providing automatic notifications, back-ups, dashboard promotion to different environments like DEV/QA/PROD.
- Experienced in creating data modeling and relationships using Erwin and Toad data modeler.
- Well versed in PL/SQL with experience in constructing the triggers, tables, collections, Packages, functions, Cursors, Stored procedures, user defined data type etc.
- Skillful in ETL - Extraction Transformation Loading, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
- Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools.
- Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedure consumed at various stages of migration/cleansing process, reports or data validation.
- Proficient in writing complex T-SQL (DDL, DML), CTE, Ranking Functions, PIVOT, XML PATH, Stored Procedures, Functions, Physical, logical database design and Performance tuning.
- Created complex ad-hoc Reports using data access and report design using Web Intelligence modules, Business Objects, Crystal Reports.
- Used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Cross Tab, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
- Created reports in MicroStrategy including freeform SQL reports, data mart reports, etc.
- Good knowledge of Data Warehousing concepts and RDBMS
- Knowledge in all types of Database migrations with all the versions of SQL Server.
- Experience in Migrating databases from SQL 2008 R2 to SQL 2012.
- Experienced in Data mapping, updating and retrieving required data from metadata portal, creating mapping rules and load rule and preparing Change log documents as part of System Analyst.
- Expertise in conducting FIT-GAP Analysis, create Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
- Experience in development of data mappings and the development of ETL routines for migrating data from non-relational or source relational to target relational.
- Strong analytical skills and methodical approach to problem solving.
- Experience in Risk Analysis & Risk Management for product life cycle and in process of implementing document.
- Excellent communication and coordination skills, Documentation Skills, Team problem solving ability, analytical and programming skills in high speed, quality conscious, Multitasked environment.
- Proficient in creating and reviewing Test Plans, Test Strategy and Test Cases by collaborating with the QA team.
- Excellent knowledge of HIPAA (Health Insurance Portability and Accountability Act) transaction codes.
- Excellent understanding PHI (Protected Health Information).
- Experienced in Implementation and Effort Estimation.
- Experience as Software Engineer with onsite and offshore teams, leading development of applications.
- Experienced in Waterfall and AGILE methodologies.
- Good hands on experience using Rally.
TECHNICAL SKILLS:
BI Tools: Tableau 10.x/9.x/8.x/7.x (Tableau(Desktop & Server), Power BI, SSRS, OBIEE
Databases: Netezza, IBM DB2, Oracle 9i/10g/11g, SQL Server 2012/2008/2005 , MS Access, MongoDB, Teradata, My SQL, Hive
Data Modeling: Dimensional Data Modeling, Toad Modeler, Erwin FACT and Dimensions Tables, Star Schema, Snowflake Schema, OLAP, OLTP Physical and Logical Data Modeling
SQL Server Tools: SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS).
Programming Languages: T-SQL, SQL, PL/SQL, C, C++, XML
Technologies: HTML, CSS, JavaScript
Packages / Tools: MS Office, Toad, Putty, SQL Server Management studio, Microsoft Visual Studio, MS Excel, Informatica, Selenium, QTP, TFS, SVN, GitHub, MS Visio
Operating Systems: Windows XP, Windows95/98/2000, Linux, Unix
Methodologies: Agile, Waterfall, RUP, UML, SDLC, Scrum, RUP, V-shape modelling.
PROFESSIONAL EXPERIENCE:
Confidential, Jacksonville
Sr. BI Developer/ Data Analyst
Responsibilities:
- 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.
- Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
- Created stored procedures and performed index analysis for slow performing SSRS reports to bring down the report rendering time to minimal.
- Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools likeToad, PL/SQL DeveloperandSQL* plus.
- Designed Summary and Detailed reports using Data Blending feature in Tableau and utilized the cascading feature on Dimensions to provide dependency on objects through filters.
- Defined best practices for Tableau report development.
- Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
- Interacted with business users and performed Gap Analysis of Client requirements.
- Consistently attended meetings with the Client subject matter experts to acquire functional business requirements to build SQL queries that would be used in dashboards to satisfy the business’s needs.
- 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.
- Extensively usedbulk collectionin PL/SQL objects for improving the performing.
- Performed report validation writing SQL queries using SQL assistant on a Teradata database.
- Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary.
- Worked onXMLalong with PL/SQL to develop and modify web forms.
- Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
- Working on analyzing the existing BI infrastructure and coordinating with various teams to install and configure single node Tableau server environment and creating sites, users, groups and granting the required permissions.
- Blendeddata frommultiple databases into one report by selecting primary keysfrom each databasefor data validation.
- Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
- Converted charts into Crosstabs for further underlying data analysis inMSExcel.
- Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
- Developed story telling dashboards inTableauDesktop and published them on toTableauServer which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
- Scheduled data refresh onTableauServer for weeklyand monthlyincrementsbased on business change to ensure that the views and dashboards were displaying the changed data accurately.
- Involved in report tuning, caching, specifying query governing thresholds, and report optimizations
- Created SSRS reports based on client requirements
- Involved in data blending data mapping for SSRS report creations
- Created stored procedures which meets the requirements
- Created SSRS Dashboards for executives
- Granted permissions to users to access SSRS reports
- Supported for SSRS reports issues
- Load the data into premises SQL Server from various sources i.e. Flat files, Excel, CSV, Oracle.
- Created Email subscriptions for SSRS reports
- Deploying the SSRS reports into different servers based on Business Specific servers.
- Served as a power user for troubleshooting various issues or problems to use Tableau platform and administer Tableau.
- Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes.
- Verification of fixes done and defect closing along with attaching supporting documents and data.
- Assisted in Conducting UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application and gets sign off from Business to move production.
- Proactively started initiative to begin Root Cause Analysis (RCA) on known issues, which had impacts on further upstream\downstream processes which reduced the number of issues\defects.
- Created Data mapping files as per client requirements on time.
- Develop efficient pig and hive scripts with joins on datasets using various techniques.
- Involved in Creating Mapping Rules Document for Client requirement.
- Worked well with Metadata Portal to retrieve required data and information regarding the backend data.
- Worked on creating load rule Documents which can help a developer to load the data in to the file or table.
- Preparing Change log documents which defines the logical and the physical names along with the field definitions which helps the data modeler the built the model of the table to create through hierarchy from enterprise level by maintaining standards of organizations.
- Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
- Performed Smoke Testing, Functional testing, and System integration testing, Regression testing, Database testing, and black box testing at various Phases of the development and test cycles
Tools & Technology::Agile methodology, Tableau Desktop & Server10.x/9.x, Power BI, Microsoft office, SQL Server 2012, IBM DB2, Netezza, Hive, Teradata, SharePoint, Rally, Agile Methodology, Visual Studio 2012, JIRA, BIDS, Metadata, TOAD, SQL Navigator, SSRS, SVN, Excel.
Confidential, Baltimore
Tableau Developer
Responsibilities:
- Understanding existing business model and customer's new requirements.
- Connected to various data sources like Oracle DB, SQL server and excel.
- Wrote heavy stored procedures using PL/SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
- Created workbooks and Dashboards using calculated metrics for different visualization requirements
- Drew upon full range ofTableauplatform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
- Extensively created visualization dashboards for the claims.
- Translated the T-SQL procedure, function and views into Oracle's PL/SQL Packages, Procedure, Function and Views
- Created Rich Graphic visualization/dashboards to enable a fast read on claims and key business drivers and to direct attention to key area.
- Involved in creating dashboards, reports and then published onto the Tableau server.
- Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
- Incorporated a regional and national comparative / benchmark metrics to give context to Horizon performance
- Effectively used data blending, filters, actions, Hierarchies feature intableau
- Created extensive custom joins for blending data from several different data sources
- Helped customizeTableauServer with Company Logo
- Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics.
- Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
- Coordinate new data development, which includes the creation of new structure to meet business requirements or streamline existing processes to reduce overhead on the existing warehouse with ETL Development team.
- Collaborated with business users and members of the BI team, including business analysts, data warehousedevelopers, and managers, to design and develop as per requirement.
- Created a proof of concept for the optimal data integration process.
- CreatedTableauscorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality during POC.
- 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
Tools & Technology:Agile Methodology, TableauDesktop & Server 8.x/9.x,PL/SQL, TOAD,SQL Server 2008, MS Office.
Confidential
Tableau Developer/Data Analyst
Responsibilities:
- Understanding Business Requirement and providing solutions by analyzing data sets.
- Developed compelling, Interactive Dashboards using unique features like Filters, Parameter, Actions, Calculations and formatting the reports/dashboards.
- Build information platform or data spaces designed for exploring and understanding the data.
- Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL.
- Involved in Installation, Configuration and upgrade of the Tableau Server environment and Manage/create users, groups, projects, sites etc.,
- Creating server administration report by connecting to tableau-postgre database.
- Trained the business users on tableau’s self-service model of creating and publishing the reports.
- Partner with Technology to help identify data for a specific analysis or application and design the structures and standards that support the effective management, governance and use of information assets to support business products, projects and initiatives.
- Design/lead/develop prototypes for business so that business users may visually understand and explore a new feature or functionality before implementation to expose design assumptions and drive ideation.
- Designed competent pl/sql programs using pl/sql collections, Records types, Object types.
- Ensured prototypes meet the organization standards to allow transfer to production.
- Developed Cross Tab, Chart and Drill Through Reports in Tableau Desktop
- Modified and maintained Universes using Designer module to include objects like Dimensions, Details and Measures according to the Functional specifications.
- Developed test plans and scripts, prepare test data, reconcile data sources and execute functional tests.
- Build relationship with Technology partners. Support communication and cooperation between the teams.
Tools & Technology:Tableau Desktop & Server 7.x/8.x, Business Objects XIr3, PL/SQL, SQL Server 2008, Excel, Oracle 11g, Toad.
Confidential
SQL Developer/ Data Analyst
Responsibilities:
- Met with Customers to determine User requirements and Business Goals.
- Blended technical and business knowledge with communication skills to bridge the gap between internal business and technical objectives and serve as an IT liaison with the business user constituents.
- ConductedJAD sessionsto gather requirements, performedUse Caseandwork flow analysis, outlined business rules, and developed domain object models
- Created a conceptual design based on the interaction with the functional and technical team.
- Analyzed the existing data model and incorporated new additions for the advancement data into the data model identifying the cardinality of the new tables to the existing tables and ensure proper referential integrity of the system
- Analyzed, created and formatted the Reports as per Business Requirements.
- Analyzed and created various adhoc Reports for users based on User Requirements.
- Created both list and drill down reports identifying the data hierarchy
- Performed report validation writing SQL queries using TOAD on an Oracle database.
- Created process documents, reporting specs and templates, training material and slideshow presentations for the application development teams and managements
- Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
- Created reports using Business Objects functionalities like queries, cross tab, master detail reports, formulas, Customized filters to display relevant data, etc.
- Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.
- Createdand maintained specifications and process documentation to produce the required data deliverables (data profiling, source to Client maps, flows).
- Exported crystal/SSRS reports into various formats like PDF, HTML, Excel and Word for end users.
- Configured Reporting Services in SQL Server 2005.
- Created standard Reports and Cross Tab Reports and Drill Through reports in SSRS.
- Generated Reports using Global Variables, Expressions and Functions for the SSRS reports.
Tools & Technology:Oracle 10g, SQL Server 2005, Business Objects XIr2, Informatica.
Confidential
Data Analyst
Responsibilities:
- Met with Customers to determine User requirements and Business Goals.
- Blended technical and business knowledge with communication skills to bridge the gap between internal business and technical objectives and serve as an IT liaison with the business user constituents.
- ConductedJAD sessionsto gather requirements, performedUse Caseandwork flow analysis, outlined business rules, and developed domain object models
- Created a conceptual design based on the interaction with the functional and technical team.
- Analyzed, created and formatted the Reports as per Business Requirements.
- Used MicroStrategy Report Services to create dashboard reports.
- Analyzed and created various adhoc reports for users based on User Requirements.
- Created both list and drill down reports identifying the data hierarchy
- Created process documents, reporting specs and templates, training material and slideshow presentations for the application development teams and managements
- Analysis of the data identifying source of data and data mappings of BHC.
- Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
- Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.
- Ensure that models conform to established best practices (including normalization rules) and accommodate change in a cost-effective and timely manner.
- Managed the data as per specifications of Actimize and performed production releases of the designed models using Informatica PowerCenter Vr.8.6.
- Ensured end-to-end implementation of releases (development, UAT and production)
Tools & Technology:Oracle 10g, Windows, Microstrategy, MS Visio, MS Project, Informatica