EXPERIENCE SUMMARY:

• SCCM Application Deployment Engineering and Business Intelligence Team Lead with 18+ years of demonstrated excellence in managing Application deployment, Data Warehouse, Dashboards, and Business Intelligence systems.
• SCCM Application Deployment Engineering: Manage the application deployment life cycle and Assist the enterprise applications distribution, Systems compliance though Inventory reporting and delivery.
• Hands - On Business Intelligence Development expertise spanning data warehousing, data modeling, ETL, OLAP and business intelligence including Microsoft SQL Server, SSIS, SSAS and SSRS, Crystal Enterprise, Business Objects and Oracle
• Leadership Excellence with strong entrepreneurial spirit and talent for translating strategy into actionable projects and achievements
• Exceptional Communication Skills to build strong customer relationships and to communicate about technical topics with people at all levels in the organization
• Project Management experience to plan and lead technical projects to successful implementation as measured by customer satisfaction, quality, and on-time, on-budget delivery.
• Teambuilding skills to build productive, results-oriented technical and cross-functional teams
• Information Architecture and System Design Experience to translate business and technical requirements into data models and business intelligence systems.

TECHNICAL SKILLS:

Reporting Tools: QlikView, SSRS, SSIS, Crystal Reports 4.6, 6, 7, 8, 9, 10, XI. Crystal Enterprise, Business Objects, MS Excel, MS Access

Extensive database experience: MS SQL Server, MS Access, ORACLEProgramming languages: VB Scripting, SQL, PL-SQL, KIX script, Java Script

Other tools: SCCM, ASP.Net, VB.Net, Visual Basic 4.0/5.0/6.0, Remedy, MS Visual SourceSafe, MS Visio, PVCS version manager

Web development: MS IIS, CGI, ASP, HTML, DHTML, VB Script, Java Script

Operating Systems: Windows, UNIX, Ms-Dos

PROFESSIONAL EXPERIENCE:

Confidential, Montvale, NJ

Manager IT

Responsibiliries:

• Software/Security updates deployment for firm-wide workstations using Microsoft SCCM.
• Architected, developed and implemented SQL Server data mart for asset management reporting of KPMG US enterprise assets. Designed database(s), views, SQL and automated many reports using SQL Server, SSIS, SSRS, Excel and MS Access.
• Implemented SQL Server Reporting Services platform for enterprise reporting, allowing self-service reporting and scheduled reporting capabilities for customers.
• Reengineered reporting processes resulting in automation of operational reports using SQL Server Reporting Services platform, replacing legacy tools of Microsoft Access and Excel. Increased efficiency and eliminated manual errors in report generation, with over 50% growth in volume of reporting and improved data quality.
• Dramatically improved customer relationships with customer business units through implementation of data quality processes and focus on highly collaborative working relationships and constant communication.
• Wrote detail requirements document by interacting with clients and gathering requirements. employees of the firm throughout the United States, Israel and Offshore team in India
• Provide guidance to the Business on deploying, Reporting solutions on KPMG Desktop.
• Managed several enterprise wide projects focusing on advanced technologies (MS Access, MS Excel, QlikView, SCCM, Microsoft VB.Net, SQL Server, SSRS,SSIS) following the SDLC techniques

Confidential

Sr. Developer

• Responsibilities included the design, documentation, and development of Visual basic application. Installers using Install Shield for Windows Installer, Merge Modules, and VSS for KPMG home grown and third party applications.
• Created SQL server database to support an application that tracks migrated workstations migrated through the POD process.
• Software: Visual Basic 6, Crystal Reports 7, Install Shield Professional 6.0, and Windows 2000.

Confidential

Sr. Developer

• Applications maintain data used in the financial Reporting of portfolios and their underlying securities. It constructed of many individual VB ActiveX components Reports were created using Crystal Reports. The database stores performance and portfolio composition data
• Application was designed using Visual Basic 6.0, database is Sybase 11 and reports were developed using Crystal reports 7.0.
• Most of the business logic is encapsulated as stored procedures in T-SQL in the database. The stored procedures are consumed by COM components implemented in Visual Basic.

Software: Visual Basic 6, Sybase System 11, Crystal Reports 7, Novel NetWare 5.0, Install Shield Professional 6.0, and Windows NT server 4.0

Confidential, New York City

Sr. Developer

• Analyzed business processes and defined improvements for Asset Management Services (AMS) group at J.P.Morgan & Co.
• Drafted and reviewed user documentation for Applications & processes. Supplied gap analysis and designed diagram process flow for Client account reconciliation System.
• Designed and Developed many Visual Basic applications for AMS, SQL server was used as a backend
• Crystal Reports and Congnos impromptu were used for reporting.
• All the applications were created for large-scale complex Systems that included technical business/functional requirements for AMS systems.

Software: Visual Basic 6 (COM components), SQL server 6.5, Sybase System 11, MS Access, MS Excel, Crystal Reports 8, Cognos Impromptu 6.0 Report Builder Powerplay Transformer 6.6.

Confidential, New York City

Project Manager/ Sr. Developer

• Assigned to the study and develop a complete System called “Gang Tracking System” for the Confidential.
• This System was designed and developed in Visual Basic with SQL Server, MS Access database Crystal reports were used for reporting.
• System is fully intergraded with NYPD Mainframe system using ODBC to connect DB2 in order to snatch the data by using remote views across the main network.
• The System has been installed in NYPD, INTELLINGENCE DIVISION and it is going to be installed in all the precincts.

Software: Install Shield Professional 5.5, Visual Basic 6, WinRunner 6.x, XRunner, SQL server 6.5, DB2, Crystal Reports 7, Novel NetWare 5.0, and Windows NT server 4.0

Confidential

Programmer/Analyst

• Designed and developed sales reporting modules for sales division of WIZ. The modules included data entry screens for Item, Sales price, Inventory, Physical count, Employee etc,
• The Inventory system automatically generates and identifies the vendors for the given Item, Keeps track of purchase orders etc.
• Designed a Report driver, which accepts date ranges and displays/prints, reports on Items, Sales history and Daily sales.
• Developed installers using Install Shield.

Software: Install Shield, Visual Basic 5.0, SQL server 6.5, Crystal Reports 4.6, WinRunner 5.x, XRunner And Windows NT.