Software Engineer Sql Server

Ramkrishnan Sankaran

Contact Telephone: 408-***-****

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

SUMMARY

An excellent Microsoft MCAD certified software engineer with very good

exposure and understanding of technology, having more than ten years of

experience in the fields of system study, analysis, design and development

of Client Server, Internet and RDBMS applications. Proficient in Visual

Basic.NET, Visual Basic v3.0-6.0, ASP, Crystal Reports, Reporting Services,

SSIS, MS SQL Server, Sybase and Oracle. Possesses excellent leadership and

communication skills and is a motivated team player.

STATUS US Citizen

TECHNICAL SUMMARY

O/S: Windows 95, Windows NT4.0, Novell NetWare, WindowsXP

GUI: Visual Basic.NET, Visual Basic 5.0/6.0, Visual Basic Automation

Databases: SQL Server v6.5/7.0/2000/2005,SSIS, Oracle 7, MS Access, Sybase

6.03

Reporting Tools: Reporting Services, Crystal Reports

7.0/8.0/8.5/9.0/10.0/11.0, Excel Reporting.

Data Access Tools: ADO.NET, ADO 2.5, and RDO 2.0

Web Technology: ASP, HTML

Has acquired training on 21 CFR11 and ICH E6 guidelines.

EXPERIENCE SUMMARY

Symantec

Position: Reporting/Business Analyst (Consultant)

Oct 2009 to Present

> Working as an Analyst on the Customer Hub data integration (CDI)

solution that enables organizations to centralize information and

create a single view of customer information that can be leveraged

across all departments and systems.

> Communicating with the development team in India and providing them

with technical documentation about the reports to be created for the

project.

> Analyzing the data on the reports and provide feedback to the

developers about the logic to be programmed in the reports.

> Writing SQL queries to validate the data which shows up on the report.

> Interacting with other department leads to get the system in place for

our project to complete on time.

> Interacting with the business users and appraise them about the

reports and document their feedback.

> Create test cases and UAT documents for the business users to enable

the testing of the system.

Environment: Business Object XI, Toad for Oracle 10.0

LifeMasters Self Supported

Position: Reporting Lead

June 2007 to August 2009

> Produced enterprise wide client quarterly reporting using SQL Server

Reporting Services and creating a Data Mart from the Data Warehouse to

stage the data for these reports.

> Created the Monthly Clinical Key Performance Index using clinical

Indicator data both claims and self reported data of measures for the

current reporting period with a run off for the last 12 months and

analyzed the performance of these measures against the target and the

baseline values.

> Created self service business intelligence tools for the user

community with detailed parameters to reduce the request for new

reports to be produced.

> Created SSIS packages to automate reports. The package included

creating the report and then posting it to the FTP site and sending an

email with the completion of the report.

> Gathered requirements to create Client Reporting Portal which

contained on demand reports with 2D, 3D graphs for better clarity and

presentation. Created technical documents, system design documents,

user guides for the reports and manuals and imparted training to the

user community.

> Used MDX queries and cubes for reporting purposes and also used cubes

for creating reports using Reporting Services.

Environment: MS SQLServer 2005, Reporting Services, SSIS, Sharepoint,

Microsoft Excel Reporting, Visual Basic.NET, Win CVS, MS Team Foundation,

ProClarity

Synarc Inc

Position: Software Engineer

February 2003 to June 2007

> Involved in the design and development of data entry systems for

various clinical studies for different therapeutical areas like

Neurology, Oncology, Arthritis from prestigious clients like Pfizer,

MedImmune, Genovate etc.

> Created data entry forms using Teleform which were sent to the sites.

These forms were entered in to the database using OCR.

> Developed custom reports using Crystal Reports 10.0 and also created

reports and published it in Microsoft Excel. The reports were

developed in the Report Designer Component. The reports were generated

by building a SQL query and the result was populated through ADO

recordsets, which were passed to Crystal reports.

> Created technical documents, system design documents, user guides for

the reports and manuals and imparted training to the user community.

> Created Test scenarios to help the QA team come up with test cases to

validate the data entry system.

Has acquired training on 21 CFR11 and ICH E6 guidelines.

Environment: Microsoft Access, VB Automation, Sybase Adaptive Server

Enterprise 11.0, Crystal Reports 9.0, Active Server Pages, IIS 4.0, Cardiff

Teleform, WinCVS.

Sitar Santa Clara County, CA

Position: Consultant

Sept 2002 to Jan 2003

> Working with the Santa Clara County in implementing custom reports in

pre-packaged software called Change Point.

> Involved in design and development of the reports and implementing the

reports in pre-packaged software called Change Point. The reports were

designed using the Active Data Definitions and ADO recordsets were

passed to the reports at runtime. Active Server Pages were used to

create the user interface and also to display the report over the web.

Sub reports were used in the designing the reports and individual

recordsets were passed to the main report and all the sub reports at

run time.

Environment: Active Server Pages, IIS 4.0, Crystal Reports 8.5/ 9.0,

Microsoft SQL Server 2000, Visual Basic 6.0,Windows NT 4.0, Visual Source

Safe.

CMOS SOFT INC

Jan 1998 to April 2002

Worked as a Consultant of CMOS SOFT at the client.

Success Maker Internet

NCS Learn, Sunnyvale, CA

Oct 99 to April 2002 (Consultant)

> The reporting is done for teachers to know how well their students are

doing at their subjects and also parent reports helps the parents to

track their child's progress.

> Involved in the designing the complete framework for the reporting

needs of the client. Lead a team of 3 engineers to design develop and

implement the Reports for Success Maker Internet on the web.

> The reports are designed using Crystal Reports 8.5, Active data

definitions, Active Server Pages and IIS4.0. Sybase Adaptive Server

Anywhere 6.03 as the back end.

> There were more than 125 reports designed and developed.

Environment: Active Server Pages, IIS 4.0, Sybase 6.03, Crystal Reports

8.0, Windows NT 4.0, Visual Source Safe.

EDUCATION:

MCAD certification from Microsoft.

BS in Information and Technology from University of Phoenix 2005

BS in Commerce; Bombay University; India - 1991

Contact this candidate