Bk Test

Seeking a challenging position in an organization which gives me enough opportunities to exploit my innovative technical ideas and analytical skills, and to enhance my skills, thereby can put forth my effective contribution to the organization's growth.

Specialist (Oracle) at LTIMindtree (2019-05 – Present)

I have been designated as a Specialist (Oracle) at LTIMindtree since May 2019.

Job Profile: GPTP (Group Payments Tracking Program) is a HSBC wide program to track E2E payment journey on real time basis. TDS-GPTP has been identified as HSBC Payment tracking service covering all type of domestic and cross border payments via SWIFT GPI. As part of this project, responsible to store payment status that receive from upstream systems via MQ/API and push the status notifications after receipt of SWIFT GPI updates to downstream systems via MQ/API.

• Provided business and technical analysis on TDS GPTP Application.
• Engaged with Interlock systems to trace the issue and the root cause.
• Highly experienced in all aspects of system development life cycle to implement complex conceptual database design and architect and custom applications with the skill-set of ORACLE DB, PL/SQL.
• Implemented Data access layer(DL) using shell Scripts, oracle database modules by creating flexible functions, triggers and stored procedures in PL/SQL.
• Wrote Stored procedures to Isolate Business Rules and to shield the data by limiting direct access to tables, perform iterative and Set-based Processing on large amounts of data in batches efficiently, thus reduce the network traffic, make the maintenance and debugging quicker.
• Developed User Defined functions and Data Types with intention to hide the complex logic and return the value by accepting multiple parameters and to make it reusable.
• Views are implemented to encapsulate very complex calculations and commonly used joins on same set tables.
• Cursors are applied to take advantage of its attributes, thus have more control on data during the traversal of records in conjunction with exception handling.
• Skilled in error/event handling, Logging and rolling back.
• Create a Release patch file containing all application objects and ensure all are in valid status by deploying and testing in different environments like DEV, QA.
• Undergo smoke test/handshake and ensure all are in sync with the application.
• Prepare Release Deployment Checklist and get Change Request approval from Release Manager.
• Monitor and validate the data and performance of the application post deployment.
• Fixed production issue upon receiving Xmatters alert for job failure over Control-M.

Sr. Software Dev Advisor at Experis IT (Formerly known as Fouren Technologies Private Limited) (2017-02 – 2019-02)

Worked as a Sr.

Software Dev

Advisor for Experis IT (Formerly known as Fouren Technologies Private Limited) from February 2017 to February 2019 and was outsourced to DELL.

Job Profile: As part of GSD IT team, responsible for handling the system of record for Dell Assets (Dell manufactured products) and Entitlements (Dell warranty) in SDR repository application developed in 12c for multiple regions globally. It is a critical application for Dell Inc. to manage sales planning, procurement, dispatch and end-services. There are many upstream and downstream source applications integrated with SDR. GoldenGate ER Tool and Oracle Streams are used to replicate the data from the global format of such applications into the legacy formats understood by SDR Applications. Packages are created in SDR which are called as interface APIs for ServicesBIL. ServicesBIL is a middle tier web service using which various end-user client applications get access to insert, update, and delete data in SDR, there by implement data protection logic to prevent bad data from being added to the tables.

Any New

Assets and Entitlements are pushed to production during product upgradation at the time of quarterly release in the presence of all the stakeholders involved in the whole product development life cycle.

• Experience in using recursive CTEs, temp tables to facilitate efficient Data Cleansing and Parsing, Data Scrubbing, data Lookup and mapping, Data validation over raw data on staging tables.
• Provide business and technical analysis, development and project management expertise for business and technology initiatives focusing on GSD Data Warehouse and Business Intelligence solutions.
• Application of one to many and many to one relationships while moving data between multiple databases.
• Applied Normalization rules by removing unnecessary columns, eliminating redundant and inconsistent data, introducing referential integrity, establishing joins and Rebuilding indexes for fast search and retrieval data.
• Analyze and gather statistics for DB objects to trace out DB bottlenecks, identify potential blocking, deadlocking, mutating table, SQL Injection, etc. in the course of Optimizing the performance.
• Performed few DBA activities like Backup, Restore, monitoring, grant Roles, etc. as a part of Security Policies for various Categories of users.
• Created Linked server and running distributed queries to access data from other remote servers.
• Triggers are used to enforce complex business rules, audit data modification, drive column values automatically and reused by multiple programs to fire notifications.
• Prepare Release Deployment Checklist like Appropriate branches exist in Visual Studio Source Control and Codes are checked in and freezed before the Release.
• Create a Release patch file containing all DB objects and ensure all are in valid status by deploying and testing in different environments like DEV, DIT, SIT, PERF.

Senior DB Developer at Epsilon (2015-10 – 2016-09)

Worked as Senior DB Developer for Epsilon (A global leader in digital messaging platform to manage effective multichannel campaigns including email, mobile and social) from October 2015 to September 2016.

Job Profile: One of the most recent project was related to hospital domain and it was built using SSIS and SQL. The process download the source files of hospital from sFTP, refine them as per client specific metrics using Execute SQL Task and ScriptTask inside ForEachLoop Container and load such file data to DB using DataFlow Task. The source files contain the details of Patients i.e., appointment dates, contact details, doctors details who attend such patients. Later the process generate output files and post them to client sFTP. Also it send email to client once the Output files are ready. These files help the client to notify if the specific patient has missed the appointment or has an upcoming appointment in future. Hence client feed these output file details to robo which perform automated calls to such patients accordingly.

Technical Lead at Allegis Group (2015-07 – 2015-09)

Worked as Technical Lead in Allegis Group and outsourced to Hewlett Packard from July 2015 to September 2015. Job Profile: Here the process was related to a Banking Domain. The process was built to access Source DB where Bank provides raw data and lookup tables to perform sanity check by validating and transforming the given data using ODI ETL Packages and PLSQL Packages and store them in a target table.

Senior software Engineer at THEOREM INDIA PVT LTD (2007-06 – 2015-04)

Worked as Senior software Engineer in THEOREM INDIA PVT LTD from June 2007 to April 2015.

Job Profile: As a Developer to the client, I was involved in developing various client specific reports as described below using PERL and ORACLE PLSQL in unix environment. As a SSIS Developer, also developed many SSIS solutions by migrating DTS ETLs to SSIS packages using ScriptTask, ExecuteSQLTask, ExecuteProcessTask, DataFlowTask, ForEachLoop, ForLoop, SendmailTask, etc. and delivered client specific reports. Also as a Reporting Analyst in THEOREM I was used to Pull reports for multiple US clients from search engines i.e, Google, Yahoo, MSN and from publisher tools and 3rd party tools.

DTP Operator at Self-employed (2004-07 – 2007-04)

Worked independently as a DTP Operator from July 2004 to April 2007. Job Profile: Troubleshooting, Installation, Maintenance of Hardware and Software, Office File Maintenance & Attending Customers. Design Book layout, Brouchers, Pamphlets, Invitation Cards, ID Cards Using Corel Draw, Pagemaker, Photoshop, MS Office.

Office Co-Ordinator at Vedanta Bharati (2001-06 – 2004-06)

Worked as Office Co-Ordinator in Vedanta Bharati, K.R.Nagar, Mysore Dist. from June 2001 to June 2004. Job Profile: Library Maintenance, office correspondence, Sorting books and Mailing addresses using Ms Access, Design Book Layout using Pagemaker, Corel Draw, Photoshop. Clipping Audio & Video files using xing player and IFilm Edit, Kannada_Sanskrit software.