Mohan Sreenivas Email & Phone Number

Bloomington, Illinois, United States

Design, develop and architecture data integration and transformation solutions Analyze and organize raw data and build data pipelines as per business requirementsUnderstanding the new/existing business rules and further design and develop ETL/ELT strategyBuild coding structures and business rules using Python and SQL languagesLead team-wide initiative for Capacity Planning and Performance OptimizationData Ingestion and processing pipeline architecture and design.Worked as a liaison between the business and support team to mitigate any issues between requirement phase and post deployment issues.

Chicago, Illinois, United States

Develop design documents, user guides, maintenance documents, project documentation, and release documents.Understanding the existing rules of analyzing risk and develop a strategy ETL to reduce false positives.Collecting and understanding requirements from Client.·Achieved high performance by handling multiple requests using Multithreading.Developed and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.· Developed a business continuity plan for the SQL Server Databases using JDBC drivers.Created many Stored procedures and scheduled jobs to support our applications for to create reports for customers.Deployed application on Client Linux server.Used ANT built tool for compiling and generating war file.Environment: Azure suite, IBM DataStage, Talend, Oracle, Unix/Linux and Shell Scripting, PL/SQL,Java

Pleasanton, California, United States

Analyzing requirements and understanding current system· Conversion of business requirement to Technical requirement.· Preparation of design document according to the business rules.· Preparation of technical flow and code level design document.· Time estimation for each requirement on the basis of technical requirement.Preparation of high level design. Involved in design and development phases of Software Development Life Cycle(SDLC).· Written SQL and PL/SQL procedures for Hypersonic, Oracle and SQL Server databases.Environment: Core Java, J2EE, Oracle 10g, SQL Server, IBM DataStage.