Experienced Data Architect/Data Warehouse Architect/Data Warehouse Manager seeks to contribute extensive knowledge in Business Intelligence and System/Database Development. Successfully led Business Intelligence projects by developing systems and reporting solutions that combined creativity and problem solving skills with a high attention to detail. Fast-paced, flexible senior level contributor, adept at staying on-task and on-time despite shifting priorities and tight deadlines.
Specialties:• BigData/Hadoop BI based on Cloudera, Datameer, Talend
• Enterprise Data Warehouse/Business Intelligence/ETL solutions
• Data Architecture
• Database Management
• 24x7 Global Service Management
• Project Delivery Management
• Domestic & Offshore/ Matrix Management
• KPIs & Operational Metrics
• Vendor Management
• Technology Architecture & Integration
• Technology Governance & Compliance
• Proof of Concept (POC)
SVP application development @ From November 2013 to Present (2 years) Vice President @ ■ Responsible for end-to-end delivery for Global Market Research Data Warehouse including the business analysis, program management, development and testing.
■ Responsible for enhancements and ongoing operational support for Bank of America Merrill Lynch research distribution platform.
■ Responsible for enhancements and ongoing operational support for Bank of America Merrill Lynch research entitlement platform.
■ Established and managed the Business Management/Program Management (BPMO) for research Technology. This include financial management, budget planning, creating portfolio heat maps and vendor management.
■ Hands-on R&D for “Big Data” initiative at the bank based on Hadoop, Talend(ETL) and Datameer(BI). From July 2010 to December 2013 (3 years 6 months) NYCVP, EDW\BI manager, DBA lead @ Data Warehouse Architect/Business Intelligence.
Responsible for designing and implementation of 6.4 Tb Enterprise Data Warehouse (Data Depot) project base on SQL Server 2005/SSAS/SSRS and Business Object XI products.
Document data architecture environment to produce and maintain an accurate "as is" view of current data environment.
Create & maintain Enterprise Data Architecture documentation and guidelines.
Participate in new release architectural reviews to ensure alignment with the enterprise data architecture.
Ensure compliance of corporate policy and standards or appropriate adaptation of standards.
Work with Application Architects and Corporate infrastructure teams to provide common access for all the application databases and enterprise data repositories.
Identify opportunities for data reuse to reduce asset footprint and costs. From March 2005 to July 2010 (5 years 5 months) VP, Data Architect/Modeler @ Vice President, Technology.
Develop standards and guidelines for the design of data architectures, data models, tools and databases, including organization, structure and nomenclature of data elements.
Create and implement required metadata processes and frameworks.
Set formal standards, policies and processes that integrate data architecture considerations and impact assessment into the broader set of Program and Project Management practices.
Define process and criteria for granting exceptions to the data architecture standards.
Implement on-going warehouse maintenance
Lead Master Data Management (Library) activity as one of the key components of EDW project based on KALIDO DIW/MDM product
Manage Data Quality initiative.
Manage offshore vendors (Cognizant, TCGI Vega) to scrub corporate data.
Manage production DBA’s (on-site/offshore) to support company 75 SQL servers. From March 2005 to July 2010 (5 years 5 months) Data Warehouse Architect/Data Modeler @ • Responsible for the development of a brand new Enterprise Data Warehouse based on Ms SQL 2000.
• Analyzed business requirements and define a problem statement for an EDW initiative
• Responsible for an Architectural design and Modeling (Logical and Physical)
• Difine toolset for an EDW implementation based on available budget and IT skill set available.
• Build EDW team, run proof of concept and actual project implementation.
• Responsible for ongoing maintenance/support for company’s 12 SQL servers (version 7 and 8) including VLDB (1.8 TB in size).
• Designed and developed back office SQL Server financial database to support internet, intranet, home banking, and 3rd party applications, company enterprise reporting system for 600+ internal users and 600 000+ credit union members.
• Implemented project involving Microsoft SQL 2000 clustering, snapshot and transactional replication to meet NYSBC requirements for a company’s disaster recovery plan. From February 2001 to March 2005 (4 years 2 months) Greater New York City AreaDatabase Developer @ • Designed and developed Web based Intranet Utility Services System, a reporting system which allows different clients to see reports through the corporate web page in real time, based on the client request.
• Designed and developed VB application, which allows managers to grant permission to the end users and make necessary changes to the back end database. From July 1999 to November 2000 (1 year 5 months)
Belarusian State University From 1989 to 1994 Sergey Kolosovskiy is skilled in: Database Admin, Vendor Management, Data Architecture, Project Management, Matrix Management, Data Warehousing, Talend, Business Objects, Microsoft SQL Server, Disaster Recovery, SharePoint, Business Intelligence, Testing, SDLC, Management, Business Analysis, SQL, Business Requirements, Visio, Databases, Access, Enterprise Architecture, Program Management, Enterprise Software, Master Data Management, SSIS, Software Documentation, ETL, Data Modeling, Integration, Data Quality, Database Administration, Data Analysis