SUMMARY

• 14 years of IT industry experiencein the capacity of Business System Analyst, Technical/Project Lead, Programmer involved in Application Software Design/Development/Testing and Production Support.
• Extensively worked in the varied functional/domain areas like Healthcare/Insurance, Central Reservations system, Retail and Rental POS and inventory management, Property management system, Restaurant and Food service POS and Inventory management(Hospitality), Capital Markets, Medical Devices Manufacturing, Telecom, Online Banking, Home Mortgage, Retail Banking.
• As a SystemAnalyst/Technical/Project Lead, I was able to establish as an effective team builder having strong analytical and interpersonal skills.Demonstrated ability to take up and handle multiple tasks independently withself - motivation and ready to accept new challenges. Good exposure in working with CMM Level 5 companies and contributed in order to fulfill the organization goals.
• Contributed significantly towards gathering business application requirements.
• Captured existing and new System design, Performed gap analysis based on the business requirements.
• Established a Project Life cycle Management (PLM) and Business process management(BPM) process to define the stepping stone for an effect delivery of projects assigned to me in various projects.
• Excellent in innovative and effective way for application designing, coding and testing.
• Good exposure with Project Management skills, Project Plan Estimations, Risk Analysis, Presentation and Interaction skills with end customers.
• Rich and vast exposure in developing client-server applications from end to end making use of PowerBuilder.
• Vast exposure in Mapping and developing ETL from end to end making use of Informatica.Good in Data modeling techniques like star and snowflake schemas using Erwin tool and Power Designer.
• Good knowledge in Oracle Database Administration activities including proficient hands on SQL Scripting, developing Stored Procedures and Database Triggers. Also worked on other RDBMS such as MSSQL Server, Sybase, DB2, Teradata and MS Access.
• Well versed in Unix Shell Scripting, Crystal Reports, Visual Basic, Developer 2000, Java, C, C++ and COBOL.
• Thorough understanding on Object Oriented Analysis and Design concepts and have good experience in developing software systems based on these concepts.
• Contributed in providing corporate level technical trainings as an instructor for the classes of mass group.

TECHNICAL SKILLS

RDBMS: Oracle 8x/9i/10g, Sybase 12.x, DB2, SQL Server 2000/2008, MySQL, MS-Access. Teradata

Operating Systems: UNIX with shell scripts and Windows XP/2000/NT/95/98, AIX, Linux, Red hat

Languages: PowerBuilder 10.5.2/9i/8i/6.5 with Power Build Foundation Classes (PFC), PL/SQL, SQL, C++, C, Developer 2000, Crystal Reports, Java, Pascal, Fortran, COBOL. Visual Basic. VB and ASP .NET 3.0 Framework.

Domain Knowledge: Research and Manufacturing of medical devices, Online Banking, Wireless/Mobile communication, Healthcare, Retail Banking Systems, Hotel Management and Finance Management Systems.

Tools: Informatica 7.x/8.x/9 T-SQL, PL/SQL, TOAD, Visio, Erwin, Eclipse IDE,HTML,Dreamviewer, Rational Rose, Rational Software Architect, SQL Developer, DB Visualizer, Oxygen, XMLSpy, Windchill 9, Cisco Call Studio, Cisco Voice Portal, VCC Desktop application

Configuration Tools: Visual Source Safe, Clear case, Clear quest, StarTeam, PVCS, Sharepoint,TFVC

Others: REST,JSON, XML, XSD, WebServices, SOAP, EAI,Visual studio team foundation server(VSTFS)

Data warehouse: Informatica 7.x, 8.x, Business Objects 5.6, Cognos 6.6, SAP business Objects

PROFESSIONAL EXPERIENCE

Business Systems Analyst

Confidential, MN

Responsibilities:

