We provide IT Staff Augmentation Services!

Business Lead And Sql Resume

3.00/5 (Submit Your Rating)

Parsippany, NJ

SUMMARY

  • Over 8+ years of IT experience including 3+ years of webMethods, and 3 years as tech business lead and SQL.
  • Experienced in Analysis, Design, Coding and testing full life cycle applications.
  • Proficient in Unix/Linux Shell Scripting, TCL, Perl, Java Script and VB Script.
  • Experience in development of Testing standards and Entrance/Exit criteria
  • Experience in development of Client Engagement Models
  • Well versed wif the Global delivery model. Executed projects wif teams spread across the US and India.
  • Experience in writing SQL, T - SQL, PL/SQL Packages, Stored procedures, Functions, Triggers, Cursors as per the business needs.
  • Experience in VHDL, RTL coding, MATLAB, C, System on programmable chip (SOC), Altera: Quartus, NIOS II, SOPC builder; Xilinx: ISE tool; Synopsys: DC & IC Complier.
  • Experience in databases like Oracle 10g/9i/8i, MS SQL Server 2005/2000 and DB2
  • Hands-on experience wif Altera Stratix V, Stratix II & Cyclone II Processor.
  • Team player and self-starter wif professional attitude, having good analytical and communication skills.

TECHNICAL SKILLS

Versioning Tools: PVCS Tracker, Serena Team Track, MS Visual Source Safe, CVS, Clear Case, Altera Quartus II, Nios II IDE, SOPC Builder, webMethods, MATLAB, QT SDK, Xilinx ISE, Modelsim, Xpower, Coregen, Synopsys IC Compiler and Design Compiler.

Languages: Java, C, C#, JavaScript, HTML, UML, SQL, XML, XSL, UNIX Shell Script, TCL, Perl, PL/SQL, VHDL, Verilog HDL

Java API: JDBC, Servlets, JSP, Java Mail, Custom Tags, SWING, RMI, CORBA, and EJB.

Databases: Oracle 8i, 9i,10g; SQL Server, MySQL & MS Access 2000

Servers: webMethods Integration server, weblogic 4.0/5.1/6.0, IBM webSphere Application Server 3.0/3.5/4.0.

PROFESSIONAL EXPERIENCE

Confidential, Parsippany, NJ

Business lead and SQL

Responsibilities:

  • Currently working on the 5010 HIPAA upgrade project for Claims Inquiry (276/277), Eligibility Benefit Inquiry (270/271), and Claims Processing (837D) HIPAA Transactions.
  • Is responsible of designing, developing and deploying 267/277, 270/271 Transactions.
  • Installed EDI docTypes and created processing rules for routing the request to processing service in TN.
  • Imported WSDL to create web service descriptor for Claims Inquiry and Eligibility Inquiry web service and generated input/output docTypes
  • Created docTypes for infoSource, inforRecevier, serviceProvider, subscriber and dependent as per HIPAA X12 specifications.
  • Mapped EDI to XML on the request and XML to EDI on the response.
  • Created the PortalInquiry service to except the inquiries by HTTP Post from Confidential Portal.
  • Work on Yale university mass email project to send enrollment and benefit guides to all the Yale members. Completed the project wif agile methodology and deployed to QA and Prod.
  • Created TN Synchronous call service and processing rule to handle Edi envelops and get the response synchronously to the caller.
  • Prepared release and support documents and assisted in Prod deploy of 837D transaction.
  • Worked on Error Handling and logging mechanism. Designed logging sequence for easy flow identification.
  • Created JDBC select adapter to retrieve data from the error Table. Also created utilities to retrieve error codes based on transaction type and error condition.

Environment: webMethods 7.12 Platform (Integration Server 7.1, wMDeveloper, Trading Networks, MWS, JDBC Adapter, webMethods Administrator), EDIINT - X12(270,271,276,277,837), SQL server 2005, SQL, XML, SOAP, WSDL, etc.

Confidential, Naperville, IL

