Data Developer
Resume:
RAJI CHANDRAN ***************@*****.***
TECHNICAL
SUMMARY:
Highly experienced and skilled developer with strong record of successful completion of projects and excellent teamwork
Handled all aspects of software development lifecycle - designing database, object model, coding, code review and testing
Worked on financial based projects at Eaton Vance Investment Managers using Eagle pace, at Credit Suisse on OFC (Operational Financial Control) and with Fidelity investments on projects that include Accounts Payable, General Ledger and Accounts Receivable, FABS ( financial accounting and billing system)
Over 15 Years of Experience in Oracle (12/11g/10g/9i/8i), MS Access and SQL server 2012, 2014
Experience working on AGILE projects participating in sprint planning, daily scrum stand up and sprint retrospective meetings. ( Used Jira for tracking progress )
Strong programming skills writing PL/SQL database objects like stored procedures, functions, packages and scripts to create tables, Indexes,views and ad hoc scripts
Over 2 years of experience in working with Data warehouse using ETL tools Informatica and Strong understanding of Data warehouse concepts such as Star Schema, Snowflake Schema, OLTP, OLAP and Multi-Dimensional Models for query and analysis
Strong Unix shell scripting experience to write batch routines and installation programs to deploy code to production and UAT
Technical expertise in database design and development, include data modeling (conceptual, logical, physical), documentation, programming, testing and development of production deployment scripts
Good experience in writing UNIX scripts to schedule jobs using Oracle concurrent manager and Oracle PL/SQL
Requirement gathering Using use cases (UML) or SDLC processes
Issue tracking, resolution and enhancements of complex application software problems
Experience with On Call Production support and Bug Fixing in the maintenance phase
Strong Business & Application analysis skills with time management, communication & presentation skills
Excellent problem solving, analytical and interpersonal skills, Strong team player, self-motivated, and mentor to others
TECHNICAL
SKILLS:
Operating System: Windows Vista/XP/2003/2000, Linux
Languages: C#, C++, C, PL/SQL, HTML, XML, Visual C++, Java script, Java, Python, CSS, HTML, Angular, Perl
Database: Oracle 12, 11g/10g/9i, Server 2005/2000, MS Access
Web Server: Microsoft IIS 5.0/6.0, Apache/Tomcat
Object Oriented Design Tool: Microsoft Visio 2003, Rational Rose
Designing and Modeling: Agile Methodology, UML, Enterprise Architect, Erwin 8.x
Operating Systems: Windows XP/2000/NT, UNIX and Linux
Version Controls: Stash, Source Tree, Visual Source Safe, Clear Case, GitHub and SCCS.
BI Tools: Business Objects 5.x/6.5/XIR2/XI3.1, Crystal Reports
ETL Tools: Informatica 10, 8.1/7.1/6.1, SQL Loader
Job Scheduling Tools: Computer Associates ESP, Autosys.
EXPERIENCE:
8/17 – Present Fidelity Investments Merrimack, NH
Oracle-ETL Software Developer
Project: FX Trading /Centralization– MIFID initiative.
Once an FX Order is placed on fidelity internal systems like Flex trade or FX connect, FX traders have the option of going thru live quotes from different brokers like Barclays, Bofa or algos or any execution steps provided by EMS. FX centralization platform is mainly developed to improve cash management and fund performance by having a single platform for all FX needs across advisors. Main modules of the system include order creation and generation, Single execution management system, Exposure tool, ORM and integration with accounting system.
Responsibilities:
Communicate effectively with systems teams and business users.
Publishing and storing of new MIFID II related fields for FX Orders and Trades into the appropriate FX transactional and database, CDE ODS and AMWH tables. This will help reporting once regulation goes into effect on Jan 3rd 2018.
Identifying and automating solutions for repetitive production issues.
Developed PL/SQL Stored procedures in Oracle12 for processing data and populating staging table, error table and fact tables on AMWH (Asset management warehouse).
Developed autosys job to load data from staging table to warehouse FACT tables.
Created informatica mapping, workflow, and session that also includes transformation like lookup strategy, update strategy, router strategy and so on.
Developed PL/SQL stored procedures, DDL changes on transaction database as part of enhancements to OMS interface to support fat finger checks.
Implemented snapshot changes that would provide user with most accurate recent trade activity status.
Developed trader and broker restriction loaders to load data from staging to AMWH to support MIFID II initiatives.
Used Jenkins to do continuous integration builds.
Participated in Scrum and added and modified task to be done using JIRA tool.
Used Sonar to improve code quality.
Created utlplsql packages to perform unit test.
Created PL SQL packages to handle order generation on the transactional database.
Performed performance tuning of sql queries that were being used in packages.
Environment: Oracle 12c, SQL Loader, PL/SQL Developer, Visio 2010, Informatica 10, Autosys, Jira, Sonar, Unix Shell Scripting, ETL tools
8/13 – 6/17 Eaton Vance Investment Managers, Boston, MA
Oracle Software Developer
Project: Eagle Pace Project
Eaton Vance Corp is one of the oldest investment management firms providing wealth management services that uses Eagle Pace Eagle Pace is Eagle’s reference data management solution that allows consolidation of security, holdings, and performance and transaction information from several sources. Eaton Vance receives vendor feeds related to security, ratings, issuer, issuer ratings, performance, price and analytics that needs to be extracted, transformed and loaded to Eaton Vance Financial data ware house. The goal of the project is to centralize security setup and make sure accurate data is available for making valuable and timely decision for its clients. Involved in multiple PACE projects ALADDIN, CALVERT, CODERED, DFI, RIMES, NEXT SHARES, Ladder Manager and Fund Of Fund, building database solutions, performance tuning, bench mark report to measure performance within asset management.
Responsibilities:
Communicate effectively with systems teams and business users.
Involved in complete life cycle of the application from design phase to deployment for building custom solution interfacing Eagle Pace with vendor feed from Aladdin.
Identifying and automating solutions for repetitive production issues.
Performed performance tuning of extracts that go against Eagle Pace data ware house repository using awr, addm and ash utilities.
Worked with data architect to enhance existing data model to support integration with IBOR project.
Developed fund of fund extract that implements bulk collections, table partitions (large ledger tables with about 500million rows), dynamic SQL’s and oracle supplied DBMS packages.
Developed EV Fund Investment Holdings extract for Risk group that implements materialized views, table partition, hierarchical queries and parallel processing.
Developed Eagle Pace Exporters, Eagle Pace Loaders, Eagle Pace Data Model, SRM, Eagle Pace Data Mart, Eagle Star, OLAP/Advance report, implement solution to support data needs of Performance measurement product, Performance Analytic reports and understanding of Eagle Pace data requirements to develop custom extracts.
Extensively worked on enterprise job scheduling products like CA’s workload automation ESP edition.
Provide technical support to system once in production and provide faster and timely resolution.
Worked on EAGLE-PACE version upgrade from 12.0 to 13.0.
Redesigned and refactored existing Eagle Pace source code for better performance.
Environment: Oracle 11g, SQL Loader, PL/SQL Developer, Visio 2010, Eagle Pace Version 12.0, 13.0, UML, Perl, Unix Shell Scripting, ETL tools
Transition Manager
Project: Ladder Manager Integration
Responsibilities:
Communicate effectively with systems teams and business users.
Led design and development of robust scalable and secure electronic data interchange between Transition manager and Ladder Manager Interface.
Led database design and development to integrate internal ratings to performance database.
Provide technical support to system in production.
Extensively worked on enterprise job scheduling products like CA’s workload automation ESP edition.
Support large scale initiatives to transition programs from svn to git hub repositories.
Environment: C#, Oracle 11g, SQL Server Management Studio ver 12.0, CA ESP application, SQL Loader, PL/SQL Developer, Visio 2010, Eagle Pace Version 12.0, 13.0, UML, Perl, Unix Shell Scripting, ETL tools
Project: Eagle Pace – CODERED (FACTSET) Integration Project
Responsibilities:
Communicate effectively with systems teams and business users.
Designed scalable and robust solutions to integrate Pace and CODERED – Fact set systems.
Developed extract transform and load programs to bring in data from EAGLE PACE database to CODERED system that after processing is sent to Fact set system.
Designed and developed multiple interfaces and reports in CODERED to support business needs.
Environment: C#, Oracle 11g, SQL Server Management Studio ver 12.0, CA ESP application, SQL Loader, PL/SQL Developer, Visio 2010, Eagle Pace Version 12.0, 13.0, UML, Perl, Unix Shell Scripting, ETL tools
Transition Manager
Project: Perform (Investor Tools) – Transition Manger integration Project
Responsibilities:
Communicate effectively with systems teams and business users.
As a developer wrote stored procedures using SQL server management studio.
Extract EV internal rating from corner stone and load to perform MSRB database.
Wrote jobs to schedule load data to perform database.
Designed and developed multiple interfaces and reports on perform application to support business needs.
Environment: C#, Oracle 11g, SQL Server Management Studio 12.0, CA ESP application, SQL Loader, PL/SQL Developer, Visio 2010, Eagle Pace Version 12.0, 13.0, UML, Perl, Unix Shell Scripting, ETL tools
10/10 – 7/13 ESPN, Bristol, CT
Oracle Developer
Project: Sports Data Repository Database (SDR)
The Sports Data Repository (SDR) database and its related services provide the vast majority of real-time sports data for ESPN broadcasts and digital media. SDR also is the database upon which the core Stats & Analysis (S&A) user applications are built.
Responsibilities:
Communicate effectively with systems teams, testing team and business users.
Evaluate solutions and redesign business processes as necessary.
Involved in complete life cycle of application development from design phase to deployment for NHL, NBA, WNBA and College basketball part of SDR project.
Developed NHL play-by-play applications that includes most in-depth statistics and content interfacing it with SDR database allowing the creation of industry-leading box scores, shot charts and textual play-by-play descriptions.
Wrote Oracle stored procedures, triggers, functions and packages to generate statistics like Player and Team Statistics in NHL, Detailed Statistical split that included Home and away, wins losses, and more.
Worked on ESPN SDR Front end tools like In-game tool and Pre-Game Manager written in C# and Oracle PL/SQL that support Stats and Analysis team to provide accurate Box Scores, Schedules, Results, Standings and more.
Worked with Industry’s leading sports analysts and mathematicians to develop ESPN QBR rating application which values a quarter back on all play types and calculates the QBR rating in a scale of 0-100. EPA’s calculated include Pass EPA, Run EPA, Sack EPA, Penalty EPA, Total EPA, Act EPA, CW Avg and much more.
Provide technical support to system once in production and provide faster and timely resolution.
Resolved bugs and fix it for smooth performance, also used bug tracking tools like JIRA.
Extracted data from ESB (Elias) schema to SDR database after performing technical analysis for data extraction using Erwin, also did Data Modeling, Data Mappings and table design.
Wrote programs to generate xml clobs that would be queued to Oracle Queue’s which in turn would be consumed by third party applications. XML Spy tool was used to validate XML‘s against its XSD definitions.
Designed and developed NBA, WNBA and College Basketball play-by-play applications that include most in-depth statistics. Other features of the application include standings, shot charts, box score and much more.
Worked with various groups that include stats & analysis group, digital media, and development team within ESPN for smooth transition of NBA and WNBA applications to production and college basketball to UAT.
Adaptable to changing priorities and have the ability to quickly get things done and “figure it out” with minimal requirements and guidance.
Environment: C#, Oracle 11g, SQL Loader, PL/SQL Developer, Erwin, UML, Visio 2010
9/09 – 9/10 Credit Suisse LLC, Raleigh, NC
Oracle Developer
Project: Operational Financial Control (OFC)
Operational Financial Control is a global reporting tool to provide Month-End Reporting for purchase order Accruals and Deferrals, Travel and Entertainment expenses. Purchase Orders, voucher payment and other data (FX rates included) are received on a daily basis when the system is in open status. Users have the option to drill down to underlying procurement from a Purchase Order reference by clicking a hyperlink. This enables review of expiring PO’s and on time renewal if applicable. Main objective of system is to provide Month End Accrual and Deferral (ME AD) calculations. Other important reports include MEAD reports, PO by Functional area, Requested PO Closure and Glad Journals. Informatica was used to extract data from multiple source systems to OFC database.
Responsibilities:
Communicate effectively with systems teams and business users.
Involved in complete life cycle of the application from design phase to deployment.
Wrote Control M jobs to automate data extraction from Travel &Expense feeds to OFC base tables for reporting purposes and developed T&E reports specific to OFC as per User requirements.
Developed PL/SQL Stored procedures in Oracle10g for processing data and populating staging table for reporting purposes.
Developed shell scripts in UNIX to migrate oracle stored procedures to production and QA.
Worked on tools like SQL Loader to load data and SQL Navigator, PL/SQL Developer ( as client ) for designing SQL Statements, checking explain plan and other database operations.
Developed Informatica mappings and transformations (Joiner, Router, Aggregator, Expression, and Update Strategy) to extract data from multiple systems.
Build mapplets, worklets and reusable transformations to handle reusable logic.
Wrote test plans for data load.
Worked with business users for design, development and ongoing changes to financial reports.
Provide technical support to system once in production, and provide faster and timely resolution.
Resolve the Bugs and Fix it for smooth performance.
Managed source code for each releases using Visual Source Safe.
Performed Unit test & Documentation of system.
Environment: PL/SQL, Oracle 10g, Informatica 8.1/7.1/6.1, Erwin, C#, NET Framework 2.0 and 3.5, Visual Studio 2005/2008, JavaScript, HTML, Windows, Unix
Project: TIME @ SYSTEM
Time@ system provides tracking of time spent on Credit Suisse activities that include projects, applications, infrastructure, administration and management. Approved timesheets are sent to TAR application nightly using Control M. Worked as Oracle developer to enhance existing Time @system for product Control and Private Banking.
Responsibilities:
Communicate effectively with systems teams and business users.
Understand architecture of existing application and make enhancements as per business requirements.
DDL Changes modified existing stored procedures, Complex queries, Packages, triggers and views.
Developed PL/SQL Stored procedures for extracting data from project server feeds in Oracle10g for processing data and populating staging table for reporting purposes.
Worked on tools SQL Loader and Modified Control M Jobs to load data, Used PL/SQL Developer (as client) for designing SQL Statements, checking explains plan and other database operations.
Resolve Bugs and Fix it for smooth performance during UAT.
Performed Unit testing in Development environment.
Environment: C#, ASP.NET, JavaScript,.NET Framework 2.0 and 3.5, Visual Studio 2005/2008, XML, XSLT, HTML, XML, Oracle 10g, SQL Loader, PL/SQL Developer, Erwin
Project: CATI
CATI is the repository for strategic planning of Credit Suisse IT. It provides one global, structured and organized platform which allows product dependencies and linking applications to their infrastructure, finding systematically target areas to advance enterprise strategically identifying functional business redundancy.
Responsibilities:
Communicate effectively with systems teams and business users.
Understand architecture of existing application and make enhancements as per business requirements.
Modified existing stored procedures, queries, packages, triggers and views for enhancing CATI Data mart to sync up with upgrades to CATI application release 10.3.
Developed PL/SQL Stored procedures in Oracle10g for processing data and populating staging table for reporting purposes.
Wrote shell scripts in UNIX to deploy/migrate pl/sql code to production and qa environment.
Modified existing control M jobs as well used SQL Loader to load data, PL/SQL Developer ( as client ) for designing SQL Statements, checking explain plan and other database operations.
Developed Informatica mappings to extract data from multiple systems.
Build mapplets, worklets and reusable transformations to handle reusable logic.
Resolve Bugs and Fix it for smooth performance.
Extracted and Loaded data from Planning IT feeds to CATI Data Mart Staging and base tables.
Performance Tuning and Unit test.
Environment: SQL Server 2005, UNIX, Oracle 10g, SQL Loader, Informatica 8.1/7.1/6.1, Erwin
5/04 – 7/09 Fidelity Investments, Boston, MA
Software Engineer
Project: Financial Accounting & Billing Systems (FABS)
Financial accounting and Billing System is to integrate financial processing for financial suite of billing applications. The project addresses creation of new applications as well as modifications and integration with existing applications. Reports that were generated include Décor File which is an electronic file that is sent to DACOR system to generate check or EFT payments to carriers. It contains credits that are live payments. Accounts payable financial extracts were generated that would enable carriers to reconcile the EFT or check payment they receive from DACOR. Other financial reports included actual premium, employee stock plans, and employee contribution reports for salaried, retiree populations. Integrated suite of applications includes Accounts Payable, Accounts Receivable, Payroll, Oracle Advanced Benefit, and HRMS.
Responsibilities:
Communicate effectively with systems teams and business users.
Designed architecture and communicated progress and other general project development activities.
Involved in complete life cycle of the application from design phase to deployment.
Created database design, developed PL/SQL stored procedures, Complex queries, Packages, triggers and views for Oracle database.
Worked on tools like SQL Loader to load data, SQL Navigator & TOAD (as client) for designing SQL Statements, checking explain plan and other database operations.
Contributed to data warehouse design and development of financial reports, parallel processing large volumes of data in Oracle10g.
Worked with cross functional teams to achieve common goals.
Design and Development of Universe and Reports and created Cardinalities, Contexts, Joins and Aliases for resolving Loops.
Developed UNIX shell scripts to migrate code to production and qa environments.
Used Informatica to load data from existing vendor applications.
Worked on various issues on existing Informatica Mappings to produce correct output.
Documented all the changes made to the Universes and Reports for future references.
Environment: Oracle 10g, SQL Loader, TOAD, UNIX (IBM AIX), Informatica 8.2/7.1/6.1,Universe Designer, Web Services, Visio, UML
5/03 – 4/04 Delloite and Touche, Austin, TX
Software Consultant
Project: Texas Integrated Eligibility and Redesign System (TIERS)
System integrates application process for health and human services program. Project involved redesigning and replacing existing legacy system to be rolled out to multiple sites within the country. This replaced many legacy systems including 30 year old SAVERR (System of Application, Verification, Eligibility, Referral and Reporting system (SAVERR), with a single integrated system.
Responsibilities:
Involved in Architecting, designing and developing Application.
Participated in requirement gathering JAD Sessions, analysis and translating to object oriented design using RUP.
Design and implementation of executive reports, includes detail reports, mismatch reports and summarized reports.
Contribution to design of data warehouse and data marts using Oracle.
Developed technical solutions for data extractions, Data analysis, Data mappings, and table design from various DHS applications and updating it to TIERs database.
Developed stored procedures, Complex queries, Packages, triggers and views for Oracle database using PL/SQL.
Worked on tools like SQL Loader, Informatica to load data from existing proprietary applications.
Involved in support during the maintenance phase.
Created database objects like tables, indexes, triggers, views, and oracle stored procedures.
Wrote conversion programs to migrate data from legacy system to TIERS database.
Environment: C#, XML, XSLT, ADO.NET, Crystal Reports 7.x, HTML, CSS, JavaScript, PL/SQL, Oracle, UNIX, UML, IIS, Informatica 7.1/6.1
4/02 – 5/03 Daimler Chrysler, Auburn Hills, MI
Software Consultant
Project: Fleet Bid Accounts System
This project is aimed at supporting the owner base by profitable sale of vehicles to dealers who in turn sell or lease to state, local government agencies and utility/rail road companies. The application is modeled after Model View Controller architecture.
Responsibilities:
Involved in web development using HTML, JavaScript and ASP.net and Deployment.
Participated in JAD session to gather requirement, analysis and translating to object oriented design.
Analyzed and developed many functional and technical solutions after studying existing system at Chrysler.
Created .NET business components using Microsoft Visual Studio.
Created tables, stored procedures, views and triggers using Oracle Stored procedures.
Involved in creating Use Case, Class, Sequence diagrams and Component diagrams (UML) using Microsoft Visio.
Participated in system design and analysis.
Environment: C#, VB, Oracle, DB2, UML, IIS, JavaScript, HTML, Crystal reports, Visio
6/01 – 3/02 Delta Airlines, Atlanta, GA
Software Engineer
Project: TQAPM (Aircraft performance Monitoring and Engine Condition Monitoring Application)
Responsibilities:
Participate in project full lifecycle Design, Programming, Testing, and documentation.
Developed Components using Visual C++ and integrated with business services developed in Tuxedo ( C++ servers )
Developing reports using Crystal reports.
Responsible for writing stored procedures in oracle.
Wrote CGI applications that were used to extract data from Oracle database.
Environment: Visual C++5.0, HTML, JavaScript, Oracle, Tuxedo, C++, Visio 2000
EDUCATION:
Master’s Degree (Computer Science)
Contact this candidate