Sql Server Data

SAJIN THANKACHAN

Email: ******@*****.***

Ph: 267-***-****

EDUCATION:

• Masters in Computer Applications

University of Madras.

technical summary:

Database: MS SQL Server 2008/2005/2000, Oracle 10g/9i/8i, Teradata, Progress, DB2, MS Access.

Languages: T-SQL, PL/SQL, C, C++, C#, Java, VB.net, Visual Basic 6.0,

SQL Server Tools: DTS, SSIS, SSAS, SSRS, BIDS, Query Analyzer.

Tools/Utilities: Visio 2010, Erwin, Toad, MS Office 2010, Informatica 7,8.1, Tivoli work Scheduler (Maestro), Visual

SourceSafe 2007, MS Share Point Server 2007, TFS.

Scripts: Korn, Perl, VB Script, Java Script

Web: ASP.net, XML, HTML, DHTML, WSDL, SOAP

Environment: Unix-AIX, HP-UX, Windows.

EXPERIENCE:

Accenture

Client: Bank of America, Plano, TX

Sr Data Integration Developer

11/2011- till date

• Served as Sr.Data Integration Developer for the Integration Team supporting the HLI Control Tower Data

Integration Project. Primary responsibilities included identifying functional and technical requirements, design,

development, enhancement and production support.

• Served as Report developer for the Integration Team supporting the reporting solutions. Primary responsibilities

included design, development, enhancement and production support.

• Worked with business stakeholders to support the ongoing changes to Default Workflow Application

Primary responsibilities included design, build and support for the administrative team.

• Performed code reviews for the Sql scripts, SSIS packages and SSRS reports prior to the Biweekly release.

• Responsible for automation of the existing manual process which includes converting the existing manual excel

reports to SSRS reports, Manual csv/txt file generation to SSIS packages.

• Performed performance tuning to the packages/stored procedures which pulls data from the different source

systems to the Data warehouse.

• Provided documentation for business requirements, technical design, Visio flow-charts, and business process

documentation in accordance with the official Bank of America project auditing procedures.

• Assisted team members and clients in addressing business demands. Peer reviewed team member designs,

testing methods, and implementations.

Environment: MS SQL Server 2008 R2, Oracle 10g,Teradata, Toad, IBM AS 400, SSIS, SSRS, SharePoint, Pega,

Salesforce, XML, Cognos,Jams Scheduler, Excel, Unix AIX.

Page 2

Centene Corporation (Nurtur Health)

Sr Data warehouse Developer

05/2011 to 10/2011

• Worked as a data warehouse developer to monitor the daily activates of the data load to the Data warehouse

• The duties includes conversion of manual process to fully automated process, normalizing the database, cleaning

up history files, rearranging using type II SCD, new SSIS Packages, Conversion of existing DTS to SSIS,

Scorecard Reports and SQL Agent Jobs.

• Performed cleaning and scrubbing process and monitored the data load for Incoming data files from different

clients using SSIS & SQL Server 2008 to the Data Warehouse.

• Redesigned the existing Stored Procedures to implement business changes and tuned the existing procedure as

well.

• Worked on new client implementations which includes creating data layouts and verify the transition files against

the against the data dictionary.

• Developed and Scheduled daily and weekly SQL jobs for maintenance and file processing.

Environment: MS SQL Server 2008 R2, SSIS,SSRS, T-SQL, Visual Studio 2010, BIDS, Excel, BIDS, Windows 2008

Server R2, SAP Business Objects.

National Business Research Institute, Plano, TX

Sr.SQL Server Developer

09/2010 to 04/2011

• Participated in the analysis and interpretation of data appropriate to ensure quality control, integrity, and

implemented dimensional measures for governance in support of the application using SQL Server 2008

• Resolved highly complex data related problems while developing effective partnerships with other team members,

business customers and other layers within the business to recommend, research, design, test, transform and

implement data related system and process improvements.

• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the

OLAP Reporting needs.

• Developed new web portal using ASP.net and C# for client interaction and report deployment.

• Created an ETL solution using SSIS that reads Survey response data from an FTP server into a SQL Server

database. The solution also validated incoming Data and performs notifications when jobs complete. The data

thus loaded into the SQL Server was used to generate reports and charts using SSRS 2008.

• Designed database Maintenance Plans to set up core maintenance tasks to make sure that the database

performs well, and is regularly backed up in case of system failure and is checked for inconsistencies.

• Utilized tools such as SQL Server Profiler, Activity Monitor, Performance and Reliability Monitor, Data Collector,

Policy-Based Management, Resource Governor, Event Notifications to monitor and ensure optimal performance

of SQL Server.

Environment: MS SQL Server 2008 R2, T-SQL, Visual Studio 2010, BIDS, SSIS, SSAS, SSRS, Excel, BIDS, .NET

3.5, ASP.net, C#, Crystal Reports 10, Windows 2008 Server R2, Microsoft Visio 2010,Subversion.

Nexus Software Solutions, Horsham, PA

10/2006-06/2010

Client: Pacer Global Logistics, Columbus, OH

SQL Server ETL/BI developer

10/2009-04/2010

• Gathered and organized data for analysis, and developed conceptual Model and Process Flow Diagram,

consulted with requestor and report group analysts to insure timely and accurate completion of report request.

Page 3

• Developed SSIS packages and Stored Procedures for data load from different databases such as Teradata,

Oracle, and legacy systems such as Progress, SQL 7.0, and MS Access and Performed Data Scrubbing and Data

