Business Intelligence Analyst / Developer Resume
Philadelphia-pA
SUMMARY
- Over 7+ years of experience in Requirement Gathering, Analysis, Documentation, Design, Development, Testing, and Implementation in Business Intelligence and Software Applications.
- 6+ Years of extensive Tableau Experience in Enterprise Environment, in Tableau as a Developer, Administrator and Analyst.
- Proficient in Installing, Configuring and Administration of Tableau Server and good understanding of Tableau architecture, design, development and end user experience
- Good Knowledge in Users and Group Management, Licensing and Data Connections, Web data connectors, Scheduling in Tableau Server.
- Create/Modify/Manage server task Scheduled data refresh on Tableau Server for increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
- Good in creating complex formulas, Level of Detail Expressions and complex calculations within Tableau to meet the needs of complex business logic.
- Extensive knowledge of Tableau Server Concepts like tabcmd, tab admin, creating/ adding users, sites and projects, managing licenses and data connections, scheduling tasks.
- Extensive knowledge in creating various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters, aggregates, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters.
- Hands on experience in content migration between environments with high level enterprise tools like TabRESTMigrate, EDT.
- Experience with utilizing scripting languages to leverage Tableau's APIs ( JavaScript API, Data Extract API, REST API).
- Good Knowledge in Automating and implementing Server level activities like Triggering and Scheduling extracts with coordination with ETL and DB jobs.
- Experience in implementing Data blending, replace references, Customized queries with help of CustomSQL and advanced visualizations in Tableau.
- Diversified experience in implementation of BI systems within Healthcare, Finance, Pharmaceutical, Insurance, Accounting and Telecom sectors, etc.
- Expertise in gathering, analyzing and documenting Business Requirements and Data Specifications.
- Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, Table Variables and Stored Procedures.
- Experience with Alteryx to collect the required data from large complex databases.
- Hands on experience on Hortonworks and Cloudera Hadoop (HDFS, YARN) environments.
- Expertise in testing Data Warehousing jobs (Informatica, SSIS, Data Stage) and applications, Business Intelligence reports (OBIEE, SSRS, Business Objects, BEx, Tableau, Cognos, Grafana), Java based applications, Quality Assurance and management, Risk, Compliance, Data management, Internal audit and Enterprise risk management projects and programs.
- Experience in developing reports from various sources like Oracle, PL/SQL, MS SQL Server, Access, Azure, AWS RedShift, Vertica, SaaS, Teradata, DB2, MongoDB, RDBMS, Adobe Files.
- Experience in connecting and working with CRM Data like Salesforce and JIRA Data.
- Experience in working with Operating Systems like Windows and UNIX.
- Train the users on the BI practice within the organization.
- Highly skilled, self - motivated team player, outstanding organizational, excellent communication and interpersonal skills with result-oriented dedication towards goals.
TECHNICAL SKILLS
Business Intelligence: SAP Business Objects XI R4.x/3.x/XI R3/XI R2/6.x/5.x, SSIS, SSRS, SSMS,SAP HANA, WebI XI R2/6.x/2.x, Infoview, CMC, Crystal, Xcelsius, Tableau, QlikView Dashboards, Grafana, Scorecards, Hadoop Ecosystem.
RDBMS: Oracle 10g/11g/12c, SQL Server, SAAS, MS Access, Azure, Snowflake, Visual Studio, ERP, Teradata, Hadoop, Impala, Jira Data, Spark, SAS, AWS RedShift.
Programming Languages: SQL, Python, R- programming, HTML, XML, XSD, JavaScript, JQuery, Node.js, C#.
ETL Tools: Informatica Power center/ Power mart, SSIS, Alteryx, Logstash, Pentaho, Tableau Prep. TOAD
Operating Systems: Windows, UNIX.
PROFESSIONAL EXPERIENCE
Confidential, Philadelphia-PA
Business Intelligence Analyst / Developer
Responsibilities:
- Involved in requirement gathering and analyzing business requirements from mobile team.
- Designing and developing visualization solutions for clients according to specifications.
- Working in coordination with Clients for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement.
- Translating business requirements into report visualization, design documents. Developed metrics, attributes, filters, reports, dashboards and created advanced chart types, visualizations and complex calculations to manipulate the data.
- Follow approved life cycle methodology.
- Automated Tableau Extracts with TabCMD for more reliability and avoid queue on Tableau Server.
- Trained users on site administration by providing step-by-step guidance from basics to advanced functions.
- Prepare Data for reporting, data blending and advanced data analytics. using alteryx
- Performance Tuning and Optimization.
- Understand data modeling based on specifications.
- Coordination with business and technical teams on Analytics, problem-solving, time management.
- Work with Agile/Scrum development methodology.
- Defect analysis and assisting QA team in testing the reports and fixed the defects.
- Assisted users in UAT
Environment: Tableau Desktop2019.2, 2018.3, Tableau Server2020.1, 2019.2, 2018.3, Tableau Prep, SQL Server, Cloudera-Impala, Spark, JIRA, Python, CRM DATA(Salesforce), Alteryx, AWS RedShift, Vertica, MS Access, Azure.
Confidential
BI-Tableau Development Advisor
Responsibilities:
- Involved in requirement gathering and analyzing business requirements from clients
- Providing best practice solutions on designing and developing of front-end BI applications and Visualization solutions for clients according to specifications.
- Assisted Admins in Administrating user, user groups, and scheduled instances for reports in Tableau.
- Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
- Performing Migration of workbooks between different environments using TabRESTMigrate.
- Visualized the objects created in Teradata using Tableau to demonstrate data and visual analysis.
- Working in coordination with Clients for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement.
- Translating business requirements into report visualization, design documents.
- Developed metrics, attributes, filters, reports, dashboards and created advanced chart types, visualizations and complex calculations to manipulate the data.
- Build prototypes for demonstration and illustration purposes for peer groups, business partners, senior leaders followed by design, deployment and on-going enhancements.
- Creating and Scheduling AutoSys jobs to trigger Tableau extracts in sync with DB jobs
- Create/Manage Groups, Workbooks and Projects, Database Views, Data Sources and Data Connections.
- Coordination with business and technical teams.
- Defect analysis and assisting QA team in testing the reports and fixed the defects.
- Assisted users in UAT
Environment: Tableau Desktop 2018.1, 2019.1, Tableau Server 2018.1, Tableau Prep, Teradata, SAS, ServiceNow, MS Office tools.
Confidential, Philadelphia-PA
BI Analyst /Tableau Reports Developer
Responsibilities:
- Involved in requirement gathering and analyzing business requirements from mobile team.
- Designing and developing visualization solutions for clients according to specifications.
- Develop solutions to loosely defined business problems by leveraging pattern detection over potentially large datasets
- Working in coordination with Clients for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement.
- Translating business requirements into report visualization, design documents. Developed metrics, attributes, filters, reports, dashboards and created advanced chart types, visualizations and complex calculations to manipulate the data.
- Follow approved life cycle methodology.
- Trained users on site administration by providing step-by-step guidance from basics to advanced functions.
- Performance Tuning and Optimization.
- Understand data modeling based on specifications.
- Coordination with business and technical teams on Analytics, problem-solving, time management.
- Work with Agile/Scrum development methodology.
- Defect analysis and assisting QA team in testing the reports and fixed the defects.
- Assisted users in UAT
Environment: Tableau Desktop 10.3, 2018.3, Tableau Server 10.3, Tableau Prep, SQL Server, Cloudera-Impala, MS Office tools.