SUMMARY:

• Senior System Engineer with over 13 years of IT industry experience encompassing a wide range of skill sets, roles and industry verticals.
• Experienced in transforming client requirements into solutions by applying SDLC activities like Analysis, Technical designing, Coding and Unit testing
• Excellent in system analysis, ER and Dimensional Modeling, Database design and implementing RDBMS specific features.
• Proficient with Normalization (1NF, 2NF and 3NF) to reduce data redundancy and improve data integrity and De - normalization techniques to improve the read performance of a database.
• Proficient in writing SQL Queries, Sub Queries, Views, Materialized Views, Packages, Procedures, Ref Cursors and Exceptions handling.
• Excellent Hands-on Knowledge on SQL queries and creating database objects like stored procedures, triggers, packages and functions using SQL and PL/SQL for translating business requirements into working models.
• Skilled in developing Joins, Indexes and Sequences. Well versed in identifying where to and not to use them.
• Experienced in performing Reverse Engineering of Physical Data Models from data, SQL scripts.
• Extensive knowledge on producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations.
• Supported in creating Tableau visualizations and dashboards with interactive views, trends and drill downs.
• Coherent in UNIX & LINUX Shell Scripting & Python (Beginner) and job scheduling using tools like CA Workload Automation.
• Led several teams as part of earlier engagements and had managed to concurrently setup multiple teams and make them functional in no time.
• Has been part of the “firefighting” team who were expected to maintain good rapport with the client and identify any issues with the technical team beforehand and proactively work on resolutions to avoid escalations.
• Vocal advocate for automation. Pursued interest by building business value adds that helped the team to save time and effort.
• Good knowledge on the end-to-end aspects of Telecommunication, Retail and HR (HCM, Absence and Payroll) Domains
• Good communication skills, interpersonal skills, self-motivator, quick learner, team player
• Good experience with Oracle 9i, 10g, 11g, DB2. DB2 Certified Application Developer

CORE COMPETENCIES:

Database: Oracle, DB2, PL/SQL

Database Access Tools: SQL Developer, TOAD, DB2 Data Studio

ETL Tools: Pentaho Data Integration

Workload Scheduler Tools: CA Workload Automation

Data Analysis Tools: Splunk, Kafka and Kariba solutions (Inhouse).

Secondary Skills:

Automation QA Tools: Parasoft SOATest, HP UFT

Scripting: Unix, VBA (VB for Applications), VB Macros, Nmon report analysis, Python

Mainframe Skill set: COBOL, JCL, CICS, File-Aid, WebSphere MQ

Database Access Tools: SPUFI, QMF, RTLS

Debugging Tools: XPEDITER, INTERTEST

Configuration Management Tools: ENDEAVOR, GuardIEN, CE-Access

Operating Systems: AIX, Linux, Windows Server, z/OS

Defect Management Tools: HP Quality Center, Mercury Clear Quest, BugTracker, Jira, Confluence

Deployment Tools: Jenkins, uDeploy

RAD Tools: AllFusion Gen, COOL Gen

SDLC Models: Agile Model, V-Shaped Model, Iterative Model, Waterfall Model

PROFESSIONAL EXPERIENCE:

Confidential

Senior System Engineer (PL/SQL)

Responsibilities:

• Build SQL scripts, procedures and other DB components to support large data volume application ensuring top notch performance and accuracy.
• Responsible in generating data metrics and identifying new areas of monitoring that can aid in maintaining the system stability and proactively identify areas of concerns.
• Validation and verification of production data and services to ensure smooth functioning of applications.
• Fine tune SQL queries for performance improvement.
• Extensive Data analysis and reporting.
• Designing and building of Oracle solutions and supporting batch routines. Deployment and maintenance of builds across Oracle services in the DEV and QA environments.
• Designed DB structures based on Normalization and De-normalization concepts to reduce data redundancy and integrity without impacting the performance of the system.
• Design, build and maintenance of Unix scripts and ESP batches. Monitor and manage the ESP jobs in CA Workload Automation tool.
• Identify areas for automation and write scripts to ease manual processes. Developed frameworks to automate redundant tasks to minimize manual effort and workarounds.
• Supported the Tableau team with queries and frameworks to support the dashboards and alerts.
• Providing support to various application teams to resolve issues and help teams with the integration of applications during the builds across environments.
• Planning, tracking, change control.
• Establishing Quality procedure for the team and continuously monitor and audit to ensure team meet quality goals.

