Inventive, Customer-focused and Solutions-driven Information Architect (IA) Professional with 15+ years' extensive senior level experience. Successfully drives planning, architecture, deployment, and management while analyzing, documenting and re-engineering development processes. Proven track record of leading teams towards meeting objectives and exceeding customers' expectations. Able to achieve breakthrough results through solid analytical and communication skills. Leads cross-functional projects to reach organization objectives, mentoring junior IAs and Developers through complex projects to aid in professional development. Resolves complex technical issues related to business applications while communicating solutions to business areas. Impeccable integrity and work ethic.
Oracle 11g, Microsoft Sql Server 2012
Microsoft .NET 4.0 -- ASP.NET and MVC Frameworks
SAP Business Objects 4.x, Cognos 8.4
Oracle Data Integrator, SAP Data Services
Crystal Reports, MS Reports
ERWIN 7.1, TOAD 11, Oracle Data Designer, MS Visio
Perl, PHP, Python, PL/SQL, SQL
Hadoop, Hive and PIG Technologies Databases: Oracle 10g, 11g, MS SQL Server 2008, MS SQL Server 2012
ETL Tools: Oracle Data Integrator 11g, IBM Data Stage and SAP Data Services
Data Modeling Tools: Erwin 7.0, TOAD 11, MS Visio
Web Frameworks: ASP.NET and MVC Frameworks
Scripting Languages: PL/SQL, SQL, PERL and Python, C#
Reporting Tools: SAP Business Objects 4.x [WEBi, XCelsius Dashboards, and Crystal - Reports]
Tools : MS Visio, MS Project, and MS Excel
Cummins Aftermarket, Memphis, TN 1998 - 2002
As a Senior Analyst, saved 20% of the budget by successfully migrating The Long-Term Warranty system from Mainframe/Cobol to Oracle Forms 4.5 and Oracle 8i with available tools and custom Scripting.
Provided Technical Guidance and Consulting for Data warehouse Team in testing the ETL tools and implement and integrate the systems
Performed many technical functions including Automating Report Generation using Unix Cron Jobs, migrated data from mainframe system to Oracle database using PL/SQL scripts, built user interfaces using Oracle Forms and Oracle Reports.
As a junior level developer, Helped OCTEL Oracle Team with writing APIs to Oracle HRMS 10.0 ERP system using PL/SQL
Saved 30% by developing a robust home based Excel Application using VB Macros for the HR Team at OCTEL.
Databases: Oracle 7
Front-end tools: Oracle HRMS 10.0 System
Scripting Languages: PL/SQL and VB Script.
Business Link automation (I) Ltd. India 1995-1997
Worked as an entry Level developer and customized various retail applications using Oracle and Clipper Softwares.
Technical Lead and Application Administrator January 2014 to CurrentMIG Technologies Inc － Rockville, KY
As an Business Intelligence (EBI) Architect and Solution provider for State of Kentucky, involved in bringing various state agencies onboard to EBI project as part of an integration project.
Being the owner of this project, my responsibilities include "not to compromise" agencies data and keep it secured from other agencies accessing another agencies data but still reside on same server Project Management Duties: Perform Stakeholder interviews Plan for Project with timeline approved by all agencies statewide Request and Allocate resources to onboard upcoming agencies onto EBI Document all the onboarding process, share them with all state agencies on MS Share point site and updating them as and when needed Mitigate Risks by taking a proactive approach and solving issues ahead of time Create a process in migrating the reporting content with the blessings of all stakeholders Create a process to keep the agencies data secured from being shared with each other.
Information Architect January 2002 to January 2014Rockville, KY
Dedicated to successfully assisting teams in obtaining software needs.
Performed meticulous stakeholder interviews, Designing Database Architectures and Application Development for notable clients including Office of Employment Technology, Office of Vocational Rehabilitation and Unemployment Insurance [UI].
Employed team-building expertise during project management of several client projects.
Performed stakeholder interviews to gather business requirements.
Defined Project Scopes and created schedules.
Conceptual, Logical and Physical Database Design for Case Management System (CMS), E3, TAPR and other satellite systems Successfully Performed Data Integration strategies and integrated enterprise level databases for a big Data warehouse project with databases ranging from 50 GB to 2 TB.
Implemented Kimball and Inmon methodologies to design Data Marts and Data warehouse.
Proactively Implemented Data Integration methods between Mainframe System and RDBMS Systems using various technologies.
Guided junior developers to streamline and standardize scripts and document them in a Team lead role Successfully finished Business Intelligence / Datawarehouse Project well under budget and on time.
Provided end-user training in generating and analyzing reports using the Business Intelligence tools.
Perform nightly backup of the server content into BIAR files Install and configure new Business Objects Reporting Servers and maintain the servers (patches, fix packs etc.) Resolve scheduling issues to all customers by setting up a proper scheduling time per customer, so that these jobs will not affect the server performance Monitor and Audit Servers and provide the reporting capability on these applications Built a .NET SDK to query infostore and bring these details into database for reporting Architected and built databases to hold audit and SDK Metadata information and provide Oracle Stored procedures to talk to .Net Application Wrote and scheduled batch jobs to stop and start servers at a scheduled time Provided Row-level security on Audit Universe to secure audit data for all Agencies Enterprise Business Intelligence (EBI) is an integration project which combines all different state agency licenses into one single enterprise license.
Education and Training
Bachelor of Computer Technology
BTech : 1993
PMP Certified from Project Management Institute in 2013
C_BOBIP_40 Application Associate SAP BusinessObjects Business Intelligence platform 4.0 Certified in Dec : 2014
Best Technical Lead Award for E3 Kentucky Project , 2007
.NET, Microsoft .NET 4.0, ASP.NET, streamline, Analyst, Application Development, approach, Architect, agency, automation, backup, big Data, budget, Business Intelligence, Business Objects 4.x, Business Objects, C, Case Management, Clipper, CMS, COBOL, Cognos 8.4, Consulting, content, Crystal - Reports, Crystal Reports, client, clients, Data Integration, Data Modeling, Data warehouse, Databases, Database, Database Design, Dec, Designing, ERP, ERWIN 7.1, Erwin 7.0, Erwin, ETL, Forms, Forms 4.5, HR, PHP, IBM, Informatica, Insurance, JCL, team-building, Team lead, Macros, Mainframe, MS Access, C#, MS Excel, Excel, Office, MS Project, Share point, MVC, Enterprise, Oracle Forms 4.5, Oracle Developer, Oracle, Oracle 8i, Oracle database, Oracle Designer, developer, Oracle Developer 2000, PL/SQL, Oracle 7, PERL, Project Management, Python, RDBMS, Rehabilitation, reporting, retail, SAP, scheduling, Servers, scripts, Scripting, MS SQL Server, Microsoft Sql Server, SQL, Systems Analyst, user training, TOAD, Unix, VB Script, Visio, VB
Bachelor of Computer Technology BTech : 1993 PMP Certified from Project Management Institute in 2013
C_BOBIP_40 Application Associate SAP BusinessObjects Business Intelligence platform 4.0 Certified in Dec : 2014 Best Technical Lead Award for E3 Kentucky Project , 2007
Create a job alert for [job role title] at [location].