Business Intelligence and Data Warehouse System Designer Resume

TECHNICAL SKILLS

Database Platforms/ Languages: SQL Server 2000/2005/2008 - R 2/2012/2014/2016 T-SQL, PL/SQL, BTEQ Oracle 8.05 / 9i / 10g / 11g UNIX Shell Script, XML, Bash, WinSCP, Putty Teradata v13, MYSQL v5.6 Course work - Perl, Python and .Net MS Visual Studio 2000/05/08/12/14 Knowledge - Java, JavaScript, C, C++, XHTML UNIX/Linux MS Query TFS (Team Foundation Services), Azure Data Catalog

BI / ETL Case Tools: Microsoft - SSIS, SSRS, SSMS, SSAS SSRS Informatica v9.2 Tableau Pentaho (Kettle) Power BI Desktop DataStage, DJ Cosmos, Data Junction SharePoint TFS (Team Foundation Services), Azure Data Catalog OBIEE, Crystal Reports, Brio and DCU TOAD v12.1 Microsoft Office 2016 Oracle PL/SQL Developer, SQL Navigator, SQL Plus Erwin r7, Power Designer, Visio, Siebel Analytics Version Control (svn Tortoise), SourceSafe Scheduler (Tivoli) and many other analytical tools Creative thinker ability to think outside of the box to resolve complex issues

PROFESSIONAL EXPERIENCE

Business Intelligence and Data Warehouse System Designer

Confidential

Responsibilities:

Highly skilled Business Intelligence Developer with over twenty years of experience in the IT arena - Developing, Analyzing and Implementation of Life Cycle DW Solutions and Business Intelligence applications, Architecture design, ETL development, configuration within Oracle, SQL Server, Teradata, Power BI and various other environments.
Exceptional working knowledge of multiple applications and operating environments with solid understanding of data warehousing (star and snowflake) and data mart design, implementation, data migration/conversions and management concepts (development and production).
Hands-on experience with Microsoft SQL Server Business Intelligence Development Studio (BIDS), Power BI, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Power Pivot and Power View, SQL ServerDataTools (SSDT), Team Foundation Server (TFS), PowerBI, Office 365 and Azure.
Clear understanding of Online Transaction processing (OLTP) and Online Analytical Processing (OLAP) in a Data Warehousing environment with Big Data concept and processing.
Ability to quickly understand the business requirements and storiestranslating them into data solutions and detailed specifications including data mappings, data models and workflow diagrams.
Extensive work experience in ETL Process development including data mappings, workflow development, process monitoring, performance tuning, testing and implementation/deployment of ETL processes using various tools and programming code.
Ability to extract various types of data (EBCDIC, ASCII, XML, unstructured datasetsand other data types) data from numerous, heterogeneous OLAP and/or legacy data sources using programming code, batch files (.bat) and etc…then transform into the targeted structure using SQL Scripts and various ETL tools.
Extensive experience creating database schemas, table definitions, views, writing complex stored procedures, queries, functions, triggers and packages.
Multitudinous experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
Ability to work on multiple projects with multiple stakeholders on Agile, Scrum and/or Waterfall SDLC methodology and convey Analytical findings accordingly both written and verbal.
Exceptional technical skills including advance SQL scripting development (PL/SQL, T-SQL, Pearl, C, VB) utilizing applications such as TOAD, SQL *Plus, Management Studios, Visual Studios, DAC (Data Warehouse Application Console), SQL Developer, Informatica Power Center v9x, MySQL, SQL Navigator, DTS and SSIS Processes and many more.
JCL experience - Enterprise Scheduler Tivoli and windows scheduler to schedule the execution of processes.
Extensive experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME’s), Development and QA teams.
Creative thinker - ability to think outside of the box to resolve complex issues
Excellent analytical and communication skills

Environment: Oracle 10g / 11g, PL/SQL, SQL Server 2000/2005/2008/2012/2014, T-SQL, Teradata v13, Unix, XML, Informatica,SSDT,SSIS, SSRS,SSAS,Visual Studios, TFS (Team Foundation Services),Pentaho (Kettle, Spoon), DataJunction Cosmos, ETL Developer, SQL Developer, Teradata Assistant, Teradata Express, Power BI, Tableau, Report Developer, TOAD, ERwin, Data Mining, Programmer, Architect, ODW, ODI, ODS, OLTP, OLAP, Star, Snowflake, Enterprise Databases, 3rd Normal Form (3NF), Modeling, SDLC, Big Data, Data Lakes, SOQL&SOSL, Force.com.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship