SUMMARY:

• Technical Architect with 15+ years of professional software experience in IT industry.
• Good working experience in Planning, Designing, Developing and Coordinating projects in Information Technology using Agile and Waterfall methodologies.
• 6+ years of experience as Project Leader/ Manager / Architect middleware applications.
• 6 + years of experience with merchandising Product catalog, Web navigation information in PIM and good understanding of how Promotional attributes, Copywriting, Digital assets data managed in PIM.
• Providing e - commerce solutions and middleware data architecture to a leading e-commerce client
• Confidential & Beyond since 6+ years. Following are few key solutions implemented/supporting at Confidential & Beyond
• Designed and developed the middleware interface between PIM and Confidential (e-commerce front end platform) to process the product catalog information.
• Designed and implemented daily Price updates from JDA to Confidential and I also implemented the Dynamic pricing module to keep the pricing competitive with other retailers.
• Designed and implemented Confidential (Less than Truck Load) module to sell large items on the web site.
• Designed and implemented Customizable/Personalize products feature on web site.
• Designed and developed Same Day Delivery feature.
• Designed and implemented the solution to show the available Product inventory on Product listing pages at nearby stores.
• Designed and implemented Coupon Wallet Webservices .
• Designed and implemented the Registry Webservices .
• Provided architecture to send Product catalog feeds to various third party vendors.
• Designed and implemented the Products reviews feed between a third party vendor and Confidential & Beyond.
• Successfully migrated legacy data model of the Confidential & Beyond to new Confidential Data Model using Oracle Data base.
• Write and maintain documentation to describe program development, specifications, logic, coding, and user operating procedures with the e-commerce environment.
• Successful background working with stakeholders to develop Service Oriented Architecture framework that aligns to business strategy, processes, goals and IT assets.
• Work closely with project managers, developers, and focus groups to avoid redundancy, minimize expenditures, and improve overall synergy within organization.
• Tremendous experience in developing Desktop and Web applications using ASP. Net, C#.Net, VB.Net, XML, HTML and Java script.
• 6+ years of working experience with REST APIs using AJAX and JSON.
• Over 12 years of experience in designing, development, and testing enterprise Oracle database applications in Versions 8i, 9i, 10g and 11g. Specific expertise in database development utilizing PL/SQL and SQL.
• 12+ years of experience in PL/SQL, MS-SQL, Data Analysis, ETL and application performance tuning.
• In-depth experience in designing/developing interfaces between applications developed in UNIX, Oracle, TIBCO and .Net.
• Over 12 years of experience in gathering, analyzing and documenting business requirements in the form of Functional and Technical specifications, Entity-Relationship (E-R) diagrams, process-flow diagrams, and data-mapping documents.
• Extensive experience in all phases of software development life cycle (SDLC), i.e. requirements gathering, analysis, design, development, System Acceptance Testing, deployment, maintenance and production support.
• Over 8 Years of experience of leading teams (Technical Lead) on different projects with complex requirements and tight deadlines. And have lot of experience in Onsite and Offshore Co-ordination.
• Good experience in interacting with Business units from various countries in the world and understanding their requirements and proposing best technical solutions in the IT industry.
• 2 years of experience in creating, modifying data base objects using IBM DB2database.
• Over 6 Years of experience in UNIX Shell scripting and have good working experience in UNIX jobs scheduling through, Crontab, Maestro and UC4 job schedulers.
• Over 12 Years of experience in Quality assurance processes and Release management process.
• Trained in ITSM BMC Remedy tool and having in depth working experience on ITSM and ITIL and JIRA.
• Working knowledge in managing the internal controls of the applications that falls under the scope of Sarbanes Oxley (SOX).
• Extensive experience in accurately estimating project resources and projects completion as per the timelines and budget.

TECHNICAL SKILLS:

Development Applications: PL/SQL, SQL, C, HTML, C++, Visual Basic, UNIX Shell Scripting, C#.NET, ASP.Net, VB.Net, Visual Studio 2003, 2005 & 2008, MVC, WCF, SSRS, NUnit, JUnit and REST.

Databases: Oracle 9/9i/10g/11g, MS SQL Server and IBM DB2.

Oracle Utilities: SQL*Loader, Import/Export utility, External Tables.

Web Servers: Windows 2000 and 2003 Servers.

Networking Protocols: TCP/IP, C and Java sockets, HTTP, FTP, SMTP

SQL Tools: SQL Navigator 5.0, TOAD 10.1, SQL Analyzer, Erwin and Visio.

OS/Environments: Windows NT/XP, Windows 2000, Vista and Windows 7, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential,NJ

