Rajeswari Varre

Immigration Status: Green Card E-Mail: hnp5nq@r.postjobfree.com

|Summary |

Around 8 years of extensive experience in business process engineering and

software development with expertise in Analysis,

Design, Development and Implementation and

Maintenance of software applications and Data

Warehouse.

Microsoft Certified Professional and my areas of Certification is Microsoft

SQL Server 2008 Business Intelligence Development and

Maintenance.

Proven Track Record of providing Business Intelligence Solutions in SSIS,

SSAS, and SSRS.

. Developing the SSIS Packages, Debugging and Error Handling in SSIS,

Deploying and Configuring SSIS Packages, Administering, Securing and

Executing SSIS Packages.

. Developing SSAS Cubes, Extending SSAS Cubes, SSAS Storage, Processing

and Deployment, Securing and Administering SSAS cubes.

. Developing SSRS Reports, Extending and Deploying SSRS Reports,

Scheduling and Securing Deployed Reports and Data Sources. Configuring

and Administering the SSRS Server.

Extensive hands on experience in Business Analysis and development of

Microsoft applications/solutions using ASP.NET

3.5/4.0, .NET Framework, C#.NET, VB.net, XML, WCF,

WWF, ASP, Visual Basic6, VBA, Oracle, SQL server,

MYSQL, XML, XSL, XSLT, ADO.NET, SSRS, SSIS, SSAS,

Informatics, Oracle Discoverer, Cognos, BizTalk 2006

and well trained in SAP ABAP & Cross Applications.

Proven knowledge in using the ETL tool called Informatica 8.1.1 across

multiple

Databases.

Excellent working knowledge in building queries for reports using Cognos.

A solid understanding of the Team Foundation Server 2008/2010 architecture

and components. Experience managing project

artifacts with TFS version control and configuring

and using work item tracking.

Experience in maintaining the version control using Visual Source Safe

2005.

. Strong knowledge of Software Development Life Cycle, Testing

Methodologies and Techniques

. A solid base in gathering and documenting user and business process

analysis and business requirement

. Knowledge in Utilizing information architecture and systems analysis

techniques to support content development/maintenance needs of the

global content model

. Experience in process modeling using Use Cases, Sequence Diagrams, and

Collaboration diagrams, Activity Diagrams, Class Diagrams and Data

Modeling.

. Involved in writing Test Plans, Test Cases for the applications

related to Client Server and Web Based Technologies.

. Analytical, methodical, and resourceful approach to problem solving,

identifying root causes and taking corrective actions to meet short

and long-term business, financial, and system requirements.

. Coordinate and participate in Plan of Action and Milestones (POA&M)

meetings.

. Excellent verbal and written communication skills. Adept in written

correspondence, reports, implementation requirements, project status

reports, oral presentations, e-mails.

. Strongly self-motivated, willing to assume responsibilities, and

able to work independently or work within a team environment.

. Customer-focused mindset with proven track record of meeting and

exceeding goals and expectations.

. Effective communication across both technical and non-technical

audience to synchronize the testing efforts.

. Strongly believe in making the Dream to create the Future come true

by suggesting and implementing modern ways of automating things.

|Training / Achievements / Certifications |

Microsoft Certified Technology Specialist in Microsoft SQL Server 2008,

Business

Intelligence Development and Maintenance.

Best Team Member award From ThermoFisher Scientific

Trained in .NET from Pearl Technologies, Hyderabad.

Diploma in Embedded Systems from Accel IT Academy, Chennai.

Business visit to Histogenetics Inc, US in 2007

|Education |

Master of Computer Applications with GPA 8.6 /10

University Rank Holder in B.Sc. Physics

Gold Medalist for Securing School First Rank in 10th grade

|Skill Set: |

Web Technologies ASP.NET, .NET Framework 2.0/3.5/4.0, C#.NET, jQuery, Web

Services, WCF, WWF, XML, XSL, XSLT, VB.NET, ASP,

HTML, DHTML, Java Script, VB Script, Java, Linq to

SQL.

Business Intelligence SSIS, SSAS, SSRS using SQL Server 2005/2008

GUI Visual Studio 2005/2008/2010, Visual Basic 6.0, Visual InterDev6.0,

Crystal Report 9.0.

Version Control Systems Team Foundation Server 2008/2010, Visual

Source Safe 2005 and Vault.

ERP SAP-ABAP

ETL Informatica PowerCenter 8.1.1, Oracle

Discoverer, Cognos

Web Servers IIS 6.0, Personal Web Server

RDBMS Oracle 9i, SQL Server 2000, SQL Server 2005, MySQL,

MS-

Access

Database interfaces ODBC, ADO, DAO, ADO.NET

Reporting Tool Oracle Discoverer 4.1

MS Office Tools MS Office 2000/2003/2007, Visio, Macros and

