PROFILE

• Innovative and experienced software engineer / project manager with a record of developing and supporting successful solutions incorporating a wide range of applications and technologies. Exceptional leadership qualities that align the business process and program infrastructure to realize cost savings, accelerate performance, and sustain flexibility for the organization.
• Oversee and lead all phases of project lifecycle, numerous software applications, change management, and assessment of end-user needs while efficiently resolving IT issues. Exemplary track record of success in planning, issue resolution, customer service, and technical design and architecture. Innovative and forward-thinking leader utilizing unconventional methods for team building and knowledge transfer, facilitating effective migration processes.
• Over 20 years of experience in team building, coaching, project management, and the development life cycle, with a background in managing projects for development of ERP, CRM, Business Intelligence, Security based systems and DOT systems applications from inception to completion.
• Managed a variety of solutions involving hands-on application development, creative user experience design, and efficiency monitoring.

TECHNICAL EXPERTISE

• Languages: PL / SQL SQL T-SQL .NET 4GL HTML MF COBOL Visual Basic XML
• Progress
• Operating Systems: UNIX Windows BTOS
• Databases: Oracle SQL Server SSIS SSAS INGRES Sybase Progress
• Software: Erwin Visio TFS Visual Studio 2010 Lotus Notes PowerBuilder
• BI Tools: Web Focus COGNOS Impromptu Diver SQL Server Analyzer ETL
• Applications: DOT Safety Information systems ERP CRM Business Intelligence Credit Review
• Data Migration Configurator
• Reporting Tools: Crystal SSRS Logi XML Web Focus-Dashboard Report Painter FRX Sharepoint
• Methodologies : Agile Scrum Waterfall JAD SOA Webservices

PROFESSIONAL EXPERIENCE

Confidential

Senior Software Engineer

Working as Team Lead/ETL Architect and Developer for the learning software project which involves in maintaining the existing systems, ETL / SSIS Packages and SSRS Reports and develop new SSIS Packages and reports using SSRS and Cognos Report Writing tool.

Environment: SQL Server 2012, 2008, SSRS, SSIS, SharePoint, XML, Visual Studio 2008, Data Mart, DataWarehouse, Code Integration, Reports Development using Cognos,Oracle and other External interfaces.

Confidential

Senior Project Manager

• Served as Project Manager for four different projects Reporting Analytics, Merging / Integrating Codes, Database development/maintenance and monitoring tools development for the local systems and Integrating various hardware Interfaces with the main system for Security Based Software Development Company Technology Division at Burlington. Use SCRUM Methodologies in managing different projects.
• Responsible for full Data warehouse and reports development project starting with Data capture, cleaning, transforming, aggregating, cubes development and reporting for various functionalities like visitor Management, events Monitoring, incidents Reporting,etc. Worked on Microsoft Data Warehousing technologies including SQL Server Enterprise Services, SSAS, SSRS, SSIS and Sharepoint. Involve in designing/managing analytical reports, dashboard and scorecards for the security system.
• Responsible for managing different code base developed in different locations and different technologies into a single codebase and internationalize the code to support international languages for easier maintenance and enhancements. The codes were developed using different frameworks classic ASP, .net and MVC and all the codes to be merged. Involved in testing of various systems. Responsible for coordinating the tasks , managing, controlling and tracking the project.
• Responsible for coordinating various hardware interfaces between various components like Camera, Card Device, Elevator Systems and Building access systems with our main system and developing various interfaces, maintenance and the enhancement.
• Responsible for maintaining single uniform database schema across the local systems which are having different schema for each installation now and developed a monitoring tool to identify which sites are having problem in transferring the data and fix the problem.

Environment: SQL Server 2012, 2008 2005, SSRS, SSIS, SharePoint, HTML, XML, CSS Stylesheet, Visual Studio 2008, MS Project, .NET , Middleware, Data Mart, DataWarehouse, Code Integration, Internationalization

Confidential

Software Engineer Principal Leader

