OBJECTIVE:

To leverage over 14 years of IT experience in Software Analysis, Application, Database, Data warehouse, Business Intelligence and Webapp designs and developments space. I bring with me exceptional skill in finding and bringing about result oriented solutions. I have architected and supervised many successful Data warehouse, and Business Intelligence development including Data migration, and ETL processes to support enterprise reporting systems. I have unique and effective leadership abilities to mentor junior developers and raise team moral to achieving and for most times exceeding team's mission. I am a people's person and leader who work collaboratively with other teams to realize corporate IT goals, all the while employing best practices and methodologies. I have excellent writing and verbal communication skills.

SUMMARY:

• System, Database, Data and BI Architect, Data Modeling and System Automation design and implementations. Including management and support for SDLC.
• Experience Business Intelligence developer and Architect specializing mainly in, but not limited to Microsoft Technologies such as SQL Server 2012, 2008, 2005 suites including SSRS, SSDT, SSIS, and SSMS stack.
• Led and directed the design and successful deployments of many corporate Business Intelligence applications including Enterprise Data Warehouse, Analysis Services, and Reporting Services with outstanding results.
• Data warehousing design and management including Master Data Management.
• Defined and managed Data staging environment and ETL designs and enhancements.
• SQL 2005 Reporting services, Analysis services and Integration services development
• Data modeling and Database Performance Tuning.
• Advance Microsoft SQL 2008 programming with DMO, DDL, DML, ETL and DTS including using ActiveX.
• Microsoft .Net framework 3.0 to 4.5 technologies
• Front-end tools such as ASP.NET, ADO.NET, ASP.NET MVC, Razor, Entity Framework / EF Code First, LINQ
• Microsoft Access, Oracle 8, 9i, 10g PL/SQL, Oracle work bench and export tools.
• Service broker programming for asynchronous processing.
• Visual Basic. NET, C . NET and Visual C . NET, ADO.NET, ASP.net.
• Talend software, Jasper Reporting
• Object-Oriented programming using C , C and Visual Basic.
• Postgres DB, Vertica DB, MySQL, SQL Server 2005, 2008, 2012
• Graphic database design - Neo4J
• Visual Basic Database programming and OLE-Automation reports and Seagate Crystal Report Designer 9.
• Pentaho BI Solutions, Mondrian Saiku-Server, Talend software, Jasper Reporting
• Open source development tool -Python and BASH/Script programming.
• Expert VBA programming with Excel, Access, Word and Outlook.
• Excellent communication and interpersonal skills with extensive client interaction.

TECHNOLOGIES:

Microsoft Visual Studio 2010, ASP.Net MVC , Microsoft Report Builder 3.0, Microsoft SQL Server 2012, 2008/2005/2000/7.0, SSAS Analysis Services , SSDT SSIS Integration Services , SSRS Reporting Services , Crystal Reports XI, Monarch, DTS, OLAP, OLTP, Visual C .NET, C , VB.NET, ASP.NET, ADO.NET, Visual Basic 6.0, XML, XSL, VBScript, HTML, MS Access, Crystal Reports 8.5, Erwin 3.5, Visio 2000, Internet Technology Web Services, Visual Studio.NET, Python, Java, PostgresSQL, Pentaho BI solutions, Saiku BI Sever, Shell scripting

PROFESSIONAL EXPERIENCE:

Confidenital

Senior Enterprise BI/Data Architect

Responsibilities:

• Lead database design development, enhancement, expansion and provide performance and optimization support for the Enterprise Data Warehouse and Reporting.
• Principal Data Architect for database designs for DCPS IMPACT project from CDM through LDM, PDM and implementation using Embracado Data Architect tool.
• Reverse engineered other enterprise database platforms for architectural understandings and to learn various systems, identifying opportunities to drive performance and scalability.
• Manage and resolve production database issues including the implementation of maintenance plan to mitigate flash issues.
• Design short, medium and long term strategies for performance and scalability of new database developments.
• Principal architect to Multi-Source ETL process including SSDT SSIS , SSAS and open source tools Python, shell scripting, Pentaho Data Integration etc.
• Coordinates with other teams for common design approaches and uniform standards to shared platforms for the usage of enterprise resources.
• Lead one of the most successful enhancement to a bugged down SSIS ETL process reducing performance processing time from 15hrs to 3hrs.
• Provides enhancement and optimization with ETL process development and maintenance.
• Design and develop Analysis Services SSAS OLAP Cubes for various reports and data mining analysis.
• Design and support the development of standard and ad-hoc BI reports and reporting modules using SQL Server Reporting Services SSRS
• Designed and developed various operational Drill-through and Drill-down reports using SSAS and SSRS
• Design dash-board reports with Sub Reports, Charts, Matrix reports and Linked reports.
• Provide support to report performance issues by Query Optimization.
• Design predictive database using Neo4j graphic database.
• Leading the effort to designing a new and improve Data Warehouse for EDware BI project.
• Member of the database release advisory team.

