Business Data Analyst Resume
New, YorK
SUMMARY:
- Over 10+ years of IT development and analysis experience in scientific, commercial and financial software applications:
- Solid experience inSDLC and fluent working in bothUNIXandWindowsenvironments.
- Involve in collection, subscription and publish of historical and real - time market data feeds NYSE TAQ, TAQ NBBO, CME, RMDS Reuters, NASDAQ, TSE, OTC Markets, ICAP, Tradeweb & Confidential .
- Excellent in BRD (Business Requirements Documents), FRD (Functional/System Requirements Documents) and technical specifications, project planning and time estimate, project plan implementation, and project risk management.
- Proficient in creating BRD and FRD based on exchange specifications, Business and product requirements.
- Created the mapping document for new market and exchange.
- Created the functional specification for exchange feed migration.
- Solid understanding of Market data feed, exchange data content and messages.
- Worked on various exchange market data feeds for data subscription and publication.
- Excellent working knowledge of Reuters RFA, Confidential B-pipe, Eikon, Elektron and Onetick.
- Involved in supporting feed and data for production environment across different region APAC, EMEA and Americas.
- Used OneTick Database for tick data collection, management and research for real-time and historical market data.
- Worked on analysis, normalization and mapping of time series data based on business requirement.
- Involve in data Quality, validation and verification.
- Used Perl & Shell scripting, SQL, UNIX, Onetick, github for developing market data application.
- Thorough understanding of change and release management for software deployment.
- Excellent knowledge ofEquity, Derivatives,Fixed Income products.
- Ability to interact wif vendors as well asbusiness andcross-functionalteams.
- Develop, simulate and test replay scenarios wif published Market Data.
- Strong knowledge of databases and extensively usedSQLqueries for backend data validation and verification.
- Strong analytical and problem-solving skills wif the ability to work individually as well as be a team player.
- Good hands on experience working wif onside, off-shore model, daily scrums.
TECHNICAL EXPERTISE
Operating Systems: UNIX, Linux, Windows 7/XP/8, Windows Server 2008
Databases: Oracle 9i, Sybase, SQL Server
Market Data tool: Confidential, Reuters Eikon/Elektron, Thomson One, Onetick, RFA, B-pipe
Programming Languages: C, C#, HTML, XML, PL/ SQL
Scripting Languages: Shell Scripting, PERL, AWK, VBScript, JavaScript
Protocols: FIX 4.2 Protocol, FTP, SSH, TELNET
Others: WireShark 1.2, SecureCrt, Putty, MS Office 2003/2010, MS Sharepoint 2010, ServiceNow, VirtalBox, VMWare, GitHub, Git
PROFESSIONAL EXPERIENCE
Confidential, New York
Business Data Analyst
Current responsibilities:
- Good understanding of exchange real-time pricing and reference data.
- Worked on interpreting market data provider specifications and normalized to Confidential market data model.
- Involved in managing projects from requirements gathering to software rollout for various market data products.
- Write BRDs and execute test scripts for domestic and global exchanges.
- Wrote detailed test scripts across multiple testing cycles and environments.
- Created and Review BRD, HLD/LLD to determine Use Case scenarios and Test Plan implementation.
- Organized Defect management on teamtrack and client issues on Jira.
- Created LLD, HLD, Use Cases, and System Test Plan wif technology development group for alpha and beta testing.
- Involved in researching and modeling financial markets data and their events.
- Excellent knowledge ofEquity, Derivatives,Fixed Income products.
- Develop, simulate and test replay scenarios wif published Market Data.
- Involved wif various aspects of the project life cycle from requirements and implementation design to development, release and QA/troubleshooting.
- Actively involved in working wif the Feed Handler software developers to make changes to key systems for Exchange market data.
- Working on and good understanding of various exchange market data level 1 and level 2 feeds.
- Support development teams to ensure successfully execution of requirements and project delivery
- Good knowledge of Exchange Datafeeds provided by the Equity markets (NYSE, NASDAQ, BATS, CME, TMX Canada, Alpha, ICAP, Tradeweb and other global exchanges) and the technologies used to deliver those feeds in both client and co-located facilities.
- Solid understanding of Confidential B-pipe API, SAPI and DAPI subscription.
- Used Perl & Shell scripting for supporting and developing market data application.
- Used SQL for backend testing and historical data mining.
- Used Onetick database time series data for real time data validation and testing.
- Used various terminal functions and tools to analyze, test and verify the data and unit testing of code.
- Proficient in project and business documentation and responsible for modeling various market data events.
Environment: Linux/UNIX, Shell Scripting, PERL, AWK, XML, Jira, GitHub, Confidential, Bpipe, Windows 7, PL/SQL, Onetick, MS Office
Confidential, New York
Business Data Analyst
Responsibilities:
- Worked on analysis, normalization and mapping of time-series data based on business requirements.
- Involved in functional and technical design reviews.
- Involved in data quality management, quality analysis and issues, backload, verification and validation of data.
- Track/Maintain Product enhancement and maintenance subject matter documentation, for new projects in JIRA.
- Create BRD and supervise test lead activities for Vendor data and exchange specifications.
- Review BRD, HLD/LLD to determine Use Case scenarios and Test Plan implementation.
- Create and Track Test Project deliverable documentation artifacts on SharePoint.
- Wrote detailed test scripts across multiple testing cycles.
- Involved in user entitlement management and application management using GARS.
- Supporting user and Clients, involve in assisting users in building API based applications.
- Involve in development, UAT testing and production deployment of application.
- Used Perl & Shell scripting, SQL, UNIX, SVN, Onetick, OTQ, Tectia ssh client for Developing market data application.
- Used OneTick market data client and server-side components for collection, normalization and loading of data.
- Involve in collection, subscription and publish of historical and live market data feeds NYSE TAQ, TAQ NBBO, CME, RMDS Reuters, ICAP, Tradeweb & Confidential .
- Worked on various exchange market data feeds for data subscription and publication.
- Support for various production environment across different region APAC, EMEA and Americas.
- Worked on capacity performance and management, build tools to monitor infrastructure usage for capacity, analyze and follow ups for capacity and performance alerts, hardware expansion.
- Thorough understanding of change and release management for software deployment
- Excellent knowledge ofEquity, Derivatives andFixed Income products.
- Using Jira for Issues and task Management internally and wif external Vendors.
- Good hands on experience working wif onside, off-shore model, daily scrums.
Environment: Linux/UNIX, Shell Scripting, PERL, AWK, Jira, SVN, Windows 7, Sybase, PL/SQL, Onetick, MS Office, Putty, Tectia SSH Client, Cloakware, FIX 4.2, ITSM, SSH and FTP, ServiceNow
Confidential, New York
Market Data Engineer
Responsibilities:
- Working on and good understanding of various exchange market data level 1 and level 2 feeds.
- Participate in requirements elicitation session and review requirements to ensure they are clear, concise and testable.
- Expertise in usingFIX 4.x Protocol. Testing admin and application FIX messages like heartbeat, pre-trade, trade and post-trade messages.
- Excellent knowledge ofEquity, Derivatives,Fixed Income, andAUTEX IOI/AT products.
- Review requirement and software specification documents. Identify conflicts, errors in the documentation and provide feedback to business analysts.
- Writing Linux PERL, AWK and C-shell Scripts to automate regression testing and to test/verify functionality.
- Worked on Wireshark 1.2 tool to capture and analyzing network data packets and contents.
- Create and maintained test case repository in HP Quality Center 11.
- Writing PL/SQL for extracting and analyzing data from history database.
- Using TeamTrack and Jira for Defect Management and tracking.
- Create test scenarios and ensure the test coverage completeness and find any gaps.
- Good working knowledge of Confidential desktop platform; Thomson One, Reuters3000 Xtra Elektron and Eikon workstation.
- Provide direction to team members and interface wif projects team members outside team.
- Involve in Test Case Design, Test planning, Test Tool usage and Test execution.
- Manage build notifications and assist environment support team in deploying the applications into QA, verified production deployment accuracy and participated in production environment testing.
- Writing, maintaining and updating test documentation for various stages and phases of testing.
Environment: Linux, Shell Scripting, PERL, Teamtrack, Windows 7, HP Quality Center 11, PL/SQL, ThomsonOne, Eikon, Reuters3000 Xtra, WireShark, MS Office 2003/2010, Putty, SecureCrt 6.7, QTP 11, VBScript, Elektron, Eikon
Confidential, Braintree, MA
Software Programmer Analyst
Responsibilities:
- Analyzed system requirements and develop test plan for end-to-end testing.
- Involved in web based automation testing.
- Generated the test scripts for Functional, Data driven and Regression testing using automated testing tool QTP 9.0.
- Converted Functional requirements into detailed scenarios and test cases.
- Analyzed business requirements documents.
- Creating and enhancing test scripts using keyword driven framework and descriptive programming.
- Creating automation resources such as object identification, object repositories, function libraries, parameterization, Data Driven testing and test data set up.
- Maintained and update QTP object repository (OR) as functionality changes.
- Develop SQL queries for backend testing.
- Good knowledge on QTP IDE (Object Identification, Object Repository, Step Generator, Data Table, Checkpoints, Output values, Actions, Recovery scenarios etc
- Experienced in performing Data Driven Testing using parameterization in Quick Test Pro, to test the application wif different sets of data.
Environment: TeamTrack, ASP.NET, C#, VBScript, QTP 9.0, Microsoft Excel 2000/2002/2003, Windows 2000/XP, SQL Server 2000/2005, PL/SQL.
Confidential
Programmer
Responsibilities:
- Involved in Coding unit testing and bug fixes for various features of software.
- Worked on textual phonetically speech database designs.
- Involved in functional and technical design reviews.
- Involved in speech data collection
- Developed, trained and test the speech recognition system.
- Used PERL, C and Shell scripts and HMM Toolkit.
Environment: Linux 9.0, C, ‘C’ Shell Script, PERL, HTK Hidden Markov Model Toolkit