We provide IT Staff Augmentation Services!

Technical Analyst Resume

SUMMARY

  • Have 8 years of experience in IT Field covering Software development, analysis, design, development, testing and system maintenance of business applications with extensive experience in ETL, RDBMS and Web Technologies.
  • Technical skills include requirements analysis, data modeling, systems design, testing and implementation of web & client/server systems. Related skills in writing functional specifications, business diagramming (process mapping, process modeling, entity relationship diagrams, data flow diagrams) and design reports.
  • Over 6 years of experience in Data Warehousing and Transactional Environments.
  • Experienced in diverse financial domain including Retail, WholeSale Banking, Investment Banking & Asset Management which includes products like Equities, Forwards, Futures, Bonds - MUNI, Corporate Bonds, Treasury Bonds, Money Market instruments etc also different derivative products like REPO, OPTION, SWAP etc.
  • Extensive knowledge of GENEVA Portfolio accounting and management tools with daily reporting of realized and unrealized gain/loss, Taxlot position and fund performance to the clients as a part of the regular Client reporting exercise.
  • Extensive experience in writing Business Requirement Documents, Regression Test Plans.
  • Excellent communication and strong interpersonal skills with ability to interact with end-users, managers and technical personnel on-site.
  • Extensively writing and tuning Stored Procedures, packages for the Reporting needs.
  • Writing Shell Scripts as a wrapper to interact with different interfaces on Solaris platform.
  • Strengths are Problem Solving, Communication and interpersonal skills and ease of adaptation to newer development techniques, languages and working culture.
  • Analytical, highly self-motivated, goal-oriented professional with proven success in technology consulting and software development.
  • Having extensive work experience in cross-functional and multicultural environment.
  • I have strong SQL and relational database skills, using SQL Server 2005 or Oracle 10.
  • Great interpersonal skills and the ability to deal with all levels of business users and management.
  • Exposure to Formal Quality Processes.

TECHNICAL SKILLS

Data warehouse: ETL (Informatica Power center 7.1) and Business Objects Data Integrator XI/6.x.

Database: Oracle 10g/9i, MS Access 2000/97, SQL Server 2000 -05/7.x Sybase Eagle PACE.

Reporting: SQL Server 2005 Reporting services (SSRS). Business Objects XI.

Accounting Tool: Advent’s Geneva Portfolio Accounting Tool and RSL developer which is Geneva proprietary language.

Languages: PL/SQL, C, C++, VB 6.0, ASP, Power Builder 6.x, Unix Shell Scripting.

Web Technologies: J2EE (JSP),XML, XSLT, HTML, JavaScript, HTML, DHTML, ASP, VB Script, IIS.

O/S: MS-DOS, Windows Vista Ultimate, Windows Server 2003, Windows Server 2008, Windows XP/2000/NT/98, Sun Solaris 8.x, HP-UX 11.0, UNIX

PROFESSIONAL EXPERIENCE

Confidential

Technical Analyst

Responsibilities:

  • Working closely with Business Analysts to take requirements and writing extensive RSL on demand.
  • Worked extensively on Geneva 7.6 RSL development.
  • Business Analysis for prime brokerage client reporting based on portfolio overview, cash activity, and periodic performance etc.
  • Business Analysis for reporting stale price based on exchange holiday calendar, position reporting for Average cost clients, analysis of various corporate actions (mandatory and voluntary)
  • Enhancing and developing new RSLs (specific to Geneva) to extract data from the database and display the data in the desired format i.e. customizing reports according to client’s requirements.
  • Involved in installation of SSRS on windows server in Geneva 7.6.
  • Involved in periodic maintenance activities (backup and recovery) of AGA (Geneva database).
  • Good knowledge about Geneva configuration settings, service manager and repserver processes.
  • Working with Securities - Equities, Bonds, Options, Swaps, Forwards, Future, Repos and ETFs. Requirements specifications of all aspects from market data, online reconciliation reports, EOD processing scripts, portfolio accounting using Advent Geneva Portfolio Accounting Tool.
  • Working with global corporate actions (mandatory & voluntary) and reporting daily accruals.
  • Development for the Geneva 7.6 platform using RSL and SQL Server Reporting Services (SSRS) in SQL Server 2005.
  • Preparing the release notes and other suitable documents for users.
  • Imparting product training to the Documentation team
  • Reviewing product documentation deliverables and provide suggestions
  • Identifying new documents based on customer needs
  • Good grip on clear case version control system.

Environment: Platform: Unix, .Net

Tool: Geneva (Advent’s accounting software product)

Confidential

Senior Business and Technical Lead

