Sql Server Data

ASHMITA PATNAIK

ETL / SQL Developer

Summary:

. Over 8 years of IT experience in the use and development of SQL Server

****/****/****, ******, *** Sybase databases.

. Worked extensively on PL/SQL, stored procedures, functions and

triggers to develop various complex queries and views for generating

reports

. 5+ years expertise in using ETL tools including SQL Server Integration

Services (SSIS), Data Transformation Services (DTS), ETL package

design & RDBM systems like SQL Servers and Oracle.

. Over 6 years experience in database performance tuning & query

optimization, data integrity and statistics.

. Over 3 years dimensional data modeling experience using data modeling,

star schema/snowflake modeling, fact and dimension tables, physical &

logical data modeling.

. Hands on experience in installing, configuring, managing, monitoring

and troubleshooting SQL Server 2005/2008.

. Worked on SQL Server Partitioning and data management.

. Extensive experience in monitoring, tuning and analyzing database

performance and allocating server resources to achieve optimum

database performance.

. Experienced in handling large volume and internal databases from

planning stage through implementation and support.

. Skilled in programming languages required for report automation.

Technical Skills:

Databases: Oracle 8i/10g, MS SQL Server 7.0 / 2000 / 2005

/ 2008, MS Access, Sybase

Languages: SQL, T-SQL, PL/SQL, ASP, VB Script, C#, HTML,

UNIX shell scripting

Data warehouse tools: OLAP, SSIS, SSRS, SSAS, SQL Data

Transformation Services (DTS)

ETL tools: ERWIN

Packages: Visio, MS Office, Outlook, MS Project,

Operating Systems: MS-DOS, Windows 95/98/NT 4.0/XP/2000/2003

Server, UNIX, Sun Solaris 8

Education:

. M.Sc. (Masters of Science) in Information Technology.

Certifications And Awards:

. Oracle Certified Professional (OCP 10g).

. Service Excellence award in Adventity: 2005 and 2006.

Professional Experience:

Technosoft Corp Mar '07 - Present

Technosoft Corporation is a Business Application and Business Process

Outsourcing (BPO) Services Company. Headquartered in Michigan, USA,

Technosoft has offices in Princeton, New Jersey and Minneapolis, Minnesota.

Technosoft has approximately 500 employees and consultants in the U.S.,

including corporate headquarters and at client sites in many states. In

addition, more than 500 Technosoft staff members are employed in India.

Client: Sprint Nextel, Overland Park, KS. Mar '07

- Present

Role: ETL Developer

Description:

Performed a major role in understanding and impletmenting business

requirements. Developed and supported Extraction, Transformation and

Load process (ETL) using SSIS to populate the tables in data warehouse

and data marts. Handled large volumes of data warehouse database.

Responsibilties:

. Worked extensively on control flow elements including containers,

tasks and precedence constraints. Used data flow extensively including

tools like lookup, conditional split, derived columns, script task,

multicast, source and target elements. Handled exceptions using event

handlers

. Built efficient SSIS packages for processing fact and dimension tables

with complex transformations

. Used SSIS client tools for defining source and target definitions and

coded the process of data flow from source system to data warehouse

. Implemented performance tuning logic on targets, sources, mappings,

sessions to provide maximum efficiency and performance

. Created alerts, notifications for system errors, insufficient

resources, fatal database errors, hardware errors and server space

based on system criticality

. Worked on database connections, SQL joins, cardinalities, loops,

aliases, views, aggregate conditions, parsing of objects and

hierarchies

. Worked on databases with terabytes of data, used partitioning for

better performance of database

. Performed daily tasks including backup and restore by using SQL Server

2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL

Server Agent, and Database Engine Tuning Advisor

. Troubleshot system issues, monitored scheduled jobs and set up

maintenance plans for proactively monitoring the performance of SQL

Server databases

. Designed and developed SSIS packages, stored procedures, configuration

files, tables, views, and functions

. Created systems using VB.net/C# and SQL server 2008 for capturing,

reporting, and correcting erroneous data

. Worked with developers and systems support personnel in elevating and

automating successful code to production

. Used database engine tuning advisor and query tuning techniques to

profile maximum efficiency and performance

. Created ad-hoc queries from SQL Server databases for custom reporting

needs using SSRS

Environment: Windows 2003, UNIX, SQL Server 2005/2008, Netezza, SSIS,

VB.net, C#, Microsoft Office.

Adventity Jan '02 - Mar '07

Adventity is a market leading full service KPO/BPO firm for the Banking &

Financial Services and the Airlines & Travel industry, offering

comprehensive & innovative knowledge services, transaction services and

customer contact support solutions to clients across the globe.

Headquartered in Mumbai, and with global offices in North America, Europe,