Responsibilities:

  • Involved in requirements gathering/Analyzing and preparing Technical & Functional documentation.
  • Responsible for developing flow services for complex client requirements.
  • Involved in Bug fixing and Enhancement.
  • Involved in END-to-END tests for Inbound and Outbound process.
  • Created Webmethods Integration Security by Connection control restriction on host address and/or connection port and Authentication, Encryption.
  • Involved in creating and installing certificates in order to secure connections using Open SSL and WebMethods.
  • Worked on Adapter Notification, Adapter Service, Debugging flows, Unit testing, and Building the Integration end to end.
  • Monitoring EAI Broker queue for smooth transmission of data.
  • Created Flow services/webServices and generated WSDL’s and created webService connectors using WSDL’s
  • EDI Transactions handled 850,855,860,875 and 876 for X12 and UCS standards.
  • Deployed code to various environments.
  • Created High Level Design documents and conceptual, flow diagrams.
  • Set up Trading Networks to define & manage the complete B2B document exchange.
  • Installing and configuring WebMethods 6.1. Integration Servers and Broker Servers.Configured Trading Networks.
  • Responsible for webMethods internal team support, coordination between onsite & offsite teams - both webMethods& others.
  • Created test cases, gatheird test data, unit tested and documented the Trouble shooting guide. Created run books for offshore.
  • Configured Adapter connections, Adapter Services (including Dynamic & Custom SQL), Triggers, Document Types and Broker Document Types.

Environment: webMethods, Integration Server 6.5, Trading Networks6.5, wMDeveloper, TN console, webMethodsAdministrator,EAI, B2b, Oracle 10g, SQL, XML, SOAP, WSDL, etc.

Confidential

Responsibilities:

  • Created the workflows for automated lead routing, lead escalation, alerts and custom coaching plans.
  • Created various reports (summary reports, matrix reports, pie charts, dashboards) and setup report folders to authenticate users based on their profiles (permissions).
  • Responsible for migrating existing data (Accounts, Contacts, Events and Tasks) from legacy systems to Salesforce.com using data Loader.
  • Packaged and Deployed customizations from Sandbox to other environments using Eclipse.
  • Customized the Dashboards to the track usage for productivity and performance of business centers and their sales teams.
  • Provided the training to internal business users to use the application and develop their own custom reports.

Environment: Salesforce.com platform, Apex Language, Visual Force Pages, Components and Controllers, S-controls, Data Loader, Workflow and Approvals, Reports, Custom Objects, Tabs, Email Services, Security Controls, HTML, JavaScript, Eclipse IDE Plug-in.

Confidential, North Andover, MA

EDA tool, Language and Hardware used: Altera Quartus II, NIOS, SOPC builder, Modelsim, webMethods 7.12 platform (Integration Server 7.12, Trading Networks7.12, wMDeveloper, MQ Adapter, JDBC Adapter, TN console, webMethods Administrator): VHDL, C, Red Hat Enterprise Linux 5: Altera Stratix II FPGA, DDRAM3, FIFO, PCIe - 16, Intel Xeon, Ethernet.

Responsibilities:

  • Created data maping.
  • Created webMethods Integration Security by Connection control restriction on host address and/or connection port and Authentication, Encryption.
  • Involved in Unit testing, integration testing, debugging in hardware and fixing the bugs.
  • Involved in creating and installing certificates in order to secure connections using Open SSL and webMethods.
  • Set up Trading Networks to define & manage the complete B2B document exchange.
  • Installing and configuring webMethods 6.1. Integration Servers and Broker Servers. Configured Trading Networks.
  • Responsible for webMethods internal team support, coordination between onsite & offsite teams - both webMethods & others.
  • Participated in Product requirements, review, design and code review.
  • Testing is performed in modelsim and Altera Stratix II FPGA.

Confidential

Business Analyst & Tech lead

Responsibilities:

  • Analyzing the system and feasibility in the development efforts using the webMethods Enterprise Application Integrator.
  • Involved in implementing Visual Integration that determines event flow, configuring the operations in an adapter using Visual Integrator and developing scripted operations.
  • Understanding the current business process of the system and gathering the requirements for the change of process or for the new process by interacting wif the users.
  • Developed the Functional specification document wif all 'As-Is' Vs. 'To-Be' process maps, use cases and all required UML diagrams.
  • Coordinated wif the development team in developing the system as per the requirements using JDK1.2.2, EJB, JSP, Oracle 8.0.6, Webmethods 4.0.1 and Solaris 2.6.

