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.
- Company industry:
- Agriculture & Crop Production
- Job role:
-
Information Technology