BI / Tableau Developer
Resume:
teja
***********@*****.***
Summary
• 7 years of experience in Microsoft Database Technologies that includes experience in Database Design and Development in various Domains. Experience in Business intelligence as BI Developer in data modelling, development and maintenance of database applications on SQL Server in OLTP/OLAP/BI environment.
• Knowledge of SDLC phases such as Requirement analysis, design, development, implementation, deployment and maintenance with Good understanding of methodologies like Waterfall and Agile.
• Worked on Power BI and prepared dashboards using Tableau to make it more attractive.
• Created hierarchies in Power BI reports using Data visualizations like Bar chart, Line chart, pie charts, forecast charts.
• Experience on publishing Power BI reports of dashboards in Power BI server and Scheduling the dataset to refresh for upcoming data in power BI server.
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards per the client Requirements.
• Experienced on Microsoft Business Intelligence Suite (Power Pivot, Power View, Power Query, Power Maps, Power BI Desktop, Power BI Service, Power BI Mobile App).
• Fully exposed to Software Development Life Cycle (Agile and waterfall methodology) and Test-Driven Development.
• Developed the application using Java 8 and implemented its features like lambdas Expressions, Time API, Streams, functional interfaces, collectors, default methods, type interfaces, foreach.
• Experience in working Confidential Azure cloud platform in components of ADF, ADL and Azure SQL & Datawarehouse.
• Knowledge on reporting tool Tableau and Confidential Azure Cloud space.
• Utilize Power Query in Power BI to pivot & Unpivot data model for data cleansing & massaging
• Experience in creating Tabular Reports, Matrix Reports, Parameterized Reports, Sub Reports, Global map reports in both Power BI Desktop and Power BI Cloud service.
• Robust MS Access and excel skills with Power pivot, PivotTable, PivotChart, Power view, VLOOKUP functions and formulas.
• Used tools like MS SQL Profiler, Index Tuning Wizard, and Windows performance for monitoring and tuning SQL Server performance.
• Designing, Scheduling and Maintaining ETL Framework for different Processes.
• Data Mapping Skills, Data Migration Methods and Validations from Legacy Systems.
• Developed OLAP cubes using SSAS (SQL Server Analysis Services) and calculate the metrics that were revealed in the functional analysis.
• Exposure in writing SQL using analytical functions like Ranking Functions, Reporting Aggregate Functions, LAG/LEAD Functions
• Proficient Knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
• Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending and managed Database Views available to all BI and DW applications.
• Outstanding knowledge in Microsoft Office suite (MS Word, MS Excel, MS PowerPoint, MS Project, MS Visio).
• Good knowledge in Business Intelligence (BI)/ data warehouse (DWH) concepts, designs SSAS, and project implementations.
• Experience in developing data applications in Linux/Windows environments.
• Good and Effective Communication with all levels of business partners with Business Analysts to ensure the requirements are completely analyzed and technical owners to minimize risks.
Skills
SDLC, Agile, Waterfall, SQL, Oracle, Tableau Server, ETL, KPI, Informatica, SSRS, SSIS, SSAS, POWER BI, SQL Server Management Studio, Enterprise Manager, BI Development Studio, SQL Server, MS-Access, Data Visualization, MySQL, MS Office, MS Project, OLAP, UML, MS Visio, MS Outlook, Microsoft Office SharePoint Server, Windows, Linux.
EDUCATION:
Bachelor of Technology in Computer Science Engineering.2013 JNTU.
Executive Master in Information Systems Security ( Masters). 2017 University Of Cumberland’s.
Professional Work Experience
Client: Capital One Jan 2020 – Till Date
Location: Washington ‘DC.
Role: BI / Tableau Developer
Responsibilities:
• Designed dynamic ETL SSIS packages dealing with different data sources and loaded data into target data warehouse by performing different kinds of transforms using SSIS
• Developed T-SQL coding and table templates in database for preparing, processing and analyzing risk data
• Communicated with statistics, SAS, risk management team for better preparation of T-SQL and to help generate risk management model
• Utilized SQL programming skills within SAS model team and performed all programming required for branded card analysis and reporting
• Created scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using both Tableau and QlikView for different requirements
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed managers to understand the data on the fly with the usage of quick filters for on demand needed information
• Generated complex reports using multiple functionalities including global filters, parameters, actions, dynamic sets, groups
• Deployed Tableau workbooks onto Tableau Server and implemented row level security, scheduled data refresh on Tableau Server to ensure data accuracy
• Analyzed report performance by recording workbook timeline execution query and by generating performance workbook using Tableau desktop and Tableau Server
Environment: Tableau 8.1, Tableau 8.2, QlikView, MS SQL Server 2012, MySQL Database, SQL Server Integration Services (SSIS), MS Office
Environment: SQL, T-SQL, Power BI, DAX, SSRS, SQL, MS Access, MS Excel, Agile, JIRA, MSVisio, MS PowerPoint.
Client: Charter communication’s Dec- 2018 – Dec-2019
Location: St. Louis, MO.
Role: Power BI Developer
Responsibilities:
• Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Physical Implementation of database into SQL Server 2005 using T-SQL.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.
• Created check constraints to maintain data integrity.
• Created views to restrict access to data in a table for security. Expert in extracting data using SSIS from OLTP to OLAP. Performed Bulk data migration using DTS and SSIS from flat files.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
• Performing analytics on Azure and developed Web and Mobile dashboard in Power BI for various field level equipment’s to provide business intelligence that helps them evaluate critical KPI’s.
• Data migration (import & export/BCP) from Text to SQL Server.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Coordinating post-implementation events such as testing.
• Created different mappings for loading the data into MySQL database.
Client: Bank Of America Aug 2016 – Nov 2017
Location: Plano, TX
Role: SQL Server Developer / Power BI
Responsibilities:
• Involved in analysis, development, implementation, testing and maintenance of Complete Software Development Life Cycle (SDLC) projects using Waterfall.
• Created multiple kind of Power BI Reports and Dashboards. Migrate Business Objects reports to Power BI.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Configured Tableau Server for granting licenses appropriately to the corresponding users; created and supported new projects and sites.
• Good in extraction, transformation and loading of data directly from different source systems like Teradata, Oracle and SQL Server.
• Experience in creating Tabular Reports, Matrix Reports, Parameterized Reports, and Sub Reports using SQL Server Reporting Services (SSRS).
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Experience in deploying solutions in Azure and AWS platforms
• Designed and deployed reports with Drill Down, Drill Through and dropdown menu option and parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Used ERWIN for reverse engineering and hosting according to the business requirements on existing models.
• Knowledge of and proven expertise with cloud implementations in AWS
• Developed modules based on the dimensions, levels and measures required for the analysis. Pivoting, drill down, Slice and Dice and filtering operations are done for all the OLAP applications.
• Involved in creating different reports based on the business request and ad hoc requirements using SSRS.
• Developed multi-tiered object-oriented system architectures utilizing Use case Diagrams, Activity Diagrams, Sequence Diagrams and Class Diagrams using UML modelling tools like MS Visio.
Reddy Labs. Bangalore, India
SQL Server Developer / Power BI Aug 2013– Sep 2015
Responsibilities:
• Worked in Agile methodology in order to discuss status of the project twice a week and take further measures which includes scrum meetings daily to discuss product backlog.
• Analyzed and designed software and database solutions.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Test and Production Environments.
• Designed various cube objects such as KPIs, drill through actions, aggregations, and translations. Implemented key performance indicators, actions, hierarchies, and attribute
relationships with added functionalities.
• Involved in performance tuning using indexing (Cluster Index, Non cluster index) tables.
• Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Migrated and recreated existing Dimensions and Cubes using Star schema on Server to achieve the efficiency of SQL Server Analysis (SSAS).
• Understand the business needs and convert into the Data Models using Erwin tools for Data modelling, Table design, DB Objects.
• Planning and gathering the requirements for setting up TFS environments for environment based migration and up gradation.
• Documenting the process followed for restoration based up gradation of TFS server.
• Setting up SQL server for TFS requirements.
• Imported data from multiple data sources in to Excel workbook, created relationships between heterogeneous data, created calculated columns and measures using VLOOKUP and formulas, built PivotTables and pivot charts using power pivot skills.
• Updated mapping tables related to assigned functional areas as directed by the Business Analysts. Worked with Excel Power Pivot Tables.
• Used recently introduced Power BI to create self - service BI capabilities and use tabular models.
• Responsible for building reports in Power BI from the Scratch.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Experience on publishing Power BI reports on dashboards in Power BI server.
• Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc.
• Worked with both live and import data in to Power BI for creating reports.
• Managed relationship between tables in Power BI using star schema.
• Created reports with Analysis Services Cube as the data source using SQL Server Reporting Services.
Environment: SQL, T-SQL, Power BI, DAX, SSRS, SQL, MS Access, MS Excel, Agile, JIRA, MSVisio, MS PowerPoint.
Contact this candidate