Jitaditya Saha

Project : Mc Donald's Corp

Directed transition from legacy systems to AWS Cloud for major restaurant chain serving 69 million customers.
Managed archival processes for AS400, Mainframe, and Oracle data for future analysis.
Engineered SQL solutions in Azure, responding swiftly to customer enhancement requests.
Revamped existing SQL code to boost efficiency in Master Data Management operations.

Key Responsibilities :

• Served as an AWS Solution Architect and Developer.
• Built IAM policies and created AWS SSO roles.
• Created Athena tables using AWS Glue-Crawler for legacy tables and resolved any test issues.
• Managed S3 bucket data, including backups and disaster recovery.
• Maintained EC2 servers, built security policies, and set up network connectivity with the source.
• Developed automation scripts using Lambda.
• Addressed customer ad-hoc requests.
• Built DMS instances and created DMS tasks to migrate Oracle data to S3.
• Analyzed and calculated AWS resource pricing for project scoping.
• Handled new intake requests in the MDM project, understood customer requirements, and implemented business logic in SQL Server stored procedures and SSIS scheduled as needed.
• Worked on enhancement and problem tickets, investigating issues and enhancing ETL code as required.
• Conducted data analysis and data profiling in MDM.
• Providing performance improvement of long running SQL queries
• Providing tactical and strategical solutions where required
• Provided cost estimations for new intake requests or enhancements to be implemented in stored procedures.
• Proposed innovative ideas to save time and cost for daily tasks and automated processes

Project : British Telecom

This telecommunication data warehouse is targeted to achieve the following for various subject areas like Call Centre Reporting, Assets, Orders, Marketing and Analytics. The ultimate objective of the project is to develop reports both scheduled (Canned) and Ad-hoc for

➢ Direct access of data to business users.

➢ Summarized business indicators for Client.

➢ Historical data analysis and reporting.

➢ As-of date reporting.

➢ Near Real Time reporting.

➢ Consistent and Reproducible reporting.

➢ Business metrics.

➢ Decision Support System.

Key Responsibilities:

• Over 7 years of experience in the IT industry, serving in various roles such as ORACLE PLSQL Developer, Team Lead, Data Designer, and Analyst, primarily in the Telecom domain.
• 6+ years in Data Warehousing and Business Intelligence Solutions, utilizing tools like PLSQL (Toad/SQL Developer/PLSQL Developer), OBIEE Reporting, QlikSense, Ab Initio, Informatica, and UNIX. Awarded the prestigious Best Team Award for successfully completing a production server migration ahead of schedule.
• Worked in data analytics, using QlikSense to prepare data for customers, transforming QVDs and reports for business use, following Agile methodology.
• Participated in a code migration project from ORACLE 10g to 12c, rewriting and redesigning Ab Initio and OWB maps into PLSQL, and scheduling them in Control-M for daily BAU.
• Developed new packages and scheduled them in Control-M via UNIX shell scripting for various stories, including BAU, Third Line Support, and E2E testing.
• Collaborated with business owners, system developers, and management, specializing in gathering system requirements, analysis, design, development, and creating and performing test scenarios/test cases.
• Conducted data analysis, understood user requirements, and resolved technical and functional issues.
• Involved in requirement gathering from the business and preparing design documents.
• Provided solutions based on business requirements, implemented them in PLSQL code, and presented them in reports.
• Performed performance tuning for long-running queries.
• Generated ad-hoc SQL queries using joins, database connections, and transformation rules to fetch data and present it via reporting tools or web portals.
• Defined load strategies for storing historical data.
• Addressed live production issues, providing tactical fixes and strategic solutions through stories.
• Built several generic frameworks as part of best practices.
• Led a developer team of 4.
• Worked on the EDW to GCP migration project