Sql Server Data

Location:

Germany

Posted:

March 19, 2017

Contact this candidate

Resume:

Paul Samuel.K

***.*******@*****.***

848-***-****

PROFESSIONAL SUMMARY:

Over 6 years of IT experience in Design, Development and Maintenance of Database applications using SQL Server 2012/2008R2/2008/2005.

Expertise in scripting DDL, DML, T-SQL (Complex VIEWS, Stored Procedures (SP), Functions, Triggers and Indexes).

Good experience and understanding of Database Design, Relational Integrity Constraints, OLTP, OLAP and Normalizations.

Good Experience in Tuning SQL Queries by implementing Indexes and using Stored Procedures.

Good Experience in Extraction, Transformation and Loading (ETL) in SQL Server database using SQL Server Integration Services (SSIS).

Experience in Implementing Checkpoint, Transactions, Logging.

Experience in building Package Deployment and Package Configurations.

Good Experience in Creating and Scheduling Jobs for SQL Server Database and SSIS packages using SQL Agent.

Good experience as a Data Analyst with solid understanding of Data Modeling, Evaluating Data Sources and strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications.

Proficient in developing all types (Tabular, Matrix, List, Drill-Down, Drill-Through, Sub-Reports, and Chart Reports) of Complex Reports using SQL Server Reporting Services (SSRS).

Experience in Implementing Dynamic Grouping, Sorting & Page Breaking using SSRS Parameters.

Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.

Good Experience in Managing/deploying reports to both the modes/environments (SharePoint and Native-Report Manager).

Expertise in Subscribing Reports (Standard and Data Driven Subscription) using SSRS in both the modes (SharePoint and Report Manager).

Knowledge on Tableau reporting tool for visualization.

Expert in troubleshooting/resolving SQL Reporting services and SQL related issues.

Good Knowledge in SQL Server Analysis Services (SSAS) 2012/2008R2/2008/2005).

Used SSAS Cubes as data source for Reports Development.

Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down and Drill-through reports using SSRS.

Worked on Power BI and prepared dashboards using Tableau to make it more attractive.

Experienced in developing ETL packages using SSIS SQL Server Integrated Services.

Abilities to perform VB .NET programming, Experience of LAN administration

Excellent skills in PC Client/Server software installation and troubleshooting.

Extensive Knowledge on Microsoft .NET Design Patterns including Dependency Injection (DI), Inversion of Control (IOC), Singleton, MVVM and MVC.

Developed SSIS packages bringing data form various heterogeneous sources like:

Oracle, SQL server and OLEDB sources. Also did transformations like Execute SQL Task, Conditional Split, Merge, Lookup, fuzzy Lookup and Slowly Changing Dimension while loading the data into destination.

Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.

Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables

Very good experience in Installation, configuration and maintenance of SQL Server.

Performed Unit Testing for migrated procedures, functions and RDLs.

Experience in Software Development Life Cycle (SDLC) including requirements gathering, writing technical specifications and Production support/Maintenance Activities.

Proficient in developing SOAP and RESTful Web Services.

Experience in Object-Oriented Programming within networks as well as online applications

Self-starter and quick learner with strong analytical and problem solving and troubleshooting skills.

Good Experience in Agile Methodology and Water Fall Methodology

Good Experience in Logistics, Retail, Insurance.

EDUCATION

Bachelors in Engineering from JNTU, India.

Master’s in Computer science from Wilmington univ. DE, USA.

TECHNICAL SKILLS

BI Data Warehouse Tools: SSRS, SSIS, SSAS, Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, Sharepoint.

Databases: MS SQL Server 2012/2008/2005, MS Access, Oracle.

Languages: C,C++,HTML,XML,T-SQL,MYSQL,DHTML,VB.NET,JavaScript,.Net, PHP,PLSQL, VB script, Web Services, Python.

App. /Web Servers: IIS 5.0/6.0

Reporting/ETL: SSRS, SSIS, SSAS, Report Builder.

