Summary:

• Around 3 yearsof experience as a developer in IT industry
• Design and development of business applications using Java, SQL, and PL/SQL.
• Extensive experience in MS SQL Server 2005 with Business Intelligence in SQL Server Reporting Services and SQL Server Integration Services
• Very good understanding of SQL Server Architecture design.
• Experience in Creating SSIS and DTS package development and implementation for different tasks.
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using MS SQL Server DTS and SSIS
• Experience in SQL Server Migration and Migration of DTS Packages to SSIS.
• Strong experience in creating complex Stored Procedures, Replication, Index, Functions, DTS packages, triggers, cursors, tables, views and other SQL joins and statements.
• Expert in creating SQL Server Reports using SSRS 2005 in designing stylish report layout parameterized, performance, Chart Reports, ad-hoc report.
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
• Experience in report writing according to the business requirement in SSRS.
• Experienced in developing Ad-hoc reports using Business Objects, Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, SDLC concepts
• Experience in SQLSERVER 2005 Analysis services/OLAP Design & Implementation.
• Familiar with OLAP cubes and fact table, star and snowflake schemas
• Experience in Building Multi Dimensional Cubes, Data Modeling, and OLAP Cubes using SSAS.
• Using Data Mining Wizard and Designer to Design, Manipulate models.
• Strong experience in design and construction of data marts, data views and data mining
• Experience in SQL Server Migration and Migration of DTS Packages to SSIS.
• Very good experience in Installation, configuration and maintenance of SQL Server.
• Experience in backup and disaster recovery procedures.
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
• Experience in Unit testing
• Trained extensively in C, Java, PL/SQL languages and well versed with RDBMS like Oracle, and OS concepts.
• Proven track record of good communication and interpersonal skills.

Education:

• Master’s in Computer Science
• Bachelors in Computer Science

Certifications:

• Oracle PL/SQL Developer(OCA Certification)
• Certification in PL/SQL programming
• Certification in Basic SQL

Technical Skills:

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)
ETL Tools: Data Transformation Services (DTS) – Export/Import, SQL Server Integration Service (SSIS)
Reporting Tools: SQL Server Reporting Services (2008/2005/2000), MS Access, MS Excel
Database: MS SQL Server 2008/2005/2000, MS Access, Oracle 9i/8i
Programming: T-SQL, PL-SQL, C
Web Technologies: HTML, DHTML, XML, XSL, Java Script (Validation), CSS, PERL
Operating Systems: Windows (95/98/2000), Windows 2003 Server, Windows XP, Windows Vista
Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash.

Educational Experience:

Masters Program

Learnt various methodologies available for efficient project management skills, and analyzed various types of ERP software’s available in the market such as Oracle, and PeopleSoft etc …
As a part of Masters Program, intensively trained on algorithmic techniques which have great impact while developing applications, extensively trained on Relational Database diagrams and database implementations

Courses completed:

• Project Management and Enterprise Resource Planning
• Introduction to Algorithm design
• Analysis of Algorithm Design
• Computer Security
• Introduction to Database Concepts
• Data base organization and file structure
• Software testing methodologies

Projects & Experience:

Teaching Assistantship
Worked as Teaching Assistant for Introduction to Programming language-Java

Securities in Cloud Computing
(Environment: Java)

• Worked on how is being implemented by leading Cloud providers like IBM, Amazon
• Implemented Gentry Homomorphic technique using java.
• Encryption and decryption is done on 32 bit integer.

Security Mechanism
(Environment: Java)

• Worked on implementing cryptographic algorithms
• RSA cryptographic system would accept 1024 bit input and generate random message.
• Message encryption and decryption timing is recorded.

University Database System
(Environment: Java, JSP, JavaScript, MySQL, Tomcat and Eclipse)

• Worked on the implementation of University Database System for the students and professors
• Implemented an interface for the users using JSP
• Login Screen
• Home Page
• Professors screen
• Responsible for
• Gather, analyze and document the requirements
• Design, develop and test the entire solution with various test cases
• This involves in creating various database objects such as Tables, Views, Sequences, synonyms, PL SQL packages in MySQL

Automated Banking Application
(Environment: Java, Linux, SQL)

• Main objective of the project is to automate the daily activities of bank
• Project deals with the
• Automated demand drafts maintenance
• Automated loan sanctioning
• Automated deposits
• Provide the security at each and every level
• A bank user can access only his account details
• Bank employee can only deal with his transaction amount, where as
• Bank manager can check all the transactions done in his branch only

Professional Experience:

Confidential, Sep 2006 – Feb 2008
Client: Confidential
Role: ETL Developer
Environment: SQL Server 2005
Project Description:
Mahanagar Telephone Limited (MTNL) is one of the major Telecom service providers Organization in India. This implementation involved major transformation and reporting in Marketing, Sales, and Account management, Number Management, Order Capture and Support Modules.

Responsibilities:

• Installed and Configured SQL server 2005 on windows 2003 advance server system.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Designed dynamic DTS and SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Created packages using DTS and SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server using ETL Tool.
• Performance Tuning the Stored Procedures used in SSIS Packages and SSRS Reports.
• Created many rich and highly interactive Web forms for user management module using ASP.Net 2.0, VB and DHTML.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Generated database monitering and data validation reports in SQL Server Reporting Service (SSRS).
• Experience in Designing and Building the Dimensions and cubes with star schema and snowflake schema using SQL Server Analysis Services (SSAS).
• MDX Coding and MDX object modeling using analysis services.
• Involved in Report writing according to business requirment using SSRS and Crystal Reports.
• Designing Cubes, Star Schema and Data models for Data Warehousing Applications
• Developed reports where the data extracted from SSAS cubes.
• Used the Report Manager to Create folder structures,modify data sources,Controlling access to Report Services resources
• Optimized query performance by creating indexes.
• Moved the static data from various text files to SQL Server 2005 database using BCP Import and Export, Bulk Insert.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.
• Provided support to the application developers on the application databases.
• Configured and Deployed different reports in the Servers using SQL Server 2005 Reporting Services.