Sujit Kumar Jha Email & Phone Number

South Brunswick Township, Nj, Us

Basking Ridge, Nj, Us

CCRS application calculates commission, incentive and compensation of all representative working directly or indirectly for Verizon. It drives behaviors that grow the business and enhance customers experience for both wireless and wireline system. This project supports 40K employees and 22K agents for device/plan upgrade, Contract Renewal, Activation, Deactivation, Reactivation. Key features include:● Daily commission calculation and online reporting allow reps to monitor month-to-date progress● Persistent customer tracking thru account, service and number changes● Maintain compensation rules for the ability to recalculate prior periods● Online discrepancy submission, resolution, and statement detailsRoles & Responsibilities:● Directly responsible for design, development, and maintenance of DADM, IADM and IMPADM instances and debug the RCA and provide the technical resolution● Write clean, maintainable, and efficient code to develop robust SQL statements● Develop and maintain documentation for database schemas, procedures, and best practices● Working knowledge of software development in each sprint using Agile delivery methodology● Expert in SQL Tuning techniques to prevent performance degradation by query optimization● Coordinate between development team and testing teams to ensure quality gates and right method followed in daily standup scrum call● Fix the issue related to daily cyclic job, nightly batch job and monthly batch job failure● Using ESP Workload Automation Workstation for job failure RCA/ICA and provide fixes● Using Git for database code version control● Proven work experience as a Database Expert● Extensive hands-on with Oracle/DB2 PL/SQL, including performance tuning, dynamic SQL, and advanced query development● Understand the data and reverse engineer by looking into code to write detailed functionality● Enforce regulatory rule, development standard and guidelines for the application

Tokyo, Jp

● Extensive experience in identifying, analyzing, designing, developing, monitoring by automating the process using Denodo Platform version 8.0 powered by Data Virtualization in AWS● Used Elastic Container Service (ECS) container orchestration solutions in AWS ecosystems● Market data analysis of S&P and Moody’s guarantor and reference table to build the SQL queries● Perform the collection, aggregation, analysis and visualization of customer, product, and transaction data using Oracle PL/SQL Development and Unix Shell Scripting● Directly responsible for design, development, and maintenance of MBR instances and debug the RCA and provide the functional or technical resolution● Develop robust SQL statements and optimize them for maximum performance by analyzing the execution plan and changing them as needed for performance tuning● Develop Oracle’s new DB objects like stored procedures, functions, packages, indexes, views, sequence, triggers, cursors, partition table and modify existing SQL or objects● Understand end-to-end Data flow and data integration/enrichment rules● Enforce regulatory rule, development standard and guidelines for the application● Challenges the BA on defined BRD and writing trampled functional/technical requirement● Collaborate with the business stakeholder and infrastructure teams to understand requirements and help design solutions with tools and methodologies to test for gaps, mitigate risk and address regulatory compliance● Understand the data and reverse engineer with business stakeholder for redesigning application● Ownership on the effect of making application/server/db level config changes to the environment● Proficiently using query optimization and troubleshooting using Oracle PL/SQL Development● Assist DBA team members with performance tuning and redesign efforts using Oracle PL/SQL

● Architecting the old legacy application to new Web application● Used Toad Data Modeler to create logical, physical and universal Entity Relationship Diagrams (ERD) - models for Oracle and DB2 Databases● Existing databases reverse engineered into Toad Data Modeler models and displayed as Entity Relationship Diagrams (ERD)● Participate in all phases of the SDLC including design, development, testing, deployment and maintenance using Shell scripting and PL/SQL● Migrating legacy data from old Power Builder system to new Settlement Web Application● Responsible for establishing data modeling best practices for advanced analytics, multivariate analyses, business intelligence, data management, and forecast analytics● Develop robust SQL statements and optimize them for maximum performance by analyzing the execution plan and changing them as needed● Develop new DB objects like stored procedures, functions, packages, indexes, views, sequence, triggers, cursors and modify existing SQL or objects● Performance tuning of the procedure and rewriting as per ANSI standard using Oracle 19c

