Data Developer

VARGHESE V. PALATHARA

**** ***** ***** **.

Missouri City Houston 77459

Cell: 832-***-****

Mail : acvj5f@r.postjobfree.com

SUMMARY

I have over 15 years of total experience and over 12 years experience working on MS SQL Server utilizing Transact-SQL (DDL, DML), Views, Stored Procedures, function and Triggers.

Experience in Extraction Transformations and Loading (ETL) tools like Data Transformation Services SSIS.

Experience in designing complex reports including sub reports and formulas with complex logic using SQL Server Reporting Services (SSRS).

Experience of RDBMS. Database design issues like Normalization and De-normalization.

Extensive experience in performance tuning, query optimization and statistics.

Involved in design, coding, testing, quality assurance and production support in most of the projects.

Translate the functional requirements into technical requirements and performing development tasks to complete solution.

Good understanding of End user req. analysis and full Software Development Life Cycle (SDLC) with QA Has worked with complete software development life cycle, analysis, design, development, testing and delivery (SDLC).

TECHNICAL SKILLS

Languages: T-SQL, PL / SQL, VB, C#, VB6, Power builder 7 & 6, Oracle forms, Cobol & Clipper

Database: MS SQL 2014 / 2012 /2008/R2 / 2008 / 2005 / 2000, Oracle 11i & MS Access,

Salesforce.com.

Server: Window 2003/ 2000 / NT / Novell Netware / Unix

Applications & Tools: Visual Studio 2005/2008/2013/2015, VSS, Data Modeling, SSIS, SSRS, Power Pivot, Share point & DAX.

Design Design Database and its objects, Create Reporting Service objects and create SSIS objects and its modifications and updates (like a mid level DBA)

EDUCATION

Degree in Statistics, Gandhi University, India

Bachelor in General Law from Bombay University.

Post Graduate Diploma in Computer Science, Datamatics Bombay

TRAINING

Computer Programming on Cobol, Indian Institute of Computer System

CERTIFICATION

Certification in VB.Net from Houston Community Collage, USA

PROFESSIONAL EXPERIENCE

Champion Energy Services Oct. 2015 - Still

Working as Sr. Business intelligence developer/Data Analyst (Consultants )

Role: T-SQL Developer / SSRS / SSIS

Environment: T-SQL / SSIS / SSRS 2005/2008 R2/2012/2014

Responsibilities:

Analysis, design and develop SSIS packages as per requirements.

Convert user requirements in to SSRS Reports.

Modify existing SSIS packages and SSRS reports.

Create adhoc queries for users for their immediate requirements.

Reverse engineering the SQL Code for the performance.

Automation of Excel VBA reports in to SSIS packages.

Performance tuning and Query optimization.

Refactoring existing SP’s, Views & Functions.

Using iSigma & Salesforce applications.

SSIS Performance tuning (hours long SSIS packages in to couple of minutes jobs).

Design and develop database and its objects, deploy SSIS jobs and SSRS subscriptions.

Done Vender log data file load on parallel processing as incremental data load.

Daily report automation with data driven subscription that send the report to upper management basis of values.

HP Houston April 2015 – Sept. 2015

Working as Business intelligence developer ( Consultants )

Role: T-SQL Developer / SSRS / SSIS

Environment: T-SQL / SSIS / SSRS 2005/2008 R2/2012/ORACLE DATABASE/ PL SQL

Responsibilities:

Create or modify SSIS packages.

Analyze data and write SQL code to pull the data.

Write and troubleshoot T-SQL code / SSRS Reports / SSIS Package.

Create adhoc queries for users for their immediate requirements.

Reverse engineering the SQL Code for the performance.

Performance tuning and Query optimization.

Refactoring existing SP’s, Views & Functions.

Load data for dashboards and historical data analysis.

Belmont Village Feb 2015 - March 2015 (short term Project)

Working as Reporting Analyst / BI ( Consultants )

Role: SQL Developer / SSRS / SSIS

Environment: T-SQL / SSIS / SSRS 2005/2008 R2/2012

Responsibilities:

Write and troubleshoot T-SQL code / SSRS Reports / SSIS Package

Convert Crystal Reports to SSRS Reports.

Performance tuning and Query optimization .

Refactoring existing SP’s, Views & Functions.

Universal American Dec-2012 - Jan 2015

Working as Reporting Analyst / BI developer

Role: T-SQL / SSRS / SSIS / PowerPivot - Developer / SharePoint

Environment: T-SQL / SSIS / SSRS 2005 / 2008 R2 /2012 / Power Pivot / SharePoint / BIDS /SSAS

Responsibilities:

Write and troubleshoot T-SQL codes / SSRS Reports / SSIS Packages / Code review

Design and create ETL processes using SSIS to import data from external sources and also retrieve data to be send to internal and external users

Performance tuning and Query optimization .

Refactoring existing SP’s, Views & Functions.

Understand BRD or user requirements and create or modify the reports, AHQs or Dashboards.

Create reports for Government Audit purposes as per the government guide line from facets.

Money Management International (MMI) Jan-2012 – Sept 2012

Working in Data conversion project with Money Management International. (Data Migration Project)

Role: SQL Developer / SSRS / SSIS

Environment: T-SQL /SSIS /SSRS 2008 R2

Responsibilities:

Write and troubleshoot SQL code and design (stored procedures, functions, tables, views, triggers, indexes, constraints etc.)

Design and create ETL processes using SSIS to import data from external sources and also retrieve data to be send to internal and external users

Data Migration from different data source and daily night batch processing.

Data cloning for test users.

Performance tuning and optimization of Stored Procedures.

Refactoring existing SP’s, Views & Functions.

Create Reports using SSRS as per the requirements.

