PROFESSIONAL SUMMARY:

• Over 7 years of IT experience working as Business Analyst/Business Systems Analyst across various lines of business, with experience leading cross - functional teams in the development, documentation and delivery of process innovations driving the attainment of business goals.
• Seek opportunities to transform company practices into fresh, cost-effective solutions leading to more efficient operations.
• Worked closely with various project stakeholders, SMEs, and staff to understand and document business requirements, functional requirements, and design specifications for new applications along with enhancements to the existing applications.
• Researched, created, reviewed, and revised requirements documents and use cases.
• Rendered support to the Project Manager throughout the project’s lifecycle including: development of project scope; collection and documentation of business requirements, preparation of related process documentation, and preparation of change control documentation, and coordination of user acceptance testing.
• Experience in the field of Software Design, Development, Support analyst and Implementation with Proficiency in Oracle and SQL, PL/SQL that includes Complete System Development Life Cycle from Analysis and Design to Implementation.
• Experienced working with various software development lifecycle methodologies such as Rational Unifies process, Agile, (Scrum frame work) and waterfall
• Exceptional analysis skills with an ability to transform the needs of business users and stakeholders into functional / technical requirements.
• Adept at preparing business requirement documents (BRD’s), defining project plans, writing system requirements specifications, and delivering project/status reports.
• Revised business performance metrics in collaboration with IT, which increased transparency on sales key factors
• Proficient with UML (Use Cases, Activity Diagrams, Sequence diagrams, ER diagrams etc.)
• Well versed with Enterprise Data Reconciliation techniques by looking into Master Data, IBM rational software integrated tools for requirements management and analysis use case development, business modeling, and data modeling.
• Lead and worked with teams to examine and solve business problems accurately analyzing the needs of clients and helping them achieve improved quality and value for their Customers.
• Experience in conducting/facilitating JAD sessions with superior Organization and presentation skills.
• Expert at analyzing, designing, and reengineering systems applications and business processes.
• Excellent written and Oral Communication skills with a results-oriented attitude.
• Experience in management of requirements throughout the Software Development Life Cycle (SDLC).
• Have experience on security setup using Active directory integration. Workflow tools and techniques.
• Familiar with MS Project to manage schedules, deadlines, resources, collaborate with different teams, and analyze project information.
• Possess reasonable understanding of different relational databases, writing simple SQL queries, creating tables, and generating scripts.
• Familiar with some testing tools to design and develop test plans and test scripts and good at quickly learning technologies and systems that are organization/project specific.
• Experience in new process technology implementation and, and conducting system and user acceptance test.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring complex business logics and detail-level data analysis.
• Worked with query tools like Toad, SQL*Plus, SQL Developer.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Worked on Wiki documents and have written technical documents for ESL
• Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting between various applications.
• Excellent analytical and interpersonal skills, oral and written communication skills.
• Coordinated with DBAs, QA, Release Management and external team for technical needs and to ensure the timely release of project.
• Worked extensively with quality assurance team in understanding and documenting Test Cases, System Test Plans(STP), Unit testing, integration testing, regression testing and User Acceptance Testing (UAT)
• Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities.
• Ability to explain technical concepts and communicate with users and system administrators at all levels. Strong experience in mentoring team members and writing documentation.
• Experience working with many Offshore teams across the world on different time zones

TECHNICAL SKILLS:

Web: app platform/Operating Systems

HP: UX, Linux, Windows 95/98/XP/NT, Novell(Micro Focus) Netware, MS-DOS, Sun Solaris, IBM Mainframe z/OS, HTML5, ASP.NET, Spring framework, Ajax, CSS

Reporting: Oracle OBIEE, SAP Business Objects Enterprise and Infoview, IBM Cognos, SSRS

ETL Tools: Informatica, Data Migrator, SSIS, Data Stage

Databases: MS SQL Server 2008/2012Toad for SQL Server,, Toad for Oracle, Oracle 9i, 10g, 11i, Redshift, Elastic Search, SQL server2000, MS Access

Testing Tools: JIRA, Serena Team Track, PVCS Tracker, HP Quality Center, BugZero, Beyond Compare, LoadRunner, QuickTest Pro

