Associated Vice president Resume New York, NY - Hire IT People

OBJECTIVE:

Senior level position in Backend software development.

SUMMARY:

Professional with more than 20 years of extensive experience in designing and development Database applications. Current expertise lies in warehouse/datamart based Business Intelligence (BI) application development using Microsoft SQL Server 2012, SSAS, SSIS. A strong background in relational and multidimensional Database architecture, design, data modeling, development and administration.

SUMMARY OF SKILLS:

Programming Languages: T - SQL, MDX, XMLA, C#, VB

DBMS: Microsoft SQL Server.

Data Sources: DB2 UDB, Sybase, ORACLE, EXCEL, WED Services

Tools: Microsoft Visual Studio, OLAP and Data Warehousing, SQLXML, ADO, .NET.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Associated Vice president

Responsibilities:

Developing data marts, SSAS OLAP cubes financial and HR systems (Microsoft SQL Server 2012).
Creating logical and physical models for multidimensional databases.
Designing, debugging, and optimizing T - SQL and MDX queries, T-SQL and CLR C# stored procedures, functions, views for SQL Server, SSAS OLAP Server.
Designing and creating SSIS based ETL processes.
Designing front-end OLAP reports utilizing Excel and Tableau

Confidential, Parsippany, NJ

Senior Database Developer / Architect

Responsibilities:

Worked as a Database leader in development team
Design datamart architecture for Business Credit Card Online Reporting system (SQL Server relational databases and SSAS multidimensional OLAP cubes )
Creating logical and physical model for relational and multidimensional analytical databases. (SQL Server 2008 SSAS)
Developing, tuning and optimizing MDX queries, T - SQL and C# stored procedures, functions, triggers, views.
Designing and creating SSIS packages to extract, transform and load data from mainframe files.

Confidential, New York, NY

Senior Database Developer / Architect

Responsibilities:

Design datamart architecture of Performance Attribution system based on SQL Server relational databases and SSAS multidimensional OLAP cubes
Creating logical and physical model for relational and multidimensional analytical databases .
Developing T - SQL and C# stored procedures, functions, triggers, views and MDX queries.
Debugging, tuning and optimizing T-SQL code utilizing SQL Server Management Studio.
Working on optimization SQL Server performance, monitoring, and tuning using Microsoft tools Performance Monitor, SQL Server Profiler,Database Engine Tuning Advosor, DMVs.
Designing and creating SSIS packages to extract, transform and load data from databases located on SQL Server, Sybase, Excel, and ORACLE.
Improving mathematical model for Fixed Income Performance Attribution system
Designing batch procedures for Confidential Web site.

Confidential, Jersey City, NJ

Senior Database Developer / Architect

Responsibilities:

Developing datamarts, SSAS OLAP cubes and Data Mining projects for Global Sales system (Microsoft SQL Server 2000 and 2005).
Creating logical and physical models for relational and multidimensional databases for Global Sales system.
Designing, debugging, and optimizing T - SQL and MDX queries, T-SQL and CLR C# stored procedures, functions, views and dynamic queries for SQL Server, SSAS OLAP Server, DB2 and Sybase.
Designing and creating ETL Integration Services packages.
Designing front-end OLAP reports utilizing Excel and ProClarity
Designing automated procedures using C#, VBScript, and autosys.

Confidential, Montvale, NJ

Database Architect / Developer /Administrator

Responsibilities:

Providing full lifecycle of SQL Server 2000 and Oracle 9i database development I:
Created logical model including Entity - Relationship diagram and Data Dictionary utilized Visio and Erwin.
Converted logical model into physical model and documented it using SQL Server diagrams for more than 200 tables.
Developed over 1000 T-SQL stored procedures, functions, triggers and views.
Worked on optimization SQL Server performance, monitoring, and queries tuning using Microsoft tools Performance Monitor, SQL Analyzer, and Profiler.
Designed and implemented schema for distributing data utilizing replications, DTS packages, BCP, and VB code.
Designed and implemented Warehouse for Loan Origination system with Web site utilizing OLAP, ASP and ADO MD.
Designed production database maintenance schema including Backup/Restore, Transaction log shipping and monitoring procedures for Live, Standby, Reporting and Cluster SQL Servers.
Designed release management procedures for Development, QA and production SQL Servers using Red Gate SQL Bundle.
Designed and implemented data replication nationwide.
Developed Web content for database maintenance and reporting using DMO.

Confidential, Washington, DC

System Specialist

Responsibilities:

Mainframe Database programming using VM/SP, ADABAS, and NATURAL to handle accounting, payroll, and inventory tasks .

We provide IT Staff Augmentation Services!

Associated Vice President Resume

New York, NY

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship