Data Developer

Monish Varghese Joshy

Summary

Almost ** years total experience within the IT industry as an expert Business Intelligence developer (SQL/SSIS/SSRS/SSAS) in Product development, Application Development, and Data Warehousing.

Expert in T-SQL query development skills, advanced performance tuning and query optimization.

Almost 10 years of Data Analysis experience in various domains like Financial, Healthcare, Retail, Mortgage, Communications and Insurance etc.

Created various ETL applications using SSIS to load the data from different sources, transform the data according to the business logic and load into different destinations.

Worked in various data migration projects.

Proficiency in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.

Expertise in developing ETL applications using SSIS.

Strong in Data warehousing, Operations Data Store concepts, data marts.

Worked on the entire software development life cycle (SDLC) including analysis, design, programming, testing and documentation.

Strong MS SQL Server 2014/2012/2008/2008R2 Developer Skills including writing Stored Procedures, User Defined Functions, Views, Query writing.

Thorough understanding of the Software Development Life Cycle (SDLC), involved in various phases such as requirements, analysis/design, development and testing.

Experienced in Business case development and presentations for senior Leadership.

Immigration status: US Citizen

EDUCATION

Master’s in data science, Regis University, Denver, Colorado (Online pursuing)

Bachelors of Electronics Engineering, V.T.U, Karnataka, India.

Bachelor of Computer Science, Kerala University, Kerala, India

TECHNICAL SKILLS

• SQL Server/T-SQL

• SSIS Packages /Lavastorm/Informatica for ETL.

• SSRS Reports.

• SSAS Cubes.

• Data Modeling (ER Studio, Erwin).

• Oracle, MySQL, PostgreSQL.

• R Programming, Python, Statistics for Data Science.

• C#, VB, Java, JSP, HTML, CSS

PROFESSIONAL EXPERIENCE

Client: Direct Energy

Duration: September 2018- Now

Implementation partner: TCS

SSIS/T-SQL Developer

Houston, TX

Project Name: Data Migration for HWA/DEPP

Responsibilities:

Loading Source Data from Oracle into SQL Tables to load into Microsoft AX.

Fetch the Source data from Oracle, perform data cleansing, transformation before loading into the final destination tables.

Created SSIS Packages for each entity that includes Customer Bank Account, Vendor Bank Account, Subscription billing, Sales Partner etc.

Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data load, transformation and extraction.

Employer: Larson & Toubro Infotech

Duration: Feb 2017 - July 2018.

Client: Crum and Forster

SSIS/T-SQL /Oracle-PLSQL/Python/SSRS

Morristown, NJ

Project Name: Claims to IEV / Premium and Claims to Sapiens

Responsibilities:

Loading Data from Claims which is in Oracle, convert into Acord XML and do incremental load into IEV XTM database. Making sure the data goes smoothly from XTM database into TDS and from TDS into ODS.

Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data load, transformation and extraction.

Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases

Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables.

Wrote T-SQL queries, created dynamic Stored Procedures by using input values.

