Bharti Parekh

adfzbp@r.postjobfree.com

469-***-****

Summary:

Around 12 years of experience in IT industry and gained expertise as ETL Developer, SQL/BI Developer, Automating Software Configuration Management (SCM), Deploying Applications through Continuous Integration (CI) and Continuous Deployment (CD) and Managing Cloud Services.

Experience with AWS Cloud Administration which includes services like EC2, S3, Elastic Beanstalk, SNS, Cloud Management, EMR, RDS, Dynamo DB, Ops Works, AWS Code Deploy, Cloud Front, SQS, Route53, VPC, Subnet, IAM, SWF, CloudWatch, Lambda, Elasticsearch, Elastic IP’s

Analyzed requirement and impact by participating in Joint Application Development sessions with business

Implementation of Continuous Integration using Jenkins and deployment using Pivotal Cloud Foundry

Experience in Automating, Configuring, Deploying AWS services and Managing Security groups

Worked closely with the Project Manager and Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to Target Mappings, Designed technical design documents for ETL process

In-depth understanding of principles of software configuration management (SCM), CI/CD in Agile, SCRUM, Waterfall Methodologies

Experience in Administration/Maintenance of Source Control Management Systems such as Git, GitHub, Bitbucket and Sub Version (SVN)

Created the schema, implemented all stored procedures and SSIS packages Created the deployment scripts and managed the code in Microsoft Team Foundation Server

Updated existing and created new reports using Microsoft SQL Server Reporting Services.

Coded and tested SQL queries based off the persistent table using Inline Views, Dynamic SQL, Merge statements. Built and monitored indexes to bring down processing times from minutes to seconds

Develop SSRS reports and configure SSRS subscriptions per specifications provided by internal and external clients and Power BI for executives and managers

Utilized T-SQL to pull data from various databases and created various dashboards, scorecards and reports to support loan business decision making. Generated ad-hoc reports, sub-reports, drill-down reports, drill-through reports, and parameterized reports to provide visible data for data analysts and business using SSRS and Power BI

Created scripts to analyze data, modify data, import / export scripts, and execute stored procedures. Created complex queries for use in Power BI and Tableau.

Developed custom calculated measures using DAX in power BI to satisfy business needs.

Updated and tested current OLAP data cubes including Servicing cube using SSAS and MDX

Experience on databases like MySQL, SQL server, PostgreSQL, Mongo DB, Cassandra, Big Query

Experience on the Scripting Languages like Python, Bash & PowerShell

Experience on Web Technologies like HTML, XML and Application life cycle Management (ALM)

experience supporting or designing complex ETL production environments

Experienced in supporting 24/7 production computing environments, on-call, and weekend support.

Technical Skills:

Operating Systems:

Red Hat Linux/CentOS 5.x/6.x/7, Sun Solaris 11/10, Ubuntu/Debian, Windows Server 2008/2012

Source Code Management Tools

Gitlab, GitHub, SVN, CVS, Bitbucket

Continuous Integration Tool

Jenkins, Gitlab CI

Build Tools

Maven, NPM

Containerization Tool

Docker

Languages/Scripting

Java, Shell, Python, PowerShell

Databases

MySQL, SQL Server, Mongo DB, Casandra, Snowflake, PostgreSQL

Reporting

SSIS, SSAS, SSRS, MDX, DAX, Power BI, Tableau

App/Web Servers

Apache, Tomcat, Nginx

Bug Tracking Tools

JIRA, Clear Quest, HPE AGM

Web Technologies

HTML, CSS, Java Script, XML, JSON

Cloud Platform

Amazon Web Services, Azure, GCP

Monitoring Tools

AWS CloudWatch

Education Qualification:

Bachelor’s in Computer Engineering from Gujarat University, India

Professional experience:

FedEx, Plano, TX Jan 2018 to June 2020

Role: ETL SQL Developer

Responsibilities:

Implemented BI Reporting Solution and supporting ETL process

Set-Up Development, test, and production Cubes for use with Performance Point and Share Point report distribution

Converted Crystal Reports to use power BI processes

Performed Branching, Merging, Tagging and Release Activities on Version Control Tool, GIT

Involved in designing, developing, and testing of the ETL strategy to populate the data from various source systems using SSIS

Created databases and schema objects including tables, indexes, stored procedures, and functions as a part of the data migration initiative

Built SSIS packages and scheduled jobs to migrate data from disparate sources into SQL server and vice versa

Used various SSIS tasks such as Condition Split, Derived Column, etc. to scrub, clean and validate data during staging before loading data into the data warehouse

Successfully developed front end web base dashboard with trending data, animated pipeline charts, and demographic charts with drill downs functions that displays a breakdown of Regional/States sales, utilizing data aggregation from SQL statements

Experience in writing Automation scripts using the python, HTML, CSS and JSON scripts

Built ad hoc reports such as an analysis grid with the capability to drill down at a hierarchical level and functions as print and download

Implemented DAX (Data Analysis Expressions) functions for SSAS tabular models and Excel pivot tables.

Creating DAX Expressions, create Date to yearly columns and implement partitions in Tabular Models for power BI.

Created Stored Procedures, user-defined functions, views for handling business logic and functionality such as Email Alerts, Data Extracts build-in Excel

Updated and tested current OLAP data cubes using SSAS and MDX

Created SSIS dynamic packages and designed and implemented a snowflake -schema Data Warehouse in SQL Server based on the existing data warehouse