the Middle East and Asia, Adventity provides technology driven innovative

product and process solutions to a diverse global business community, which

includes leading Indian private sector banks, International Investment

banks and several Airline & Travel companies.

Client: DishPronto Jun '06 - Mar

'07

Role: Sr. Programmer/Analyst

Description:

Designed ETL process for different data sources (Oracle, Sybase), data

quality and testing. Developed, modified, and optimized complex

queries for data retrieval and modification.

Responsibilities:

. Responsible for the installation, configuration and maintenance of SQL

Server database on different platforms

. Upgraded the database SQL Server 2000 to SQL Server 2005, migrated SQL

Server 2000 DTS objects to SQL Server 2005 integrated services (SSIS)

environment

. Involved in the design and generation of reports for different data

sources using SQL Server reporting services

. Managed the backup and recovery of databases

. Interacted with the users and troubleshot the problems involved with

the development of stored procedures, triggers and privileges

Environment:

Windows 2000, UNIX, SQL Server 7/2000/2005, Oracle and Sybase.

Client: Rapid Satellite - Retailers for DirectTV.

May '05 - Jun '06

Role: Sr. Developer.

Description:

Designed the logical and physical database for the project and was

also responsible for performance tuning, triggers, stored procedures

and replication. Provided DBA support. Generated reports on customer

order processing and shipping, general accounting and manufacturing.

Responsibilities:

. Worked extensively on PL/SQL, stored procedures, functions and

triggers to develop various complex queries and views for generating

reports

. Wrote shell scripts to load data into tables

. Responsible for data validation, feeding of live data and user

acceptance for each module

. Created web script in Lyricall as per the client requirements with

client side validation. Automated reports to be sent to clients using

DTS with VBScript and ASP

. System Administrator for Epro and Ensemble Dialers on Sybase DB

. Managed day-to-day dialer activities like sending reports, managing

campaigns in terms of pacing, lead list, exclusion, filters, and

creation of lead lists

Environment:

Windows 2000, UNIX, SUN Solaris 8, SQL Server 7/2000 and Sybase.

Client: Tata AIG Life Insurance Company Limited

Aug '04 - May '05

Role: Sr. Engineer

Description:

Trained 5 team members and supervised the inbound and outbound

campaigns' performance. Initiated and implemented the report

automation process for MIS team (for internal and external clients).

Ensured maximum uptime for international and domestic projects as per

service level agreement.

Responsibilities:

. Managed database in SQL server & Sybase for outbound campaigns

. Responsible for administration & maintenance of predictive dialer

servers (Ensemble 3.1.0.2 & E-Pro 5.2). Scripted in Lyricall for

Ensemble 3.1.0.2 and E-Pro 5.2

. Created call tables and generated the daily reports of database

utilization. Responsible for the backup of databases for all campaigns

on a daily basis

. Evaluated new technologies and was responsible for integration and

customization of those technologies as per business requirements

. Responsible for scrubbing activity for DNC customers from DNC solution

site and files received from clients

Environment:

Windows 2000, SUN Solaris 8, SQL Server 7/2000 and Sybase.

Client: ICICI Bank Aug '03

- Aug '04

Role: Jr. Developer

Description:

System Administrator for Epro and Ensemble Dialers on Sybase database.

Managed day-to-day dialer activities like sending reports, managing

campaigns in terms of pacing, lead list, exclusion, filters, and

creation of lead list.

Responsibilities:

. Created and managed customer databases, tables, data objects, setting

privileges, indexes, user logins, passwords (security)

. Responsible for creating and executing PL/SQL, stored procedures and

triggers

. Used SQLPLUS for data loading, issuing command line queries and report

generation

. Created DTS packages for data loading and automation of reports using

SQL server 2000

. Used VBScript and ASP to automate client reports

Environment:

Windows 2003, SQL Server 7/2000 and Sybase.

Client: Etihad Airways - The National Airline of the United Arab Emirates

Jan '02 - Aug '03

Role: Programmer

Description:

Played a key role in ISO 9001:2000 certification for Adventity -

Etihad project. Responsible for the development, implementation, and

troubleshooting of in-house database and related software application

design.

Responsibilities:

. Created and managed databases, tables, table spaces, data objects,

privileges, indexes, and user logins

. Analyzed project requirements, installed and configured Oracle

databases. Worked on database triggers and stored procedures

. In charge of monitoring the databases for any performance bottlenecks

and tuning the database to avoid pitfalls. Applied periodic patches to

the server side and client side

. Streamlined the security, backup & recovery procedures

. Troubleshot and resolved various client issues related to Oracle and

the application software

. Supported end users for any trouble in accessing the data from the

tables and views

Environment:

Windows 2003, Oracle 8i, Visual Basic 6.0.

Contact this candidate