EXPERIENCE PROFILE

• 5+ years of experience in Software Services and Products.
• Working as System Analyst with Dataworks Consulting Group since September 2009.
• Worked as Programming consultant with the University of Puerto Rico from July 2009 to August 2009
• Worked as System Analyst in Subex Ltd. from June 2007 to Jan 2009.
• Worked as Software Engineer in Infosys Technologies Ltd. from August 2005 to May 2007.
• Sun Java Certified (SCJP 1.4) Programmer.

Dedicated IT professional with exceptional data warehouse, database, and business applications experience

Qualifications Highlights:

• Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling.
• Outstanding SQL and shell-scripting skills
• Expertise in performance tuning VLDB, data warehouse database design and modeling
• Extensive experience in Object Oriented analysis and design.
• Self-starter and quick learner with proven analytical, technical, and communication skills.
• Very resourceful in problem solving.
• Sound understanding of Software life cycle methodology

SOFTWARE EXPOSURE

RDBMS: Oracle11g/10g/9i, MS SQL Server
Programming Languages: PL/SQL , C# (.Net Framework),
Java (J2EE technologies), JavaCC, C/C++
Business Intelligence: MicroStrategy, Oracle BI Discoverer
Scripting Languages: Shell, TCL
Tools: TOAD,SQL developer, Websphere, Clearcase, VSS, Subversion
Operating Systems: Unix, Windows

Confidential, Sept 2009 – till date

Dataworksis a consulting firm specialized in technology solutions for the finance, accounting and operational business areas.

Dataworks Projects:
Client: Confidential,
Languages/Technologies: Oracle, Oracle E-business suite applications, PL/SQL, Shell scripting, MicroStrategy, Oracle BI Discoverer, C#(.Net Framework)
Domain: Banking and Financial Services

My Role:

• Worked closely with the clients for the requirements gathering, technical specifications and user acceptance testing.
• Supervised a team of 3 developers while providing the design and production solutions to complex technical problems.
• Created UNIX shell scripts, oracle procedures, and processes to extract data from various sources as part of the ETL process.
• Implemented complex transformations by creating custom transformations in addition to using built-in ones.
• Assisted unit and system tests and assisted users with acceptance testing.
• Extensive designing with Star and Snowflake Schemas.
• Extensive application development including the database design, developing oracle procedures, functions, jobs etc and web page development.
• Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, prompts, metrics, templates, Custom Groups and Consolidations using MicroStrategy Desktop and Architect.
• Created Advanced Prompts and filters, Conditional, Transformation and Level Metrics for creating complex reports.
• Managed backup of Metadata.
• Enforced advanced administration, management and performance tuning techniques, including warehouse partition mapping.
• Imparted advanced technical troubleshooting.
• Worked with back end Database Administrators to provide requirements for necessary back end tables.

My Achievements:

• I successfully designed and developed the ‘Reportes Regulatorios’ project for Doral bank, which was left unsuccessful by two previous consulting companies. This was a turning point for the association of my company with the client and our team got many informed client accolades.
• I enhanced the performance of the Microstrategy reports resulting in drastic reduction of the execution time.

Confidential, Jul 2009 - Aug 2009

I worked for the School of Dental Medicine, University of Puerto Rico as a programming consultant. My work included designing website, writing macros and providing data storage solutions.

Confidential,Jun 2007 - Jan 2009

Subex is a leading global provider of OSS solutions.

Subex Products:
Product: ROCwareand Syndesis NetProvision
RDBMS: Oracle10g, Informix
Languages/Tools:Java, JavaCC, C++, TCL, Shell scripting, MS Visio
Domain: Networking/Telecom OSS BSS

Products Description:
ROCware 2.0 is a product based on the concepts and methods of Business Intelligence with a primary focus on operational and tactical decision making
My Role:

• Database designing and modeling.
• Defined and developed analytic classifiers, which are the building blocks of the business-intelligent decision making logic.

Syndesis NetProvision is an award-winning, industry-leading solution for the provisioning of connection-based services for residential broadband, business and wireless service providers.
My Role:

• Apart from the existing support for CR cisco routers, we added new support for CX (IOS XR). As part of new development my responsibilities were:
• Database migration from Informix to Oracle.
• Imparting Oracle training to my team.
• Developing PL/SQL procedures, triggers and jobs.
• Extensive shell scripting and TCL scripting.
• Creating technical and functional specifications, including relational database design, using business and system use cases and Visio diagrams.
  

My Achievements:

• I trained my team to use Oracle database efficiently, which was the foundation for the new design for supporting CX functionalities in NetProvision.

Confidential, Aug 2005 - May 2007

Infosys Project:
Client Confidential,
Languages/Tools Java/J2EE, Oracle, PL/SQL, Webshere, VSS ,TOAD

Project Description:
The Business objective of the application BASIX was to capture all the client setup information and disseminate the information to the downstream departments.
My Role:

• Performed Client Requirements Gathering, Requirements Analysis, Design, Development and Testing of the application.
• Developed data models in Oracle Designer.
• Developed and tested Oracle PL/SQL procedures, functions and triggers.
• Developed servlets and JSP pages.
• Extensive Performance tuning of database queries and Quality Assurance.

My Achievements:

• After the application failed user acceptance testing for the first time, I did extensive database performance tuning, which led to the successful deployment of the application in turn.

EDUCATION QUALIFICATIONS

• Bachelor (B.E) in Computer Science