validation checks during Staging.

• Work with production support team to deploy object/schema changes and ETL packages/processes in SSIS for

new and existing source data for the data warehouse.

• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.

• Monitored the existing Production Jobs (Daily, Weekly and Monthly) and performed necessary action for the failed

jobs.

• Performed data modeling, SSRS report subscriptions and data driven subscriptions, SSAS analysis services

processing tasks, cube processing and roles.

• Developed Schedule Documentation which helped the production team to deploy in sequence.

Environment: MS SQL Server 2008, T-SQL, Oracle 10g,AS400, Progress, Teradata, DB2, SSIS, SSAS, SSRS, Erwin

Suite, Microsoft Project, Microsoft Visio, Share point Server 2007,Visual SourceSafe, Excel, Team Foundation Server.

Client: Nationwide Insurance, Columbus, OH

SQL Server ETL/Reports Developer

10/2008-05/2009

• Performed Analysis on the existing System and Developed Logical, Physical & Dimensional Model & Architecture

for the Goal State PPC Project using Erwin and developed Application Design Document.

• Defined data sources and destinations for extracting, loading & migration of data, developed tasks for conversion,

cleaning, aggregating, merging, and copying data using SSIS.

• Developed SSIS packages to perform profiling against the incoming data from multiple sources and lookup the

web services application to find the GIS data which helped in finding the matching address and cleansed the

address which are statistically placed.

• Diagnosed problems using tools such as SQL Profiler and System Monitor. Performed Execution plans to trouble

shoot poorly executed queries, Monitored database systems performance, capacity and availability.

• Customized agency / role-based scorecard reports and simplified reporting with flexible portal integration,

developed different Home Owners Policy reports and deployed on Microsoft Share Point sites.

• Scheduled maintenance tasks to monitor overall database performance, as well as design stored procedures and

views that generate report files.

• Assisted QA in developing Test cases & Test Plans and Performed System testing and Integration Testing

• Ensured Best practices and performed user training as well.

Environment: MS SQL Server 2005, T-SQL, IBM Mainframe, UNIX- AIX, VB.Net, SSIS, SSAS, SSRS,

DTS,MOSS(Microsoft Office Share point Server), XML, XSLT, Erwin, Visio, Excel.

Client: Bank of America, Addison, TX

Database/ETL Developer

09/2007-07/2008

• Understood the Business flow from different environments by studying existing stored procedures and enhanced

the stored procedures according to the present business needs.

• Defined data sources and destinations for extracting and loading data; transformations for cleaning, aggregating,

merging, and copying data; a management service. The Integration Services service, for administering Integration

Services; and application programming interfaces (APIs) for programming the Integration Services object model.

• Performed high performance data integration solutions, including extraction, transformation, and load (ETL)

packages for data warehousing using DB2,SQL Server 2005 and Informatica 8.1.

• Developed a multitude of new tasks, looping structures, and transformations and also improvements in package

deployment, management, and performance improvement.

• Optimized the performance of queries, eliminated redundant data, and created indexes whenever necessary.

• Edited the existing Perl programs and added the functionality according to the latest table changes occurred due

to the business changes and used environment variables.

• Created Job definitions and Schedule definitions in Maestro for scheduling the Informatica workflows, Perl and

Korn scripts.

Page 4

• Involved in all 22 System Integration Testing (Sit) events of Project More, updated the test results and checked the

data counts in the source and target against the log table and updated the spreadsheet.

• Worked on the documentation, edited the HLD and LLD to include the additional changes made later and created

run books for the schedules which helps recovering if it fails in production.

Environment: DB2, SQL Server 2005,IBM Mainframe 3278,Oracle9i,Unix AIX, VPN, FTP, BIDS, XML, MDX, Erwin,

Maestro, Perl, Korn, Informatica 8.1, Excel

Client : Hewlett Packard, Houston, TX

Data Warehouse Developer

11/2006 to 06/2007

• Created logical and physical database design, data structures, and implemented large databases using Erwin.

• Performed automation of day to day uploads by cleansing the received data from different environments

and uploading it into the Oracle using Informatica 8.1

• Applied schema change scripts to existing objects to synchronize with changing business rules by adding or

enhancing relevant entities/tables, columns etc.

• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraints and

triggers for data consistency.

• Created/developed/maintained the stored procedures, triggers to interpret complex business rules, history data

and audit analysis.

• Coordinated all system test plans; participated in the system testing; performed system upgrades, patches and

point releases as necessary.

Environment: Oracle 9i, Microsoft Business Intelligence Studio, T-SQL, XML, Erwin, PL/SQL, Java, VB.Net, .Net

Framework,XML,SOAP,WSDL, Business Objects XI,Korn, Perl, HP-UX, Maestro.

SESCO, Alkhobar, Saudi Arabia

Programmer Analyst/System Admin

07/2002 to 08/2005

• Gathered requirements, created functional specification documents, detailed design documents and developed

the whole module of deployment of Materials Management.

• Designed the user interface using Visual Basic 6.0 and generated reports using Crystal Reports.

• Prepared software design, development and support for new client systems and performed technical

documentation.

• Performed enhancement and support of applications involving Visual Basic 6.0 and Oracle 8.0, troubleshooting

and software/technical support for existing clients.

Environment: Oracle 8.0, Visual Basic6.0, XML, Crystal reports 8.0, ODBC, Foxpro2.5, Windows 2000.

Contact this candidate