Information Technology Consultant

• May 2021 - Present

Manager Budgets

• Apr 2011 - May 2021

SAP Business objects / WebFocus Reporting and Tableau SAP Business objects / WebFocus Reporting and Tableau

SR Consultant / Project Manager

• Oct 2009 - Apr 2011

Manage Outsourcing Projects,Contracts and negotiate new teams for contract extension. Managing a team of developers for a .Net project through all phases of project life cycle - analysis, design, development, testing, implementation, and post-production support. Managing and developing a Reporting suite using C# and VB.Net / ASP.Net, WebFOCUS applications, deployed against Microsoft SQL Server, Oracle®, and Sybase® databases Working on the Architecture and development of ETL software modifications for a data warehouse and associated data marts in SQL 2005. Analyze specifications and develop/test complex reports and dashboards utilizing WebFOCUS. Architecting, designing, developing and deploying WebFOCUS based solutions for our customers. Data modeling and Source data analysis, table design using ErWin, improved cube designs for ease of loading. Working on performance troubleshooting on database and application errors in existing customer implementations, and implemented performance tuning measures on production databases Identified the sources for and aggregated historical Practice Management and billing data, developed OLAP cubes, performed insightful data analysis, and create analytical reports for management. Design and implement Real-Time Cube, and automate Cube processes with SSIS and plug the report in Webfocus Show less

Sr. Consultant / Project Manager

• Dec 2004 - Apr 2009

Managed and Developed a year-long project involving re-engineering of company manufacturing systems to WebFOCUS from Mainframe, DB2, MS-Access, Visual basic, .Net, VB Macros. Architecting, designing, developing and deploying WebFOCUS based solutions for our customers. Designed, developed and deployed complex Manufacturing reports/ad-hoc reports/graphs using advance technique and involving multiple and multi level drill down and complex excel/pdf template, dynamic parameter using WebFOCUS, MRE, Dashboard. Extensive use of WebFOCUS OLAP functionality and Optimized/Fine Tuned SQL queries, Data Migrator Flows and WebFOCUS Reports. Analyze specifications and develop/test complex reports and dashboards utilizing WebFOCUS. Created and maintain jobs, analyzed error logs for trouble shooting Created SSIS packages to load data from OLTP data model to OLAP data model which is used for Cube and other applications Used SSAS to create/maintain OLAP Cubes which are based on multidimensional database with star schema . Used DataStage as an ETL tool to extract data from sources systems, aggregate the data and load into the Teradata database. Design and Develop extensive SSIS packages, SQL Store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance and cleansing of data. Assist in managing an outsource relationship for 3rd party application development and programming consultants. Optimize query performances by utilizing SQL Server's Execution Plan Quality Assurance, validate Financial data, troubleshoot EDW design Develop internal financial reports, deploy and embed reports onto MS SharePoint 2007 Design and implement Real-Time Cube, and automate Cube processes with SSIS Train and manage developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices. Show less

Project Manager

• Feb 1999 - Dec 2004

Managed a team of developers and graphic designers in the design and implementation of a websites www.ezworldwide.com and www.ezoffice.net with ASP, Java, XML, VB Script, ASP.Net, VB.Net, Microsoft IIS Server and SQL Managed enterprise projects for EZ Worldwide top clients, Drove projects from Conception through completion. Launched two new sites and re-launched two portals. Managed and Developed internal business applications Finance and Accounting, Human Resource System, Sales and Marketing Managed and Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries. Created Customer web portals to download mailing software and print labels for the packages. Created classes and dimension and measure objects according to business requirements. Ensure deliverables are prepared to satisfy the project requirements, cost and schedule. Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production. Conducted resource planning and budgeting tracked costs to ensure adherence to budgetary limitations. Show less

Project Lead

• Apr 1997 - Dec 1998

Managed a team of developers and Implemented a two tier based Sales Funnel System , Citibank Reporting System, Financial Accounting System, Integrated Hospital Management using PowerBuilder PFC and Oracle through all phases of project life cycle - analysis, design, development, testing, implementation, and post-production support. Written proposals in response to RFP and win new contracts for private business sectors. Manage multiple contracts and negotiate new teams for contract extension. Consulted with client to identify key requirements, defined project scope, developed project plan and schedule, provided leadership to internal teams on projects and daily production issues. Documented non-core systems maintenance tasks so that the work could be transitioned to an offshore IT firm. Led 6-person team in creating automated tests to ensure Y2K Conducted cost benefit analysis of various ETL tools and technologies. Show less

System Analyst

• Jan 1997 - Apr 1997

Completed the development of a large and complex reporting system for the Hitachi (Inventory Control System) pilot using Visual Basic, SQL Server, and Crystal Reports Built a project management tool using php, VBScript, and Access 97 that allowed the Visa department to track the progress of IT related projects and requests. Oversaw unit and system tests and assisted users with acceptance testing. Conducted peer design and code reviews and extensive documentation of standards and best practices Show less

System Analyst / Programmer

• Apr 1996 - Dec 1996

Developed Management Report System and Panadata Terminal System an interface for communication between the Host Computer and the Panasert Machine a Remote Access to Customer Support Hot line Services database (Overseas Systems Database) through Modem / Internet Connection using Visual Basic and MS-Access Collaborated with department heads to create functionality specs and user interface. Created system to register, track, and resolve tickets and bugs to maximize end user experience and functionality of new application interfaces. Reduced user complaints by 65%. Perform requirements analysis, design, development, implementation, testing, and maintenance; modify and upgrade existing programs when necessary. Communicated with all business levels, as well as external partners and vendors, during requirements analysis and testing phases. Show less

System Analyst

• Apr 1992 - Mar 1996

Developed Financial Analysis System using PowerBuilder, Visual Basic and Oracle Interacted with developers, system engineers and testing teams to identify application defects. Developed Financial Analysis System using PowerBuilder, Visual Basic and Oracle Interacted with developers, system engineers and testing teams to identify application defects.