VBA.

Knowledge in DB Triggers, Stored Procedures, User Defined

Function, Backup

and Restoration of Database, Scheduling

Jobs/Services,

reporting tools, Query Analyser, Query Optimizing,

Indexing,

DataModeling and Performance tuning.

|Experience in detail |

ATI Allegheny Ludlum, Vandegrift, PA

.NET\SQL Developer - August 2011 to Current Date

ATI Allegheny Ludlum (NYSE: ATI) is a world leader in the

technology, production and marketing of specialty materials - stainless

steels, grain-oriented electrical steels, titanium and nickel alloys, as

well as other advanced alloys with revenues of $5.2 billion for 2011. ATI

has approximately 11,400 full-time employees world-wide who use innovative

technologies to offer growing global markets a wide range of specialty

metals solutions. Our major markets are aerospace and defense, chemical

process industry/oil and gas, electrical energy, medical, automotive, food

equipment and appliance, machine and cutting tools, and construction and

mining.

|Role and Responsibilities |

. Significantly worked on Web Applications throughout the SDLC using

ASP.NET, C#.NET using .net framework 3.5/4.0 with SQL Server

2005/2008. Providing Production Support and Project Management.

. Efficiently delivered the Business Intelligence Solutions in SSIS,

SSRS and SSAS using SQL Server 2005/2008 for business demands to

perform ETL, access/view the information and to make decisions based

on analyzing the data warehouse in the form of Cubes.

. Technical Leader for various projects thereby assuming and taking

responsibilities in bringing up new technology aspects/advantages into

the existing systems and provide Client Interaction and satisfaction.

. Performance tuning for various View(s)/Stored Procedure(s) in SQL

Server 2005/2008.

. Worked extensively with Web Services, Linq to SQL, Windows

Communication Foundation and Windows Workflow Foundation, XML, XSLT.

. Good knowledge in understanding and using the Team Foundation Server

2010 architecture and components for team builds and administration.

Also, using VSS for some of the old applications.

. Hands on experience in using Attunity software that enables access,

sharing and distribution of data across heterogeneous enterprise

platforms, organizations, and the cloud.

. Worked on DDL, DML, T-SQL, PL-SQL, views, stored procedure, triggers,

and functions in SQL Server 2005/2008.

. Created roles, profiles and privileges and assigned roles to users.

. Worked on scheduling the jobs.

. Informatica administration of security and setup of repository

structures

. Created dimension views and User Class views to implement the data

security in the Cognos Powerplay Transformer Model

. Delivered presentations and training to users on use of markup

. MS Visio is used to create the Data model and ERD.

. Maintenance and enhancements of Biztalk applications using Biztalk

Server 2006/2009.

| |

ThermoFisher Scientific Inc., Pittsburgh, PA

Content Engineer - March 2009 to August 2010

Thermo Fisher Scientific Inc. (NYSE: TMO) is the world leader in

serving science, enabling customers to make the world healthier, cleaner

and safer. With annual revenues of $10 billion, and has more than 30,000

employees and serve over 350,000 customers within pharmaceutical and

biotech companies, hospitals and clinical diagnostic labs, universities,

research institutions and government agencies, as well as environmental and

industrial process control settings

|Role and Responsibilities |

. Analyzed complex data, requirements and existing standards.

. Designed Web-based Internet applications linked to firm-wide SQL

databases using ASP.NET, C#.NET, VB.NET, Webservices, Jscript, Linq to

SQL.

. Extensively worked on XSL, XSLT and XML using XML Spy.

. Experience with WCF and WWF.

. Strong experience in Business Intelligence using SQL Server 2005/2008.

. Applied Core java skills to fix the issues and maintain the existing

Java application using Eclipse.

. Develop and maintain related data conformance validation scripts.

. Strong experience with XML DTDs/schemas

. Maintenance of Internet Information Server (IIS).

. Applied the knowledge Informatica in generating the reports on time

with efficiency using normalization

. Worked on DDL, DML, T-SQL, PL-SQL, views, stored procedure, triggers,

functions and packages and SSAS,SSIS in SQL Server 2005/2008 and

Oracle 8i/9i based on business plans.

. Created roles, profiles and privileges and assigned roles to users.

. Worked on scheduling the jobs.

. Informatica administration of security and setup of repository

structures

. Created dimension views and User Class views to implement the data

security in the Cognos Powerplay Transformer Model

. Delivered presentations and training to users on use of markup

. MS Visio is used to create the Data model and ERD.

. Developed solution to automate processes for converting the SDFdata

into the SVG images using PERL scripting.

. Worked on MSAccess 2000/2003 VBA Macros and Modules to create

processes for automating the generation of data tables and updation of

the same.

. Supervised junior Content Engineers throughout the Import/Export and

