SUMMARY:

• Extensive knowledge and 360 degree exposure in Data Modeling, Analysis and Design. Understanding and 3 years of working knowledge with Total Systems 2 in financial transactions environment
• Exhaustive knowledge and understanding of Data Flow & Architecture in various domains aforementioned along with thorough understanding practices in the industry.
• Experienced in Installations, migrations, partitioning and archiving of Very Large Databases in development, testing and production environments.
• Study, research, analysis and solution providing based on Harvard Business Review Case study teaching methodology complimented with 6 years of hands - on experience in the industry.
• Strong knowledge in relational database management systems (RDBMS)
• In depth knowledge of programming languages including C, Java, .NET and Database Architecture and Administration tools including SQL Server 2005/ 2008/ 2012 Release Candidate versions, Oracle 11g/10g environments, MySQL Enterprise Suite, MS Access versions, TOAD, WAMP and XAMP Servers. Strong in UML, Windows XP, 7, UNIX, Linux, Os X environments.

TECHNICAL SKILLS:

Databases: Oracle10g/11g, MS Access, SQL Server 2005/2008/12, MySQL

Testing Tools: Win Runner, Load Runner, Quick Test Pro.

Database Tools: Toad, ERWIN, MySQL Workbench, SSMS, SSIS, SSRS

Languages: XML, UML, Perl, HTML, C, Java and .NET

Operating Systems: Windows NT/98/2000/XP/7, MS-DOS, UNIX, Linux, OsX

PROFESSIONAL EXPERIENCE:

Database Architect

Confidential, NYC

Responsibilities:

• Database modeling including physical modeling (from logical modeling) to object creation
• Database Design (E-R, Schema Design and Table Design) using Oracle and MySQL Enterprise Suites
• Designed and developed databases with more than 250 tables and 100 ready to use queries
• Data modeling, forward & reverse engineering from Code to GUI and vice versa in MySQL & TOAD + ERWIN
• Query Optimization, cost analysis and turnaround time analysis of complex queries
• Performance tuning, maintenance and backup (discs and tapes) of databases larger than 200GB
• Work flow Design, Flowcharts and Application Mockups using Balsamiq Software
• Oracle Software Migration from 10g to 11g in Development, Production environments
• Complete Database Systems Migration from PostgreSQL to MySQL
• Backups and generating data files for importing and exporting into other heterogeneous systems and formats

Environment: - Oracle 11g/10g, PostgreSQL, SQL Server 2008, Balsamiq Mockups, MS Word, MS Excel, MS PowerPoint, MS Access, MS Projects, MS Visio

Database Architect and Technology Project Manager

Confidential, Boston

Responsibilities:

• Liaison between the CEO, CTO, President, Vice President and Director of Publishing to design and develop workflows and processes for their Mobile Applications
• Schema Design, Database Construction, Query Design and Optimization (Development DBA; ERWIN, MySQL & WAMP, XAMP Servers)
• Content and information to database through parsing, database to web applications, database to mobile applications, partitioning and archiving methods . Also worked with SQL Server 2008 and MS Access + Java + Ruby on Rails + Drupal Web CMS technologies.
• SQL Server Installations, Configuration, Maintenance. Includes SSIS, SSRS
• Migrating all the heterogeneous databases into MS Access and SQL Server engines
• Defined universal format for data in XML markup.
• Provided backend and database connectivity support for Web applications and mobile applications (both Android and Iphone) Environment:- Oracle 10g, MS Access, XML, SQL Server 2008, Java, Ruby on Rails, Drupal, MS Active Directory, Win 7 Statistical Research Literature/ Algorithm Writer, Confidential Spring 2011 Department of Statistics, Confidential Faculty of Arts and Sciences
• Analysis of Product Variety and Product Line Algorithms
• Analysis of Multi-Line and Multi-item Product Inventory Models
• Shelf Space Algorithms and their applications
• Designing flowcharts for application development and further research on Product Inventory Algorithms

Environment: - MS PowerPoint, Arena 10 Simulation Software, MS Word, MS Visio

Support Engineer

Confidential

Responsibilities:

• SQL Server 2008/2005, Os X Servers Management and performance monitoring
• Scheduling backups and maintenance
• User creation, roles and privilege granting, ticketing system management,
• IT management including software troubleshooting

Environment: - Proprietary Ticketing System, Print Queue Management System, Billing Systems, Windows XP/7, Mac OS, Os X Servers, SQL Server 2008/2005 T.A.

Confidential

Responsibilities:

• Supporting Faculty and Staff Computers, Maintaining School computers in 3 labs.
• Imaging and reimaging; Software and hardware installations and configurations
• Provided troubleshooting and support for architectural plotters

Environment: - Windows XP/7, Mac Os X, Rhino, VRAY, Cisco VPN, MS Office

Database Developer

Confidential

Responsibilities:

• Worked on a project involving building in-house Human Resources applications for Appraisals, benefits, health and life insurance.
• Actively involved in Database Design and Software Development Life Cycle
• Interaction with in-house Human Resources Department about user requirements, employees about user ps, program manager for business requirements and Software Project Manager for functional requirement analysis. Wrote AD HOC queries, extracting data from the existing systems
• Co-ordinated with external insurance providers for implementing the desired policy, premium and claim options available to different band of employees in the spectrum
• Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing.
• Ensured all applications were tested for functionality and were adequately controlled in production.

Environment: - Oracle8/ 9i, MS Word, MS Excel, MS PowerPoint, MS Access, Internal Application Development Design Software, TOAD Data modeler

Database Analyst

Confidential

Responsibilities:

• Worked on a project in Corporate Payment Solutions Portfolio. From a non-technical perspective, it is a web portal for the members of the portfolio to initiate transactions like an increase in credit limit, payment cycle reminders, manage automatic payments, report lost/stolen card instantly, claim unauthorized/ fraudulent charges, fetch consolidated statements on a card in Total Systems 2 Interface
• Designed and developed Use Cases Scenarios, Use Cases Models, Activity Diagrams, and Sequence Diagrams. Wrote queries to extract data from Total Systems Interface.
• Responsible for all the requirement deliverables and Reported Issues and Status throughout Project Life Cycle
• Assisted in developing ER models for internal database design used for CRM and performance monitoring.
• Assisted in formulating testing documents like Test Plans, Test Scripts, Traceability matrix and Test summary report
• Involved in system testing, functional testing and regression testing