Post Job Free
Sign in

Sql Server Data

Location:
Passaic, NJ, 07055
Posted:
September 11, 2016

Contact this candidate

Resume:

** ********* ***., *******, ** *****

Tel (Home):

Tel (Mobile): Email:

973-***-****

914-***-****

****@*****.***

David Seidman

Qualification Summary

Experienced data analysis and application software development professional with strong project management and communication skills. Over twenty years of managerial and hands-on technical experience in hardware and software development. Facility in interfacing between technical teams and non-technical business leaders. Expertise in translating strategic business and IT objectives into concrete action plans and delivering results on schedule.

Experience

January 2015 – August 2016

Computer Sciences Corp. (CSC)

Falls Church, VA

Senior Consultant

Duties and Responsibilities: Coding and testing of large SSIS (Microsoft SQL Server Integration Services) packages for CSC’s Big Data and Analytics dept. for financial compliance reporting. Data modelling for Oracle (version 11g) and SQL Server databases using Oracle PL/SQL and Microsoft T-SQL. (client: Mizuho Bank, Jersey City, NJ); Data analysis and SSRS (SQL Server Reporting Services) report design and implementation for healthcare center operations (client: Bright Horizons, Watertown, MA); Project management and offshore team coordination for insurance company Informatica-based system (client: Guardian Life Insurance, NY, NY)

Previous Employment

December 2013 – December 2014

C&A Marketing

Ridgefield Park, NJ

Senior Developer

Duties and Responsibilities: Development of .NET applications (with C# and Visual Basic) utilizing APIs (application programming interfaces) to interface with eBay and Amazon for transaction histories and product information.Design and implementation of SQL procedures, SQL agent jobs, and SSRS (SQL Server Reporting Services) reports. Data warehousing including creation of SSAS cubes for visualization of data related to inventory, sales, and profit margins. Development of Cognos reports and dashboards using IBM Cognos Business Intelligence (Version 10.2.2) Workspace Advanced, Report Studio, and Framework Manager.

May 2013 – November 2013

Direct Energy

Montebello, NY

Application Developer

Duties and Responsibilities: Development of .NET Windows Forms applications for energy services (including collection functions, complaint resolution, and rejection tracking) using Visual Basic and C#. Team lead in design and implementation of SSIS (SQL Server Integration Services) packages for ETL data import and extraction. Design of SQL Server tables, triggers, and stored procedures in SQL Server. Design of Oracle procedures and packages.

November 2012 – March 2013

Systems Maintenance Services

Parsippany, NJ

Data Analysis and Visualization

Duties and Responsibilities: Project leader for data analysis, reporting services, and data visualization of statistical information on revenue and profitability using Tableau business intelligence software. Maintenance and modification of Java JSP application for database comparison and data migration. Lead analyst for SQL Server legacy databases for data migration into unified system. Design and generation of Tableau dashboards for financial reporting and resource management. Analysis of Oracle MySQL databases for data conversion, migration, and validation. Design of new databases and tables for contract management and asset management.

September 2010 – September 2012

Major Energy

Orangeburg, NY

Application Developer / Analyst

Duties and Responsibilities: Team leader in development of .NET C# applications for front and back end design, implementation, and rollout for IT processes enabling service expansion into new territories and with new utilities. Served as acting CTO (chief technical officer) for 6 months, managing all IT department activities and new project development. Responsible for full software design life cycle (SDLC) of energy management applications in ASP.NET (using C#). Interfaced with executives in analyzing requirements and designing functionality to implement business process. Used SQL Server Analytical and Reporting Services to develop custom reports and statistics on account activity and energy rate plans. Led quality assurance efforts, including code review, regression test plans and execution, and bug tracking.

Education

Columbia University, New York, NY (M.S., Ph.D., Electrical Engineering)

Enabling Technologies

Microsoft Visual Studio 2010, SQL Server Management Studio, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Business Intelligence Developers Studio, Oracle SQL Developer, ServiceNow, Excel, SharePoint Designer, Tortoise SVN, Visual SourceSafe, Tableau reporting, Oracle MySQL Workbench, MyEclipse for Spring, Telerik and DevExpress controls, Crystal Reports, JIRA Project Tracking, SAS (JMP), Crystal Reports, Team Foundation Server (TFS), Toad.

Languages

C#, C++, Visual Basic, .NET, ASP



Contact this candidate