Shilpa Vellapally Sasi

· Design, develop, implement, and support data integration solutions that support resiliency, stability, and supportability of information technology systems.

· Perform rapid development and refinement of data integration solutions using IBM Infosphere DataStage, Relational Databases, SQL and Unix Scripting.

· Work with business sponsors and application development teams including business requirements review and interpretation, availability, quality, and lineage of source system data analysis, data mapping from source to target by applying data warehousing methodologies and related data integration solutions development and implementation, and socialization of data integration standards.

· Support Data Warehouse applications and utilize tools to manage source system changes, optimize applications and ensure availability, accuracy, security, and performance.

· Work with business to ensure standards and best practices, and data governance requirements compliance and serve as subject matter expert regarding data integration technical questions and capabilities.

• Improved data quality by designing and implementing DataStage jobs for data cleansing, validation, and transformation.
• Enhanced ETL performance through tuning DataStage parallel jobs and optimizing database queries.
• Developed reusable components for common ETL tasks, reducing development time and promoting consistency across projects.
• Collaborated with cross-functional teams to gather requirements, ensuring effective and accurate data integration solutions.

· Develop data warehousing solutions based on the needs by identifying and analyzing the business requirements, translating requirements to technological specifications, and implementing using Informatica ETL tool, relational databases like Oracle and SQL server and Unix shell scripting.

· Worked on both production support and application development.

· Manage and own application Bugs and incident life cycle, and drive those to permanent resolutions, implement preventive measures to avoid repetitive issues.

· Exposure with Data Integration across multiple platforms.

· Worked on different projects related to web page redesign, loading data to IVR, Energy Efficiency areas.

· Responsible for understanding the requirements, developing data mapping documents, design data flow diagrams & Data model and developing ETL mappings.

· Establishing and analyzing business needs, converting them into technical specifications and developing data warehousing solutions based on those requirements using Informatica ETL tool, relational databases like Oracle and SQL server and Unix shell scripting.

· Responsible for understanding the requirements, developing data mapping documents, design data flow diagrams & Data model and developing ETL mappings.

• Collaborated with cross-functional teams to gather and analyze requirements for successful project completion.

· Involved in all phases of SDLC from requirement gathering, analysis, design, development, testing, code review, production implementation and warranty support.

· Identify and analyze business requirements and translate requirements to technical specifications and building data warehousing solutions based on the requirements.

· Developed ETL programs using Informatica PowerCenter to implement the business requirements and all major transformations were used to implement the required business logic.