SUMMARY

• Eight plus 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 both SOAP UI testing working wif Agile / Waterfall Methodology.
• Gathered requirements during inception phase, documented and delivered functional specification documents.
• Developed SQL Views and used them in creating reports using Crystal Reports XI R2.
• Worked on creating PL/SQL Tables, Views, Stored Procedures, Triggers and Functions which are used in generating teh Crystal Reports.
• Analyzed and framed teh business logic for teh ETL process as per teh requirements.
• Highly TEMPeffective management and organisational skills wif ability to prioritise.
• Exposure to Client/Server, Web Application developmental tools and Software development and design.
• Information Technology experience in areas of production supports for Linux/Windows infrastructure, environment setups, servers build and migration, IT service transition and operational phase, providing customized solutions, Incident and Change Management.
• Having relevant experience in Linux/Unix Systems Administration and Technical Leadership role.
• Extensive technical noledge 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 noledge on Telecom, Retail, Finance, Education and Web Hosting domains.
• Prepared and published technical documents for company’s internal noledge repository.
• Conducted various professional trainings and workshops for company’s internal employees.
• Highly motivated team player wif 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, Crystal Reports, Access, Excel, MS - SQL Server, Oracle, Cognos

PROFESSIONAL EXPERIENCE

Confidential, Buffalo N.Y

Business Analyst / Data Analyst

Responsibilities:

• On assignment wif teh Information Technology and Communications Department on a Mainframe Conversionproject. dis is an ongoing archived data project to convert mainframe data files into generic text files thatcan be accessed by other platforms and software. Data files were cloned into formatted or unformatted layouts based on block characteristics and transferred from teh 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 teh customised applications.
• Working wif Agile planning tools, Version One tool. Agile Methodology.
• Creating all project related documents - Functional Specification Documents (FSD), Data Transformation Documents (DTD), Business Requirement Documents (BRD), and System Required Specifications (SRS).
• Installation and configuration of Oracle Network Management System Application in RHEL6 Servers.
• Performed data cleansing enrichment and mapping tasks.
• Work on Automation of jobs by creating Shell and Perl scripts and schedule it using crontab.
• Apply Oracle NMS product releases and configuration patches.
• Installation and configuration of Oracle WebLogic 11g Admin server, Node Manager and Managed servers in RHEL6 Servers.
• Provide support for WebLogic related issues, Oracle Network Managed System application related issues.
• Provide on-call support for production environments.
• Setup non-production and production environments for teh Oracle Network Management System Applications.
• Install and configure Dominion specific customized complex interfaces which supports to Oracle NMS application eg. DMS, CBMS, GIS, SCADA Focus, Outage Management Systems, Device Attributes, etc.
• Installation and configuration of SSL Certificates, create CSR and get third party certificates, managed renewal of SSL.
• Install, configuration and support of Oracle Business Intelligent Publisher for Dominion specific Reports.
• Managed application users and its privileges.
• Migration of Application database and application migration from old platform to new platform.

Confidential

Business Analyst / Data Analyst

Responsibilities:

• Gathered high-level requirement for all teh external projects in a release.
• Working wif HR application Oracle and PeopleSoft.
• Working in both SOAP UI testing.
• Modelling and development of Reporting Data Warehousing System.
• Facilitated JAD sessions wif 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 teh impacting projects that were agreed upon to be implemented in teh current release.
• Designing and developing Data Models and Data Marts that support teh Business Intelligence Data Warehouse.
• Expertise in Data Warehouse/Data Mart, ODS, OLTP and OLAP implementations teamed wif project scope, analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, system testing, implementation and production support.
• Data reconciliation to verify data.
• Drafted and submitted change management guides for approval.
• Maintained and updated database input from multiple sources.
• Ensured accurate and complete asset information for all projects.
• Mapped system requirements for Job Functions.
• Created / presented training materials for upgrade.
• Designed and implemented training materials for End Users highlighting upgrade enhancements and new functionality.
• Enhancement configuration of Navigational Profiles.
• Gathered information from Business Units on screen navigation downtime and configured Navigation buttons for great user speed to work.

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 teh 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 extensive data modeling to differentiate between teh OLTP and Data Warehouse data models.
• Identified/documented data sources and transformation rules required populating and maintaining Data Warehouse content.
• Performed Gap Analysis to check teh compatibility of teh existing system infrastructure wif teh new business requirements.
• Performed analysis and presented results using SQL, SSIS, 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 wif 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 wif project managers, legal counsel, and other team members to gather data for projects.
• Conducted review sessions on regular basis wif 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 teh current application performance.

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

Confidential

Business Analyst / Systems Analyst

Responsibilities:

• Addressed all aspects of credit card business.
• Gathered requirements and modelled teh Data Warehouse and teh underlying transactional database.
• Incorporated Automated Clearing House (ACH) functionality for teh Private Label Credit Cards for Cash Advance abilities.
• Extensive testing ETL experience using Informatica 9.1/8.6.1/8.58.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.
• Performed data cleansing enrichment and mapping tasks.
• Performed requirements modelling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realisations using RUP tools.
• Interviewed Business Users to gather Requirements and analysed teh feasibility of their needs by coordinating wif teh project manager and technical lead.
• Conducted extensive requirement analysis.
• Serve as a liaison to teh business community. Participate in a user and task analysis to maintain teh business community's perspective.
• Data modeling of both Logical Design and Physical design of Data Warehouse and Data Marts in Star Schema and Snow Flake Schema methodology.
• Mentoring specific projects in application of teh new SDLC based on teh Agile Unified Process, especially from teh project management, requirements and architecture perspectives.
• Researched teh various steps in teh life cycle and then constructed teh system in a way that teh high risk customers would be easily identified and monitored.
• Used teh Data Stage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into Data Warehouse database.
• Met wif individual departments to communicate SharePoint purpose, application and vision for teh future.
• Streamlined clerical work processes and mapped then into teh new system.
• Developed project plans and managed project scope. Assigned tasks among development team monitored and tracked progress of project following Agile Methodology.
• Assisted in building a Business Analysis Process Model using Visio.
• Assist in translating requirements and use cases into test conditions and expected results for product, performance, and user acceptance testing.
• Used MS SharePoint for teh purpose of managing documents and for hosting websites which was used to access shared work spaces and documents.
• Assisted Project Management in developing Scope/ Vision Documentation and Project Plan, tracking project process, and developed Risk Mitigation Plan.
• Performed extensive Requirement analysis and developed use cases and work flows.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
• Played a key role in teh planning, User Acceptance Testing, and Implementation of system enhancements and conversions.
• Provided key input in working wif users in defining project and system requirements.
• Developed strategic partnerships wif teh business units to develop a solid noledge base of teh business line; including teh business plan, products, and process and revenue streams.
• Documented and delivered Functional Specification Document (FSD) to teh project team.
• Conducted JAD sessions for communicating wif Stakeholders and Project Directors.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Produce performance reports and implement changes for improved reporting.

Environment: COBOL, Db2, Oracle, MS Word, MS Project, MS Excel, MS Visio, MS SQL.