ANSHUMI SHAH, PMP

Schaumburg, IL

***- ***-****

add4og@r.postjobfree.com

APPLICATIONS DEVELOPER

Broadly skilled professional blending a solid technical foundation with superior interpersonal and user skills with expertise in database design, performance tuning and migrating data. Possess a comprehensive understanding of best practices in enterprise level environments. Experience in creating data warehousing, inventory and order management systems in different environments. Knowledge of IT security relevant to data protection and data integrity.

Technical Expertise

SSIS SSRS Perl SQL Server SAS

BI/DW OLAP OLTP SSAS Unix shell scripting

Star Snowflake VB TSQL SSIS

Professional Experience

BI Team Developer, Veritas 05/2019 –Current

●Created Packages to extract information for Proof and print views using SSIS

●Imported data from SQL Server DB to Power BI to generate reports

●Deployed packages to different Environments from development to QA to Prod using TFS

●Generated computed tables in Power BI using DAX

SSIS Developer, Syntel 02/2018-05/2019

●Created Packages to extract financial and demographic data from multiple sources using SSIS

●Published reports and dashboards using Power BI

●Identified and communicated data inconsistencies. Took initiative to determine root cause, and made recommendations for resolution

●Deployed packages to different Environments from development to QA to Prod.

Senior BI Developer, Aetna, Downers Grove, IL 05/2013 – 01/2018

●Develop concise data marts that require advanced joins from multiple data sources in support of Aetna Medicaid and Commercial business using SSIS

●Thorough knowledge of the healthcare business application systems and table schemas

●Converting the SQL code from Oracle to Netezza using ETL

●Extracting healthcare and financial data from multiple sources and creating integrated analytic data sets

●Developed data transformations involving SQL, data-type conversions, joins, filters, translations, aggregation, de-/normalization, and custom database stored procedures

BI Developer, Enterprise Recovery System (contract), Oak Brook, IL 11/2012 - 03/2013

●Used SQL, SSRS and SSIS to create reports for Data Analysis and manipulation

●Led developers, advising other groups in organization on SSIS development, data warehousing developments and ETL development best practices

●Used SSRS to design a complex, on the fly, report that displayed financial and marketing information for the company

●Created system for capturing, reporting, and correcting error data

●Designed and developed SSIS packages, store procedures, configuration files, tables, views and functions using SQL programming,; implemented best practices to maintain optimal performance

●Built efficient SSIS packages for processing fact and dimension tables with complex transformations

BI Analyst, Sears Holdings Corporation (Contract), Hoffman Estates, IL 03/2011 - 08/2012

●Executed concise and actionable business reporting with actionable customer insights using SSRS

●Led team members and business partners to define requirements for analysis

●Gathered data, applied analysis methods and synthesized conclusions into recommendations

●Developed, maintained and enhanced reporting and analysis processes using T-SQL

●Served as a team leader for automation, scheduling reports and tuning queries to enhance performance and minimizing resource usage

ANSHUMI SHAH, PMP, Page Two

Report Analyst, Restaurant.com (Contract), Arlington Heights, IL 07/2010 - 03/2011

●Created and maintained reports using the SSRS including design, coding, testing and documentation

●Managed all reporting applications including report server security and maintaining user subscriptions

●Assisted users with ad-hoc and complex report creation and data interpretation using SSRS

●Created and maintained ETL processes to maintain our data warehouse environment

●Designed and developed SSIS packages, store procedures, configuration files, tables, views, and functions using SQL

Sr. Software Engineer, Accenture (contract), Fairfax, VA 03/2010 - 07/2010

●Created stored procedures, functions, packages, collections, triggers, object types to implement complex business functionality

●Data optimization, scrubbing and manipulation of staged data using PL/SQL packages

●Extensively worked on writing complex SQL queries (sub queries, correlated sub queries).

Senior Analyst, Sara Lee, Downers Grove, IL 02/2007 - 06/2008

●Implemented Stored procedures using PL-SQL and Unix Shell Scripts to update the data in Manugistics

●Designed source-target mappings based on subject areas to plan for ETL data integration initiative using SSIS

●Developed scripts and queries in ORACLE 9i and 10g to analyze and resolve ETL data transformation issues

●Partnered with business to develop new system reporting requirements for transformation from Manugistics to SAP

●Worked on project management tasks such as project work plan, project estimates, change request log and project status reports to enhance project visibility and ensured project delivery on schedule and budget

●Implemented Scheduled Receipts, Vehicle Loads, Customer Orders, Forecast, Recommended-shipments, Sku-on-hand interfaces from/to JDE, SAP and various other legacy systems

BI Systems Consultant, Quadratic Systems, Inc. Elk Grove 02/2004 - 06/2007

●Designed database architecture / dimensional models for J2EE/JAVA based mobile software solution

●Implemented OLAP based dimensional model using PL/SQL, Oracle and UNIX Shell Scripts for very large database

●Developed SSIS ETL transformations using control flows, data flow, data tasks, error handlers to conform various data marts for a centralized EDW schema

●Developed inventory management web application that allowed clients such as Wal-Mart to manage inventory without adding overhead and reduced processing time by 50%+

ADDITIONAL TECHNICAL HIGHLIGHTS

Languages: JAVA/JSP, SQL, MySQL, PERL, C++, XML, HTML, VB.net, VBA, SAS

Operating Systems: UNIX, MS Windows NT/2000/XP/Vista

Database/BI tools: Oracle, SQL Server, Toad, SSIS, SSRS, MS Access

EDUCATION

MBA in Finance and Operations Management, DePaul University, Chicago, IL

Bachelor of Science in Computer Engineering – University of Illinois at Chicago, IL

Contact this candidate