ETL Developer at Milliman
Seattle, Washington
Sogeti
BI Developer
June 2013 to April 2016
Milliman
Pig Developer/Test Specialist
April 2016 to May 2017
Greater Seattle Area
Milliman
ETL Developer
Greater Seattle Area
Sogeti
Lead Business Analyst/Lead BI Developer
December 2015 to March 2016
Microsoft
BI Developer
September 2013 to December 2015
Western Governors University
Master of Science - MS, Data Analytics
2018 to 2019
University of Washington
Bachelor of Science (B.S.), Information Technology And Systems, 3.76 GPA
2010 to 2013
University of Washington
Minor in Mathematics, Mathematics, 3.76
2010 to 2013
Highline Community College
Associate's degree, Computer Science
2008 to 2010
What company does Ravi Bansal work for?
Ravi Bansal works for Sogeti
What is Ravi Bansal's role at Sogeti?
Ravi Bansal is BI Developer
What industry does Ravi Bansal work in?
Ravi Bansal works in the Computer Software industry.
Who are Ravi Bansal's colleagues?
Ravi Bansal's colleagues are Joseph Boschert, Robin Preijer, Bill Bade, Greg Herrle, Rick Wilde, Kelsie Stevenson, Rahul Mohan%2C ASA, Abigail Caldwell, Emily Stadheim, and Andrew Zeevi
📖 Summary
BI Developer @ Sogeti From June 2013 to April 2016 (2 years 11 months) Pig Developer/Test Specialist @ Milliman From April 2016 to May 2017 (1 year 2 months) Greater Seattle AreaETL Developer @ Milliman Working as an ETL Developer, building E2E solution using Apache pig, Hadoop, and Azure SQL. Also, building reports to show Financial data in charts, graphs and tables using PowerBI.. Greater Seattle AreaLead Business Analyst/Lead BI Developer @ Sogeti My role is to design and implement a fully automated dashboard using Power BI and MS SQL server to represent the total revenue, renewal projects, the growth, successfully completed deals, along with many other divided in Segment, sub-segment, area, region, district and individuals.Role & Responsibilities:• Gathered requirements, analyzed and wrote the design documents.• Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.• Performed data mapping from source to target.• Helped migrate from spreadsheets to OLAP business intelligence solutions.• Extensively used Power BI to represent data in charts, graphs, tables on a Dashboard.• Used MS SQL queries to pull the data from MS SQL Server to Power BI.• Research, evaluate and recommend improvements to existing reports and processes • Managed multiple reports at one time, and multiple end user requests. • Designed, build and deliver new reports, measures, and KPIs with TSQL and DAX.• Collaborated with requirements gathering team to develop an effective approach.• Take initiative to drive project architecture and processes.• Strong understanding of ETL principles such as dimensional modeling, meta-driven ETL, and table driven business rules.• Showcased excellent problem solving, analytical, communication and customer-facing skills. From December 2015 to March 2016 (4 months) BI Developer @ Microsoft Description: Microsoft Office 365 is a cloud-based service that is designed to help meet organization’s needs for robust security, reliability, and user productivity. Our role is to maintain and deliver Customer Usage and Analytics for Various Office 365 Services.Role & Responsibilities:• Written SQL joins, sub queries, performance tuning for better running of queries. • Created tables, views, users, logins, indexes (indices), using T-SQL and maintained databases. • Worked extensively on SSIS Packages for extracting the data of the customers from OLTP, transform that data and load it into the OLAP.• Migrating data from various sources into the SQL Server 2008 R2 using SSIS. • Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Log Providers etc. • Performed data mapping and transferred data from staging tables to database tables using SSIS transformations. • Involved in writing T-SQL stored procedures, functions for generating various customer review SSRS reports.• Maintained performance and analysis of the customers billing information in the form of reports using SSRS. • Developed ETL solutions pulling from Cloud Big Data sources. • Generated on-demand and scheduled reports for using SSRS. • Create PowerShell scripts to automate processes required to ensure data quality.• Provide support for 50+ SQL Server Instances containing sensitive usage information From September 2013 to December 2015 (2 years 4 months)
Introversion (I), Sensing (S), Thinking (T), Perceiving (P)
1 year(s), 8 month(s)
Unlikely
Likely
There's 100% chance that Ravi Bansal is seeking for new opportunities
Enjoy unlimited access and discover candidates outside of LinkedIn
Trusted by 400K users from
76% of Fortune 500 companies
The most accurate data ever
Hire Anyone, Anywhere
with ContactOut today
Making remote or global hires? We can help.
No credit card required
Ravi Bansal's Social Media Links
/company/m... /school/we...