Management Sql Server

Mallemkonda Gattupalli

Sr AEM Developer

E: - ***********.**********@*****.*** ` Ph.: +1-469-***-****

PROFESSIONAL SUMMARY

Highly talented IT Professional with about 9 years of experience in developing and implementing Enterprise Solutions for Distributed Software products and distributed applications using JAVA technologies.

Worked on design and implementation of modules on Adobe CQ 5.5 and Adobe AEM 6.1. Have a solid understanding of CQ5 building blocks, CRX repository, leveraging web content management components for customization and porting of websites.

Expertise in Setup and configure Authoring and Publishing environments, replication agents.

Expertise in develop the custom CQ components on top of JCR (Java Content Repository) and OSJI framework, Apache Sling (A REST based web development framework on top of JCR), CRX (Day's commercial JCR Implementation), and CQ5 (Day's latest suite of WCM, DAM, and Social Collaboration applications).

Expertise in CQ Mobile development concepts like server-side Mobile CONTENT, Mobile Components, Emulators, Device Groups, Device Detection and Mobile request processing.

Having a good Experience in Social Collaboration and Campaign Management with CQ.

Expertise in migration from CMS to CQ5

Expertise in developing integrated business applications using Hibernate, Spring framework (Spring Core Framework, AOP, Spring Integration, Spring Batch, Spring MVC, Spring Web flow and Spring Security), Struts, JSF Framework and Web Services (JAX-WS, JAX-RPC, JAXP, JAXB).

Expertise in Project Implementation skills using both core and advanced java technologies like JSP, Servlets, EJB, Hibernate and JDBC.

Extensive experience in developing web pages using HTML5, CSS3, SASS, LESS, Object Oriented Javascript, JQuery, AngularJS, AJAX, JSON, REST APIs,

Expertise in build the tables, stored procedures, indexes, create jobs in SQL Server, use SQL Server Management Studio and tools such as query analyzer, activity monitor, and query profiler.

Expertise in analyzing Business Requirements, Delegation and Delivery of the Software with Quality.

Knowledge on using MVC and version control tools like Visual Source Safe and TFS.

Experience with SDLC process (Agile, Waterfall models) of performing detailed analysis, collecting use cases, documenting requirements and creating designs for Object Oriented Programming (OOPs) Applications.

Good experience in automated build process by using jenkins and maven

Good experience in migrating from CMS to AEM

Good experience in working on SQL Server

Good Knowledge on MongoDB

Good experience in coordinating and working with developers (Offshore and Onsite) and End Users in Team based environment.

Good experience in System testing, Integration Testing, Regression Testing, UAT and Automation Testing

Experience with front-end development with back-end system integration

Excellent Communication and Inter-personal skills, flexible and versatile to new environments, self-motivated a good team player and have worked in multicultural environment.

Proven problem solving, analysis and leadership skills. Capable of performing under minimal supervision as well.

EDUCATION

Bachelors of Engineering in Electronics & Communications, Year(2003 to 2007)

TECHNICAL SKILLS

Programming Languages

JAVA, Servlets 2.2, 2.3, 2.4, JSP 1.1, 1.2, 2.0, JDBC 4.0, AJAX, Web Services, SOAP

Web CMS (WCM) tool

Adobe CQ 5.4 & 5.5; AEM 6.1, Umbraco

Databases & Tools

Oracle 8i, 9i, 10g, SQL Server 2000, 2005 & 2008; IIS 6.0/7.0

Application Servers

Web Logic 10, JBOSS, WebSphere6.1, Apache Tomcat 6.1

Scripting/Markup Languages

Java Script, VB Script, HTML, HTML5, CSS, CSS3, JSON, JSP

Other Utilities

TFS, VSS, UML, MS Office

Operating Systems

Windows NT Server/9x/2000/XP/Windows 7/8

Management Skills

Team Leader/Onsite Coordinator

Domain knowledge

Consumer Goods, Banking and Retail

PROFESSIONAL EXPERIENCE

Client: Bank of America, Charlotte, NC Feb 2015 To Till Date

Role: Sr AEM/CQ5 Developer

Description: Bank of America is an American multinational banking and financial services corporation headquartered in Charlotte, North Carolina. It is the second largest bank holding company in the United States by assets. Worked on Online Banking/Bill Pay System. This provides secure online access to customer accounts and keeps track of daily account activity like withdrawals, deposits, and facilities like inter-bank money transfer was provided by the application. It also provides service to the customers to pay the bills.

Responsibilities

Worked on implementing CQ5 from procurement of product to training, project planning, requirement gathering, analysis, estimates and implementation.

Worked on implementing Responsive design on CQ5 platform using frameworks like Twitter Bootstrap and Foundation.

Developed the components and templates in Adobe CQ5.

Developed the complex components with dialog on CQ5 using jQuery, Zepto, HTML5 and CSS3.

Developed functionality specific OSGi bundles on CQ5.

Developed Marquees Panels for content implementers to make their work easy.

Extensively worked on front end, business and persistence tier using the HTML, CSS, JavaScript, jQuery, and Hibernate frameworks.

Used Sightly for Customizing workflows.

Creating Custom Components, templates using Sightly

Implemented the Sling Filter, Felix Filter, Sling Servlet, OSGI bundles for interacting with remote spring webapp services and custom business logic in java.

Used ExtJS for writing listeners in the dialogs .

Developed a map page for customer phasing

Developed sling servlets to perform various actions.

Maintained the Content Management System (CMS) and provided support for the application.

Solved many issue that come to our team.

Used Eclipse Integrated Development Environment (IDE) in entire project development.

Have worked on Coding for the service requirements as per the scheduled releases.

Involved in Code review, unit testing and local Integration testing.

Have worked on automated build process by using jenkins and maven.

Have worked with Devops team to make this build process.

Have involved in Migration process from Teamsite to AEM

Have involved in impact analysis and creating High Level Design Document and Low Level Design Document as per the Functional Specifications Document.

Have Performed the unit testing, system testing and integration testing.

Have worked in Testing support during the UAT and production.

Integrating of application modules, components and deploying in the target platform.

Ownership of build and release activities.

Suggesting innovations and doing subsequent analysis for the same.

Mentoring new team members.

Environment:

Adobe CQ5/AEM 6.1, Java (jdk1.5), J2EE, JSP, Servlets, Java Script, HTML, CSS, Ajax, jQuery, Apache Sling, CRXDE, CRX, WCM,log4j, Windows and Linux .

Client: Johnson & Johnson New Brunswick NJ DEC 2013 – JAN 2015

Role: AEM/CQ5 Developer

Description: Caring for the world, one person at a time, inspires and unites the people of Johnson & Johnson. We embrace research and science - bringing innovative ideas, products and services to advance the health and well-being of people. Our approximately 128,000 employees at more than 265 Johnson & Johnson operating companies work with partners in health care to touch the lives of over a billion people every day, throughout the world.

Responsibilities

Worked on customizing the foundation components in CQ5, provide workflows to extend functionalities and improve performance.

Worked on HTML5, CSS3, JQuery and extJS for designing and implementing custom CQ5 components.

Worked on style sheets to maintain the structure and improvise the appearance of WebPages.

Worked on Digital Asset Management, to manage and store all the media.

Maintained the Content Management System (CMS) and provided support for the application.

Involve with content management strategies, architecture and multichannel content delivery.

Implemented the Sling Filter, Felix Filter, Sling Servlet, OSGI bundles for interacting with remote spring webapp services and custom business logic in java.

Developed an AngularJS workflow manager leveraging Angular-UI's state router for flexible configuration .

Used AngularJS for management of multi-step user input flows .

Worked on Backbone.Configurator (Backbone.Config) which is an extensible object-class that helped us to manage Backbone.js configuration.

Worked on Multisite Manager (MSM) so as to get same structure and content on all the versions of website.

Worked on CRX as a repository and accessing the CRX content nodes by SQL Queries and XPath

Worked on CQ Mobile development concepts like server-side Mobile CONTENT, Mobile Components, Emulators, Device Groups, Device Detection and Mobile request processing.

Used Interwoven Teamsite CMS for deploying contents on QA, STG and PROD environment.

Involved in daily meetings and worked in Agile Environment.

Developed sling servlets to perform various actions.

Used log4j for logging the messages.

Wrote test cases for testing of CQ components and templates in both authoring and publishing environments.

Environment:

Adobe CQ 5.6, Java (jdk1.5), J2EE, JSP, Servlets, AngularJS .Java Script, HTML, CSS, Ajax, jQuery, Apache Sling, CRXDE, CRX, WCM,log4j,SQL Windows and Linux .

Client: ADP Atlanta GA DEC 2012 – NOV 2013

Role: CQ5 Developer

Description: ADP helps organizations of all types and sizes unlock their business potential. For 60 years, we’ve led the way in defining the future of business outsourcing solutions. And we remain one of the world’s most innovative, diverse and admired companies to work for today.

We are a comprehensive global provider of cloud-based Human Capital Management (HCM) solutions that unite HR, payroll, talent, time, tax and benefits administration, and a leader in business outsourcing services, analytics and compliance expertise. Our unmatched experience, deep insights, and cutting-edge technology have transformed human resources from a back-office administrative function to a strategic business advantage.

Responsibilities:

Perform CQ5 customization on foundation components core CMS and workflows to extend functionalities improve performance or fix issues on project level Utilize HTML CSS JQuery for designing and implementing custom CQ components

Developed the customizable landing pages and CQ5 custom components

Development of static web pages landing pages category landing pages using content management system Adobe CQ5

Worked on CRX as a repository and accessing the CRX content nodes by SQL Queries and XPath

Users and roles and build workflows as well as utilize Digital Asset Management

Implemented the OSGI bundles for interacting with remote spring Webapp, Webservices and custom business logic in java and deploy as jar files from the Felix System Console

Provide author training to business users to familiarize them with the design and usage of the system

Worked on Adobe CQ5 CMS end and developed the custom grid components

Have Worked on CMS migration to CQ5

Worked on CQ5 Forms customization by developing the custom form fields writing the custom constraints for form fields and specifying the global validation resource type at the form level

Used GIT to review code and do a continuous integration

Used Subversion for version control across common source code used by developers

Good experience in working on Spring framework Eclipse and SQL Server

Environment:

Adobe CQ5, JDK 1.6, MVC, JSON, JQuery 1.7, Apache Sling CRX, CRXDE, JSP, Apache Tomcat 7.0, SQL

Client: ICICI Bank Bangalore, India SEP 2011 – NOV 2012

Role: CQ5 Developer

Description: ICICI Bank was originally promoted in 1994 by ICICI Limited, an Indian financial institution, and was its wholly-owned subsidiary. ICICI's shareholding in ICICI Bank was reduced to 46% through a public offering of shares in India in fiscal 1998, an equity offering in the form of ADRs listed on the NYSE in fiscal 2000, ICICI Bank's acquisition of Bank of Madura Limited in an all-stock amalgamation in fiscal 2001, and secondary market sales by ICICI to institutional investors in fiscal 2001 and fiscal 2002. ICICI was formed in 1955 at the initiative of the World Bank, the Government of India and representatives of Indian industry. The principal objective was to create a development financial institution for providing medium-term and long-term project financing to Indian businesses.

.

Responsibilities:

Develop and write high level design with an emphasis on robust functionality and performance.

Assign detailed design and coding work and facilitate reviews.

Coordinate code reviews and ensure coding standards are followed.

Design and development of web pages using CQ5, JavaScript, HTML, CSS, Ajax and jQuery.

Developed Adobe CQ5 templates and reusable components.

Created an AngularJS add on lib that allows component developers to define and bind to W3C Custom Elements.

Involved in code releases, data loads, deployments, etc.

Involved in Integrate process with Twilio for sms and evoice and Brightmail for email.

Data from Sterling database is retrieved using RESTFUL service calls to Customer Order Management (COM) layer.

Using JAX-RS specification for creating Restful services.

Design user interface using html5, jquery and backbone.

Manage any technical issues that arise during development.

Coordinate security review and ensure security standards are followed.

Designed test plans with QA staff for unit, system and integration testing.

Environment:

Adobe CQ5, Java (jdk1.5), J2EE, JSP, Servlets, AngularJS, Java Script, HTML, CSS, Ajax, jQuery, Apache Sling, CRXDE, CRX, WCM,log4j, Windows and Linux,

Client: Canara Bank Bangalore, India May 2007 – Aug 2011

Role: Developer

Description: This client requires an online application for loans section where client can request for loans, see approval status of loans, loan balance, historic payments and transactions online and bank management can approve the loans online and update the payments and their status online.

.

Responsibilities:

Involved in acquiring requirements from the clients.

Designed use cases for different scenarios.

Designed and developed components for billing application.

Developed functional code and met expected requirements.

Wrote product technical documentation as necessary.

Designed presentation part in JSP(Dynamic content) and HTML(for static pages)

Designed Business logic in EJB and Business facades.

Used MDBs (JMS) and MQ Series for Account information exchange between current and legacy system.

Attached an SMTP server to the system which handles Dynamic E-Mail Dispatches.

Created Connection pools and DataSources.

Involved in build the tables, stored procedures, indexes, create jobs in SQL Server

Deployed this application which uses J2EE architecture model and Struts Framework first on

Weblogic 5.1 and helped in migrating to JBoss Application server.

Participated in code reviews and optimization of code.

Followed Change Control Process by utilizing winCVS Version Manager.

Prepared test plans and data, and user documentation for customer billing system.

Problem-solved hardware issues with fault-tolerant hard drives.

Environment:

J2EE, JSP, Struts Frame Work, EJB, JMS, JBoss Application Server, Tomcat Web Server, Pl/Sql, SQL, winCVS, MS PowerPoint, MS Outlook

Contact this candidate