Engineer Data

CHITRANGADA WAGH

*****************@*****.*** • 309-***-**** • Jersey City, 07310.

SUMMARY OF QUALIFICATIONS

Demonstrated capacity to develop and maintain large databases. Experience with payroll terminologies and technologies. Communicate with business users, QA and other teams to deliver quality performance.

WORK EXPERIENCE

BI Engineer II, Namely at New York City, NY September 2015 – Present

(SQL Server 2014, Spark SQL, Databricks, Data Warehousing, Looker, Airflow, Python, Agile workflow, Git)

·Design and implement data models for Payroll and HCM data warehouse projects.

·Design and develop HR Time off Requests data pipelines in Databricks using delta tables, case classes in Spark SQL from application databases in PostgreSQL and Microsoft SQL Server.

·Create DAGS in Airflow to schedule and monitor workflow.

·Design, analysis and development of HR, Payroll and Benefit rules and reports using T-SQL.

·Extensive development in T-SQL such as writing and optimizing complex SQL queries, dynamic queries, joins, stored procedures, functions, views and triggers.

·Expertise in performance tuning and indexing to make query plan optimization more efficient, resolving database integrity issues, debugging both SQL code and data related issues.

·Optimizing legacy reports for faster execution.

·Design and create safety mechanisms to eliminate risk of accidental data breach from Namely reporting using T-SQL.

·Gather requirements from client and internal team members to create Looker dashboards for Namely analytics.

·Working as a part of Agile workflow to meet team goals.

·Collaborating with other developers using Git source control solutions.

·Help create learning culture in technology by mentoring team members across US, India and Nigeria.

·Managing weekly releases and production support.

Programmer Analyst, Tokio Marine HCC, Inc. at Houston, TX February 2013 - September 2015

(SSIS, SQL Server 2008, Hyperion, Microsoft Access, SQL Data Compare)

·Maintaining and troubleshooting SSIS packages to analyze data for risk management and month end close project.

·Developing tier-1 application database in SQL Server which generates audit reports.

·Developing and debugging Java code with Oracle connectivity and shell script to upload person/policy records to calculate billing and earnings.

·Experience working with different teams on SQL Server and MS Access to SQL Server migration.

Research Assistant Intern, Innovative Technologies Complex at Binghamton May 2012- January 2013

(OmniUpdate, CSS, HTML, MySQL, WordPress, Photoshop)

·Maintained and updated the University websites: www.binghamton.edu/harpur and www.research.binghamton.edu

·Designed and built an uploader for uploading all file types using SWF libraries in JavaScript.

EDUCATION

Binghamton University, State University of New York

Master of Science in Computer Science (Cumulative GPA:3.3/4.0) May 2013

Government College of Engineering, Aurangabad, India

Bachelor of Computer Science and Engineering (Cumulative GPA:3.6/4.0) May 2009

PROGRAMMING SKILLS

Programming Languages: T-SQL, Python, HTML, CSS, JavaScript, JDBC

Database Platforms: PostgreSQL, SQL Server 2014, MySQL 5.x, Oracle 10g

ACADEMIC PROJECTS

Student Registration System using SQL, Binghamton University March 2013 - May 2013

SQL Programmer

·Created application software in SQL to support student registration activities for Binghamton University.

Contact this candidate