BP April 2011 – December 2011

Worked in GCRO project in BP for Microsoft Project. (Data Integration Project)

Worked as Data Analyst consultant, loading different research structured data (Oil spills in gulf of Mexico ) from different research agencies to BP Data Warehouse.

Role: Database Developer / ETL

Environment: MS SQL 2005/2008 R2, SSRS 2008 R2/2005, SSIS 2008 R2

Responsibilities:

• Design and create ETL processes using SSIS to import data from external sources and also retrieve data to be send to internal and Data Warehouse.

• Generate different Preload and Post load reports.

• Generating Missing Valid values.

• Developed Complex quires, SPs, functions and Views.

• Extraction, transformation and Loading of Data using SSIS Packages.

• Processing, manipulating, cleansing data before migrating to development environment.

• Generate QA data, Data forensic and load statistic.

• Create various reports using SSRS like Auditing, QA/QC, statistics etc.

Academy Sports September 2010 Mar 2011 Working in E-Commerce project with Academy. Doing E-Commerce Product data

Reviews/Enhancements/Reporting

Role: Database Developer / SSRS / SSIS

Environment: MS SQL 2005/2000, SSRS 2008/2005, SSIS 2005

Responsibilities:

Writing Optimized procedure, Function, View and Triggers.

Developed SPs, Views for SSRS to generate expected business reports for client.

Extraction, transformation and Loading of Data using SSIS Packages.

Data Staging from different data sources through SSIS and Linked Servers.

Processing, manipulating, cleansing data before migrating to production.

Sending data from staging to different production data sources.

Create Jobs and batch processing.

InvescoAIM December 2009 – August 2010

Role: SQL Developer / BI Developer

Environment: VB6, VB.Net, MS SQL 2005/2000, SSRS 2008/2005, SSIS 2005, SSAS

Responsibilities:

Created the Stored procedure, Function, View and Triggers in Development stage.

Wrote Optimized stored procedure.

Used SSIS to migrate data from different sources to 2005.

Upgraded required stored procedures from SQL 2000 to SQL 2005 with ANSI compatible.

Extensively used the built-in services for SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Extraction, transformation and Loading of Data using SSIS Packages.

Modified existing data warehouse with SP & cube.

Developed stored procedures & used SSRS to generate expected business reports for client.

Modification of existing front end applications developed in VB6 & VB.Net.

Agility Project Logistics January 2009 – Nov 2009

Role: SQL Developer / Business Intelligence Developer

Environment: VB6, VB.Net, MS SQL 2005/2000, DB2/ AS400, SSRS 2008/2005, SSIS 2005

Responsibilities:

Team member in Database design team, actively involved in the database creation using the Normalization techniques.

Created the Stored procedure, Function, View and Triggers in Development stage.

Wrote Optimized stored procedure

Used SSIS to migrate data from SQL 2000 to 2005.

Extensively used the built-in services for SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Developed accurate and efficient ETL processes based on business requirement.

Extraction, transformation and Loading of Data using DTS Packages.

Developed stored procedures & used SSRS to generate expected business reports for client.

Modified existing front end application developed in VB.Net.

Shell, Houston, Texas Aug. 2007 – November 2008

Role: SQL Developer / Report Developer

Environment: T-SQL, SSIS/DTS, ETL, MS SQL Server 2005 / 2000, VB.Net, .Net 2005, Financial Objects Applications, SSIS, SSRS, Business Intelligence Development Studio & Quality Center.

Project: Energy Credit Projects

Description: Worked with Shell Trading as IT Consultant, of their Energy Credit Projects for Shell Trading Gas & Power and STUSCO - Oil, Natural Gas and Power.

Responsibilities:

Worked extensively on T-SQL, Reports and Data loads for Shell Trading.

Did extensive modification of existing VB, VB.net application modules.

Responsible for writing stored procedures, Views and User defined functions for handling business logic and functionality of Energy Credit Applications.

Worked on analyzing and performance tuning on ad-hoc queries by looking at the Indexes, Appropriate joins and Execution plans using Query Analyzer, SQL joins, sub queries, usage of Table Variables etc.

Created and modified T-SQL ad-hoc quires for Reporting.

Did ETL Loads using SSIS/DTS packages from various data sources.

Gained business knowledge of Energy Trading.

ARC Cooperative Insurance Co September 1997 – March 2007

Role: Programmer Analyst /SQL DBA

Environment: Visual Studio.Net 2005, VB.Net 2005, WinForms, ASP .Net 2005 (Intermediate level), Clipper 5x, Crystal Reports, Visual Basic 6, Power builder 6 & 7. Databases: MS SQL 2000, Oracle 9I & PL SQL, MS Access, Oracle Form

Responsibilities:

Designed and developing applications for the requirement of an insurance company such as Insurance Quotation, Underwriting, Claims, Reinsurance, HR and Payroll for Administration.

Extensive use of Client/Server Programming with VB6, VB.Net, MS SQL Server 2000, and Oracle 9i with Forms and report with Crystal Report, Excel Spreadsheet and Lotus Spreadsheet

Maintained current business applications, systems and related procedures.

Developed application in Power Builder 6 for insurance claims.

Analyzed, design, coding, debugging, testing and problem solving of application programs.

Designed tables, defining entities and table relationships, developing triggers, stored procedures, and views, performance tuning queries, increasing DB response time and throughput.

Implementation of Network, Server configuration, Network Connection, User Creation, User rights, permission and password in Windows NT network.

Controlling the Data Backup in various format and different places.

Business Intelligence Report like Business Operation, Forecasting, Multidimensional Analysis etc.

Citizenship: US Citizen

Volunteer Memorial Herman Hospital – South West

Contact this candidate