• Involved in technical design of documents which comprise of implementing this design on brand new IVR or enhance the existing IVR. Extensively involved in review meetings with the business, cross application teams.
• Worked with the srucm master and product owner to create a new userstories/backlogstories and acceptance criteria in agile methodology using a tool called RALLY. Later translate these stories to development/QA team to size.
• Collaborated with Productowners to assist in prioritization and engage Development/QA team in discussions explaining the userstories. Involved in adding all the depenedencies and resolved any issues/roadblocks that arise during the sprint.
• Analyzed the existing current call center self-service applications and enhanced with the new changes based on new business needs.
• Designed a brand new IVR application and coordinated with architect within the IVR and crossapp teams do discuss new design changes. Involved in the creation of complex IVR call flow diagrams using Microsoft visio and changes related to VCC Desktop/Screenpops.
• Involved in defining business rules for all IVR applicatios, GAP analysis and back and forth communication with the business stakeholders, crossapp API’s creation team and outside vendors.
• Worked on middleware requirements termed with various API/Webservice vendos groups like FISL, ApplicationEnablement, FARO and created the DataMapping document that consists of the translations/transformation, handle business rule, datatype, optionality that will align with IVR application and theirbusiness needs.
• Involved in discussion with business team and cross application team on TollFreeNumber, call routing rules where calls will routed to correct customer servce representative(CSR). Designed the solution to identify repeate caller using lightspeed and VCC Desktop and created the Campaigns where frequent callers are identified immediately and route them to CSR.
• Involved in documenting the complex Error handling scenarios when API/Webservice return a results from multiple source system. Parse the error and extract the information from the sourcesystems that were successful and based on caller entered TollFree number and the type of product hat they selected then readback required information and provide a good caller experience .
• Conducting JAD sessions with API Vendor groups to understand the XML/JSON format of data translation/transformation and other required validations in WSDL/WADL and capturing same in data mapping document.
• Worked closely with development team and ensured that all the requirements are handedoff to QA/UAT and provided the constant support to these team whenever any issue has arised.
• Worked proactively and co-ordinated with the backend teams (FACETS, Wex, Fiserv, Cosmos, Etc) and middleware team to ensure that test data have been loaded to successfully test all the testcases. Worked extensively on SOAPUI to ensure webservice reuten the appropriate request and responses. If any issues were found it was immediately esclated to corresponding API teams. Also analysis on the data that was pooled in the bigdata platform.
• Provided constant support during the production issues supporting the production support group(SSMO) in analyzing the issue and resolving them,
• Successfully delivered the quality products while building a new IVR application or enhancing the existing application and data integration throught multiple APIs, received a good appreciations from the team and business stakeholders.

Business Systems Analyst

Confidential, TX

Responsibilities:

• Contributed in discussions with TPWD cross divisional business teams to identify, understand, analyze and document TPWD business requirements along with creation of business flow diagrams and review.
• Involved in numerous Joint Application Development (JAD) session with business stakeholders within the TPWD Texas state agency and Sales channel and came up with new business needs and solutions to a new reservation system that will manage retail and rental, lease concession and Food service program.
• Involved in creation of functional requirements for revenue management, managing cash drawer according to GAAP principles, integration and automated process to sweep bank accounts between Texas parks and State financial accounting system in the capacity of a System Analyst role.
• Involved in discussion and scrutiny of software solutions to meet interfacing capabilities for Reservation, Retail/Rental/Lease concession and Food Services software packages so that all sales are performed as one transaction.
• Created various Microsoft Visio and business flow diagram on centralized reservation system through various sales channel like field, public web (online) and call center.
• Created Ad-hoc reports usings SAP business objects and reporting requirements for canned reports.
• Created business flow diagram for Passes, Retail, Rental, Gift Card, Lease concessions and property management, Restaurant and Food service and their related sales through various channel like field, public web (online) and call center.
• Involved in the documentation of business requirements (RFO) for a Commercial off-the-shelf (COTS) business system solution requiring minimal customization and address all reservations and sales related activities performed via Field for walk-in reservations and registration, Online reservation through public web to customers, in a centralized reservation and Customer Contact Center(Call center) and in parks throughout the state of Texas.
• Involved in discussion and documented requirements for Customer rewards and loyalty program.
• Involved in discussion and documentedrequirements for retail and rental sale and management of inventory of the products and monthly reconciliation reports and related sales reports.
• Involved in discussion and documentedrequirements for Lease concession and property management along with discussion on fee structure and penalties intact with Texas state rule and during period of Fiscal year.
• Involved in discussion and documentedrequirements for manage hotel services (folio); and manage food service operations and inventory of the products and monthly reconciliation reports and related sales reports.
• Held sole responsibility in the discussions and creation of requirements for all applications through all sales channel.
• Involved in several review and re-work process on the requirements and worked with team to get the sign off on the requirements.

