TANYA D. PICKENS

**** ****** *****, *******, ** *0189 630-***-**** ac4ctf@r.postjobfree.com

PROFESSIONAL SUMMARY

Experienced Lead Software/Applications Developer. Accomplished, innovative IT professional with comprehensive multi-industry experience. Strong understanding of relational database concepts. Proven talent in Database Analysis, Database Development, Reporting, and common Administration tasks with Visual Studio, Reporting Services (SSRS), and Integration Services (SSIS). Skilled in SQL Server Business Intelligence tools, Data Modelling, Data Warehousing, Erwin, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Microsoft Visual SourceSafe (VSS), Data Warehousing and ETL processes.

Designed, Developed and Implemented many large scale Enterprise Resource Planning (ERP) application modules like Financial, CRM (Customer Relationship Management). Accomplished Lotus Notes/Domino software/web development utilizing such skills as Lotus Notes @functions, LotusScript and Domino Administration. Adaptable and detail-oriented performer in difficult and high-pressure situations. Thrives in a diverse and global workplace. Consistently lauded for communication, technical writing and teamwork.

AREAS OF COMPENTENCIES

Programming Languages/Software

SQL (queries, stored procedures, and triggers), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Lotus Notes/Domino Application Development (Lotus Notes @functions &LotusScript), Lotus Notes/Domino Administration, VBA, QuickPlace, Sametime, SharePoint, Visual Basic, Javascript, .NET 2.0 & 3.5, C++, HTML, COBOL I & II, Micro Focus COBOL, JCL, CICS, Assembler, RPG, Oracle PL/SQL, Basic

Databases& Object Oriented Programming

SQL Server 2005/2008/2008R2/2012/2014/2016, Lotus Notes, MS Access, SharePoint, DB2, Oracle, RBASE, SPUFI, LotusScript, Javascript, .NET 2.0 & 3.5, Java

Operating Systems& WAN/LAN & Hardware

Domino, Windows, UNIX, AS400, CMS, DOS, PS/2, OS-MVS, TSO-ISPF, TCP/IP, Domino Server, Client Server, IBM3090, IBM9000, IBM PC's

Miscellaneous

Business Intelligence Development Studio (BIDS),QlikView, ER Studio, Tableau, Visual Studio 2005, 2008, 2010& 2015, Visual Studio .Net 2003,Windows Server 2003, MS Visual SourceSafe, Domino System Administration, Internet Information Services (IIS) 6.0, BEA Aqualogic web infrastructure, TOAD, LEI, QuickPlace, TeamStudio, Sametime, Systems Development Life Cycle (CASE), Lotus Accelerated Value Method (AVM), VBA, MS Word, MS Excel, MS Project, MS Powerpoint, Photoshop, Panvelet, File-aid, Abend-aid

PROFESSIONAL EXPERIENCE

SQL / SSRS Report Developer

Client: Platinum Home Mortgage – Rolling Meadows, IL September 2017 – Present

Actively participating in the report and dashboard development of complex data initiatives, including gathering of business requirements, technical specifications, prototyping, and implementation.

Developing reporting code and reports to support company reporting, operation, and analytic needs.

Collaborates with other business entities for new reporting requests.

Build effective working relationships with all functional areas.

reate and review data models for new components using ERWin tool

Contribute to the design and implementation of new applications as well as enhancements within company website and existing custom applications.

Extracted data from the XML file and loaded into the database

Actively participates and processes direct mail extracts in accordance to the business needs.

Helps engineer new ways to simplify and improve processes.

SQL Server 2016.

Visual Studio 2017.

Lead SQL Developer

Client: Epsilon – West Chicago, IL May 2017 – June 2017

Developed scalable and reliable data warehousing solutions using Microsoft T-SQL and SSIS.

Built and maintained platforms that provided traditional data warehousing, BI, datamarts, and email marketing solutions.

Began development on a database used for driving marketing campaigns.

Developed unit testing and performed developer testing of code changes.

Performed peer reviewsand code walk through.

Documented new development.

SQL Server version 2016

Visual Studio version 2015.

SQL / BI Developer

Client: Komatsu America Corp. – Rolling Meadows, IL September 2016 – April 2017

Developed BI and reporting solutions on the Microsoft SQL Server/BI reporting stack (SSIS, SSRS, and SSAS).

Developedcustomized reports in SSRS.

Analyzed and developed dashboard reporting format using Tableau.

Developed database programming in SQL Server with stored procedures and T-SQL.

Delivered and maintained comprehensive SSRS reporting and user access through SharePoint.

Developed and supported reporting in Crystal, MS Excel, MS Word, and PDF formats.

Performed production support and project development work.

Performed R&D on integrating the client’s system with other ERP solutions using Crystal Reports

Create and review data models for new components using ERWin tool

Helped develop strategic technical direction within the business intelligence function.

Performed other duties related to projects such as creating analysis documentation, gathering requirements, creating requirements and design documentation.

