Resume

Sign in

Data Developer

Location:
Alpharetta, Georgia, United States
Posted:
February 07, 2018

Contact this candidate

Resume:

Styvenson Jeanlys

**** ********* ** ● Atlanta, GA 30350 ● Cell (704) 713 – 4028 ● ac4dqb@r.postjobfree.com

OBJECTIVE To obtain a position as a senior level .net/SQL Developer that perform various IT related duties.

SKILLS

Microsoft SQL Server 2000/2005/2008/2012/2014 Enterprise Manager, SQL Server Profiler, Database Engine Tuning Advisor, BIDS (Business Intelligence Development Studios), SSIS (SQL Server Integration Services), Microsoft Access, TOAD

Data warehouse Knowledge: STAR schema, dimensional and fact tables.

BI Tools: Microsoft Power BI, QlikView

Microsoft Visual Studio 2005/2008/2010, WPF (Windows Presentation Foundation).

T-SQL, Stored Procedures, Triggers, Views, Table-Valued Functions, User Defined Functions (UDF), Common Table Expressions (CTEs), Recursive Functions

Microsoft SSRS (SQL Server Reporting Services), Crystal 8.5/11, Actuate 8

Object Oriented Principles (OOP), SDLC, Agile

ASP.net, C#, VB.net, JavaScript, CSS, HTML, Microsoft AJAX, jQuery

.Net Framework 2.0-4.0

Maximo 4.1.1, Maximo 6.x, Epicor

Microsoft Visual Source Safe, ChangeManDS, TFS, SVN

Team Oriented, Motivated, Excellent Interpersonal Communication Skills.

EXPERIENCE

03/17 – 10/17 WestRock Atlanta, GA

SQL Developer

Implemented various logics through stored procedures, triggers, and user defined function.

Tuned and optimized queries by altering database design, analyzing different query options and indexing strategies.

Assisted the testing team in preparing the test cases and validation of data.

Involved in the defect analysis along with testers to understand the data and to make any modification to code.

Provided data validation, data cleansing, data transformation as well as writing and scheduling complex ETL jobs.

Used various transformations like MultiCast, Conditionalsplit, OLEDB Command, Script Component and Lookup while loading the data into Destination.

Implemented the Package configuration using XML files.

Developed several reports utilizing SSRS (SQL Server Reporting Services).

Used complex expressions to calculate groups, filters, parameterize, and format the contents of SSRS reports.

Developed web application to allow accounting to correct data anomalies. The application was able to greatly reduce support from IT department thus making it feasible to focus on new development and enhancements.

Strong Excel experience utilizing VBA, macros, PIVOT tables and VLOOKUP.

Build minor QlikView reports to adhere to business logics and procedures.

Experience with performance tuning utilizing SQL profiler, database tuning advisor and creating indexes.

Delivered BI reporting solutions in Power BI and Reporting Services SSRS.

Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.

6/16 – 02/17 Ernst & Young Atlanta, GA

Application Developer

Utilized SSIS script task to load large complex data into specified database tables.

Build SSRS reports per business requirements.

Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.

Worked on formatting SSRS reports using the Global variables and expressions.

Created parameterized reports, Drill down and Drill through reports using SSRS.

Prepared the complete data mapping for all migrated job using SSIS.

Developed web pages using ASP.net, HTML and CSS for styling the web page.

Good understanding of Object-Oriented Programming (OOPs) concepts.

Experience in using ADO.NET data controls (Dataset, Data Reader, Data Adapter, Data Grid, Grid View, Tree View and Data List).

Experienced with Microsoft Application building blocks for .Net projects (Data Access, Exception Handling, Caching and Configuration Management Application Blocks).

Executed SSIS packages via batch files.

Deployed packages using environment variables as well as configuration file.

Build, modified and created views, triggers, function and stored procs on SQL Server 2012.

Configured IIS on Windows 2012 Server.

Developed web interface that uses membership provider to authenticate users.

Modified existing website so that users can execute SSRS reports via the web interface. It allows users to login to their respective accounts and execute their reports based on security privileges.

Build Static and Dynamic menus in web interface utilizing a combination of TreeView and SiteMapPath to allow users to easily navigate the website.

Embedded Power BI reports on web portal page and also managed access of reports and data for individual users using Roles.

Migrated existing self-service reports and Adhoc reports to Power BI.

Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.

12/15 – 6/16 GoodCents Atlanta, GA

Application Developer

Create and modify SSIS packages per business requirement.

Utilized script task control to programmatically implement business requirements where it was not feasible to implement using SSIS standard controls.

Build and modified SSRS reports per business requirements.

Configured web application to allow end-user the ability to launch report using front-end application.

Worked on formatting SSRS reports using the Global variables and expressions.

