Database/bi Architect Resume
Monterey, CA
SUMMARY:
- IT professional with 20 years of experience and specialize in Business Intelligence, SQL programming and database engineering. Efficient, creative, and resourceful professional who is able to translate business requirements into actionable business intelligence solutions. Developed numerous business - critical management and operational reports. Created a formal procedure for Business Intelligence projects which included a step-by-step process for requirements gathering, documentation, scope definition, communication plans, development, user acceptance, change management and planning for future versions. Created Universes
- Dashboards & Business Views to streamline information and create greater access to information. Created and maintained documentation related to Business Intelligence projects. Planned, tracked and provided status reports on Business Intelligence projects. Provided and implemented recommendations on best practices regarding Business intelligence. Established intuitive reporting methodologies, including ad-hoc reporting capabilities. Ensured that Business Intelligence knowledge is shared throughout the enterprise.
TECHNICAL SKILLS:
TECHNICAL: SQL Server PLSQL Stored Procedures Dada Modeling Data Warehouse ETL SSAS SSIS Replication TSQL SSRS .Net 3.0 Metadata Data Mart TDE Normalization Data Performance Cube Oracle Full - text search OLAP Failover Cluster MDX ADO
WORK EXPERIENCE:
Confidential, Monterey CA
Database/BI Architect
Responsibilities:
- Data Modeling: reconciling multiple databases to be related Data warehouse.
- Programing: Design Stored Procedure to insert data into the database with primary key and foreign key. Design API to pull data from data cloud.
- Consulting: Provide implementing solution and Technique opinion to management team on high level project requirements.
Confidential, Atlanta GA
Sr. DBA/BI Architect/Data Warehouse Developer
Responsibilities:
- Data Modeling: Create relational database for retail raw data. Physical design with primary key and foreign key. Design DataWarehouse with Fact tables and Dimensional tables.
- BI Architect: Design application interface to meet business requirement, and build co-related query to reflect the action between the application and human being with retail data.
- ETL Process: Build ETL included TSQL, PLSQL, and SSIS package to transfer large size ofdata from MySQL, Excel, and CSV file to MS SQL, with Slowly Change function.
- DataWarehouse: Design star schema for cubes. Create cube with SSAS.
- Data Analysis: Design high level SSRS report by CTE and MDX. Create Excel Pivot table by pulling data from cube with Power BI, Pivot Query.
- Administration: Database backup and restore, SQL server agent and jobs execution plan. Database security control. System performance with index, partition and environment clean. Set up Cloud environment with Window Azure. Running the special query against Hadoop.
Confidential, Atlanta GA
Sr. SQL DBA/Developer
Responsibilities:
- Data Modeling: Collected data from different sources. Reorganized and consolidated data in acloud environment with Azure for ERP systems.
- Administration: backup and restore. Cleaning up transaction log, removing duplicate andchecking accuracy on data.
- Data Report: Complicated scripts with CTE, Stored Procedure and functions. Big data runningperformance.
Confidential, Atlanta GA
Database Administrator
Responsibilities:
- Data Replication: Setup data publisher and subscriber to disturber data between environments.
- Administration: Database application maintaining; data import and deleting.
- Dashboard and Report: CTE for complicated data join and Hierarchical relation to dig in.
Confidential, Radford VA
Database Administrator
Responsibilities:
- Administration: Transparent Data Encryption (TDE). Back up and restore encrypted data files to different SQL Servers. Troubleshooting database issues and clean database to optimize database performance for large size of database.
- Support: Suggest the technical teams to use right tools to find the SAN related database issue.
Confidential, Ft. Leavenworth KS
Senior SQL DBA
Responsibilities:
- Administration: Tuning SQL server hardware resources and programming coding. Optimal database and application performance with MS SQL Server 2008 R2.
- Support: Troubleshooting database issues for large application. Apply complicated business rules
Confidential, Ft. Leavenworth KS
Database Engineer/Database Manager
Responsibilities:
- Architecture: Design entire decision support system with Microsoft technology. Setting and
- Modeling: Data architecture for Cloud Database. Logical and physical modeling on data which can be process by SSAS.
- Database Development: TSQL, ETL process (SSIS), SSRS. Full-text search with index. Data analysis with cube, matrix as a BI role.
- Programming: Full-text search with index service. Setting developing and programming environment to generate system metadata. Build document searching application by Microsoft Reporting Services.
- Server Administration: Perform job function for Data Center Administration; Maintain Cluster environment; Server tune up to enhance system performance with MS SQL Server 2008 R2.
Confidential, San Antonio TX
Senior SQL DBA/Architect/BI
Responsibilities:
- Data Modeling: Datawarehouse architecture with star schema for building cube, matrix.
- Systems Design: SQL server architecture with SAN and RAID 5 for stage, product, develop and testing environments.
- Production DBA: Database security, data performance, data replication with MS SQL Server 2008 R2. Perform database disaster recovery by back up and restore.
Confidential, Louisville KY
Senior SQL DBA
Responsibilities:
- Data Mining: DB2, Oracle, and SQL server environments. ETL process with SSIS, Informatics.
- Migration: Convert DTS packages to SSIS packages with MS SQL Server 2000 and 2008 R2.
- Development: Design new SSIS packages to implement the business solutions.
- Normalization: Complicated query for mainframe database clean.
- Consulting: Technique opinion on SQL server installation, administration, and standards on database developments.
Confidential, Arlington VA
Database Engineer/BI Developer
Responsibilities:
- Database Model: Participation in designing related database architecture. Dataflow diagram and data query with Oracle.
- Reporting: PLSQL. RDL, XML for complicated finance report design. Setting security environment for report server.
- Data Analyze: Finding the best solution to present and analysis the finance information and business mode to clients.
- Ad Hoc Report: Build ad hoc report models. user for build report.
- Documentation: Writing business document for project implementation.
Confidential, Sierra Vista AZ
SQL DBA/BI Developer
Responsibilities:
- ETL process: Create and modify SSIS packages to convert and transfer data from outside of MS SQL server 2008 R2 with Cursor and configuration file.
- Data modeling: Dataflow diagram for data logical modeling. Snowflake schema
- Replication: Data copy distributed by transaction log from developing environment to testing environment. Perform database disaster recovery by back up and restore.
- Reporting: Stored Procedures. TSQL. RDL, XML for customizes report design.
- Data Analyze: Create cubes and dimensions with SSAS.
Confidential, Washington DC
SQL DBA/Developer
Responsibilities:
- Reporting: Stored Procedures. TSQL. RDL, XML for customizes report design. Administration for MS Reporting Services. Enhance existing reports. SSAS.
- Database: SQL 2005/2008. SSIS. Design query to apply complicated business rule and data calculation by stored procedure. Temp Table. Data Warehouse. Data converting and clean up.
- Analyze: Finance data analysis to meet business management’s requirements on report’s design.
Confidential, Atlanta, GA
SQL DBA/Data Warehouse Programmer
Responsibilities:
- Reporting: Online report with TSQL, Stored Procedures, MS Reporting Service (SSRS)
- Database: Data transmission by SSIS. Data Market. Data analyze with cube (SSAS).
- : Provide consolation to management on solution, software, and equipment.
Confidential, Lincoln, NE
ASP.NET Developer/DBA
Responsibilities:
- Program:.NET Framework3.0, CSS. UI design with Multi. Column lay out. User Controls and N’sides control. Data linking with X path in XML Web Service. Ajax, Silverlight.
- Platform: Visual Studio 2005, Source Safe, XML Web Service and SQL/DB2 environment.
- Database: DB2, SQL 2005. SSIS, TSQL, database maintenance for software design purpose.
Confidential, Atlanta, GA
SQL DBA/Data Warehouse Developer/BI
Responsibilities:
- ETL Process: Data transmission between DB2 and SQL servers by DTS, SSIS.
- Data Warehouse: Design OLAP to apply business rule and data calculation.
- Database: Database improvement with index turning, denormalization. Database performances by NT monitor, SQL profiler. Temp Table.
- Analyze: Finance data analysis with (SSAS), Cognos.
- Upgrading: Data server’s upgrading from SQL 2000 to SQL 2005. Data applications merge.
- : Successful to build the critical component for a 1 million project which was tried by other groups.