Technical Architect

• Responsibilities include the overall planning, organizing, architecting, integrating, and delivery of all services prioritized in alignment with the client's expectations and business needs
• Lead a team of solution partners and client developers and specialists to meet specific client requirements; responsible for ensuring an optimal system architecture to facilitate the successful completion of implementations
• Provide the architecture solutions to all initiatives taken by Business to improve the guest online Shop experience and result in more revenue.
• Interact with client Directors of IT and Marketing to understand requirements and set project milestones.
• Analyze, define, and document system requirements for data, workflow, logical processes, hardware and operating system environment.
• Provide technical support and solutions to enhance Product catalog data feeds processing performance between PIM and Confidential .
• Provide technical support to Registry web services (REST APIs) and Coupon web services.
• Provide technical support to middleware process which tags products Same Day Delivery attribute.
• Assist Business team to execute manual prices overrides and special marketing promotions on the Confidential & Beyond retails websites.
• Triage production support incidents by looking for Website data issues that arise from the middleware and then fix those data issues in the database.
• Gather the new features/enhancements requirements from Business team and create POC’s and created feasible plan for the development.
• Drive enhancements that improve application performance, make applications more configurable, automate tasks, or prevent long-term data issues.
• Delegate and assign work to a developer or application Database Administrator (DBA), and then drive their development progress through implementation.

Confidential

Technical Architect

Technology and Tools: .Net, Oracle, TIBCO, SQL Server, TOAD and PIM.

• Created technical specification document to explaining the flow of the personalization/customization products.
• Design and Modify the PIM to Confidential interface (Oracle PL/SQL and TIBCO) to process the new personalization/customization attributes.
• Modified REST APIs to accommodate the processing of new attributes for Customized products.
• Write and execute test case scenarios to test all possible data flows.
• Assist Business team during the User acceptance testing.
• Provide production support after the launching this feature to customers.

Confidential

Technical Team Lead

Technology and Tools: Oracle, ASP.Net, C#.Net, MS-Access, Visual Studio 2010, VSS, TFS (Team Foundation server), and TOAD.

• Closely worked with Business to gather requirements for the Registry Services.
• Design and develop the Registry web services in .Net to create/update Bridal, Baby, Birth Day and College etc… registries
• Designed and developed coupon wallet service API’s. Using these API’s front end can create/update wallets for users and also add and get coupons for the users.
• Involved in Complete Project Life Cycle using agile methodology.
• Prepare Functional Specifications, Technical Specification and Unit test cases.
• Design application architecture and prototype using Visio. Database designing using Oracle 10G, Reports SSRS.
• Development and testing, technical support for the user’s queries and issue resolution.
• Perform extensive user interaction for query resolution.
• Generate ad hoc reports using MS- Access tools.
• Deployment and post implementation Support.

Confidential

Technical Team Lead

Technology and Tools: .Net, Oracle, TIBCO, SQL Server, TOAD and PIM.

• Integrate Harmon Data with Beyond Data systemically.
• Offer a subset of Harmon SKUs for purchase to BBBY & BABY websites, non ORM-D SKUS (ORM-D: “Other Regulated Materials-Domestic” These are products with certain shipping, packing, storing, etc. legal restrictions).
• Display additional Harmon specific product information to the customer on the websites.
• Deliver customer orders with Harmon SKUs in an efficient manner, leveraging existing processes
• Closely worked with Business to gather requirements for the Confidential integration.
• Design the interface program to accommodate Confidential data like, Ingredients, Warning and Instructions
• Involved in complete Project Life Cycle using agile methodology.
• Prepare Functional Specifications, Technical Specification and Unit test cases.
• Design application architecture and prototype using Visio. Database designing using Oracle 11G,
• Development and testing, technical support for the user’s queries and issue resolution.

Confidential

Technical Architect

Technology and Tools: .Net, Oracle, TIBCO, SQL Server, TOAD and PIM.

• Modify the PIM- Confidential interface to accommodate the Confidential product attributes, Like Assembly offered, Assembly time, Types of Ship methods, case weight etc.
• Closely worked with Business to gather requirements for Confidential Project.
• Involved in Complete Project Life Cycle (SDLC)
• Prepare Functional Specifications, Technical Specification and Unit test cases.
• Design application architecture and prototype using Visio. Database designing using Oracle 11G
• Development and testing, technical support for the user’s queries and issue resolution.

Confidential

Technical Architect

Technology and Tools: .Net, Oracle, TIBCO, SQL Server, TOAD and PIM.