Environment: Oracle, Unix, CA Workload Automation, Kibana, VB Macros (Reports), Tableau, Python

Confidential

Senior System Engineer

Responsibilities:

• Designing and building of Oracle solutions - SQL scripts, procedures and other DB components to support large data volume and high-volume transaction application
• Deployment and maintenance of builds across Oracle and Mainframe services in the DEV and QA environment.
• Design DB components to support dashboards and alerting to support real-time monitoring.
• Data analysis and reporting.
• Identify areas for automation and write scripts to ease manual processes.
• Providing support to various application teams to resolve issues and help teams with the integration of applications during the builds across environments.
• Planning, tracking, change control.
• Translating customer requirements into formal requirements and design documents, establish specific solutions including programming and testing.
• Establishing Quality procedure for the team and continuously monitor and audit to ensure team meet quality goals.
• Supported Mainframe solutions for technical and functional issues.

Environment: Oracle, Mainframes, COBOL, DB2, JCL, CICS, WebSphere MQ, JBoss, Splunk, Kafka, Kariba, VB Macros (Reports), Unix

Confidential

Business Analyst (Oracle PL/SQL)

Responsibilities:

• Working directly with customers, functional consultants and integration consultants to establish conversion approach, complete migration of configuration and to complete the data conversion/load of customer data into Workday.
• Understanding the technical data conversion issues, expertly resolve issues and communicate solutions.
• Provide functional expertise in one or more Workday functional areas (e.g., HCM, Absence, and Payroll)
• Design and code DB components to translate the data into the required template. Ensure the design handles the high volume of data and it is performance oriented to ensure the SLAs are met.
• Assisting customers with their data extract, explaining the conversion process, defining data requirements and working with them to correct data in their legacy systems and prepare for the data conversion.

Environment: Peoplesoft, SAP, Oracle, Salesforce, Netsuite, Taleo, Workday, Pentaho Data Integration

Confidential

Senior System Engineer

Responsibilities:

• Being a time critical application, there is a conscious effort to create and maintain builds that is fine-tuned and is best in terms of response time. Was critical in maintaining the application across new components and newer builds
• Responsible for designing the best tailored high-quality database solutions for the various new and complex business requirements
• Responsible for leading and guiding a project team in delivering solution to our customer in the Retail sector
• Solely responsible in designing and building Oracle solutions as part of various business requests
• Was part of the SME team to support the application for any production environment issues
• Took constant effort to identify areas with scope for automation and write scripts to ease out the process
• Independently responsible for setting up and onboarding new teams to the account to the point where they can work independently with an on-shore coordinator
• Part of the “firefighting” team who were expected to maintain good rapport with the client and identify any issues with the technical team beforehand and proactively work on resolutions to avoid escalations
• Responsible in the deployment and maintenance of builds across Java, Oracle and Mainframe services in the Dev and QA environment
• Responsible for providing support to the various application teams to resolve issues and helping the teams with integration of applications during the newer builds of the application across environments
• Responsible for planning, tracking, change control, aspects of the project
• Was also responsible in designing and building Mainframe solutions as part of various business requests. The changes include COBOL Batch modules, CICS routines, JCL, DB2 Queries and also CICS programs that can be integrated with other programming languages via SOAP requests.
• Took up assignments from performance and automation testing teams to support them during resource crunch situations. Developed various scripts with HP Unified Functional Testing and Parasoft SOAtest tool for various webservice automated testing. Developed scripts for performance testing an Active Space Application and monitored and created reports as part of the test.
• Responsible for effective communication between the project team, the onsite team and the customer. Provide day to day direction to the project team and regular project status to the onsite team.
• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results
• Utilize in-depth knowledge of functional and Technical experience in Mainframes and other supporting products and technology in conjunction with industry and business skills to deliver the best solutions to the customer
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals
• Was part of the team selected to engage with client in building and proposing POC across new tools and services

Environment: Oracle, Mainframes, COBOL, DB2, JCL, CICS, WebSphere MQ, JBoss, uDeploy, Jenkins, VB Macros (Reports), Unix, Linux

Confidential

System Engineer

Responsibilities:

• Analysis, development, unit testing and defect support of customized mainframe solutions for new implementations and upgrades throughout the MICA Application.
• Provided technical and investigative support for system testers and other functional users on interfaces, defects, change requests, debugging issues, testing, and adhoc report requirements
• Solely responsible for building and delivering the bill message requests from the client

Environment: Mainframes, COBOL, JCL, CICS, WebSphere MQ