MURALI MUNIAPPAN

Address: **** ****** ** *** ***, Audubon, PA, 19403 USA

Mobile: +1-470-***-**** adzi3q@r.postjobfree.com

PROFESSIONAL SUMMARY

Highly skilled software development professional bringing more than 11+ years in software database design, development and Integration.

Advanced knowledge of SQL Server, MySQL Oracle 11g PL/SQL, PostgreSQL

6+ Years work experience on Domain knowledge in healthcare.

Skilled in data warehousing tools, data mapping, unit testing, migration, conversions, and process documentation

Proficient in developing Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, Ad-hoc reports using Business Objects.

Expertise in designing, developing, maintaining and tuning of RDBMS like MySQL, PostgreSQL, Oracle, SQL 2017 etc.

Highly proficient in the use of MYSQL, Oracle, PostgreSQL and T-SQL for developing complex creating Database, Tables, Indexes, Views, Triggers, Stored Procedure, User Defined Function, relational database models and data integrity, SQL joins and query writing.

Experience with SQL Server 2017 new concepts like data partitioning, online indexing, Data Definition Language (DDL) triggers, Dynamic Management views (DMV), Dynamic Management Functions (DMF).

Extensive experience in Extracting, Transforming and Loading (ETL tools)

Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

Experience in Data Modeling (logical modeling and physical modeling), Entity relationship diagram (ERD) development/normalization and physical database schema design using ER Studio

Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Views, TSQL Scripting.

Experience with Production (24 X 7) and Development Environment.

Works well under pressure and consistently meets deadlines and targets while delivering high quality work.

In-depth understanding of data management (e.g., permissions, recovery, security and monitoring)

Experienced in all stages of the development cycle for migration and dynamic projects.

Maintaining strong database level security and Performance Tuning and proactive database tasks

Expertise in database performance tuning, data modeling and DB Migrations.

Having Knowledge in DBA activities, J2EE and Oracle Forms. System analyst specializing in object-oriented analysis and design.

SKILLS

SQL Server 2017

MySQL 5.6 & 5.7

Oracle PL/SQL

PostgreSQL

Performance Tuning

Redgate

Octopus

DBA Activities

Jira, Confluence

GIT & Bitbucket

TeamCity

Basics of J2EE and Unix

WORK HISTORY

Coforge ( NIIT Technologies ) – Client SEI

Sr. Technical Analyst Philadelphia, PA, USA October 2019 – Current

Acting as SQL Sr. Developer for implementing complex business solutions into System design.

Analyzing the Sprint stories (Agile Model) and created new data model to support ETL larger files in Informatica.

Produce queries to analyze data from the source systems and the data in the data warehouse using T-SQL.

Data Modeling Reviewing and architecture support for multiple projects which are implemented using different RDBMS database like SQL Server, Oracle, PostgreSQL etc.

Worked on various latency issues and provided solutions to improve the efficiency of reports in ( SQL Server, PostgreSQL, Oracle)

Collaborating closely with all the other members of the team to take shared responsibility for the overall efforts that the team has committed to.

Generated complex stored procedures, views to support the informatica ETL Load operations.

Analyzed existing slow queries and tuned the system design to support varies system to access the information’s in data warehousing

Designed strategic plan for component development practices to support future projects.

Worked with automation of Version control software (Git) to support database structure

Providing support for your code along with maintaining and enhancing existing applications

Help validate business requirements, and suggested modifications might affect the existing functionality

Plan delivery of work

Ensure all project artefacts are stored in confluence and are complete and up to date

TATA CONSULTANCY SERVICES – Client Bank of America

Analyst Atlanta GA, USA September 2013 – October 2019

Acting as onsite coordinator and sharing data-modeling and design for customer requirements

Achieve Business standards and ensure application & environmental security by upgrading hardware & software as per client standards

Acted as Performance engineer for PostgreSQL Database.

Designed new architecture and Data modelling for new system enhancements in PostgreSQL Database

