Vivian Foss

Email: adjzvi@r.postjobfree.com

Phone: 201-***-****

Professional Summary

Strategic and goal-oriented Software developer and analyst with demonstrated experience in Database/ Reports development and support. I possess good knowledge in all phases of development lifecycle - right from requirements definition, business analysis, prototyping, Proof of Concept, design, implementation, testing, and production support. I am a very good communicator and presenter, capable of establishing rapport with individuals and groups at all organizational levels.

Areas of expertise:

Application Development and maintenance - PL SQL, SQL Server

Database Analysis & ETL

Data / Business Analysis

Reports Development

Business Intelligence

Testing & Troubleshooting

Production support

Skills Summary

Programming Languages

SQL, PL/SQL, T-SQL,

C, C++, Visual Basic 6.0, C#. NET, My SQL, VB.NET, HTML, CSS, XML

ETL /Reporting Tools

SSIS, SSRS, Microstrategy, Tableau

Databases (RDBMS)

MS SQL Server 2012/2013/2014/2017, IBM DB2, Microsoft Access

Design & Development Tools

SQL*Loader, SQL programmer, SQL Management Studio, SQL Server Business Intelligence Development Studio

Azure Cloud

Source Management

Visual SourceSafe, Subversion, WinCVS

Scheduling Tools

Autosys

Platforms

Windows 95/2000/2003/XP/VISTA/7/8/8.1, UNIX, LINUX

Other Packages & Tools

Visual Studio, SQL Dialect, MS Office,

HP Application Lifecycle Management (ALM), JIRA

Development Methodologies

Waterfall & Agile

Professional Experience

Duration: March 2019 – Till date

Job Title: Reports Developer (SSRS/ Tableau/ Microstrategy)

Client: Wells Fargo Bank, North Carolina

Roles and responsibilities:

As a member of BI/Database team, involved in Requirement gathering, Technical Design, Development, Testing, and Implementation of BI reporting needs.

Actively involved in writing T-SQL Programming for implementing Stored Procedures, tables, views for different reports.

Involved in business requirements gathering, impact analysis, and data analysis with respect to reporting requirements.

Developed and maintained complex SSRS report that need to be submitted to Federal Reserve on Quarterly basis.

Involved in creating SSIS packages with various transformations like Slowly Changing Dimensions, Look-up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion and automate Autosys jobs to run on daily and quarterly basis.

Experience in configuring package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.

Worked on Generating dashboards in Tableau server using various data sources

Designed and implemented group by, drilldowns, drill through, sub-reports, Parameterized and cascading parameterized reports using SSRS.

Created Graph and Chart report to show Enterprise performance and overall risk in SSRS reports.

Used JIRA and ALM for defect logging, tracking and closure.

Worked with TFS and GIT for checking in the developed reports, SSIS packages and SQL queries into Cloud.

Versioning the checked in for deploying the reports to each environment (DEV, UAT, PROD).

Point of contact for build / release management process for SSRS/ SSIS.

Worked with QA team and created test plan for unit testing of all generated SSRS reports

UAT Support and analysis/ clarification of business team queries

Implementation support for production implementation and post-implementation validations.

Duration: October 2018 - February 2019

Job Title: SQL Server/ BI Developer

Client: Klaxon Tech Inc., New York

Roles and responsibilities:

Collected business requirements from users and translated them as technical specifications and design documents for development.

Designed database objects after analysis of the business requirement.

Worked closely in developing the detail design document and presenting to the client and implementing their feedback on a weekly basis

Generated parameterized queries in SSRS 2008 R2 using data from SQL Server.

Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2008 R2

Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations like Conditional Split, Derived Column, Data Conversion, Look Up, and Merge Join as required using SQL Server Integration Services (SSIS).

BI reporting using Excel with Power Pivot

Duration: February 2017- May 2017

Job Title: Graduate Research Assistance

Client: Pace University, New York

Roles and responsibilities:

Collect data on 90 churches in New York State to verify if they provide services to the Spanish and Latino speaking population

Develop and update Excel database to track data on pastor contact information and types of services offered

Analyze collected data using Pivot tables, filters, VLOOKUP functions, charting & table formatting of Microsoft Excel

Duration: February 2015 – May 2016

Job Title: SQL Server/ BI Developer

Employer: Cal soft Labs India Private Limited– Mumbai, India

Roles and responsibilities:

Created many new reports according to the business user requirement with includes complicated expressions and tables.

Perform unit testing at various levels of the Reports.

Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.

Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2008 R2.

Written complex stored procedure according to the business requirements for reporting purpose.

Designed & developed the various SSIS packages for the Weekly & Monthly Loads from business users in different locations in United States (Tampa. FL, Bridgewater. NJ, Morristown. NJ).

Managed the ETL processes between various environments through scripts utilizing linked servers, DTS packages and SSIS.

Involved in re-design, re-build, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.

Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data.

Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).

Created Sub Reports, Parameterized and Drill down Reports based on the requirements provided.

Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Excel and Flat Files.

Modified existing database to fit new business requirement by adding tables and relationships.

Educational Qualification

Masters of Information Systems, Pace University, NY

Contact this candidate