Solution Architect Resume
Chicago, IL
SUMMARY
- Senior Developer with 15 years of experience in system analysis, architecture, design, development and implementation of web and windows based software and products for Insurance, Enterprise, Travel, Healthcare, and Financial Services domains. Proven capabilities as a successful leader in software development processes & methodologies with an eminent degree of specialization in Agile Methodology.
- Expert level skills and experience in Software Architectures and Microsoft .Net technologies with 12 years of experience on .Net Framework 1.x/2.0/3.5/4, C#, ASP.NET, VB.NET, .Net Remoting, MVC 2/3/4/5, jQuery, WCF and Web API.
- Hands on experience with OOAD, UML, Design Patterns and Application Architectures concepts
- 3 years of experience as a Team Lead for the project like S3, UIS.
- Experience in all the stages of SDLC including Requirements, Analysis, Design, Development, Testing, Implementation, User Training and Support.
- Experience in integration with legacy systems using BizTalk 2004
- Experience on converting Web forms to MVC
- Expert in generating Reports using Crystal Reports and Cognos Reports
- Knowledge on generating reports using SQL Server Reporting Services and RDLC
- 2+ years of experience on working with Salesforce objects.
- 8+ years on Microsoft SQL Server 7.0/2000/2005/2008 , very strong on writing complex database queries, stored procedures, triggers, cursors and functions.
- Experience on converting Client Server Application to Web Application
- Experience on converting ASP application to ASP.NET
- Developed prototypes based on the client requirement
- 4+ years of experience on DB2, developed Stored Procedures, Views, Triggers and MQT
- 3+ years of experience on Oracle 11i
- Experience in ETL processes using SSIS
- Experience in Messaging Framework using MSMQ
- Experience on setting up a Continuous Integration server and build projects using CruiseControl.NET (CCNET)
- Experience in Code reviews, defined coding standards using FxCop
- Possess strong team building skills and competencies need to analyse problems, respond to changing needs
- Experience with ORM like LLBLGen Pro, Entity Framework
- Experience in software development using various Software development methodologies like Agile, Scrum and those confirming to CMMI Level 5 standards.
- Experience in working in onsite/ offshore model and as a Module lead, Team lead and Tech lead
TECHNICAL SKILLS
Programming Language: C#, VB.NET
RDBMS: DB2 9.0,Oracle 11i,SQL Server 2005
.Net Technologies: Asp.Net, WCF, LINQ, ADO.NET, Web API, MVC
JavaScript: jQuery, Ajax, AngularJS, Kendo UI
ORM: LLB LGen Pro, Entity Framework
Reporting Tools: Cognos 8, Crystal Report 11, SSRS
Unit Test: Nunit, MbUnit
ETL Tools: SSIS
Version control tools: MS VSS, TFS
Design Tools: Visio, Sybase Power Designer, Irwin
PROFESSIONAL EXPERIENCE
Confidential, Chicago, IL
Solution Architect
Responsibilities:
- Conduct workshops to review and validate BCG product current technical state
- List out architecture and design understanding of current products focus areas
- List out the findings and improvements opportunities by the architecture/design changes
- Developed the Proof of Concept (POC) for proposed architecture
- Present the initial observation to key stakeholders
- Submitted the formal architecture assessment document
Environment: - C#, Entity Framework 6.0,Visio 2013, Visual Studio .NET 2013, SQL Server 2008 R2, HTML5, NUnit, WCF, MVC 5, Web API, jQuery, AngularJS, Bootstrap, Neo4j 2.2, Rhino Mocks
Confidential, Chicago, IL
Senior Consultant in Development
Responsibilities:
- Provide solutions for invoice re-factorization
- Developed Invoice process re-factorization using uFacts Batch Framework
- Performance monitoring & tuning using various tools ANTS, Fog light and SQL profilers.
- Monitored health of application servers using DynaTrace.
- Designed the Single Page Application Architecture using Angjular JS.
- Developed Membership Billing re-factorization using MVC; Web API and Angular JS to optimize Performance.
- Tuned SQL queries, stored procedures to optimize performance.
- Point of contact for release management using TFS; maintained TFS tasks, deployment tickets, Build notes and Worklist
Environment: - C#, uFacts Batch Framework, Entity Framework 6.0, Visual Studio .NET 2013, SQL Server 2008 R2, Foglight, ANTS, DynaTrace, HP Quality Center, ASP.NET, Bootstrap, Kendo UI,HTML5, NUnit, WCF, MVC 5, Web API, jQuery, AngularJS
Confidential, Boston, MA
Senior Consultant in Development
Responsibilities:
- Developed & Architected the Use Case Claimant Tax Intercept, Treasury Offset Program, IRORA, Claimant Manage Debt, Request Debt Waiver, Establish and Manage Claimant Payment plan on uFacts Framework and MVC
- Developed Batch Process for Medical Security Plan (MSP) like Marketing, Enrolled, Eligible, Deduction Inbound and Outbound in uFacts Framework batch process using C#.
- Conceptualized and developer the various batches for Tax intercept, ACH Credit, Claimant Payment Plan
- Developed and mentored other team members on various correspondence such as Tax Intercept Notice, Payment Plan Default Notice, Payment plan agreement using uFacts Framework correspondence process
- Architected the entire end to end Debit Card Interfaces for Bank of America and Direct deposit interfaces for Sovereign Bank.
- Developed unit tests using MbUnit
Environment: C#, uFacts Framework, LLBLGen Pro, ASP.NET,MVC 4.0, jQuery, Visual Studio .NET 2010, Web Service, SOAP, XML, XSLT, HP Quality Center, Oracle 11g, Microsoft Enterprise Library 5,WCF, Crystal Report 11, MSMQ, LINQ, Filenet, TFS
Confidential Bedford, NH
Senior Consultant in Development
Responsibilities:
- Designed the Application Architecture and developed POC for the application
- Created Technical Design Specifications for Accounts and Brokers and their corresponding Reporting modules.
- Developed the application using ASP.NET, Ajax, VB.NET and C# using Enterprise Library like Data Access Block, Exception Block, Logging Block
- Developed the application using Object Oriented Methodologies and GOF Designing Patterns.
- Involved in VSS set-up configuration to suite the production deliverables
- Have used Soft Artisans Excel Writer to generate reports in excel
- Developed the Dashboard using Ajax and infragistics controls.
- Responsible the deliverables in staging and production.
- Developed Web Service for Account and Broker Modules
- Developed DB2 Stored Procedures, Views, Triggers and Materialized Query Tables for PU
- Developed Unit test using NUnit
- Developed crystal report which pulls data from salesforc.com and published in crystalreport.com
- Upgrade the application to .net 3.5, Enterprise Library 5,Infragistics 10 and Ajax Tool Kit
- Developed reports using Cognos and published in salesforce.com
- Developed reports using SSRS and published in EMIS
- Designed and developed business component using WCF and published on intranet, which is used by other applications like ESTART, EMIS, and AIU.
- Developed MSMQ application to generate on Demand Reports
- Developed MSMQ application for auditing the application usage on each module.
- Done the analysis for ETL processing those data got from Duns & Bradstreet; LexisNexis
- Created SSIS Reusable Packages to import data from Multi formatted Flat files.
Environment: -VB.NET, ASP.NET, Visual Studio .NET 2008, jQuery, Web Service, SOAP, XML, XSLT, DB2 9.0, Ajax using infragistics, Microsoft Enterprise Library 5,WCF, Crystal Report 11, MSMQ, LINQ, Cognos,Sql Server 2008,SSRS,SSIS,Salesforce
Confidential, Bedford, NH
Senior Consultant in Development
Responsibilities:
- Developed Quota management module using ASP.NET, Ajax Extension and VB.NET, using Enterprise Library like Data Access Block, Exception Block, Logging Block
- Developed stored procedure for the complex reports like BERT, Call Reports, Quota Statistics
- Developed Web Service Client to access the Service from the provider LexisNexis
- Rewritten the existing stored procedure to make them improve the performance
- Rewritten the dynamic SQL which was inline in the code into stored procedure using UDF, CTE, Ranking Functions
- Developed POC for the application
- Have used Soft Artisans Excel Writer to generate reports in excel
Environment: -VB.NET, ASP.NET,MVC 2.0, Visual Studio .NET 2005, Web Service, SOAP, XML, XSLT, DB2 9.0, Ajax Extension, Microsoft Enterprise Library 3.0
Confidential, NJ
Sr. Software Specialist / Team Lead
Responsibilities:
- Involved in designing the Architecture for S3 system based on MVC (Model View Controller) and SOA (Service Oriented Architecture) Patterns.
- Involved in Data Modeling & Analysis
- Master Data Management for specific data objects -- like Physician, Sales Rep, Product
- Responsible in designing and coding infrastructure components that were used by the developers using C#.
- Handled a team of 10 Developers and responsible for designing four modules.
- Responsible for tracking the team member assignments and delivery for four modules.
- Developed the Windows Services for S3 Remote Server, S3 Report Distributor
- Created source and target specifications for Import Modules using Biztalk Editor.
- Mapped all the incoming data to S3 application expected format using Biztalk Mapper.
- Responsible for gathering the requirements and clarifications for the modules handled by myself.
- Involved in design and coding of S3Web application using ASP.NET and VB.NET
- Created complex SQL stored procedures, views and user-defined function in Sql Server 2005, and are used in Crystal reports for reporting.
- Designed and developed an application that can design, generate, distribute reports. This is developed on windows forms using C#.
- Have developed complex reports like Variance Audit Report, Reconciliation Report, Detailed Inventory Report, Reach and Frequency Report, Outstanding Order Processing Report, Invalid Call Report.
- Coordinated with the database team to get the database stored procedure and data for the intermediate database between S3 System and External System.
- Conducted Performance Tuning of Queries & Stored Procedures.
- Testing and fixing the bugs as and when required.
Environment: -C#, VB.NET, ASP.NET, Biztalk 2004, IIS, Visual Studio .NET 2005, UML, Visio 2005, Visual Source Safe, FxCop, SQL Server 2005, Crystal reports 11.0,WCF,WebService, SOAP, XML, XSLT,.Net Remoting, LINQ
Confidential
Sr. Systems Analyst / Team Lead
Responsibilities:
- Responsible for designing and coding, allocating and tracking the team member assignments.
- Developed the core components using C#
- Developed widget interface GUI components
- Handled a team of 5 Developers and responsible for designing three modules using Visio 2000.
- Developed the custom control and UIS Web application using ASP.NET and VB.NET
- Interact with business analyst, project manager to facilitate the precise system requirement.
- Going through the clients' requirements and coming up with database design and application architecture.
- Designed the XML structure for the defined data that stored in the database
- Created the SOAP structure that consumed by the Widget which are published as Service
- Have used third party COM components
Environment: -C#, VB.NET, ASP.NET, XML, SOAP, ASP, ADO.NET, Visio 2000, SQL Server 2000, Reporting Services.
Confidential
Programmer Analyst
Responsibilities:
- Involvement in Requirement Gathering and OOAD using Sybase Power Designer 9.0
- Development of Business Layer using C#
- Designed and created tables, views, and stored procedures in SQL Server
- Designed Web parts and web controls that have used in the application
Environment: -SharePoint Portal Server 2003,Sharepoint Services, BizTalk 2004, XML, SOAP, C#, ADO.NET, ASP.NET, SQL Server 2000, Sybase Power Designer 9.0 .
Confidential
Programmer Analyst
Responsibilities:
- Developed XML Web Services that publish online stock quotes, market commentary
- Involved in Design and development of the application
Environment: -XML, SOAP, C#, ADO.NET, ASP.NET, SQL Server 2000
Confidential
Programmer Analyst
Responsibilities:
- Involved in Coding and testing. Extensively used the polymorphism and inheritance capabilities of oops.
- Designed and Developed win forms
Environment: -VB 6.0, SQL Server 2000, Crystal Reports 8
Confidential
Programmer
Responsibilities:
- Involved in development of the application
- Created stored procedures, tables and views
Environment: -ASP 3.0, VB Script, JavaScript, ADO 2.6, SQL Server 2000
Confidential
Programmer
Responsibilities:
- Developed ASP Pages (in VBScript) using MS Visual InterDev
- Developed stored procedures, views, user-defined functions
Environment: -ASP 3.0, VB Script, JavaScript, ADO 2.6, SQL Server 2000
Confidential
Programmer
Responsibilities:
- Designed and developed the application
- Design the application that is more interactive for the user.
- Convert the MS Access query to stored procedures in Sql Server 2000
Environment: -VB 6.0, ASP, JavaScript, VB Script, ADO 2.6, XML, Access 2000,MS SQL 2000
Confidential
Programmer
Responsibilities:
- Developed Financial analysis module
- Involved in development of the application
- Created the applet that shows online ticker stock indexes
- Environment -VB 6.0, ASP, JavaScript, VB Script, ADO 2.6, XML, Microsoft SQL Server 7.0
