MD Golam Sarowar's Email Addresses & Phone Numbers

Sr. Oracle PL/SQL Developer (team lead) @ Apple Apple Inc. is an American multinational technology company headquartered in Cupertino, California, one of the company's hardware products include the iPhone smartphone.Environment: Oracle Database 12c XE, Toad, GIT, Java J2EE, XML, Linux, SQL and PL/SQL, SQL * Loader, External Table, Oracle Reports Builder, Agile methodologies, Agile tool – JIRA.Responsibilities:•...

Sr. Oracle PL/SQL Developer (team lead) @ Apple Apple Inc. is an American multinational technology company headquartered in Cupertino, California, one of the company's hardware products include the iPhone smartphone.Environment: Oracle Database 12c XE, Toad, GIT, Java J2EE, XML, Linux, SQL and PL/SQL, SQL * Loader, External Table, Oracle Reports Builder, Agile methodologies, Agile tool – JIRA.Responsibilities:• As a team lead involved in the full development lifecycle (SDLC) and was responsible for collecting business requirements, system analysis, detailed technical design (Architecture), application development, data modeling, implementation and maintenance (production support) of Data Warehouses, Data mart and OLTP system..• Participating in all aspects of database programming on Oracle SQL, PL/SQL and related technologies that encapsulate SQL, including Cursors, Ref-cursors, Procedures, Functions, Packages, Oracle Supplied Packages, Collections, Table Partitions, Triggers, Materialized Views, external tables etc.• Building Data Warehouse for reporting and analysis purpose.• Writing (ETL Scripts) PL/SQL scripts, custom PL/SQL subprograms that extract data from different systems and populate into the Data Mart and data warehouse schemas.• Using Oracle 12c new features.• Using Bulk binds (FORALL, BULK COLLECT), Hints, Collections, bind variables and Dynamic SQL, and parallel processing to improve performance.• Performing code review for other developers, providing suggestions to improve performance.• Maintaining different versions of codes using GIT (version control software).• Performing Unit test, UAT, creating test plan for QA and preparing production implementation scripts, rollback scripts.• Crating XML data.• Involved in performance tuning of SQL queries and PL/SQL subprograms.• Writing Shell Scripts for job automation and ETL purpose using External Table interface. Cupertino, CASr. Oracle PL/SQL and ETL Developer @ XPO Logistics, Inc. Project Name: Supply Chain. XPO Logistics (NYSE: XPO) provides end-to-end management through a variety of supply chain services. XPO is the Europe’s largest provider of e-commerce fulfillment.Environment: Oracle Database 12c, Toad, GIT, Java J2EE, XML, Linux, SQL and PL/SQL, SQL * Loader, Oracle BI Publisher, Oracle Reports Builder, Agile methodologies (Scrum, Kanban), Agile tool – JIRA.Responsibilities:• Involved in all phases of system development lifecycle (SDLC) i.e. collecting user requirements, design (Architecture), development, testing, implementation and production support of the Supply Chain Management System.• Participating in all aspects of database programming on Oracle SQL, PL/SQL and related technologies that encapsulate SQL, including Cursors, Ref-cursors, Procedures, Functions, Packages, Oracle Supplied Packages, Collections, Table Partitions, Triggers, Materialized Views, external tables etc.• Building Data Warehouse.• Writing (ETL Scripts) PL/SQL scripts, custom PL/SQL subprograms that extract data from different systems and populate into the Data Mart and data warehouse schemas.• Performing analysis to find the error and fix it in Procedures, Functions, Packages, Triggers, Jobs and Unix Shell Scripts for Data Warehouses, Data mart and OLTP system.• Using Bulk binds (FORALL, BULK COLLECT), Hints, Collections, bind variables and Dynamic SQL, and parallel processing to improve performance.• Performing code review for other developers, providing suggestions to improve performance.• Maintaining different versions of codes using GIT (version control software).• Performing Unit test, UAT, creating test plan for QA and preparing production implementation scripts, rollback scripts.• Writing Shell Scripts for job automation and ETL purpose using External Table interface.• Using Oracle Reports Builder, BI publisher to create reports.• Involved in performance tuning of SQL queries and PL/SQL subprograms. From February 2018 to April 2019 (1 year 3 months) High Point, NCSr. Oracle PL/SQL and ETL Developer @ StubHub StubHub is an online ticket exchange owned by eBay, which provides services for buyers and sellers of tickets for sports, concerts, theater and other live entertainment events. It has grown from the largest secondary-market ticket marketplace in the United States into the world's largest ticket marketplaceEnvironment: Oracle Database 12c/11g, SQL Server, MongoDB, Toad, GIT, Java J2EE, UNIX, PL/SQL, SQL * Loader, Oracle BI Publisher, Oracle Reports, Tableau, Crystal Reports, Agile methodologies (Scrum, Kanban), Agile tool – JIRA, Hadoop, HDFS, Hive, Pig.• Involved in the design, development and testing of custom data (huge data set) migration scripts using Oracle PL/SQL and Shell script in an optimized manner.• Writing database objects like Tables, Views, Stored Procedures, Functions, Packages, Materialized views, DB triggers, Partitions, Indexes for Data Warehouses, Data mart and OLTP system..• Using data visualization tool/BI tool Tableau to create interactive Dashboards, Worksheets and ad-hoc reports.• Creating different type of reports using Crystal Reports.• Using advanced Bulk techniques (FOR ALL, BULK COLLECT), Hints, Collections, and Dynamic SQL to improve performance for Data Warehouses, Data mart and OLTP system.• Involved in performance tuning of SQL and PL/SQL code using DBMS_XPLAN, DBMS_PROFILER, SQL Trace utility and Explain plan.• Doing code reviews for other developers and providing suggestions to improve performance.• Performing Unit testing, UAT, creating test plan for QA and preparing production implementation scripts, backup and rollback scripts.• Creating XML report using Oracle PL/SQL code.• Writing Korn shell scripts.• Maintaining different versions of codes using GIT.• Doing ETL (extraction, transformation and loading) Using SQL * Loader, external files, external tables, shell script and Oracle PL/SQL.• Working in Agile environment (Scrum, Kanban) using JIRA.• Participating in the production support. From December 2016 to March 2017 (4 months) Boston, MASr. Oracle PL/SQL and ETL Developer @ IQNavigator + Beeline Environment: Oracle Database 12c/11g XE, Toad, SVN, Perforce, Java J2EE, Windows 7, UNIX, PL/SQL, SQL * Loader, BI Publisher, Oracle Reports, Crystal Reports, Informatica, Agile methodologies (Scrum, Kanban), Agile project management tool – JIRA.• Collected and documented user requirements and creating mapping documents to support the implementation of the extraction, transformation, loading (ETL) and validation of data moving from legacy systems into VMS and MSP system.• Developed complex mappings and SCD type-I, Type-II and Type III mappings in Informatica to load the data from various sources using different transformations.• Created complex mapplets for reusable purposes.• Involved in the design, development and testing of custom data migration scripts using Oracle PL/SQL in an optimized manner.• Wrote database objects like Tables, Views, Stored Procedures, Functions, Packages, Materialized views , DB triggers, Partitions, Indexes for Data Warehouses, Data mart and OLTP system..• Used advanced Bulk techniques (FOR ALL, BULK COLLECT), Hints, Collections, and Dynamic SQL to improve performance for Data Warehouses, Data mart and OLTP system..• Helped other developers in tuning queries or programs and trained them to write well-tuned code.• Provided expertise to development managers in design or preparing proof-of-concept testing.• Performed Unit testing, UAT, creating test plan for QA and preparing production implementation scripts, rollback scripts for Data Warehouses, Data mart and OLTP system..• Created XML report using Oracle PL/SQL code.• Used Oracle BI publisher to create report in pdf format.• Wrote Batch jobs, daily jobs, one time jobs and queues.• Involved in performance tuning of SQL and PL/SQL code using DBMS_XPLAN, DBMS_PROFILER, SQL Trace utility and Explain plan.• Wrote Korn shell scripts.• Used SQL * Loader to load data from external files.• Worked in Agile environment (Scrum, Kanban) using JIRA. From June 2012 to November 2016 (4 years 6 months) Centennial, Colorado, USASr. Oracle PL/SQL and ETL Developer @ TriZetto Healthcare Products Facets (Integrated Healthcare Solutions) : This is a complete healthcare solution comprises the module like : Group, Membership, Provider, Claims, Authorizations, Accumulators, HIPPA etc. Data is coming from various sources like Oracle, SQL Server, Sybase, DB2 etc which will be loaded into Facets. The entire ETL process consists of source systems, staging area, Facets, Data warehouse and Data mart.Environment: Oracle 10g, Oracle Reports 10g, SQL Server, Sybase, Informatica PowerCenter 8.6, Windows NT/2000, UNIX (AIX), Subversion, ElemenTool –Task management tool, PL/SQL, Transact-SQL, ERWIN.• Involved in gathering requirements and created design documents and mapping documents.• Involved in design and development complex ETL mappings and stored procedures in an optimized manner.• Migrated data from legacy systems (SQL Server, Sybase, Amisys, etc..) into Facets database (Oracle) and into Data warehouse.• Wrote PL/SQL code to integrate data from multiple source systems into Data Warehouse and Facets.• Wrote PL/SQL program units (stored procedures, functions, triggers, packages, batch jobs, etc.) for Data Warehouses, Data mart and OLTP system.• Performed SQL and PL/SQL tuning using Explain Plan, Execution plan, SQL Trace utility, DBMS_PROFILER.• Wrote Korn shell scripts.• Maintained different versions of codes using SVN.• Used SQL*Loader, BCP (bulk loader), Informatica Powercenter to load data.• Used DBMS_JOBS, DBMS_SCHEDULER to automate jobs.• Wrote Batch jobs, daily jobs, one time jobs and queues.• Used Oracle Reports for reporting. From August 2010 to June 2012 (1 year 11 months) Denver, Colorado, USASr. PL/SQL Developer @ Boy Scouts of America Environment : Oracle 10g, PL/SQL, Pro*C, Oracle Reports 10g, Crystal Reports, PL/SQL Developer, SQL * Loader, Version control software CVS, Korn Shell script, COGNOS 8.0 – Query Studio, Report studio, eclipse, performance tuning, data transfer using FTP, SFTP, NDM (Direct), Export, Import, JAVA, Windows NT, AIX.♦ Created high performance queries and PL/SQL codes using Bulk Binds, Collections, REF Cursors etc for OLTP and ETL.♦ Wrote high performance procedures, functions, triggers, packages, Korn shell scripts for ETL process.♦ Wrote Data Cleaning scripts.♦ Used SQL * Loader to upload data into the staging files from external files, using Export, Import, for data transfer from one domain to another domain using FTP, SFTP, NDM (Direct), JAVA interfacing class.♦ Helped other developers in tuning queries and trained them to write well-tuned code.♦ Performed code review, checking code standard of other junior developers.♦ Created and tuned various feeds/downloads, nightly jobs, and other daily/monthly reports/download.♦ Performed performance tuning using Explain Plan, Execution plan, SQL Trace utility, TKProf & DBMS_PROFILER.♦ Fine Tuning SQL’s and Pro*C code ♦ Maintained different versions of codes using CVS, Starteam, multiple task using JIRA.♦ Performed Development testing, Unit testing, UAT, creating test plan for QA and preparing production implementation scripts.♦ Performed analysis to find the error and fix it in Procedures, Functions, Packages, Triggers, Jobs and Korn Shell Scripts.♦ Created rollback scripts. From July 2008 to December 2008 (6 months) Irving, TXSr. PL/SQL Developer @ Electronic Transaction Consultants Project Name: Illinois State Highway Toll Authority (ISHTA)(Highway toll management system)Environment: Oracle 10g, PL/SQL, Korn Shell Script, Window NT, AIX, FTP, SFTP, NDM, PL/SQL Developer, Toad 8.5, SQL*Loader, Version Control Software CVS, ElemenTool for Production Support. Involved in the full development lifecycle, responsible for collecting business requirements, System Analysis, Functional Specifications, Detailed Technical Design, Application development, Data Modeling, Implementation, Preparing test plan and Maintenance using Oracle SQL & PL/SQL, Korn Shell Script.♦ Understanding the existing business processes and Interacting with Super User and End User to finalize their requirement.♦ Have extensive experience in developing efficient PL/SQL code for OLTP environment and ETL code for the Data Warehouse environment.♦ Used SQL * Loader to upload data into the staging files from flat files.♦ Created PL/SQL Packages, Procedures, Functions and Triggers.♦ Wrote high performance queries/programs using Collections, Bulk Binds, Objects, Nested tables, REF Cursors, pipeline functions etc. ♦ Created Batch jobs, daily jobs, one time jobs and queues.♦ Performed SQL performance tuning using Explain plan, Trace utility & TKProf.♦ Documenting all Oracle Reports, Packages, Procedures and Functions development specifications.♦ Maintaining different version of software (version control) using CVS.♦ Providing production support solving Tickets created using the software ElemenTool.♦ Preparing test plan for QA for testing before moving from PreProd to Production environment.♦ Preparing Production implementation plan & scripts. From May 2007 to May 2008 (1 year 1 month) Richardson, TXOracle Developer @ Citi Project Name : FastFinance (Mortgage & Financing for healthcare instruments)Environment: Oracle 10g, PL/SQL, Oracle Reports 10g, HTML, Korn Shell Script, Window NT, AIX, JAVA, FTP, SFTP, NDM (Direct), SQL Navigator 4.5, Version Control Software PVCS.Have been involved in Design, Development, Testing, Integration, Implementation and Maintenance of financial system using Oracle Database 10g, Oracle PL/SQL, JAVA, Korn shell script, Oracle Reports, Oracle Database 10g, Windows NT, AIX. Involved in backend development. • Wrote complicated stored Procedures, Functions, Database Triggers and Packages, Korn Shell Scripts.• Analyzed, created new and modified existing reports, scheduled reports, oracle jobs using AIX, Oracle 10g, Oracle Web Toolkit, Reports (10g/9i), PL/SQL, Stored Procedures, Functions, Packages, Korn Shell Scripting, FTP, SFTP, NDM (direct). • Did code reviews of other developers and provided suggestions to improve performance• Wrote high performance queries/programs using Bulk Binds, REF Cursors etc. • Helped other developers in tuning queries or programs and trained them to write well-tuned code.• Provided expertise to development managers in design or preparing proof-of-concept testing.• Converted Reports from 9i to 10g.• Designed and Developed FTP, SFTP and NDM (direct) processes using Java, PL/SQL and Korn Shell Script.• Created various feeds/downloads, nightly batch jobs and other daily/monthly reports/downloads.• Tuned batch jobs and other daily/monthly reports/downloads. From March 2006 to May 2007 (1 year 3 months) Dallas, TXSr. Oracle PL/SQL and ETL Developer @ Pristine Dental Supplies, Inc. • Involved in all phases of system development lifecycle (SDLC) i.e. collecting user requirements, design, development, testing, implementation and production support of the inventory management system.• Participating in all aspects of database programming on Oracle SQL, PL/SQL, Procedures, Functions, Packages, Oracle Supplied Packages, Collections, Ref-cursors, Table Partitions, Triggers, Materialized Views etc.• Performing analysis to find the error and fix it in Procedures, Functions, Packages, Triggers, Jobs and Unix Shell Scripts for Data Warehouses, Data mart and OLTP system.• Using Bulk binds, Hints, Collections, bind variables and Dynamic SQL, and parallel processing to improve performance.• Performing code review for other developers, providing suggestions to improve performance.• using GIT as version control.• Performing Unit test, UAT, creating test plan for QA and preparing production implementation scripts, rollback scripts.• Creating XML data using DBMS_XMLGEN package, parsing XML data using SQL function SYS_XMLGEN, XML_Query etc.• Using Oracle Reports, BI publisher for reporting.• Working in Agile environment using JIRA.• Involved in performance tuning of SQL queries and PL/SQL subprogram using DBMS_XPLAN.DISPLAY_CURSOR, DBMS_PROFILER, SQL Trace utility and Explain plan etc.• Writing Shell Scripts for data loading in to the target tables using External Table interface. From May 2017 to January 2018 (9 months) Santa Fe Springs, CA, USA