managing the user requests.

. Extensive knowledge of creating and manipulating the Chemical

Molecular structure using ChemDraw software.

| |

Histogenetics, Chennai, India

Senior Software Engineer / Business Analyst - Bioinformatics June 2007 to

Jan 2008

Histogenetics, a New York based Biotech firm, specializes in Human

Leukocyte Antigen (HLA) typing services and Sequenced Based Typing (SBT)

for blood stem transplantation. This company provides the DNA sequence

based tissue typing services. IT development and support center branch

in India.

|Roles and Responsibilities |

. Gained knowledge on the terms and technologies used in the

Biotechnology lab

. Worked on Web-based applications using ASP.NET, VB.NET, ASP with

Oracle 9i and SQL Server 2005 as backend

. Good programming experience in Transact SQL, SQL, PL/SQL, Complex

Stored Procedures, Triggers.

. Installed Oracle, apply patches, and create/setup databases.

. Maintenance of Internet Information Server (IIS).

. Oracle 8i/9i Database Implementation/Upgrade/Support.

. Migration of Data from SQL Server 2000 to SQL Server 2005

. Performance tuning using SQL Query Optimizer

. Creation of roles, profiles and privileges and assigned roles to the

users

. Supervise a team of Software Engineers throughout the Project

Lifecycle.

. Involved in performance appraisal of the software engineers

. Use of COM and DCOM Objects to establish the security of data

connection in the applications through IIS

. MS Visio is used to create the Data model and ERD.

. Regular DBA activities like Backup and Restoring of the Database by

either Hot/Cold, Import/Export

. Generated reports using SQL Server Integrated Services

. Proficient in using the Jscript and VBScript in performing the client

side validation

. XML and XSL style sheets has been used for manipulating the user data

as per the business plans.

. Web Services has been used to create the web-applications and

installed on the user-machines for usage.

| |

ProcessMAP Infotech Pvt Ltd., Hyderabad, India

Analyst III January 2006 to June 2007

Process MAP Infotech Pvt Ltd., suite of web-based applications provides all

key functionalities that are essential to build a world-class EH&S

management system. The flexibility of solutions allows customers to

leverage technology to support the management processes in a modular and

structured manner.

|Roles and Responsibilities |

. Worked on Web-based applications using ASP with SQL Server 2000 as

backend

. Good programming experience in Transact SQL, SQL, T-SQL, Complex

Stored Procedures, Triggers.

. Installed SQL Server, apply patches, and create/setup databases.

. Maintenance of Internet Information Server (IIS).

. Performance tuning using SQL Query Optimizer

. Creation of roles, profiles and privileges and assigned roles to the

users

. Use of COM Objects to establish the security of data connection in the

applications through IIS

. MS Visio is used to create the Data model and ERD.

. Regular DBA activities like Backup and Restoring of the Database using

Enterprise Manager.

. Generated reports using Crystal Reports

. Proficient in using the Jscript and VBScript in performing the client

side validation

| |

Delphi-TVS Diesel Systems Ltd., Chennai, TN, India

Systems Officer - EDP January 2004 to August 2005.

Delphi-TVS Diesel Systems Pvt Ltd., is an Automobile Industry involved in

the manufacturing of Diesel Pumps, Filters and Injectors. It is maintaining

its own development centre and IT Support Center to develop and implement

their own Projects.

|Roles and Responsibilities |

. Worked on Web-based applications using ASP with SQL Server 7/2000 as

backend.

. HTML is used for designing the Web Pages.

. Multiple desktop applications have been developed using the Visual

Basic 6 with Oracle as backend.

. Good programming experience in Transact SQL, SQL, PL/SQL, Complex

Stored Procedures, Triggers.

. Maintenance of Internet Information Server (IIS).

. Installed Oracle and create/setup databases.

. Performance tuning using SQL Query Optimizer.

. Creation of roles, profiles and privileges and assigned roles to the

users.

. Created and Executed the Batch programs for importing and Exporting

the data in scheduled jobs.

. Use of COM Objects to establish the security of data connection in the

applications through IIS.

. Regular DBA activities like Backup and Restoring of the Database by

either Hot/Cold, Import/Export.

. Generated reports using Crystal Reports.

. Proficient in using the Jscript and VBScript in performing the client

side validation.

Trainee programmer December 2002 to April 2003

|Personal Details |

|Sex |Female |

|Marital Status |Married |

|Resident Status |Green Card Holder (Permanent Resident of |

| |United States) |

|Email (Personal) |hnp5nq@r.postjobfree.com |

|Mobile # |646-***-**** |

|Land Line # |646-***-**** |

|Languages Known |English, Tamil, Telugu, Hindi, |

| |Spanish(beginner). |

|References |

References are available upon request.

[pic]

Contact this candidate