Abhijit Dutta
C: 816-***-****
adzzvn@r.postjobfree.com
**** ******** ***** **, ********, TX 75072
Work Authorization: US Citizen
Accomplished data leader with 15+ years of experience of technical and consulting knowledge of legacy to next generation data systems. Responsible for driving over 25 innovative data products from ideation to deployment in varied domains such as retail, insurance and banking. Effective communicator with experience leading fresh graduates to executive presentations
●ETL (DataStage) / Similar to Informatica 10+ yrs
●SQL (Oracle,SQL Server, Netezza) 10+ yrs
●Project Management 4 yrs
●Python - 3 months of bootcamp
●AS400, RPG/400, RPGLE, CL, DFU, SEU, SQL/400,ACMS,ROBOT 10+ yrs
●Data Modelling - 5+ yrs
●Technical/Business Consulting 3 yrs
●Job scheduling (AutoSys) 10+ yrs
●Agile App Development 4+ yrs
●Data Virtualization 1 yr
●File Transmission using FTP, SFTP, CLI for S3 5+ yrs
●Production Support 10+yrsc
Relevant Professional Experience
Tata Consultancy Services Company - Client: Bank Of America 2020 to Present Software Engineer II - ETL(DataStage) Developer/Lead
Responsible for Master Data Management (MDM) replacement from Informatica to custom in-house solution for our current client
●Part of the development and testing team where the product was deployed into production within 1 year of inception.
●Module lead of another project related to enhancing the algorithm to track customers who can potentially do insider trading.
●Played key role (development, coordination with offshore, Implementation support) in multiple projects
Helzberg Diamonds 2015 to 2020
Lead Data Warehouse Analyst
Helzberg Diamonds is part of the Berkshire Hathaway group of companies focused on luxury retail with over 150 stores nationwide.
●Responsible for maintaining and enhancing Enterprise Data Warehouse (EDW).
●Responsible for requirement gathering.
●EDW was used for strategic business reporting, analytics for sales projections and product price forecasting, and business decision support for sales and marketing.
●Responsible for maintaining customer service data, specifically complaints, escalations, quality of product/service as well as complaint resolutions.
●Developed process on AS/400 using RPG/400, RPGLE, SQL/400, DB2/400, CL to customize JDA process
SELECTED PROJECTS
●Design, development and maintenance of ETL processes for data ingestion from various nationwide stores to EDW and ensuring pre/post ingestion quality checks.
●Integration of disparate data sources for inventory management at various retail locations by creating a data virtualization layer.
●Design, development and maintenance of Web Services using DataStage.
●Led data modernization of legacy data migration system to an innovative modern stack. Modernization effort required learning and implementation of new technologies and tools with minimal prior experience.
Federal Reserve Bank 2014 to 2015
Senior Software Engineer
The Federal Reserve Bank is responsible for regulating banks nationwide to ensure safety of the nation's financial system and protect consumers.
●Improved backend ETL processing and deployment times on mission critical data for the institution.
●Converted DataStage Jobs and maintained non-production environments.
Assurant Employee Benefits 2008 to 2014
Technical Lead/Developer
Insurance company providing dental and vision benefits for employees of small businesses.
●Responsible for design and development of EDW which was used for strategic business reporting and analytics for making business decisions, plan/ product sales, anticipated claim volumes and care provider contracting.
●Responsible for data consolidation and standardization of multiple data sources.
●Implemented MDM system for creating a single source of truth from disparate data sources.
Other Professional Experience
●Developed a security module of Insurance software using java, SWING, RMI and SQL Server
●Trained people on AS/400 COBOL and RPG programming.
●Led a team of programmers in India to customize an AS/400 based Insurance for a company in the United States.
●Part of a development team in Nederland, developed an AS/400 based Library Management software. My involvement in the project was for 3 years.
●Developed programs using different COBOL compilers for different application like Payroll, Bonus, Check Reconciliation, Draft Reconciliation, Financial Accounting, Sales Analysis etc.
Skills
ETL:
DataStage 8.5-11.7
Programming:
Java, Python, RPG, COBOL, Shell
Modeling:
ERWIN
Database:
SQL Server, Oracle
Job Scheduling:
AutoSys, SKYBOT, ROBOT
DB Appliance:
Netezza
Miscellaneous:
Corticon Rule Engine, Hyperion, Showcase Strategy, IBM MQ Series, MS Project
Education/Certifications
B.S. Accounting, University of Calcutta, India
Big Data with Hadoop
Web Development with Oracle