PROFESSIONAL SUMMARY

• Technical Business Analyst with over 6 years of IT Experience in System Analysis, Software Requirement Analysis, Process Modeling, Process Flow, Data Modeling, Quality Assurance, as well as J2EE Development and Cognos BI Reports.
• Strong Experience in Enterprise System Interface and Integration analysis with good knowledge of SQL, PL/SQL, XML, XSD, XSLT, COGNOS and J2EE programming concepts as well as ESB software like Web Sphere Message Broker and Web Methods Integration server.
• Proficient as long time liaison between business and technology with competence in Full Software Development Life Cycle with Waterfall, Agile, RUP methodology, IT Auditing and SOX Concepts as well as broad cross-functional experiences leveraging multiple frameworks.
• Organized many Joint Application Development (JAD) sessions and Joint Requirement Planning sessions (JRP), walkthroughs, interviews, workshops and Rapid Application Development (RAD) sessions with end-users/clients/stake holders and the IT group.
• Design and review of various documents including the Software Requirement Specifications (SRS), Business Requirement Documents (BRD), Technical Requirement Documents (TRD), Use Case Specifications, Functional Specifications (FSD), System Design Specifications (SDS), Requirement Traceability Matrix (RTM) Reporting and Testing documents.
• Expertise in creating UML based Modeling views like Activity/ Use Case/Data Flow/Business Flow /Navigational Flow/Wire Frame diagrams using Rational Products & MS Visio.
• Successful as a team player to work in conjunction with SME’s, Business Analysts, Developers, DBA’s, Data modeler’s and QA team at various levels for System Interface and Integration as well as reporting issues throughout the software development life cycle.
• Extensively worked with the On-site and Off-shore Quality Assurance Groups by assisting the QA team to perform Black Box /GUI testing/ Functionality /Regression /System /Unit/Stress /Performance/ UAT\'s.
• Facilitated change management across entire process from project conceptualization to testing through project delivery, Software Development & Implementation Management in diverse business & technical environments with demonstrated leadership abilities.

EDUCATION & CERTIFICATIONS

Master of Computer Applications (MCA)  
IBM Certified Designer - Cognos 10 BI Reports.
Oracle SQL Fundamentals 11g Certified.
Sun Certified Java Programmer 1.4.

TECHNICAL SKILLS

Documentation Tools-

UML, MS Office (Word, Excel, Power Point, Project), MS Visio, ERwin

SDLC Methodologies-

Waterfall, Iterative, Rational Unified Process (RUP), Spiral, Agile

Modeling Tools-

UML, MS Visio, ERwin, Cognos Framework Manager, Map Force, XML Spy

Reporting Tools

Cognos Suite, Crystal Reports, MS Office Suite

QA Tools-

Center, Test Director, Win & Load Runner, QTP, Bugzilla, JIRA, Rational Clear Quest

Languages

SQL, PL/SQL, XML, XSD, XSLT, HTML, Java Script, J2EE, VB script

Databases & Tools-

MS SQL Server, Oracle 11g, DB2, MS Access, SQL Plus, SQL Developer and Toad

Operating Systems-

Windows 2000/XP/2007, Linux, AIX

Version Control-