Confidenital

Senior Microsoft SQL Server BI Architect / Developer

Responsibilities:

• Managed the development of multi-platform ETL process for the automated Quality Management Reconciliation System MRS .
• Analyse data from various enterprise source systems to understand the structure and context of the data, and how it fits into the Enterprise Data Warehouse. Identify potential source system data issues and/or gaps.
• Developed and deployed SSIS packages for extracting and analysing data from multiple data sources, including flat file, Mainframe, DB2, SQL, Teradata servers and other data source.
• Designed and developed robust automated QA system for validating converted data.
• Provided both leadership, mentoring and technical expertise to junior developers and facilitated an atmosphere of can-do attitude among the team and the teams we support.
• Principal supervisor of automating scripts including developing and publishing the standards, performance tuning and ensuring consistency in reporting.
• Collaborating extensively with peers and internal users from various business units to understand business processes, requirements and expected wish lists. Worked with development team leaders to establish and map-out phased strategies and approximate timelines for completion of various milestones of development requirements with defined metrics to evaluate the success and failures of each phase.
• Defined and managed the Data staging environment including working tables and ETL SSIS packages with performance optimization through coding and database designs including the analyses and selection of the most effective indexes to use.
• Re-engineered a unified application process capable of processing all files received from differing, vendors and clients by standardizing the send and received file layout and implementing unified business rules using stored procedures, functions and triggers.
• Monitored the data consistency of automation scripts and data in staging database including version control.
• Administered database management and trained current DBA and Data processors.
• Created and generated enterprise QA reports using Microsoft reporting tools with drill-down and drill-up capabilities and report subscription that publishes reports to users at specific times.
• Partly managed the Recon database server SQL 2008

Confidenital

Technical lead Reporting Team Risk Management

Responsibilities:

• Technical lead designer/architect with the ERP team tasked to design, develop and deploy Microsoft Reporting Services and Microsoft Analysis Services on the 2008 platform for enterprise Data warehouse reconciliation system for the Credit Risk Management group.
• Migrated reports from SQL2005 to SQL2008 including the re-writing of RDLs using Multi-Dimensional Expression MDX queries.
• Creation of analysis data mining and cubes.
• Designed multiple SSIS packages to validate and load data files from different source feeds.
• Automated stored procedures through SSIS packages to generate ad-hoc reports for QA and business units including the investigation team.
• Designed and deployed reconciliation reports between feeds from differing sources on SSRS.
• Successfully helped the redevelopments and deployments of some long running SSIS packages for performance optimization.
• Designed reporting cubes for the EDW using SSAS.
• Provided documentations for the design, and deployments for objects created and released to QA and UAT including technical processes and object migrations.

Confidenital

Senior Microsoft SQL Server BI Architect / Developer

Responsibilities:

• In the capacity of a Data Warehouse Architect, I architected, designed and managed the development of the company's Data Warehouse infrastructure, using Microsoft's BI technologies.
• Provided both leadership and technical expertise to building a robust, flexible and extensible foundation that met 99.99 of the design goals.
• Collaborated extensively with peers and internal users from various business units to understand business processes, requirements and expected wish lists. Worked with development team leaders to establish and map-out phased strategies and approximate timelines for completion of various milestones of development requirements with defined metrics to evaluate the success and failures of each phase.
• Lead the team of designers, DBAs and developers to design a Master Data Management MDM system and the strategies for change management while employing some of the best practices in design patterns and methodology.
• Defined and managed the Data staging environment including working tables and ETL SSIS packages with performance optimization through coding and database designs including the selection of the most effective indexes.
• Defined Data warehouse dimension tables including SCD ETL strategies.
• Designed, wrote the project plan and lead the project team to migrate the company's system from SQL2000 to SQL2005 to platform with minimal down time.
• Lead the Migration of database objects and DTS packages to SSIS Project including testing and user acceptance testing.
• Designed and supervised the daily, weekly and monthly ETL processes for the data warehouse and data marts databases including time sensitive and real time information extraction from transaction servers using SSIS.
• Managed ongoing maintenance of Microsoft Business Intelligence SSAS environment for performance, scalability and addressed issues regarding latency.
• Re-engineered existing application processes to efficiently utilize new technologies removing buggy modules and leveraging new programming practices with astonishing efficiency and effectively implementing business rules.
• Re-engineered a unified application process capable of processing all files received from differing, vendors and clients by standardizing the send and received file layout and implementing unified business rules using stored procedures, functions and triggers.
• Administered database management and trained current DBA and Data processors.

