Summary
Overview
Work History
Education
Skills
Timeline
Generic

Richard Christian

Mississauga,ON

Summary

Application Development Sr. Manager at CITI Group with 14 years of experience in risk management, database design, and data analysis. Demonstrated success in optimizing performance and leading cross-functional teams. Proficient in SQL and Python, with a strong focus on Agile methodologies, resulting in enhanced risk calculation modules and improved project delivery.

Overview

19
19
years of professional experience

Work History

Application Development Sr. Manager

CITI Group
Mississauga, Ontario
05.2018 - Current
  • Direct global initiatives for market risk calculation module targeting bonds and derivative products, ensuring comprehensive SDLC management from inception to completion
  • Engaged with business teams to evaluate current risk structures and identify improvement areas.
    Integrated calculated risk measures for derivative products into existing systems.
    Facilitated discussions on enhancing risk management practices across platforms.
    Assessed and refined methodologies for deriving risk metrics in product offerings.
  • Utilize Jira for organizing client work and overseeing development tasks with direct reports and matrix partners
  • Conducting scrum calls with internal teams and external partners to monitor project progress with assigned Jira
  • Translated business requirements into technical specifications for data streams and integrations.
  • Defined data flows across organization, identifying data generation and consumption points.
  • Developed modules using Python and Pandas for large dataset comparisons.
  • Created ad-hoc reports for clients utilizing Python 2.x and 3.x.
  • Debugged production issues to ensure system reliability and performance.
  • Managed team of three direct reports and cross-platform partners on project basis.
  • Executed development, testing, and code preparation for production migration.
  • Utilized GIT and Bitbucket for effective version control management.
  • Collaborated in Agile environments using JIRA, Confluence, and GitHub.
  • Conducted code analysis and peer-to-peer reviews for production deployment.

Sr. Sql Server Developer

Exsilio Consulting
Ahmedabad , Gujarat, India
06.2017 - 02.2018
  • Created and updated complex Stored Procedures, Triggers and User Defined Functions for logical T-SQL implementation
  • Developed Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database
  • Created and run Sub-reports, Drill-down reports, Matrix or Crosstab reports and Summary reports in SSRS
  • Managed Report Security by using SSMS
  • Connect to Reporting Server and set different roles and different security level to different users
  • Designed Data Warehouse and Database for the system using Star Schema which includes Tables, Stored Procedure and Indexes in SQL Server Management Studio
  • Created SSIS packages for incremental loading from PMS system to enterprise data warehouse
  • Worked on Cleansing and Scrubbing of data using SSIS and stored procedures for reporting and analysis service
  • Scheduled and maintained every mid-night and weekly load data by creating corresponding job task by SQL Server Agent in SSMS
  • Achieved significant performance improvement by migrating reports from C# to stored procedures
  • Implemented partitions on a large dataset as well as index functions using SQL Server 2012 resulting in 90% improved performance
  • Used TFS for Version Control and Project Management
  • Used SQL Server Profiler for tuning report queries and improve performance in SQL Server
  • Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements
  • Worked on Enterprise deployment and weekly deployment
  • Scheduled backups and restores of databases
  • Documented the development work
  • Project Environment: Microsoft SQL Server 2012 Enterprise Edition, SQL Server Management Studio(SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) Business Intelligence Development Studio(BIDS), Microsoft Visual Studio 2012

Sr. MS SQL SSIS Developer Consultant

JP Morgan Chase
03.2016 - 05.2017
  • Planned, defined, and designed databases based on business requirements with comprehensive documentation.
  • Implemented SSIS ETL packages to extract and transform data from Oracle RDBMS using SSIS 2012.
  • Created packages to extract data from applications like CALM and Pledge in flat file or CSV format for staging databases.
  • Collaborated with mapping teams to document migration processes effectively.
  • Utilized Tortoise SVN for version control of project files.
  • Developed transformation packages utilizing merge joins, lookups, and fuzzy groupings for data processing.
  • Executed error handling protocols within SSIS to manage data discrepancies.
  • Optimized performance of stored procedures and SSIS packages through rigorous testing.

Sr. MS SQL Developer/Engineer Consultant

UPS Ramsey
Jersey City , New Jersey
07.2013 - 01.2016
  • Developed and reviewed primary objects, including views and indexes, based on design models and requirements.
  • Created complex stored procedures, views, and indexes aligned with detailed design specifications.
  • Optimized indexes, SQL queries, and stored procedures to enhance software performance.
  • Engineered DDL and DML triggers along with common table expressions (CTE).
  • Designed queries utilizing merge statements, joins, and functions for efficient data handling.
  • Executed performance tuning of stored procedures and queries using execution plans and SQL Profiler.
  • Generated SSIS packages for data transfer from various sources to SQL Server.
  • Applied data transformations such as Slowly Changing Dimensions and Aggregates within SSIS packages.

Junior Programmer

Avtar Pvt Ltd
12.2006 - 11.2009
  • Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2000 using DTS Packages
  • Created complex stored procedures and functions for integrity checks of transferred data
  • Performed unit testing and SQL performance tuning
  • Helped provide end users with the ability to access and utilize the data stored in the data mart
  • Tuned SQL statements Using Indexes and stored procedures
  • Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries
  • Involved in implementation and maintenance of disaster recovery solutions such as replication and log shipping
  • Was responsible for query optimization using MS SQL tools such as Query Analyzer, SQL Profiler and index tuning wizard

Education

Master’s - computer science

New York Institute of Technology
NY, NY
12.2012

Bachelors - electrical engineering

Sardar Patel University
VV Nagar, Gujarat, India
06.2006

Skills

  • Risk management and analysis
  • Agile project methodologies
  • Database design and development
  • SQL programming and ETL
  • Version control systems
  • Performance optimization
  • Technical documentation skills
  • Client engagement strategies
  • Team collaboration techniques
  • Cross-functional leadership
  • Troubleshooting and resolution

Timeline

Application Development Sr. Manager

CITI Group
05.2018 - Current

Sr. Sql Server Developer

Exsilio Consulting
06.2017 - 02.2018

Sr. MS SQL SSIS Developer Consultant

JP Morgan Chase
03.2016 - 05.2017

Sr. MS SQL Developer/Engineer Consultant

UPS Ramsey
07.2013 - 01.2016

Junior Programmer

Avtar Pvt Ltd
12.2006 - 11.2009

Master’s - computer science

New York Institute of Technology

Bachelors - electrical engineering

Sardar Patel University

Similar Profiles

CREATE PROFILE
Richard Christian