Sankaran Hariharan
(*********@*****.*** / 713-***-**** - Cell)
Summary:
** ***** ** ** ********** in high volume data, mission-critical environments with extensive experience in project management, application software development, data analysis, modeling and architecture utilizing ASP .Net, C#, JavaScript, MS SQL, PowerBuilder, Java, and C++
12 years in Project Management in various software upgrade, regulatory and non- regulatory enhancement and conversion projects.
14 years in application development/maintenance for Oil & Natural Gas pipeline systems with sound knowledge and experience in SDLC and SOX compliant procedures.
Profound experience in analyzing and designing business processes and identifying and implementing effective strategies to provide a competitive market advantage and long- term stability
Strong Business Intelligence, ETL, DTS, UML, DFD (Data Flow Diagrams), ERD
(Entity Relationship Diagrams), OOP/OOD,TDD, System Integration, Testing, Implementation and Maintenance skills
Lead multiple application development/upgrade projects (including FERC compliant requirements) and has extensive experience in working with Business Units to gather requirements and design systems to meet their needs. Education:
MBA (Global Management), 2012, University of Houston-Victoria, USA. Bachelor’s degree in Mathematics, 1996, University of Madras, India Higher Diploma in Software Engineering, 1995, Aptech Computer Institute, India Microsoft Certified Systems Engineer, 1999, Microsoft Testing Center, India Experience:
Kinder Morgan (El Paso Corporation) Houston, TX
Project Lead/Application Developer – Sr. II - 05/2008 - Current
Project Lead for migration and integration of legacy systems integrated in to an in- house application called Dart (using VB .Net, TFS, MSSQL, SSRS, Crystal reports).
Data conversion from legacy systems using SSIS and SQL scripts.
Implementation of new allocation process for interstate and intrastate pipelines.
Part of 24/7 production support on-call rotation.
Project Lead for FERC approved Rate case and SQL server upgrade projects
Responsible for processes, data modeling, architecture, enhancements, upgrades, FERC requirement changes.
Responsible for complex stored procedures and triggers in MS SQL.
Web application development/maintenance with MS-SQL, .NET, C# and Java Script.
Create C++ wrappers to run stored procedures using tools like Appworx / UC4.
Streamline the use of PVCS version manager for both code and documentation. ECS Inc. (Client-ElPaso Corporation)
Proejct Lead/Programmer Analyst - July 2005 –May 2008
Major Player in Legacy systems conversion project from PowerBuilder 8.0 to 10.5.
Project Lead following SDLC steps for,
FERC Order 637 - OFO
PowerBuilder conversion project,
Migrate applications such as Volume Allocation, Cashout Imbalance and Billing from Java to ASP .Net (C# and Java script), a multi-million dollar project.
FERC approved Rate case projects.
Implemented the project with successful SOX audit (3 year 13 million dollar project).
Wrote extensive complex stored procedures in MS SQL 2005.
Upgraded the SQL Server codes from MS SQL 2000 to MS SQL 2005.
Involved in all BRD discussions for the conversion project and wrote multiple TDDs.
Maintained project code using PVCS version manager.
Converted web based application from Java front end to ASP.Net 3.0 and C#. Polaris Software(Client–ElPaso Corporation)
Project Lead/Programmer Analyst, - Oct, 2000 – July, 2005
Worked as Project Lead to develop an application for controlling the usage of natural gas pipeline during peak seasons (FERC Order 637 - OFO).
Developed screens and reports using PowerBuilder 8.0 and Seagate Crystal Report.
Upgraded the wrapper programs used to call stored procedures to Visual C++ 6.0.
Created web screens in Java on a third party tool called Versata (Vision Jade 4.0).
Wrote stored procedures in MS SQL 7.0 and later upgraded to MS-SQL 2000. Surya Tobacco Company, Nepal
Database Administrator/Programmer – Mar, 2000 – Sept, 2000
Responsible for database administration of MS SQL 6.5/7.0 Servers.
Installed SQL Server and service packs, created/altered devices, databases and logs.
Monitored server performance and fine-tuned via configuration parameters, table indexes, and optimization of stored procedures.
Wrote SQL stored procedures and triggers for ERP modules.
Created user logins and assigned rights. Took DB dumps and tape backups.
Automated maintenance tasks like DBCC and update statistics. Madura Coats Ltd., India
IT Executive – May, 1996 – Feb, 2000
Responsible for database administration and programming on MS SQL 6.0 Servers.
Implemented an ERP system called Ramco Marshal.
Built applications for timesheet, production data entry and raw material accounting. Sunrad Computer Systems, India
IT Programmer – Feb, 1994 – April, 1996
Developed educational software under the guidance of a physics professor in Indian Institute of Technology, Madras, to simulate lab experiments using Borland C++.
Developed financial accounting and inventory control application using Borland C++.