SUMMARY

• Over 4 years of experience as a business analyst in business analysis, consulting, and database management and leveraged technical, business skills to generate innovative solutions to address client issues
• Created impactful business rules and KPIs through classification, regression testing, demand forecasting, risk management and model validation/control
• Effective liaison between business and technical groups, creative and resourceful, problem solving with excellent decision - making capabilities
• Experienced in development and design of reports and dashboards for supporting the business analysis in a corporate wide reporting using OBIEE, Business Objects, Tableau, Sharepoint and Visio
• Extensive experience in Software Development full cycle (SDLC), Testing, Project Management, Client Engagement, Business logic development, BI/DWH/EDW
• Strong experience in the ETL (Extract, Transform and Load) of data into a DWH/DM and writing complex SQL/PL-SQL queries, OLTP, OLAP, Star, Snow Flake and multi-dimensional data modeling
• Proficient in data Normalization, data validations, data management/governance, data quality, metadata management, data mapping between different databases and managed multiple/concurrent engagements
• Skilled in SAS Programming, Macros, Preparing Data, PROCs, Producing Reports, Validating Reports, SAS Formats, Storing and Managing Data in SAS
• Experience in predictive modeling, and statistical algorithm development using historical data and testing thresholds to predict future performance, and probability of customer conversions.
• Excel expert with experience in organizing data, maintaining dictionaries and utilizing VLOOKUP, power pivot, pivot reporting, functions, charts, and dynamic modeling for data cleansing and validation.

TECHNICAL SKILLS

Database: ETL Datawarehouse - (IBM Datastage,ODI), Oracle 10g/11g, Data-mining, Oracle e-business Suite

Business Intelligence: OBIEE, Business Objects, Sharepoint, Tableau, Essbase- Dashboards

MS Office: Word, Excel, PowerPoint, Access, Visio and Outlook.

Scripting Languages: PL/SQL, Javascript-HTML

Statistical tools: SAS, R

PROFESSIONAL EXPERIENCE

Confidential, San Francisco

Data Analyst - Summer Intern

Responsibilities:

• Streamlined the financial reporting process in the IT-Sourcing department to better accommodate dual reporting and eliminated operational redundancies in the process
• Analyzed accounting journals to identify chargebacks among various business lines and created executive reports
• Evaluated existing processes to identify gaps and enabled a repository of analytical tools and models
• Developed Excel based tracking models to perform data cleansing, analyze the financial spend categories and automated the Excel models to generate compliance monthly/quarterly reports
• Built Financial budgeting models to compare and test the Automated Excel tracking models
• Designed, implemented & automated reporting tools to analyze data from various data sources and created monthly ad-hoc reports
• Developed spend dashboards in Tableau and Oracle Essbase, to enable better short & long range planning, and supplier contract management
• Created Dashboards with interactive views, trends and drill downs along with user level security to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis
• Enabled mature financial reporting analysis & planning through various analytic models, which analyzes the budgeting & actual spend for services and labor provided by the vendors
• Implemented dynamic models and defined standards to follow in quarterly financial reporting
• Evaluated annual budget spend of $150M by working with vendors and analyzed key cost drivers
• Identified cost savings of $1M annually and set benchmarks to realize the savings through contract negotiations
• Identified gaps in the hiring process and developed a social media strategy, to improve brand value and hiring efforts through social media

Confidential

IT - Data Consultant

Responsibilities:

• Led the restructuring of order management workspace to operate cross-functionally, as well as aid the users in dynamic reporting, eliminating the annual licensing fee of $500K
• Improved collaboration between teams by implementing new business process datawarehouse models and successfully integrated various business data models into one cohesive model
• Involved in creating database objects like tables, views, procedures, triggers, and functions using finely tuned SQL/PL-SQL queries to provide definition, structure and to maintain data efficiently
• Designed and implemented data warehouse architecture for the business datawarehouse. Subsequent data marts, extracts and reports were sourced from the architecture of conformed facts and dimensions
• Optimized business performance by implementing business algorithms to implement and evaluate efficiencies
• Enhanced operations by building business models, simulating operations, developed business intelligence systems and strategic plans
• Developed predcitive models which implemented customer conversion probability algorithms to identify patterns using historical, current data and improve the probaiblities of customer conversions
• Forecasted sales by successfully collaborating with planning, Inventory and manufacturing teams and defined standards for efficient planning and Inventory management
• Utilized Excel analytics to run regression and stastistical significant tests for the business variables and built predictive models based on the results
• Built Excel statistical analytical models to test and validate the predictive model results.
• Retained the top suppliers in six regions by analysing the trends and saved over $2 million a year
• Incorporated comparative and regressive automation solutions, defined benchmark standards and eliminated about 20 man-hours/week
• Designed and implemented automation solutions by utilizing Javascript,HTML and developed comparative solutions to analyze reports and report discrepancies.

Confidential

Data Analyst - IT

Responsibilities:

• Led the process optimization in the Customer Services division, by identifying the bottlenecks and trends in grievances division
• Implemented qualitative & quantitative solutions to solve complex business issues and effectively collaborated with management to initiate business process optimization
• Developed complex PL/SQL queries to load databases through data validation and transformation
• Fine tuned SQL Queries for maximum efficiency and performance
• Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments
• Led the revamp of grievances division and attained a 20% increase in resolution rate for the first day
• Developed and maintained an analytical database for use in dynamic reporting for the client
• Led the migration of business users to new data environment and helped migrate analytical reports
• Led the effort on multiple data remediation challenges rising due to large data migration and data mismatches between OLTP and new warehouse