UI Tools / Development Methodologies: MS Visio, SnagIT, ARIS, / SDLC, Agile

Dashboard: LogiXML, MS Dynamics CRM Dashboard, Key Indicators

Requirements &Project Management Tools: Rational Requisite, blueprint, Microsoft Office 2013, JIRA

Modeling Tools: Rational Rose, UML, MS Visio

RDBMS: MS SQL Server 2012, 2008

Operating Systems: Windows server, Windows 2000, Windows Operating System, UNIX, Linux

Development Tools: Toad, SQL Developer, DBeaver, XML Publisher, SQL*Loader, SQL*PLUS, RAD, RSASource Control GitHub, SVN

Tools: WinSCP, GO CD

Reporting Tools: Business Objects, Crystal Reports, Oracle reports 9i

Languages: SQL, PL/SQL, Shell Scripts, HTML, Basic Java, C

Environment: MS Windows XP/2000, Vista, UNIX, Windows Server 2008, Linux.

Case Tools: MS Office, Word, Excel, Power Point and Access, Microsoft Visio, Microsoft Visual Studio, Microsoft Project, CA SCM, SVN, Fuse, Rally, Jira, Remedy, Sales Force.

WORK EXPERIENCE:

Confidential, Englewood, CO

Sr. Business Systems Analyst / Project Management Analyst

Responsibilities:

• Gathered business requirements by conducting detailed interviews with business users, stakeholders, and Subject Matter Experts (SME’s)
• Documented business, functional and technical specification requirements including data flow, business rules, Use cases, application programming interface details and other subject matter expert meetings
• Communicated and interacted on a regular basis with the project manager and development team during different stages of the project
• Developed use cases from requirements and created UML diagrams such as use case diagrams, activity diagrams, and sequence diagrams
• Designed Data Flow Diagrams (DFS’s), Entity Relationship Diagrams (ERD’s), and web page mock ups using Rational Rose and MS
• Managed schedules and collaborated with different teams working on the project
• Prepared Project progress reports and status reports submitted to the management on an ongoing basis
• Assisted with required data analysis, interpretation, correction and document presentation for various assignments
• Direct/guide team to develop software components using both Spring framework, ASP.NET and Angular JS web application environment, assisting them in initial analysis by finding the right components to be updated using JSON editor
• Extensive business facing experience in goals-based wealth planning, identifying inputs from clients/customers
• Involved in business requirements review sessions for integrating new Aladdin risk score, discussing how this new ‘volatility’ score can be validated at different levels
• Prepared high level design document for Blackrock Aladdin integration project
• Created end-to-end comprehensive project plans and implementation checklist to ensure all the activities are on track and delivered on-time using MS Project and Atlassian JIRA
• Used GOCD Tool to configure Continuous Integration (CI CD process)
• Worked/updated changes in NIFI Servers links and Production support scenarios and steps
• Written Trouble shooting guide for on call support incidents
• Conducted walk-through sessions with development and business teams on requirements traceability matrix, comparing test cases against software requirements/ business use cases
• Experience working on MS Excel & Access Application Development
• Generated UNIX Shell scripts to automate Batch Jobs and Loading Process.
• Written technical Documents in Wiki and created child & parents pages to update all ESL Architecture.
• Involved in developing the User Stories for the various functionality
• Used Rally to create User Stories and to see Iteration status
• Used WinSCP to deploy war file into QA, INT environments
• Gave support during production release and validated the application during production night
• Used JIRA to refer production defect
• Assisted performance testing team in providing inputs for application response times, frequency of users and server load at peak hours
• Involved in fixing prod defects and On-call support as well

Environment: Oracle 10g/11g, PL/SQL, TOAD, Perl, Shell Script, SQL*Loader, UNIX shell scripting JavaScript, MS Excel, MS Word, Jira, ETL, Java, J2EE, HTML5, Angular JS, Bootstrap, JSP, CSS, Java, Spring, hibernate, spring data, spring security

Software’s used: WebLogic Server, Oracle IWI 1 g, Mongo DB, Couchbase, Soap UI, IntelliJ, Putty, JMeter, Cloud foundry, Kafka, logstack, AppD, Granfana

Confidential, Boston, MA

