Shweta Padmanabhan +1-224-***-**** ac6zlm@r.postjobfree.com

EDUCATION:

The University of Texas at Dallas Aug 2015 - May 2017

Master of Science, Information Technology and Management

University of Mumbai, India Aug 2009 - Sept 2012

Master of Computer Applications

TECHNICAL SKILLS: Microsoft SQL Server, Oracle, MS Access, SSIS, SSRS, SSAS, Power BI, Tableau, ASP.NET, Azure

PROFESSIONAL EXPERIENCE:

Rightpoint Inc.: Business Intelligence Developer and Analyst, Chicago, IL May 2018 -Sep 2018

•Creating complex SSIS packages using proper control flow and data flow elements

•Developed SQL SSIS Packages to extract data from various data sources such as Excel, csv and flat files for doing raw data loads and building the staging area using various transformations

•Developed stored procedures in T-SQL for applying business rules and loading data into data warehouse

•Developed Reports and Visuals required for the client utilizing Power BI

AIM Specialty Health: Business Intelligence Developer and Analyst, Chicago, IL Oct 2017- Apr 2018

•Creating complex SSIS packages using proper control flow and data flow elements

•Developed SQL SSIS Packages to extract data from various data sources such as Excel and flat files using different transformations like derived column, sort, aggregate and various other transformations

•Developed packages for extracting, cleaning, transforming and loading data into data warehouse

•Developed Reports to be used by the Business users and Senior Management utilizing SSRS and Power BI

Ocwen Financial Corporation: Business Intelligence Developer and Analyst, Mumbai, India Sep 2013 - Jul 2015

•Retrieving data at various intervals from OLTP database to OLAP or staging database using the SSIS packages

•Created SSIS packages to populate data from various data sources

•Worked with data extraction using SSIS and Data Warehouse staging, and loading

•Worked very closely with Business Customers, End Users and resolved any business process related issues

•Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.

Freelance IT Consultant: Business Intelligence and Analyst, Mumbai, India Oct 2012 - Jul 2015

•Requirement gathering, analysis and testing to build business intelligence solutions for industry users

•Creating various dashboards using Tableau and Power BI as per requirements

•Interpreted business requirements and built packages for ETL and Data warehouse

•Building various canned and Adhoc reports using SSRS as per business needs from time to time

•Designed, Built the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).

J.P Morgan Chase: Business Intelligence Developer and Analyst, Mumbai, India Aug 2007 - Dec 2008

•Analyzing data with SSIS and SSRS for trends and performance analysis for credit cards

•Developed optimal stored procedures and queries to create data sets for reports

•Designed matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports

•Resolving credit card compliance issues with quick turn-around time for customers

•Working with business to gather requirements, document BRD and FRD, work with the development teams and manage end to end deliveries

IBM India Private Ltd.: Business Intelligence Developer and Analyst, Mumbai, India Dec 2005 - May 2007

•Interacted with business user to discuss and finalize the business requirement for analysis

•Extracted the business requirements from the stakeholders keeping in mind their need for the application and documentation of requirements

•Created SSIS packages as per business requirements retrieving data from various sources

•Created SSRS reports as per requirements for analysis and decision making for business users

Contact this candidate