Bharti Parekh
***********.*@*****.***
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