Sr. Business Analyst

Responsibilities:

• Documented Advisory business, functional and technical specification requirements including data flow, business rules, Use cases, application programming interface details and other subject matter expert meetings
• Hands-on experience and thorough understanding of Wealth management advisory account opening and update lifecycle including but not limited to program selection (UMA, PM, CGA, IMS, CES, TRAK), investment amount (contribution, withdrawal, eligible/non-eligible assets etc.), risk profile/score (objectives/factors affecting risk), model allocation (SMA, GIC or Custom allocation), Service elections, assigning effective advisory rate % and proposal generation
• Performed complex Statistical computation between Advisory Portfolio historical risk, historical return and Forecasted data based on asset class weightings for Portfolio models/accounts analysis for Portfolio Analyzer application
• Managed/tracked Advisory applications including Account Inception and Update, Advisory Fee Calculator, Investment Proposal Tool, Portfolio Analyzer, Consulting Group Proposal System changes
• Performed extensive data analysis on Portfolio Analyzer data, i.e. involved in data reconciliation of forecast and historical data
• Involved in business requirements review sessions for integrating new Aladdin risk score, discussing how this new ‘volatility’ score can be validated at different levels
• Prepared high level design document for Blackrock Aladdin integration project
• Created end-to-end comprehensive project plans and implementation checklist to ensure all the activities are on track and delivered on-time using MS Project and Atlassian JIR
• Performed extensive impact analysis and assessment on all the downstream and upstream Wealth management systems
• Creating and monitoring deployment tickets using ServiceNow and coordinating with production support team
• Plan, Conduct and successfully completed various test cycles (manual testing) including System Integration Testing, Performance and User Acceptance Testing in a timely manner and managed defects using HP ALM 12.20
• Conducted walk-through sessions with development and business teams on requirements traceability matrix, comparing test cases against software requirements/ business use cases
• Assisted performance testing team in providing inputs for application response times, frequency of users and server load at peak hours
• Involved in Documentation during various phases of product life cycle.
• Designed requirements traceability matrix to trace/manage business requirements
• Interacted with the development and testing teams to improve overall quality of the Applications

Environment: Oracle 10g/11g, PL/SQL, TOAD, Redshift, Perl, Shell Script, SQL*Loader, UNIX shell scripting JavaScript, html, MS Excel, MS Word, Jira, ETL.

Confidential, Conway, AR

Sr. Business Analyst / Project Analyst

Responsibilities:

• Created business requirement document and functional requirement document for USD Clearing project where objective was disintegrating Conway branch for better monitoring
• Experienced working with Alerts/Case Management lifecycle with scenarios, risk assignment, watch list monitoring and alert/case consolidation
• Worked closely with Quality Assurance team for overall upgrade testing activities and product acceptance including UAT sessions with business
• Responsible for creating interface requirement document for accounts, customer, activity and risk areas sourcing from various upstream systems feeding into Mantas database
• Used UML notations and RUP methodology to analyse and translate business requirements into system specifications
• As a Scrum master, created User stories/Epics in JIRA, sprint planning/product backlog documentation and daily scrum meetings for MANTAS Upgrade 5.8 to 8.x
• As a Scrum master, proactively providing inputs for retrospective sessions
• Validated new upgraded version of Oracle OBIEE business reports for all three regions i.e. US, Asia-Pacific and European markets
• Identified Opportunities for business process improvement and initiated efforts to make improvements
• Defined use cases, simulate UI mock-ups, managing storyboards and designed queries using ‘Query Management’ for Mantas Miami requirements using Balsamiq
• Performed end-to-end data validation i.e. AS-IS and TO-BE process comparison using Toad for Oracle SQL, comparing data from 5.8 version to 8 version
• Wrote complex SQL queries for running few manual business reports which cannot be automated and delivering them on periodic basis
• Created process flow and data flow diagrams using MS Visio representing how various upstream systems feeding into Mantas
• Updated all the necessary documents and maintenance via Sharepoint tool
• Analyzed case management and transactional data workflows in Informatica ETL
• Created all project related incident tickets for implementation activities and other business manual report scheduling purposes in ServiceNow incident module
• Prepared test cases and exported test cases for Mantas Miami project using Selenium IDE automation tool
• Created project plans for Mantas upgrade project using Microsoft Access
• Performed Enterprise Web application UI testing during Oracle Mantas upgrade from version 5.8 to version 8
• Experienced working with different region owners of data i.e. Americas, Europe and Asia Pacific, meeting their on-demand/manual report requests
• Interviewed business users to gather requirements and analyzed the feasibility of their needs by co-ordinating with the project manager and technical lead
• Involved in writing Data Requirements/ Data Load functional specs for any updates to databases including but not limited to validations, data model changes and data load rules

