SQL Analyst
Developed and maintained reports for company analytics using multiple Business Intelligence tools.
- Designed databases, stored procedures, reports, and data input interfaces using SQL Server 2005, 2008 and C#.
- Developed C# applications add-ons for ERP systems to better accommodate user needs and provide accurate information validation.
- Created and updated applications for internal company operations using C#, SQL Server 2008 and SQL Server 2005.
- Maintained and provides support for multiple ERP systems.
workforce
at this job
SQL Analyst
Wrote complex SQL queries using complex joins, grouping, aggregation, nested subqueries, cursors, etc.
- Performed analysis and presented results using SQL, SSIS, MS Access, Excel, and Visual Basic scripts.
- Imported, exported and manipulated large data sets in multi-million-row databases under tight deadlines.
- Wrote and automated tools and scripts to increase departmental efficiency and automate repeatable tasks.
- Manipulated files and their associated data for rapid delivery to clients or loading onto internal databases.
- Collaborated with project managers, legal counsel, and other team members to gather data for projects.
workforce
at this job
SQL Analyst
Build and maintain SQL 2008 scripts, indexes, and complex queries for data analysis and extraction.
- Create daily reports in designed Excel spreadsheet with pivot tables.
- Identified data issues and provided recommendations for resolution to ensure optimal performance.
- Performed and conducted complex reporting analytics
- Diagnosed and addressed operational data requests
- Interacted and communicated with colleagues as needed as both a technical and functional expert.
workforce
at this job
SQL Analyst
Adept at working with clients to determine business needs
- Performed sophisticated ad-hoc or ongoing custom analyses against medical claims to support business stakeholders
- Developed and deployed quality T-SQL codes, stored procedures, views, functions, triggers and jobs
- Designed and Populated specific tables, databases for collection, tracking and reporting of data
- Built SSIS packages to extract, transform and load data to data warehouse
- Created and automated SSRS reports
- Diagnosed and addressed operational data issues
workforce
at this job
SQL Analyst Developer / Business Intelligence Analyst
- Analyzed data collected in stores (DTS Package, T-SQL, jobs, stored-procedures and queries) and provided reports to the commercial team (Excel, VB Script, Macro)
- Compiled lists of stores respecting criteria given by client services, while minimizing collection costs (T-SQL, Queries, Views)
- Assured and checked the quality and the integrity of the data received from the store collectors (T-SQL, Queries, jobs, stored-procedures)
- Wrote and analyzed trending reports, drew extrapolations from findings to/with the project manager and the commercial team (SSRS, Excel, T-SQL, Queries)
- Optimized DTS, stored procedures and jobs into SQL Server to increase overall performance and time/server use of daily functions
- Created and optimized processes in the Data Warehouse to import, retrieve and analyze data in the Data Mart System (Jobs, DTS, Queries)
- Employee of the year in 2007 for best teamwork player
workforce
at this job
Database Architect/sql Analyst
Developed and performed quality assurance activities and unit testing.
- Modified and maintained oracle procedures using SQL and Cold Fusion.
- Interacted with BI team in fine Tuning SQL and creating webFOCUS reports.
- Wrote database scripts & PL/SQL stored procedures, functions and triggers.
- Developed SQL Reports using advanced queries in OLTP system and webFOCUS.
- Participate in the development of an automated testing strategy and deliverables.
- Performed advanced queries on views, which was used in the metric reporting tools.
workforce
at this job
SQL Analyst
Assisted project personnel in writing better MS-SQL (T-SQL) for data conversion quality assurance.
- Evaluated QA / data conversion MS-SQL for logic problems. Automated key testing scripts via MS-SQL programming.
- Created procedures to steer QA away from rubber stamping conversion code toward true independent evaluation.
- Left contract because client was not ready to proceed.
workforce
at this job
SQL Analyst
- Performed audits of suppliers' processes to ensure continuous improvements in customer/supplier relations
- Managed the suppliers' action plans to ensure maximum efficiency within quality and logistics
- Facilitated the implementation of VMI (Min/Max, Consignment)
workforce
at this job
SQL Analyst
Provided remote administration and support for 65 servers in 15 business services centers.
- Managed remote support via Microsoft Systems Management Server and Terminal Server.
- Used Microsoft SQL Server 6.5 for remote database support.
- Trained users on SMS and Terminal Server.
- Provided extensive Application Support.
- Provided HelpDesk and Technical Support.
- Worked Remedy HelpDesk Trouble Tickets.
- Project Management experience.
workforce
at this job
Senior Pl/sql Analyst - Team DBA
Having originally been scheduled to be the RAC DBA, they placed me into a system analyst position to wait for the DBA position to open. [company name]'s in the business of processing healthcare billing processing for various parts of the U.S. healthcare delivery system.
- Extensive tuning activities on pl/sql procedures, functions, procedures, and such to enhance performance.
- Extensive programming activities (pl/sql) on a 10G/11G RAC development system for ultimate deployment to production.
- Development of rman backup routines to implement best-proactive backup activities.
- Recommendations for Oracle best practice implementations.
- All sql was converted from embedded to dynamic as part of my activities.
workforce
at this job