Sam
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Sam as PDF for free.
More details
- Words: 3,197
- Pages: 8
SUMMARY • Multi-skilled, results-driven Information Technology Professional with over 7 years of experience in design, development and implementation of Business Integration Applications, Service Orientated Applications(SOA), Client/Server applications, Web and Windows applications with proficiency in Object-Oriented Analysis and design. • Over 4 yrs of experience in BizTalk 2006 R2, BizTalk 2006, BizTalk 2004, SQL,WSE 3.0, WSE 2.0, FTP, FILE, HTTP, SOAP, CICS, MSMQ Adapters, BAM, Custom pipeline component, Adapter setup and configuration, BizTalk configuration and troubleshooting, BizTalk publishing Wizard • Over 6 years of experience in VS 6, VS .NET (2005,2003,2002), C#, VB, sequence diagrams, Win Forms , API's, RPC, VBScript, Jscript, RDO, ADO, ADO.NET, ASP, ASP.NET, .Net Remoting, IIS 5.x/6.x , Visual Interdev 6.x. • Expertise with Microsoft BizTalk Server technologies like Orchestration, Maps, schemas, pipelines, ports and HAT. • Expertise in writing custom XSL, creating complex schemas, BizTalk deployment using MSBuild. • Expertise in testing using BizUnit and NUnit code coverage using NCover & NcoverExplorer, documentation using BizTalk documenter & BizTalk profiler. • Proficient with all phases of Software Development life Cycle like UML, Use Cases.
• • • • • • • • • • •
Exposure to Windows Workflow Foundation (WWF) Beta technologies like activities. Extensive experience in the Telecommunication, Pay media, financial and HealthCare domains. Expertise in 2-Tier and 3-Tier development architecture. Excellent experience of SQL Server 2005 and 2000 database access through ADO and ADO.NET and Knowledge of DB2 and Oracle 8i. Excellent knowledge of SQL, T-SQL, stored procedures, functions, triggers, SQL jobs, views, joins in SQL Server 2005/2000/7. Expertise in Database Design, Database Programming and Normalization using SQL Server 2005 and 2000. Expert in configuring and designing forms using InfoPath 2003. Hands on experience in using HTML, CSS, JavaScript and XML. Experience in XML related technologies: XML, XPATH, XSLT, DOM and XML Schema. Worked extensively on HTML Controls, Server Controls, User Controls and Web Controls using both C#. NET and VB. Excellent analytical, communication, team and interpersonal skills.
TECHNICAL SKILLSET Languages Web Technologies Scripting languages XML Technologies RDBMS Operating Systems IDE Database Access Technologies Version Control Mainframe Tools
C#, VB.NET, VB6.0, C++, C, Java, VS Cobol ASP.NET 1.1, ASP, Web publishing, BizTalk Publishing Wizard VB Script, Java Script, Perl Script XML, SOAP, WSDL, UDDI, Web Services, WCF, XSD tools, WSDL tools SQL server 2005,SQL Server 2000, SQL Server 7, MS Access, DB2 Windows 2003 (R2)/NT/2000/XP, Linux, Unix, MS DOS Visual Studio 2005, Visual Studio.NET 2003, Visual Studio 6.0, Java SDK ADO.NET, ADO,VSAM, DB2Connect SVN, MS Team Foundation, MS Visual Source Safe(VSS), CVS JCL, VSAM, VS COBOL, CICS, TSO/ISPF
Middle Ware Web Tools Other Tools
BizTalk Server 2006, BizTalk Server 2004, BizTalk Server 2002 Web Service Studio Tool, SOAPUri,WSE3wsdl, WSE3.0 Tracing tool, Info path 2003 SSOConfigStore tool, Wire Shark, NUnit GUI, Tortoise svn, Eclipse
TRAINING
• • • •
BizTalk 2006 and Windows Workflow Foundation internal training. Java 2 training from NIIT (National Institute of Information Technology). IBM authorized Mainframe s/390. Red Hat Linux training.
PROFESSIONAL EXPERIENCE Global Crossing Inc, Rochester, NY Role: BizTalk Developer Project: VOIP Local services
Feb 2008 – Till Date
Description: This project is to process VOIP orders from customers. A BizTalk application processes the VOIP orders. This application is exposed as a Webservice to external client. The application validates order, maps input data to order schema and inserts to database. The trading partner updates the status of order in the database at regular interval. The BizTalk application uses SQL adapter for database connectivity. Responsibilities: • Responsible for analysis, designing, developing the application, creating helper classes, testing, interacting with users, debugging, configuring, database connectivity and deployment. • Actively participated in project meetings and directly reporting to Project manager.
• • • • • • • • • • •
Designed the schemas as per the requirement. Created maps, schemas, orchestrations and ports. Created helper class libraries and customer exception classes. Wrote many stored procedures for this project for data validation, storing message as XML and formatting response. Published the BizTalk application using BizTalk publishing wizard. Used NUnit, BizUnit, Ncover, BizTalk documenter and BizTalk profiler for testing and code coverage. Responsible for creating design document and test cases. Hands on experience in using Tortoise SVN for branching, tagging, merging source codes in source control. Used Bugzilla for bug tracking. Responsible for development, QA and Partner testing
Extensively used SOAP, HTTP,FILE, SQL, Host Application Adapters Environment: C#, ASP.NET, BizTalk 2006 R2, SQL Server 2005, Visual Studio .Net 2005, ADO.NET, DB2Connect, IIS 6.0, HTML, SVN, NUnit, BizUnit, MSBuild, Mainframe, WSDL, XML, Bugzilla, WebserviceStudio tool, log4Net Global Crossing Inc, Rochester, NY Role: BizTalk Developer Project: Number porting Automation
Oct 2006 – Feb 2008
Description: The telephone number porting refers to the ability to transfer either an existing fixed-line or mobile telephone number assigned by a local exchange carrier (LEC) and reassigns it to another carrier. The number porting orders come as a bulk flat file and BizTalk splits that into multiple orders. Each order undergoes portability check and serviceability check before sending to different carriers. This order is then send to the number porting API. BizTalk receives responses from the API asynchronously. This application uses File, SQL, HTTP, SOAP, FTP and CICS adapter. The application uses custom pipeline to log both inbound and outbound messages. The responses are stored in Database using SQL adapter. SMTP adapter is used to send mails, if there are some connectivity issues or exceptions from trading partners. Responsibilities: • Was solely responsible for requirement analysis, design, developing, creating helper classes, unit testing, client interaction, debugging, database and deployment. • Actively participated in client and internal meetings.
• •
Created custom pipeline component for the project.
•
Created several complex orchestrations interacting each other with direct bound or correlation based. Created stored procedure, views, tables and jobs for the project.
•
• • • •
Discovered one bug in BizTalk 2006 and confirmed it with Microsoft. Responsible for connectivity with backend legacy systems.
Used log4net for logging and created custom error handling application to effectively handle BizTalk suspended messages. Used WMI script to control BizTalk instances.
Used Msbuild, BizUnit, Ncover, NcoverExplorer for deployment, testing and code coverage respectively. Environment: C#, ASP.NET, BizTalk 2006 R2, BizTalk 2006, SQL Server 2005, Visual Studio .Net 2005, ADO.NET, Win forms, IIS 6.0, HTML, Java Script, SVN, NUnit, BizUnit, MSBuild, Mainframe, WSDL, XML, Bugzilla, log4Net Interknowlogy, San Diego, CA Role: BizTalk Developer Project: Telenor-Entriq Integration
April 2006 – Oct 2006
Description: Telenor is the incumbent telecommunications company in Norway with operations in Scandinavia, Eastern Europe and Asia. This project was for integrating messages from different business partners. There were hundreds of use cases and message category in the integration. There were FTP, web, SOAP, WSE 3.0, HTTP, File and MTOM messages. WSE 3.0 enhancement is used throughout in this project to secure the messages published as Web services. BizTalk system acts as a middleware and all messages passes through it. It does the validation, security check, construction and transformation of the incoming messages to required output format and finally updates the destination system Database. Middleware sends the response back as response to the caller and logs Soap error to the event viewer or sends a negative acknowledgement. The BizTalk system uses certificates to identify the caller and secure the connection. Responsibilities: • Involved in almost all the aspects of this project and did R&D on WSE3.0 compatibility with BizTalk 2006 and WCF. • Actively participated in design meetings and daily project meetings.
• • • • • • • • • • • • • • • • • • • •
Installed and configured BizTalk and SQL server on the Testing environment. Responsible for creating Msi, Binding files and packaging the application. Helped team members in troubleshooting WSE 3.0 Adapter issues, security Check issue and with messages. Designed forms and configuration using InfoPath 2003. Designed and created orchestrations, schemas, Maps and custom pipelines. Worked extensively on Party Resolution and used certificate along with it. Used MTOM and large file processing with the orchestrations. Used BizTalk WSE 3.0 publishing wizard to public the orchestrations as WSE 3.0 web services. Solely responsible for setting up certificate authority, creating certificates and making policy files for both the client and server side to be used with WSE 3.0 adapter. Created and designed the classes for doing the security check Created stored procedures and scripts for creating the security database. Developed testing suite to test the messages at the testing environment. Responsible for unit testing inbound and outbound messages Designed and developed many Web services to be used in orchestrations. Used extensively adapters like WSE 3.0, WSE 2.0, File, FTP and SOAP in this project. Used Share Point for Project site along with TFS. Worked some time with Windows workflow Foundation (WWF) to design the data aggregation part. Familiar with configuring and running Web services and FTP web sites in IIS 6.0. Hands on experience in creating and updating tasks in TFS and VSS.
Experience with using Application blocks especially Exception Handling, Data Access and logging. Environment: C#, ASP.NET, MS BizTalk 2006, SQL Server 2005, Visual Studio .Net 2005,WWF, WSE 3.0, ADO.NET, Win forms, IIS 6.0, HTML, Java Script, TFS, VSS, InfoPath 2003. National City Bank, Cleveland, Ohio Role: Sr .NET/BizTalk Developer Project: Gateway Report System
July 2005 – March 2006
Description: Gateway Report System is a part of the National City Corporate intranet application ‘Gateway Intranet’. Through Gateway all the NCC employee & non-employee users can access business information, structured around the concept of communities. BizTalk Server is used to integrate the files coming from different department and to create a unified report. The reports coming from different departments are in different formats like flat file, XML etc. The BizTalk server takes all these files from an input location, converts them to XML, applies the required business transformation on the files and creates a single file. The users send reports using FTP and receive the unified report either by email or from a web service. The transformation rule is specified in the Orchestration. The rule engine is used which helps in changing the rules frequently. Responsibilities: • Designed and developed the report application being used by thousands of users using ASP.NET, BizTalk server, ADO.NET, C#, HTML, IIS 5.0, and JavaScript. • Designed and developed BizTalk MAPS, orchestrations, XSD schemas, XSLT and custom pipelines.
• • • • • • • • •
• • • •
Assigned the Ports for message inflow and outflow with bounding Schemas Created Binding Files for each environment which greatly helped easy deployment to Testing, Staging and Production environments Used File, FTP, SMTP, SOAP, SQL and HTTP Adapters. Installation and configuration of BizTalk Server 2004 was also done on various environments (Development PC, QA and Production server). Client side and Server side validation using Java Script Used ADO.NET connection, command, datasets, data adapter and data reader to retrieve and store the data in SQL Server 2000. Created Stored Procedures and triggers for updating related tables using SQL Server. Created tables, views, indexes and relations using SQL Enterprise Manage Installation of different tools Crystal Reports, VSS Migration of application from development/QA/test environment to production environment. Coding and troubleshooting for development phase of the projects for different communities in gateway. Scheduling and Planning of Application backup (VSS).
Testing of applications (unit testing, integrated testing). Environment: C#, ASP.NET, VB.NET, MS BizTalk 2004, ADO.NET, HTML, IIS 5.0, Java Script, SQL Server , Visual Studio .Net, DOM, VSS. Nationwide Mutual Insurance, Columbus, OH Nov 2004 –June 2005 Role: .NET/BizTalk developer Project: NMI Report Generator Description: It is a part of an Internet application that houses content, functionality and procedures of multiple lines of business into one corporate 'common look and feel' web site. The report generator was the important feature. It picks up the Flat Files or positional Flat file from the Client's FTP Server and converts it into the XML format and applies the Business rules (orchestration) and sends the XML document as a request to Web Services and the response from web service is sent to the respective client via email. There was no direct access to SQL Server; every call has to go through Web Service. Responsibilities: • Worked as Developer and System Analyst • Was responsible for off shore/on site Coordination to tasks, preparing approach document and system specification. • Developed Orchestration for implementing the business rule.
• • • • • • •
Created Maps for connecting schemas
• • • •
Write stored procedures and database packages
•
Developed XSD and XML data structures. Created Binding Files for testing, staging and prod environment. Used the appropriate adapters for particular input file formats. Created various SQL Scripts, joins and SQL Stored Procedures Integration testing before delivering the tasks to client for QA testing. Coding and troubleshooting for development phase of the projects. Design and develop applications using Microsoft technologies Scheduling and Planning of Application backup. Design of the replication process among Company servers Prepared DRP plan for the application
•
Upgraded the system from BizTalk server 2002 to 2004
Environment: C#, ASP.NET, ADO.NET, BizTalk Server 2004, HTML, DHTML, IIS 5.0, Java Script, SQL2000, Visual Studio .Net, VSS GE Quartz, Cleveland, Ohio Role: .NET Developer Project: ASP TO ASP.NET Migration
April 2004 – Oct 2004
Description: GE Quartz has its legacy systems running on JDE and AS-400. The legacy system was not able to cater to new business needs and it became mandatory to migrate some modules to latest platforms for better operation. The new modules were being developed using ASP.NET and SQL Server. Data integration was done using DTS jobs. Responsibilities: • It was migration of JDE modules onto ASP.NET platform
• •
• • • • • • • • • • •
Analyzed and gathered business requirements and system specifications from business analyst, business owners, system owners and operators. Prepared feasibility, scope and efforts document Designed framework of the multi-tier architecture Developed base classes for all the layers so that they all share common platform and functionality with in the group Designed and developed User Management database in SQL Server. Developed a custom control for login interface in ASP.NET Developed DTS jobs to transfer data to and fro from SQL Server and DB2. Implemented ADO.NET as data access technology for SQL Server Wrote Stored Procedure for data acquisition and manipulation in SQL server. Used Excel to generate MIS reports using VBA and ODBC Performed Unit, system and integration testing Documented use and test cases
Developed administration UI for the application Environment: C#, ASP.Net, ADO.NET, MS SQL Server, DTS, T-SQL, Excel, DB2, XML, XSLT, Java Script. Mount Sinai Hospital, NY Role: .Net Developer Project: Patient Care System (PCS)
July 2003 – Feb 2004
Description: Patient Care system (PCS) is a web based documentation deals with creating a patient assignment and identification lists in different areas and it is one of the important applications used by Health Industry. This is an intranet system used by the public relations representatives. This system deals different types of patients like outpatient therapy, mammography, outpatient radiology, inpatient survey and emergency center. The system will retain information on all patient complaints. It will list/capture/store patient comments, personal issues and will be able to lookup patient’s information based on a unique patient ID. Responsibilities: • Worked closely with clients in gathering and analyzing requirements and providing solutions that meet the client’s requirements. • Involved in analyzing and designing of the system.
• • • • • • •
Developed presentation layer Components using ASP.NET. Developed web services for defining patient’s health disorder and treatments or tasks that a care provider performs on behalf of the patient. Implemented various User Controls and Custom Controls in front-end forms Implemented Validation controls to perform both client side and server side validation Developed the New Assemblies by using the C#.NET. ADO.NET was used to access data from SQL Server 2000.
Wrote SQL queries with Joins on multiple tables, Stored Procedures, Functions, Triggers, Backup and Restore Database, Define roles, Create database users and used Data Transformation Services (DTS). • Involved in designing database, SQL queries optimization and performance. • Involved in full lifecycle of the project from design, development & Testing. Environment: C#, ASP.NET, SQL Server 2000, ADO.NET, Web Services, Visual Studio 2003, XML, HTML, JavaScript, MS Visio. Erie Insurance, Erie, PA Role: Application Developer Project: Claims processing system
Nov 2002– May 2003
Description: The project involved development of Client Server application to report, document and process various types of insurance claims. Application provides company representatives with an enhanced Claims model to take first information reports (FIR) through a logical sequence of questionnaire forms derived by looking up policy id’s associated with customer policy numbers, to setup an initial claims work case (CWC). Based upon the type of policy and claim, scripts are generated at the end of the process that is meant to be read verbatim to the claimant. Application provides for seamless CWC processing across multiple claims disciplines. A primary architectural goal was enhanced scalability keeping in tune with an increasingly diverse product range. Responsibilities: • Designed and developed front end using ASP.NET, VBScript
• • • • • •
Designed database tables and implemented data integrity techniques using foreign keys, checks, and triggers Created views and stored procedures involving complex queries viz. joins and cursors. Involved in testing and debugging of the application. Used ADO.NET for database connectivity implementing features like transactions and connection pooling Involved in iterative updates of the technical documentation
Also involved in implementing features like display of various reports, graphs, and charts using Crystal Reports Environment: VB.NET, ASP.NET, ADO.NET, MS SQL Server 2000, DTS, XML, VB Script, Java Script, Crystal Reports 8.0, UML, IIS 5.0 GE Water and Process Technologies, Trevose, PA Role: .NET Developer Project: INSIGHT (Development)
Feb 2001 – Oct 2002
Description: Insight was a multi-tier, multi-platform application, which would cater to diversified needs of diversified customers. This application was capable to communicate with Controllers installed at the remote plant locations. Data was collected on minute frequency from various
location and analysis reports were sent out to Customers and GE representatives serving those customers. Inputs were collected via Handheld and were synchronized with Oracle database. The application was critical to production for all the GE customers. ASP was used for web interface. Embedded VC++ was used for Handheld UI. Oracle 8i was used as backend. Oracle Loader was used to upload bulk data to the Oracle database. Excel was used for off-line data collection, bulk data upload and for customized MIS reporting. Responsibilities: • Documented functional specifications by studying the legacy tool.
• •
• •
Extensively worked with Business and System Owners to corner down technical specifications of various modules in the application. Developed UI screens for data entry and on screen reporting. Wrote stored procedures for updating data.
Implemented Visual Source Safe for versioning of documents and source for the whole Project team. • Performed unit, system and integration testing. • Lead a technical feasibility study on MATLAB • Designed and developed data integration module between legacy system, application database and historian database. • Designed Data Layer to talk to Oracle 8i using ADO. • Developed security using cookie based authentication in ASP. Environment: C#, ASP, ADO, VB, Excel, Oracle 8i
• • • • • • • • • • •
Exposure to Windows Workflow Foundation (WWF) Beta technologies like activities. Extensive experience in the Telecommunication, Pay media, financial and HealthCare domains. Expertise in 2-Tier and 3-Tier development architecture. Excellent experience of SQL Server 2005 and 2000 database access through ADO and ADO.NET and Knowledge of DB2 and Oracle 8i. Excellent knowledge of SQL, T-SQL, stored procedures, functions, triggers, SQL jobs, views, joins in SQL Server 2005/2000/7. Expertise in Database Design, Database Programming and Normalization using SQL Server 2005 and 2000. Expert in configuring and designing forms using InfoPath 2003. Hands on experience in using HTML, CSS, JavaScript and XML. Experience in XML related technologies: XML, XPATH, XSLT, DOM and XML Schema. Worked extensively on HTML Controls, Server Controls, User Controls and Web Controls using both C#. NET and VB. Excellent analytical, communication, team and interpersonal skills.
TECHNICAL SKILLSET Languages Web Technologies Scripting languages XML Technologies RDBMS Operating Systems IDE Database Access Technologies Version Control Mainframe Tools
C#, VB.NET, VB6.0, C++, C, Java, VS Cobol ASP.NET 1.1, ASP, Web publishing, BizTalk Publishing Wizard VB Script, Java Script, Perl Script XML, SOAP, WSDL, UDDI, Web Services, WCF, XSD tools, WSDL tools SQL server 2005,SQL Server 2000, SQL Server 7, MS Access, DB2 Windows 2003 (R2)/NT/2000/XP, Linux, Unix, MS DOS Visual Studio 2005, Visual Studio.NET 2003, Visual Studio 6.0, Java SDK ADO.NET, ADO,VSAM, DB2Connect SVN, MS Team Foundation, MS Visual Source Safe(VSS), CVS JCL, VSAM, VS COBOL, CICS, TSO/ISPF
Middle Ware Web Tools Other Tools
BizTalk Server 2006, BizTalk Server 2004, BizTalk Server 2002 Web Service Studio Tool, SOAPUri,WSE3wsdl, WSE3.0 Tracing tool, Info path 2003 SSOConfigStore tool, Wire Shark, NUnit GUI, Tortoise svn, Eclipse
TRAINING
• • • •
BizTalk 2006 and Windows Workflow Foundation internal training. Java 2 training from NIIT (National Institute of Information Technology). IBM authorized Mainframe s/390. Red Hat Linux training.
PROFESSIONAL EXPERIENCE Global Crossing Inc, Rochester, NY Role: BizTalk Developer Project: VOIP Local services
Feb 2008 – Till Date
Description: This project is to process VOIP orders from customers. A BizTalk application processes the VOIP orders. This application is exposed as a Webservice to external client. The application validates order, maps input data to order schema and inserts to database. The trading partner updates the status of order in the database at regular interval. The BizTalk application uses SQL adapter for database connectivity. Responsibilities: • Responsible for analysis, designing, developing the application, creating helper classes, testing, interacting with users, debugging, configuring, database connectivity and deployment. • Actively participated in project meetings and directly reporting to Project manager.
• • • • • • • • • • •
Designed the schemas as per the requirement. Created maps, schemas, orchestrations and ports. Created helper class libraries and customer exception classes. Wrote many stored procedures for this project for data validation, storing message as XML and formatting response. Published the BizTalk application using BizTalk publishing wizard. Used NUnit, BizUnit, Ncover, BizTalk documenter and BizTalk profiler for testing and code coverage. Responsible for creating design document and test cases. Hands on experience in using Tortoise SVN for branching, tagging, merging source codes in source control. Used Bugzilla for bug tracking. Responsible for development, QA and Partner testing
Extensively used SOAP, HTTP,FILE, SQL, Host Application Adapters Environment: C#, ASP.NET, BizTalk 2006 R2, SQL Server 2005, Visual Studio .Net 2005, ADO.NET, DB2Connect, IIS 6.0, HTML, SVN, NUnit, BizUnit, MSBuild, Mainframe, WSDL, XML, Bugzilla, WebserviceStudio tool, log4Net Global Crossing Inc, Rochester, NY Role: BizTalk Developer Project: Number porting Automation
Oct 2006 – Feb 2008
Description: The telephone number porting refers to the ability to transfer either an existing fixed-line or mobile telephone number assigned by a local exchange carrier (LEC) and reassigns it to another carrier. The number porting orders come as a bulk flat file and BizTalk splits that into multiple orders. Each order undergoes portability check and serviceability check before sending to different carriers. This order is then send to the number porting API. BizTalk receives responses from the API asynchronously. This application uses File, SQL, HTTP, SOAP, FTP and CICS adapter. The application uses custom pipeline to log both inbound and outbound messages. The responses are stored in Database using SQL adapter. SMTP adapter is used to send mails, if there are some connectivity issues or exceptions from trading partners. Responsibilities: • Was solely responsible for requirement analysis, design, developing, creating helper classes, unit testing, client interaction, debugging, database and deployment. • Actively participated in client and internal meetings.
• •
Created custom pipeline component for the project.
•
Created several complex orchestrations interacting each other with direct bound or correlation based. Created stored procedure, views, tables and jobs for the project.
•
• • • •
Discovered one bug in BizTalk 2006 and confirmed it with Microsoft. Responsible for connectivity with backend legacy systems.
Used log4net for logging and created custom error handling application to effectively handle BizTalk suspended messages. Used WMI script to control BizTalk instances.
Used Msbuild, BizUnit, Ncover, NcoverExplorer for deployment, testing and code coverage respectively. Environment: C#, ASP.NET, BizTalk 2006 R2, BizTalk 2006, SQL Server 2005, Visual Studio .Net 2005, ADO.NET, Win forms, IIS 6.0, HTML, Java Script, SVN, NUnit, BizUnit, MSBuild, Mainframe, WSDL, XML, Bugzilla, log4Net Interknowlogy, San Diego, CA Role: BizTalk Developer Project: Telenor-Entriq Integration
April 2006 – Oct 2006
Description: Telenor is the incumbent telecommunications company in Norway with operations in Scandinavia, Eastern Europe and Asia. This project was for integrating messages from different business partners. There were hundreds of use cases and message category in the integration. There were FTP, web, SOAP, WSE 3.0, HTTP, File and MTOM messages. WSE 3.0 enhancement is used throughout in this project to secure the messages published as Web services. BizTalk system acts as a middleware and all messages passes through it. It does the validation, security check, construction and transformation of the incoming messages to required output format and finally updates the destination system Database. Middleware sends the response back as response to the caller and logs Soap error to the event viewer or sends a negative acknowledgement. The BizTalk system uses certificates to identify the caller and secure the connection. Responsibilities: • Involved in almost all the aspects of this project and did R&D on WSE3.0 compatibility with BizTalk 2006 and WCF. • Actively participated in design meetings and daily project meetings.
• • • • • • • • • • • • • • • • • • • •
Installed and configured BizTalk and SQL server on the Testing environment. Responsible for creating Msi, Binding files and packaging the application. Helped team members in troubleshooting WSE 3.0 Adapter issues, security Check issue and with messages. Designed forms and configuration using InfoPath 2003. Designed and created orchestrations, schemas, Maps and custom pipelines. Worked extensively on Party Resolution and used certificate along with it. Used MTOM and large file processing with the orchestrations. Used BizTalk WSE 3.0 publishing wizard to public the orchestrations as WSE 3.0 web services. Solely responsible for setting up certificate authority, creating certificates and making policy files for both the client and server side to be used with WSE 3.0 adapter. Created and designed the classes for doing the security check Created stored procedures and scripts for creating the security database. Developed testing suite to test the messages at the testing environment. Responsible for unit testing inbound and outbound messages Designed and developed many Web services to be used in orchestrations. Used extensively adapters like WSE 3.0, WSE 2.0, File, FTP and SOAP in this project. Used Share Point for Project site along with TFS. Worked some time with Windows workflow Foundation (WWF) to design the data aggregation part. Familiar with configuring and running Web services and FTP web sites in IIS 6.0. Hands on experience in creating and updating tasks in TFS and VSS.
Experience with using Application blocks especially Exception Handling, Data Access and logging. Environment: C#, ASP.NET, MS BizTalk 2006, SQL Server 2005, Visual Studio .Net 2005,WWF, WSE 3.0, ADO.NET, Win forms, IIS 6.0, HTML, Java Script, TFS, VSS, InfoPath 2003. National City Bank, Cleveland, Ohio Role: Sr .NET/BizTalk Developer Project: Gateway Report System
July 2005 – March 2006
Description: Gateway Report System is a part of the National City Corporate intranet application ‘Gateway Intranet’. Through Gateway all the NCC employee & non-employee users can access business information, structured around the concept of communities. BizTalk Server is used to integrate the files coming from different department and to create a unified report. The reports coming from different departments are in different formats like flat file, XML etc. The BizTalk server takes all these files from an input location, converts them to XML, applies the required business transformation on the files and creates a single file. The users send reports using FTP and receive the unified report either by email or from a web service. The transformation rule is specified in the Orchestration. The rule engine is used which helps in changing the rules frequently. Responsibilities: • Designed and developed the report application being used by thousands of users using ASP.NET, BizTalk server, ADO.NET, C#, HTML, IIS 5.0, and JavaScript. • Designed and developed BizTalk MAPS, orchestrations, XSD schemas, XSLT and custom pipelines.
• • • • • • • • •
• • • •
Assigned the Ports for message inflow and outflow with bounding Schemas Created Binding Files for each environment which greatly helped easy deployment to Testing, Staging and Production environments Used File, FTP, SMTP, SOAP, SQL and HTTP Adapters. Installation and configuration of BizTalk Server 2004 was also done on various environments (Development PC, QA and Production server). Client side and Server side validation using Java Script Used ADO.NET connection, command, datasets, data adapter and data reader to retrieve and store the data in SQL Server 2000. Created Stored Procedures and triggers for updating related tables using SQL Server. Created tables, views, indexes and relations using SQL Enterprise Manage Installation of different tools Crystal Reports, VSS Migration of application from development/QA/test environment to production environment. Coding and troubleshooting for development phase of the projects for different communities in gateway. Scheduling and Planning of Application backup (VSS).
Testing of applications (unit testing, integrated testing). Environment: C#, ASP.NET, VB.NET, MS BizTalk 2004, ADO.NET, HTML, IIS 5.0, Java Script, SQL Server , Visual Studio .Net, DOM, VSS. Nationwide Mutual Insurance, Columbus, OH Nov 2004 –June 2005 Role: .NET/BizTalk developer Project: NMI Report Generator Description: It is a part of an Internet application that houses content, functionality and procedures of multiple lines of business into one corporate 'common look and feel' web site. The report generator was the important feature. It picks up the Flat Files or positional Flat file from the Client's FTP Server and converts it into the XML format and applies the Business rules (orchestration) and sends the XML document as a request to Web Services and the response from web service is sent to the respective client via email. There was no direct access to SQL Server; every call has to go through Web Service. Responsibilities: • Worked as Developer and System Analyst • Was responsible for off shore/on site Coordination to tasks, preparing approach document and system specification. • Developed Orchestration for implementing the business rule.
• • • • • • •
Created Maps for connecting schemas
• • • •
Write stored procedures and database packages
•
Developed XSD and XML data structures. Created Binding Files for testing, staging and prod environment. Used the appropriate adapters for particular input file formats. Created various SQL Scripts, joins and SQL Stored Procedures Integration testing before delivering the tasks to client for QA testing. Coding and troubleshooting for development phase of the projects. Design and develop applications using Microsoft technologies Scheduling and Planning of Application backup. Design of the replication process among Company servers Prepared DRP plan for the application
•
Upgraded the system from BizTalk server 2002 to 2004
Environment: C#, ASP.NET, ADO.NET, BizTalk Server 2004, HTML, DHTML, IIS 5.0, Java Script, SQL2000, Visual Studio .Net, VSS GE Quartz, Cleveland, Ohio Role: .NET Developer Project: ASP TO ASP.NET Migration
April 2004 – Oct 2004
Description: GE Quartz has its legacy systems running on JDE and AS-400. The legacy system was not able to cater to new business needs and it became mandatory to migrate some modules to latest platforms for better operation. The new modules were being developed using ASP.NET and SQL Server. Data integration was done using DTS jobs. Responsibilities: • It was migration of JDE modules onto ASP.NET platform
• •
• • • • • • • • • • •
Analyzed and gathered business requirements and system specifications from business analyst, business owners, system owners and operators. Prepared feasibility, scope and efforts document Designed framework of the multi-tier architecture Developed base classes for all the layers so that they all share common platform and functionality with in the group Designed and developed User Management database in SQL Server. Developed a custom control for login interface in ASP.NET Developed DTS jobs to transfer data to and fro from SQL Server and DB2. Implemented ADO.NET as data access technology for SQL Server Wrote Stored Procedure for data acquisition and manipulation in SQL server. Used Excel to generate MIS reports using VBA and ODBC Performed Unit, system and integration testing Documented use and test cases
Developed administration UI for the application Environment: C#, ASP.Net, ADO.NET, MS SQL Server, DTS, T-SQL, Excel, DB2, XML, XSLT, Java Script. Mount Sinai Hospital, NY Role: .Net Developer Project: Patient Care System (PCS)
July 2003 – Feb 2004
Description: Patient Care system (PCS) is a web based documentation deals with creating a patient assignment and identification lists in different areas and it is one of the important applications used by Health Industry. This is an intranet system used by the public relations representatives. This system deals different types of patients like outpatient therapy, mammography, outpatient radiology, inpatient survey and emergency center. The system will retain information on all patient complaints. It will list/capture/store patient comments, personal issues and will be able to lookup patient’s information based on a unique patient ID. Responsibilities: • Worked closely with clients in gathering and analyzing requirements and providing solutions that meet the client’s requirements. • Involved in analyzing and designing of the system.
• • • • • • •
Developed presentation layer Components using ASP.NET. Developed web services for defining patient’s health disorder and treatments or tasks that a care provider performs on behalf of the patient. Implemented various User Controls and Custom Controls in front-end forms Implemented Validation controls to perform both client side and server side validation Developed the New Assemblies by using the C#.NET. ADO.NET was used to access data from SQL Server 2000.
Wrote SQL queries with Joins on multiple tables, Stored Procedures, Functions, Triggers, Backup and Restore Database, Define roles, Create database users and used Data Transformation Services (DTS). • Involved in designing database, SQL queries optimization and performance. • Involved in full lifecycle of the project from design, development & Testing. Environment: C#, ASP.NET, SQL Server 2000, ADO.NET, Web Services, Visual Studio 2003, XML, HTML, JavaScript, MS Visio. Erie Insurance, Erie, PA Role: Application Developer Project: Claims processing system
Nov 2002– May 2003
Description: The project involved development of Client Server application to report, document and process various types of insurance claims. Application provides company representatives with an enhanced Claims model to take first information reports (FIR) through a logical sequence of questionnaire forms derived by looking up policy id’s associated with customer policy numbers, to setup an initial claims work case (CWC). Based upon the type of policy and claim, scripts are generated at the end of the process that is meant to be read verbatim to the claimant. Application provides for seamless CWC processing across multiple claims disciplines. A primary architectural goal was enhanced scalability keeping in tune with an increasingly diverse product range. Responsibilities: • Designed and developed front end using ASP.NET, VBScript
• • • • • •
Designed database tables and implemented data integrity techniques using foreign keys, checks, and triggers Created views and stored procedures involving complex queries viz. joins and cursors. Involved in testing and debugging of the application. Used ADO.NET for database connectivity implementing features like transactions and connection pooling Involved in iterative updates of the technical documentation
Also involved in implementing features like display of various reports, graphs, and charts using Crystal Reports Environment: VB.NET, ASP.NET, ADO.NET, MS SQL Server 2000, DTS, XML, VB Script, Java Script, Crystal Reports 8.0, UML, IIS 5.0 GE Water and Process Technologies, Trevose, PA Role: .NET Developer Project: INSIGHT (Development)
Feb 2001 – Oct 2002
Description: Insight was a multi-tier, multi-platform application, which would cater to diversified needs of diversified customers. This application was capable to communicate with Controllers installed at the remote plant locations. Data was collected on minute frequency from various
location and analysis reports were sent out to Customers and GE representatives serving those customers. Inputs were collected via Handheld and were synchronized with Oracle database. The application was critical to production for all the GE customers. ASP was used for web interface. Embedded VC++ was used for Handheld UI. Oracle 8i was used as backend. Oracle Loader was used to upload bulk data to the Oracle database. Excel was used for off-line data collection, bulk data upload and for customized MIS reporting. Responsibilities: • Documented functional specifications by studying the legacy tool.
• •
• •
Extensively worked with Business and System Owners to corner down technical specifications of various modules in the application. Developed UI screens for data entry and on screen reporting. Wrote stored procedures for updating data.
Implemented Visual Source Safe for versioning of documents and source for the whole Project team. • Performed unit, system and integration testing. • Lead a technical feasibility study on MATLAB • Designed and developed data integration module between legacy system, application database and historian database. • Designed Data Layer to talk to Oracle 8i using ADO. • Developed security using cookie based authentication in ASP. Environment: C#, ASP, ADO, VB, Excel, Oracle 8i
