SUMMARY

• Over 5 years of strong professional IT experience as a Software Developer and Production support executive with a focus on Oracle, Teradata Database design and ETL activities using Informatica 9.6/10.0 in Banking, Retail, Insurance and Telecommunication industries
• Experienced in cost benefit analysis, policy planning, implementation planning, Agile and Waterfall models required for initial set up of Projects in IT industry
• Experience in various phases of Software Development Lifecycle (SDLC) such as Analysis, Design, Development, Testing, Deployment and maintenance activities
• Complete knowledge on end to end development activities that includes Solution design, Data Analysis, Data Modeling, Design mappings in ETL and documentation of HLD/LLD
• Experienced in database designing/architecture with SQL Server 2008/12/14 writing database queries using joins, Indexes, views, stored procedures, triggers, normalization, functions, SQL, PL/SQL and query optimization techniques.
• Acted as scrum master while adapting Agile methodology to update stories in JIRA and Service - Now
• Completed the ITIL foundation certification offered by AXELOS regarding Process followed in IT Industry.
• Master of Business Administration (Finance); Master of Science in International Management; Bachelor of Engineering (Electronics and Communication)
• Completed Agile certification offered internally by Confidential Consultancy Services, India
• Proven ability to analyze problems, roots cause, and develop innovative solutions to business challenges and streamlining operations.

TECHNICAL SKILLS

ETL Tool: Informatica 9.6/10.0, Microsoft SSIS

Scripting Languages: JavaScript, JQuery, Angular.js.

RDBMS: MS SQL Server 2008, Oracle 11g, SYBASE, Teradata

Version Controller: MS Visual Source Safe (VSS)

Scheduling Tool: UC4, Control-M

Data Modelling tool: SAP Power Designer

Reporting Tools: SQL Server Reporting Services (SSRS), Tableau, SAP BO, SAP BI, Data Virtualization - Denodo

Cloud technologies: Microsoft Azure

Operating System: Unix, Linux, Windows

PROFESSIONAL EXPERIENCE

Technical Lead

Confidential

Responsibilities:

• Created Informatica Mappings, Session and workflows jobs with different source systems such as RDBMS, flat files and excel.
• Performed Impact analysis, Design and Development of technical modules.
• Implemented better coding standard in Informatica by using parameters and reusability components
• Coordinated with On-site counterparts and clients for requirement gathering and problem solving.
• Interacted with clients for requirements, discussed the feasibility of requirements and participated in the development and Key technical analyst role in the inception, elaboration and construction phases.
• Proposed and implemented enhancements to improve data quality checks for customers which reduced job timings.
• Documentation of Microsoft Azure migration Processes for company future reference.
• Handled change management and incident management requests for production support activities.

Environment: Teradata, Informatica PowerCenter 9.1, Unix, Tableau, AZURE, Service-Now

Technical Lead

Confidential

Responsibilities:

• Implemented data modelling techniques for the creation of tables using SAP Sybase tool.
• Involved in translating the customer requirements into Design specifications and ensured that the requirements translate into software solution.
• Responsible for performance Tuning for the SQL/PLSQL queries that were long time to execute
• Responsible to provide system support once the code is migrated to Test, QA or Production environments.
• Involved in Code reviews and Stored Procedures Optimization.
• Created procedures, function, packages and ETL Mappings, Sessions, workflows different source systems such salesforce, Cordata and CSV files.
• Used data virtualization technique using Denodo tool, to provide an abstraction layer between dataloaded through Informatica and details about thatdatasuch as its type or location
• Handled over five client interactions per day from three different geographies in a busy IT environment to provide technical solutions

Environment: Teradata, Informatica PowerCenter 10.1, Oracle, PL/SQL, Control-M, Denodo

Team Lead

Confidential

Responsibilities:

• Involved in Code reviews and Stored Procedures Optimization.
• WrittenSQL Queries,Stored Procedures,Triggers, Backup and Restore Database, defining roles, creating database users using Oracle and Teradata
• Involved in Testing of database, queries optimization and performance
• Maintained schedules and organized work-flow activities through scheduler UC4
• Assisted Senior Software Architect in developing major aspects of the application and database design
• Performed unit testing to ensure quality and optimum performance output.
• Co-ordinated with Onsite and Offshore team regarding business requirements and progress of the project
• Acted as scrum master while adapting agile methodology to update stories in JIRA
• Exhibited effective written and oral communication skills to clients while sending daily and weekly status reports and deliverables during production deployments

Environment: Teradata, Informatica PowerCenter 10.1, MS SQL, UC4, Jira, Service now

Customer Service Representative

Confidential

Responsibilities:

• Curated excellent customer service by matching customers with products based on their needs and desires to provide service that is prompt, friendly, courteous and active
• Utilized professional telephone manners by placing calls to potential customers and advised them of the company’s services to increase customer awareness and perception
• Recognized the opportunities by taking appropriate measures and action tasks resulting in reaching the potential sales
• Skilled in banking operations such as verifying information, managing accounts, and handling withdrawals and deposits allowing for efficient and accurate banking activities
• Prepared banking tasks such as cashier’s checks and handling cash at the start and end of shifts, increasing confidence when proactively approaching customers
• A dynamic communicator with established customer experience skills who can connect, both verbally and in writing, with different people in a calm, courteous, and effective manner