Environment: SQL 2000, SQL 2005 DTS, SSIS, SSRS, SSAS , SSRS, Excel, Access, ASP.net, Visual Studio .NET 2005, Visual Studio 2003, Crystal Reports XI, Monarch

Confidenital

Senior SQL Server Developer

Responsibilities:

• Senior Database Analyst responsible for leading and managing the re-engineering of the Enhancement Leads Management Systems ELMS department.
• Translated monthly product managers targeting strategies for marketing by leveraging effective database programming, standing risk assessments and in-depth analysis for marketing profitable populations.
• Automated the Triggers waterfall report process reducing the usual 2 to 3hrs time normally needed for creating the report to 10 minutes with 100 accuracy using Excel formulas, VBA and SQL scripts.
• Led the re-engineering team to design and deploy internal application modules using Oracle PL/SQL procedures, UDFs and packages.
• Built a cross portfolio automated post campaign process application using Access, Oracle SQL, Encompass and VBA.
• Excellent Knowledge of CITI cards products, services, cross processes and Data flow across multiple BUs.

Confidenital

Senior Microsoft BI Architect/Developer

Responsibilities:

• Responsibilities included conducting interviews with executives, VPs, senior managers, business analysts, and technical staff in capturing and understanding business requirements, and defining project scope.
• Performed detail data analysis of both data elements requested by the business and data source and documenting data source definition, source-to-target mapping, and logical structures for the data warehouse/data mart.
• Project manager in designing ETL, Schema, Fact and Dimension tables and the strategies to maintain the availability and the most current information through scheduling of ETL using SQL job scheduler.
• Designed and implemented the strategies for updating slowly changing dimensions SCD through SSIS.
• Defined and managed the Data staging environment including working tables and ETL SSIS packages.
• Deployed Microsoft reporting services for Business intelligence with customized reports formats including Excel, Flat file and PDF.
• ETL operations for moving data from OLTP to staging databases and DATA MART.
• Lead a team of 4 developers to design and deploy the Eltman Analysis SSAS and Reporting Services SSRS .
• SQL optimization relating to using cursors, indexes, temporary tables.
• Conducted complete system studies to identify bottlenecks and suggest improvements with documentation, unit and integration tests and the definition of technical standards and requirements.
• Project management including monitoring and reporting of project milestone.
• Developing data warehousing schema and its supporting stored procedures, UDF and Views for reporting services.
• Responsible for the design, development and management of the corporate data warehouse and reporting services.
• Developed the Eltman HR web survey 360 application using ASP.net and C .
• Developing DTS packages and automation of reporting services including Stored Procedures and UDFs.
• Developed trends, aggregates, charts and averages reports through Microsoft reporting services using DTS packages, stored procedures and Visual Basic ActiveX scripts and macros.
• Using Excel VBA to design complex spreadsheet applications for sales trends, cost analysis, data mining and forecasting of future returns on Investments.
• By re-writing existing stored procedure codes and re-packaging local packages, I managed to improve significantly the efficiency and the processing speeds of most in-house applications. In some cases, non-performing or crashing procedures/Packages were recoded to eliminate bugs and achieve speeds up to over 1000 times faster than the previous procedures. Example, a package that used to take almost 3hrs to complete its task was reduce to 2mins or less

Confidenital

Senior Developer/Analyst

Responsibilities:

• Responsible for all the development and integration of VB/VBA applications including Excel, Word and stand-alone VB.
• Performed functional data management and analysis using MS SQL and Oracle Data Transformation Engines DTE and DTS services in conjunction with Excel spreadsheet for reporting.
• Developed robust PL/SQL programs such as packages, functions and stand-alone SQL statements that enhanced the processing of data with automations and job scheduling.
• Developed automation applications that that interacted with data marts and data warehouse for reporting with Microsoft Office applications Word, Excel, Outlook, etc.
• As a Project director, I supervised and managed some of the critical cross system operations to compare application scalability and versioning controls using in-house tools.
• Gathered, analysed designed and developed application enhancement and development requirements for various division applications including the Research and Analysis departments.
• Managed the Software Development Life Cycle SDLC
• Designed and developed COM/DCOM and ActiveX components and applications using Visual C 6.0.
• Performed unit and system testing and integration on software modules and applications from both in-house and third party products.
• Redesigned and made modifications to existing applications and processes to take advantage of emerging new technologies. Some modifications reduced production time from 2 business days to 10 minutes.
• Produced user documentations and trained end users to efficiently utilize in-house applications.
• Corporate Goto person for Excel and VBA questions and solutions Expert .