SUMMARY

• 11+ years of IT experience in Software Design and Development in Microsoft Technologies
• 11 + years of US Retail domain experience
• Having strong Management and Leadership skills and utilizes the resources to the fullest extent, motivate them appropriately
• 1 year of experience as a Scrum Master for the People transformation project (Human Resources)
• 3 Years of experience with functional and implementation knowledge of Oracle Retail Suite of applications (RMS 13.2.6, RPM and SIM)
• 3 Years of working experience in developing interfaces between Epicor Retail Suite applications (Merchandising, WMS, POS and Sales Audit, Markdown Optimization)
• Developed Interfaces between Oracle RMS and JDA Allocation
• Good understanding of RIB Hospital, RIHA and RIB interfaces
• Good Implementation knowledge on the Ecommerce website (Ordering, Fulfillment, Returns, Product Sampling)
• Good working experience in developing and deploying web based applications using .Net and database design
• Good working experience in developing and deploying ETL packages using SSIS
• Extensive knowledge on the SDLC process and agile methodologies.
• Involved in different phases starting from Requirement Gathering, Design, and Development to Production Deployments and production Support

TECHNICAL SKILLS

Technologies: ASP.NET, C#.Net, AJAX, Java Script, HTML, XML, CSS, Web Services, IIS, LINQ

Tools: Visual Studio.NET 2003 - 2010, Team Foundation Server, MS SQL Enterprise Manager, MS Office, UC4 (Atomic)

Integration/Reporting Tools: SSIS, SSRS

Project Management: Waterfall, Agile

Database: MS SQL Server, Oracle

Packages/Products: Oracle Retail Suite 13.2.6 (RMS, RPM and SIM)

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Conducted Daily Stand up meeting, User story estimation, Sprint retrospective meetings and Product Demo meetings
• Responsible for removing any impediments to the Scrum team
• Prepared burn down chart and weekly status report

Environment: Salesforce, SAP - ABAP, Mule Soft, Web Merge

Integration Manager

Confidential, Topeka, KS

Responsibilities:

• Responsible to identify and manage project dependencies and critical path and track project milestones and deliverables
• Involved in the Architecture and Database design for Store Dashboard and Interfaces
• Point of contact for escalations and coordination with the Development team, Client management team
• Contributed to the Sprint Planning sessions
• Developed the Store Dashboard application using MVC Razor framework, Automated jobs using UC4 environment
• Resolved production issues related to Store Setup, Polling issue, Transaction log processing and Back office data collect operations

Environment: ASP.Net, MVC, UC4, Power Shell Script

Integration Manager

Confidential, Houston, TX

Responsibilities:

• Responsible to identify and manage project dependencies and critical path and track project milestones and deliverables
• Responsible for the entire data conversion activity from Epicor Merchandising to Oracle RMS system
• Populated 50 + tables in RMS database with 3 year historical data from Epicor using SSIS
• Performed 5 Mock data conversion before the implementation
• Created a utility to automate the unit testing process in the data conversion. This saved 300 hours of testing effort in all the 5 mock data conversion
• Involved in cleaning up the incorrect data in the Epicor Merchandising system
• Involved in structuring the Operational Data Store (ODS) between RMS and the downstream systems
• Involved in the Architecture and Database design (ODS)
• Developed project plan for Data Conversion, Data Integration and BI Integration
• Involved in the development of 40 + interfaces from RMS to downstream systems like Sales Audit, POS, CRM and BI
• Involved in the design and development of 20 + interfaces between RMS and JDA Allocation
• Created low level, high level and functional specific document for the interfaces.
• Point of contact for escalations and coordination with the Development team, Client management team
• Conducted Quality audits for the deliverables and prepared Metrics and status report for the management
• Provided inputs for overall implementation plan, lead deployment of applications/infrastructure and post-production support activities
• Scheduled all the ETL jobs in different workflows using UC4 (Atomic)
• Involved in performance tuning and optimization of data mappings and sessions using features like partitions and data/index cache to manage very large volumes of data
• Used Attunity connector plugin to get the data from Oracle database in SSIS
• Managed 20 offshore team members
• Used Mercurial tool for version controlling

Environment: Oracle Retail Suite 13.2.6 (RMS, RPM, SIM), JDA Allocate Now, SSIS, SQL Server

Integration Lead

Confidential, Houston, TX

Responsibilities:

• Extensively involved in almost all the phases of Project life cycle right from Requirements Gathering, Design, Development, Testing and Production deployment
• Involved in designing 20+ interfaces between Epicor Merchandising, Magento and Innotrac
• Prepared test plan and performed unit testing on the interfaces
• Performed System testing on all business process involved in the Ecommerce website (Ordering, Fulfillment, Returns, Product Sampling)

Environment: SSIS, MS SQL Server, Magento (Open Source)

Project Lead

Confidential, Houston, TX

Responsibilities:

• Involved in Web application design and Database design
• Created ETL package to get the 24 months Sales and inventory information from BI to SLAM tool
• Created reusable components like Excel reader, Grading selector, Document uploader
• Involved in project estimation, planning, metrics creation and Status reporting
• Created and maintained the project specs, High level design, Low level design and Unit test plan
• Co-ordinated teams from onshore and offshore to accomplish the project deliverables well on time

Environment: ASP.NET, C#, MS SQL Server 2012, SSIS, XML

Program Lead

Confidential, Houston, TX

Responsibilities:

• Involved in Web application design and Database design
• Created 20 + interfaces between the Epicor Retail Applications
• Deployed ETL packages using SSIS
• Created reports from Epicor databases using SSRS
• Onsite coordination, planning and managing daily activities and interaction with client
• Preparation of test plan and Implementation plan
• Created alert jobs using .Net and scheduled using windows scheduler

Environment: ASP.NET, C#, MS SQL Server 2012, SSIS, XML, SSRS, Windows Scheduler, Epicor Retail Suite (Merchandising, WMS, POS and Sales Audit)

Project Lead

Confidential, Fort Worth, TX

Responsibilities:

• Involved in Web application design and Database design
• Involved in converting all the data from Lotus Notes to Oracle environment
• Developed lots of reusable components like multi select dropdown, customized grid view control, page layout design and document upload control
• Co-ordinated with different client teams from Fort Worth and Hong Kong for the architecture design
• Managed 10 member offshore team for the development activity
• Worked in Version control using Team Foundation server (TFS)
• Involved in the Code review process
• Conducted Quality audits for the deliverables and prepared Metrics and status report for the management

Environment: ASP.NET, C#, AJAX, Oracle 11G, Lotus Notes, HTML, JavaScript, TFS, Microsoft Enterprise Lib 4.1

Team Lead

Confidential, Fort Worth, TX

Responsibilities:

• Involved in almost all the phases of Project life cycle right from Requirements Gathering, Design and Development, Testing, integration and Production deployment
• Involved in Analyzing the Functional Requirement Specifications, Technical docs and facilitate understanding between client and Confidential teams.
• Developed the Custom Workflow Engine needed for the tool

Environment: ASP.NET, C#, AJAX, Oracle 11G, DB2, IIS Server, HTML, JavaScript, .NET web services

Dot Net Developer

Confidential

Responsibilities:

• Implemented Web applications in the Answers Online portal
• Worked with different databases (MS SQL Server, IBM DB2 and Oracle)
• Involved in the preparation of detailed test case documents for various sub-sections in the application
• Handled various maintenance requests ranging from Production bug fixes to major enhancements
• Performed unit testing and provided UAT and implementation support
• Environment: C# with Microsoft Visual Studio.NET 2005, MS SQL Server, IBM DB2, Oracle