PROFESSIONAL SUMMARY:

• Over15+ years of experience in Digital Marketing, HealthCare,Retail,Customer Care,Telecom,B2B/B2C Portal domains as a Business Analyst and project lead/co - coordinator, manager
• Experience includes Design, Business Re-engineering, Requirement Gathering/Analysis, Internal Control reviews, Testing, Statements, and implementation of Business Applications, IT Operations, Project Team Management using the Systems Development Life Cycle (SDLC).
• Proficient in working with users to gather requirements, analyze them and subsequently use Microsoft Excel, Visio and other design tools to model the requirements.
• Performed feasibility, adaptability study and risk analysis to identify the business critical areas from USER perspective.
• Excellent skills in gathering requirements and creating Business Requirements Document (BRD) and Functional Requirements Document (FRD), facilitating Joint Application Development (JAD) sessions, Rapid Application Development (RAD) sessions, Disaster Recovery Plan (DRP), developing Use Cases, Test Approach, User Acceptance Testing (UAT), and Requirements Traceability Matrix (RTM).
• Proficient in interacting with business users and stake holders to identify information needs and initiating process changes and creating Business Process Modeling, Use Cases, Activity Diagrams, Entity Relationship Diagrams, Sequence Diagrams, Collaboration Diagrams, Class Diagrams, based on UML methodology using tools like Rational Rose and MS Visio.
• Skilled at performing User Acceptance Testing (UAT)
• ITIL V3 Foundation Certified and practitioner in all product implementations.

TECHNICAL SKILLS:

BI/OLAP Tools: Cognos Report studio, Query Studio Cognos 10 BI (Cognos Connection, Framework Manager, Report Studio, Query Studio, Analysis Studio), Business Objects, MS Analysis Services, MS Reporting Services

ETL Tools: MS DTS, Informatica 6.2, SQL Server Integration Services (SSIS)

Programming Languages: SQL, PL/SQL, Visual Basic 6.0

Databases: Oracle 9.0/8i/4.x, SQL SERVER 6.5/7.0/2000/2005

Data Modeling Tools: Erwin

Operating Systems: UNIX, Windows XP/7/10

Case Tolls: MS Visio and ER-Win

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Prepare the overall off shore environment for the SAT
• Prepare the test strategy, test plan for the testing
• Prepare the templates for test cases, test reports and defect metrics
• Participate in the Release meetings along with the Business users
• Client interaction on updates of the testing activities on a weekly basis
• Request data from UAT and PROD server on need basis for SAT testing.
• Preparing the MOMs,weekly progress reports and other documentation related to the project
• Worked onsite and interacted with the business users for requirement gatherings
• Responsible to set up the team to execute the project.
• Guiding the team in testing of developed Cognos cubes,models
• Assisting team in testing/execution of developed workflow

Confidential

Responsibilities:

• Interact with the Clients and On-site coordinator on a regular basis for resolving issues pertaining to the data delivered and special client requests.
• Initial analysis and understanding of Specification documentation and report layouts.
• Synchronizing and offloading catalogs daily from remote server, testing them and adding the joins wherever necessary. Create Calculations and prompts at Folder levels.
• Checking customizing picklists reports and IMS file, Query file, group, filter, prompts, summaries and functions. Templates for reports as per the Client requirements.
• Designed the Report formats and developed reports using Impromptu and Power Play tools. (Used the Catalog and Transformer to generate reports and cubes).
• Testing multiple Impromptu reports like List reports cross-tab reports and sub reports.
• Developing Specification Documents for Reports as per client requirements.

Confidential

Responsibilities:

• Interact with the Clients and On-site coordinator on a regular basis for resolving issues pertaining to the data delivered and special client requests.
• Initial analysis and understanding of Specification documentation and report layouts.
• Synchronizing and offloading catalogs daily from remote server, adding the joins wherever necessary. Create Calculations and prompts at Folder levels.
• Preparing and customizing picklists reports and IMS file, Query file, group, filter, prompts, summaries and functions. Templates for reports as per the Client requirements.
• Creating strategies for hotfiles and picklists, implementing reusable picklists for set of reports.
• Designed the Report formats and developed reports using Impromptu and Power Play tools. (Used the Catalog and Transformer to generate reports and cubes).
• Testing multiple Impromptu reports like List reports cross-tab reports and sub reports.
• Prepare the PDF from IMR files, SAP/access snapshot files, thumbnails and review checklists.

Confidential

Responsibilities:

• Developing Specification Documents for Reports as per client requirements.
• Maintained the catalogs and cubes created.
• Making changes to the prompts and calculations created at folder levels as per the
• Reports required by the top management.
• Generate reports required by the higher management on daily basis using
• Impromptu and powerplay tools.
• Reports include like daily inventory,forecast for the month
• Created Reporter and Explorer reports (cross tab and graphical) covering different types of analysis with drill-down, alerts features.

Confidential, New York

Responsibilities:

• Interaction with the Client.
• Analysis requirements.
• Integration and Installation of the Product.
• Developed Complex reports using Crystal Reports.

Confidential, NewYork

Responsibilities:

• Designed database in MSSQL Server.
• Designed and Implemented Forms in VB6.0
• Database tuning.

Environment: VB6.0, SQL Server 7.0, Visual Studio.NET, Windows 95/98, Windows 2000/ XP