EXPERIENCE SUMMARY:

• Hands - on IT Lead/Engineer having 12 years of experience in Banking/Telecom/Healthcare software development
• Experienced in Oracle PL/SQL, T-SQL, Data Modeling, Data Migration, Database Performance Tuning, Data Warehousing, Informatica, UNIX Shell scripting and Test Data Management
• Expertise in design and development tools like Informatica, Erwin, ER Studio, PL/SQL Developer, Toad, SQL PLUS, SQL Server Management Studio, TBMS, Business Objects, Tableau, Fast Data Masker, Javelin, GTEDI, CA TDM Portal
• Core competencies include requirement analysis, design, development, testing, time management, prioritization, leadership, problem resolution, decision making and possess excellent interpersonal skills
• Domain expertise in Oracle Mantas Behavior Detection Platform, Payments and Billing domain
• Hands on experience in SDLC Development methodologies like Waterfall and Agile
• Team player with good analytical and problem-solving capacity

SKILLS PROFILE:

• Ability to lead development/support teams
• Ability to prepare Technical and Functional Specifications, to do High level & Low - level Designs.
• Ability to interact with clients and business users for project execution.
• Ability to guide junior Engineers in completing their assignments.

TECHNICAL SKILLS:

Operating System: Windows, UNIX

Tools: Informatica 10.4, ODI, Tableau 9.2, Business Object XI R3, PL/SQL Developer 7.1, SQL Server Management Studio, Erwin, ER Studio, Fast Data Masker, GTEDI, Javelin, CA TDM Portal, Delphix, Toad for Oracle, SQL PLUS, SVN, Clearcase, TFS, C ARA, TBMS, Ant 1.x, SQL Developer 4.x, Benthic, Jira, Git Stash, HP Quality Center, DBCA, HL7, HAPI, EDI, XML, HIPAA

Databases: Oracle 9i, 10g, 11g, 12c, Exadata, Microsoft SQL Server

Products: Oracle Mantas from Oracle Financial Services, TBMS Billing Solution from Confidential

Languages: Oracle PL/SQL, T-SQL, Unix Shell Scripting, UML

PROFESSIONAL EXPERIENCE:

Confidential

Software Developer

Responsibilities:

• Create/maintain Data Models using ER Studio
• Perform data/system analysis, data profiling and querying on large complex data sets in OLTP and OLAP databases to meet business requirements
• Identify sensitive PHI/PII data available in production data sets using HIPAA standards and assign a domain to each data element.
• Deterministically obfuscate real PHI/PII data with masked yet real looking values using Fast Data Masker (FDM) algorithms like HashLov, FormatEncrypt, Concat, SEQLOV, TRANSLATE etc.
• Create automated Database Refresh scripts using complex PL/SQL, T-SQL, procedures, packages and CARA to create subsetted and masked test databases to meet HIPAA regulatory requirements
• Create Informatica mappings and workflows for data extraction and loading
• Define transformation logic for each field extracted from the source
• Use Delphix Self Service to stand up Sandbox Virtual databases, create Branches, Bookmarks and Restore DB to a particular point in time
• Parse and Mask HL7 ADT and ORU production files using HAPI Interface for test environments
• Create Self Service Tiles in CA TDM Portal for user requirements like synthetically generate EDI/XML files, mask EDI/XML production files, EDI Updater etc.
• Optimize existing procedures and functions to ensure better performance
• Develop and execute unit testing programs to access areas such as database impacts, software scenarios, negative testing, error or bug retests
• Co-ordinating with Quality Assurance and helping them to execute test validations in various Test Phases like SIT, UAT.
• Manage ad-hoc test data requests by generating synthetic data, producing masked EDI files and providing end users with a self-service portal using CA TDM
• Refresh configuration and provider data using Informatica
• Documenting project and process related documents as per standards to ensure compliance with internal/external audits
• Provide timely project status and issue reporting to management.

Tools: Oracle 11g, 12c, Exadata, SQL Server, SQL Developer, TFS, CARA, Fast Data Masker, GTEDI, Javelin, CA TDM Portal, Delphix, Informatica, EDI, HL7, HAPI, XML, HIPAA

Confidential

Responsibilities:

• Database design, develop and implement tables, views, triggers, procedures and packages for Visual Autoloader application by creating complex PL/SQL queries
• Create maintenance scripts, clean up scripts, alert scripts and schedule through Crontab
• Review, Optimize and Tune existing procedures and functions, monitor server processes to ensure better performance
• Generate Autoloader Utilization reports using Tableau
• Create Production deployment kits and support during production roll out
• Data load from Production to UAT database
• Creating/executing test cases

Tools: Oracle 11g, PL/SQL, SQL Loader, UNIX shell scripting, Tableau, Crontab, Benthic, SQL Developer, Jira, Git Stash

Confidential

Principal Consultant

Responsibilities:

• Development using PL/SQL and testing of Citi Customizations - CitiKYC, Segmentation, Alert Risk Scoring for Anti Money Laundering applications
• Manual Testing and Defect Tracking
• Support for Oracle Mantas Behavior detection platform and Citi customizations for NAM and LATAM regions
• Interacted with Clients to accomplish the project requirements.
• Assisted various teams for SIT, UAT and Production deployments and testing

Tools: Oracle 11g, PL/SQL, SQL Loader, Informatica 9.1, UNIX shell scripting, SQL Developer, HP Quality Center

Confidential

Responsibilities:

• Design and develop conceptual, logical, physical data models and data flow diagrams.
• Design and development of views, triggers, scripts, schedules, procedures and packages for DDIN Preprocessor and Global Funds Check modules
• Design and Develop Data warehouse and DataMart for SEPA Reporting using Informatica and PL/SQL scripts
• Define transformation logic for each data field extracted from the various data sources.
• Data Migration
• Development of SEPA Reports using Business Objects
• L2 Support for Account Settlement and Account Lookup modules
• Review, optimize, and tune application to ensure better performance
• Support for Technical and Business Go-Live
• Create and Manage Technical Design Documents
• Manage Release activities
• Ensured customer satisfaction by focusing on quality and communicating with customers and management, and resolving critical database issues in a timely manner.

Tools: Oracle 11g, PL/SQL, Informatica 9.1, UNIX shell scripts, Business Object XI R3, Clearcase, SVN, Erwin, PL/SQL Developer, UML

Confidential

Implementation Engineer

Responsibilities:

• Development of customization modules in PL/SQL
• Interface/Reports Development and Maintenance using Crystal Reports
• Post live Support
• Onsite team member for TBMS Billing product Implementation

Tools: Oracle 10g, PL/SQL, Shell Script, TBMS, Crystal Reports, SVN, Toad for Oracle, Ant and Seminars