Dynamic and goal-driven specialist with 8+ years of comprehensive experience in software application project development and management, database management, data analysis, marketing and sales support, customer service and technical support. Adept at collaborating with cross functional teams to ensure successful project deployments. Excellent communicator who works closely with customer teams to optimize project deployments in customer environments. Proven track record of delivering successful projects and providing excellent client support.
• Analyzed three datasets from Chicago Data Portal (the census, crime, and school data) for a given neighborhood or district, to identify causes that impact the enrollment, safety, health,
environment ratings of schools using SQL queries.
• Analyzed a fleet inventory data in Microsoft Excel using pivot tables.
• Analyzed a car dealership dataset in Microsoft Excel and IBM Cognos Analytics to understand the sales and service departments using appropriate Charts and Dashboards.
• Extracted Stock data for Apple and AMD using yfinance and Pandas to analyze their historical share price and dividend in Jupyter Notebook.
• Extracted Stock data from a web page for Netflix and Amazon using BeautifulSoup and Pandas in Jupyter Notebook.
• Extracted Stock data for Tesla and GameStop using yfinance, BeautifulSoup and Pandas to analyze their historical revenue data in Jupyter Notebook.
• Collected data using API and web scraping, explored and analyzed using SQL queries and python libraries and presented findings and insights through visualizations, actionable dashboards and reports.
• Discussed with clients to establish a detailed requirement for their software applications.
• Attended project meetings, logged notes and managed presentations.
• Developed detailed proposal specifying requirements, operations, the user interface, outputs and presented proposals to clients.
• Worked with cross-functional project teams to develop and manage software products.
• Managed releases, versions, technology change management for all software solutions.
• Transformed eligible voter’s database in Microsoft Excel and loaded the cleaned data into deployed iDecide®- E-voting application in Microsoft Azure.
• Designed database schema and wrote SQL Scripts as needed by Software applications.
• Designed and implemented a cloud deployment solution in Microsoft Azure for E-voting application thereby reducing voter’s complaint by 70%.
• Ensured 99.99% Azure SQL Database availability during iDecide®- E voting application usage.
• Backed up, managed and maintained client database after every project in accordance with the Standard Operating Procedure of the organization.
• Created project completion report for all projects deployed.
• Supported marketing and sales team with sales leads.
• Handled customer complaints through emails, phone calls and chats.
• Participated in the development of Standard Operating Procedures for customer support services, this significantly improved SLA achievements and general customer satisfaction.
• Researched and reported on new and emerging technologies, risks, opportunities and trends in the market
• Worked with the compliance team to test new software applications, ensuring alignment with standards and customer expectations and developed application documentations.
• Assisted with database designs, development and implementation for new software applications using Microsoft SQl Server.
• Administered and maintained client databases in Microsoft SQL Server or MySQL.
• Assisted with development of an enterprise system called DEVCIS using Microsoft Visual C#.
• Assisted with the migration and upgrade of organization products (iDecide®- E voting system and Staff Attendance and Access Control System (SAACS)) from visual C# platform to Python.
• Performed the database migration of the organization’s (NIGCOMSAT) Staff Attendance and Access Control System (SAACS) database from Microsoft SQL Server to MySQL.
• Performed the database migration of the client’s database from Microsoft SQL Server to MySQL during application upgrade.
• Performed technical sales proposal presentations and exhibitions of organization’s product and services.
• Oversaw the functionality of data communication equipment, including routers and switches, to ensure optimal connectivity.
• Performed Network monitoring, Incident response, Communications management and Reporting
• Participated in the Project Monitoring, Inspections and Reporting
• Researched and prepared a report on policy and programs regarding Indigenous culture in the K-12 education system in Newfoundland and Labrador.
• Handled data research and data collection from relevant sources for analysis.
• Investigated and explored collected data to recognize and identify patterns, trends and answer relevant questions.
• Prepared visualizations and reports to communicate findings to relevant stakeholders.