Platforms/OS: Windows 98/2000/2003/XP/NT/Vista, Windows 7

Version Control Tools: Team Foundation Server, SVN

Others: SQL Server Data Tools, BIDS, SQL Server Management, Studio, Visual Studio.Net 2005/2008/2010, Office 2005/2008/2010, FTP, Share Point 2007/2010, JIRA

PROFESSIONAL EXPERIENCE

HealthEC LLC, Piscataway, NJ Jan 2017 – Till Date

SQL/MSBI developer

HealthEC is a leading innovator in empowering the exchange of healthcare information, providing a complete end-to-end solution to manage Population Health. HealthEC provides knowledge, expertise and technology solutions to the healthcare industry to effectively and efficiently manage its community. HealthEC Population Health Management platform provides the flexibility to integrate all of the critical components of a Care Management program into a single integrated platform – from patient attribution through care coordination and analytics for payers, providers and employers.

Responsibilities:

Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).

Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.

Involved in ETL architecture enhancements to increase the performance using query optimizer.

Experienced in writing complex SQL Queries, complex Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes.

Created SSIS packages to create csv files and excel sheets.

Created global temporary tables in the Execute SQL SQL task and created reports based on the global temporary tables inside the data task flow.

Used Package Configurations to make the SSIS Package reusable in any server.

Used Execute SQL Task, Data flow Task, Sequence Container, For Each Loop Container, File System Task, Execute Package Task.

Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS/DTS using various features like data conversion etc.

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

Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.

Created SSRS reports like tables, matrix, charts, sub reports, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.

Created reports based on both cascading and standard parameters.

Created different Parameterized Reports (SSRS 2012/2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.

Designed and built cube using SQL server Analysis Services for salary analysis.

Worked on dimensional data modeling, dimensions and facts for OLAP cubes configured report server environment and deployed reports to the database.

Extensive experience in SSAS (SQL Server Analysis Services), Design and Developed cubes testing and Deployment/ Implementation.

Experience in writing complex MDX queries for calculated members and measure groups.

Environment: MS SQL Server 2012/2008/2005 Enterprise Edition,SSIS 2008R2, SSAS 2008R2, SSRS 2008R2, T- SQL, VSS, Windows Sever 2000/2003/2008, SQL Server Management Studio, SQL Profiler, Query Analyzer, MS Visio.

Ashfield Healthcare, Ivyland, PA Aug 2016-Jan 2017

SQL/MSBI Developer

Ashfield offers a wide range of world-class, market leading services that include medical sales teams, inside sales, contact centers, nurse educators, patient support programs, medical communications, medical information, meetings and events, market research, pharmacovigilance and training.

Responsibilities:

Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.

Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files. Created packages with different Control Flow options and Data Flow Transformations such as Conditional Split, Multicast, Pivot, Union All etc.

Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).

Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.

Involved in ETL architecture enhancements to increase the performance using query optimizer.

Implemented Event Handlers and Error Handling in SSIS packages.

Created SSIS packages for Data Conversion using data conversion transformation. Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.

Advanced extensible reporting skills using SQL Server 2012 Reporting Services (SSRS).

Worked in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).

Worked on dimensional modeling, creating cached reports, drill-down reports, linked reports, report snapshots, parameterized reports and report optimization Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012.

Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.

Coordinated with front-end for implementing logic in stored procedures and functions.

Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.

Involved in Normalization and De-Normalization of existing tables for faster query retrieval.

Involved in upgrading from SQL Server 2008 to SQL Server 2012. Migrated SQL server 2008 R2 packages to SQL Server 2012 SSIS packages using SQL Server 2012 Upgrade Advisor.

Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Environment: SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS),TSQL,C#, .Net framework, XML, MS Visual Source Safe and Windows Server 2003.

MasterCard, O’Fallon, MO Dec 2015 – July 2016

SQL Server Developer

