SUMMARY

• 10 years of professional experience as a Business Analyst/System Analyst in Banking/Finance domain.
• Extensive experience in analysing and requirements gathering and writing system functional specifications.
• Strong experience in Data Warehousing, Data Models, Data Marts, Data Migration, Data Cleansing, etc.
• IT Management experience in distributed web services and enterprise software environment.
• Strong experience in working with Agile / Waterfall Methodology.
• Gathered requirements during inception phase, documented and delivered functional specification documents.
• Developed SQL Views and used them in creating reports.
• Worked on creating PL/SQL Tables, Views, Stored Procedures, Triggers and Functions
• Analyzed and framed the business logic for the ETL process as per the requirements.
• Highly effective management and organisational skills with ability to prioritise.
• Exposure to Client/Server, Web Application development and Software development and design.
• Information Technology experience in areas of production supports infrastructure, environment setups, servers build and migration, IT service transition and operational phase, providing customized solutions, Incident and Change Management.
• Extensive technical knowledge and experience of Build Engineering, build solution implementation, profitability analysis, installation and configuration of software and process automation for environment and server builds.
• Having rich experience in project transition and operational phase of ITIL service life cycle.
• Experience writing Functional Specification Documents (FSD), Data Transformation Documents (DTD), Business Requirement Documents (BRD), and System Required Specifications (SRS).
• Experience creating Business Requirement Documents (BRD) and converting into Functional Specifications Documents (FSD).
• Successfully executed and managed various projects on heterogeneous environments and provided customized functionalities.
• Having good knowledge on Telecom, Retail, Finance, Education and Web Hosting domains.
• Prepared and published technical documents for company’s internal knowledge repository.
• Conducted various professional trainings and workshops for company’s internal employees.
• Highly motivated team player with excellent Interpersonal and customer relational skills, proven communication, organizational, analytical, and presentation skills.

TECHNICAL SKILLS

Software/Hardware: MS Visio, HP Quality Centre, UML, XML, MS Office, MS Project, C/C++, PL/SQL, Html, Jira, Rally, Version one, Access, Excel, MS - SQL Server, Oracle

PROFESSIONAL EXPERIENCE

Business Analyst

Confidential

Responsibilities:

• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures.
• Created various business process workflow diagrams using Business Process Model and Notation (BPMN) for developing workflows for AS - IS and TO-BE systems
• Worked with the Teams to understand metadata, Analytics Repository, dimensional modeling design.
• Maintained metadata (data definitions of table structures) and version controlling for the data model.
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
• Involved in defining the source to target data mappings, business rules and data definitions.
• Responsible for defining the key identifiers for each mapping/interface.
• Responsible for defining the functional requirement documents for each source to target interface.
• Documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Responsible for physical/logical data modeling; metadata documentation; user documentation.
• Documented data quality and traceability documents for each source interface.

Confidential

Business Analyst / Data Analyst

Responsibilities:

• On assignment with the Information Technology and Communications Department on a Mainframe Conversion project. This is an ongoing archived data project to convert mainframe data files into generic text files that can be accessed by other platforms and software. Data files were cloned into formatted or unformatted layouts based on block characteristics and transferred from the mainframe to a Unix server.
• Working on finance Fixed Income, Equities, and Derivatives Instruments.
• Prepare technical and functional specifications and develop, document and revise business system design procedures, test procedures, and quality standards.
• Working in financial investments, investment instruments, profitability analysis (equity/funds/debts/shares/options/security).
• Train cross functional user groups and management on the customised applications.
• Creating all project related documents - Functional Specification Documents (FSD), Data Transformation Documents (DTD), Business Requirement Documents (BRD), and System Required Specifications (SRS).
• Manage vendor accounts ensuring that all billing and collections are completed within company policy.

Confidential

Business Analyst / Data Analyst

Responsibilities:

• Gathered high-level requirement for all the external projects in a release.
• Working with HR application Oracle and PeopleSoft.
• Working in both SOAP UI testing.
• Modelling and development of Reporting Data Warehousing System.
• Facilitated JAD sessions with SME's and business analysts from other feeder systems for a detailed analysis and a better understanding of impact of various projects on each other.
• Created functional requirement documents for the impacting projects that were agreed upon to be implemented in the current release.
• Designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Managed team of 16 advisors to ensure all applications for public assistance were processed in quickly and accurately to ensure that eligible clients receive benefits in a timely manner.
• Resolved client complaints and explained eligibility determination so that client clearly understood reason for application denial or delay.
• Conducted monthly meetings with team in order to ensure that all advisors were up to date with all state policy changes ensuring accurate application processing.

Environment: Microsoft Office Suite, Microsoft Visio Access, Excel, Unix, Windows NT/XP, Oracle, SQL, SQL Server, C#., C++, NET, ASP.NET, Business HP Quality Centre.

Confidential, Richmond, VA

Business Analyst

Responsibilities:

• Analysis of the existing credit card processing system, mapping phase according to functionality and data conversion procedure.
• Industry analysis and company analysis on scenario basis, competitiveness, growth potential and credit analysis.
• Performed Data Warehousing, Data Marts, Data Dimensions, Hierarchy, and Data Measures.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Performed analysis and presented results using SQL, MS Access, Excel, and Visual Basic scripts.
• Imported, exported and manipulated large data sets in multi-million-row databases under tight deadlines.
• Wrote and automated tools and scripts to increase departmental efficiency and automate repeatable tasks.
• Maintained existing data migration program with occasional upgrades and enhancements.
• Performed data migration enforcement tasks.
• Performed data cleansing enrichment and mapping tasks.
• Manipulated files and their associated data for rapid delivery to clients or loading onto internal databases.
• Collaborated with project managers, legal counsel, and other team members to gather data for projects.
• Conducted review sessions on regular basis with QA and development teams for preparing status, delivery report and client reporting.
• Creating all project related documents - Functional Specification Documents (FSD), Data Transformation Documents (DTD), and System Required Specifications (SRS).
• Suggested measures and recommendations to improve the current application performance.

Environment: Java, Unix, C, Oracle, DB2, SQL Server Reports, .Net.