Provided support to a core business intelligence and reporting technical team for ETL, BI and database solutions

Work with users on gathering business requirements, designing enterprise solutions and implementing solutions for end-to-end development.

Recommend, develop, and enforce IT and database standards, guidelines, and procedures in order to facilitate quality assurance and document data requirements for database design.

Develop detailed technical specifications and ETL documentation, comply to internal standards and guidelines.

Provide post-implementation production support by performing problem analysis and resolution as needed.

SQL Server version 2014 & 2016

Visual Studio version 2015.

SQL Developer

Client: Athletico – Oak Brook, IL December 2015 to September 2016

Responsible for the management and support of custom developed reporting systems.

Supported the integration of management reporting systems, SSRS and QlikView.

Supported and managed back end data infrastructure such as data warehouse and report server databases.

Provided SQL Server database design, development and administration (SSRS, SSIS, SSAS) duties.

Provided SQL programming using T-SQL to create stored procedures and basic queries.

SQL Server version 2014.

Visual Studio version 2015.

Lead BI Developer

Client: MB Financial – Chicago, IL September 2015 to December 2015

Contributed to the design and implementation of Business Intelligence vision including data governance, data usage, and control processes.

Assisted in governing and managing BI hierarchies, change control, issue tracking, prioritization of work to be interfaced to EDW, lead EDW UAT testing, etc.

Had direct responsibility for managing governance and control processes.

Developed and maintained reports, models or databases to support individual and the enterprise’s routine and ad hoc data and analytical needs.

Provided guidance and training on use of tools, modeling, reporting and key data components in core, related databases, and the enterprise data warehouse.

Had responsibility for leading training and communication programs.

Served as primary analyst on Loan reporting, examples include OCC data analytics, concentration reporting, and Large Borrower reporting

Supported regular and ad hoc requests from business and support areas using SSRS and Tableau.

Managed tracking and resolution of data quality, technical and other issues.

Complied with all Bank policies/procedures and all applicable federal and state laws and regulations.

“LIVED” the Bank’s Mission Statement and “PRACTICED” the Bank’s Corporate Strategy.

SQL Server version 2014.

SQL / BI Developer

Client: ArjoHuntleigh – Addison, IL December 2014 to June 2015

Supported BI Manager with reporting process using MS Access and SQL Server.

Led SQL Server Report (SSRS) writing to ensure the timely delivery of data to the business stakeholders.

Set up reporting environment using Tableau.

Continuously improved the MS SQL Server Data Warehouse solutions.

Created and maintained SQL Server reports as well as complex queries necessary to complete monthly financial reporting.

Analyzed, designed, developed, implemented and maintained technical solutions through the use of SSIS and T-SQL. The project scope involved migration of CRM applications.

Provided ETL development using 2008 R2 SQL Server Integration Services (SSIS).

Supported, maintained and debugged the technical aspects of the MS Access, MS Excel and Visual Basic consolidation processes.

Served as a subject matter expert on system data structures and the queries required to access information for effective reporting.

Assisted the Manager of Business Intelligence with implementation of the core financial Data Warehouses.

Supported the migration of legacy Microsoft Office toolsets to new Microsoft SQL Server.

Worked with users to gather accurate source data queries for integration to the data warehouse and define effective web based SQL Server Reports and Analytical Cubes.

Assisted with end-user acceptance testing of the new toolsets.

Provided training and on-going support to the Business Units in regards to writing reports and accessing data.

SQL Server version 2014.

Visual Studio version 2010.

Contractor – SQL Programmer Analyst

Client: Abercrombie & Kent – Downers Grove, IL January 2013 to December 2014

Was responsible for supporting users' application, database and reporting needs while ensuring timely and accurate delivery.

Wrote and optimized T-SQL, stored procedures, functions and views.

Analyzed, designed, developed, implemented and maintained technical solutions through the use of SSIS/DTS Packages and T-SQL.

Provided ETL development using 2008 R2 SQL Server Integration Services (SSIS).

Delivered reporting solutions using MS Excel and SQL Reporting Services (SSRS).

Used MS Import and Export Wizard.

Assisted in creating technical solutions to satisfy business requirements through database and application design and development.

Created and maintained technical documentation to support new and existing systems.

AssistedDatabase Administrators in the preparation, set-up, and maintenance of hardware/software systems.

Worked with third party hardware and software vendors.

Participated in application design discussions and the change management process.

Applied a high standard of customer service when interacting with all levels of staff.

Assisted with other special projects or related duties as assigned.

Demonstrated organizational skills.

Demonstrate excellent oral and written communication skills.

Contractor – SSRS / SQL Developer

Client: Sanford – Oakbrook, IL February 2012 to December 2012

Used SQL Server 2005 technology.

Developed and delivered dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS) in Visual Studio 2005.

Designed, implemented, verified, debugged, optimized and maintained SQL Server database objects (database design, table design, stored procedures, views, functions, scripts, etc.) and processes for application, reporting and interface modules.