Charlotte, Nc, Us

· Participate in all phases of the Software Development Process including design, development, testing, deployment and maintenance using Shell scripting and PL/SQL in Agile environment· Database design, development and architect in Oracle 19c Exadata DBaaS cloud · Hands on CI/CD using Ansible integration and Deployment in AWS env · Host code, build, test, and deploy applications to AWS· Actively participate in daily scrum call and track an effort using Horizon platform linked with Jira· Develop new DB objects like stored procedures, functions, packages, indexes, views, sequence, triggers, cursors and modify existing SQL or objects using Oracle 19c· Develop robust SQL statements and optimize them for maximum performance by analyzing the execution plan and changing them as needed· Design and develop conceptual, logical and physical data models· Migrating legacy data from old legacy system (ESS) to new GUES DB· Hands-on with coding complex packages, stored procedures and functions covering significant business logic· Develop robust SQL statements and optimize for maximum performance by analyzing the execution plan and changing them as needed in production· Develop new DB objects like stored procedures, functions, packages, indexes, views, sequence, triggers, cursors and modify existing SQL or objects using Oracle 19c· Able to work in a fast paced Agile environment and have daily scrum call· Proficiently using query optimization and troubleshooting· Understand the End-to-end Architecture of existing Business and each application and data flow across systems· Have designed upgrade/modifications of existing schemas as per business requirements and applied the appropriate constraint to maintain the data integrity· Relational data modeling of structured/un-structured data using MDM/DRM· Responsible for establishing data modeling best practices for advanced analytics, multivariate analyses, business intelligence, data management, and forecast analytics

New York, Us

Project: JDA EP, Logility, AllocationPosition: Lead Database Engineer / Production Support Ralph Lauren Corporation is engaged in the design, marketing and distribution of lifestyle products, including apparel, accessories, home furnishings and other licensed product. The Company operates in three segments: Wholesale, Retail and Licensing. Wholesale business consists of sales made to department stores and specialty stores around the world. Retail business consists of sales made directly to consumers through retail channel, which includes Company’s retail stores, concession-based shop-within-shops and e-commerce operations around the world. Licensing business consists of royalty-based arrangements.JDA Enterprise Planning is a multi-dimensional financial planning application for retail business which leverages high data volume, consumer demand to create sales, on hand, on order, receipt and inventory goals that maximize profitability, optimize inventory and minimize financial risk across every channel and key product area. To do planning activity, RL require access to a comprehensive set of structure and fact data for which it’s using JDA Enterprise Planning (EP).Roles & Responsibilities:Develop robust SQL statements and optimize them for maximum performance by analyzing the execution plan and changing them as neededDevelop new DB objects like stored procedures, functions, packages, indexes, views, sequence, triggers, cursors and modify existing SQL or objectsUnderstand end-to-end Data flow and data integration rulesMaintaining the integrity rule of Business processes by changing the database objectsChallenges the BA on defined BRD and writing trampled functional/technical requirementUnderstand the data and reverse engineer with business stakeholderAbstracts the complexity of a system into a manageable model that describes the essence of a system by exposing important details and significant constraints

