Styvenson Jeanlys

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

OBJECTIVE To obtain a challenging position in the area of SQL and BI development that would eventually be promoted to a lead or managerial position

SKILLS

Microsoft SQL Server 2000/2005/2008/2012/2014/2016/2017/2019 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.

Windows Server Suite: IIS (Internet Information Services, Reporting Services, Integration Services

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, Power BI, Tableau

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/21 – Present CDC Atlanta, GA

SQL Developer

Worked extensively on creating and modifying SQL stored procedure queries to create valid JSON objects that front-end developers utilize to visually represent periodic data trends.

Build Adhoc reports for business Analyst, Testers and QA lead.

Provided assistance to QA and Testers so that development projects are deployed without bugs.

Assisted in modifying application built with JavaScript technology and C# middleware.

Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.

Utilized GitHub and Bitbucket for source control and JIRA for sprint planning.

Build and Modify SSIS package to import data from various sources into SQL Server.

.

03/20 – 03/21 Truist Atlanta, GA

SQL Developer

Build and modify SSIS packages to adhere to changing business process related to Suntrust and BB&T wealth account merger.

Provide Business with adhoc reports utilizing T-SQL queries.

ETL implementation using SQL Server Integration Services (SSIS), Applying some business logic and data cleaning in staging server to maintain child and parent relationship.

Worked on Extracting, Transforming and Loading (ETL) process to load data from Excel, Flat file to MS SQL Server using SSIS.

Utilized SSIS Script Task component using C# to adhere to changing business requirements.

Modified and Build legacy .Net applications to adhere to changing business requirements.

Regression testing of deliverables as it is deployed in different environments.

Utilized Veracode Static Analysis tool to provide feedback on coding issues such as SQL injection, cross site scripting, etc.

Utilized Software version control tools such as GitHub and TFS.

Provided support for in house applications during off hours.

Designed Power BI visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.

03/18 – 12/19 Wellsfargo Atlanta, GA

SQL Developer

Monitored server critical issues including Response Delay, Locking/Blocking and Server Downtime.

Designed and Developed parametric Reports, Cross-Tabbed and Sub-Reports in SSRS.

ETL implementation using SQL Server Integration Services (SSIS), Applying some business logic and data cleaning in staging server to maintain child and parent relationship.

Worked on Extracting, Transforming and Loading (ETL) process to load data from Excel, Flat file to MS SQL Server using SSIS.

Worked on deploying Cubes in SQL server management studio as well as created partition on that having process full for fact table and process update for dimension daily basis.

Worked on Control flow tasks such as Execute SQL task, Send Mail Task, File System Task, Dataflow Task and used different data sources and destination with derived column, lookup transformation within Dataflow Task.

Experience in creating SSIS packages using different type’s task, with Error Handling, Log particular event by creating logging and worked on package configuration to run package on different server.

Designed dimension modeling for data warehouse. Developed data warehouse to generate OLAP cubes and identified measures and dimensions according to different requirements.

Created and integrated user defined functions and stored procedures for reporting purposes.

Designed and developed various complex reports.

Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time.

Reduced the overall ETL Time by SQL Query Performance Tuning. Discussed with User Interface and External Interface teams over the performance issues and provided solutions.

Designed, developed, tested and maintained Tableau functional reports based on user requirements.

Developed Power BI model used for financial reporting.

Experience in writing DAX functions in Power BI and Power Pivot.

03/17 – 02/18 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 the reports.

Generated various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS.

Developed web application to allow accounting to correct data anomalies.

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

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

Worked on developing cubes, dimensions, measures and partitions.

Query the cube utilizing MDX (multidimensional Expression) language.

Developed reports and dashboards utilizing Power BI.

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.

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

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 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.

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.

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

Modified existing Java code to adhere to new functionality and business requirements.

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