Sumit Saha

Sumit Saha Email and Phone Number

Database Implementation Architect @ L3Harris Technologies
Texas, United States
Sumit Saha's Location
Dallas-Fort Worth Metroplex, United States, United States
Sumit Saha's Contact Details
About Sumit Saha

• Over 20+ years of IT experience in System Analysis, Design, Testing, and Development of business applications using Oracle and MS SQL Server.• 12+ years of hands on experience on DW technical development, data architecture, data integration, business intelligence and data analysis.• Strong Data Modeling experience using ER diagram, Dimensional, Star Schema, Snow-flake modeling using Erwin.• Extensive experience in Database Design, Normalization, Selective Denormalization, Forward/ Reverse Engineering of Applications, Conceptual , Logical and Physical data modeling using Erwin.• Highly experience in backend programming(in Oracle SQL, PL/SQL, MS SQL Server) including schema and table design, stored procedures, Packages, Functions, Triggers, Views, and Indexes etc.• Experienced in optimizing performance in relational and dimensional database environments by making proper use of Indexes & Partitioning techniques.• Highly expertise on optimizing & tuning SQL’s to improve the batch performance & response time of data processing• Extensive experience in Complex SQL Queries, Dynamic SQL, Analytical function, Oracle Object and Collection, Bulk Collect etc.• Designed & documented complex data integration flows, ETL source to target maps & complex transformations for development and metadata purposes• Expert in Data Migration, Add-hoc reporting, Data Analysis and validation.• Experience in design and development of end user Reports using SQL, Crystal Report, Business Objects, Tableau, Cognos.• Proficient expertise in using UNIX command and Shell Scripting.• Have good exposure on working in offshore/onsite model with ability to understand and create functional requirements.• Enthusiastic & project-oriented team player and the ability to develop different solutions for challenging client needs.• Experience in project management best practices, processes & methodologies including Waterfall Methodology and Agile Scrum Methodology of SDLC

Sumit Saha's Current Company Details
L3Harris Technologies

L3Harris Technologies

