Sql Server Developer/ssrs Reports Developer Resume
PROFESSIONAL SUMMARY:
- Extensive background in senior IT positions, several years of experience in database development and software development as well as mentoring thus enhancing efficiency within organizations.
- Highly respected and dynamic achiever in corporate driven paradigm shifts, employee, specializing in time management and problem resolutions to achieve desired results.
- Detail - oriented, process-minded technical professional with a passion for learning new technologies and web-based software systems.
AREAS OF EXPERTISE:
- 5+ years of Confidential -SQL development using the latest Confidential tools
- 5+ years of experience developing SSIS packages and have advanced skills with SSIS
- Proficient in building enterprise level stored procedures and functions.
- Proficient in designing database schemas, including indexing as appropriate.
- Proficient in the use of appropriate SQL development standards as it pertains to supporting a business.
- Ability to optimize new and existing stored procedures and queries.
- Proficient in creating SQL jobs utilizing SSIS packages.
- SQL Development heavy, strong SQL skills are key (read and describe execution plan)
- Data exports and excel type reporting, then expanding into dashboards and analytics
- Open to getting into unit testing
- Develop the report and also analyzing and telling a story based off trends
- SSRS from scratch since
TECHNICAL SUMMARY:
SQL Server 2000/2005/2008 R 2/2012/2014/2016/2017 , (OLTP, OLAP, TSQL, DML, DDL) Oracle 8i & 9i/PL/SQL, Visual Studio.Net 2013,2015 (C#, VB, ASP, ADO), Web Services, Visual FoxPro, VB Script, JavaScript, HTML, CSS, Project Management, SSRS, SSIS, SSAS, SSDT, Table Creation, Salesforce, JIRA, Erwin, MS Access, . NET Framework (2.0 up to 4.5), Google Suite (Calendar, Mail, Drive, Sheets, Docs etc.), Jenkins, Redgate (SQL Prompt, SQL Search, SQL Compare etc.)
PROFESSIONAL EXPERIENCE:
Confidential
SQL Server Developer/SSRS Reports DeveloperResponsibilities:
- MVC/Razor development skills using Confidential Visual Studio 2017.
- Online sessions via Confidential webinars.
- Code Razor pages apps which included scaffolding as well as other entity features.
- Build stored procedures that were incorporated into the web applications.
Environment: Azure, SQL Server (2014), SSMS, Confidential -SQL, Visual Studio (2017), Confidential Office Cloud, TFS (Team Foundation Services).
Confidential, Atlanta, GA
SQL Server Developer/SSRS Reports Developer
Responsibilities:
- Responsible for Confidential -SQL development using Confidential SQL Server for stored procedure creation, query analysis and execution of house reports during employee transition supporting enterprise system data components.
- Developed correct reporting solution within an Agile environment via DBA/developers.
- Coded efforts (data analysis, query generation/optimization, testing) transforming report data/procedures generating timesaving Confidential -SQL query algorithms validating efficiency via SQL Profiler.
- Agile experience using MS Office within the cloud fulfilling requirements gathering/testing thru project release.
Environment: Azure, SQL Server (2008 R2, 2012, 2014, 2016), SSMS, SSIS, Confidential -SQL, Visual Studio (2013/2015/2017 ), Confidential Office Cloud, TFS (Team Foundation Services).
Confidential, Atlanta, GA
SQL Server Developer/SR. Software Engineer
Responsibilities:
- Confidential -SQL development skills using Confidential SQL Server for stored procedure creation, analysis and execution for migration efforts during employee transition supporting MyInfo enterprise system data components.
- Developed the correct reporting solution working closely with Stakeholders, ETL developers and Report developers.
- Ensured data integrity via multiple joins (left, right, inner and outer joins) on multiple tables.
- Optimized several queries for efficient dataset returns using timesaving Confidential -SQL query algorithms.
- Provided guidance in data storage techniques (data warehouse) for efficient data querying.
- Designed/developed Confidential -SQL stored procedures for several apps (WFO, WNO, CFM, CXM, CMB etc.).
- Modified Web application code (.Net/CSS/Javascript) to be compatible between Google and Confidential IE, Jenkins.
- Responsible for Data Exchange via data migration (data analysis, query generation, testing) transforming report data/procedures from Nice Systems to MyInfo enterprise system generating timesaving Confidential -SQL query algorithms ensuring corporate data platform compliance.
- Participated in Agile environment using Jira Ticketing System in meetings with Business Stake Holders from requirements gathering to testing thru project release.
Environment: SQL Server (2008 R2, 2012, 2014, 2016), SSMS, SSIS, Confidential -SQL, SSDT (DACPACS), Visual Studio (2008/2 ), Jira, Jenkins, GOOGLE Suite (Calendar, Mail, Drive, Sheets, Docs etc.)
Confidential, Atlanta, GA
DBA/SQL Server Developer
Responsibilities:
- Responsible for Database development/administration using SSMS for stored procedure analysis/execution.
- Assisted with data migration efforts during employee transition supporting TCEO application data.
- Reviewed Visual Studio .Net for Telerik control updates and SSRS reporting (Tablix, matrix, charts other data regions) for validity/clarity.
- Mediated stored procedure code validating criteria (within the SSMS environment) prior to submission to AHB.
- Data Exchange via data integration/ migration using experienced troubleshooting techniques interacting with AHB for direct DBA correspondence (technically speaking - multiple SQL Server environments in SSMS, each having over 900 constraints for those tables within those environments) objects (views, stored procs, indexes trigger etc.) This was done to match the predefined government data platform.
Confidential, Atlanta, GA
SW Engineer/SQL Server Developer
Responsibilities:
- Developed and restructured SQL -DML (creating schemas, tables, and indexes) to accommodate best practices.
- Served as an escalation point for stake holder/customer issues.
- Responsible for Data migration - Created SSIS/ETL processes by coding stored procedures, testing and implementing ETL mappings and scripts to match Confidential platform.
- Used SQL development skills thus reducing active case load via participation by 20% in 1st quarter by analyzing then creating queries/stored procedures to provide data imports, cleansing that data for validation.
- Ensured that the support team was on pace to meet all defined objectives (Case load reduction, SQL Best Practices).
- Created a GitHub repository then provided (joint/one-on-one) for script consolidation for team and individuals.
- Developed SSIS Packages and Confidential -SQL to solve client repetitive data/system related problems expediently.
- Shared/spread knowledge with team members as well as internal teams regarding corporate issues.
Environment: SQL Server (2008 R2, 2012, 2014), SSMS, SSIS, Confidential -SQL, SSDT (DACPACS), Visual Studio (2008/2010/2013 ), Jenkins, Visio, Salesforce