Business Systems Consultant

Confidential, TX

Responsibilities:

• Acted as the primary liaison between the client and the Information systems department and also interacted with internal and external clients,to collect functional requirements and business process information for NDC Pricing. Also involved in brainstorming session on Group Purchasing Organization (GPO), New NDC fee schedule for Outpatient facility and Whitepaper creation for Specialty Pharmacy.
• Interacted with business stakeholders and SMEs to gather the business needs for NDC pricing
• Conducted JAD session identifying impacts in various business streams and created the process flow diagram.
• Involved in research,trend analysis, documentation and creation of Whitepaper for specialty drugs.
• Involved in analysis and brainstorming session with business users on Group Purchasing Organizations(GPO)
• Involved in creation of customer requirements document and identified features both functional and non-functional requirements.
• Interacted with business on document reporting needs for technical document.
• Involved in creation of business requirement and technical document and conducted walkthrough with Business stakeholders and other required teams.
• Involved in brainstorming session on architecture design and system impacts.

Sr.System Analyst

Confidential, TX

Responsibilities:

• Prepared technical design document for options price editing module which comprise of screen design, SQL queries for various display grids and various rules and database schema defined.
• Involved in brainstorming session on architecture design and Memory cache design.
• Involved in writing complex sql queries, triggers to retrieve, update and display pricing data,
• Interacted with DBA to define new database table and define new database schema for pricing module.
• Involved in interacting with architect and main memory cache developers to understand data to be sent and received from Memory Cache that are registered to Vendors and Stock Exchanges.
• Interacted with development team to ensure that all details in design are captured and performed system testing. Design included both for Web app and Database.
• Interacted with business users and understood the business needs and created translation and transformation document for FIXML messaging for downstream application.
• Involved in weekly coordination with Business users and Business analyst to ensure are all business needs are met. Interacted with Predict Module developers to clean up the data and understood the tables, data from which downstream systems consume.
• Took initiative to schedule all meeting required for system design and development, design for new schemas and architecture change and new design in User Interface and Memory Cache.
• Prepared high level approach document and conducted walkthrough with Design and Development teams.
• Involved in coordinating with testing team and tracking of defects, fixing defects and tacking it to closure.

Lead Business System Analyst

Confidential, MN

Responsibilities:

• Involved in technical design of documents which comprise of implementing this design on Windchill 9. Extensively involved in business review meetings. Analyzed system requirements required to implement this project on Windchill 9 PLM process.
• Efficiently followed PLM process to design workflow for manufacting documents with review, rework and regulatory flow.
• Analyzed the existing functionality of Winchill system to enhance further application with new MES objects which involves this enhancement using Java and J2EE technologies.
• Interacted with Architects and technical group to define the project security system and workflow process for MES implementation on Windchill 9.
• Designed complex work flow process using Microsoft Visio. Constant interaction with Architect to understand workflow process for Windchill 9 Change Management system.
• Facilitated meetings and coordinated with business, development group and project management group on reviews of the design documents with formal approval and sign off.
• Documented security system by creating various roles and providing access capabilities to roles and groups across various libraries and domains in Windchill System where in this security details get stored in Oracle 10g database.
• Facilitated and coordinated with Enterprise Application Group (EAI) on interfaces and data to be sent in XML format to downstream partners like SAP, TRS, GTMS and MOL.
• Followed GSM and partial agile methodology. Involved in daily scrum.
• Involved in testing the application. Executed test scripts and any discrepancy in approach were notified based on the design needs. Held responsibility for test scripts approvals.

