SUMMARY

• 9 years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Experience in Teradata performance techniques like Index, skewness reducing, join index, partitioning, collect stats, secondary index selection, Teradata data locks. Handling dead locks.
• Extensive Experience on Teradata database, analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverables with in committed timelines.
• Experience in Business Analysis and Data Analysis, User Requirement Gathering, User Requirement Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Experience in working with DMaaP Services for Message Router and Data Router services.
• Having Good exposure on emerging technologies like Dev opps and Dec Sec ops and Digital skills like (Java script, Node Js and Angular).
• Having good idea on Hadoop architecture.
• Experience in Dimensional Data Modeling, using Data Modeling, Star - Join Snowflake Schema Modeling, FACT & Dimensions Tables, and Logical & Physical Data Modeling using ERWIN.
• Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, Multiload, Fast Export, Tpump, Visual Explain, Query man), Teradata parallel support and Unix Shell scripting.
• Proficient in coding of optimized Teradata batch processing scripts for data transformation, aggregation and load using BTEQ.
• Expertise in RDBMS, database Normalization and Denormalization concepts and principles.
• Experience working on the project built using the Agile Methodology. Involved in the estimate planning, design discussions and scrum meetings for the project.
• Experience in leading and managing teams. Technical Lead, Developer, Application SME.
• Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views. Having knowledge on index and table portioning.
• Very Good experience with the Clients and other Businesspersons. Daily interaction with the clients for any production issues, Maintenance requests solution reviews, Design reviews.
• Proficient in analyzing and translating business requirements to technical requirements and architecture. Delivering the projects with quality and timely manner.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Self -motivated, highly committed to responsibilities and ability to work independently. Ability to perform well within cross-functional teams.
• Good interpersonal and communication skills and is experienced in working with senior level business personnel’s, Clients and developers across multiple disciplines.

TECHNICAL SKILLS

Scripting: Shell Scripting, Java Script

OS: Windows, Z/OS, LINUX

Languages: COBOL, SQL, HTML, CSS

FraBackend: Coldfusion

Tools: Teradata Sql Assistant, Power Center 9.5.6, Toad, Connect Direct, Eclipse, FTP, SVN

PROFESSIONAL EXPERIENCE

Confidential

Technical Lead

Responsibilities:

• Analyze, Design and develop the Projects, Involved in the Business and system requirement analysis.
• Proposing the Innovative ideas to the clients for improving the quality of the application and enhancing the applications to meet the client requirements.
• Proposing the innovations with stage architectures for building stable applications.
• Analyzing Mainframe performance issues like COBOL + DB2 programs and enhancing the jobs for better performances.
• Always looking for emerging technologies like Dev ops, Devsec ops and API’s
• Improving the performance of the process like Mainframe jobs CPU time and Data base processing time.
• Data Modeling, Snowflake Schema Modeling, FACT & Dimensions Tables, and Logical & Physical Data Modeling using ERWIN.
• Automating the manual process which helps in improving the quality and time.
• Working with the clients on the daily basis and help to them fix any data issues also help them improve the application by understanding the client needs.
• Works with Business Analyst in translating business requirements into Functional Requirements Document and to Detailed Design Documents.
• Writing the High-level designs and reviewing with the clients, SME’s.
• Being point of contact for the application and Pro actively responding to clients for the project requirements, issues and adhoc requests from the clients.
• Always keep improving on the lessons learned from the prior projects, issues and other work requests which helps in improving the quality of the delivery and client’s satisfaction.
• Developing the code and ensuring that other team members performed as per requirements. Conducting the code reviews.
• Playing key role starting from the Design to Deployment of the projects.
• Analyzing the Teradata query performances to improve the processing time to meet the client requirements.
• Supporting the Daily production process and Abends fix, Working on Month end activities to generate the reports.
• Participating the UAT with the clients and getting the results approved.
• Lead analysis sessions, gather requirements and write specification and functional design documents for enhancements and customization; Analyze product impact
• Establish Quality Procedure for the team and continuously monitor and ensure the team infallibly follows the defined standards and meets quality goals.
• Coordinate and communicate tasks with developers in offshore and helping them for all kinds of technical support required.
• Communicate activities/progress to project managers, business development, business analysts and clients.
• Develop implementation and test plans, build software acceptance criteria, coordinate and work with clients to the acceptance and dissemination process.