View
Database Implementation Architect
Texas, United States
Sumit Saha Work Experience Details
  • L3Harris Technologies
    Database Implementation Architect
    L3Harris Technologies
    Texas, United States
    View
  • L3Harris Technologies
    Database Implementation Architect
    L3Harris Technologies Jul 2019 - Present
    Melbourne, Florida, Us
    • Working with Capability Lead in translating their business needs through feasibility study, requirement gathering, prototyping and JAD sessions into conceptual, logical and physical systems designs, as well as working in a technical capacity to implement the design.• Lead the Database team and mentor other database team member to implement the best database solution.• Developing and supporting different efforts in the agile SDLC• Working, solo and as part of a group, toward creating new and/or modifying existing applications using PL/SQL • Inheriting architecture patterns and implementing them using best practice.• Increasing and maintaining the unit test code coverage to ensure higher confidence in delivered software.• Developing highly complex database processes using functions, procedures, packages, triggers, database partition, collections, in memory process etc.• Building metadata driven transportable tablespace process for moving data between two systems.• Using SQL Loader, External Table and Data Pump for data Load.• Writing Complex SQL script, Analytical Function, Data Analysis and validation.• Extensively working on optimizing various database process using performance tuning technique like in memory process, index, hint, parallel process, AWR report etc. • Building database process for high volume data loading• Writing various scripts using Unix for automate the process.• Using Git for software version control and Jira for issue tracking and activity log.• Provide post implementation ongoing production support.Technology Used: Oracle 19c, PL/SQL, UNIX Shell Script, Git Lab, Jira, Jenkin.
    View
  • Nestle Skin Health S.A.
    Senior Oracle Etl Developer
    Nestle Skin Health S.A. Jun 2015 - Jun 2019
    • Develops, manages, and update data models, including physical and logical models of the data warehouse, and data mart.• Design and develop the process architecture for the new projects and implement and maintain those process.• Provide ongoing support of enterprise data warehouse, continued development and enhancement of the data warehouse, automation of daily data extracts and external system feeds, and development and enhancement of current reports.• Design data interfaces to support data warehouse processes. Design and implement queries to extract specific data from relational data sources into data warehouse. Establish controls to ensure the accuracy and consistency of data.• Design and develop PL/SQL processes to perform complex ETL processes.• Conducts data requirements assessment and design sessions with customers.• Gather business requirements from subject matter experts (functional experts), Product owner within the organization and translate them into specifications design. Design, develop, and maintain the dimensional model based on business needs requirements.• Lead and mentor other developers. • Represents the DW team and collaborates with the customer and other agencies to conduct data risk assessments, document data mappings/lifecycle, and help build a data governance model, policies and programs.• Provides Level I and Level II functional support; including (but not limited to) on-call troubleshooting and problem resolution• Develop UNIX shell scripts automation and batch process and SFTP process.• Developing business reports for various departments within the organization using BI (Cognos, Tableau) reporting tools. • Managing Tableau administration task and help Tableau developer for their data related task.• Lead the change management and code migrations from Development to QA, QA to UAT and UAT to Production Environment.
  • Infogroup
    Senior Database Engineer
    Infogroup Feb 2015 - Jun 2015
    Dallas, Tx, Us
    • Design and develop scalable and reusable database processes. • Design, code, and test major features, as well as work jointly with other team members to provide complex software enhancements for databases.• Building Database Modeling and Data architecture for the new project.• Developed UNIX script for data auditing and automation and SFTP process.• Design and develop ETL processes to perform complex ETL processes using Talend open studio and Oracle.• Construct and design documents and documentation to aid in maintenance and code reuse in accordance with team processes and standards.• Developed strong working relationships with managers and analysts.• Participated in code reviews in accordance to standards.• Analyzed data needs and independently develop logical and physical data models.• Coordinate the implementation of database application components.• Understand and work with data in with varying degrees of complexity and scale.• Coordinate and participate in application testing and quality inspections.• Provide ongoing production support.• Followed the Agile methodology• Mentor and Assist other developers with design issues identified during development and testing
    View
  • Jpmorgan Chase
    Lead Database Developer
    Jpmorgan Chase Jul 2011 - Feb 2015
    New York, Ny, Us
    • Leads project teams in the implementation of the data management lifecycle components.• Leads the team on best practices when designing and managing data models in data modeling product.• Provided direction and reviews solutions with regard to data architecture, working with software development teams and enterprise and application architects to ensure consistency and coherence with the enterprise architecture.• Perform complex PL/SQL ETL programming and adhere to programming standards and processes. • Interact with Manager, PM, Architecture team, Business Analysts, Business user to identify objectives, design and develop detailed technical design, functional specification, process flow charts and Batch Process Scheduling Documentation etc. • Leading the team in design architecture, coding, unit and integration testing, debugging.• Mentor and Assist other developers with design issues identified during development and testing phases. • Assist Development Manager in creating overall architecture process and implementation. • Provide post implementation and on-going Level-II production support • Acquire new skills in various programming languages and development environments • Provide ongoing production support.• Develop ETL batch process using pl/sql, SSIS, other ETL tools. • Using Unix script for data loading and SFTP.• Working on PL/SQL and Sql Server, SSIS code and performance optimization, Query Hints • Working on the agile framework.• Building Relational and dimensional database modeling for the process design.
    View
  • Rent-A-Center
    Data Warehouse Lead
    Rent-A-Center Jun 2009 - Jul 2011
    Plano, Tx, Us
    • Lead and guide the DW team on best practices, database development, data analysis for source system data.• Translate data requirements into ETL requirements and develop and execute routines to move data into and out of the data warehouse from a variety of sources, including other databases, flat files, and Excel files.• Responsible for implementing and maintaining ETL process and integrating them into the data warehouse environment.• Coordinates and executes daily updates of data warehouse and independently resolves loading and extraction problems.• Contributes to the overall design and implementation of the data warehouse and assists in other data warehouse activities as needed. Participates in all data warehouse planning and execution.• Collaborate with data warehouse personnel, business intelligence developers, and data custodians to develop ETL requirements.• Data mart creation, Extracting data from different source, Transformation data in the Staging area and load data into the Fact table. • Writing Complex SQL script, Analytical Function, Data Analysis and validation.• Writing PL/SQL, packages, procedures, functions, Cursors and database triggers. • Support Data warehouse, ETL Process.• Worked with SSIS and SSAS.• Use SQL Loader and External Table for data Load.• Extensive SQL tuning, Data Analysis and validation, Unit testing.• Handling various type of data source like Lawson, High touch etc.• Creating Add-hoc Reports.
    View
  • Maxim Integrated Products
    Senior Oracle Pl/Sql Developer
    Maxim Integrated Products May 2008 - Jun 2009
    San Jose, Ca, Us
    Oracle Database Development for Business Financial Department of Semiconductor Industry• Understanding and documenting business rules, input/output requirement and data sources.• Designing/modifying design of database tables, keys, indexes, grants, triggers, packages, functions and procedures etc.• Creating database objects And Developing and modifying PL/SQL Packages, Functions and Procedures, Triggers, Ref Cursors. Views.• Extract data into Oracle table using SQL*LOADER and EXTERNAL Table.• Transforming the source data into the Target table.• Writing Complex SQL script, Analytical Function. • Data Analysis and validation.• Developed and support application in MS SQL Server.• Improved query performance by query optimization - tracing the query execution plan (explain plan).• Unit testing.• Implement Logical design to Physical design.
    View
  • Cvs Caremark Corporation
    Oracle Pl/Sql Etl Developer
    Cvs Caremark Corporation Jun 2007 - Apr 2008
    Woonsocket, Ri, Us
    • Designing, creating and developing Data Mart.• Creating Custom Packages, Stored Procedures, Function and SQL Scripts to load data into Pharmacy warehouse from different sources.• Writing new PL/SQL packages, modified existing code perform Certain Specialized functions / enhancement on oracle Application.• Create Complex SQL script, Dynamic SQL, Analytical function, Bulk Collect.• Data Load from Various source like Main Frame, Flat File, Excel file using SQL*LOADER and External Table.• Heavy SQL tuning for performance improvement.• Working with Business Objects Developer.• Write script for FTP and UNIX DBUL utility.• Create Ad-Hoc Report for Business support.• Load and monitoring the pharmacy data warehouse jobs scheduled in Control-M.• Design Data Conversion with the use of SQL*Loader.• Writing Unix Shell Scripts to load the data as per the Business functionalities.• Create SFTP process to load the feed data files from multiple outside server.• Scheduling the jobs using Control-M.• Enhancement of the legacy application in MS SQL server.• Code to requirement specifications and design.• Conduct unit testing and support system testing.• Provide information to project manager with any status update, issues/concerns as they.• Work with the Test Architect to insure all areas of the application have been tested.• Created Test cases & Test Scripts document.• Provide adequate documentation on unit testing.• Support the implementation of the project and address any post implementation defects.
    View
  • Rent-A-Center
    Oracle Pl/Sql Etl Developer
    Rent-A-Center Dec 2006 - May 2007
    Plano, Tx, Us
    • Data mart creation, Extracting data from different source, Transformation data in the Staging area and load data into the Fact table. • Writing Complex SQL script, Analytical Function. • Writing PL/SQL, packages, procedures, functions and database triggers. • Support Data warehouse, ETL Process.• Writing code for Fact and Dimension table population using SQL, PL/SQL.• Data Modeling using ERWIN.• Use SQL Loader and External Table for data Load.• Extensive SQL tuning.• Creating Add-hoc Reports.• Work with Business Object Developer.• Data Analysis and validation, Unit testing.• Implement Logical design to Physical design.• Production Support, Technical Documentation.• Develops, implements, and executes a quality assurance program and quality control standards for all ETL activities.• Works with database administrators to ensure available resources, both target and source systems.• Communicates statuses with data warehouse and business intelligence teams and assists in resolving data-related problems.
    View
  • Grameenphone Ltd
    Oracle Etl Developer
    Grameenphone Ltd Feb 2006 - Oct 2006
    Dhaka, Bd
    As an Oracle ETL developer, I was responsible for writing ETL script; Database development work, Report Development and support in Oracle Data Warehouse project. Responsibilities included: • Writing PL/SQL, packages, procedures, functions and database triggers. • Writing complex SQL script.• Working on Oracle Ware House Builder (OWB).• Data mapping in OWB and support OWB process.• Created new reports and modified existing reports for Oracle based custom application using Crystal Reports/ Oracle Discoverer.• Support Data warehouse, ETL Process.• Generate Add-hoc Reports.• Technical Documentation.• Production support.
    View
  • Leads Corporation Limited
    Software Developer
    Leads Corporation Limited Jun 2005 - Feb 2006
    Dhaka, Dhaka, Bd
    As an Database Developer was responsible for develop Banking Software, different Banking Reports and Systems Support.Responsibilities included: • Created new screens/modification of existing screen using Oracle Forms. • Creation/Modification of Banking Statement Reports using Crystal Report/Oracle Reports.• Write PL/SQL Packages, Procedures, Functions and database triggers• Wrote SQL scripts.• T-SQL using MS SQL Server.• Provided Support to the Bank.• Software Implementation.• Training to the End User. • Create Technical Documentation.
    View
  • Shivam Computers
    Software Developer
    Shivam Computers Nov 2003 - May 2005
    Custom Software Development for various client.
  • Niit Limited
    System Engineer
    Niit Limited Jan 2000 - Nov 2003
    Gurgaon, Haryana, In
    Development and maintain software and network.
    View

