🚄 Mission: To enhance operational efficiency by analyzing, defining, and optimizing business processes through integrated IT solutions. Contributing to PRASA's information strategy, ensuring systems alignment with business needs.Key Accomplishments and Responsibilities:📊 Conduct systems analysis, driving actionable recommendations for improvements.🛢️ Design, develop, and maintain databases; troubleshoot and repair corrupted data.📋 Define specifications for new databases, aligning with evolving requirements.💬 Engage with end-users to identify needs and deliver tailored IT solutions.🔄 Monitor environmental changes impacting business processes, adapting strategies.🤝 Collaborate with stakeholders, leading group sessions to define processes.💡 Advise regional project teams on business process analysis and definition.📝 Develop policy guidelines for business process analysis across departments.🛠️ Manage system maintenance, ensuring high availability and performance.🧑‍🤝‍🧑 Mentor MIS team, driving performance management and growth.📈 Oversee vendors and service providers, ensuring quality deliverables.📞 Foster relationships with internal stakeholders to support ICT initiatives.

● Perform source data profiling with the help of source system experts.● Convert business requirements into high and low level dimensional model.● Design the data architecture of the data warehouse.● Design and develop the SSIS packages to extract data from various sources like Text Files, SQL Server and Oracle data sources.● Combines stored procedure and TSQL scripts with SSIS packages as part of the ETL process.● Deployed SSIS packages from development to testing to live servers.● Scheduled SQL Server jobs to execute end to end deployed SSIS packages.● Creating different types of reports such as Cross Tab, Drill Down, Drill Through, Summary, Sub Reports, Parameterized and format them using SSRS.● Deploy and schedule reports using SSRS to generate daily and monthly reports.● Assist users on report interpretations and applying different formulas on Excel.

Software Development: I gained an in-depth understanding of existing applications, programming logic, structure, and dataflow. I proposed and implemented improvements to code and database structures, enhancing efficiency.Testing and Documentation: I wrote, verified, and tested code, ensuring that it met specifications. I maintained clear records of code changes and database updates, facilitating version control and compatibility.Software and Database Maintenance: I identified and addressed problems and opportunities for refinement, maintaining a comprehensive list of bugs and fixes. I kept program and user documentation up to date.Software Application: I facilitated the use of simulation models and decision support programs, processing output for research and advisory purposes. This involved retrieving, reformatting, and setting up input data, ensuring data integrity, and contributing to technical reports and presentations.Liaison: I assisted in the familiarization and training of new staff members with SASRI models and decision support programs. I also provided support to internal and external users by answering queries and receiving feedback.

Instructed students in computer networks troubleshooting and installation, following the curriculum based on the CompTIA A+ booklet.Conducted interactive classroom sessions to facilitate a deep understanding of computer hardware, software, and network concepts.Guided students in hands-on practical exercises, enhancing their skills in computer assembly, configuration, and troubleshooting.Administered and graded assessments and exams to evaluate students' comprehension and progress in CompTIA A+ principles.Provided individualized support and assistance to students who needed additional help in grasping complex technical concepts.Created and maintained a conducive learning environment that promoted active student participation and engagement.Stayed updated with the latest developments in computer hardware and networking technologies to ensure that students received current and relevant information.Collaborated with other educators to enhance the overall curriculum and teaching strategies.Fostered a passion for information technology among students and encouraged them to pursue further certifications and careers in the field.

Provide guidance and support to students as they work on programming assignments and projects. Answer questions, clarify doubts, and offer assistance with coding challenges.Assist students with the technical aspects of programming, including debugging code, resolving errors, and troubleshooting software development issues.Review and provide feedback on students' code to help them improve their coding practices, adhere to best practices, and optimize their solutions.Conduct demonstrations, mini-lectures, or workshops to explain complex programming concepts and techniques, helping students gain a deeper understanding.Encourage collaborative learning by fostering an environment where students can share knowledge and work together on programming tasks.Assist students in problem-solving by guiding them through logical thinking processes, helping them to break down complex problems into manageable steps.