Senior System Engineer

Confidential

Responsibilities:

• 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.
• Worked on the Teradata stored procedures and functions to confirm the data and have load it on the table.
• Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
• Worked on optimizing and tuning the Teradata views and SQL’s to improve the performance of batch and response time of data for users.
• Prepared low-level technical design document and participated in build/review of the BTEQ Scripts, Fast Exports, Multiloads and Fast Load scripts, Reviewed Unit Test Plans & System Test cases.
• Coordinate with Configuration management team in code deployments
• Creating and maintaining source-target mapping documents for ETL development team.
• Done the impact assessment in terms of schedule changes, dependency impact, code changes for various change requests on the existing Data Warehouse applications that running in a production environment.
• Prepared low-level technical design document and participated in build/review of the BTEQ Scripts, Fast Exports, Multiloads and Fast Load scripts, Reviewed Unit Test Plans & System Test cases.
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Created a cleanup process for removing all the Intermediate temp files that were used prior to the loading process. Streamlined the Teradata scripts and shell scripts migration process on the UNIX box.
• Responsible for leading a project team in delivering solutions for the projects
• Resolving Production emergency fixes and Maintenance requests (MRs) in a priority order determined.
• Deliver new and complex high-quality solutions to clients in response to varying business requirements.
• Working as Senior Application Developer for the Enhancement projects in both Water fall and Agile methodology
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
• Utilize in-depth knowledge of functional and Technical experience in UNIX, Informatics and Teradata and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
• Playing key role starting from the Design to Deployment of the project
• Coordinate and communicate tasks with developers in off shore and helping them for all kinds of technical support required.

Senior System Engineer

Confidential

Responsibilities:

• Works with Business Analyst in translating business requirements into Functional Requirements Document and to Detailed Design Documents.
• Worked on the Teradata stored procedures and functions to confirm the data and have load it on the table.
• Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
• Worked on optimizing and tuning the Teradata views and SQL’s to improve the performance of batch and response time of data for users.
• Prepared low-level technical design document and participated in build/review of the BTEQ Scripts, Fast Exports, Multiloads and Fast Load scripts, Reviewed Unit Test Plans & System Test cases.
• Coordinate with Configuration management team in code deployments
• Creating and maintaining source-target mapping documents for ETL development team.
• Done the impact assessment in terms of schedule changes, dependency impact, code changes for various change requests on the existing Data Warehouse applications that running in a production environment.
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Created a cleanup process for removing all the Intermediate temp files that were used prior to the loading process. Streamlined the Teradata scripts and shell scripts migration process on the UNIX box.
• Data Modeling, Snowflake Schema Modeling, FACT & Dimensions Tables, and Logical & Physical Data Modeling using ERWIN.
• Playing key role starting from the Design to Deployment of the projects.
• Supporting the Daily production process and Abends fix, Working on Month end activities to generate the reports
• Lead analysis sessions gather requirements and write specification and functional design documents for enhancements and customization; Analyze product impact
• Establish Quality Procedure for the team and continuously monitor and ensure the team infallibly follows the defined standards and meets quality goals.
• Writing the High-level designs and reviewing with the clients, SME’s
• Coordinate and communicate tasks with developers in off shore and helping them for all kinds of technical support required
• Developing on the code and ensuring that other team members performed as per requirements
• Communicate activities/progress to project managers, business development, business analysts and clients.
• Develop implementation and test plans, build software acceptance criteria, coordinate and work with clients to the acceptance and dissemination process.