Sumit Saha Skills

Data Warehousing Oracle Etl Pl/sql Databases Data Modeling Sql Sdlc Database Design Business Intelligence Business Objects Informatica Unix Microsoft Sql Server Data Integration Requirements Analysis Db2 Crystal Reports Systems Analysis Enterprise Architecture Unix Shell Scripting Performance Tuning Master Data Management Ssis Solution Architecture Requirements Gathering Shell Scripting Erwin Teradata Toad Ssrs Olap Sql Tuning Dimensional Modeling Data Quality Oracle Hr Data Migration Data Warehouse Architecture T Sql Sql Server Reporting Services Database Administration Oracle Pl/sql Pl/sql Etl Development Datawarehouse Talend Open Studio

Sumit Saha Education Details

  • Texas A&M University-Corpus Christi
    Texas A&M University-Corpus Christi
    Master Of Business Administration - Mba
  • West Bengal University Of Technology, Kolkata
    West Bengal University Of Technology, Kolkata
    Software Engineering
  • National Institute Of Information Technology
    National Institute Of Information Technology
    Software Engineering

Frequently Asked Questions about Sumit Saha

What company does Sumit Saha work for?

Sumit Saha works for L3harris Technologies

What is Sumit Saha's role at the current company?

Sumit Saha's current role is Database Implementation Architect.

What is Sumit Saha's email address?

Sumit Saha's email address is su****@****ail.com

What schools did Sumit Saha attend?

Sumit Saha attended Texas A&m University-Corpus Christi, West Bengal University Of Technology, Kolkata, National Institute Of Information Technology.

What skills is Sumit Saha known for?

Sumit Saha has skills like Data Warehousing, Oracle, Etl, Pl/sql, Databases, Data Modeling, Sql, Sdlc, Database Design, Business Intelligence, Business Objects, Informatica.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.