Developer Sql Server

Rajalakshmi Krishna

E-mail: *******.***********@*****.*** A4-805, Elita Promenade, J.P Nagar 7th Phase Mobile: +91-809******* Bangalore - 560078

Summary

• Five years of experience as software developer with expertise in Oracle and SQL Server.

• Experience in development of Enterprise Data Warehouse (EDW) infrastructure, processes for extracting, transforming, and loading data.

• Proficient in using Informatica Power Center for ETL processing.

• Oracle Certified Associate

• Close to one and half years of experience as Linux systems administrator with proficiency in developing system maintenance utilities in Perl and shell programming languages.

• Adept knowledge in SQL Server Reporting Service, Cognos 8 Report Studio, Query Studio and Jaspersoft iReport.

• Hands-on experience in designing data models, ER-Diagrams, Data Flow Diagrams for multitier business applications.

• In-depth understanding of all stages of software development life cycle (SDLC).

Technical Skills:

Programming Languages: PL/SQL,T- SQL, Shell script, PHP, Core Java, C, C++ Operating Systems: Windows XP/Vista/7, Linux (RedHat, CentOS, Ubuntu), Solaris Databases: Oracle 9i/10g, SQL Server 2005/2008, MySQL ETL Tools: Informatica Power Center 7 Development Environment: Oracle SQL Developer, Eclipse, Net Beans Reporting Tool: Cognos 8, SSRS 2008, Jaspersoft iReport 4

Certifications: Oracle PL/SQL Developer Certified Associate

Professional Experience:

Systems Administrator Jan 2011- March 2012 Illinois Institute of Technology, Chicago, USA

• Designed and maintained MSSQL Server 2008 and Oracle 10g database and file structures used by institution systems; established, link, join and related data within tables via scripts.

• Developed several detail and summary/dashboard reports including line charts, trend analysis reports and sub-reports according to business requirements using SSRS 2008 and Jaspersoft iReport.

• Created and tested various reports for student course schedule, faculty payroll and other packages using Cognos 8 Report Studio and Query Studio.

• Designed web pages for the IIT Graduate Admissions using PHP and MySQL.

• Assisted in the integration and development of the various systems such as customer relations management (CRM), web-based applications and home grown Decision Support Systems.

• Assisted technical support personnel and software/hardware vendors in installation, maintenance support, software interface requirements and problem determinations and resolution.

Database Developer June 2008- May 2010 Illinois Institute of Technology, Chicago, USA

• Involved in migration of data from legacy Student Information System (SIS) to Enterprise Data Warehouse (EDW).

• Developed PL/SQL scripts for extraction and transformation of data from Operational Data Source to Enterprise Data warehouse.

• Developed PL/SQL scripts for daily metadata load.

• Involved in design and development of complex aggregate, join, lookup, sequence generator, stored procedure, expression, filter and rank transformations rules using Informatica Powercenter 7.1.1.

• Designed ad hoc MS Access database for the office of Institutional Information and Research, IIT consisting of data required for US News yearly surveys.

• Involved in building Cognos 8 reports for analysing the Student Decision Support System.

• Generated reports on Microsoft Excel for student admission and enrollment using Visual Basic script as backend.

• Documented requirements and various backend processes.

Linux System Administrator Oct 2006- Jan 2008 Carmatec IT Solutions Pvt. Ltd, Bangalore, India

• Administered Linux web-hosting servers remotely with root privileges.

• Built large and small system administration related utilities such as daily backup, software updates and full server scan for root kits in Perl and Shell programming language.

• Installed and configured Apache web servers on client machines.

• Installed and configured Linux firewalls and various network security tools such as NMAP, Nagios helpful for monitoring the server traffic round the clock.

• Involved in Solaris and Linux server upgrade, both at the operating system and application level.

• NIS, NFS, routing and DNS administration and Firewall configuration.

Software Developer Aug 2005 - Sep 2006 Ambigro Technologies, Bangalore, India

• Involved extensively in System Study & Business Requirement Analysis.

• Defined and designed the entity-relations – ER Diagrams and physical databases for OLTP.

• Created Oracle database tables, sequences, clusters, triggers, procedures, functions and packages.

• Managed Log Files, Control Files for optimum performance levels of the databases.

• Performed SQL query optimization using Indexes.

Education:

M.S, Information Technology May 2010 Illinois Institute of Technology, Chicago, IL USA

B.E, Computer Science July 2005 Visvesvaraya Technological University, India

Personal Profile:

Date of Birth: 21st June 1983 Mailing Address: A4-805, Elita Promenade, J.P Nagar 7th Phase, Bangalore - 560078 Marital Status: Married Passport Number: F0720915

Contact this candidate