SUMMARY

• A Senior Data Analyst with experience in business process analysis, software design development, execution and implementation in the Finance and Investment Banking industries. Core Strength: Data Analysis/Data Modeling, Report Modeling & Simulation, Business Artifacts Documentation skills, Project Scope, Business Use Cases.
• Over 7 yrs of Experience and Expertise in Finance and Investment Banking working as a Business/Data Analyst.
• Extensive experience as Data Analyst for data warehousing projects for large Finance and Investment Banking organizations experience in Data Cleansing/Data Conversion/Data Mapping/Data Migration.
• Data warehouse, ETL - Extraction/Transformation/Loading, Data Analysis, Data mining, Data migration, Data preparation, Graphical Presentation, Statistical Analysis, Reporting, Validation and Documentation.
• Good understanding of basic principles of Asset Management, Financial markets, and instruments (Equity, Bond,FI, FX, Derivatives).
• Prepared Business Requirement Document (BRD) and System Requirement Specifications (SRS) then converted Business requirements into Functional Requirements Specification (FRS).
• Knowledge of full life cycle implementation in building a Data Warehouse
• Extensive experience working with Teradata.
• Exceptional data analysis and reporting skills using (BusinessObjects, SSRS, Crystal Reports and MS Excel).
• Extensively used ETL methodology for supporting data extraction, transformations and loading process, in a corporate-wide-ETL Solutions.
• Extensive experience as a Business Analyst/Data Analyst for data warehousing projects for large financial organizations.
• Good experience with conducting feasibility analysis, Gap Analysis, impact analysis, SWOT analysis, cost & benefit analysis, requirement gathering and documenting System Requirement Specifications (SRS), System Design Specifications (SDS) and Design Reviews.
• In depth understanding of AS-IS and TO-BE business processes and experience in converting these requirements into Functional Specifications
• Experienced in Facilitating and participating JAD sessions for project definition involving analyzing requirements and process flows.
• Responsible for all aspects of Business Strategy, Development, Operations, Training, and Support.
• Expertise in creating training methods, training document, conducting trainings with the help of subject matter experts.

TECHNICAL SKILLS

Operating Systems: Microsoft Windows 95/98/2000/NT/XP, UNIX

Languages: Databases & Tools:

C, C++, JAVA: MS SQL Server 2000/2005, MS Access, Toad and Oracle 9i/10/11g, SQL, VBScript, UML

Business Intelligence: Business Objects XI r3, r2, r1, 6.5, 6.1, 5.x, 4.x

Internet Technologies: HTML, XML and HTTP concepts

Software: MS PowerPoint, MS Project, MS Visio, MS FrontPage, IBM Lotus Notes, MS SharePoint, IBM Congos.

Quality Management: Quick Test Professional, Test Director and Bugzilla

Methodologies / Frame work: Rational Unified Process (Rational Rose, Requisite Pro, ClearCase, ClearQuest), Axure, Data Modeling, Business Modeling, Use Case Diagrams, State Diagrams, Sequence Diagrams, Activity Diagrams and Class Diagrams

PROFESSIONAL EXPERIENCE

Confidential, West Des Moines, IA

Sr. Data Analyst

Environment: Teradata, SAP BusinessObjects, iGrapfx

Responsibilities:

• Conducted JAD Sessions to show the effects of Cost of Debts, Cost of equity and SML (Security Market Line).
• Used MS Excel, MS Power Point to create reports.
• Participated in business requirements meetings with the business sponsors, end-users and business analysts to gather end-user requirements
• Performed GAP analysis to identify the various existing processes and analyzed the process based on end user requirements.
• Developed business requirement specification documents as well as high-level project charter.
• Enhances the all over Data requirement process by adding a new artifact to capture the Consumption Requirements from the business user.
• Performed data profiling to assist the initial level data quality for various project.
• Involved in SDLC including requirements gathering, designing, developing, testing, and release to the working environment.
• Migrated from MS Access 2000/2003 to Oracle/MS SQL server 2000/2005.
• Responsible for gathering requirements, writing functional specifications and use cases for the application.
• Assisted Data Quality team in Data Profiling and documented the result out of it to the Project Folder which help helps the design team in sourcing the data.
• Produce series of MS Visio/MS Excel reports, Data Dictionaries.
• Data analysis and reporting using Excel and MS Access.
• Conducted Capacity Planning meeting.
• Created Technical Business Requirement Documents for the Tech only projects.

Confidential, San Ramon, CA

Sr. Data Analyst

Environment: Sun Iplanet, Visual Basic, SAP BusinessObjects, Informatica Powercenter 8.5, Oracle 10g/11g, Agile.

Responsibilities:

• Conducted JAD Sessions to show the effects of Cost of Debts, Cost of equity and SML (Security Market Line).
• Used SSRS and MS Excel, MS Power Point to create reports.
• Participated in business requirements meetings with the business sponsors, end-users and business analysts to gather end-user requirements
• Performed GAP analysis to identify the various existing processes and analyzed the process based on end user requirements.
• Used Rational Unified Process (RUP) for preparing Functional Requirement documents
• Designed and developed project document templates based on SDLC methodology.
• Developed business requirement specification documents as well as high-level project charter.
• Created all Use Cases and UML models using Rational Rose.
• Designed and implemented basic SQL queries for QA testing and report.
• Customized Oracle EBS 11.5.10 forms and reports
• Involved in SDLC including requirements gathering, designing, developing, testing, and release to the working environment. Developed and maintained Requirement Traceability Matrix (RTM).
• Migrated from MS Access 2000/2003 to Oracle/MS SQL server 2000/2005.
• Prepared Data modeling and Data Mapping document for data elements and data cleansing that were used for Current and New system in MS-Excel.
• Business and systems analysis of the business reporting requirements and translated the requirements to a technical specification for them to be deployed within the SAP BusinessObjects Data warehouse.
• Led a team to develop the reporting set to be delivered via BusinessObjects.
• Responsible for gathering requirements, writing functional specifications and use cases for the application.
• Developed Informix and Oracle data management strategies using fragmentation, striping, and redundancy from the database to the physical partition level.
• Capture the Data Change across time.
• Produce series of MS Visio/MS Excel reports, Data Dictionaries.
• Data analysis and reporting using Excel, Crystal Reports and MS Access.
• Develop the SQL codes as well as use ETL tools to Data Cleansing, Data Mapping and conversion rules and applications.
• Extracted data from Teradata with the help of Informatica.
• Interactive report document and dashboards and dynamic dashboards with use of tooltips and highly customized features like subtotal, alerts, derived metrics, color coding, drill maps etc. to better understand about business and business trends.

Confidential, Jersey City, NJ

Sr. Data Analyst

Environment: Apache, C#, SAP BusinessObjects, Teradata, Loadrunner, Java Scripts, J2EE, Oracle 9i, Web 2.0, Agile, BEA webLogic

Responsibilities:

• Chaired the Change Control Board and participated in the Release Management process.
• Designed and implemented complex SQL queries for QA testing and report/ data validation.
• Worked in RUP Framework involved in iterations at each phase of the software life cycle.
• Refined the requirements and Use cases in all iterations of the RUP cycle.
• Ran multidimensional analytics on SAP BusinessObjects
• Shared business insights with peers via BusinessObjects
• Used drag-and-drop features to create interactive reports using SAP BusinessObjects
• Identified data and information needs and suggests solutions that could provide returns in performance using Teradata
• Facilitated meetings to gather business requirements from department managers, technical staff to gain consensus for feature development, timelines, milestones, resources, and to impart an understanding of our clients business needs.
• Translated customer requirements into definitive class/object design using UML and Rational Rose.
• Interviewing business area experts and technical people. Prepared Logical Data Models to analyze and document business data requirements using Rational Requisite Pro.
• Developed complex queries using oracle data bases for reporting purpose.
• Data analysis and reporting using SAS, Crystal Reports, MS Power Point and MS Access.
• Extracting data from different sources like Oracle, Flat files, External files and transformed the data based on Business requirements.
• Used BusinessObjects tocreate reports based onSQL-queries.
• Migrated from MS Access 2000/2003 to Oracle.
• Worked in ETL Tool to extract data from Teradata, Oracle, ASCII files, XML and MS excel.
• Designs, develops and maintains ETL code, defining and capturing metadata and rules and development of ETL validation code.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency.
• Performed Data Cleansing, Data Mining and Data Mapping for change requests and new requirements.
• Extracted data from an Oracle data warehouse.
• Used for Excel spreadsheet download or validation, Cognos cubes, upload in third party applications.
• Responsible for providing valuable inputs to the Web based clinical software.
• Created dashboards, metrics, analytics, goals, alerts using Business Objects enterprise edition.
• Developed Informix and Oracle data management strategies using fragmentation, striping, and redundancy from the database to the physical partition level.

Confidential, Emeryville, CA

Data Analyst

Environment: IIS 6.0, Visual Basic, SAP BusinessObjects, Win Runner, Teradata, Java Scripts, J2EE, SQL Server 2000, Agile, Scrum, Tomcat.

Responsibilities:

• Created UML based diagrams using Rational Rose and MS-Visio for Use Cases and Activity Diagrams, for better understanding of the layout of the new process.
• Used MS PowerPoint & MS Project for status reporting and planning.
• Combined data from different sources using SAP BusinessObjects
• Used BusinessObjects tocreate reports based onSQL-queries.
• Improved business forecasting and strategic planning with SAP BusinessObjects
• Optimized Teradata datawarehouse helped in streamlining
• Used MS PowerPoint for complex project management tasks.
• Data analysis and reporting using Oracle, MS Power Point, MS Access and SQL server.
• Development of requirements and functional design documentation for Data Cleansing, Data Mapping and conversion rules and applications.
• Extracted data from Oracle into temporary tables in order to cleanup and standardize column entries for re-import into new Oracle data structures.
• Used extensive complex queries to create/modify/delete data.
• Provided Data modeling and Data Mining support for numerous strategic application development projects.
• Migrated the data from Oracle to SQL server and MS Access.