• Design the PL SQL programs to read Product details sent by PIM.
• Design the PL SQL programs to push Product details sent by PIM to Confidential system.
• Involve in Complete Project Life Cycle Requirement gathering and analysis.
• Prepare Functional Specifications, Technical Specification and Unit test cases.
• Design application architecture and prototype using Visio. Database designing using Oracle 11g.
• Provide technical support for the user’s queries and issue resolution.
• Perform extensive user interaction for query resolution.
• Generate ad hoc reports using MS- Access tools.
• Involve in Development and testing.
• Deployment and post implementation Support.

Confidential

Technical Team Lead

Technology and Tools: .Net, Oracle, TIBCO, SQL Server, TOAD and PIM.

• Design the PL SQL programs to convert the Data to Confidential format.
• Design/Modify the existing web services in .Net
• Provide technical support for the user’s queries and issue resolution.
• Perform extensive user interaction for query resolution.
• Design, Implement and Test Interfaces from PIM system to Confidential . Also modifying existing Interface as per the requirement.
• Play an active Role in migrating the current Data model to Confidential
• Generate ad hoc reports using MS- Access tools.
• Involved in Complete Project Life Cycle (SDLC). Requirement gathering and analysis.
• Prepare Functional Specifications, Technical Specification and Unit test cases.
• Design application architecture and prototype using Visio. Database designing using Oracle 11g.
• Involve in Development and testing. Deployment and post implementation Suppor

Confidential,Decatur, IL

Technical Team Lead

Technology: ASP.Net, C#.Net, AJAX, Java Script, CSS, HTML, IBM DB2, Visual Studio 2010, TFS (Team Foundation server), and IBM DB2 Data Studio.

• Involved in all phases of application development: requirements gathering and analysis, design, implementation and testing.
• Worked directly with customers and users of Rail Rates system to identify their business processes, rules and application user requirements.
• Designed and developed Rail Rates and Fuel Surcharge web forms using ASP.NET, ADO.NET, Visual Studio 2010 and IBM DB2.
• Create/modify /debug PL/SQL stored procedures and PL/SQL performance tuning using IBM DB2 Data Studio.
• Designed Business layer and Developed data access layer using Datasets, Data Reader, Data Adapter as a part of ADO.NET to access and update database and
• Wrote client side scripting in JavaScript to perform client side validation and manipulate web content dynamically.
• Designed data model, Created tables and stored procedures using IBM DB2 for accessing and manipulating the data in Server using ADO.NET
• Developed standardized menu navigation for ADM Intranet websites using CSS, DHTML, Themes and Master Pages to give all intranet applications a uniform and consistent look and feel.
• Involved in creating user defined controls, Custom Controls and also used AJAX controls for dynamic display of Rail Rates and Fuel Surcharge details.
• Involved in the unit testing and the integration testing and create Unit test cases.
• Documenting Functional and technical design artifacts including mapping documents between system requirements and coding functions. Deployment and post implementation Support.
• Used Share Point tool as CMS to maintain the system documentation.

Confidential

Technical Team Lead

Technology: ASP.Net, C#.Net, AJAX, Java Script, CSS, HTML, IBM DB2, Visual Studio 2010, TFS (Team Foundation server) and IBM DB2 Data Studio.

• Extensively used Microsoft .NET framework using ASP.NET, VB.NET to use .NET features that powered with CLR.
• Used ADO.NET objects such as Dataset and Data Adapter, for consistent access to Oracle data sources.
• Involved in Writing, Modifying complex Queries using IDM DB2.
• Developed User Controls for Common Header's in the ASP.NET.
• Used List Views for presenting Confidential booking details to the user.
• Involved in creating User Controls for maintaining custom Properties on the Web Pages like Banner.
• Prepared Functional and Technical specs. Performed validation using Validation Controls.
• Performed Unit Testing and Integrated Testing and create Unit test cases.
• Maintenance and enhancement of PL/SQL packages, Function, Stored procedures, Triggers and Views using IBM DB2.
• Troubleshoot the user’s issues and resolve the system issues in timely fashion.
• Used Share Point tool as CMS to maintain the system documentation.

Confidential, CA

Technical Team Lead

Technology: Oracle 10g and UNIX, SQL Navigator, Toad, Putty, WinSCP and Humming Bird.

