We provide IT Staff Augmentation Services!

Senior Bi Developer/data Analyst Resume

SUMMARY

  • Excellent knowledge and usage of reporting tools such as Tableau, PowerBI and Looker.
  • SQL server Architect with numerous years of experience working with financial, insurance and healthcare domain. Proven ability in working with enterprise level large data warehouses, RDBMS systems, and ETL and modeling tools/techniques.
  • Passionate about data quality and consistency.
  • Familiar with retail, wholesale, planning and allocation systems, or supply chain operations
  • Strong analytic skills, attention to detail, ability to multi - task, troubleshoot and problem solve along with the ability to make recommendations based on analysis.
  • Excellent in data mining for fulfilling customer segmentation business requests and periodic report generation.
  • Worked with different source systems like Teradata, Oracle 10g and Microsoft SQL Server.
  • Excellent in writing highly complex and well-tuned SQL queries to fulfill ad-hoc and strategic data segmentation requests.
  • Experience with Alteryx in data cleansing and building workflows
  • Experience in Data Analysis and ETL techniques for loading enormous amounts of data.
  • Experience with DATA MINING.
  • Extensive Tableau Experience in Enterprise Environment, in Tableau as a Developer and Analyst
  • Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
  • Self-motivated individual with strong communication skills, great attention to detail and the ability to work under pressure.
  • Self-managed, highly motivated and have a strong drive for results.
  • Ability to exert influence, drive and steer stakeholders in the right direction.
  • Proven, demonstrated capability in gathering and documenting complex business and functional requirements.
  • Ability to grasp concepts quickly and reduce them to practice with minimal supervision in a fast-paced environment.
  • Ability to manage changing priorities and plan effectively in order to meet deadlines.
  • Exceptional organizational and time management skills and the ability to work independently.
  • Excellent team player with demonstrated experience of working diplomatically and collaboratively with all levels of staff to ensure successful implementation of assignments.
  • Experience in data scrubbing and cleansing.
  • Great understanding of SDLC methodologies such as Waterfall and Agile (specifically SCRUM).
  • Possess strong computer and office administration skills with a vast knowledge of Windows and Microsoft Office Suite (Word, Excel, PowerPoint, Access, and Visio).

TECHNICAL SKILLS

Operating Systems: Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64), Unix

Databases: MS SQL Server 2005/2008/2012 , Teradata 12/13, MySQL 5.2, 5.7, Oracle 9i, 10g 11g, DB2, Google Big query

ETL/Other Tools: Informatica Power Center 8.6.1/9, SAS Base 9.x, SAS Enterprise Guide, SSIS

Test Tools: HP Quick Test Professional 10/11, HP Quality Center 10

Querying Tools: SQL Management Studio 2008/2012, Teradata SQL Assistant, SQL Plus, SQL

Data Analytic Tools: Python

Business Intelligence Tools: Power BI, Tableau 9.1, 9.2, 9.3, 10.4, Looker, Cognos, Excel and PowerPivot, SSRS

PROFESSIONAL EXPERIENCE

Confidential

Senior BI Developer/Data Analyst

Responsibilities:

  • Gather requirements from senior management to build visualizations required to meet business needs and help make decisions.
  • Work with senior management to help analyze and project data using visualization tools like Tableau and Power BI.
  • Analyze business logic and test business logic by querying database and presenting daily, weekly and monthly reports to help the data governance and data integrity team.
  • Provide Power BI and tableau trainings to clients to help build capacity to use visualization tools and provide guidance as necessary
  • Create custom visuals based on business requirement not available in the tool to help the business and management easily understand visualizations based on familiar reports.
  • Transition reports previously prepared using power point into visualization tools and significantly help the company timely visualize accurate data.
  • Help with data integrity by constantly reviewing underlying data results and communicating with the data integrity team as necessary to help improve data models and structures.
  • Partner with business teams to gather, document and maintain business requirements that will inform data modeling decisions, relevant data features and KPIs.
  • Lead user story workshops for the definition of use cases, business analysis, and requirements gathering.
  • Translate business requirements into process/system functional requirements and identify/assess potential data source(s)
  • Deliver functional scope analysis and detailed solution design of the processes and reporting systems and partner with developers on data requirements needed to support the build of data models
  • Meet with the ETL team constantly and provide recommendation on data models required to meet data governance requirements
  • Ensure delivery meets agreed upon requirements.
  • Leads or assist with end user training of business intelligence, visualization, and analytics tools.
  • Execute thorough testing of enhanced or added system functionality
  • Lead QA and testing efforts including the creation of test scripts and user acceptance testing.
  • Participate in release management and change management initiatives.
  • Participate in the construction of a strategic roadmap for business intelligence and analytics across the enterprise.
  • Ensure project documents are complete, thorough, accurate, current and stored appropriately.
  • Maintain project plans and task lists for self in an organized fashion.
  • Create detailed epics, stories, feature specs that meet business criteria.
  • Write and execute effective test plans and test cases, manage requirements traceability, document test results, track defects, and work with developers to resolve issues.
  • Customer Satisfaction
  • Build strong relationships with our business partners and work collaboratively in a cross-functional matrix environment.
  • Continually seeks opportunities to increase customer satisfaction and deepen relationships.
  • Communicate project status and application issues to necessary stakeholders and supervisor.
  • Manages customer expectations effectively.
  • Operate in an agile development environment with rapid, iterative releases.
  • Provide agreed upon service level of production system support.

