Database developer
Resume examples

Managed software development and maintenance for critical system components while constructing efficient processes operating on large distributed systems using Oracle PL/SQL. Delivered complex mission-critical applications in a large processing environment while effectively managing offshore contractors.

• Designed and developed complex applications and programs by collaborating with project teams in gathering requirements.
• Translated business requirements and functional design specifications into technical solutions.
• Collaborated with multi-functional engineering teams to define and implement some of the core backend platform frameworks and systems
• Worked closely with the development team to ensure proper system design and implementation.
• Assessed design and development need to evaluate the proposed changes to build or enhance the software solution.
• Provided ongoing support to users through maintenance and troubleshooting.
• Ensured that security and quality assurance best practices are followed throughout the software development lifecycle.

Managed a team of 7 to 9 developers globally, onsite, and offshore. Provided solutions for business reporting requirements for internal and external customers of Thermo King.

• Managed team activities that include allocation of work, team mentoring, tracking the progress of the work, and ensuring its completion on time.
• Set up the entire BI environment for Cognos and OBIEE.
• Worked closely with the network team for the server architecture to support a robust BI environment. Installed and configured the Cognos and OBIEE toolsets.
• Designed and implemented the complete security model to address data level and object level security for users.
• Played a key role in setting up an enterprise-wide data warehouse solution.
• Performed gap analysis on the business requirements and BI DW environment shortfalls.
• Gathered, documented, and validated business requirements and line the BI space per the requirements.
• Performed detailed analysis of source data and designed the extract transform and load strategies to load the cleaned-up data into the EDW to make it one source of truth for the data.
• Designed and documented the data mappings from source to EDW.
• Designed and developed several DAC plans to facilitate the data loads.
• Stayed cognizant of other projects and their data loads into the EDW and addressed the impact of multiple data loads into the same tables nightly.
• Re-used the existing BI DW components to satisfy business needs for data without expanding the DW BI space unnecessarily with additional components.
• Planned, designed, documented, implemented, and tested upgrades to all components of BI.
• Traveled throughout the globe to present, knowledge transfer, and train user community on a new project.
• Earned Presidents’ Award for the Driving to Excellence project, and the TK Pillar of Pride for outstanding achievement, and various Bravo Awards for project accomplishments.

Developed and maintained complex databases that are highly scalable and manageable. Supported automated deployment and operation of AzureSQL instances in a high-availability environment.

• Optimized and tuned database schemas, stored procedures, triggers, and dynamic queries.
• Built data pipelines for migrating on-premise data sources to the cloud.
• Designed and extended data models for enterprise OLTP applications and data warehouses.
• Created complex queries to derive intelligence from the data with Power BI and other tools
• Supported traditional managerial reports in SQL Reporting Services and documented technical designs and program logic.
• Participated in functional and technical reviews
• Assisted in identifying process improvements and application enhancements while securing the products, tools, and processes.
• Collaborated with a distributed team in multiple geographic locations and time zones.

Instrumental in the development, maintenance, and support of XX databases. Recorded all-new feature development designs on JIRA Confluence and established proper team communication channels. Handled all facets of the SDLC, delivering sophisticated software for the core data apps.

• Solidified skills in designing and optimizing systems for databases with complex plans, big tables, and high transaction rates.
• Swiftly resolved all the technical problems identified through reports on dashboard data and routine database performance analysis.