Responsibilities:

  • Working closely with Business to take requirements and writing Business Requirement Document extensively.
  • Business Analysis for prime brokerage client reporting based on portfolio overview, cash activity, and periodic performance etc.
  • Business Analysis for reporting stale price based on exchange holiday calendar, position reporting for Average cost clients, analysis of various corporate actions (mandatory and voluntary)
  • Enhancing and developing new RSLs (specific to Geneva) to extract data from the database and display the data in the desired format i.e. customizing reports according to client’s requirements.
  • Involved in developing the shell scripts for loading data into Geneva and running reports.
  • Enhancing the wrapper codes (adapter code written in Java) in order to synchronize Geneva activities with external systems as per the business needs.
  • Automating the processes using shell scripts.
  • Developed the audit scripts (Java) for Pace and Geneva systems.
  • Autosys JIL creation for scheduling jobs to be run in Geneva.
  • Involved in the upgrade to a newer Geneva version (from version 6.0.3 to 6.0.6 and then to 7.6), which consisted of several steps like installation of the new version and comparison of the data with earlier version for customized reports etc in order to maintain stability after the upgrade.
  • Involved in installation of SSRS on windows server in Geneva 7.6.
  • Involved in periodic maintenance activities (backup and recover) of AGA (Geneva database).
  • Implemented various techniques (purging data from AGA and lockdown pool creation) for accounting run time improvement.
  • Good knowledge about Geneva configuration settings, service manager and repserver processes.
  • Working with Securities - Equities, Bonds, Options, Swaps, Forwards, Benchmark indices, ETFs. Requirements specifications of all aspects from market data, online reconciliation reports, EOD processing scripts, portfolio accounting using Advent Geneva Portfolio Accounting Tool.
  • Working with global corporate actions (mandatory & voluntary) and reporting daily accruals.
  • Requirements gathering, Analysis and development of a suite of Geneva reports to analyze fund TWR performance, P&L and exposure
  • Development for the Geneva 7.6 platform using RSL and SQL Server Reporting Services (SSRS)
  • Integrating Geneva 7.6 with 3rd party Tool - Gainskeeper for Cost Basis adjustments and trapping Wash Sale for year end tax reporting on 1099b reports for prime brokerage clients.
  • Business analysis, interface development using XSLT and SQL Server Integration Services (SSIS)
  • Sending back Accounting Data to Eagle PACE for reporting. Worked on Eagle PACE for creating or modifying exiting stored procedures and packages rigourously.
  • Preparing the release notes and other suitable documents for users.
  • Imparting product training to the Documentation team
  • Reviewing product documentation deliverables and provide suggestions
  • Identifying new documents based on customer needs

Environment: Platform: Unix

Tool: Geneva (Advent’s accounting software product)

Confidential

Technical Lead

Responsibilities:

  • Responsible for complex analysis of data for development of ETL process for extracting data from the different sources subsequently transform and load into the target.
  • Performed testing of the ETL processes and reports before releasing the application to the end users
  • Responsible for Performance Tuning of sources, targets, mappings and sessions.
  • Created complex functions, stored procedures and packages, Triggers by using PL/SQL
  • Implementation and Post Implementation surveys. Highly skilled in Design, Development, Implementation and testing of business applications, Unit and System testing on database.
  • Good Knowledge in data extraction, transmission and loading.
  • Extensive experience in Generating Client extracts using Unix scripts and Stored procedures.
  • Created complex informatica mappings which involved Slowly Changing Dimensions, implementation of complex Business Logic and capturing the deleted records in the source systems.
  • Developed PL/SQL stored procedures for database updates and to create the necessary indexes in the target tables.
  • Created and scheduled Sessions based on demand, run on time and run using Workflow.
  • Monitored Workflows and Sessions from Informatica
  • Worked with SQL*Loader to load the data into the warehouse and flat files respectively.
  • Wrote UNIX shell scripts to work with flat files, to define parameter files and to create pre and post session commands. Precise Documentation was done for all load jobs.
  • Designing data model with efficient integrity constraints and normalization techniques. Creating and managing various database objects like views, stored procedures, triggers, functions etc. Importing of data from legacy database into new database both having different database designs using scripts.
  • Worked extensively on Fermat Regulatory Reporting tool and involved in Risk Weighted Asset calculation. Customizing and inbound data massaging in order to suit fermat engine.
  • Implementations of the build in different testing environment.
  • Provided Technical Support to Business users the best practices approach and anticipate potential issues with customer solutions. Resolving complex technical issues and clearing specific technical hurdles.
  • Requirement clarification from Business users. Analysis and Preparing HLD/DLD/Technical design.

Environment: ETL Tool: Informatica PowerCenter7.1

Hire Now