Environment: Java1.2.2, EJB, JSP, XML, CIDX, AS2, Oracle 8.06, Weblogic6.0, Webmethods 4.0.1, e-Matrix9.0, Win 2000 and Solaris2.6.

Confidential

Tech Lead

Responsibilities:

  • Involved in Systems integration and systems security and other administration tasks like rotation of log files and Guaranteed Delivery.
  • Conducted performance bench marking, tuning and enterprise level configuration for EJB & Weblogic server.
  • Coordinated the development wif the QA, business and the product implementation teams.
  • Developed centralized reusable validation halper, data halper classes and error utility tags to validate the user-entered data and to send the data and appropriate errors back to the same Screen.
  • Developed SQL server scripts to process the input batch files from the external data and to load the Database.
  • Involved in fixing the critical production problems and researching on root cause analysis by coordinating wif related external vendors.

Environment: Visual Studio.Net 2003, C#, ASP.Net 2.0, .Net Framework 2.0, ADO.Net, SQL Server 2000, XML, HTML, IIS, Javascript, Crystal Reports, Windows XP, Test Director, Win Runner, TOAD, MS Excel, MS Access, MS Outlook.

Confidential

Sr.Financial Analyst

Responsibilities:

  • Responsible for all aspects (BBB) related to Booking and Revenue recognition including Forecast and Close cycle
  • Financial analysis and reporting involving analysis of Department’s revenue and various items on the balance sheet following more specific revenue responsibilities
  • Supporting the annual budget and the quarterly commit/flash processes as well as driving the quarterly close financial packages for Revenue
  • Work closely wif Business Management/Operations to manage the supply and Operation Planning Process
  • Reporting, analyzing and interpreting financial and operating data for ad-hoc reports
  • Managed all aspects of backlog validation and reporting including Financial Policy Compliance
  • Support for all Product Business Groups Involved in balance sheet review and reconciliation at Quarter end
  • Analyzed the budgeted figures wif actual and providing detailed variance analysis report for directors review
  • Preparation of Balance Sheet account reconciliation for areas supported
  • Supported various ad-hoc analysis, reporting and process improvements as required.
  • Identifying and managing finance departments needs for process improvement and eliminating inefficient areas those need improvements.
  • Working wif process team to develop new and improved ways of work flow and eliminate redundancies and implemented best possible standardized solution
  • Conducting through analysis and reporting results for process improvement, ad-hoc reporting and regression analysis to support decisions
  • Help document desk procedures for me&W, Revenue, GM, or OPEX as needed
  • Helping and providing support for reorganization of whole transition system and highlighting areas that need to improve.
  • Create a FAQ guide for working in the COP system and trained new hires and interns
  • Conducted meeting wif various groups for new process polices and procedures
  • Consolidated all the Product Groups and provide a detailed file for Operation Controllers review
  • Assisted Operation Controller for small projects as they come up and created a Tiger Team Tracker for all projects being worked

Confidential

Financial Analyst

Responsibilities:

  • Conducting variance analysis and reporting of factors affecting anticipated figures at period close
  • Involved in period end close process and assisting in budgeting and variance analysis
  • Managing purchase order (PO) and reviewing before submitting requests for approval.
  • Using automated accounting system ERP Walker for processing invoices and following up until paid by payable department
  • Helping the Manager Operations for updating, modifying and maintaining Fixed Assets Inventory, Worked on AFEs, CARs documents.
  • Processing the accruals and updating accruals wif payments invoices
  • Creating new vendors filesand setting up their accounts in automated system
  • Working and updating financial records in Walker (Automated System) and generating reports
  • Documenting the payables process flow and training manuals for upcoming hires

Education:

  • Master Degree in Commerce, NU, India.
  • Post Graduate Diploma in Computer Applications, Hyderabad, India

We'd love your feedback!