Abiola Pedro
SQL Developer at Arrowpoint Corporation- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
ITIL v3 - Present
*
Experience
-
Arrowpoint Corporation
-
United States
-
Information Technology & Services
-
1 - 100 Employee
-
SQL Developer
-
Dec 2017 - Present
• Reviewed, evaluated, integrated data from multiple data sets into one database system to streamline information. • Interpreted data, analyzed results using statistical techniques and provided ongoing reports. • Developed and implemented data collection systems and other strategies that optimize statistical efficiency and data quality. • Acquired data from multiple sources and add it to the database. • Identified trends or patterns in complex data sets. • Filtered and cleaned data, and reviewed computer reports, printouts, and performance indicators to locate and correct code problems. • Worked closely with management to prioritize business and information needs. • Located and defined new process improvement opportunities. • Written scripts to analyze data and perform specific data queries. • Responsible for updating 2 data inbound feeds in a server that supported data related to the RCMS-G/SMMS systems using Oracle client. • Manage work to assigned due dates. Notify manager of any conflicts or other issues related to timely delivery of work • Assist client managers with development of client work orders • Working with other senior database developers & management • Responsible for performing SQL development and SSIS /SSAS/SSRS development • May act as Project Leader and/or may be involved in providing assistance and training to less senior developers • Review the designs, code, and test plans of other developers and provide recommendations for improvement or optimizations Show less
-
-
-
USAID
-
United States
-
International Affairs
-
700 & Above Employee
-
SQL Developer
-
Feb 2015 - Dec 2017
• Work as an SQL/Java Developer and establish strong relationships with end users and technical resources throughout established projects • Work closely with the development team to provide support for database objects (stored procedures/triggers/views) and performing code review • The SQL Server Developer will work closely with Application Developers to ensure proper design and implementation of database systems • Database administration including performance monitoring, access management and storage management • Partners with development teams/vendors to provide reporting on in flight software development projects • Create, develop and maintain SQL processes for channel performance data warehousing • Closely working with development manager and onsite team to deliver solutions • Assists in preparing project plans using project management tools • Improves performance of T-SQL stored procedures • SQL Development - Writing Transact SQL • Deploying environments/applications fixes, patches, improvements • Performing environments/applications upgrades Show less
-
-
-
Maryland Live Casino
-
Hanover, Maryland, United States
-
SQL Developer
-
Aug 2014 - Jul 2015
• Monitored and tuned database resources and activities for SQL Server databases. • Performed and automated SQL Server version upgrades and patch installs. • Designed, developed and maintained relational databases. • Developed, implemented and maintained enterprise business information systems. • Develop SSRS reports and configure SSRS subscriptions per specifications provided by internal and external clients • Work on support tickets, maintenance tasks and assigned projects at discretion of the Reporting Coordinator. • Maintain existing Crystal Reports against legacy system and rewrite these reports in SSRS against new data warehouse • Developed and Optimized Stored Procedures and Functions using T-SQL • Participated in several projects and interacted with peers • Gathered business requirements and converted it into SQL stored procedures for database specific projects • Daily reconciliation of pharmaceutical industry data sets • Created a sophisticated Inventory analysis report for vice president of commercial operations and the sales operations department head • Designed query accessing JD Edwards Oracle database to pull information for government Sunshine act compliance Show less
-
-
Community