Created parameterized reports, Drill down and Drill through reports using SSRS.

Prepared the complete data mapping for all migrated job using SSIS.

Developed web pages using ASP.net, HTML and CSS for styling the web page.

Good understanding of Object-Oriented Programming (OOPs) concepts.

Experience in using ADO.NET data controls (Dataset, Data Reader, Data Adapter, Data Grid, Grid View, Tree View and Data List).

Deployed packages using environment variables as well as configuration file.

Developed websites that have a consistent feel and look throughout all web properties.

Developed website to allow field techs to enter pertinent information pertain to customer’s assets.

05/15 – 12/15 Bank of America Charlotte, NC

SQL Database Developer

Created and modified SQL Stored Procedures, Triggers, User Defined Functions, Views, and Cursors.

Performance tuning of stored procedures utilizing Database tuning advisor and SQL Profiler.

Adhoc reporting per client’s requests.

Build and modify SSIS packages utilizing BIDS 2012.

Built complex queries utilizing recursive CTE’s.

Documents both business and application processes utilizing Microsoft Visio.

Build SSIS configuration files to adhere to deployment processes.

Utilize SSIS script task extensively to load data from excel files to database tables.

Utilize SVN as the main source control repository.

Modified Web interface to adhere to business logic pertaining to the leasing of company assets.

06/13 – 04/15 HP (Project Management Office) Charlotte, NC

SQL Database Developer and .Net Developer

Created and modified SQL Stored Procedures, Triggers, User Defined Functions, Views, and Cursors.

Utilized Build Extract, Transform and Load (ETL) tools for the purpose of Data Warehousing.

Build and modify SSIS packages per business requirement.

Documents both business and application processes utilizing Microsoft Visio.

Build and modify web pages utilizing VB.net on the .net framework 4.0.

Upgraded existing classic ASP pages to ASP.net pages.

Build master pages to provide a consistent header/footer across related pages. This allowed end-users to remain familiar with the consistent logo and layout of the department.

Utilized ADO.NET technology extensively for data retrieving, querying, storage and manipulation.

Involved in writing complex queries using T-Sql programming.

Involved in creating web methods for web service.

Used Java Script, HTML, DHTML, IIS and CSS for developing Web Pages.

Used Grid View control extensively for data display, dynamic generation of rows, and user input inside template columns. Used Edit Item-Templates and Footer Templates extensively for editing and adding rows.

Involved in complete Life Cycle including Analysis, Design, Development and Testing.

Upgraded legacy classic ASP code to ASP.net 4.0 code.

Maintain documentation to aid in support and build a knowledgebase repository.

Developed web page to allow phone reps to easily enter dispatched information. Application was able to reduce the number of IT request coming from phone reps.

Mentored junior developers on best business practices pertaining to developing application as well as attaining other skillset that were lacking.

01/12 – 06/13 Wells Fargo (Home Mortgage) Charlotte, NC

SQL Database Developer and C# Developer

Created and modified SQL Stored Procedures, Triggers, User Defined Functions, Views, and Cursors

Utilized Build Extract, Transform and Load (ETL) tools for the purpose of Data Warehousing

Designed, Built, and Implemented Microsoft SSIS 2008 packages

Maintained DTS packages for SQL Server 2000

Utilized BIDS (Business Intelligence Development Studio) to modify and create SSRS reports per end-user requirements.

Maintained SQL Server Replication, Mirroring, and Log Shipping

Assisted in consolidation of multiple databases into one data warehouse

Performed Backups, Performance Tuning, Transaction Monitoring. Made recommendations on analysis

Tested and documented best practices. Conducted proactive performance, capacity, and availability audits

Reported and analyzed business issues. Made recommendations to maximize operational efficiency, quality, and compliance.

Worked under limited supervision to analyze and solve complex operational, systems-related and/or customer issues.

Worked with managers to apply data to business goals and analytical requirements.

Assisted in identifying, developing, and implementing policies, procedures, and training materials to assure compliance with government regulations and to maximize efficiency and customer service.

Built C# programs that queries XML data in .rdl files.

Transformed query results into XML hierarchical data file as well as transform XML into SQL structured data.

Built complex SSIS packages to automate various business processes.

01/11 – 12/11 Mecklenburg County Tax Assessor’s Charlotte, NC

C#/SQL Developer

Responsible for designing the advanced SQL Queries, Stored Procedures, Triggers, Cursors, and Scripts

Created, modified, maintained, and optimized SQL server database

Maintained the documents and created reports for Business Analysts and end-users

Was responsible for the management of the database performance, backup, replication, capacity, and security

Performed quality assurance and testing of SQL server environment

Ensured best practices were applied and integrity of data was maintained through security, documentation, and change management

Aided in development, execution, and maintenance of disaster recovery plans for all data services