Managed and developed existing and new ETL processes for SQL Server reports and Used SSIS to create ETL package to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases

Created SSIS/ETL packages for moving data from OLTP (Lab and Pharmacy) database to operational database (ODS) for reporting

Environment: AWS, AWS EC2, AWS S3, SVN, GIT, Bash, Shell, Python, POWER BI, SQL Server, SSIS, SSAS, MDX, DAX, HTML, CSS, JSON, Tableau

Old Republic International, Chicago, IL Jan 2016 to Jan 2018

Role: ETL SQL Developer

Responsibilities:

Developed ETL framework for processing and monitoring import of flat files in SSIS for key client

Maintained SQL scripts and complex queries for analysis and extraction, Developed Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, and Matrix reports using SSRS

Performed Branching, Merging, Tagging and Release Activities on Version Control Tool, GIT

Developed and created the new database objects including tables, views, index, stored procedures and functions and advanced queries, developed complex TSQL stored procedures and SSIS ETL processes utilizing XSLT and XML queries to consume and translate the vendor XML and Excel data files into the supporting database

Worked extensively on almost all the transformations such as Aggregator, joiner, Cached and Uncached Lookups, Connected and Unconnected Lookups, SQL, Java, XML, Transaction Control, Normalizer, and Sequence Generator

Provided production Level 1 and Level 2 on-call support for ETL processing, requiring time-critical resolutions to issues

Translate business needs to technical specifications

Design, build and deploy BI solutions using Power BI

Developing visual reports, dashboards and KPI scorecards using Power BI desktop.

Created scripts to automate in-house metadata explorer project using Shell Script and SQL

Created and loaded multiple Metadata resources from the data warehouse

Worked with various scripting languages like Shell and Python, Wrote Python scripts for pushing data from Mongo DB to SQL Database

Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.

Very good knowledge of DAX and MDX queries

Created SSRS inventory management reports

Created SSIS packages to export and import data from CSV files, Text files and Excel spreadsheet. Involved in installation, configuration and developing of SSIS packages

Store procedures, User defined functions, Views, TSQL scripting for complex business logic. Optimized the database by creating various clustered, non-clustered indexes and index views. Using aggregate strategies to aggregate data, sorting and joining tables

Responsible for creating and maintaining Analysis services objects such as cubes, dimensions, measures. Created report model on SSAS cubes as well as changing default configuration on existing cubes

Environment: SQL Server, TSQL, SSAS, SSIS, SSRS, Power BI, Tableau, SSMS, SSDT, GIT, MDX, DAX, Shell, python scripting, windows, Linux

Thomas Cook, London, UK Dec 2012 to Nov 2015

Role: ETL SQL Developer

Responsibilities:

Demonstrated ability to adapt to company's evolving environment by learning quickly & taking on expanded roles by implementing new procedures and improving existing ones

Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes, and views for the application

Performed Branching, Merging, Tagging and Release Activities on Version Control Tool, GIT

Scheduled and maintain packages by daily, weekly, and monthly using SQL Server Agent in SSMS

Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 R2 and Flat files

Responsible for optimizing SQL queries, stored procedures to improve the performance time

Conducted data migrations from third party databases to create consolidated database system

Performed data analysis on product datasets and led the modeling and development of the initial Enterprises data loading ETL/ELT solution in SQL 2008 R2

Created the weekly meeting BI SSRS reports on data acquisition and integrity progress for Director of Information Systems, Director of Digital Operations, and Vice President of Business Development

Implemented auditing using triggers and enforcing business rules via checks and constraints. Proper use of views to prevent unauthorized access to sensitive data

Connecting to data sources, importing data, and transforming data for Business Intelligence.

Excellent in analytical thinking for translating data into informative visuals and reports.

Able to implement row level security on data and application security layer models in Power BI.

Able to integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation

Created batch job processing, scheduling, and production support

Created a SQL script to create the tables, implement business rules, and populate the tables, developed queries and reports to illustrate features of the application

Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configurations, SQL Server automatic email notification and backup strategy

Extensive use of T-SQL programming and stored procedures to interactive with the database, and ASP to perform the calculation of the risk assessment modeling

Using ASP and SQL server programming to produce a final assessment report which are rich with dynamic graphics and charts

Environments: SSAS, SSIS, SSRS, SSMS, SSDT, Power BI, Tableau, MS SQL Server, Bash Scripting, Jira, GIT, SVN, Windows Server 2008

Reliance Communications, Ahmedabad, India

Mar 2008 to Oct 2012

Role: DB Developer

Responsibilities:

Designed, developed, and implemented highly optimized database systems for performance efficiency

Prepared design specs and functional documentations for database projects

Performed space management and capacity planning for database systems

Developed database tables and dictionaries, Ensure data quality and integrity in databases

Created complex functions, scripts, stored procedures, and triggers to support application development

Developed & Maintained database maintenance routes and procedures, scripts, function to increase performance

Successfully transferred inbound data from various sources like flat files, MS Access, and Excel into database

Implemented auditing using triggers and enforcing business rules via checks and constraints. Proper use of views to prevent unauthorized access to sensitive data

Troubleshoot database related issues in a timely fashion and developed security procedures to protect databases from unauthorized usage

Environment: Windows Server 2000, Solaris 10, Shell Scripting, MS SQL

Contact this candidate