Environment: SQL, PL/SQL, SQL Developer, Windows XP, UNIX, Fuse, Perl, UNIX, Tableau 8, SVN repository, SIT, QA, UAT, Pivot, Triggers, Salesforce, Jira.

Confidential

Business Analyst/ Business Development Executive

Responsibilities:

• Basically this company is into IT/ITES.I personally is responsible in identifying the prospective clients and then generate business for the company in terms of their IT services, mobile application development and IT services
• Identify new business opportunities through market research, trend analysis, monitoring of competitors activities etc
• Gathered and documented customer requirements along with detailed functional design specifications and system documentation
• Prospecting identified decision makers on various technologies Develop solution accelerators that promote new-solutions in my domain
• Developed Use case diagrams, business flow diagrams, Activity/State diagrams, and Sequence diagrams to help business users and developers better understand the process
• To understand the business directions and trends related to client's industry or domain; provide value-additions by proposing new solutions and business strategies
• Evaluate and analyses capabilities against competitors
• Based on the business requirements for Property, Casualty and Environmental created screen mock-ups/ Wireframes using Axure Pro 6.5
• Created user stories/epics for various business Underwriting Toolbox scenarios to meet the acceptance criteria with each module product owners and SME’s
• Assisted ASI’s Data services team with ACORD standards in terms of business glossary and Data model
• Understanding of ACORD XML business messages for Property & Casualty and Surety.
• Analyzed data and results with query tools (e.g. SQL navigator, Aginity, Informatica) to support UTB requirements
• Identify the business areas in greatest need of change using client's needs, best practices, and corporate performance measures
• I am a part of the Group strategy and Business Development team at Swayam During my work here, I built a client network of over Many companies ranging from start - ups to MNCs to promote Swayam programs and Our Strategy's in IT world as a Strategic IT Partner, and My work at Confidential involves a lot of Data analysis, Data Research, and decision making, etc.,.
• Involved in the database design for better understanding the relations, associations and dependencies within the data base.
• Involved in writing functional and technical documents.
• Assisted the development team in designing the GUI of the application

Environment: SQL, PL/SQL, SQL Developer, Windows XP, UNIX, Fuse, Perl, MS Access, Java, Oracle, Sysbase/Unix, Windows NT

Confidential

Business Process Associate/Business Analyst

Responsibilities:

• Analyzed the different data feeds which passes on to the GIDW (Group Insurance Data Warehouse)
• Performed analysis on transactional database and data validation using TOAD(DB2) for getting historical data for some of the elements
• Gathered and documented customer requirements along with detailed functional design specifications and system documentation
• Designed the separate universe using SAP Business Objects XI for data mart
• Defined the new universe which was created by identifying dimensions and measures
• Identified the roll-up or aggregation rules, granularity or hierarchy rules in data mart for all the data elements
• Well versed with Serena Team Track or PVCS Tracker to resolve and maintain all the testing issues
• Performed UAT testing to ensure that the requirements provided by Underwriting, Actuarial and Sales have been met
• Handling support central Work flows for address changes
• Raise cases for all Query mails
• Resolve Customer Query mails on time
• Worked on IT DOCCUMENTS and Support Central
• Worked on ITG
• Calling customers to get clarify to process few works successfully in given TAT and Time
• Completing the Provided work on time before the TAT
• Learnt few other activities from what I was doing

Environment: SQL, AS 400 Application, Windows XP, UNIX, Support Central tool, Applications of Genpact, SQL, PL/SQL, SQL Developer, Windows XP, UNIX, Fuse, Perl, MS Access, Java, Oracle, Sysbase/Unix,