Sql Server Project
Resume:
KRISHNA PERICHERLA
SUMMARY PROFILE
•Over ** year’s experience in Analysis, Development, Design and Managing computer applications.
•Over 7 year’s experience building simple to complex business processes using Opentext MBPM(formerly Metastorm BPM and e-work) Suite.
•Experience building n-tier applications in .NET framework, C#, ASP.NET.
•Experience working with simple to complex databases using SQL Server 2000/2005/2008/2012 and Oracle 10i.
•Experience building reporting packages using Crystal Reports and SSRS 2000/2005.
•Involved in complete testing life cycle such as preparing and implementation of test cases for Unit, Integration testing.
•Strong domain knowledge in developing forms in Aderant CMS, Thomson Elite and solutions for law firms.
•Flexible, self-reliant, tendency of taking Initiation, Innovative & creative.
•Strong analytical skills, organizational and coordination skills.
•Analyzing the existing system, Identification of user requirements, Gap analysis.
TECHNICAL SKILLS SUMMARY
BPM Tools: Opentext MBPM 9.3/9.1(formerly Metastorm BPM 7.6/7.5/7.0, Metastorm E-work 6.6),Opentext Cordys
Software: Visual Studio.Net, ASP.NET, C#, VB.NET, Visual Studio 6.0, HTML, CSS, Javascript, VBScript, WSH, XML, XSL, XSLT, VML, SQL, T-SQL, xCelsius 4.0, UML, COM, ODBC, OLE DB & ADO, ADO.NET, Microsoft Office, Visual Source Safe, Visual Source Offsite, Source Depot, MS Project 2000, Crystal Reports, SQL Reporting Services.
Databases: SQL Server 2000/2005/2008/2012, ORACLE 11i, PL/SQL, MS-Access
Others: HIPAA and COBRA Acts, Wireless Communication, CMMI Practices, Aderant CMS, Thomson Elite.
CERTIFICATIONS
Microsoft Certified Professional
•Developing and Implementing Web Applications with Microsoft Visual C#.net and Visual Studio.net
•Developing XML Web Services and Server components with Microsoft Visual C#.net and Microsoft .net Framework
•Installing, Configuring and Administering Microsoft SQL Server 2000 Enterprise Edition
CAREER EXPERIENCE
Project: Manage Compliant Process, Life Health and Mutual Fund Referral Process, Admin forms
(Metastorm – Opentext MBPM V9.3 Upgrade)
Client: State Farm
October 14 – Current
Role: Sr. Project Manager/ BPM Architect
Environment: Opentext MBPM 9.3, Metastorm BPM 7.6, Microsoft Visual Studio. Net, C#, ASP.NET, Web Services, XML, XSLT, SQL Server, TFS, Microsoft Project
Contribution:
•Gather requirements from the 7.6 process and design forms/ process using Opentext MBPM V 9.3 designer.
•Design Business objects for data presentation in MBPM designer
•Co-ordinate with SQL DBA and design function/stored procedure required for both the processes.
•Design methods in C# for integration to e.CaseTrack system.
•Design visual scripts for Role manipulation and assign functions to validate dynamic actions.
•Design client scripts for validation and manipulating data.
•Design client script for integration with Filesite to retrieve documents.
•Design and integrate Mail library for tracking emails and create audit history for emails.
•Design admin forms for assigning users and roles.
•Design admin forms for Mail configuration and DSN configuration.
•Involved in Unit testing and fix issues assigned by the UAT team.
•Involved in training business users and document required features with screen captures for user manual.
Project: Data Archive, Users and Roles, Metastorm – Opentext MBPM V9.3 Upgrade
Client: Amerisource Bergen Corporation
March 14 – October 14
Role: Sr. Project Manager/ BPM Architect
Environment: Opentext MBPM 9.3, Metastorm BPM 7.6, Microsoft Visual Studio. Net, C#, ASP.NET, Web Services, XML, XSLT, SQL Server, TFS, Microsoft Project
Contribution:
•Discussion with team and involved in analysis and design of scripts for Data Archive project.
•Discussion with business to identify key factors for data archival and built SRS document.
•Co-ordinate with SQL development team and involved in building stored procedure and triggers for data archival.
•Design functional and technical specifications document for Users and Roles process.
•Design forms/scripts using process designer for Users and Roles process.
•Generate Views/Stored procedures in SQL Server 2008 for integration with Users and Roles.
•Built Scripts in VB script, Jscript(JQuery) and Jscript.net for validation and integration within Users and Roles process.
•Integrate Header library to display status of each folder in the process.
•Design and Integrate Metastorm library for dynamic roles.
•Design admin forms for Report access to various users
•Involved in post-production support and additional releases.
•Involved in training business users and document required features with screen captures for user manual.
•Analyze various processes and built technical specification document MBPM V 9.3 upgrade project.
•Involved in Analysis and built cost and resource estimate document for Finance team.
•Co-ordinate with Metastorm Technical team for MBPM V 9.3 training and development.
•Co-ordinate with Tech team and built one process in MBPM V 9.3.
Project: BEACON – Compliance processes ( Speaker Bureau, Speaker Program, Speaker Training,Engagement of HCP, Spend Adjustment, Expense processing, Ad Boards, Workshop, Proctorship)
Client: Allergan
December 09 – March 14
Role: Project Lead / Architect
Environment: Metastorm BPM 7.6, Opentext MBPM V 9, Microsoft Visual Studio. Net, C#, ASP.NET, Web Services, XML, XSLT, Oracle 10i, TFS, Microsoft Project
Contribution:
•Discussion with team and built various process maps (Speaker Bureau, Speaker Program, Speaker Training,Engagement of HCP, Spend Adjustment, Expense processing, Ad Boards, Workshop, Proctorship) using Metastorm process designer.
•Design forms/scripts using process designer.
•Create dynamic roles and assign appropriate role access for dynamic action visibility.
•Integration with MDM using web services for retrieving Master information for physicians.
•Generate Queries/Views/Stored procedures in Oracle 10i for required data elements to be displayed in the Metastorm BPM forms.
•Built Scripts in VB script, Jscript and Jscript.net for validation and integration
•Integrate Header library to display status of each folder in the process.
•Design and Integrate Metastorm libraries for Meal Attendees( BACH)
•Design and Integrate Metastorm Process for Expense processing and validation routines.
•Involved in design and development of web service using ASP.NET, C# for third party vendors integration
•Design admin forms for audit and send automated emails to billing manager and P L leaders for notification.
•Involved in post production support and additional releases.
•Involved in training business users and document required features for next phase development consideration.
Project: New Project Intake Process, Approvals Process, Admin Dashboards, List Maintenance Process.
Client: Marsh & McLennan Companies
January 09 – November 09
Role: Project Lead Analyst/ Developer
Environment: Metastorm BPM 7.6, Microsoft Visual Studio. Net, C#, ASP.NET, Web Services, SQL Server 2000, VSS, Microsoft Project, Thomson Elite
Contribution:
•Gather Requirements and build SOW and Project plan.
•Discussion with team and built process map using Metastorm process designer.
•Design forms/scripts using process designer.
•Create dynamic roles and assign appropriate role access for dynamic action visibility.
•Built web services using ASP.NET, C#, SQL SERVER 2000.
•Built Integration with FX Services built by Thomson Elite.
•Generate Queries/Views/Stored procedures in SQL Server 2000 for required data elements to be displayed in the Metastorm BPM forms.
•Built Scripts in VB script, Jscript(JQuery) and Jscript.net for validation and integration to firm’s financial system Thomson Elite.
•Design navigation bar and implement status bar to indicate the status of each item in the header panel.
•Design separate process map for search function and integrate with the main process map.
•Design PDF report of the entire forms.
•Involved in design and development of code using ASP.NET, C# and SQL Server 2000.
•Built test cases and involved in testing.
•Involved in setting SSO setup for authentication to Metastorm. Track and maintain users in Metastorm database.
•Design admin forms for audit and send automated emails to billing manager and P L leaders for notification.
•Initiate and discuss the modifications and changes to the Metastorm BPM procedure and SQL server database scheduled for next release and coordinate with the development team.
•Publish procedure and roll out process globally.
•Involved in post production support and additional releases.
•Involved in training business users and document required features for next phase development consideration.
Project: New Client Matter Intake Process, Approvals Process, Admin Process
Client: K & L Gates (http://klgates.com)
December 07 – November 08
Role: Sr. BPM Architect
Environment: Metastorm BPM 7.6, Microsoft Visual Studio. Net, C#, ASP.NET, Web Services, XML, XSLT, SQL Server 2000, VSS, Microsoft Project, Thomson Elite, BRD SWiFT
Contribution:
•Gather Requirements and build SOW and Project plan.
•Discussions with Client and modified the design and process flow diagram. Design Maps in Metastorm.
•Built web services using ASP.NET, C#, SQL SERVER 2000. Integration with FX Services built by Thomson Elite.
•Generate Queries/Views/Stored procedures in SQL Server 2000 for required data elements to be displayed in the Metastorm BPM forms.
•Built Scripts in VB script, Jscript and Jscript.net for validation and integration to firm’s financial system Thomson Elite.
•Integrate Metastorm BPM with BRDEE Swift tool for advanced key features and API control.
•Design navigation bar and implement status bar to indicate the status of each item in the header panel.
•Design separate process map to handle approvals based on questions answered in the forms.
•Design PDF report of the entire request and email a copy for approver’s reference.
•Involved in design and development of code using ASP.NET, C# and SQL Server 2000.
•Built test cases and involved in testing.
•Design new process for tracking daily Matter Maintenance reports and design scripts to send email to director for verification.
•Initiate and discuss the modifications and changes to the Metastorm BPM procedure and sql server database scheduled for next release and coordinate with the development team.
•Involved in support and maintenance during roll out plan.
•Train developers on various key features in Metastorm, SWiFT and matter intake process.
Project: AMEX Billing Process, Trust Requistion Process, Purchase Order Requests
Client: Goodmans LLP (http://www.goodmans.ca)
October 07 – December 07
Role: Sr. BPM Developer
Environment: Metastorm BPM 7.5, Microsoft Visual Studio. Net, C#, ASP.NET, Web Services, XML, XSLT, SQL Server 2000, VSS, Microsoft Project, Thomson Elite, BRD SWiFT
Contribution:
•Discussions with Client and modified the design and process flow diagram. Design Maps in Metastorm
•Generate Queries/Views/Stored procedures in SQL Server 2000 for required data elements to be displayed in the Metastorm BPM forms.
•Built Scripts in VB script, Jscript and Jscript.net for validation and integration to firm’s financial system Thomson Elite.
•Integrate Metastorm BPM with BRDEE Swift tool for advanced key features and API control.
•Implement advanced features and create grid controls to select/deselect rows.
•Design PDF report of the entire request and email a copy for approver’s reference.
•Involved in design and development of code using ASP.NET, C# and SQL Server 2000.
•Built test cases and involved in testing.
•Provide support and Maintenance for roll out of each process.
•Initiate and discuss the modifications and changes to the Metastorm BPM procedure and SQL Server 2000 database scheduled for next release and coordinate with the development team.
•Set up Webex Sessions and provide technical support
•Train developers on advanced features in Metastorm BPM and BRD SWiFT
Project: New Client Matter Intake Process, Broker Component
Client: Baker & Hostetler (http://bakerlaw.com)
January 07 – September 07
Role: Sr. BPM Developer
Environment: Metastorm BPM 7.0, Microsoft Visual Studio. Net, C#, ASP.NET, Web Services, XML, XSLT, SQL Server 2000, VSS, Microsoft Project, Thomson Elite, BRD SWiFT
Contribution:
•Gather Requirements and build SOW and Project plan.
•Involved in Analysis and design of process flow charts using Metastorm BPM.
•Discussions with Client and modified the design and process flow diagram. Design Maps in Metastorm.
•Involved in design and development of code using ASP.NET, C# and SQL SERVER 2000.
•Built classes and integrate with Thomson Elite using jscript.Net.
•Generate Queries/Views/Stored procedures in SQL Server 2000 for required data elements to be displayed in the Metastorm BPM forms.
•Built scripts in VB script, Jscript and Jscript.net for validation and integration to firm’s financial system Thomson Elite.
•Integrate Metastorm BPM with BRDEE Swift tool for advanced key features and API control.
•Build breadcrumbs and design navigation bar and implement status bar to indicate the status of each item in the header panel.
•Design separate process map in Metastorm to handle approvals based on questions answered in the forms.
•Design PDF report of the entire request and email a copy for approver’s reference.
•Design scripts and built class for integration with Interwoven.
•Built separate process map in Metastorm to handle attachments.
•Built admin forms to move to do list/ watch list items.
•Initiate and discuss the modifications and changes to the Metastorm BPM procedure and SQL Server 2000 database scheduled for next release and coordinate with the development team.
•Involved in support and maintenance during roll out plan.
•Train developers on various key features in Metastorm BPM and new matter intake process.
Project: New Client Matter Intake Process, Matter Status Maintenance Procedure
Client: Baker Donelson (http://bakerdonelson.com)
September 06 – December 06
Role: Sr. BPM Developer
Environment: Metastorm e-work 6.6, Microsoft Visual Studio. Net, C#, ASP.NET, Web Services, XML, XSLT, SQL Server 2000, VSS, Microsoft Project, ADERANT CMS, BRD SWiFT
Contribution:
•Gather Requirements and build SOW and Project plan.
•Manage development team and act as key liaison between the client and team.
•Involved in Analysis and design of process flow charts using Metastorm E-work.
•Discussions with DBA and involved in designing Data model diagrams using Microsoft Visio.
•Discussions with Client and modified the design and process flow diagram. Design E-work Maps.
•Built web services using ASP.NET, C#, SQL SERVER 2000 and integrate with Aderant CMS. Import the web services using Import wizard.
•Generate Queries/Views/Stored procedures in SQL Server 2000 for required data elements to be displayed in the E-work forms.
•Integrate the E-work process and launch Aderant CMS Conflicts module to generate the conflicts reports and attach back to the process.
•Use RaiseFlag control in Metastorm E-work and pass data from CMS to E-work
•Build web services and integrate the E-work process with DM5 – document management system for storing attachments.
•Integrate E-work with BRDEE Swift tool for advanced key features and API control.
•Initiate and schedule Configuration management for the development using Visual SourceSafe. Copy all e-work procedures and maintain releases.
•Initiate and discuss the modifications and changes to the e-work procedure and sql server database scheduled for next release and coordinate with the development team.
•Designed new process in Metastorm E-work to track inactive matters and run a scheduled task to clear data and mark status as inactive. Built controls to send notifications to the Directors.
Project: Reconciliation Report Process
Client: National Bankruptcy Services.com (http://bkcylaw.com)
April 06 – September 06
Role: Business Analyst/ Metastorm Process Architect
Environment: Metastorm e-work 6.6, Microsoft Visual Studio. Net, C#, ASP.NET, Web Services, XML, XSLT, SQL Server 2000, Reporting Services 2000, Crystal xCelsisus 4.0, VSS, Microsoft Project, CMMI Process
Contribution:
•Involved in design, development and implementation of new processes using Metastorm E-work.
•Involved in Analysis and design of process flow charts using Metastorm E-work.
•Generate Queries/Views/Stored procedures in SQL Server 2000 for required data elements to be displayed in the E-work forms.
•Involved in Design and development of code using ASP.NET, C# and SQL server 2000.
•Built reports using Microsoft SQL Server Reporting Services 2000.
•Involved in integrating dash boards with the process map.
•Designed forward looking Dashboards using Business Objects Crystal xCelsius 4.0.
•Involved in post production support.
•Initiate and schedule Configuration management for the development using Visual SourceSafe. Copy all e-work procedures and maintain releases.
•Initiate and maintain Metrics analysis using Microsoft Project and Microsoft Excel.
•Initiate and discuss the modifications and changes to the e-work procedure and sql server database scheduled for next release and coordinate with the development team.
Project: Bankruptcy & Foreclosure System Support
Client: National Bankruptcy Services.com (http://bkcylaw.com)
December 05 – March 06
Role: Project Lead/ Metastorm Process Architect
Environment: Metastorm e-work 6.6, Microsoft Visual Studio. Net, C#, ASP.NET, Web Services, XML, XSLT, SQL Server 2000, Reporting Services 2000, VSS, Microsoft Project, CMMI Process
Contribution:
•Involved in design, development and implementation of new processes using Metastorm E-work.
•Involved in Analysis and design of process flow charts using Metastorm E-work.
•Design Data model diagrams using Microsoft Visio.
•Discussions with Client and modified the design and process flow diagram. Implement Sub processes and global stages.
•Generate Queries/Views/Stored procedures in SQL Server 2000 for required data elements to be displayed in the E-work forms.
•Built test cases and execute End to End testing. Generate report and submit status to the clients.
•Built reports using Microsoft SQL Server Reporting Services 2000 and created a Reporting package.
•Schedule and install new releases based on the modifications to new tech requests placed.
•Schedule Backup/ Restore plan for the SQL server database.
•Manage DSN connections and modify the E-work procedure as and when required.
•Involved in post production support.
•Initiate and schedule Configuration management for the development using Visual SourceSafe. Copy all e-work procedures and maintain releases.
•Initiate and maintain Metrics analysis using Microsoft Project and Microsoft Excel.
•Initiate and discuss the upcoming modifications and changes to the e-work procedure and SQL Server database.
Project: Aderant CMS-KwikTag Imaging Connector
Client: I-nnovate (http://www.i-nnovate.com)
July 05 – November 05
Role: Project Lead/ Sr. Developer
Environment: CMS, Microsoft Visual Studio. Net, C#, ASP.NET, Web Services, XML, XSLT,CSS, SQL Server 2000, Crystal xCelsius 4.0, VSS, Microsoft Project, Basic SummitScript, Docudraft, CMMI Process
Contribution:
•Initiate and Schedule discussions and meetings on a time frame to submit delivery status to the client.
•Involved in Design and Analysis for new CMS Web forms and integration of the web application to the newly built and existing CMS forms.
•Initiate and schedule meetings with Client to discuss the functionality and design of CMS forms.
•Design Flowcharts and Data model diagrams using Microsoft Visio.
•Creation of data access components using Data Dictionary module in CMS. Generate Queries/stored procedures in SQL Server 2000.
•Involved in Development of EXE files for usage in CMS form design to communicate to KWIKTAG Imaging solution using C#.net, SQL Server 2000.
•Built of File opening API module in CMS for Front office.
•Involved in modifying Docudraft formats for changes in design in CMS Prebill, Bill and Collections modules
•Integration and testing CMS Web/Win Forms with Bar code assigning and Image Retrieval from different modules in CMS.
•Involved in integrating the connector with Business Objects Crystal xCelsius for creating Dash board presentations.
•Installation, Deployment and post-production support for the Connector.
•Discussions with Client and End users for enhancements for the connector and refine scope for Phase 2 Connector development.
Contract: Corpus Inc.
Project: FTTP VRU Web Services,
Client: Verizon (http://Verizon.com)
March 05 – June 05
Role: Sr. Developer/ Technical Analyst
Environment: Microsoft Visual Studio. Net, C#, ASP.NET, Web Services, XML, XSLT, CSS, SQL Server 2000, Rational Clearcase
Contribution:
•Design Data model diagrams using Microsoft Visio.
•Design, development and integration of web services for COFEE project using C#.
•Creation of data access components using the ADO.Net objects such as DataSet, DataAdapter, and DataReader.
•Integration and testing of web services with the various client applications.
•Generate sql queries, views and stored procedures in SQL Server 2000 to associate the data access components and data retrieval.
•Deployment and post-production support for COFEE Production and Test SQL Server 2000 databases.
•Publishing and administering the web services through IT WorkBench, which acts as a central repository for Verizon common enterprise services.
•Interacted with end users throughout and after the development period to enhance the benefits of the application.
•Involve in End to End testing, SIT and UAT. Identify and track issues.
Project: COFEE Billing
Client: Verizon (http://Verizon.com)
October 04 – March 05
Role: Sr. Developer/ Technical Analyst
Environment: Microsoft Visual Studio. Net, C#, ASP.NET, XML, XSLT, CSS, SQL Server 2000, MS Access 2000, Reporting Services, DB2.
Contribution:
•Analyze the Bill Inquiry, Adjustments and Voucher Display modules.
•Technical discussions with DBA about the Business model and table attribute changes.
•Technical discussions with Architects about the Business model changes and document the impacts to discuss with client.
•Involved in UI design and coding for Bill Inquiry and Voucher display screens.
•Design, development and implementation of various client-specific as well as general COFEE webservices using C#.NET and ADO.NET
•Creation of data access components using the ADO.Net objects such as DataSet, DataAdapter, and DataReader.
•Identify and document requests for building scripts in back end using SQL Server 2000.
•Created sql queries, and stored procedures using SQL Server 2000.
•Involved in design of Reports using Microsoft Excel, Access, Visio and Project
•Involved in developing unit and integration test plans. Execute the test plan. Build test cases and coordinate System and integration testing
•Version Control using Rational Clearcase.
•Initiate and implement CMMI Processes for the modules and code design.
Contract: iSpace Inc.
Project: System Rewrite
Client: Long Term Care Group (LTCG) Inc. (http://ltcg.com)
February 04 – September 04
Role: Business Analyst/ Functional Lead
Environment: Microsoft Project, Office 2000, Visio, VBA, ASP, Visual Source Safe, VBScript, JavaScript, Crystal reports, XML, XSLT, CSS, SQL server 2000, AS400, MS Access
Contribution:
•Analyze the Business model and develop project plan for implementation and Design of the reporting package for each specific clients.
•Gather Requirements for Application processing, Billing and collections, Coverage Admin, Claims and underwriting modules.
•Design Reports for Application Processing, Billing and Collections, Claims Modules per HIPAA transaction codes.
•Design Reports for specific cases that are dealt with ICD9 codes.
•Design stored procedures and queries to get the user data using SQL Server 2000.
•Discussions with DBA and involved in Data architecture changes.
•Schedule and run datafeeds to load data from MS ACCESS to SQL Server 2000 and AS400 systems.
•Extensive usage of MS ACCESS and MS EXCEL for Reporting. Usage of VBA for building Business logic. Usage of ADO to communicate to the Business layer.
•Generate Test plans. Build test cases and involved in system and Integration testing.
•Use Citrix Metaframe for connection to LTCG Domain to communicate the development process.
•Gather Requirements for specific business reports for Merrill Lynch, MetLife, GE Capital and AIG
•Gather Requirements for specific Data feed generation for Merrill Lynch, MetLife, Calipers, and CAN.
•Involved in coding Data feeds and Reports for AIG, AMGEN, MetLife and Mutual of Omaha.
•Training on HIPAA privacy rules and policies and design HIPAA Compliant solutions.
Project: Data Services – ISR Information System Requests
Client: Long Term Care Group (LTCG) Inc, (http://ltcg.com)
January 01 – January 04
Role: Business Analyst/ Functional Developer
Environment: Microsoft Project, Office 2000, Visio, VBA, ASP, ADO, MTS, COM, Visual Source Safe, VBScript, JavaScript, HTML, CSS, Crystal reports, SQL server 2000, AS400, MS Access
Contribution:
•Analyze ISR and involved in development and fixing issues.
•Track ISR changes and update the Design Document after discussions with client and developers.
•Identify Risks involved and discuss with client, Prioritize and assign the task.
•Involved in Coding and Design of Reports for ISR’s.
•Extensive usage of MS Excel and MS Access for Reporting. Use VBA for building Code logic and designing interface.
•Generate SQL scripts and stored procedures in SQL Server 2000 for data retrieval and involved in designing Access reports.
•Discussions with DBA and involved in Data architecture changes.
•Use of ADO to communicate to SQL Server 2000.
•Schedule and manage User Acceptance Testing.
•Use Citrix Metaframe for connection to LTCG Domain to communicate the development process.
•Maintain Stakeholder involvement plan using MS Word and MS Excel
•Design Metrics Calculation sheet to track the issue priority and developer involvement in a graphical representation using MS Excel.
Project: Data Services
Client: Long Term Care Group (LTCG) Inc. (http://ltcg.com)
January 01 – January 04
Role: Business Analyst/ Developer
Environment: Microsoft Project, Office 2000, Visio, Power point, MS Access, MS Excel, VBA, ASP, ADO, COM, Visual Source Safe, VBScript, JavaScript, Crystal reports, SQL server 2000
Contribution:
•Generate reports for assigned clients using MS Access 2000, MS Excel 2000 and VBA.
•Create ADO components and involve in design to retrieve the data from SQL server production database.
•Manually validate the reports for assigned clients.
•Discussions with client for the file transfer process and identify the issues.
•Package the reports and execute the process.
•Identify risks and communicate to the clients
•Identify and track Issues and numbers on the reports that don’t tally and communicate to the clients.
Contact this candidate