SUMMARY

• Around 14 years of IT experience with technologies Oracle PL/SQL, SQL Server development, VB6,VB.net, SSIS, Sybase, Classic ASP, M2O Studio/Paradigm Tool and JIRA tool.
• Around 4 years of experience in mutual funds, investments and finance domain and 4 years of experience in manufacturing repair domain involving Analysis, design and development of underwriting & Surety applications.
• 4 years of experience in Windows and Doors quote development catalog tool. Good understanding of Agile model and working since last 4 years.
• Worked closely in JIRA with Scrum master and Product owners to update product backlog items.

TECHNICAL SKILLS

Operating System: Windows 7/10/Server

Environment: Client/Server, Citrix, Desktop, Web applications

Database: SQL Server 2000, 2008,2012 Sybase 12.5, Oracle 10g,11g, Sql Lite DB3

Internet Tools: HTML, VB Script, Java Script

Inhouse Tools: M2O Studio, Paradigm Tool

Languages: PL/SQL, VB 6.0, Classic ASP, SSIS, Informatica, VB.net, C#.net, ASP.net

Other: ETL, Database conversion, Database performance tuning/optimization

Reporting Tools: Crystal Reports, VBA Macros, SSRS

Dev Model: Agile, Atlassian JIRA, Waterfall

BI Tools: SSIS,SSRS, Informatica

Cloud: Exposure to Azure Administrator role(Completed Training)

Data Visualization/Analytics: Exposure to Tableau(Completed Training)

PROFESSIONAL EXPERIENCE

Confidential

Sr. Programmer/Developer

Responsibilities:

• By using very specific complex domain knowledge of Fenestration Industry, gathering requirement for 400/200/100 Series, A - Series, Architectural Series and E-Series windows and doors products and map it to IT requirements.
• Working closely with Product Owner/Scrum team to analyze business requirement and break it down to smaller Product Backlog Items and score it accordingly.
• Developing and testing of product based on Andersen product specifications using rule language, m2o studio software and CenterPoint Paradigm templates. Also leveraging tools like Windows PowerShell ISE, Frog Logic Squish, Cloud Jira, Informatica 10.1.0, Oracle SQL Developer, Bitbucket, InstallShield, XML Spy, Edit Plus, Eclipse, Microsoft SharePoint and Microsoft Team for rapid development.
• Reviewing solution designs with Business and Marketing teams. Also review the work product in each sprint review and get feedback from product owner and all other stakeholders.
• Working on Andersen product deployment activity includes building executable of Intelligent Quote software, user manual and preparing release notes.
• Performing Configuration Management activity by using CVS repository and co-ordination with the team for version control and code maintenance.
• Providing post production support and fixing any production issue with required analysis by following very extensive level of coding standards and code review.
• Implement Software quality processes by practicing defect prevention and other quality management processes to minimize defects & control cost of quality.
• Initiate and maintain client relationships and execute project work plans in the field.
• Performing and Managing ETL (Extract Transform and Load) activity using Informatica for each software release to Integrate data with BAAN ERP System.

Operating Systems

Windows 7/10

Software / Special Tools iQ M2O Studio, Center Point Paradigm Software

Languages

Rul Language, PIN Files, PVC tables, Oracle PL/SQL

Confidential

Programmer/Developer

Responsibilities:

• Silverline iQ & CPQ Catalog Development Project involves in developing electronic product catalogue for Silverline brand in iQ and CPQ tools.
• These tools are used to quote work order for Silverline brand windows and doors.
• CPQ and iQ are being used by all many Silverline dealers and Confidential customers.
• Paradigm and m2o studio are used to design product knowledge.
• Product knowledge is the information regarding different types of doors and windows available including its variety of features and options.
• Developing product catalogue involves capturing various business rules as well as complex manufacturing constraints.
• Meeting with business stake holders/partners to understand the requirements.
• Deliverables planning as per the planned tasks and then break out the developer tasks as per priority set. Do Development, unit testing, regression testing and production release.
• Make environment ready for Customer Acceptance testing.

Operating Systems

Windows 7/10

Software / Special Tools iQ M2O Studio, Center Point Paradigm Software, iCAT

Languages

Rul Language, PVC tables, Oracle PL/SQL

Confidential

Programmer/Developer

Responsibilities:

• Was Closely working with the project team to understand. Involved in Application development and maintenance, database structure of the various applications. Did database performance tuning of stored procedures and triggers, T-Sql design and database indexing. Did Packaging and deployment
• Solution to frequently encountered live issues common business procedures, writing documents.
• Daily status reporting to client IT development manager and the offshore manager and having weekly calls with client and onsite manager.

Operating Systems

Windows 7/10

Languages

VB6, SQL Server 2008, ASP.net