MasterCard is a technology company and payments industry leader. For more than four decades, MasterCard have been a driving force at the heart of commerce, making the global economy safer, more efficient, more inclusive and more transparent for all. Consumers, merchants, business partners and governments in markets around the world have reaped the benefits of master card innovative products and solutions which, simply put, are designed to make life easier.

Responsibilities:

Writing TSQL, PL/SQL, stored procedures, functions and complex queries for migrating legacy Oracle 10g to SQL Server 2012.

Experience working in multiple projects both OLTP and OLAP (Data warehouse) databases.

Designed and developed SSRS reports exactly similar to the Crystal Reports (Migration of Crystal Reports to SSRS Reports).

Created complex Stored Procedures, SSIS Packages, Triggers, Cursors, Tables, and Views and other SQL JOINs and statements for applications.

Designed and development of SSIS (ETL) packages for Data Extraction, Transforming and Loading the data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data).

Responsible for Developing OLAP Cubes, Data Source View, Partitions of queries with MDX.

Migrating SSIS packages from SQL Server 2008 version to SQL Server 2012 version.

Experience in implementing Event Handlers, Checkpoints and Logging to maintain active SSIS packages.

Automating the SSIS packages execution through SQL Mail Agent jobs, scheduling the jobs adding notifications for success and failure.

Designed and Developed Drill-through, Drill-down, Cross Tab (Matrix) Reports and Sub-Report using SSRS.

Applying optimization techniques to improve the performance of the queries and taken care of performance issues across TSQL, SSIS and SSRS reports.

Optimized the performance of queries by Data Manipulations which includes modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins and created clustered/non-clustered indexes wherever necessary.

Implemented the Best Practices and Coding Standards for SQL Server, SSIS & SSRS.

Experienced working in Development, Testing and Production servers.

Environment: MS SQL Server 2008/2012, Oracle, MS SQL Server Reporting Services, SQL Server Integration services, ETL, Data Modeling, T-SQL, SQL Profiler, XML, MS Access, Excel

Starmark, Lake Forest, IL Nov 2014 – Dec 2015

SQL BI Developer

This client is a health insurance company headquartered in Lake Forest and providing health insurance service across several states. The data retrieved from the source was loaded to the data marts for report generation after implementing with the business logic in ETL.

Responsibilities:

Experience in Designing and modeling SQL Server Database, creating tables and views.

Writing TSQL, PL/SQL, Stored procedures, functions, views and common table expressions.

Designing and developing new SSIS (ETL) packages and enhancing existing SSIS packages.

Automating the ETL executing process through jobs and creating notifications for failure and success.

Created various SSIS packages for Daily run, Weekly run and monthly run for both incremental load data and fully load data to SQL Server, from Flat files or excel spreadsheet.

Experience in loading the data through Import, Export wizard activities in SQL Server for one time load.

Migrated SQL Server 2008 packages to SQL Server 2012 version.

Created Drill down, Drill through, sub reports through SQL Server Reporting Services and creating subscriptions for automating the process.

Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different retail locations.

Performed data analysis to generate various trend reports.

Generated Ad-hoc, matrix and tabular reports using SQL Server reporting services based on customer needs.

Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.

To set up SQL Server configuration settings for better server management.

Experience in using SQL Server Profiler & SQL Server Agent.

Experience in working Development, Testing and Production Database servers.

Specialized in Continuous Integration, DevOps and Service Orchestration practices

Experience in administrative tasks - Backups & Restoring the database, replicating the database.

Environment: MS SQL Server 2008/2012, Microsoft Visual Studio 2008, SQL Server Reporting Services (SSRS 2008), Report Manager, Report Viewer, SQLServer Integration Services (SSIS), Data Transformation Services (DTS), Oracle 10g, Toad, MS Excel

SunTrust Bank, Atlanta, GA Dec 2012 – Oct 2014

MSBI Developer

SunTrust Banks, Inc. is one of the nation’s largest and strongest financial holding companies. The company provides deposit, credit, trust and investment services to a broad range of retail, business and institutional clients.