Sr. Programmer Analyst/Team Lead
Resume:
Ashutosh Varshney
IT Professional
*.********.********@*****.***
www.linkedin.com/in/ashutosh-varshney
Profile
Experienced and driven IT Professional with over 24 years of proven experience in application development. Well versed in all aspects of the SDLC. Expertise in design and development of object- oriented client/server applications using PowerBuilder, PFC, SQL and more. Experienced in development with .Net, C#, Visual Basic, Visual Basic for Applications, Microsoft Exchange, EWS and many other tools and technologies. Hard-working team player with a strong desire to learn, grow and succeed. Experience
Summary
Expertise in development with PowerBuilder 2017/12.5, PowerBuilder Foundation Classes (PFC), SQL
Expertise in Object Oriented programming and developing base classes for use across multiple applications.
Experienced in SQL Queries, Views, Stored Procedures, Triggers, Cursors.
Experienced in development using .Net, C#, Visual Studio, Exchange Web Services (EWS).
Expertise in Microsoft Exchange Development using VBScript, CDO, CDOEX, CDOWF, ADO.
Experienced in MS Office development using VBA, Outlook, Word and Excel
Familiarity with JavaScript, Python, PHP, HTML, CSS, COBOL, PowerShell.
Experienced in various DBMS like IBM DB2, Sybase, Sybase SQL Anywhere, Microsoft SQL Server.
Highly motivated problem-solver with excellent analytical skills.
Excellent verbal and written communication skills with attention to detail.
Versatile team player with good interpersonal skills. Technical
Skills
Tools/Technologies PowerBuilder 2017/12.5, PowerBuilder Foundation Classes (PFC), Infomaker, PowerDesigner, .Net, Visual Studio, MS Office, Exchange Web Services (EWS), Microsoft Exchange Development, CDO, CDOEX, CDOWF, ADO. Programming
Languages
Powerscript, C#, Visual Basic, VBA, VBScript, JavaScript, Python, PHP, HTML, CSS, COBOL, PowerShell.
Operating Systems MS Windows, MS DOS, UNIX, LINUX. Databases ODBC IBM DB2 Sybase Sybase SQL Anywhere Microsoft SQL Server. Professional
History
Foresters Financial (Formerly First Investors Corp), NJ Sr. Programmer Analyst/Team Lead
Jun 1999 – Present
Responsible for design, development and enhancements for a vast array of applications using various technologies, primarily PowerBuilder and IBM DB2. Also utilized other technologies and tools as required. Led a small team of developers and worked extensively with various IT and business teams to accomplish project goals. Worked extensively with business users from gathering requirements to delivering final product. Was instrumental in developing and implementing companywide change management, procedures, coding and UI standards.
Designed and developed major CRM system for use by sales reps.
Designed and developed a vast array of product and policy illustrations for use by sales reps.
Responsible for developing & maintaining major business/paperwork routing and tracking system.
Designed and developed automated bulk e-mailing process using PowerBuilder, IBM DB2 and MS Outlook.
Designed and developed automated contact syncing process using PowerBuilder, IBM DB2, C# and EWS.
Designed and developed Sales Rep recruitment, onboarding and performance monitoring application.
Responsible for major trade processing application to interface with DTTC along with tracking and confirms.
Designed and developed automated processes to generate customer letters and management reports.
Responsible for implementing Active Directory sign-on across all PowerBuilder applications.
Responsible for designing and implementing application security to ensure compliance with NYDFS.
Designed and developed user auditing application for compliance with company audits.
Designed and developed e-mail moderation, review & archiving solution for compliance with FINRA regulations using Microsoft Exchange & Symantec technologies.
Designed and developed electronic image based, paperwork routing and tracking system.
Designed and developed Customer Screening solution for compliance with various regulations using data from OFAC.
Designed and developed Help-Desk ticket management system using MS Outlook & VBA.
Developed and implemented PowerBuilder coding and UI standards for all company applications.
Responsible for migrating applications to newer versions of PowerBuilder.
Mentored and trained team members in PowerBuilder, PFC, IBM DB2, and C#.
Conducted demo sessions for users and handled various application service calls.
Worked with various outside vendors.
CIGNA, PA
Sr. Systems Analyst
Aug 1998 - May 1999
Designed and developed a support system for major insurance pricing application, using PowerBuilder, Microsoft SQL Server and Erwin.
Responsible for migration of major insurance pricing application from PowerBuilder 5.0 to PowerBuilder 6.5.
Handled various enhancements to major insurance pricing application.
Guided teammates for future direction of product development. Coremedia Systems, Inc. NJ
Systems Analyst/Project Lead
Jan 1997- Aug 1998
Was responsible to build a PowerBuilder development team which was tasked to convert existing Foxpro applications to PowerBuilder.
Primary architect and developer of advertising revenue management system.
Designed and developed base classes which could be used across multiple products.
Actively involved in developing and implementing UI and coding standards, documentation and quality control.
Mentored and trained team members.
Compuflex Systems Ltd. India
Programmer Analyst
Feb 1996 - Jan 1997
Designed and developed financial accounting system for a big construction company.
Involved in maintenance of Personnel Information System.
Actively involved in documentation, quality control & implementation. Education Post Graduate Diploma in Management Studies, University of Bombay, India.
Bachelor of Science, University of Bombay, India. Certifications Fundamentals of Life & Health Insurance (Level 1), Life Office Management Association (LOMA). Achievements Nominated twice for company awards for exceptional service.
Contact this candidate