• Served as Team Lead/ Database/ETL Architect and Developer for three different projects FSIMS, FSAS and MSAD for department of transportation systems at Volpe Center for Raytheon.
• Developed and maintained Master Data, Meta Data and various databases for Aviation applications using state of the art platforms. Developed and maintained systems and record keeping under strict government guidelines from different data sources.
• Involved in full Data warehouse development cycle starting from Data capture, cleaning, transforming, aggregating and reporting. Worked on various Data Warehousing technologies including SQL Server Enterprise Services, Web Focus, and logiXML.
• Involved in various phases of Software development lifecycle SDLC including project reviews at each phase gate of the SDLC using Agile Scrum , JAD and waterfall Methodologies.
• Involved in creating data modeling, flow diagrams, and writing test scripts for MSAD Business application.

Confidential

• Anchored various systems related to aviation and sub systems using ETL and .Net automation. Created integration packages using ETL, Server side scripts, T-SQL, stored procedures for various Business Rules, and VB.net.
• Developed dashboards and Business Intelligence reports using tools like SSRS, LogiXML and Web Focus for the IT Systems.
• Worked closely with database administrators and database security personnel on application and system scripts for secure database implementations. Performed software writing of data modeling, flow diagrams, instructional manuals and test scripts for Business Infrastructure.
• Used Erwin to maintain database schema and database conversion from one application to another across systems.
• onducted extensive troubleshooting, optimizing the performance, and creation of stored procedures in SQL for middle-tier business layer applications.
• Work well independently as well as in a team environment.

Environment: SQL Server 2008 2005, Web Focus, Reporting Services, LogiXML, HTML, XML, CSS Stylesheet, Visual Studio 2005 and Visual Source Safe, TFS, ERWIN, MS Project, SharePoint

Confidential

Project / Applications Manager

• Responsible for architecture and leading a team of seven people from mid to senior level application specialists, database administrator and business analyst for more than eight years
• Worked with Functional Managers and users to acquire resources and functionalities for various modules AP/AR/GL/PO/HR for ERP systems, CRM Systems, Data warehousing application systems, data migration, and configuration management and involved in converting technical details to business language and communicating the same to the user community.
• Developed and maintained Master Data, Meta Data and various databases for ERP, CRM and Data warehouse applications using state of the art Oracle, Progress and Microsoft platforms.
• Performed software writing of data modeling, flow diagrams, instructional manuals and test scripts for Business Infrastructure.
• Developed databases and ETL applications for various BI systems using Star Schema and Dimensional modeling for various modules like Purchase Order, Sales, Accounting and Production Systems.
• Responsible for completely migrating data from one ERP system Syteline to other ERP IFS system using PL/SQL, T SQL Scripts and Progress 4GL Scripts. Converted data from ERP to CRM applications using ETL, SSIS Package tools and T-SQL.
• Performed Data Mining and joined data warehouses from multiple sources like Sales, Customer Service, Production, and Purchase for production statistic. Involved in building business Intelligence applications using COGNOS - Cubes and Imprompt Reporting tools for ERP applications.
• Conducted extensive troubleshooting, optimizing, and creation of stored procedures in SQL and Oracle databases.
• Aided in development, execution, and maintenance of disaster recovery plans. Worked with project managers, developers and production teams to identify business needs and solution options.
• Served as a mentor and coach to junior and mid-level personnel

Environment: Progress, Oracle, SQL Server, PL/SQL, 4GL, T SQL, Crystal Reports, FRX, ERWIN, COGNOS , Impromptu, Diver, CRM, .NET, HTML, XML

Confidential

Senior Software Engineer

Consulted three different clients on ERP application in financial, credit review, and manufacturing industries, providing requirements analysis, effort estimation, technical investigation, architecture, coding, unit testing, bug tracking, and fixing. Customized and enhanced applications and served as lead developer, integrator, and architect on various projects. Trained end-users on system modules and evaluated emergent technologies for impact on business and design solutions.