Documented and maintained database system specifications, diagrams, and connectivity charts

Monitored and provided front-line support of daily processes

Provided training to the managers in using the system, writing and using reports and executing complex queries

Prepared detailed statistical reports utilizing both SSRS and Crystal Reports XI

Developed adhoc programs using C# and Visual Studio 2010 .Net framework 4.0

Designed many different modules, including data parsing which was develop by using C#

Created SharePoint sites with custom lists, calculated columns, alerts and various web parts

Utilized SharePoint designer to connect to an external data sources

Used InfoPath 2007 to design and deploy forms to form libraries

02/10 – 11/10 MIT Charles Stark Draper Laboratory Cambridge, MA

Application/SQL Developer

Provided secondary administrative support for SQL Server 2005 databases

Participated in the design, analysis, and implementation stage for a manufacturing database system

Managed and resolved design issues during development stage. Worked closely with developers on migrating database Schema changes to stage or production

Developed strategies and scripts relating to database backup and recovery

Implemented database refresh using full export. Used “EXPORT/IMPORT” to access table level and full database defragmentation

Performed database tuning using SQL Database Engine Tuning Advisor

Created various documentation to aid users and developers knowledgebase on proper use of front end ERP system

Built and modified Crystal Reports per client’s requests

Developed and implemented new feedback system for users concerns, bugs and defect tracking regarding use and functionality of new interfaces

Utilized ASP.net to build web based customized applications

Developed code and support provided for C#.NET, T-SQL, Microsoft SQL Server 2005

Mentored interns on IT best practices and business procedures

Developed, modified and maintained various types of documentation for Windows based systems including: software user manuals, training materials, presentations, and job aides.

Developed content from requirement and design documents

Utilized Visio software for illustration of work plans and procedures

Used SharePoint Designer to design and develop various custom form web parts, custom edit forms, and custom display forms

Created workflows using SharePoint designer on the documents libraries

Implemented and designed SSIS packages

06/08 – 01/09 Aspect Medical Systems, Inc Norwood, MA

Software Engineer/SQL Developer

Wrote and maintained documentation describing changes and modifications to all systems and databases

Utilized C# and TSQL to design a customized Kanban application integrated with the Manufacturing ERP system to support the company’s inventory reordering process

Was responsible for backups/restores, monitoring SQL uptime, designing, and maintaining DTS packages

Reviewed and optimized SQL Queries, Stored Procedures, and Triggers to achieve maximum efficiency and scalability

Profiled and tuned servers on a monthly basis to ensure fast queries and reports.

Evaluated and purchased Reporting Systems including Case Studio, Visual Studio .NET, NetCharts, and UML diagramming

Have experience in Agile as a set of engineering best practices

Assisted developers and managers in documenting user manuals and knowledgebase repository

Wrote installation and procedural manuals for support staff

Utilized Microsoft Office Visio Professional to document Business Logic and Procedures

Complied with all applicable regulations including Sarbanes-Oxley (SOX)

Provided Security Admin Role for Seibel Application

Ported Access data to SQL Server back end

Modified User Interface code with Visual Studio 2005 utilizing C# programming language

Installed client tools on user machines and establishing connectivity to Progress databases

08/05 – 05/08 Duke Energy Charlotte, NC

Application/SQL Developer

Developed SQL scripts for database backups

Refreshed development/test database from production using Export/Import

Managed database security. Created and assigned appropriate roles and privileges to users depending on the user activity

Installed client tools on user machines and establishing connectivity to databases

Utilized T-SQL to develop libraries of stored procedures to implement complex data access

Documented Work Management procedures

Recorded changes and modifications with the use of ChangeMan DS

Extracted data from various sources, transformed and loaded into the target SQL/Oracle database

Developed SQL scripts to carry out routine checks on databases, including checks on whether all databases were running, listeners were running, disk space availability, segments nearing max extents, and checking for errors in alert logs

Assisted developers and technical writers in documenting work management procedures

Assessed in the development of work-plans concerning perforrnance, enhancement and support

Data loading using SQL * Loader.

Built and modified Crystal reports per customer’s requirements utilizing T-SQL, XML and web interfaces

Utilized both Picasso and Remedy application as the ticket tracking applications

Attended to on-call problems on a daily basis and resolve various database related issues and customer request

Complied with all applicable regulations including Sarbanes-Oxley (SOX)

EDUCATION 08/2001 – 05/2005 University of North Carolina at Charlotte Charlotte, NC

B.S., in Computer Sciences

Related courses

1.Computer Networking I and II.

2.Computer architecture I and II.

3.Computer circuit and logic design.

4.Software Engineering.

5.Artificial Intelligence.

6.Data Structure and Algorithms.



Contact this candidate