ETL development using 2005 SQL Server Integration Services (SSIS)Import and Export Wizard.

Used Microsoft Visual SourceSafe (VSS) as source control software.

Performed analysis and unit testing of Antivia XWIS with Xcelsius dashboards.

Wrote technical design documents related to schema and stored procedures.

Performed business analyst duties to gather report requirements.

Contractor – Business Analyst / SSRS & SQL Developer

Client: Insight – Bloomingdale, IL July 2010 to February 2012

Used SQL Server 2008 technology.

Delivered comprehensive BI through MS solutions including VBA, MS Excel, MS Access, and Microsoft Office SharePoint Server (MOSS).

Developed and delivered dynamic reporting solutions using SQL Server 2008 & 2008 R2 Reporting Services (SSRS).

Developed reports using SSRS in SQL Server Management Studio (BIDS).

Wrote SQL stored procedures, queries and analysis.

Developed and modified production software using C# and VB.NET (.Net 3.5 Framework) technologies.

Created and enhanced CMS system using a VB.Net front end with SQL Server backend.

Wrote technical design documents related to schema and stored procedures

Designed, implemented, verified, debugged, optimized and maintained SQL Server database objects (database design, table design, stored procedures, views, functions, scripts, etc.) and processes for application, reporting and interface modules.

Designed, coded and tested SSRS components including user interface, stored procedures, queries and tables.

Created ad-hoc queries from SQL Server databases for custom reporting needs.

Performed business analyst duties to gather report requirements.

Contractor – Application Migration Developer

Client: Bank of America April 2008 to November 2008

Lotus Notes Experience

Used Lotus Notes/Domino version 6.

Developed and enhanced Lotus Notes/Domino client applications using LotusScript.

Used Sametime and TeamStudio.

Implemented Master Data Integration framework with Lotus Notes contacts, DAX CRM along with Reference data.

Provided knowledge for existing Lotus Notes power user base.

Dealt with the current LaSalle Lotus Notes population to assist with maintaining applications until they were ported to SharePoint.

Participated in the Analysis and Design of the Image-Enabled Notes add-in for Lotus Notes.

.NET Experience

Converted Lotus Notes applications into intranet ASP.NET 3.5 Web applications written in C# and VB.NET with SQL Server 2000 on the backend.

Performed business and system analysis, designed applications and database structure, converted existing data into SQL Server.

Created Web Forms using ASP.NET, C#, VB.NET, XML, HTML, CSS, JavaScript.

Used Crystal Reports to create reports based on SQL Server database.

SharePoint and other skills

Was involved in providing advice on Windows SharePoint Services to a team building and maintaining one of the company’s culture sites on Windows SharePoint Services.

Dealt with the current LaSalle Lotus Notes population to assist with maintaining applications until they were ported to SharePoint.

Used solid oral and written communication skills.

Contractor – Web Portal Developer

Client: Cook County / Bureau of Technology June 2007 to February 2008

Participated in the design of the technical architecture of Web Portal Application Project.

Used SQL Server 2005 technology.

Used Aqualogic web infrastructure suite of tools.

Worked with the team and customers to drive features and specifications, architecture design, implementation, and other software development responsibilities.

Contractor – Lotus Notes Developer

Client: IneosSilicas March 2007 to May 2007

Used Lotus Notes/Domino version 6.

Developed and enhanced Lotus Notes/Domino client application using @functions and LotusScript.

Performed business analyst duties to gather application requirements.

Managed project scope.

Used oral and written communication skills.

Provided daily update on application progress.

Contractor – Applications Developer

Client: Federal Reserve Bank of Chicago May 2006 to February 2007

Used Lotus Notes/Domino version 6.5.3.

Developed, supported, and enhanced Lotus Notes client applications using @functions and LotusScript.

Developed, supported, and enhanced Domino web applications using HTML, JavaScript, Java, Visual Basic and

LotusScript.

Used Crystal Reporting tool.

Used SQL skills for accessing back end data.

Used MS SQL Server 2005 skills for T-SQL development.

Used TOAD to access and create Oracle applications

Used Ajax programming skills.

Used Moody’s software for risk analysis purposes.

Worked with team on disaster recovery for all our software applications processes.

Provided periodic updates on application progress.

Worked with user groups to gather application requirements.

EDUCATION/TRAINING/CERTIFICATION

Keller Graduate School of Management – Addison, IL Graduation: August 2014

Master of Business Administration with IT concentration

DeVry University – Addison, IL Graduation: August 2012

Bachelor of Science in Technical Management

Southern Illinois University – Carbondale, IL Graduation: December 1995

Computer Information Processing

TRAINING 2009 – 2010

ITIL Six Sigma Green Belt

SharePoint Project Management

CERTIFICATIONS

HTML Certification Lotus Notes

Lotus Certified Professional, (CLP)

Contact this candidate