Sql Server Hands-On
Resume:
Email Id: ***********@*****.***
Contact No: (***) 519 - 7087
DEEPAK CHAUDHARI
EXPERIENCE SUMMARY
Java Consultant with 15 years of hands-on experience in analysis, design, development and implementations of client/server, database and Internet-based applications in various business domains.
Expert level skills in Java/ J2EE-based development, with hands-on experience in complete design-build release product cycle for various projects using latest technologies such as Java, JavaScript, JSP, Servlets, Spring, Spring Boot, Spring Batch, Spring IOC, Spring AOP, Spring MVC, Spring DAO, Spring microservices, Hibernate, Struts Framework, Oracle, MS SQL Server, MYSQL and IBM DB2.
Extensive experience in developing n-tier applications within the BFSI domain, having engaged in application development efforts for Insurance and Capital Markets, FOREX, Banking majors.
Well versed in database design, coding and maintenance on multiple platforms (Oracle, MS SQL Server)
Specific strengths and abilities include strong problem solving capabilities, an eye for detail and quality. Ability to work alongside multiple teams.
Excellent inter-personal and communication skills, both verbal as well as written.
Extensive experience in various SDLC methodologies such as Agile and Waterfall models.
Proficient working knowledge in Application servers such as IBM WebSphere, Apache Tomcat, JBoss.
Excellent logical, analytical, problem solving and troubleshooting skills.
Great team player with strong leadership and communication skills.
Well focused and achievement oriented person with ability to manage change with ease.
EDUCATIONAL QUALIFICATION
Bachelor of Engineering (Mechanical Engineering)
TECHNICAL SKILLS
Operating Systems
Windows XP/ 2000/ 98/ NT, Linux, Ubuntu, MAC
Languages
Java, SQL, PL/SQL
GUIs
Eclipse, RAD, WSAD, STS, NetBeans IDE 3.5.1, TOAD, PostMan
Web Technologies
JSP, Servlets, J2EE, XML, XSLT, HTML, JavaScript, Flex, REST Webservices, SOAP, WSDL, JSON
Java Framework & Tools
Spring, Spring Core, Spring MVC, Spring DAO, Spring Boot, Spring microservices Spring AOP, Spring Batch, Spring Security, Hibernate, Struts, Angular, AWS Basics,JPA,Apache Kafta, Redis
Unit Testing
Junit, Mockito
Databases
MS SQL Server 2000, Oracle, DB2, MySQL, MS Access
Tools
Perforce, TeamTrack, ClearCase, SVN, JIRA, Bitbucket, WinScp, putty, VSS, CSV
Application Servers
JBoss, WebSphere, WebLogic, Apache Tomcat, Oracle Application Server, Apache
Integration Tools
WebMethods 6.0/ 7.1
Documentation
UML, Word, Excel
Software Methodology
Object Oriented Analysis & Design, SDLC (Agile, Iterative, Scrum, Waterfall)
PROJECT EXPERIENCE
Cognizant
Client: Edward Jones Oct 2024 to till date
Projegct1: AAR, Joneslinks
Role: Team Lead
Description:
AAR is appointments and review, primarily used to set Financial Advisors appointments with clients. From this portal they can add/update/delete calendar appointments, meeting details. This portal syncs the outlook calendar with AAR calendar .We can see appointments for day, week, region. We can set diffident types of appointments like Face to Face, call, Callback, Money Due, Note etc. We can see diffident reports like Weekly Office report, Money due monthly report, Activity Summary for day etc.
Responsibilities: Team Leader, hands on software development, designing experience.
Responsible for managing 6 guys, managing deliverers, developing software solutions.
Understanding AAR integration solutions for Joneslinks.
Creating Jira tickets and assigning to team members, conducting daily SCRUM calls, team meetings.
Implemented server side solution using Spring Boor, REST API, Spring AOP and Java 1.8
Designing and implementing REST API, using spring boot.
Worked as L3 Production Support.
Involved in Support activity, defect fixing, on call support.
Troubleshooting data issues and technical errors.
Involved in standard practice of coding, code review, code coverage, evaluating test cases.
Communicating to different team to understand the requirements and explaining solutions.
Defect fixing, tickets tracking, Solution designing, performance optimizations, writing test cases.
Deployments on different environments like DEV, UAT and PROD.
Environment: Java 1.8, Spring Boot, Oracle DB, Power Mockito, Jira, STS, Hibernate etc
Allied Informatics Inc.
Client: Charter Communication Feb 2020 to Sep 2024
Project: Mobile 2.0 Phase-1
Role: Team Lead.
Description: The Mobile 2.0 Phast-1: Project will provide efficient solution for Spectrum business, it is end to end
Online business solution for customers to buy different mobile products, mobile plans and promotions Online. In this we had to redesign and develop Credit Services (CSR) / Fraud Services.
The Fraud Services are designed to categorized and process the orders based on their credit scores, it was designed to send email reminders to end clients. The Fraud Services are designed to execute by system and manually by agents as per requirement. A Batch processing logic was implemented to process orders in pending state or cancel orders. Spring Boot Rest API has been developed to provide solution.
Responsibilities:
Full stack software developer, hands on software development, designing experience.
Responsible for managing 9 guys, managing deliverable, developing software solutions.
Understanding Mobile 1.0 integration solutions for Fraud Services.
Creating Jira tickets and assigning to team members, conducting daily SCRUM calls, team meetings.
Implemented server side solution using Spring Boor, REST API, Spring and Java 1.8
Designing and implementing REST API, using spring boot and Spring Microservices, Good experience working on Swagger, curl API.
Written test cases using Power Mockito.
Presenting incremental demos to stake holders and different team leads.
Creating model job components and POCs.
Troubleshooting data issues and technical errors.
Managing database transactions.
Involved in standard practice of coding, code review, code coverage, evaluating test cases.
Communicating to different team to understand the requirements and explaining solutions.
Defect fixing, tickets tracking, Solution designing, performance optimizations, writing test cases.
Deployments on different environments like DEV1, DEV2, SIT.
Used Apache kafka for all asynchronous communication for logging, email notifications etc.
Environment: Java 1.8, Spring Boot, microservices, Oracle DB, Power Mockito, Jira, STS, Hibernate,bitbucket, Apache Kafka, Splunk,Stream APIs etc
Digital Group InfoTech Pvt. Ltd. `
Client: TD Ameritrade Bank, NJ Nov’18 to June 2019
Role: Technical Lead
Project 1: Bulk Data Processor
Description: Bulk Data Processor are multiple Spring Batch jobs which runs sequentially/parallel to process bulk data from one Netezza DB(CDI) to Mongo DB(EDW). This component is providing solution to process billions of records in time efficiently manner. These are daily/ quarterly jobs completely developed using Spring Boot, Spring Batch 3.0.* version. We implemented performance critical solution using spring batch.
Responsibilities:
Being engaged in technical implementation hands on coding and solution designing.
Understanding the business critical
Implemented server side solution using Spring Batch, Spring Boot and Java 1.8ETL requirements.
Creating requirement specification, UML diagrams for the proposed solution.
Designing and implementing Spring Batch Jobs, Flows, Parallel Flows and Data flow.
Performance evaluation, profiling and implementing multithreaded Spring Batch.
Written test cases using Junit and Mockito.
Presenting incremental demos to stake holders and different team leads.
Creating model job components and POCs.
Troubleshooting data issues and technical errors.
Communicating to different team to understand the requirements and explaining solutions.
Defect fixing, tickets tracking, Solution designing, performance optimizations, writing test cases.
Deployments on different environments like DEV, SIT.
Environment: Java 1.8, Spring Boot, Spring Batch, IBM Netezza DB, NOSQL, Mongo DB, Mockito etc
Client: WW Norton Inc. NY
Role: Technical Lead March 17 to Nov’18
Project 2 : SmartWork5
Description: This is end to end solution for Learning Management System. It provides interface for users to study and appears for assignments, exams. This provides functionality for instructor to design assignments for students. This was a re-engineering project, where the application has been restructured to address the grade sync issues between SW5 and NCIA. It provides Class Activity Reports to display student, question, grades reports, and graphs. It has functionalities like Create Student Set, Create/Edit Assignment, Create/Edit Questions, Reset grades, eBooks. Every assignment gets created with certain business rules and the grading happens based on these rules. This has administrator module where admin can manage questions, taxonomy, accounts etc.
Responsibilities:
Worked as Technical Lead, Team management, arranging Team Meeting / Client Meetings.
Actively managing team of 8 developers.
Understanding current implementation, identifying defect and proposing new solution in reengineering release.
Being engaged in technical implementation hands on coding and solution designing.
Hands on implementation experience using Java, Spring, Hibernate, JSON.
Developed APIs using Spring microservices.
Developing REST Web Services and passing JSON to node.js services.
Worked on design artifacts, creating designing documentations, flow diagrams.
Primary responsibility was to understand the legacy implementation, client requirement and develop the application using Java technologies.
Defect fixing, tickets tracking.
Task assignment to respective team members.
Was involved in code reviews of pears, team meeting, SCRUM calls, timesheet managements, conducting interviews.
Solution designing, implementing best practices, code review, defect tracking, version controlling, MOM, client meetings.
Testing the REST web services using Post Man.
Worked on UI development by using Angular
Environment: Java 1.7, Spring, Hibernate 3.2, MySQL, MondoDB, JSON, Spring IOC, Spring microservices, NODE JS, Spring DAO, Apache Tomcat, Ubuntu/Mac, Angular, Docker
HSBC
Role: Sr. Consultant Specialist Nov’15 to Jan’17
1. Project: ISD (Investment banking market and static data)
Description: HSBC is one of the largest banks in world. ISD is centralized static data for most of the investment banking operations. It is a web based solution which provides static data for different systems. It manages data like Business Entities, Processing Organizations data, roles information, address, currency details different reports, standing settlement instructions. It generates different EOD files, end of week, end of month files through control-m jobs.
Responsibilities:
Being engaged in coding/ defect fixing/ implementation
Managing the team of 5-7 guys, arranging Team Meeting / Client Meetings.
Primary responsibility was to attend meeting with Business Analysis for requirement gathering, requirement analysis, and team communications.
Full stack developer responsibility, implementing solution using java, JSP, Servlets.
Resolving UI defect using JSP, HTML, CSS, and Servlets.
Defect fixing, unit testing
Arranging training, onboarding for new joiners.
Conducting code reviews of pears, team meeting, BA walkthroughs calls.
Was actively involved in deployment of ISD on DEV, SIT and UAT environments
Task assignment to respective team members.
Developed Stored Procedured using PL/SQL
Environment: Java 1.7, Oracle 11, Windows 7, STS, Jsp, Servlets, Spring, Webshere 8, JQuery, PLSQL
Intellect Design Arena Ltd. (POLARIS)
Client: Credit Suisse, USA
Role: Sr. Project Lead Feb’15 to Sep 2015
Description: Credit Suisse is one of the largest banks in USA. Market Data Back Testing is a reporting projects where all BEX reports are getting generated using Datawatch. Data Streams generation was the development using Report Data Algebra scripting for generating Daily, Monthly, Quarterly and Yearly reports.
Responsibilities:
Full stack software development working with Agile.
To develop Market Data Back Testing software for client Credit Suisse, United States.
Designing and developing Java classes, which were used in DRA to manipulate database data
Being engaged in coding/ implementation.
Managing the team of 2-3 guys, arranging Team Meeting / Client Meetings.
Primary responsibility was to understand the client requirement and develop the application using Java technologies and RDA scripting.
Task assignment to respective team members.
Implementing process like code reviews of pears, team meeting, SCRUM calls, timesheet managements, conducting interviews.
Defect fixing, production support and deployments of software on different environments
Coding for server side components for historical market data reports which was visualizing, monthly, daily, quarterly, yearly trading reports in graphical formats.
Environment: Java 1.7, Oracle 11, Windows 7, RDA, RDL Scripting.
Synechron Technologies Pvt. Ltd.
1. Project: Global Foreign Exchange (GFX) May’12 to July’14
Client: Wells Fargo, Charlotte, NC
Role: Team Lead
Description: Wells Fargo is one of the largest banks in USA. GFX provides functionality for Global Foreign Exchange. GFX buffet is trading application used for booking trades such as FX Spot, fwd, NDF, and Swap. Also it supports different modules like settlement, order board, and payment flow. GFX also provides facilities to upload bulk foreign exchange transactions into the system (trade feed), setting customer details.(static rates), and generate rate sheets for customer (Rate sheets).
Responsibilities:
Being engaged in coding/ implementation
Managing the team of 6 guys, arranging Team Meeting / Client Meetings.
Primary responsibility was to understand the client requirement and develop the application using Java technologies.
Solution designing using Java / Spring /Hibernate / Oracle technologies.
Understanding the existing application and document the flow for knowledge base.
Task / Bug assignment to respective team members.
Implementing Service Locator, Singelton and factory pattern.
Used Jira, Bitbucket, PMD, check style.
Designing artifacts using UML for settlement module.
Coding done for developing settlement synchronizatizers for GFX.
Defect fixing and working closely with QA team.
Closely engaged onsite team members, daily meetings.
Conducting code review, QA coverage reports.
Developing Junit test cases and testing service side code.
Environment: Java 1.6, Spring, Hibernate 3.2, MS SHibernate QL Server 2008, WebLogic 11g (10.3.5), Windows XP, AJax
2. Project: User Load (Data Transformer) Dec’11 to Apr’12
Client: Wells Fargo, Charlotte, NC
Role: Lead Software
Description: User Load project is batch file processor. Multiple files, which are coming from broker terminals are processed and transformed into a normalized AnnuityNet database. It has been developed using Spring batch technology. Different job scheduler has been used to process multiple files to staging database. Transformer is the component, which has been used to transform staging database to normalized database, which is used by AnnuityNet.
Responsibilities:
Understanding the ELT requirement, creating POC and proposing solution.
Worked as Individual contributor. Full stack developer role.
Engaged in coding and implementation
Solution designing for user load application using Java / Spring /Hibernate / Oracle technologies.
Creating design documentations.
Spring Batch and Spring IOC has been used to develop solution.
Spring Batch Job scheduler used.
Writing Mockito test cases and testing different components like processor and writer.
Performed enhancement / redesigning application.
Database designing, creating tables scripts.
Using SONAR Cube to maintain health of software code base.
Preparing for client demos.
Test environment setup for testing end to end solution.
Worked on designing database, schema definition and table.
Bitbuckt, Jira, Coburtura, PMD, Check Style has been used.
Environment: Java, Spring, Eclipse, Oracle, Windows XP/ 7.0
3. Project: GiftCardDashBoard/ PayGroupDashBoard/ SGDashBoard/
Wal-Mart Invoice Processing Aug’09 to Sep’11
Client: N.E.W, Sterling, VA
Role: Lead Software
Description: National Electronic Warranty (NEW) is working in extended warranty business. NEW sales extended warranty on electronics goods. Extended warranty is parallel to insurance domain. Once user claims his warranty it falls through the claims life cycle and it moves through different processes. All the above listed a projects are designed to support the claims functionality (claims life cycle) of NEW business, GiftCardDashBoard and PayGroupDashBoard are Java/Flex-based portals. WebMethods has been used as integration tool for these projects.
Responsibilities:
Full stack developer coding, solution designing and implementation.
Worked at client site to understand application.
Design and develop UI using Flex.
Managing the team of 5-9 guys, arranging Team Meeting / Client Meetings.
Primary responsibility was to understand the client requirement and develop the application using Java flex, webMethod technologies.
Solution designing different claims application using Java / Flex / Web Method / Oracle technologies.
Spring IOC, Spring MVC and Spring LAP authentication has been used in this project.
Understanding the existing application and document the flow for knowledge base.
Apache Tomcat has been used to deploy and run this application.
Domain Knowledge sharing cross teams.
CSV, SVN has been used to maintain the source code.
Defect fixing, code review, deployments, client demos.
Developed WebServices using Web Methods.
Flow Services has been developed using Web Methods and same has been consumes in Flex through Java calls.
Training team members of Web Method.
Performance improvements of application, implementing pagination, graphical representations.
Environment: J2EE, Spring, Flex, Eclipse, WebMethods, Web Services, Oracle, Apache Tomcat, Oracle Application Server, Windows XP/ 7.0
Contact this candidate