SUMMARY

• Seven years of experience in IT & IT enabled services industry as a highly motivated professional offering support in Systems monitoring (UNIX & Windows), Process Improvements, configuring, Data analysis and software related infrastructure with a minimum downtime.
• Interact with business users and managers in gathering business requirements.
• Created database objects such as tables, views, indexes, sequences, functions, stored procedures, packages as per business requirements.
• Having vast working knowledge in building jobs on Active Batch and scheduled, executed and triggering jobs as per the requests.
• Involved in production team in monitoring the production support jobs.
• Large volume data conversion, data cleansing, production report generation, and upholding scheduled data delivery standards.
• Perform Data validation and massaging to ensure accuracy and quality of data.
• Team player with good communication and inter personal skills. Expertise in developing software using, SQL, PL/SQL, Oracle10g.
• Implementation plan and production support.
• Experience in using SQL Server Integration Services for data extraction, transformation and loading. Experience in using SSIS tools like Import and Export Wizard, Package Installation, SSIS Package Designer.
• In - depth knowledge of data processing, data collection, quantitative and qualitative data analysis.
• Excellent organizational and time management skills.
• Excellent planning and decision making abilities.
• Software designing and development in oracle (PL/SQL).
• Ability to learn quickly with good learning curve and take up new tasks and responsibilities. Can work effectively individually as well as in cross-functional team environments.
• Self-motivated in doing Research and development of new technology and tools. Strong analytical, problem solving skills and specialized in understanding existing work flows and excellent verbal & written communication skills.

TECHNICAL SKILLS

Operating Systems: All Windows Platforms, UNIX, Solaris and Linux

Products Tools: PL/SQL, Toad, SQL-navigator, Perl, Xml

Languages: Pro*c, SQL, PL/SQL, .Net, Business Objects, Ruby rails

RDBMS: Oracle 11g/10g/9i/8i, SQL Server 2000

Documentation Tools: MS Office tools with MS Visio.

PROFESSIONAL EXPERIENCE

Confidential, Andover, MA

Sr. PL/SQL Analyst

Responsibilities:

• Supported the production team in monitoring the production jobs.
• Designed, developed, deployed and maintained desktop and web applications and databases. Focal point for making sound decisions related to data collection, data analysis, methodologies and study design.
• Utilized Microsoft Access & Microsoft Excel applications for reporting
• Designed and executed queries in SQL to get data matching the required criteria from Oracle Database using PL/SQL and SQL Server 2008.
• Worked on complex SQL queries to querying large volumes of data.
• Involved in writing SQL Queries in order to test the functionality, used INNER and OUTER joins to retrieve the data in Oracle database.
• Conducted research to collect and assemble data for databases was responsible for design/development of relational databases for collecting data.
• Escalate and follow up on issues to Engineering and Content department.
• Maintained the data integrity during extraction, manipulation, processing, analysis and storage.
• Built data input and designed data collection screens - Managed database design and maintenance, administration and security for the company.
• Provided 24/7 On-call support.
• Used XSLT to transform the data from XML database to update the database.
• Extensively used the FTP ( File Transfer Protocol ) to download the source flat data and to upload the reports
• Validated data for periodic summary reports and for use by other groups.
• Discussed intelligence and information requirements with internal and external personnel
• Cooperated with external outsourcing on the design and development of analysis.
• Assist in quarterly and annual audits related to revenue.
• Ability to multi task and prioritize work effectively in a fast paced environment.
• Played a key role in converting the financial system over to an ORACLE based program as part of an overall team of programmers.

Environment: PL/SQL, Oracle 11g, Web Intelligence, Info view, Windows 2000 Server & UNIX, IIS, SQL Server 2000.

Confidential, Boston, MA

Sr. Analyst

Responsibilities:

• In-depth knowledge of data processing, data collection, quantitative and qualitative data analysis.
• Resolved customer error messages, checking Web Server and FTP Upload Configurations.
• Supported users with hardware and software systems.
• Responded rapidly to client problems and questions by supporting database systems, report generation, hardware issues.
• Maintained the integrity and reliability of Managed Care and Provider Services custom programs while performing tasks with very limited resources.
• Proficient with the data management policies, procedures and common technical tools.
• Responsible for manipulating, transferring and managing data.
• Obtained data from agency data base for management and developed reports.
• Participate in ad hoc projects as needed.
• Ability to exercise control over the executed tasks with the planned activities.
• Validated data from all resources for accuracy purposes utilizing structure queries.
• Provided maintenance and programming support to users and business clients.

Environment: PL/SQL, Designer, Web Intelligence, Info view, Supervisor, Windows 2000 Server, IIS, SQL Server 2000.

Confidential

Database Support Engineer

Responsibilities:

• Provided systems administration support for all platforms & Executing SQL queries, disaster recovery monitoring, user account setup and security administration.
• Developed a Module program to maintain the custom created tables in SQL.
• Creating new Connections and editing existing to run the report in different database test, development.
• In-depth knowledge of data processing, data collection, quantitative and qualitative data analysis.
• Developed a report to show Material Changes Details by date or material.
• Entered, researched, and forwarded call and error information into various database files.
• Resolved customer error messages, checking Web Server and FTP Upload Configurations.
• A leading developer of database management and productivity software applications.
• Entered, researched, and forwarded call and error information into various database files.
• Designed, developed, deployed and maintained desktop and web applications and databases.
• Providing operational readiness support documents to all the production operation teams including network administrator and systems analyst as required.
• Worked on Technical Support Tickets & have vast knowledge on SLA’s.
• 24/7 On-call support when needed.
• Being in ONCALL rotations for weekends & afterhours support. Handled Level 2 & Level 3 escalations of production and critical non-production issues.
• Excellent planning and decision making abilities.
• Involved in Technical, User, Security, and I.T. Support policy documentation for implementation, maintenance of existing technical documentation (Wiki/SharePoint).

Environment: SQL, Toad, Supervisor, Windows 2000 Server, Oracle 10g.

Confidential

Database Support Engineer

Responsibilities:

• Active Participation in the System Study.
• Involved in gathering and creating requirement documents.
• Physical designing and development of Database.
• Assisted in designing the system flow.
• Created tables, indexes and views.
• Creating & modifying stored programs in the form of PL/SQL Packages, Procedures and Functions.
• Creating SQL Loader Control Files for moving data from Flat Files (Fixed Record Length) to Staging Area Tables.
• Managing tables, indexes, constraints, views, sequences, synonyms and stored program units.
• Extensively used complex SQL queries (Sub-queries and correlated sub queries).
• Involved in writing crisp and precise technical documentation.

Environment: Oracle, SQL *PLUS, Solaris 2.6, Microsoft word, PL/SQL.

Confidential

Database Support

Responsibilities:

• Used SQL * Loader for loading data from flat files into the database tables.
• Enforced database integrity using primary keys and foreign keys.
• Created PL/SQL functions to facilitate business functions and calculations.
• Involved in coding and testing various Packages, Procedures and Functions.
• Responsible to maintain the dependencies of all Procedures, Function, Packages, Views and Triggers.
• Implemented complex business rules with the use of integrity constraints and Database Triggers.
• Developed Packages to validate raw data from Flat Files and insert into tables.
• Tuned and Optimized the SQL statements using Explain Plan and SQL trace utilities.
• Involved in documentation of various database objects like packages, procedures and functions.

Environment: s: Oracle 8i, SQL, PL/SQL, SQL * Loader.