Home

Vara Balina - Sr.Microsoft Business Intelligence/Data Analyst/Power BI/ETL and Tableau Developer

[email protected]

Location: San Francisco, California, USA

Relocation: Yes

Visa: H1B

Vara Balina Sr.Microsoft Business Intelligence/Data Analyst/Power BI/ETL and Tableau Developer 7036899945 *142 [email protected] San Francisco, CA Yes H1B PROFESSIONAL SUMMARY Around 8+ years of Extensive experience in the Architecture, Design, Development, Implementation and Support of complex Data engineering solutions for building Enterprise Data warehouses, Data Marts and Business Intelligence needs. Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Architecture, Analysis, Design, Development, and Implementation. Experience in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop. Hands on experience in Logical and Physical Database design & development, ORDBMS Concepts, Normalizatand Data modeling using Erwin data model in relational databases such as SQL Server 2012/2014/2017/2019. Extensive experience in leading Business Intelligence/ ETL implementations using MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS) and Tableau. Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing in SQL Server. Expert in Design and optimization of OLTP, OLAP tools and OLAP Cubes. Led design, development, implementation of reports, and also development and management of the BI reporting environment. Involved in ongoing support, design, and development of airline-based data warehouse, data marts and online OLAP analytical applications. Have extensive experience in building BI Products and Solution frameworks through Meta Data driven approaches. Developed U-SQL scripts for processing massive amounts of data in a very familiar environment which is mainly used for AZURE DATA LAKE ANALYTICS. Hands on experience on writing T-SQL Procedures, Functions, Views and Indexes. Hands on experience in writing MDX queries to work with cube data. Defined the custom data reader to read the data from flat files (Character data sets, delimited files, fixed text length) into Data Profiler and Data Cleanser. Strong Expertise in importing the Legacy Data Structures into Relational Data Structures and data mapping in the Relational database. Experienced in Developing, Deploying, Scheduling and Monitoring SQL workflows/sessions for ETL Purposes. Strong experience in handling Master Data (MDM), strong focus on the customer data. Very good Project management experience encompassing very aspects required for building Data & Information systems such as - Requirements gathering & Analysis, Stakeholder Analysis, Feasibility study, Effort and Cost Estimations, Project Planning, Risk. Performance tuning of DTS/SSIS packages. Performance Tuning - Memory, CPU, I/O, Application, Hardware configuration (Different RAID levels) etc. Troubleshooting the long running queries and stored procedures to increase the performance by adding the index or by changing the query logic on need basis. Experienced in creating and scheduling of Markit EDM ETL tool. Created SSIS jobs, which run on daily, weekly and monthly basis to update fields in reporting files. Identified and made recommendations for the appropriated data sources for the best solution to extract the data for the project being worked on. Proficient in handling parameterized reports in SSRS. Experience in integrating the SSRS reports into web applications using Report viewer control. Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects. Experience with optimizing cube using partitions and aggregations. Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin. Experience in Excel pivot services and exposure to source safe, version controlling etc. Worked on SQL BI solution integration with Microsoft share point server. Experience on leading, mentoring teams and strictly adhering to SDLC/Agile processes. Played the role of Team Lead and On-Site coordinator and managed offshore associates. Experienced in creating build environment setup using TeamCity to deploy Web and batch applications. Proven organizational, time management and multi-tasking skills and ability to work independently while being a good team player who enjoys delivering high quality work. TECHNICAL SKILLS Operating System: MS Windows 7,8,10, MS Windows Server 2012, UNIX, Linux Languages: SQL, PL/SQL, T-SQL, C#, Visual Basic, C, C++ Database: Microsoft, Oracle, Teradata Application Servers: Microsoft SQL Server 2012/2014/2017/2019, Oracle 9G/10G/11G/12C/18C Tools: SQL Server Integration Sevice (SSIS), Markit EDM, SQL Server Reporting Service, (SSRS), SQL Server Analytic Service (SSAS), Toad, IBM Datastage, IBM Cognos, Tableau, PowerBI, Microstrategy, Crystal Reports Scheduling Tools: Windows Scheduler, MS SQL Agent Data Modeling Tools: Ms Visio, Erwin, Toad Data Modeler and SQL Developer Data Modeler. Project/Process Management: Bugzilla, Ms Visual Source Safe, Tortoise SVN, TFS, Clear Case, and Clear Quest Internet Tools: IIS, FTP, TCP/IP, SFTP, WinSCP Testing Tools: HP ALM, QTP, Win Runner, Test Director Portal: SharePoint Portal Server, Windows SharePoint Services PROFESSIONAL EXPERIENCE Data Analyst ( Power BI Developer ) Discover Financial,Riverwoods,IL September 2022 Till Date Description : Discover Financial Services (DFS) is a direct banking and payments services company. It provides credit card loans; private student loans; personal loans for debt consolidation, home remodeling, wedding and vacations, and other needs; home equity loans; and deposit solutions. Responsibilities : Utilizing SQL/SAS/other programming language to extract customer data from a data lake to determine what financial harm occurred. Documenting requirements to extract customer data (including assisting with developing technical programming code/logic in SQL, SAS or similar based on Discover Student Loans preferred programming methodology) to assist Discover Student Loans with generating customer restitution population files. Worked on SQL (including complex joins, grouping, aggregation, nested subqueries, and cursors). Documenting Discover Student Loans utilization of Discover-built calculation engines to apply calculations to the customer restitution population files. Taking part in meetings to develop and discuss consumer compliance issues, and the data needed to determine what needs to be returned to the customer. Assisting product teams with the development of customer data location requirements. Identify opportunities to improve efficiency with the extraction of the data and the processing of customer files for crediting accounts, sending checks, or sending letters. Understanding and providing feedback to the client on gaps in the storage of student lending data (at a customer and product level). Interfacing and possibly leading meetings with multiple stakeholders, including Product Owners, Legal, Compliance, Risk Management, Data leaders, Finance/Accounting leaders, Corporate Tax and the Credit Reporting team. Used various sources to pull data into Power BI such as SQL Server,Snowflake. Responsible to do the database changes using SQL server which includes creation tables, views, stored procedures, user defined functions, jobs, triggers etc also integrates of various data sources like SQL server, Snowflake, excel components using SSIS. Wrote calculated columns, Measures query s in Power BI desktop to show good data analysis techniques. Created reports using Power BI. Used various sources to pull data into Power BI such as SQL Server. Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations. Environment: Microsoft SQL Server 2017/2019, SQL Server Integration Services (SSIS), SSRS 2017/2019, Power BI, Visual Studio 2019. Data Analyst (Business Intelligence, Power BI Developer) Coborn s Inc, Minnesota, MN August 2021 August 2022 Description: Coborn s Inc., is a fast- growing employee-owned grocery retailer located in the Midwest. This grocery store formats include Coborn s, Cash Wise, Marketplace foods, Hornbacher s, and it offers unique online grocery home delivery services through our Coborn Delivers and Cash Wise Delivers locations. Coborn s Inc. also owns and operates liquor stores under the Coborn s Liquor, Cash Wise Liquor, Andy s liquor, and Captain Jack s brands. Additionally, this fuel and convenience division, pharmacy, in- house grocery warehouse and distribution center, in- house Central Bakery, and Tops Cleaners are significant assets to its operations. It also has a handful of other retail entities in the markets where the fit is right: Little Dukes, Holiday Station stores, Ace Hardware, Country Floral Gifts & Greenhouse, Caribou Coffee, Dunn Bros Coffee, Subway and Erbert and Gerbert s. Responsibilities: Worked on Creating SQL Queries to create Views, Stored Procedures and CTEs to create SSRS and Power BI Reports. Designed and Modelled Power BI Reports on Power BI Desktop. Created Database objects - Tables, Views, Functions, and developed Procedures for implementing application functionality at the database side for performance improvement. Designed SSIS packages by performing Extract, Transform and Load (ETL) to move data from staging database to data warehouse. Extracted data from various sources such as SQL Server, Oracle, Excel, CSV and Flat Files. Utilized Tasks and transformations such as Execute SQL task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, and Derived Column very frequently for creation of ETL Packages. Performed incremental loads while transferring data from OLTP to a data warehouse using different data flow and control flow tasks in SSIS. Developed packages in SSIS with event handlers, logging, checkpoints and breakpoints. Implemented data cleansing to remove unnecessary columns eliminate redundant, inconsistent data by using SSIS transformations and Implemented Time Intelligence using DAX to compare data over time. Created Configuration Files in SSIS to ease the process of deploying the packages in different environments. Used DAX to create calculations in tabular model to as per business definitions/ logic. Created tabular, list, matrix reports and writing queries to perform drill down operations in SSRS. Used various report items like tables, sub report and charts to develop the reports in SSRS and upload into Report Manager. Designed and developed Extraction, Transformation and Loading programs. Wrote both T-SQL, PL/SQL, and stored procedures. Analyzed data using SQL to identify trends and areas of improvement. Created daily SSIS and SQL Agent jobs to fix job failures. Improved existing processes and identified new processes to resolve issues efficiently. Environment: Microsoft SQL Server 2017/2019, SQL Server Integration Services (SSIS), SSRS 2017/2019, Tableau, DAX, ETL, Power BI, Oracle, Visual Studio 2019, HTML, CSS, Azure, Java, Python and MS Access, T-SQL and MySQL. Data Analyst (Business Intelligence, Power BI Developer) SDLC Partners - Highmark Health, PITTSBURGH, PA January 2020 July2021 Description: Highmark Health, along with its subsidiaries and affiliates, engages in health insurance plans, health care delivery, retail eyewear and eye care services, dental solutions, health risk solutions, and technology-based solutions businesses. It offers post-acute care management solutions for payors, providers, and patients; individual and group health insurance; Medicare advantage plans for seniors; stop loss and managed care reinsurance to benefits brokers, consultants, and third-party administrators on behalf of group policyholders, providers, and managed care entities; and dental care and oral wellness plans to consumers, businesses, and government entities. The company also provides prescription eyeglasses and contact lenses in stores and online; and eyewear services, including examination to consumers. Responsibilities: Involved in modifying the SSIS packages and optimising the package to fetch better performance and results. Responsible for modifying the SSIS package based on the new requirement of customer. Responsible for creating the package configuration and loggings for better handling. SSIS- re-write the package to reduce the redundant SSIS package doing same task. Reduced the manual effort by the run team daily. Prepared a complete flow of the application, suggested, and successfully implemented the changes Scheduling the application and other automation for sending reports and emails. Performance tuning of DTS/SSIS packages. Developed dashboards and ad-hoc reports using MS Power BI and SSRS for senior management team for analysis. Responsible for complete maintenance and delivery of scheduled releases. Performance Tuning - Memory, CPU, I/O, Application, Hardware configuration (Different RAID levels) etc. Troubleshooting the long running queries and stored procedures to increase the performance by adding the index or by changing the query logic on need basis. Analyzing the executing plan of SQL Server queries or stored procedures. Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc. Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks. Development and testing of new packages to ensure the data were extracted from database and presented for the project requirements and data validation. Created SSIS jobs, which run on daily, weekly and monthly basis to update fields in reporting files. Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects. Migrated existing Qlikview reports to POWER BI reports. Transformed and combined the data using Query Editor in the Power BI. Experience with optimizing cube using partitions and aggregations. Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin. Developed User Interactive Sheets & Reports as per business needs in SSRS. Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports, Cascading Parameterized reports, sub-reports and linked reports using SSRS 2017 and integrated into the front end. Integrated the SSRS reports into web applications using Report viewer control. Integrate Salesforce with SQL Server 2017 and create Salesforce Pages using Apex. Salesforce Administration and Declarative changes, Triggers. Environment: Microsoft SQL Server 2017, SQL Server Integration Services (SSIS), SSRS 2017, Power BI, Erwin, Tableau, Power Pivot, Oracle 18c, Microsoft Azure, SAP BW, Power BI, QuickView, Erwin, Salesforce and Ms Access. SQL BI/Power BI/Tableau Developer Sprouts Farmers Market., Phoenix, AZ July 2018 - December 2019 Description: Sprouts Farmers Market, Inc., is an American supermarket chain headquartered in Phoenix, Arizona, USA. The stores are full-service and emphasize organic foods including fresh produce, bulk foods, vitamins and supplements, packaged groceries, meat and seafood, deli, baked goods, dairy products, frozen foods, natural body care and household items. The chain was created to respond to consumers growing demand in health and wellness. Responsibilities: Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers. Proficient in usage of SSIS Control Flow items (For Loop, executes package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot). Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server. Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS). Hands on experience working with SSIS for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations. Worked with a set of stakeholders to identify the data required to operate an area of the business. Define what it means to have complete and accurate data. Served as the internal expert for data definitions, data quality, and data lineage for your business unit. Used SSIS Component Data Profiling task to generate other types of reports (such as a Column Null Ratio report or a Column Pattern report. Used Data Profiling task in SSIS to validate data. Written TSQL Scripts for doing Data Analysis like to check Quality of Data, Integration validation issues, good experience in utilizing all TSQL windows Analytics functions. Applied Data profiling techniques to derive Candidate Key Profile, Column Length Distribution Profile, Column Null Ratio Profile, Column Pattern Profile, Column Statistics Profile..Etc. Worked on On-Premises Gateway to refresh the data sources/creating a live connection with Tabular SSAS. Implemented Role Based Security as part of security in Power Bi. Used Power BI Power Pivot to develop data analysis prototype, for advanced visualize reports. Created designs and process flow on to how standardize Power BI Dashboards to meet the requirements of the business. Designed and developed Power BI dashboards, Reports and published it on Power BI sites. Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards. Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning. Expertise in writing complex DAX functions in Power BI and Power Pivot. Wrote calculated columns, Measures query's in power bi desktop to show good data analysis techniques Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure etc. Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS. Developed various operational Drill-through and Drill-down reports using SSRS. Modify the existing Claims Summary Report by removing two calculated measures from Claims Tabular Model. Create a new Audit Tracking column in claims Report by adding one new calculated measure from Claims Tabular Model. Mastered creating the OLAP cubes using various dimensions and creating SSAS projects. Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS). Developed various operational Drill-through and Drill-down reports using SSRS. Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users. Developed U-SQL scripts for processing massive amounts of data in a very familiar environment which is mainly used for AZURE DATA. Worked on creating Azure Data Factory for moving and transforming the data. Assisted with implementation/upgrade of AutoSys and JAWS, troubleshoot errors, and documentation/procedures. Environment: MS SQL Server 2014/2016, TSQL, Tableau 10 Desktop, Tableau server Pl/SQL, Power BI, ASP.Net, Informatica, Power Center 9.6/10.0, Visual Studio 2017, Oracle 11g, SharePoint 2007/2010, SSAS, SSRS, SSIS, Informatica, Erwin, Auto Sys Scheduler. SQLBI/Power BI Data Analyst Wells Fargo Banking - Charlotte, NC July 2016 to July 2018 Description: Wells Fargo & Company is an American multinational banking and financial services holding company with operations around the world. Wells Fargo is the fourth largest bank in the U.S. by assets and the largest bank by market capitalization. Worked on Electronic Deposit Center (EDC), web application used by internal employers. This application involves modules: validate electronic check, complete deposit, search functionality and generate reports for internal auditing purpose. Responsibilities: Subject Matter Expert (SME) for Power BI and worked on Microsoft Business Intelligence stack. Design the Data Model for the current solution to make it centralized for the other line of businesses. Created Power BI reports as Proof-of-concept (POC) for End users. Migrated Excel reports and Pyramid analytics reports to Power BI. Developed and maintained multiple Power BI dashboards/reports. Created Datasets using different data sources like Microsoft SQL Server, Microsoft Azure and Excel. Created Workspace and Apps in Power BI and giving access to end users to Apps. Configured Gateways in the Power BI service. Implemented Data security (Row level security) on Dataset and Reports in Power BI. Responsible for Scheduling jobs for weekly, daily data refresh on different Power BI reports. Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models. Designed a Power BI Data Model with multiple Fact Tables and Dimensions depending on the business requirements. Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS. Migrated existing Tableau Visualizations to Power BI using Power BI desktop. Developing and Maintaining of Data Dashboards, Reports and Data Visualization tools and Products using SSRS, Power BI, Tableau, Visio and Excel. Created Calculated Columns and Measures in Power BI depending on the requirement using DAX queries. Created complicated DAX measures in the Power BI reports as per the requirements of the Business Users. Generated Monthly, Yearly, Quarterly and Daily reports in Power BI. Worked on Power BI, Power Pivot and Power View to visualize reports. Understanding the existing data and create the required data models for the development. Created Databases, Data Mart Tables, Views, Stored Procedures, Triggers, Cluster/Non-Cluster Index, Unique/Check Constraints. Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production). Designed SSIS packages to transfer the data from flat files, Access database and excel documents to the Staging Area in SQL Server 2016. Developed VB.NET and C# application to load data from multiple excel files. Developed master ETL packages for loading and migrating historical data from Legacy system into D/W. Using SQL Server Integration Services (SSIS) as an ETL Tool, the data has Extracted, Transformed and Loaded (ETL) from Excel and Flat file to MS SQL Server. Developed SSIS packages using looping, data formatting, check points, error handling, email notification etc. Create and optimize complex T-SQL queries and stored procedures to encapsulate reporting logic. Developed complex reports with multiple datasets and sources in SSRS. Optimized SSRS reports with snapshots, caches, execution log views, embedded queries and stored procedures. Involved in Data scrubbing/Cleansing/validating/Translating, and scheduling SSIS packages. Environment: MS SQL Server 2012, Visual Studio 2012, SSIS, SSRS, Power BI, SAP HANA, JIRA, Power Pivot, Skype for Business, Tableau, Agile Scrum, Web Services, T-SQL, MS Excel SQL/Tableau Developer Tech Mahindra, Hyderabad, India March 2015 to June 2016 Tech Mahindra provides software development and systems integration services. The company develops custom applications, components, and frameworks on the Microsoft platform for IT departments, application services providers, and independent software vendors. Responsibilities Gathered and analyzed the requirements and prepared Use cases, User Interface document, Traceability SRS and Site map. Scheduled daily scheduled SSIS package for transformation and storing of data. Asp Dot Net creation of web pages based on roles and setting the privileges to the users across the module. SSIS Package creation, management and scheduling SSIS package. Responsible for creating the best practices to be followed in Logging and Configuring the SSIS package. Performance tuning of SSIS packages. Performance Tuning - Memory, CPU, I/O, Application, Hardware configuration (Different RAID levels) etc. Troubleshooting the long running queries and stored procedures to increase the performance by adding the index or by changing the query logic on need basis. Expertise in analyzing the executing plan of SQL Server queries and stored procedures. Experience in integrating the SSRS reports into web applications using Report viewer control. Experienced in creating build environment setup using TeamCity to deploy Web and batch applications. Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects. Experience with optimizing cube using partitions and aggregations. Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin. Environment: Microsoft SQL Server 2014, SQL Server Integration Services (SSIS), SQL Server Reporting Service (SSRS), SQL server Analytic Service and Tableau. EDUCATION: Master of Science in Information Technology. Wilmington University, DE Keywords: cprogramm cplusplus csharp business intelligence active directory information technology business works hewlett packard microsoft procedural language Arizona California Delaware Illinois Minnesota North Carolina Pennsylvania