Software Engineer Ms Sql
Resume:
SABU CYRIAC
Email: ************@*****.***
Phone: 608-***-****
EXPERIENCE
15+ years of experience in end-to-end project life cycles as a developer and consultant.
Strong expertise in SQL Programming, Performance & Query Tuning, Data Migration and Error Handling.
Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
Expertise working with very large volume of data/transactions, complex interdependent processes and SQL optimization techniques.
Expertise in VB 6.0, SQL, C#, VB.NET, Crystal Report technologies.
Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS.
Hands on experience using SSAS and SSRS.
Experience in Microsoft Visual C# in script component of SSIS.
Defining data warehouse (star and snow flake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services (SSAS).
Has good knowledge about US Health care concepts.
Has good knowledge on HL7 (currently working on migrating the connectivity code (HL7) from VB to C#).
Implemented Object Oriented Design concepts (OOPS) using C#.
Proven ability in requirement analysis, understanding client needs and strong technical skills for developing robust, scalable solutions.
Excellent interpersonal and team management proficiency with the ability to get projects completed on schedule.
Good at client relationship management and have been successful in developing new business through work excellence.
Well versed with MS Excel (Macros using VB scripts), MS Project, JIRA (issue tracker), VersionOne and CaliberRM.
Good understanding on Agile Scrum and Kanban methodology.
Good understanding of Cerner Discern Explorer.
TECHNICAL SKILLS
Programming Languages
VB.Net, C#, C++, VB 6.0, T-SQL, PL/SQL, XML, SQL, CCL, PowerShell 3.0, VB Script
Application Framework
.Net, MVC, SOA.
Development Tools
MS Office, Internet Explorer, Adobe, MS Project, MS Visio, Eclipse, Version Control, Visual Studio, CaliberRM, Rational Clear Case, AccuRev.
Project Methodologies
Waterfall, Agile, Scrum, Kanban.
Databases
MS Access, MS SQL Server.
ETL Tools
MS SQL Server Integration Services (SSIS)
Reporting Tools
Crystal Reports (8,10,XI), Objects, MS SQL Server Reporting Services (SSRS) & MS Access.
Operating Systems
DOS, Windows
EDUCATION
Bachelors in Science, Mahatma Gandhi University, India (3 year program, 1997).
Pre-University in Physics, Chemistry and Math, Mahatma Gandhi University, India (2 year program,1994)
Professional Diploma in Network Centered Computing (3 yrs) - GNIIT (3 year program, 2000)
PROFESSIONAL WORK EXPERIENCE
Consultant – Trishulla LLC, WI, USA July’17 – till date
Summary of Duties:
Created packages included a variety of transformations, for example Slowly Changing Dimensions, Lookup, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
Write and review database scripts (DDL/DML).
Handled Performance Tuning and Optimization on SSIS.
SQL Performance & Query Tuning, Data Migration and Error Handling.
Supporting the existing legacy systems by using VB 6.0.
Designed and developing custom reports by using SSRS component.
Development and deployment of SSIS packages for data migration and integration submitted the data by various means such as xls, csv, txt, and dat.
Environment:
Environment: C#, VB 6.0, C++, MS SQL, MS Visio, SSIS, SSRS.
Senior Software Engineer – Cerner Corporation, Bangalore, India Feb’15 – June’17
Summary of Duties:
Extracted data from Hospital Information Systems and Ancillary Systems like Siemens EDM and PICIS, transforming the data if required and populating the institution database.
Created packages included a variety of transformations, for example Slowly Changing Dimensions, Lookup, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
Write and review database scripts (DDL/DML).
Handled Performance Tuning and Optimization on SSIS.
Development and deployment of SSIS packages for Health Care data migration and integration. Health care providers submit the data by various means such as xls, csv, txt, and dat.
SQL Performance & Query Tuning, Data Migration and Error Handling.
Lead for the Connectivity Code Migration from VB to C# and migrated around 300000 lines of code from VB to C#.
Spiking the migration model and designed the common framework.
Creating the COM interoperability.
Environment:
Environment: C#, VB 6.0, C++, MS SQL, MS Visio, SSIS, SSRS and CaliberRM.
Consultant – Siemens Medical Solutions, Malvern, USA Feb’14 – Feb’15
Summary of Duties:
Analyze requirements & technology.
Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
Unit Testing.
On-Call Support (Investigate & Fix errors).
Write and review database scripts (DDL/DML).
Performance & Query Tuning, Data Migration and Error Handling.
Created stored procedures to build Fact tables in data mart for Multi-Dimensional analysis using (SSAS).
Development and deployment of SSIS packages for Health Care data migration and integration. Health care providers submit the data by various means such as xls, csv, txt, and dat.
Environment:
C#, VB 6.0, VB.Net, C++, MS SQL, SSIS, SSAS, MS Visio and CaliberRM.
Module Manager – Siemens Information Systems Ltd, Bangalore, India July’10 – Feb’14
Summary of Duties:
Analyze requirements & technology.
Design and Development of the System.
Porting existing Tools from VB to C#.
Write and review database scripts (DDL/DML).
Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
Created packages included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
Handled Performance Tuning and Optimization on SSIS.
Actively participated in project planning, estimation and resource allocation.
Environment:
C#, VB.Net, VB, C++, MS SQL, SSIS, SSRS, SSAS, MS Visio and CaliberRM
Consultant – Siemens Medical Solutions, Malvern, USA Feb’09 – June’10
Summary of Duties:
Analyze requirements & technology.
Design and Development of the System.
Creating database objects like tables and procedures.
Unit Testing.
On-Call Support (Investigate & Fix errors).
Performed and fine-tuned Stored Procedures and SQL Queries and User Defined Functions.
Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
Environment:
C#, VB.Net, VB 6.0, C++, MS SQL, MS Visio and CaliberRM
Associate Consultant – Siemens Information Systems Ltd, Bangalore, India Dec’07 – Feb’09
Summary of Duties:
Analyze requirements & technology.
Design and Development of the System.
Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
Unit Testing.
Investigate & Fix errors.
Support Activities.
Environment:
VB.Net, VB 6.0, C++, MS SQL, MS Visio and CaliberRM
Senior Software Engineer – Siemens Information Systems Ltd, Bangalore, India
(from S2 Infotech Pvt Ltd, Bangalore. India) Jan’06 – Dec’07
Summary of Duties:
Analyze requirements & technology.
Design and Development of the System.
Write and review database scripts (DDL/DML).
Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
Unit Testing.
Investigate & Fix errors.
Support Activities.
Environment:
C#, VB 6.0, C++, MS SQL and Crystal Report XI
Consultant – Siemens Information Systems Ltd, Bangalore, India
(from System Logic Solution Ltd, Bangalore. India) Apr’05 – Dec’05
Summary of Duties:
Design and Development of the System.
Creating database objects like tables and procedures.
Performed and fine-tuned Stored Procedures and SQL Queries and User Defined Functions.
Developing reports using Crystal Report.
Unit Testing.
Environment:
VB 6.0, MS SQL and Crystal Report 10.0
Technical Leader – JMJ Software Solutions, Bangalore, India Apr’02 – Apr’05
Summary of Duties:
Analysis, Design and Development of the System.
Creating database objects like tables and procedures.
Performed and fine-tuned Stored Procedures and SQL Queries and User Defined Functions.
Developing reports using Crystal Report.
Technical Consultant.
Supervising the onsite implementation & providing production support /user training.
Leading a team of developers and giving technical assistance.
Environment:
VB 6.0, MS SQL, MS Access and Crystal Report 10.0
Software Engineer, TVS Motor Company Ltd, Mysore, India Apr’01 – Mar’02
Summary of Duties:
Analysis, Design and Development of the Internal Software’s using VB 6.0 and Access.
Member of the SAP implementation team.
Creating database objects like tables.
Maintaining already developed packages using C, Unify & UNIX like Payroll System, Financial Management System, Indirect Material & Budgetary Control System.
Writing Shell scripts for taking reports from Payroll System, Financial Management System, Indirect Material & Budgetary Control System.
Environment:
VB 6.0, MS Access and Crystal Report 8.0
Software Engineer, El’en Infotech Pvt. Ltd., Bangalore, India July’00 – Mar’01
Summary of Duties:
Design and Development of the System.
Installation and Administration of software includes Windows NT Server, Visual Studio, and Microsoft Office
Environment:
VB 6.0, MS Access and Crystal Report 8.0
Contact this candidate