Data Aws
Resume:
RESUME
SHUBHODIP SASMAL
LinkedIn Profile: www.linkedin.com/in/shubhodip-sasmal-b510063b
Senior Database, Data Warehouse and ETL Developer.
Atlanta, GA 30342
***************@*****.***
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