Business System Analyst/Technical Lead

Confidential, MN

Responsibilities:

• Interacted with application BA’s from SWIFT and middle ware application Translation Services to understand technical needs for data translation and transformation for online banking transactions.
• Interacted with business BA to understand BRD requirements and providing inputs on change in requirements to BA’s.
• Understood XML schema structure shared by SWIFT group to translate outbound message MT 103 and MT 202 and inbound message MT 900 and MT 198 and exception handling sent and received through TIBCO EMS queue.
• Created functional Specification document (FSD) for these inbound and outbound messages with the data mapping.
• Involved in JAD session with technical groups, BA and architects from GRP group and different groups, to make the process faster and optimize the system and understand various services. Also discussed to send XML file through MQ communication protocol.
• Interacted with SWIFT 24/7 administrator to understand networking needs for holiday processing and documented same in FSD.
• Created data mapping document to Extract Transform and Load using from source to target. Used Erwin to analyze and update data modeling.
• Stored various project artifacts within TFVC repository.
• Involved in physical and logical database design. Creating database objects and interacted with DBA.

Technical Analyst

Confidential, Richfield, MN

Responsibilities:

• Responsible to gather and understand carrier’s requirements for both prepaid and postpaid mobile activation process for Confidential online and in Store web portals.
• Involved in defining business rules for product catalog displayed on web portals, back and forth communication with the middleware based on the product selection and displaying product specific plans and features.
• Error handling and displaying appropriate error when product specific plans are incorrect and sent to middleware during activation.
• Worked on middleware requirements termed as Carrier Activation Platform(CAP), which receives the data from the application’s client interface and translate into XML format which confront to carrier specific XSD.
• Conducting JAD sessions with carriers to understand XML data structure (XSD), data translation/transformation mechanism and other required validations in XML schema and capturing same in data mapping document. This is necessary since the underlining data transfer between Confidential Mobile applications with Carrier’s systems takes place through Web Services.
• Analysis and categorizing of carrier application responses (basically WebService SOAP Fault handlers) for the client XML data input and document the same.
• Prepared UI interface specification document for frontend users and to understand middleware functionality and carrier requirements. Also documented custom errors required for the application’s client interface validations.
• Responsible to prepare high level UML design documents such as Use case diagrams, Activity diagrams along with documenting business rules involved for these functional flows using Rational Software Architect tool.
• Followedagilemethodology involving in daily Scrums and defining tasks for weekly Sprints.
• Responsible to conduct daily JAD sessions with onsite/offshore development and QA teams to ensure they understand requirements gathered from Carriers.
• Responsible to review and approve Test Cases prepared by QA team.
• Generated reports by writing SQL script and creating Analytics from Teradata.
• Involved in production support activity to analyze any mobile activation business related issues in production system.

Business Analyst/Technical Lead 

Confidential, Eagan, MN

Responsibilities:

• Acted as the primary liaison between the client departments and the Information systems department and interact with internal and external clients, to collect requirements and business process information for online banking application.
• Involved in business meetings, between various technology groups of Wachovia and Confidential, understood the conceptual view and scope of the requirements and documentation.
• Created detailed design document and performed demonstration of the design to various product managers in the enterprise level.
• Created data mapping document and analysis for Informatica PowerCentre ETL process by creating Sources, Targets, Mappings, and Workflows from Wachovia to Wellsfrago source system. Created reports by using Cognos.
• Involved in writing PL/SQL stored procedures and triggers and execution of jobs in pre and post sessions to modify parameter files, prepare data sources
• As lead, interacted with offshore team by delegating requirements, planning, estimating,and co-ordination and successfully completed various projects.
• Prepared development plan to meet the project deadline. Interacted with QA group for Integration/UAT testing & ensured code delivered on time. Made QA understand the business process to meet the requirement.
• Coordinated on release process and Prepared the implementation plan for production release & assigned task for each resource to do what and when, during the release and monitored each activity and ensured that the release was successful for WIP/Non WIP loads.