Sr SAS Developer & Analyst

RITIKA MALIK

*************@*****.*** Address: ** Commons Drive

732-***-****(c) Apt. 211, Shrewsbury MA-01545

EXPERIENCE

Commerce Insurance, Webster MA

Current Associate Consultant

• Gathered requirements from the client for front end design and developed software requirements specification.

• Created PL/SQL scripts for data updates within Oracle databases.

• Designed and coded PL/SQL stored procedures and functions to handle business logic.

• Interacted with clients to fully define the voice, data and computing systems to be implemented on various projects including John Jay College, Orange Regional Medical Centre etc.

• Developed PL/SQL queries to analyze data integrity.

• Worked with JSPOOL-the front end interface for the TronWeb application.

• Used DBI/DBD connectivity from Oracle to Perl.

• Responsible for performance tuning activities in Oracle.

• Worked on XML mapping files.

• Created/Modified numerous web pages using HTML with JavaScript validation.

• Involved in source code version control using CVS.

Shen Milsom Wilke, New York, NY

August 2009-March 2010 Associate Consultant

• Designed, developed database-intensive, rule-based applications using Oracle PL/SQL.

• Involved in database changes and coding in Oracle PL/SQL.

• Assisted with infrastructure and cable installation and co-ordinated with vendors, clients associated with PSACII.

• Worked on Oracle for data collection and document storage and retrieval.

• Participated in requirement analysis, design, coding of UNIX scripts.

• Responsible for promoting the SQL scripts via CVS for installation into the Integrated

environment.

• Wrote PL/SQL queries and stored procedures for inserting and retrieving data.

• Co-ordinated with end users, architects, colleagues and others on various aspects of the City of Jersey City Call Centre project.

Monroe County, Department of Environmental Services, Rochester NY

April 2009-July 2009 Seasonal Engineering Aide

• Involved in the creation of the Jasper style reports.

• Reviewed the requirements as provided by the business analyst and determined database requirements based on data needed.

• Involved in requirement analysis, design and design documentation.

• Designed, developed database-intensive rule-based applications using Oracle PL/SQL.

• Wrote PL/SQL queries to make changes to the database.

• Assisted in recording batch job information for ROBOT scheduler setup.

• Worked on the development set-up process in the Oracle Database and created a suite of source members.

Bharti Airtel Ltd. New Delhi, India Programmer/Developer

October 2005 to August 2006

• Responsible for performance tuning activities in Oracle.

• Created many Perl/CGI reports.

• Designed, Developed and modified Perl scripts using modules and packages.

• Created PL/SQL scripts for data updates within Oracle databases.

• Worked with JSPOOL-the front end interface for application.

• Involved in source code version control and committing objects using CVS.

• Wrote many wrapper scripts.

Orange Business Services, New Delhi, India Technical Support Specialist

June 2005 to October 2005

• Provided IPVPN service support all around the globe on 24*7 basis.

• Diagnosed fault-related cases by effectively utilizing software diagnostics.

• Co-ordinated with the necessary Equant departments thereby achieving fault resolution.

• Fixed bugs and supported the application during production.

HCL BPO Technologies, Noida, India Technical Support Officer

May 2004 to June 2005

• Provided technical support over the phone to the DSL customers of SBC Yahoo.

• Supervised quality control trained the call center operators and audited their calls.

• Supported the system during off -hours.

EDUCATION

Rochester Institute of Technology (RIT), Rochester, New York

Master of Science in Telecommunications Engineering, expected May 2010, GPA: 3.75/4.0

Research: Study on RFID under the guidance of RIT Professor. Researched and worked on the

configuration of new Allworx phones in the Telecommunications Lab at RIT.

Punjab Technical University, Punjab, India

Bachelors in Technology (Electronics and Communications Engineering), May 2004, GPA: 3.4 / 4.0

NOTABLE ACHIEVEMENTS

• Awarded Graduate and Redcom Scholarship at Rochester Institute of Technology (RIT)

• Rank: Top 5% of class at Rochester Institute of Technology (RIT) for 4 consecutive quarters

• Professional memberships:

The Core Committee of TECHFAIR (a national level technical competition)

The Organization for the Alliance for the Students of the Indian Subcontinent (OASIS)

The Global Union, the Engineering Club and the Global Interest Group at Rochester Institute of

Technology (RIT)

SKILLS

-Effective Communication -Group Training and Instructor Experience

-Excellent Time and Project Management -Strong Troubleshooting Skills

Software Applications: PL/SQL, SQL, CVS, PERL, UNIX Shell Scripting, KSH, CGI, DBI, HTML, TOAD, C++, LDAP, ERX, RADIUS, SDX, Server Technologies, Apache Web Server, Routing Protocols

Design Tools: OPNET, Delite, Optiperformer 5

Certifications: Pursuing CCNA

Contact this candidate