Suresh Santhanam Email & Phone Number

Herndon, Va, Us

United States

Herndon, Virginia

Herndon, Va

Design and develop ETL as a service for GSA’s tenants to use and implement on AWS cloud ATO environment.• Excellent skill and knowledge on implementing ETL on AWS cloud• Hands on experience in configuring ETL tools and setup meta-store configuration on cloud• Hands on experience working in ATO environment• As a AWS certified architect with hands on experience on setting up and configuring the development environment, I have gained knowledge on security groups, IAM roles , SSL enabled endpoints and AES-256 encryption.• Designed and developed an automated schema inference process that guarantees ingest of any file and enabled the same leveraging REST API calls using Penatho Carte• Designed and developed a delimiter identification tool using python; which can identify any kind of delimiter for a specified input file.• Designed and developed a generic ETL process that reads the metadata instructions from a JSON file and performs truncate and load, incremental and update loads• Designed and developed parameterized unload process that connects to different data sources and extracts data to S3 buckets• Developed python modules that uses libraries to interact with S3, Redshift, Mongo DB and RDS such as Postgres and MySQL• Configured and worked on Redshift pgbouncer—rr to facilitate multiple user access and managing load• Experience in performance tuning queries on Redshift• Experience on leveraging UDFs on Redshit• PoC on Evaluation of TalendDQ for data profiling• Technology: Pentaho Data Integration (Carte service), Unix, Python on AWS cloud, Redshift; Postgres, MongoDB and MySQL on RDS, TalendDQ- PoC

Baltimore, Maryland Area

Sr. ETL DeveloperDesigning and implementing Post-Acute Care (PAC) quality reporting program for Inpatient Rehabilitation Facility (IRF), Long-Term Care Hospital (LTCH) and Hospice.• Developed a load automation tool that performs: receipt & control, load, reconciliation and notification; thereby reducing the effort of 2 FTE resources. • Implemented a prototype to move the legacy data warehouse platform to AWS cloud thereby reducing cost by removing the server idle time and improving scaling and performance by 4 times during max loads.• Technology: AWS, Unix, Python and MySQLInnovation Lab – Lead Architect:• Independently prototyped a cloud based social media analytical framework, using provider data from yelp.• Independently prototyped and developed a generic and highly scalable data quality tool.• Technology: Spark, Unix, Python, Yelp API, Python Flask, D3.js on EC2 on AWS, MongoDB and MySQL• Trained 30+ people on Big Data concepts and Cloudera.

Columbia, Md

Designed and developed ETL streams to load Claims, Encounter, Plan, Provider and Beneficiary data into Integrated Data Repository (size: ~ 1 Petabyte), the centerpiece of CMS Enterprise Data Strategy for identifying fraud. • Designed and developed a generic, multi-threaded receipt and control process to receive over 1000 files across five applications daily and perform reconciliation with the data loads• Designed, prototyped and developed a generic, plug and play Data Quality tool which is now used by 10 applications• Designed, developed and implemented ETL flows that ingest data from different platforms involving more than 30 complex mappings, mapplets, worklets and workflows• Extensively used aggregator, joiner and router transformations• Created mappings to load tables with multiple load strategies like Type 1, Type 2, Snapshot, Insert else ignore, Truncate and reload• Extensively used Version Control and labeling procedures for continuous development and implementation in various sprints in an agile environment• Provided technical inputs to the Data Modeling team such as profiling of raw data to help design data models

Columbia, Md

Charlotte, North Carolina Area

Joined Infosys in the year 2003Client: Bank of America (Jan '09 to Jun '12)Technologies: IBM Mainframes and TeradataWorked on company number expansion and The Warehouse - Global Wealth Management and Commercial LoansTools: Multi-pattern search tool used for impact analysis Mainframes component extraction toolClient: Bank of New York Mellon (Feb '04 to Dec '08)Technologies: IBM Mainframes - JCL, COBOL, DB2, SYNCSORT, SuperCE, ENDEVOUR, Inquiry (CICS - APS), File Aid.Worked on remittance processing - LockboxTools Developed: ICETOOL: Used join logic to remove duplicates from PS - FB, VB files.SYNCSORT - To extract fields from a variable delimited file for analysis and reporting purposeRegression testing tool - Regression test for COBOL conversion. Client: Capital One (Nov '03 to Jan '04)Technologies: UNISYS Mainframes - WFL, COBOL, DMSIIWorked on Interbank Card Association number expansion project.Tools developed: Code Analysis Tool

Bachelor'S Degree, Computer Software Engineering, First Class

Computer Science