Summary

Highly skilled Database and Application designer offering 15 years of experience in designing and developing solutions for retail industry, associations, mission-critical projects. Very well experienced in all phases of the software development lifecycle expert in translating business requirements into technical solutions and fanatical about quality, usability, security and scalability.

Professional Experience

• 15 years of experience in Relational Database Design and Development.
• 10 years of experience in Trade Union, Labor Union and Professional Associations.
• 10 years of strong experience in SQL, PL/SQL, Triggers, Procedures and Functions
• 5 years of experience in Retail industries and back office automations.
• 5 years of experience in ETL development with Syncsort DMEXpress 7.12/7.13
• 5 years of experience in developing data modeling such as Conceptual data Model, Logical Data Model, Relational Data Model, Physical Data Model and Dimensional Data Model
• 8 years of Query performance tuning in Oracle and SQL Server using indexes, Explain plan, SQL trace and TKPROF
• 6 years of experience in Data conversion and migration
• 4 years of experience in UNIX shell scripting
• 10 years of system development lifecycle SDLC experience focused on Database design, application design and implementation.
• Provided DMExpress and Data Modeling training to Client and Team members.
• Knowledge of data access technologies ADO.NET, ADO, OLE DB, XML/HTML, ODBC.
• Analyze business requirements and translate them to software and database designs to meet the business requirements and, educate the various project teams on the proper usage of data structures.
• Experience documenting Requirements, Designs, issues and Test results
• Excellent in handling the team and the responsibilities independently as well as proactive self-starter.
• Experience in Agile System Development Lifecycle Methodology
• Strong in User documentation, project architecture, system specifications, project planning, interaction with end users, schedule meetings, reviews, follow-ups and preparation of test modules.
• Analyzes functional, business applications and design specifications for functional activities.
• Write block diagrams, logic flow charts and build Mockup screens to aid development process.
• Always Strives for Operational Excellence, Good Communicator, Problem Solver, Innovative Thinker, Action Oriented, Collaborative, Ability to Adapt to Change

Skills

• ETL Development Environment: Syncsort DMExpress 7.12 / 7.13
• Data Modeler: Oracle SQL Developer Data Modeler, TOAD, ERwin
• Database: Oracle 10g/11g, SQL, PL/SQL, SQL Server, MS Access, MySQL, T-SQL
• Development Environment: TOAD, SQL Developer, InstallShield 8.0, Gupta SQL
• Language: C , VB.NET, ASP.NET, Visual Basic, VBA, C, SQL, ADO, HTML, XML, JSON,
• Version Control Environment: Subversion, Windows TFS, Visual Source Safe
• Tracking Applications: JIRA, ClearQuest
• Platforms: Windows, UNIX, Linux, Window Server, Web Services

Experience

Confidential

Database Architect/Developer

• Developed ETL process to integrate data between Independent Processing States and NEA using the DMExpress 7.12 development tool.
• Design and developed the UniServ Grant system
• Developed detail technical design using the Balsamiq mockup tool, Visio for flow diagrams.
• SQL, PL/SQL Programming using SQL Developer and TOAD in Oracle 10g/11g
• Developed procedures, Functions and, Triggers.
• Create and maintain the database objects using Oracle SQL Developer Data Modeler
• Developed Membership Dimensional Data Modeling using Star Schema and Snowflake Schema.
• Developed UniServ Grant Dimensional Data Modeling using Star Schema and Snowflake Schema.
• Database performance tuning using Explain Plan, SQL trace and TKPROF methods
• Used Agile Development Methodology.

Confidential

Technical Consultant

• Responsible for Detail Technical design and Configuration Management,
• SQL, PL/SQL Programming using SQL Developer and TOAD in Oracle 10g.
• Developed procedures, Functions and, Triggers.
• Data Conversion, Data Integration and Migration activities.
• Requirement gathering and preparing the design document.
• Worked on Financial Data integrity.
• Coordination with offshore development teams
• Query tuning using Explain Plan Table, SQL trace and TKPROF.
• Responsible for application database administration support

Confidential

Programmer/Analyst

• Responsible for requirements gathering, creating requirement document SRS . Design and development of Class Libraries for database access and business logic.
• SQL, PL/SQL Programming using SQL Developer and TOAD in Oracle 9/9i.
• Developed procedures, Functions and, Triggers
• Design and development of methodologies that convert data into XML string and fill a dataset to display on the GUI developed using VB.NET
• Design and development of browser lists using HTML and CSS to convert the data table data in to HTML data string and write it into the web browser control of the windows form.
• Design and development of an install program for SYSPAC application using InstallShield 8.0 developer software.
• Responsible for developing Data models from the user requirements. Build Conceptual model, Logical Model, Relational Model and Physical Model
• Responsible for business process analysis that included requirements facilitation, definition analysis, alternatives, software selection, prototyping, business process design and mapping.
• Software version control using the Visual Source Safe.
• Responsible for the information gathering report design and assisted in the report design process, produced reports using Crystal reports.

Confidential

Developer

• Software requirement study, enhancement and implementations,
• Developed and implemented the online taxware software
• SQL, PL/SQL Programming using SQL Developer and TOAD in Oracle 9
• Developed procedures, Functions and, Triggers
• Crystal Reports Development
• Design and developed on site Meeting Module, and developed utilities to print badges on plastic cards using a 'Fargo Quatro ID card printer', tickets and receipts printing on thermal transfer tag printer for Society of Critical Care Management.
• Onsite report analysis for RE/Max Denver.
• Prepared interface program design document to interface the third party A/P software

Confidential

Software Engineer / System Executive

• System requirement study for Production and circulation departments.
• Developed UI screens using Oracle Forms and Oracle Reports for various modules.
• Developed an interface program for the Ferag-newspaper bundling machine to read the quantity from the IIS system.
• SQL, PL/SQL Programming using SQL Developer and TOAD in Oracle 8.
• Developed procedures, Functions and, Triggers
• Developed user interface menu utility in Solaris using scripts for database shutdown, Database startup, Database offline backup and shutdown Unix operating system
• Developed the screen to store and display the agent name in the regional language.
• Involved in user training.
• Responsible for Oracle DBA Activities such as Export/Import, Backup, Query performance.
• Created the database with the character set 'AMERICAN AMERICA.WE8ISO8859P9' to store the regional language in the database.