Resolved the application latency issues by fine tunning database queries in MySQL, PostgreSQL, Oracle PL/SQL databases.

Ensuring quick response to production incidents, and speedy resolutions/fixes

Acted as Tech Lead for offshore database team

Analyzing of existing system requirements and functionalities, prepared the documents for product development

Conduct code review of all new implementations and change requests before component integration testing.

Schedule regular meetings with client to discuss and document the business requirements. Update ongoing project status and updates

Prepared scalable data model for entire product with to adopt new future and enhancement changes

Implemented tools and scripting for database monitoring and File monitoring for L1 Production support teams

Involved in project management activities like software and server cost estimation, client billing and reporting etc.

Provided continued maintenance and development of bug fixes and patch sets for existing applications.

Strengthened developmental Methodologies by introducing a code quality document

Modified existing software to correct errors, adopt new customer requirements and improve performance

Provided technical training and guidance to the team by reviewing the team efforts periodically

COGNIZANT TECHNOLOGY SOLUTIONS – Client Hartford Insurance

Programmer Analyst Chennai May 2011 - July 2013

Built, tested and developed scalable, highly available and modular insurance products like Price correction, Tax Exception calculation and Product Automation etc.

Implemented company policies, technical procedures and standards for preserving the integrity and security of data, reports and access.

Generated dynamic stored procedures, xml stored procedures, triggers for the database development.

Experience in Database Tuning.

Worked with multiple joins and sub-queries for complex queries involving multiple tables for reporting to the end users.

Experience in creating packages using different type’s task and with Error Handling.

Designed strategic plan for component development practices to support future projects.

Coordinated with systems partners to finalize designs and confirm requirements.

Provided documentation on start-up, shut down and first level troubleshooting of processes to production support L1 team.

Consistently met deadlines and requirements for all production work orders.

Developed data architecture design to enable analysts to perform targeted customer analysis.

Worked closely with clients to establish the problem specifications and system designs

Involved in Performance tuning and DBA activities

QUALITIME SOFTWARE PVT LTD

Team Leader Coimbatore May 2008 - May 2011

SQL Server 2005 RDBMS database development including T-SQL programming.

ETL implementation using SQL Server Integration Services (SSIS).

Developing reports on SSRS on SQL Server (2005).

Experience in creating SSIS packages for XML based Business to Business Data exchange using different type’s task and with Error Handling and Reporting Capability.

Using SSRS, creating well-formed reports and web-based reports for logistics applications and invoicing reports transactions.

Expertise in designing ad-hoc reporting for different level of end user.

Experience in administrating the created reports and assigning permission to the valid users for executing the reports.

Fine-tuned the complex database stored procedures and increase performance up to 10%.

Involved in Backing up and Restoring of databases.

Taking weekly database backup and schedules job using SQL Agent.

Coordinated with systems partners to finalize designs and confirm requirements.

Provided continued maintenance and development of bug fixes and patch sets for existing web applications.

Designed strategic plan for component development practices to support future projects.

Provided methodologies for object-oriented software development and efficient database design.

Developed data architecture design to enable analysts to perform targeted customer analysis.

Analyzed and designed relational database using Oracle 11g

Maintained existing application and designed and delivered new functionalities and enhancements changes

Debugged, tested and modified software components

Contributed Oracle 11g and Unix scripting used in automated deployment of software on multiple vendors and virtual machines

Provided support for built databases and table structures following n-tier architecture methodology for web applications

EDUCATION

MASTER OF COMPUTER APPLICATIONS, MCA Computer Programming

Anna University Distance Education

Chennai, 2015

Top 74% of class

BACHELOR OF COMPUTER APPLICATIONS Computer Programming

University of Madras

Chennai, 2013

Top 76% of class

DIPLOMA IN COMPUTER ENGINEERING Computer Technology

Thiagarajar Polytechnic College

Salem, 2008

Top 98% of class

CERTIFICATIONS

Oracle Certified SQL Expert

Oracle Certified PLSQL Associate

Contact this candidate