Bed Bath & Beyond Inc. is an American-owned chain of domestic merchandise retail stores in the US. The stores sell goods primarily for the bedroom and bathroom, as well as kitchen and dining room. Roles & Responsibilities:Participate in all phases of the Software Development Process including design, development, testing, deployment and maintenance Develop new DB2 objects like stored procedures, functions, views, sequence, triggers, cursors and modify existing SQL or objectsDevelop DB2 objects and SQL statements which will be used by client's Planning Systems applicationsDesign and develop conceptual, logical and physical data models for Manual Order and eCom replenishment for both Oracle and DB2 DatabaseUsed Toad Data Modeler to create logical, physical and universal Entity Relationship Diagrams (ERD) - models for Oracle and DB2 DatabasesExisting databases reverse engineered into Toad Data Modeler models and displayed as Entity Relationship Diagrams (ERD)Understand the data and reverse engineer with business stakeholderResponsible for establishing data modeling best practices for advanced analytics, multivariate analyses, business intelligence, data management, and forecast analyticsCreate database tables, indexes, views, triggers and other objects in development environmentDevelop robust SQL statements and optimize them for maximum performance by analyzing the execution plan and changing them as neededWork closely with .NET developers to ensure a smooth integration of front-end and back-end parts of applications and setup test data in an agile project management frameworkCoordinate between development team and testing teams to ensure quality gates and right method followed in daily standup scrum call

Harte Hanks help NW with supporting their Nationwide Affinity Solutions (“NAS”) entire process. The NAS process includes populating and creating the Affinity Insights Marketing Engine and matching Affinity Member records to Policy records. This database includes the Affinity Member Repository which holds all the affinity member data, quote, policy data, and campaign selection and history data. Harte Hanks has implemented a database solution called Affinity Insight Marketing Engine (AIME) for Nationwide. AIME allows for new campaign setup, tracking of key marketing activities, as well as to enable comprehensive reporting and analysis.

Bank of America Merrill Lynch Central Data Base (CDB) G/L (General Ledger) migration project; the initiative to implement single software across all financial systems. This project is intended to migrate entire Merrill Lynch code from their legacy system to existing e-ledger Central DB. This initiative is due to acquisition of Merrill lynch by Bank Of America. Central Database currently uses the historical Merrill Lynch six digit expense codes. The Bank moved to a new 15 digit expense code structure in January 2015. Central Database needs to be updated to include the new expense codes, company code and related code description fields so that Finance chargeback processes are not impacted. In addition to the expense code updates, several financial hierarchy data fields that correspond to the expense codes need to be updated to the database to support cost analysis/research requests. Obsolete data fields need to be removed. It was a migration project with BoA.

Armonk, New York, Ny, Us

1. Client: AT & T, Middletown, NJ @OnsiteProject: BNCS –IT (LPP)Jun’13 - Jul’15AT&T is an American multinational telecommunication corporation headquartered in Whitacre Tower, downtown Dallas, Texas. AT&T is the largest provider both of mobile telephony and of fixed telephony in the United States, and also provides broadband subscription television services. AT&T is the third-largest company in Texas (the largest non-oil company, behind only ExxonMobil and ConocoPhillips, and also the largest Dallas Company).2. Client: Bank Of America, NC @OffshoreProject: FSR (Financial Systems Roadmap) Jun’11 – May’13Bank of America Financial Systems Roadmap (FSR) Project, the initiative to implement single software across all financial systems, managing small to mid-sized projects and supporting annual technology releases. Drives collaboration and preparation of required technical infrastructure deliverables. Performs all roles in Master Control Room during software testing and implementation to ensure successful plan execution and facilitation of communication for the purposes of troubleshooting and executive status reporting. Maintains FSR Release Management Work Breakdown Structure and provides graphical and statistical summaries for dash boarding purposes.3. Client: Sprint – Nextel, USA @OffshoreProject: Commission Nov’08 - Apr’11Project Description: Sprint Nextel’s commissioning project was intended to calculate commissions and pay based on channel used for specific lines of Business: Long Distance Telephony, Wireless (PCS) Telephony and Marketing Identities. This project was broadly subdivided into below three major applications:G7L – Indirect channel commission calculationG8L – Corporate Business channel commission calculationCOS – Company Operated Store (Retail channel commission calculation by Truecomp)

Senior Technical Lead in PL/SQL Development

To develop DB objects like procedure, function, trigger, cursor, pkg etc.

Master Of Computer Applications (Mca), Computer Science

Master Of Science (M.Sc.), Zoology/Animal Biology