Loading the accord xml from the Oracle CA into IEV XTM using script task (C#.NET).

Extracting Data from AS400 and loading into Sapiens using SSIS Package.

Extracting Data from Claims and loading into Sapiens using SSIS Package.

Create SSIS Package according to the business requirement to process claims and policy information into Sapiens database.

Created SSIS package to find exceptions after loading claims and wins file into SSIS, then email the file to different team members of Sapiens team.

Worked extensively on Data Analysis to solve the bugs created by business Analysts when they see the data is wrong.

Extract the policy data, claims data from many sources like Flat files, Excel/CSV files, different relational Databases like Oracle, SQL Server etc. and load into different destinations for analyzing the data, finding trends and insights for the Client organization.

Worked with Data Scientists and learnt Data science hands on from senior Data Scientists of the company.

Client: ABMS-ABIM

Project Name: ACCME/ LDDANS

T-SQL/SSIS Developer

July 2016- Nov 2016.

Responsibilities:

Involved in the design and development of ACCME SSIS Package that loads Addition/Modification/Deletion of Modules and the information we receive from ACCME.

Created Stored procedures to replace legacy application with Oracle PL/SQL and T-SQL Stored Procedures.

Involved in the design and development of LDDANS SSIS Package for loading Dans Data into Oracle Database from ABMS portal.

Involved in the modification of other SSIS Packages like LDABMS, AMA etc.

Guided the scrum team for the successful completion of many projects.

Involved in the performance tuning of SQL stored procedures, SSIS Packages etc.

Involved in analyzing the data, and fix the code when the data doesn’t match the business requirement.

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 T-SQL statements Using Indexes and stored procedures.

Employer: Cognizant Technology Solutions

Duration: Jan 2015 - July 2016.

Project Name: CDW

Client: CVS Pharmacy

TSQL/SSIS

(Remote)

SSIS/SQL

Responsibilities:

Involved in the design and development of CDW Database for data migration from HCN Oracle database which belongs to Coram since CVS merged with Coram.

Managed all indexing, debugging, optimization and performance tuning using SQL Profile and SQL Server Agent.

Effectively used views to prevent unauthorized access.

Tuned SQL queries using execution plans for better performance.

Designing, Modeling CDW using ER studio.

Created 1 Master package, 1 Receipt package, 14 validation packages, 14 loading packages, 1 archival package and 1 acknowledgment package using Visual Studio Data tools.

SSIS packages will dump flat files in shared location called outbox, from where our package would pick up the files, place in Inbox folder from where each validation package would load corresponding file in the staging database.

I have developed stored procedures to perform file validation, record validation and look up validation on the records loaded from flat file into the staging database. If records are not good or not having the correct data type, we will load those records into the corresponding record validation or file validation or look up error table, good records are then finally loaded into final destination tables in CDW.

I have also implemented logging to log the errors into flat file, also used package configuration, variables and expression to make the packages dynamic.

I have also successfully implemented error handling using event handler.

Involved in performance tuning and optimization.

Involved in FTP ing HCN Files from a network location to another location and loading into staging table.

Environment: SQL server 2012, Visual Studio Data Tools, MS Office 2007/2010.

Project Name: Data Integration Hub

Client: NationStar Mortgage

Irving, TX

T-SQL developer/SSIS/SSRS/Data Analyst/Data Modeler

Responsibilities:

Involved in the design and development of EDW (Enterprise Data ware house).

Involved in the analysis and reverse mapping of EDW to the source serving system which are front end application: LSAMS, TMO, LPS, ISIGHT, Equator (SS, DIL, REO) using Gap analysis.

After GAP analysis I created a document containing pseudo code of mappings for each columns of the destination tables directly from source system eliminating intermediate databases like Adhoc databases and other Reporting Data warehouses.

Monitoring the automated loading processes.

Involved in performance tuning of existing stored procedures by using execution plan making use of optimization techniques.

Modified existing stored procedures to remove dependencies to Adhoc databases and reporting Data warehouse so as to establish EDW as single source of truth which is directly linking to the source.

Involved in Data analysis to ensure the correctness of data w.r.t business logic and user requirements.

Involved in creating daily jobs, monthly jobs using SSIS package to populate Daily, Rolling, Monthly tables.

Involved in Planning, Defining and Designing data based on business requirements and provided documentation.

Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.

Designed SSIS Packages to transfer data between servers, load data into database; Scheduled the jobs to do these tasks periodically.

Created various SSRS reports like drill down, drill through, tabular reports etc.

Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.

Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers.

Environment: SQL server 2012, Visual Studio Data tools, ER Studio.

Employer: Hexaware Technologies

Duration: Jun 14 – Jan 2015

Project Name: CTR

Client: Alliance Bernstein

White Plains, NY

T-SQL /SSIS/Pearl/ XML/Javascript /Unix/SSRS

Responsibilities:

Involved in Production support.

Involved in creating various complex stored procedures, views, functions, triggers, tables etc.

Involved in reverse engineering using ER studio.

Created Stored procedures to load raw data into xraw tables, then filters out bad data using temporary tables and then loads to raw tables, and from the raw tables, finally good records will be loaded to Allocation and Block trade tables.

1 Block will have one or more allocations, if there is cancelled trade, then original trade should be loaded first.

For equity trades, cancelled and rebooked trades will be in one file.

Created documentation on the all the tables, stored procedures, views and user defined functions.

Debugging to find errors occurred while loading data from OMS to CTR which is in sql server.

Loaded Trades Obtained from State Street in CTR within the UNIX environment.

Involved in Testing of data obtained in CTR for accuracy.

Involved in debugging and testing stored procedures, functions, views, triggers during production support.

Developed various stored procedures, views, functions, triggers in CTR and performed unit testing.

Co-ordinated between different support teams for ensuring the AB advantage access to end users.

Created Indexes on Tables and worked on performance tuning of some stored procedures.

Environment: T-SQL, SQL server 2012, Aqua Studio, Visual Studio, ER studio, Putty, MS Office 2007/2010, MS Access, Pearl, SVN, UNIX.

Employer: Sark Technologies

Duration: Sep 2012-May 2014

Project Name: General Ledger Reporting Data warehouse

Client: Ernst & Young

T-SQL developer/Data Modeler/SSIS

Responsibilities:

Involved in Planning, Defining and Designing data based on business requirements and provided documentation.

Developed Logical and physical data model using ER Studio and mapped the data into database objects.

Occupied in Logical, Physical design and Development of the Reporting Data Model for the Database and using ER Studio

Developed complex logical and Physical data model using ER studio.

Designed General Ledger Reporting Data ware house using ER studio.

Developed complex Views for different visualization for Spot fire reports.

Worked extensively on query optimization and performance Tuning.

Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries.

Created documentation on the all the tables, stored procedures, views and user defined functions.

Created ETL packages with different data sources (SQL Server, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS.

Experienced in creating package dynamics by using SSIS transformations and variables.

Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.

Developed logging for ETL load at the package level and task level to log number of records processed by each package and each task in a package using SSIS.

Environment: T-SQL, SQL server 2012, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio, Erwin, Windows XP, MS Office 2007/2010, MS Access, Oracle.

Project Name: HMRS

T-SQL Developer/ Data Modeler /SSIS

Responsibilities:

Involved in Planning, Defining and Designing data based on business requirements and provided documentation.

Developed Logical and physical data model using ER Studio and mapped the data into database objects.

Occupied in Logical, Physical design and Development of the DSR (Data Staging Repository) for the Database and HMS (Health Management Reporting System) using Erwin.

Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, and Views.

Successfully implemented indexes on tables for optimum performance.

Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data load, transformation and extraction.

Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.

Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008 R2.

Employer: Amstor Softech, Technopark, Kerala, India

Duration: Feb 2008 - Jul 2012

T-SQL developer/SSIS/Data Modeling/SSRS report/ Java/ JSP/HTML developer

Responsibilities:

Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs.

Developed Logical and physical data model using ER Studio and mapped the data into database objects

Wrote complex stored procedures to process prospective customer information and balanced the processing load between front end and back end.

Enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2008 R2.

Worked with Oracle Server to extract, load information of Customers.

Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.

Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2008 using SSIS Packages.

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.

Ensured best practices are applied and integrity of data is maintained through security and documentation.

Created various SSRS reports like drill down, drill through, tabular reports etc.

Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.

Deployed and Subscribe Reports using SSRS to generate all daily, weekly, monthly Reports.

Environment: MS SQL Server 2008r2, T-SQL, Erwin7.3, Query Analyzer, Index Tuning wizard, SQL Profiler, SSIS.

Contact this candidate