SUMMARY:

• An experienced IT professional specializing in database design, development, implementation and maintenance with overall 11 years of experience in various aspects of Database management including Data modeling (Dimensional and Relational), Data analysis, Reporting, performance tuning, maintenance, query analysis, SQL PL, optimization, Unix/Shell scripting, ETL Development(Informatica). Worked with large financial institution. Demonstrated leadership, team skills and ability to achieve goals with minimal directions.
• Involved in various projects related to Data Modeling, Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Knowledge and experience in Dimensional Modeling using Star Schema, normalization/de - normalization, SCDs, Identifying Facts and Dimensions, Physical and logical data modeling using Erwin, PowerDesigner.
• Worked on full development cycle of large Data Warehouses, Relational databases including requirements gathering, design, implementation, testing, maintenance and production support
• Database and Programming experience in development, maintenance, production support
• Extensive Experience in Database Optimization and Performance Tuning, resolving various database issues and bottlenecks by working directly with Development team
• Capacity planning, Handling large databases, Data migration
• Worked on implementing advanced features like data partitioning (DPF), table partitioning, multi-dimensional clustering (MDC) for performance optimization
• Setting up Q replication between Operational Database and Reporting database and troubleshooting issues associated with Qrep source tables, fixing out of sync data issues.
• Developing processes and procedures to enhance stability and performance of database environment.
• Extensively developed Stored Procedures for reporting, data feeds to downstream systems.
• Design and develop ETL workflows using Informatica PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor.
• Create Unix/Shell, Perl scripts for automation, database monitoring and maintenance
• Experienced in working with senior level managers, business people and developers

TECHNICAL SKILLS:

• Databases - DB2, Sybase
• Data Warehousing
• Data Analysis
• Data Modeling
• Database Design
• Performance Tuning
• Database Administration
• ETL
• SQL PL
• Stored Procedures
• Unix
• Linux
• Shell Scripting
• Informatica
• Testing
• Software Project Management
• Requirements Analysis
• Software Development Life Cycle (SDLC)

PROFESSIONAL EXPERIENCE:

Confidential

Senior Database Developer

Responsibilities:

• Perform application development support activities including database modeling, plan and execute database schema changes, implementation,testing of physical db structures, prod deployment, data refresh, bottleneck analysis, outage prevention/resolution, server/db performance improvements, database maintenance, metadata management, concurrency planning
• Create entity relationship diagrams and multidimensional data models, work on commerce model to integrate multiple data models and for supporting several Enterprise Data initiatives
• Database development (building complex SQLs, stored procedures, ETL,tools) and queries/stored procedure review, optimization
• Extensively developed Stored Procedures for reporting, data feeds to downstream systems
• Scripting, design/analysis, monitoring, maintaining, troubleshooting, and tuning UDB databases
• Upgrade database servers and application tools
• Capacity planning, estimating tablespace size based on data growth
• Experienced in using IBM utilities and tools used for database monitoring (db2pd, db2top, DB2 trace, online performance monitors, reports, EXPLAIN, DB2 catalog queries), data movement and organization (LOAD, UNLOAD, RUNSTATS, REORG)
• Implement advance features like MQTs, Range Partitioned Tables, MDCs,Federation,Nicknames
• DB2 DPF implementation. Create design document, analysis to choose distribution key, study hardware requirements for database partition implementation.
• DB2 Q replication setup and monitoring. As almost all the database servers were replicated it was required to plan database changes, prepare runbooks including replication suspension and adding Q subscription for new source/target tables.
• Monitor replication queue for error, warnings and latency.
• Analyze and fix data issue if replication goes down.
• Enforce database security, standards and guidelines
• Create and maintain documentation such as Functional design documents, detailed design documents, data flow diagrams, data entity relationships documents for all the internal projects.
• Effectively manage day-to-day interactions and relationship with diverse teams

Confidential

Senior Software Developer

• Create reports to check usage and dependencies of all resource on a GRN
• Develop processes and scripts to decommission all resources on a GRN(System)

Confidential

Project Leader

• Development of Hygiene and Data Quality Reports
• Provide logical and physical database design and implementation using PowerDesigner. Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships.
• Implement DB2 DPF and range partitioning.
• Setup DB2 Q replication
• Creation and modification of primary database storage structures (tablespaces) and primary objects (tables, views, indexes). Develop stored procedures, function, triggers for business requirement.
• Performance tuning, backup and recovery
• Perform capacity planning and analysis
• Establish Database Security guidelines
• Unix/Shell Scripting
• Perforce setup, build and prod deployment
• Deployment of database application changes
• Provide technical and lead database support for various application tools to facilitate successful completion of established goals
• Requirement gathering, change management, analysis, reporting, project coordination
• Mentoring, Team & People Management

Confidential

Senior Database Developer

• Study in-house requirements for the datawarehouse and develop logical and physical data model.
• Development,testing and implementation of stored procedures database objects, reports and data analysis.
• Created dimensional model for the reporting system by identifying required dimensions and facts (star schema) using Erwin r7.1 for Enterprise server database supporting Know Your Consumer, Database Hygiene, and LDAP Usage Logging initiatives
• Used forward engineering, reverse engineering techniques
• Experience in using DB2 Maintenance Utilities (Reorgchk /Reorgs/Runstats)
• Extensively used db2 data movement utilities like export, import and load and db2look
• Setup partition maintenance
• Database permission setup
• Space management
• Database Release management
• Daily core hour onsite support presence and on call availability
• Effort Estimation and tracking
• Mentoring & training

Confidential

Senior Software Developer

• Provide support for data analysis and database design.
• Worked on logical/physical data model using ERWin for setting up relational database to store ETL metadata. Used ERWin to ensure that data model is in sync with database.
• Database development and db specific shell scripting.
• Making structural changes to the database like DB objects creation, alterations (tables, indexes, views and stored procedures)
• Managing database user privileges
• Create and maintain database backup/restoration scripts.
• SQL Query creation and tuning on Inventory database.
• Unix/Shell Scripting

Confidential

ETL/Database Developer

• Designing the overall ETL plant.
• Created interface for Salesforce APIs, to sync the ETL workflows for retrieving the data.
• Actively involved in Developing Mappings, Define Workflows, Worklets & Tasks, Monitoring and maintaining Workflows, Sessions and logs using workflow monitor etc.

Confidential

DBA

• Installation and maintenance of Oracle 9i, 10g servers
• Database creation and maintenance, including initializing the parameter files, SGA configuration, datafiles, log files and tablespace maintenance
• Performance and tuning: Query tuning (using v$ tables, Explain Plan, STATSPACK, TKPROF, OEM),Index Tuning, Tuning database with Initialization parameter
• Database import/ export activities
• Day-to-day DBA support for dev team and testing team.

Confidential

Junior DBA

• Installation and maintenance of database servers
• Backup and recovery Management, DB export and import activities
• Query optimization and performance tuning