CVS, Rational Clear Case, Visual Source Safe

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey Jan 2010-Till Date 
Technical Business Analyst and Test Analyst
Project Profile 1: Athena
Athena project is an integration project which mainly deals with the sales alignment interfaces needed to deploy the GEMS (Global Professional Education Management System/Siebel Advantis+) platform to the Depuy Operating Companies – Mitek, Spine, Orthopedics and Codman. The main categories of sales alignment data that are included in this project are: Sales Roster , Sales Organization (Territory/Region managed) structure, Customer Information (Accounts/Customer/Hospital where they sell Depuy product(s) and Customer Cross Reference (Account/Customer/Hospital to territory link).

Project Profile 2: Synygy Phase 1 & 2
Synygy is an integration project about developing various interfaces to feed sales alignment structure for Sales Incentive Compensation Management. J&J has various Depuy Operating Companies like Spine, Ortho, Mitek and Codman utilizing ERP systems JD Edwards and PRMS, SAP system called GHRT as source of sales employee data and Siperian MDM for Customer and Product Master Data.

Project Profile 3: Business Reliability Dashboard
Business Reliability Dashboard is a Cognos BI Tool on iPad and desktops, build for J&J Sales Forecasting Management. The dashboard consists of various active reports like Reliability Landing Page, Forecast Accuracy, Supplier Delivery Performance, Supplier First Pass Yield, Schedule Attainment and Heatmaps.

Environment: WebMethods Integration Server, JD Edwards, PRMS, GHRT, Siperian MDM, Siebel Advantis +, Oracle11g, AS400, XML, Web Services, SFTP, Cognos 10 Report Studio, Framework Manager, SQL server.

Responsibilities:

• Responsible for Analyzing and Documenting the Functional Requirement, Business Requirement and Interfaces Design for SYNYGY and ATHENA projects.
• Played an active role in the System Integration effort of legacy ERP systems Siperian (MDM), JDEdwards, Ortho (PRMS), GHRT and JJEDS systems with SYNYGY Sales Compensations System and Athena CRM system utilizing Web Methods Integration server as ESB.
• Participated in Technical Design meetings with Web Methods Integration team , ERP technical teams and CRM technical teams to ensure the appropriate File Formatting and Transfer Protocols are established for data transfer and data migration for designing the interfaces.
• Conducted multiple JAD session with Technical, Business and Functional teams to define and review the functional and technical specifications.
• Responsible for functional design for the interfaces like Employee, Customer Master, Customer Cross Reference, Sales Structure and ensured FSD’s are reviewed and signed off by the project stake holders.
• Owned and maintained the Data Dictionary for all the Interfaces. These Data Dictionaries depict the relationship between upstream systems and the corresponding database table & column details, Data Transport File Format details, ESB transformation details and downstream systems along with corresponding database table and column details.
• Used Altova XML Spy and Map Force tools to generate the XSLT by graphical mapping of upstream and downstream system XSD files, to generate sample xml data, validating the xml files and troubleshooting ESB transformation issues during SIT.
• Worked with the onsite and offshore BA, QA and ESB Development teams to review functional and technical specifications. Responsible for reviewing and signing off the Test Specs.
• Interacted with the QA team and involved in End to End testing of the interfaces with various scenarios to make sure that the Interface Integration is complete and accurate for different kind of data and protocols (tab/pipe delimited, positional, xml data via SOAP, SFTP, HTTP protocols).
• Participated in defect triage calls to validate and assign the defect to the responsible development team and initiate change control process where ever required.
• Liaised with the Sales teams spread globally (USA, Europe and Asia) to collect Cognos Active Report Dashboard requirements for iPad.
• Analyzed existing Excel pivot tables and reports to migrate to Cognos Active Reports Dashboard.
• Developed Active Reports and implemented the interactive behavior for both Desktop and iPad.
• Responsible for Scheduling, Bursting and Testing the dashboard reports on iPad and migrating from development to production environments.

Confidential, New York (Jun 2007- Dec 2009)
System Analyst and Cognos BI Analyst
Description:-
Confidential offers comprehensive commercial property and casualty insurance products to large and middle-market companies in a variety of industries. CONFIDENTIAL has Personal Lines, Business/Commercial Lines and Bonds as different Line of Businesses. CONFIDENTIAL processes new policies renew old policies and they also process claims for their customers. Risk and Fraud Detection and Prevention Systems are mandatory in the business. System Integration is a huge challenge with many new systems developed to improve the business efficiency and processing.

CONFIDENTIAL Data marts built from the Data warehouse which contains historical as well the current data. Reports are built utilizing data marts for the business user analysis and business reporting needs. CONFIDENTIAL has BI reporting needs for various services like Underwriting and Claims Overview report, The Modes Of Transport Analysis report, The Underwriting Policy Type Analysis by State report, The Budget Analysis/Losses Paid report, The Claims Exceeding Premiums by MOT report, The Regional Analysis report, Loss Control and Damage Prevention, Supply Chain – Risk Analysis, Risk Monitoring, Fraud Detection and Prevention Reporting thru BiFMS.

Environment: WebSphere Message Broker, XML, XSLT, Web services, ERwin, ILOG, Cognos 8.3/8.4(Cognos Connection, Framework Manager, Report Studio, Analysis Studio) XML, HTML, JavaScript, SQL, PL/SQL, 
Oracle 9i.

Responsibilities:

• Extensively involved in working with global business user base to analyze the business systems and documented System Integration and Reporting Requirements.
• Owned and maintained the service invocation matrix and Data dictionary for System Integration and Reporting.
• Involved in understanding and implementing the regulatory requirements and business rules in ILOG.
• Participated in numerous peer reviews of Business and Functional Requirement Specifications and System Interface Specifications.
• Worked with onsite and offshore Development and QA teams to ensure the requirements are implemented as per specifications.
• Involved in XSLT development for WebSphere Message Broker implementation of various interfaces to transform client XML’s to vendor service XML’s and vice versa for Web Services Integration project.
• Utilized ERwin and Cognos Framework Manager for metadata modeling creation and published packages to the Cognos connection.
• Developed various list reports, Crosstab reports, Chart reports and various Drill-Through reports utilizing Cognos suite of products.
• Created various reports which have filters, multiple prompts, cascading prompts, multiple pages and conditional variables using master-detail relationship.
• Implemented different functionalities like dynamic sorting, Unions, Joins, multiple queries and conditional blocks.
• Used HTML and JavaScript to enhance the functionality of the reports to make user friendly and interactive reports for the end user.
• Created dashboard-style reports combining list, cross-tabular, map and chart displays to give executives an at-a-glance look at the critical information needed for the successful operation of the business.
• Manually modified the SQL in Report Studio to tune and/or to write reports.
• Troubleshooting report development issues by querying the report source data directly using database tools and communicate those issues to data modelers for verification/resolution.
• Coordinating with Software Testers and Release Management to integrate the final work product into the production environment and transition the maintenance of the report to operational staff.
• Scheduled various reports to run on a daily, weekly and monthly basis using Cognos connection scheduler.

Confidential, New York (Jul 2006-May 2007) 
J2EE Developer
Description:-

POS is the Point of Sales System which deals with the Loan Application uploaded by Loan officer thru the Loan Application Processing Life Cycle. This System interfaces with various services like Loan Application import, Credit reporting, Automated Underwriting and Manual Underwriting etc using SOAP web services. The System contains various user modules like Loan Borrower Management, Loan Registrations, Loan Fulfillment, Under Writing and Funding.

Environment: SOAP, XML, XML Beans, Hibernate, WebSphere5.0, RAD, J2EE 1.2, Oracle 9i, TOAD, Win CVS, Crystal Reports.

Responsibilities:

• Responsible for UI layer development of Borrower and Underwriting management modules utilizing the UI framework, JSP, Java, Java Script and Hibernate Value Objects.
• Involved in Development of Loan Import, Credit Reporting and various other interfaces utilizing Hibernate mapping and Apache XML beans Technologies for importing XML based SOAP messages between various interfaces and services.
• Developed and Integrated Crystal Reports thru JSP into Web Application.
• Developed and Tested Application extensively using Rational Application Developer.
• Developed Unit test case suite using JUnit Tool Kit.
• Involved in System Testing Life Cycle and Production support.