SQL/ Power Bi Developer
Resume:
Shiv
***********@*****.***
Summary
8+ years of IT experience as Business Intelligence Developer, Power BI Developer, Tableau Developer, SQL Developer, User/DB Management, and Installation & Configuration on different server environments. Based on my work experience, I have developed strong abilities in data migrations, developing large SQL queries and business intelligence reporting on different tools like Tableau, Power BI, Web Focus. I worked in different domains which of huge data, and I am extremely analytical with excellent problem-solving skills. I possess a master's degree in Management Information Systems from Mississippi State University and bachelor’s degree from BITS PILANI Goa Campus.
Skills
Visualization Tools
Tableau, Power BI, Web Focus, Qlikview, SSRS
ETL Tools
Alteryx, Informatica & SSIS
Statistical Tools
R, MATLAB
Programming
Languages
C, PHP
Databases
Presto, SQL Server, Teradata, Oracle
Operating Systems
Windows, Linux, UNIX
Education
Master of Science in Management Information Systems
January 2015 – June 2016
Mississippi State University, Starkville, Mississippi
Bachelor of Engineering in Chemical Engineering
August 2008 – December 2012
BITS PILANI Goa Campus, Goa, India
Professional Summary:
Client: Toyota Material Handling, Columbus, IN January 2022 – Current
Business Intelligence/ Power BI Developer
Project Synopsis: Toyota Material Handling is an American Manufacturer and distributor of different equipment such as forklifts and tow tractors. My role is focused on developing data sources and dashboards so that it helps in operational decisions of the dealers and optimize the performance associated with process gaps.
Responsibilities:
●Develop scorecards and dashboards in Power BI, Tableau and create stored procedures from the source systems.
●Gather requirements to support ad-hoc analysis for senior management
●Integrate the data sources and standardize the process across different cross-functional teams.
●Designed and developed automated solutions in Power BI which are tailored to the requirements of the stakeholders
●Performed root cause analysis on various data sources by reverse engineering the data from the source systems like SAP and Salesforce
●Performed advanced analytics to identify the favorable and unfavorable scenarios for dealers to narrow down the targets
●Understanding the requirements for creating projections and models based on the historical data
Client: Facebook Inc, Menlo Park, CA March 2020 – January 2022
Data Analytics Engineer
Project Synopsis: Facebook is a leading social media platform and engaged in a diverse product portfolio. I am working as a Data Analytics Engineer where my role is to develop data pipelines in Dataswarm and develop visualizations in Tableau and Power BI to the executive management.
Responsibilities:
●Develop complex visualizations in Tableau and Power BI relating to security incidents that occur at all the Facebook facilities and data centers
●Performed complex data blending operations by merging the data sources to provide a single source of truth
●Automated various dashboards and designed dynamic parameter flexibility to generate custom reports within Power BI
●Experience in writing Dataswarm pipelines to gather data from different source systems and load the data into HIVE tables
●Merging the application systems and providing insights that can be leveraged using visualizations and data pipelines
●Worked with Tableau support on requests regarding the new functionality for the upcoming Tableau desktop releases
●Developed pipelines in dataswarm using several in-house libraries to transform and migrate data from different database environments
Client: Altice USA, Bethpage, NY July 2019 – February 2020
Business Intelligence Developer
Project Synopsis: Altice USA is a Telecommunications, Cable, and Internet service provider. At Altice, I worked as a Power BI, Tableau and Alteryx developer where the data from different cross functional teams is merged to generate business insights.
Responsibilities:
●Created complex workflows in Alteryx for pre-processing complex datasets before ingesting into Power BI
●Developed complex visualizations for tracking the key performance metrics for strategic business decisions
●Designed and developed complex workflows and dashboards for new product launches like Altice Mobile and Apple TV
●Responsible for handling huge data sets across multiple databases for data blending, data validations and reporting requirements
●Worked directly with the executive management on several reporting requirements and Alteryx workflow modifications
●Developed complex views that are tailored to the business users based on the business rules pertaining to the functional domain (Marketing, Accounting & Finance)
Client: Molina Healthcare, Long Beach, CA April 2019 – June 2019
Business Intelligence Developer/ Power BI Developer
Project Synopsis: Molina Healthcare provides health insurance to individuals through government programs such as Medicaid and Medicare. During my tenure at Molina, I worked in Star’s project where the aim is to increase the ratings of the several metrics associated with the plans and to close the gaps within the user groups.
Responsibilities:
●Involved in maintaining the server configurations and responsible for administration of the Power BI app in all the environments
●Responsible for updating the DML scripts based on the changes made to the existing tables
●Expertise in running SSIS packages to load the data from the configuration tables to the target tables
●Incorporated the design changes for the existing tableau dashboards based on the business enhancements
●Deployed the Power BI reports and maintained the user security and scheduling requirements as per business requirement
Client: Anthem Inc., Richmond, VA March 2018 – March 2019
Business Intelligence Developer
Project Synopsis: Anthem, Inc. is the one of the largest health benefits companies in terms of commercial membership in the United States with medical enrollment of 34.9 million members. Its mission is to improve the lives of the people it serves and the health of its communities. During my tenure, I worked in “Modular Product” and “ORMB Application” which automates the process of generating the quotes for healthcare plans.
Responsibilities:
●Involved in analysis of the requirements
●Replicated complex SQL queries from SSRS and developed the visualizations in Power BI and Business Objects (BO.)
●Created and replicated complex views from OLTP to OLAP systems which are part of BO universe
●Created dashboards to analyze the claims data based on user demographics.
●Successfully deployed 50+ Tableau and Power BI reports and was responsible for production support of Power BI reports
●Mapped the user’s enrollment data, claims data with legacy applications.
●Experienced in aggregating the complex data sets and creating extracts in Tableau to increase the performance
●Hands on experience in latest versions of Power BI and best practices involved on hyper extracts
●Solved data and ETL issues along with functional and technical analysis development
●Designed and validated Informatica ETL processes, for the source system in Claims and Enrollment Subject area
●As per business requirement, created, optimized, reviewed, and executed Teradata SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables
●Performed data extraction and validation, applying rules transformation in the flow of data from source to target
●Experienced in developing complex dashboards that are tailored to the needs of the executive management
Client: Kash Tech LLC, Lake Mary, FL
August 2017 – September2017
Business Intelligence Developer
Project Synopsis: KASH Tech is a Business Intelligence Solution and Service Provider and Specialized in delivering BI Solutions using different tools. I worked for an educational and cooperative services company which uses Power BI, Tableau and WebFocus to serve their clients with different dashboards to access their data online.
Responsibilities:
●Developed different types of reports, including drill-down, free-form, financial modeling language (FML), and tabular reports in Power BI
●Created various mappings in Informatica based on business requirements
●Developed Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 10.1 desktop/Server
●Replicated the custom SQL codes from different reporting tools and developed the visualizations in Tableau and Power BI
●Worked on performance tuning of the Tableau dashboards and monitoring the performance statistics
●Tested Power BI and Tableau dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data
Client: BNSF Railway, Ft Worth, TX November 2016 – May 2017
Tableau / Teradata Developer
Project Synopsis: BNSF Railway has multiple Data warehouse application that are dedicated for individual business verticals. The Teradata Warehouse is used by various teams to store important data including Claim details, account details, finance details etc. There are multiple projects that have been commissioned in different departments and the data is migrated from legacy Mainframe to web enabled database applications. So, as a Tableau developer my role in BNSF is to develop reports and visualizations based on the requirement of different stakeholders.
Responsibilities:
●Administered Tableau environment, sites which includes setting up security for different projects
●Troubleshoot user issues related to reports and schedules created users, sites, groups, projects, manage schedules for refreshing extracts on Tableau server
●Utilizing capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions and table calculations
●Developed queries in Teradata SQL Assistant to perform data validations between legacy mainframe and new application to ensure data consistency
●Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information
●Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions
●Worked on Informatica mapping to create flat files and load data warehouse tables using different types of source files
●Responsible for matching the data between the existing system and the new system
●Migrating and modified the existing procedures from Web Focus 7 to Web Focus8
Birla Group, Mumbai, India August 2013 – December2014
IT Analyst
Project Synopsis: As an IT analyst, I worked to streamline the processes to automate the billing system and supply chain logistics which reduced the costs and increased the overall efficiency. The scope of the project is to build a database to provide single source of truth for the end users.
Responsibilities:
●Interacted with the Business Users and Supervisors to gather business requirements
●Converted the User Requirements into Business Requirements Document, Functional and Technical Requirements Documents
●Created Business Process Models from the requirement specifications.
● Tracked and managed the requirements using Requirement Traceability Matrix (RTM) that controls numerous artifacts produced by the teams for project deliverables
●Involved in testing the SQL Scripts for report development which is leveraged in developing business strategies
●Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL
●Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS
●Created, maintained, modified, and optimized the views pertaining to the database tables to reflect the made on the base tables
●Designed, programmed, deployed, and tested the requested reports
●Designed ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects
Contact this candidate