Confidential

BI Developer/Data Analyst

Responsibilities:

  • Process and reconcile transactional data feeds from various clients to produce tax reports for the tax engagement teams.
  • Created, organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
  • Utilized Power BI to create various analytical dashboards that depicts critical performance indicators using slicers and enabled filters.
  • Utilized Query Editor to clean and format data and eliminate redundant information and append and merge tables from various data sources.
  • Utilized Geolocation on Power BI Mobile to filter information from the datasets according to the needs of the end user
  • Created hierarchies in Power BI to help end users make accurate decisions based on the visualizations.
  • Developed reports and dashboards using Microsoft Power BI stack -Expertise in Creating reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc.
  • Created Custom Visuals in Power BI to help end users visualize their reports effectively.
  • Utilized Slicers and Filters in Power BI to accurately sort visuals and make sure the end user has the relevant information available.
  • Design analytical approach to open-ended strategic business problems.
  • Apply statistics, clustering, modeling, and machine learning algorithms to complex business problems.
  • 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 reports and dashboards using KPI's
  • Created demos in Tableau Desktop and published onto Tableau Server.
  • Design re-usable workflows using Alteryx to cleanse and prepare workpapers
  • Support team with a variety of data analytic tasks including: data collection/retrieval from source systems, data loading/normalization, testing for accuracy/completeness, analysis/modeling, and reporting/communicating results
  • Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
  • Well experienced in SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, and SQL Query Analyzer. Experienced in creating ad-hoc reporting in SSRS.
  • Leverage Tableau desktop to bring data to life through visualization and storytelling to help clients visualize tax impacts in various jurisdictions
  • Manage a team, interact directly with clients and other resources to obtain relevant data and documents in formats consistent with project objectives and deadlines, review project deliverables, and resolve project issues
  • Contribute to sharing and documenting knowledge as well as building out an analytics repository.
  • Perform explanatory data analyses, generate and test working hypotheses, prepare and analyze historical data, identify patterns and communicate findings via visualization tools
  • Interpret the analysis with a focus on actionable recommendations.
  • 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.
  • Involved in reviewing business requirements and analyzing data sources from Excel, Oracle, Teradata, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
  • Escalate issues and concerns appropriately.

Confidential, Columbus, OH

Senior BI /ETL Developer

Responsibilities:

  • Develop database objects such as tables, views, common table expressions, dynamic SQL, foreign key constraints, and stored procedures.
  • Designs logical and physical databases (OLAP and OLTP) or reviews description of changes to database design.
  • Assist others with SQL performance tuning including index recommendations or hardware configuration considerations.
  • Monitoring database performance indicators of development and test environment to ensure promotion to production environment brings no surprises.
  • Diagnose database issues related to development activities in development and test environments.
  • Wrote queries to gather data from different tables by using JOINs, sub-queries, correlated sub-queries and derived tables on SQL Server platform.
  • Wrote SQL queries that were highly tuned using concepts like Explain, Stats, CAST and volatile tables.
  • Wrote complex SQL queries using advanced SQL concepts like aggregate functions, Group by and OLAP (Online Analytical Functions).
  • Used SAS to import and export data from and into SQL Server tables.
  • Planned, analyzed and designed Universes using SAP Business Objects as per Business needs.
  • Impersonating with a Run as User Account, Impersonating with Embedded SQL Credentials. Exported and imported data from Flat file, CSV file, Excel to/ from SQL Server Database using SSIS. Created tabular, list, matrix reports and writing queries stop form drill down operations in SSRS. Used Pivot tables to create reports that did dicing and slicing functions on data. This is called dimensional analysis and provides a 360 view of what is going on.
  • Created numerous permanent tables, Volatile tables and Global Temporary tables.

Confidential

Data Analyst

Responsibilities:

  • Wrote complex SQL queries using advanced SQL concepts like aggregate functions, Group by and OLAP (Online Analytical Functions).
  • Wrote queries to fetch data from different table by using JOINs, Sub-queries, Correlated sub-queries and derived tables on Teradata platform.
  • Wrote SQL queries that were highly tuned using concepts like Explain, Stats, CAST and volatile tables.
  • Developed number of Complex Informatica Mappings, Reusable Transformations for different Systems to facilitate Daily, Monthly and Yearly Loading of Data
  • Used SAS to import and export data from and into Teradata tables.
  • Worked with OLAP and OLTP tools such as ETL, data warehousing and Modeling.
  • Participated in analyzing business requirements, Use Case Modeling, Data Model Design, Data flow from various Sources to Target.
  • Planned, analyzed and designed Universes using SAP Business Objects as per Business needs.
  • Used Pivot tables to create reports that did dicing and slicing functions on data. This is called dimensional analysis and gives business a 360 view of what is going on.
  • Created numerous permanent tables, Volatile tables and Global Temporary tables.
  • Monitored and maintained user container space and suggested improvements in table creation to user who had skewed numbers.
  • Prepare high level analysis reports with Excel and Tableau
  • Converted user requirements into business requirements, analyzed the same, and segregated them into high level and low-level business requirements
  • Performed ad-hoc reporting analysis as well as manipulate complex data on MS SQL server.

Hire Now