Chief Technology Officer (CTO)
NextDot
Total years of experience :26 years, 0 Months
• As the Head of IT/CTO, responsible for leading the Web, mobile, UI, database teams.
• Review design and architecture of various projects including web application, mobile applications, database design.
• Lead a number of product design including Educational, healthcare, eCommerce and inventory management systems.
• Implement industry best practices for software development.
• Provide guidance for new product strategies and road map.
• Managed multiple teams & projects using Agile/Scrum methodology.
BUSINESS INTELLIGENCE MANAGER/ARCHITECT
15 years of experience in planning, designing, developing and implementing information technology solutions to foster corporate revenue and growth. Lead end to end technical BI projects, mentored peers, provided architectural and design guidelines, data modeling, ETL design, reports and analytical design. Hands on experience leading all phases of software development lifecycle and Data Warehouse solutions. MS in Information Technology.
TECHNICAL PROFICIENCIES
Platforms: UNIX (Solaris), Windows Server NT/2000/2003, Linux (RedHat), IIS, WebLogic, VmWare
Languages: VB 5/6, VBScript, ASP, ASP.net, VB.NET, C#, Java, JSP, HTML, XML, UNIX
Shell scripting, Actuate Basic
Databases: Informix 7, IBM DB2, SQL Server 2000/2005/2008 R2/2012, Oracle 10/11G
Tools: SAP BI 7, Cognos Impromptu/Powerplay 7, Cognos 8/10.1, Actuate eRDPro V5/V7/V8, Actuate iServer V7/V8, SSIS, SSRS, SSAS, Crystal Reports, ERWIN, Business Objects XI, QlikView,
Maestro 3.1/3.5
PROFESSIONAL EXPERIENCE
AGCO. Duluth, GA 2012- present
BI MANAGER - BI/SQL SERVER/.NET TEAM 2013 - Present
Managing a team of MS Business Intelligence (BI) developer, Cognos developer, SQL Server DBA and .Net resources within the global headquarter in Duluth, GA, USA. Current responsibilities include to manage resources, to prioritize projects, oversee technical design including data model, ETL and report design and the overall SDLC process.
Working closely with the SQL Server DBA to drive database strategy, best practice and architectural guidelines. Partnered with enterprise architecture team to contribute to enterprise architecture for MS BI and SQL Server database technology.
Working with internal clients and business partners to help them define requirements, proto-types, Proof of Concept (POC) and then deliver the solution with an end to end involvement. Hands on design and development using MS SQL Server 2008/2012 BI stack tools (SSIS, SSRS, SSAS). Designed and developed data models using ErWin, start schema, ETL jobs (SSIS). Also, developed SSRS reports with parameters, SSAS cubes.
Award: Received 2013 Annual Marketing Major Impact Award for Big Data and Business Intelligence Project
Technologies used: Cognos 10.1, SQL Server 2012/2008 R2, SSIS, SSRS, SSAS, MDS, MDM, T-SQL, stored procedures, Visual Studio 2010/2012/2013, C#
Responsibilities:
Manage technical resources and oversee technical design and deliverables.
Provide technical support to SQL Server databases within North American division.
To assist in migrating SQL Server databases to new datacenter location in a virtual platform.
Assess technical projects and provide help with architecture, scope and then assign appropriate resources for that project.
Working as a part of the IT management team as Database/BI Architect to provide guidance on database design, strategy and roadmap. Also, contributed to promote industry best practices, methodology and processes towards design and development of database and BI solutions. Helped on building database development team by screening technical interviews and provided guidance to junior team members.
Responsibilities:
Design and develop database and BI solutions.
Recommend best practices and technology road map for the organization.
Identified performance issues and optimized SQL Server 2012 environment and database solutions.
Implemented technical database solution including data modeling, data base design ETL solutions.
Resolved issues with SQL Azure Cloud databases.
Provide technical expertise for MS SQL Server and BI tools and implement industry standards.
Analyzed and designed application and infrastructure to migrate applications to the data centers. The scope of the project is to work with the business and the technical teams across the organizations to migrate applications from multiple data centers to a newly designed data center by leveraging virtualization technology.
Responsibilities:
Manages assigned activities related to the migration of applications to the data center.
Applies significant knowledge of industry trends and developments to migration environments
Recognizes system deficiencies and implements effective solutions based on established standards
Communicates difficult/sensitive information to all levels of Management
Recommends and facilitates procurement of datacenter hardware and software as required
Prepares and delivers engaging, informative, well-organized presentations and status reports
Resolves and/or escalates issues in a timely fashion
Peer reviews technical design documents for quality and accuracy
Produces technical design documents as required
Works with client project managers on assigned applications
Manages client interaction and expectations during all aspects of the migration
Attends weekly Design Review and Build meetings; presents designs as required
Provide input to management on strategy, processes and the status of issues and risks
Other duties as assigned
Lead multiple data warehouse projects and was involved in software design, architecture and implementation of software solutions in both windows and Unix environments. Analyzed software requirements, architecture and presented technical design and specification to team members and management.
Lead the data warehouse configuration management in parallel with current project responsibilities. Designed and implement guidelines for source code control for the team and outside consultants. Managed software releases and builds in Visual Source Safe.
Leading the Data Warehouse integration projects to integrate from MS SQL Server 2005 to SAP BI 7 environment. Designed and developed data warehouse/business intelligence applications and reporting product solutions using Actuate V5/V7/V8, Cognos, Crystal Reports and SAP BI 7.0.
Key Accomplishments:
Successfully completed data warehouse refresh project to migrate existing hardware and software environment from UNIX/Informix environment to MS Windows/MS SQL Server 2005 environment. Estimated project cost $1.6 million dollars. Technologies used: MS Windows 2003 64 bit server, IIS Web Server, MS SQL Server 2005, SSIS, SSAS, MS .net.
Completed reporting server upgrade from Actuate iServer V7 to V8 in Sun Solaris platform using load balanced/fail over methodology with WebLogic web servers. Technologies used: Sun Solaris 8, WebLogic Web Server, Actuate Basic, JSP, Unix Shell Scripts, C#, C++.
Successfully designed and implemented standards for the Data Warehouse Software source code repository and software releases.