RESUME

SHUBHODIP SASMAL

LinkedIn Profile: www.linkedin.com/in/shubhodip-sasmal-b510063b

Senior Database, Data Warehouse and ETL Developer.

**** ******* ****** ***

Atlanta, GA 30342

901-***-****

ades6k@r.postjobfree.com

SKILLS & ABILITIES

RDBMS/DBMS: AWS Redshift, Oracle Exadata, Oracle 11i/10G, Microsoft SQL Server 2005, IBM DB2

ETL Technologies: AWS Glue,Ab-Initio, SQL Server Integration Services(SSIS),Informatica

Big Data Technologies: MapReduce,Spark,Pig,Hive,HBase,Cassandra

Serverless Technologies: Redshift Spectrum, AWS Athena, AWS Glue

Cloud Technologies: AWS EC2, VPC, EBS, EMR, RedShift, RDS, EBS, CloudWatch, Cloud Trail, CloudFormation, AWS Config, Autoscalling, CloudFront, IAM, S3, Kinesis

Languages: SQL, PL/SQL, T-SQL, Python,Unix,Pyspark

Reporting Technologies: SSRS,Tablue

Data Security Tool: HP Voltage secure data

Operating Systems: Windows7, Vista, XP, 2000, 98, Windows 2003 Server

KEY ACHIVEMENTS

Build and maintain Exabyte’s of data ware house.

Performance tuning to expedite data loading and data reporting activities.

Securing PCI & PII data by implementing HP Voltage.

Developing new application and upgrading existing application throughout the year to support business requirement.

SUMMARY:

Data Engineer with over 12 years of experience in enterprise transformation and integration strategies and delivery.

Significant hands-on exposure in data modeling, data warehouseing,ETL, business intelligence and analytic application development using progressively evolving technology of Big Data, cloud based shared service.

Experience in Data Extraction, Transforming and loading (ETL) between Homogenous and Heterogeneous System using tools (AWS Glue,Ab-Initio, SSIS,Informatica).

Expertise in Performance Tuning in AWS Redshift and Oracle Exadata by query Optimization using various types of Data Distribution and Sorting techniques, Hints, Partitioning, Bulking techniques and Indexes.

Proficiency in PL/SQL,Partitioning,Triggers,Tables,Views,Indexing,Bulk Collect and performance tuning in Oracle.

Experience in Serverless technologies like Redshift Spectrum,AWS Glue,Athena

Experience in Data Modeling and Database Architecture based on functional requirements and system design of the client using RDBMS concepts and constructs.

Experience in Data modeling (Dimensional & Relational) like Star-Schema Modeling, Snowflake Modeling, ER-Modeling and fact and dimension tables.

EXPERIENCE

FISERV [FIRSTDATA] MERCHANT REPORTING, ATLANTA, DATA ENGINEER AUGUST 2011 TILL DATE

Build and maintain Exabyte’s size data warehouse for data delivery and reporting purpose.

Using ETL tool like Ab-initio, SSIS, Informatica to load and transform bulk amount of data in batch processing.

Creating/Modifying data using PLSQL in Oracle to support BI reporting.

Using SQL Server database to produce Tableau BI reports.

Performance tuning to expedite data loading and data delivery, reporting to satisfy end user expectation.

Always fine tune the data loading activities to meet the SLA of data availability.

Build raw data file output to deliver thousands of clients like Amazon, Walmart etc for their financial reconciliation using Oracle Exadata warehouse using PL/SQL advance features like Partitoning,Indexing,Bulk processing and UNIX shell scripting.

Work on big Hadoop tools like Hive,Impala,Pig,Sqoop etc.

Use Pyspark to use Spark framework to support batch processing of huge amount of data.

Migrate and maintain AWS Redhsift warehouse from in house big data warehouse.

Run jobs on AWS EMR cluster and work on AWS RDS databases.

Migrate traditional ETL jobs to AWS Glue

Creating objects in NoSql databse like Hbase,DynamoDB,MongoDB to support different app.

Develop design document and present to all the stake holders before actual development.

Work in JIRA to support each scrum related activity.

Using Jenkin pipeline for CI/CD deployment.

ELAVON VM Application, KOLKATA, INDIA, DECEMBER 2010 TILL AUGUST 2010

Build database objects to satisfy reporting and settlement process.

Build ETL jobs in Informatica for data loading.

Performance tuning for low latency reporting.

Gather the requirement and work in the design document preparation.

OSCB Retail Banking, ORISSA, INDIA, APRIL 2008 TILL DECEMBER 2010

Maintain and enhance database objects to support retail bank activities.

Change different module based on banking rule changes.

Performance tuning for end user smooth experience.

Gather the requirement and work in the design document preparation

EDUCATION

Bachelor of Engineering(IT) from West Bengal University of Technology

WORK EXPERIENCE

Cognizant Technology Solution – Dec 2010 to TILL DATE

CMC LTD – April 2008 to Dec 2010

Contact this candidate