• Responsible for Oracle PL/SQL development, develop PL/SQL scripts for complex business requirements by participating in the full systems development life cycle and is responsible for designing, coding, testing, implementing, documentation, maintaining and supporting applications software.
• Perform Data analysis, SQL scripting, tuning and optimization (schema and SQL) on large Oracle OLTP databases and addressing data quality issues. Size of this database is 2.5 TB.
• Involved in manual/Automatic ETL data extracts/loads from a variety of sources, including text files, Excel worksheets, and other database files, on both a scheduled and ad hoc basis.
• Perform large volume data conversion, data cleansing, generate various reports as per the Business needs and submit them to respective Business Units.
• Working with several UNIX utilities, and creating shell scripts to kick off automated jobs, manipulate files and monitor system performance.
• Implemented system in 19 countries across the globe and discussing with Business units of new countries for rollouts.
• Handling the daily tasks like Checking Credit card data loads from Chase Bank and monitoring and fixing Unix Jobs.
• Designing, Implementing and Testing Interfaces from Confidential system to Finance systems (SAP and JDE) of the respective locations. Also modifying existing Interface as per the requirement.
• Played and playing an active Role in deploying the Confidential system in new Countries.
• Adding/Removing Modifying the Expense Types as per the request from respective Confidential locations.
• Generating ad hoc reports using UNIX shell scripts and automate scripts so that reports will be automatically sent to Clients as per the schedule. Also create various canned reports using MS- Access tool.
• Created new Tables, Triggers, and Materialized Views, Snapshots, Constraints, arrays, varrays, nested tables and Sequence keys for FS application.
• Working with business users to develop functional requirements specifications.
• Prepared Solution and Technical Design, Functional specification documents as per industry standards.
• Create Unit test cases, code review logs and Knowledge transition documents.
• Provide a specialist skill or support role to investigate incidents received from help desk and coordinate resolution and recovery actions for assigned incidents.
• Actively participated in Implementation, Change and Release management.
• Ensured compliance with Information Security requirements.
• Earned a reputation for solving complex technical and data problems using innovative cost and time saving techniques. Mentored junior team members and shared knowledge with peers.

Confidential

Lead .Net Developer

Technology: ASP.Net 2.0, C#.Net, Oracle 10g and UNIX, Visual Studio 2005,TFS (Team Foundation server), SQL Navigator, Toad, Putty, WinSCP and Humming Bird.

• Involved in all phases of application development: requirements gathering and analysis, design, implementation and testing.
• Worked directly with customers and users of the system to identify their business processes, rules and application user requirements.
• Designed and developed web forms using ASP.NET, ADO.NET, Visual Studio 2008 and Oracle 10g.
• Create/modify /debug PL/SQL stored procedures and PL/SQL performance tuning and involved in query optimization. Size of this database is 1 TB.
• Designed and Developed data access layer using Datasets, Data Reader, Data Adapter as a part of ADO.NET to access and update database and
• Wrote client side scripting in JavaScript to perform client side validation and manipulate web content dynamically.
• Designed data model, Created tables and stored procedures using Oracle 10g for accessing and manipulating the data in Server using ADO.NET
• Developed standardized menu navigation for company Intranet using CSS, DHTML, Themes and Master Pages to give all intranet applications a uniform and consistent look and feel.
• Involved in creating user defined controls, Custom Controls.
• Scheduling and maintaining the weekly status reports and collection of Metrics.
• Involved in the unit testing and the integration testing
• Create Unit test cases, code review logs and Knowledge transition documents.
• Coordination with Quality and Testing team and Training of end user.
• Documenting Functional and technical design artifacts including mapping documents between system requirements and coding functions.
• Design application architecture and prototype using Visio. Database designing using Oracle 10G, Reports using Crystal reports.
• Designed an Interface in UNIX for the bank Routing Numbers feed from SAP.
• Involved in designing the ETL process to transmit the Data Files.
• Deployment and post implementation Support.
• Manual/Automatic extracting of various reports as per the Business needs.
• Customized this website as per Global countries requirements and rolled out this web site in Brazil, Bangladesh, Australia, China and Thailand.

Confidential

Sr. Net Developer

Technology: ASP.Net 2.0 and Oracle 9i, Visual Studio 2005, TFS (Team Foundation server), SQL Navigator and Toad.

