Sql Server Software Developer
Resume:
Tatyanna Tremans
Brooklyn, NY 11229
Information Technology Professional with over 16 years of experience in Business and Software Development and Quality Analysis with emphasis on latest business methodologies and system architecture. Extensive experience in the development, implementation and integration strategies within a team oriented environment for desktop, web based and business intelligence solutions in all phases of SDLC in Finance, Entertainment and Healthcare Industry. Excellent communication skills
Skills
Software
Visual Basic 4.0, 5.0, 6.0, Microsoft Visual Studio 2003/2005/2010, VB.NET, C#, MS SQL Server 6.0, 6.5, 7.0, 2000, 2005, 2008, 2012,2014, SSIS, SSRS, Oracle 8, 9i, 10g, 11g, Sybase 11,WinAPI’s, MS Access, ASP, ASP.NET, ASP.NET MVC, WCF, WEB API, C#, JSON, jQuery, VBScript, JavaScript, VBA, ADO, ADO.NET, Crystal Reports 9, 10, XML, XSL, Entity Framework, Windows 95/98/NT/2000/XP/ 2000/2003, 7, MicroStrategy 8, 9.0.2, 9.4, Infoed, SharePoint, Cognos 9, 10, eClinicalWorks, Meditech 4.24, MicroStation V8
Work History
DSNY, NY 07/2016 – Present
Computer Systems Manager
Working as a Senior developer on DSNY projects such as Target Management system, Hired equipment and Medical Division
Using Visual Studio 2017 and C# and the front- end development and SQL Server 2012 as back end. Reverse engendering, documenting and redesigning legacy applications created in Visual Basic, Ms Access into a new technologies such as ASP.NET MVC with WebAPI’s.
Creating a detailed Business requirements documents.
Designing, Developing using SQL Server and MVC with Microsoft .NET Framework 4.6.2
Creating Various Reports as it pertains to new applications using SSRS.
Participating in ETL process to transfer data from SQL Server to Oracle and OBIEE via Informatica 9.6.1 and Pentaho Kettle
Performed Data migration for major databases from SQL 2000 to SQL Server 2012 utilizing SSIS.
Working closely with business users and Business analysts to achieve best results using Agile approach.
BNY, New York, NY 10/14 – 12/15
Business Systems Analyst
Worked on new system implementation built around Service Oriented Architecture (SOA), where all server-based functionality is exposed as a collection of WCF (REST) for BNY Securities applications.
Gathered requirements and translated it in business requirements document (BRD) consisting of functional and non-functional requirements.
Worked with stakeholders at all stages of SDLC to build consensus.
Created complex stored procedures, views and user defined functions in SQL Server 2014
Performed query optimization and performance tuning with MS SQL Server.
Created new applications in ASP.NET with MVC and ASP.NET Web API
Designed reports using Business Objects and SSRS.
Participated in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
Participated in preparation of UAT scripts and user training materials
Wyckoff Medical Center, New York, NY 11/11 – 09/14
Software Developer / BA
Created various clinical and financial applications including daily statistic report which provided upper management and the CFO with Hospital’s overall performance.
Performed new development and maintenance of applications in VB, ASP, ASP.NET and VB.NET.
Created stored procedures, functions, cursors and triggers in MS SQL Server 2012.
Developed reports utilizing Excel, Access and Cognos, Micostrategy.
Worked on company’s website in SharePoint.
Worked with network administrators, systems analysts and other software engineers to assist in resolving problems with in-house or third party software systems.
Created technical documentation and user training material.
Dana-Farber Cancer Institute Boston, MA 10/07 – 11/11
Systems Designer
Served as a member of the Research Administration and Finance Department, working on new ASP.NET and VB.NET applications and utilizing VB, C# and VBA.
Designed, developed and implemented complex metrics, attributes, advanced reports, and interactive dashboards utilizing MicroStrategy.
Created stored procedures in MS SQL Server and Oracle to support current financial applications.
Troubleshot and provided performance tuning of reports.
Performed administrative tasks such as server upgrades, object migrations and user maintenance in MicroStrategy.
Created subscriptions, schedules and configuring MicroStrategy distribution services server.
Worked with data specialist to create a warehouse environment utilizing Star and Snowflake schema models to improve performance of the reporting system.
Prepared functional and technical specifications.
Created training materials and conducted user training.
Received excellence award in Research Analytics reporting project.
Children’s Hospital Boston, MA 08/04 – 10/07
Application Development Specialist
Designed and developed various projects in the cardiology department which included Cardiology Application Suite (CAS). CAS kept track of patient demographic information, provider data and consisted of Preop, Perfusion and Surgery modules.
Developed system in ASP.NET and Oracle as the database and provided instant access to patient and provider information for research and clinical purposes.
Supported and enhanced Preop module developed in ASP and VB with extensive use of COM and COM+ objects.
Created an internal program which included VB.NET front end code to create an encrypted file and PL/SQL stored procedures and functions and to gather patient’s procedure (CPB) and diagnosis (ICD9) codes from various sources and for submission to the Society of Thoracic Surgeons National Database.
Provided ad hoc reports for non-technical users.
Created new applications at user's request utilizing classic ASP, ASP.NET, VB.NET, XML and HTML using VB and C#.
Debugged system, troubleshot and conducted user training.
State Street Research, Boston, MA 10/03 – 04/04
Programmer, Business Analyst
Provided technical and analytical support to the company’s Retail Sales group, Corporate Marketing & Planning and Corporate Finance departments.
Tracked, analyzed and reported on retail mutual fund and annuity sales, redemptions and asset values.
Maintained and developed scheduled reports utilizing MS Access and Crystal Reports.
Performed business reporting, business trend analysis and competitive analysis for senior management with Crystal Reports, VBA and ad hoc reporting.
Designed and developed programs utilizing VBA, advanced MS Access and MS SQL Server.
Fidelity Investments, Boston, MA 11/00 – 02/02
Senior Software Engineer
Designed and developed global meeting scheduler. This application served as a scheduling tool to investment professionals in Boston and international offices in London, Hong Kong and Tokyo. System consisted of web-based interface developed in VBScript and JavaScript, VB COM components that provided connectivity for third party controls such as Symon software and various executables which offered instant update on client’s desktops, Outlook inbox and calendar utilizing MSMQ as collaboration system.
Utilized MTS and COM+ interfaces was implemented at all stages of project.
Developed programs utilizing XML/XSLT, VB and ASP to optimize application for speed.
Provided weekly system support and upgraded application prototypes to production environment utilizing ASP, VB and SQL.
Created various reports utilizing Crystal Reports 6.0.
Prepared detailed documentation supporting each ongoing project.
Standish, Ayer & Wood, Inc., Boston, MA 12/99 – 11/00
Fixed Income Software Developer
Served as part of the Fixed Income group, working on development and implementation of reporting and information analysis solutions such as Peer group Comparison Project that provided relative option adjusted spread calculations of the company's bonds versus comparable bonds on Salomon's Index and Municipal Bonds reporting system utilizing ASP, VBScript, MS SQL Server 7.0, Access, Excel, VBA and VB.
Gathered user specifications and translated into detailed program design.
Developed projects in VB, ASP and MS SQL server connected via ADO.
Created reports in Access and Excel utilizing pass-through queries and VBA.
Wrote stored procedures and other database objects in MS SQL Server.
Analyzed and developed application prototype to support other FI areas.
Worked with internal clients to design and develop their own applications.
Education
Kingsborough College, New York, NY
A.A.S. in Accounting, 1991- 1996
ASA Institute of Technology Computer Science, 1998
MCNY B.B.A 2016
Training
Develop Mentor, New Horizons, BU, Understanding financial instruments, MicroStrategy Desktop: Reporting Essentials, Advanced Reporting, and Architect: Project design Essentials
Awards
Recognition of outstanding performance and commitment to Excellence in Research analytics Project
Contact this candidate