Sign in

Data Sql Server

San Antonio, Texas, United States
August 31, 2017

Contact this candidate


Zankhana Shah

***** ****** **** *****, ******, TX 78717

Phone: 860-***-**** email:


** ***** ** ***** ******** experience working in variety of domains including IT, Finance, Insurance, E-Commerce, Retail and Aerospace.

6+ years experience on Business Intelligence, Reporting, Analytics and Data Warehouse applications to transform data into high quality, actionable information through the intelligent use of reporting and analytics.

Proven track record of delivering complex projects and tasks in matrix organization with cutting-edge technologies while working closely with business partners, internal teams, sourcing partners and external vendors.

Highly analytical and detail oriented with excellent problem solving aptitude

Results-oriented, ambitious, motivated, self-starter.


6+ years of experience with Microsoft Business Intelligence Suit – SQL Server Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS),

4 years of experience with BI tools Tableau, Domo and Sisense.

Expertise in Self Service BI, Dashboards, KPI and Ad-hoc reports

Experience with Data Warehouse, Data Modeling, Facts, Dimensions, Cubes, Data Quality, ETL and Data Mining

MS SQL Server 2014/12/08, Oracle, PeopleSoft

3+ years of experience working with SharePoint environment, develop solutions, web sites and workflow development, maintenance and governance. Manage BI Reporting Portals in SharePoint

Advanced knowledge of MS Office Suite (Access, Excel, Word, Outlook, PowerPoint), familiarity with Visio


HomeAway, Austin, TX June 2017 – Present

Reporting Analyst and Data Analyst

Working with the sales operations team to help them build out a new comprehensive Hive data mart in partnership with the development team.

Taking complex data and turned into structured logic for reporting consumption for enhanced visualization experience in Tableau.

Technology: Tableau 10.3, SQL, Hive, Hue, Presto

RateGenius, Austin, TX Mar 2017 – May 2017

Business Development and Reporting Analyst

Primary responsibility is to lead and manage company’s Business Intelligence and Reporting platform that includes building executive and interactive dashboards with data visualization, trend analysis, metrics and forecasting.

Leading effort to gather analytics, develop algorithms and metrics to reduce cost per acquisition for partners, improve responses and return on investment for company’s largest revenue generating program DirectMail.

Migration of old legacy reports to Tableau

Create and streamline company’s data mart for better alignment with analytics.

Technology: Tableau 10.2, MySQL, Amazon AWS Redshift

Clarus Commerce, Rocky Hill, CT July 2015 – Jan 2017

Reporting Analyst

Clarus Commerce is one of the growing internet marketing and e-Commerce company with popular products like, Return Saver, Travel Plus and various loyalty programs.

Primary responsibility is to lead, manage and support company’s Business Intelligence and Reporting platform which includes ETL process to bring data to Data Warehouse from various data sources, building executive dashboards with data visualization, scheduled and ad-hoc complex reports for internal teams and external clients, support analytical tools.

Led technical implementations, working with Business, IT and vendors to develop and continuously improve the reporting infrastructure, including data warehousing, data modeling, report performance, report design and delivery tools.

Built complex strategic, analytical and operational dashboards and KPI reports with visual presentation of performance measures, various trend analysis, measure efficiencies for Executives, Sales, Marketing and Finance departments to help them make informed decisions.

Worked collaboratively with internal teams and external vendors to successfully implement new company wide SQL Server data warehouse platform, built and streamlined ETL processes to bring data from various data sources, migrated existing SSRS reports to Tableau, created many new Tableau reports for executives and internal departments.

Demonstrated a high level of adaptability to meet changing business requirements. Capable of working across team boundaries to deliver results on key department and business initiatives.

Built complex dashboards, KPI, monthly and daily transactional reports in Tableau and SSRS.

Technology: Tableau, Domo, SQL Server 2014, Microsoft SQL Server Reporting and Integration Services,

State of CT, Judicial Branch, Wethersfield, CT May 2015 – July 2015

BI Developer

Design and build OLAP cubes for Self-service reporting using SSAS and SSRS 2012.

Develop complex SQL stored procedures and queries to extract datasets from multiple databases, create appropriate dimension and fact tables and populate measures.

Participate in requirements collection, analysis, definition, and documentation activities; assisting in defining and prioritizing content to be included in the data mart and reports.

