SUMMARY

• Dynamic, self - driven ETL/B. I developer with over 5 years’ success devising innovative and tailored solutions to meet ever-changing business requirements within diverse industries
• Drove high visibility projects at all stages of the Software Development Life Cycle (SDLC) that had a direct impact on revenue recognition
• 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
• Experienced in various phases of Software Development Lifecycle (SDLC) such as Analysis, Design, Development, Testing, Deployment and maintenance activities
• Experienced in handling and managing team of 6 people in a fast-paced IT environment
• Experienced in Agile and Waterfall methodologies
• 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)
• Certified in Agile Methodology
• Proven ability to trouble shooting, problems-solving, roots cause analysis, 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, Tableau

Cloud technologies: Microsoft Azure, Salesforce

Operating System: Unix, Linux, Windows

PROFESSIONAL EXPERIENCE

Technical Lead

Confidential

Responsibilities:

• Reduced development costs by 15%, by eliminating 1 Million Dollar loss of a production down issue by redesigning complete ETL logic and improving the database performance through modifying SQL queries
• 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
• 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

Technical Lead

Confidential

Responsibilities:

• Slashed software development costs by 20% through delivering Analytical database application 15 days ahead of schedule, while ensuring the quality of code by using Informatica
• 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 which required optimization
• Responsible for providing system support once the code was migrated to Test, QA or Production environments.
• 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

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 a higher 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.
• Handled change management and incident management requests for production support activities.

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