Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

Richard Christian

Mississauga,ON

Summary

12 Years of strong IT experience as a software developer and 2 years of Strong experience as a Lead developer handling team of 3 developers. Proficient in Database development and have intermediate experience of 3 years of working on scripting languages like python. Strong experience of complete Software development life cycle including, requirement gathering, development, Unit Testing, Integration testing, stress testing, production deployment and post production support. Extensive experience of Daily scrum calls with clients and team for understanding the requirements and creating Jiras to be assigned to internal resources and external partners. Proficient in Database Normalization, Optimization and Tuning, Data Import/Export, Troubleshooting, and Database Objects authorization. Strong knowledge of Enterprise Data Warehousing and Data Mart in OLTP/OLAP environment. Extensive experience of working with Transact-SQL (DDL and DML) for data Analysis. Proficient in creating Index, Views, Complex Stored Procedures, appropriate functions, and effective experienced in implementation of strong referential integrity and auditing using triggers and SQL Scripts. Expert in creating reports using SSRS (SQL Server Reporting Services), Crystal Reports and Business Intelligence Development Studio. Intermediate knowledge of using Scripting languages like python for data analysis. Have worked on python 2.x , 3.x and libraries like Pandas and Numpy. Excellent communication skills, analytical skills, understand business requirements in various domains. Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem-solving skills.

Overview

18
18
years of professional experience

Work History

Application Developer Lead

CITI Group
05.2018 - Current
  • Currently working as Global lead for Market risk calculation module for bonds and derivative products and responsible for developing and maintaining SDLC from end to end
  • Working with Business in understanding existing RISK structure, understanding calculation of risk measures for derivative products, and integrating it in current platform
  • Using Jira for planning work from clients and managing and delegating development work with direct reports and matrix partners
  • Have good understanding of first order derivative products like Swaps and second order derivatives like options
  • Having scrums calls with internal team and external partners to track progress of projects with assigned Jira
  • Working on SQL server 2014 on creating complex stored procedures, functions, views, index for creating reports from the warehouse
  • Experience of Working on OLTP and OLAP systems
  • Good experience of working with Analysis service cube
  • Experience of working on python 2.7 and python 3 for reporting and internal calculating risk engine
  • Have created modules using python and pandas to compare large datasets
  • Worked on libraries like Pandas and Numpy
  • Worked on creating adhoc reports for clients using python 2.x, 3.x
  • Proficient in using GIT and Bitbucket for version control
  • Taking responsibility for development, testing, unit testing, stress testing and preparing code to be migrated to production
  • Working on debugging production issues
  • Experience of working with large datasets in CSV and XML formats
  • Experience of code analysis and P2P review for production deployment
  • Working with Agile methodologies and tools such as JIRA, Confluence and GitHub
  • Experience of managing team of 3 direct reports and cross platform partners on project basis
  • Project Environment: Microsoft SQL Server 2014/2016, Python 2, python 3, Pandas, Anaconda, Git, Jira

Sr. Sql Server Developer

Exsilio Consulting
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
  • Involved in Planning, Defining and Designing database on business requirement and provided documentation
  • Implemented SSIS Package (ETL) to Extract and Transform data from Oracle RDBMS using SSIS 2012
  • Working on Creating packages to extract data from different applications like CALM, Pledge in form of Flat File or CSV and to Load into Staging Database
  • Creating documentation for Mapping and working with mapping teams to migrate the databases
  • Worked on Version controlling system as Tortoise SVN
  • Created Transformation packages using Merge Joins, lookups, fuzzy groupings etc
  • Used Error handling to handle errors in SSIS
  • Worked on Performance tuning of Stored Procedures and SSIS Packages
  • Experience of deploying Integration project in system, UAT and Stress environments creating environment variables
  • Performed integration and regression testing on products pending release
  • Used ALM for Defect Tracking
  • Used Jira for Project Management
  • Worked on creating and handling SSIS Jobs using Autosys
  • Project Environment: Microsoft SQL Server 2012, Visual Studio professional 2012/ 2010/2008, SQL Server Integration Services (SSIS) 2010, SSDT, Toad for Oracle, Jira, Tortoise SVN, Autosys

Sr. MS SQL Developer/Engineer Consultant

UPS Ramsey
07.2013 - 01.2016
  • Developed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints
  • Created and modified complex stored procedures, complex views and indexes based upon Detail design and Business requirements diagram
  • Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software
  • Developed DDL and DML triggers and CTE
  • Designed queries using merge statements, joins and functions
  • Performed performance tuning of stored procedures and queries using execution plan, SQL profiler and database engine tuning advisor
  • Created SSIS Packages to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Server
  • Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column Using SSIS
  • Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to DW systems and scheduled Jobs to call the packages and Stored Procedures
  • Used C# to create script tasks for migrating data and creating simple webforms
  • Wrote T-SQL queries, Store Procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data
  • Performed performance tuning of SSIS packages
  • Designed, Developed and Deployed tabular and matrix reports in MS SQL Server environment using SSRS
  • Created parameterized and drill down reports for better visualization of reports
  • Created reports to retrieve data using Stored Procedures that accept parameters
  • Created SQL agent jobs for smooth and timely running of the SQL projects
  • Involved in creating web forms using C#
  • Worked on front end screens and DALs
  • Involved in backing up stored procedures, views, and packages on version manager tools like TFS
  • Project Environment: Microsoft SQL Server 2012, Visual Studio 2010, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Visio 2007, Microsoft Project 2003, Windows 7/Vista/NT/XP /2003/2000/98, Windows2000 Advanced Server

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
06.2006

Skills

  • MS SQL Server 2016
  • MS SQL Server 2012
  • MS SQL Server 2008
  • MS SQL Server 2008R2
  • MS SQL Server 2005
  • DTS
  • SSIS 2012
  • SSIS 2008
  • SSIS 2005
  • SSAS 2012
  • SSAS 2008
  • SSAS 2005
  • SSRS 2012
  • SSRS 2008
  • SSRS 2005
  • T-SQL
  • Python 2x
  • Python 3x
  • Jira
  • Teamcity
  • Udeploy
  • Bitbucket

Languages

Timeline

Application Developer Lead

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

Bachelors - electrical engineering

Sardar Patel University

Master’s - computer science

New York Institute of Technology
Richard Christian