• Migration of application from ASP to ASP.NET.
• Involved in Analysis/Requirement gathering/Customer Interaction and Design phase of the entire application
• Prepared Functional Requirement Specification and Technical Specification document, Test Plan
• Involved in Database design change and migration of data.
• Creating new PL/SQL stored procedures, functions, views and nested tables.
• Responsible for Performance tuning of Database. Size of this database is 1 TB.
• Extensively used Asp.Net for developing Web Pages. Developed Business Layer and Data Access Layer.
• Used ADO.NET programming to create Data Access Layer.
• Implemented validations using the ASP.NET Validation Controls.
• Configured Web.Config for profile personalization.
• Involved in developing Security Layers for web page security and User Authentication in C#.Net.
• Created Test Cases for both Units Testing and Integrated Testing.
• Used TFS for configuration management.
• Prepared Unit Test Cases and Unit test plans for the Developed functionalities.
• Responsible for client-chat requirements & sending status reports on weekly basis.
• Extract reports from Database as per the Clients Requirements.
• Involved in ETL activity to load the external data files into Oracle Data base.
• Provided post-production maintenance support for application like changes, error-bugging and error-handling.

Confidential

Sr. Software Developer

Technology: ASP.Net 1.1, Oracle 8i and UNIX, Visual Studio 2003, Visual Source Safe, SQL Navigator, Toad, Putty, WinSCP and Humming Bird.

• Involved in System study and requirement gathering.
• Developed Web forms/user interfaces and validated these pages/forms using C#.NET and ASP.NET.
• Create/modify /debug PL/SQL stored procedures and PL/SQL performance tuning.
• Handled ETL activities to load the Payment and Invoice files in Database.
• Designed and developed business layer, data access layer and interface layer.
• Implemented validation using validation server controls and JavaScript.
• Used Data Set to fill and retrieve data from the Web Services, used Data view for filtering data in data set.
• Involved in coding Configuration files.
• Developed User controls and called them in ASP.Net WebPages.
• Utilized Trace and Debug flags within the web application in the development and test environments of the application.
• Used Visual Source Safe for version control in team environment. Performed Unit & Integration testing.
• Create Unit test cases, code review logs and Knowledge transition documents.
• Database design as well as created stored procedures, Views for the developed functionalities in Oracle 9i database.
• Involved in performance tuning of the database and query optimization. Size of this database is 2 TB
• Creating shell scripts to kick off automated jobs manipulate files and monitor system Data loads.
• Prepared reports using UNIX shell scripts and automated the scripts so that reports automatically shipped to Clients as per the schedule. Scheduling jobs in UNIX using Crontab.
• Coordination with Quality and Testing team and Training of end user.

Confidential

Software Developer

Technology: VB 6.0, Oracle 8i and UNIX, Visual Basic 6.0, Visual Source Safe, SQL Navigator, Toad, Putty, WinSCP and Humming Bird.

• Developed screens using VB 6.0 showing the details of Non-operated joint ventures.
• Created various canned reports as per the customer requirements.
• Prepared Technical Specification and Functional specifications.
• Create Unit test cases, code review logs and Knowledge transition documents.
• Played a key developer role in the application development and Testing

Confidential

Software Developer

Technology: Power Builder 6.0, 8.0, Oracle 8i, 9i and UNIX, Visual Source Safe, SQL Navigator, Toad, Putty, WinSCP and Humming Bird.

• Scheduling jobs in UNIX using Crontab. Creating new reports.
• Creating/modifying UNIX scripts and stored procedures.
• Worked extensively on stored procedure and UNIX scripting.
• Create/modify /debug PL/SQL stored procedures and PL/SQL performance tuning
• Setup Monthly process. Prepare Functional and Technical specs.
• Create Unit test cases, code review logs and Knowledge transition documents.
• Played an active role upgrading DART from PB 6.0 to PB 8.0

Confidential

Sr. Software Developer

Technology: ASP.Net 1.1, Oracle 8i and UNIX, Visual Studio 2003, Visual Source Safe, SQL Navigator, Toad, Putty, WinSCP and Humming Bird.

• Microsoft .NET framework using ASP.NET, VB.NET to use .NET features that powered with CLR.
• Used ADO.NET objects such as Dataset and Data Adapter, for consistent access to Oracle data sources.
• Tuned several long-running SQL queries and PL/SQL procedures. Size of this data base is 1 TB.
• Involved in Writing, Modifying and optimizing complex Queries.
• Developing User Control for Common Header's in the ASP.NET.
• Used Grids and Data Views for presenting employee details to the user.
• Involved in creating User Controls for maintaining custom Properties on the Web Pages like Banner.
• Prepared Functional and Technical specs.
• Performed validation using Validation Controls and Telerik Controls.
• Performed Unit Testing and Integrated Testing
• Create Unit test cases, code review logs and Knowledge transition documents.
• Developing, Maintenance and enhancement of Unix Scripts. Cron Job Scheduling.
• Maintenance of interface with JDE and SAP data. Regularly update the data using ETL process.
• Maintenance and enhancement of PL/SQL packages, Function, Stored procedures, Triggers and Views.