Pratt & Whitney, East Hartford, CT March 2014 – April 2015

SharePoint and BI Analyst

Primary responsibility is to collaborate closely with IT and Business teams, develop specifications, manage and execute on all phases of migration projects, and deliver data to the business in an accessible and actionable format using Microsoft Business Intelligence Suit (SSIS, SSRS, SSAS) and SharePoint.

Design and develop Extract, Load and Transform (ETL) components using SSIS, various control and data flow tasks using multiple data sources.

Develop dashboards, operational and ad-hoc reports using SSRS and integration with SharePoint for various reporting needs.

Develop multi-dimensional OLAP Cubes using SSAS to provide analytics and self service capabilities to various stake holders and client base.

Participate in data merging and cleansing projects to support new requirements, data conversions, and system consolidation and/or replacement.

Responsible for developing and maintaining data collection and integration processes to support business intelligence and data mining.

Consulting (Hilay LLC, Dynamite Consulting, Prutha LLC) Manchester, CT Aug ‘10 – October ‘13

BI and Reporting Analyst

As a consultant, implemented reporting and analytical solutions for a wide variety of small and medium clients

Work with business resources in various departments and clients to understand requirements, understand data needs, and resolve issues.

Develop flexible and easy to use report solutions for the business, and identify and create automated processes to replace manual workflows.

Utilize BI tools to build and support dashboards. Develop reports using SSRS

Develop SQL queries to extract complex datasets and metrics from multiple databases.

Construct ETL/data flows for the business to support both internal and external reporting environments.

Namco Pool, Manchester, CT Mar ‘07 – Mar ‘10

Financial Analyst

Work collaboratively with Accounting, Financial Planning and Reporting teams to provide technical, analytical and reporting solutions in support of building advanced BI platform for the company.

Work closely with IT and Business customers to understand their information needs, ensuring that BI solutions are excellent fit for their evolving needs.

Ensure the timely and accurate generation of regular and ad hoc reporting and analysis, ensuring consistency and standardization among various types of reports and reporting tools.

Perform ad-hoc analysis by writing SQL queries that will extract information from the data source.

Provide business leaders with a holistic view of key contributors to business performance and areas of opportunity.

Present data analysis findings in a clear and concise manner and offer recommendations based on key insights uncovered.

Design, develop, test and implement reports and dashboards using various business intelligence tools.

Create and maintain reporting documentation and user guides.

Kaman Industries, Windsor, CT June ‘06 – Feb ‘07

Accountant – G/L & Finance Reporting

Work closely with branch managers, controller and other accounting staff to ensure compliance with monthly close schedule and GAAP reporting requirements.

Daily, monthly and quarterly reconciliation of various accounts from USA and Canada. Responsible for the calculations of accruals and preparations and explanations for account reconciliations.

Processes Customer deposit in to the system accurately along with pricing analysis.

Provided support for the month-end close process of the revenue area, basic revenue reporting, and various special projects

Assist with maintenance of Fixed Asset System. Prepare and enter various journal entries for month end closing. Research questions and problems from various areas that relate to either monthly financial information or the Fixed Asset system.

Aetna Insurance, Hartford, CT Aug ‘05 – June ‘06

Payroll Systems Support

Responsible for supervision of processing payroll data. Ensured that computing, withholding, or deductions associated with net pay is done properly for employees and managers.

Accurately and timely process Short term and long term benefits transactions along with Payroll.

Communicate complex issues and coordinate activity with various internal clients to ensure appropriate processing.

Analyze, calculate and enter data in PeopleSoft software version 8.3.

Assumed responsibilities for planning, organizing and directing activities related to I-9 forms, payroll checks, under/over payments for short/long term disabilities as per Aetna’s benefit programs and in compliance with various State laws.

IBM, Southbury, CT Jan ‘05 – June ‘05


Performed operational accounting and analysis and profitability reporting.

Involved with daily routine activities to support financial transactions. Preparing and recording financial transactions on a timely and accurate basis, using GAAP, IBM Accounting Principles and Local Statutory/Tax requirements

Provided control and maintenance of assigned general ledger accounts, including account reconciliations and ledger entries.


Bachelor of Science in Accounting May 2005

Central Connecticut State University, New Britain, CT

Contact this candidate