Sign in

Data Sql Server

Houston, Texas, United States
January 15, 2018

Contact this candidate

Shahram Ahmadinejad

***** ******** **., ***. #: *13

Houston, Texas 77042

Cell: 832-***-****


Permanent Resident: Green Card


IT professional with a history of high-level Data Architecture, Data Modeling, Data Analysis, ETL, Business Intelligence and Software Development Life Cycle experience in enterprise scaled corporations, seeking an opportunity to help organizations meet and accomplish their strategic goals. Over the past 11 years, I demonstrated exceptional architecture, design and modeling skills in leveraging various technologies to develop and support outstanding Business Intelligence solutions.


Over 18 years of experience in information technology management and team work in an enterprise environment.

Database Architecture and Design

Data Modeling, Data Analysis, Data Profiling

ETL and Business Intelligence

Software Development Life Cycle Process

Expertise in reviewing business requirements and technical design documents to develop effective database design solutions.

Develop architecture plan to improve the quality of the data and integrate diverse source data to achieve business objectives.

Collaborate with IT colleagues to identify user requirements, assess available technologies, and recommend new data fit and solution options, technical strategies and tactics.

Identify data architecture problems, resolutions, changes, upgrades and communicate across.

Experience in designing Enterprise Data Warehouses, Data Marts, Reporting data stores (RDS) and Operational data stores (ODS). Strong understanding of Data Warehousing and Data Modeling concepts.

Expertise in defining, creating and maintaining Conceptual (business scope), Logical (business process) and Physical data models (technical solution) using Entity- Relational (ER) modeling (Normalization, 3NF), Dimensional modeling (Star Schema and Snowflake Schema) and Object-Oriented Modeling.

Hands on experience working and applying design considerations of 3rd Normal Form for OLTP Databases and Models.

Expertise in Physical modeling creating PKs, FKs, Indexes, Partitioning, Views, Join reports etc.

Expertise in customizing Physical models to various database platforms like Teradata, DB2, Oracle and Green Plum.

Hands on experience using Power Designer, Oracle SQL Developer Data Modeler and Rational Rose modeling tools.

Experience in design and maintenance of Enterprise data warehouse, data management, metadata management, master data management, data element modeling, naming standards, data extraction and data archival processes, across multiple database platforms.

Expertise in data requirement validation by performing business rules traceability analysis and gap analysis.

Expertise in analyzing client requirements and drafting business specifications using Use-case scenarios, Unified Modeling Language (UML) and Rational Rose modeling.

Able to recognize and identify patterns in data relationships from disparate systems.

Experience working in JAD sessions with Business, IT and Project teams, Solution Architects, DBAs and Industry Consultants to design, execute and implement BI Intelligence data stores.

Experience in implementing direct insourcing projects, sourcing and data integration from multiple regional source systems to Enterprise Data Warehouse.

Experience in Agile/Scrum, iterative and waterfall SDLC methodologies.

Experience in drafting data modeling standards, guidelines, best practices and process improvements based on experiences and new technologies. Thoughts contribution and knowledge sharing through creation of presentations, documents and facilitating Data Architects tech meetings. Mentoring and providing assistance to new joins and junior Data Modelers.

Drive innovations by keeping up to date on emerging technologies and Data Trends which may fit with the company’s project needs.

Experience working on Business Intelligence tool like Business Objects, SQL Server Reporting.

Experience working on various Database platforms like, Oracle, SQL Server and DB2.

To conclude, possess strong organizational and critical thinking abilities, to assess complex problems, analyze options, navigate diverse perspectives and objectives and develop acceptable Data Management solutions.


Data Architecture and Modeling

Entity Relationship (ER) Modeling, Dimensional Data Modeling using Star schema and Snow-Flake Modeling, Unified Modeling Language (UML) and XML Reverse Engineering, Master Data Management (MDM), Conceptual Data Modeling (CDM), Logical Data Modeling (LDM), Physical Data Modeling (PDM), Waterfall and Agile Software Development (Scrum), Zachman Framework

Data Modeling Tools

Power Designer, Oracle SQL Developer Data Modeler 4.0.3, Rational Rose/Requisite Pro, Visio for Enterprise Architects

Business Intelligence

SQL Server Reporting Service (SSRS), Crystal Reports


Oracle 10G/9i/8i/8.x/7.x, MS SQL Server 2012/2008R2/2008/2005/2000/7.0/6.5, MS Access 7.0/2013, SQL, PL/SQL, DB2, Green Plum(PostgreSQL)

ETL Tools

SQL Server Integration Service (SSIS), Oracle SQL*Loader, IBM Infosphere DataStage 8.5


Win 3.x/95/98, Windows XP, Windows 7, Win NT 4.0, Windows Server 2000,2003,2007,2012,2015


Programming Languages:

Java (Servlet, Java Beans, JDBC, JSP, Struts), ASP, .Net C#, JavaScript, HTML, DHTML, CSS, SQL, HTML5, JQuery, Janus, DevExp


Visual Studio, Xamarin, Eclipse, NetBeans, Intellij Idea, JUnit, UML (Rational Rose), IReport, XML, Microsoft Office, Adobe Photoshop and Dreamweaver, Brackets, Bootstrap Studio, WordPress, WebSphere, WebLogic, Tomcat, IIS


2017: Database Designer, Web4Market, Houston, Texas

Houston based Start-up Company providing new ideas and concepts in Internet marketing and social businesses.

Internet Marketing Consultancy for all types of businesses, applying Google Ads, Facebook Ads, Google Ad. Sense, Viral Networks, Social Networks…

Web Design and development for our marketing customers in order to help them achieve their target market goals.

2006 – 2016: Data Architect / Designer and Senior Adviser, Housing Investment Corp., Iran, consisting of 17 national construction subsidiaries

The largest construction corporation in Iran active in constructing residential buildings, high rises, residential complexes dam, etc. Consistently had more than 100 on-going projects. We had a very comprehensive IT group in holding company with over 45 direct employees under our IT management for the corporation.


Reporting to the IT Vice President of the Corporation.

Participated in brain storming sessions with application developers and DBAs to discuss about various de-normalization, Partitioning and Indexing Schemes for Physical Model.

Working across business lines and IT domains to ensure that information is viewed as a corporate asset and treated as such. This includes its proper data definition, creation, usage, archival and governance.

Create, update and maintain conceptual, logical, and physical models for identified solutions.

review/approve all DDL for any and all schema changes

Work on data needs and issues to minimize business risk.

Normalized the tables/relationships to arrive at effective Relational Schemas without any redundancies.

Identified the Facts & Dimensions Tables and established the Grain of Fact for Dimensional Models.

Created Multi-Way Aggregate Fact Tables as a specific summarization across dimensions of product, region and date.

Created Snowflake Schemas by normalizing the dimension tables as appropriate, and creating a Sub Dimension named Demographic as a subset to the Customer Dimension.

Identify the initial data access paths of the physical data models.

Work with Database Administrators to develop physical models.

Created data models for transactional data, which would be later moved to Operational Data Stores (ODS) and eventually to Enterprise Data Warehouse.

Worked on projects implemented using Agile framework and delivered Data Architect artifacts in three weeks’ sprint time.

Experience working and co-coordinating with Scrum master, Product owner (BSA), ETL lead and Testing lead as part of sprint deliverables and backlogs.

Participated and contributed in sprint grooming, planning, daily scrum and sprint retrospect calls.

Performed data analysis and data profiling of the source data to understand the data, data volumes, data anomalies, duplicate data, primary key candidate’s assignment, primary index assignments, data type assignment and null values determination.

Created views, materialized views and join indexes as needed based on the customer extract needs and reporting needs which needed pivoted data, different performance metric data etc which needs customization logic in the data model or during the ETL phase.

Created data mapping document for ETL team reference and data loading.

Created domains, templates and naming standards for different database platforms.

Organized tables in the data models and table schemas in database as per data ownership list in the organization.

Created logical data model for each of the projects in the corporation.

Created Fact and dimension tables to capture project data flow requirements.

Created Source to Target mapping documents.

Created staging area to facilitate data movement between source to target tables.

Created install scripts or deployment scripts to deploy tables in different Oracle database environments and pass them to DBAs.

Performing gap analysis between current data structures and target data structures

Enhancing and maintaining the Enterprise Information Model

Understand and translate business needs into data models supporting long-term

Serving as a technical data strategy expert and leading the creation of technical requirements and design deliverables

Maintaining knowledge of industry best practices, technologies, and architectures

Recommending and evaluating new tools and methodologies as needed

Technology Environment:


Fiber Optics, Internet, Intranet, Cisco and Huawei Routers, Voice over IP(Alcatel), Mikrotik


MS Windows Server 2008,2010,2012, Linux, (VMWARE)


HP, Super Macro (35 Servers physically and virtually)


MS-SQL Server,Oracle, MS-Access, MySQL

Programming Language:

.Net (C#, VB), PHP

Development Technology:

BI, CRM, ERP, Janus, DevExpress, SharePoint


Symantec Endpoint Protection, Junipers Firewall, Backup/Recovery, Hot & Cold Site, Contingency

2006 – 2011: CEO and Software Instructor, Aptech Global Training Center (Headquartered in San Jose, CA)

CEO of an educational entity with an annual revenue of $500,000 dollars.

Chairing a weekly meeting to lead a faculty of 40 instructors and support teams in new course development strategies, staff performance reviews, and revenue enhancement marketing plans

Instructing the following courses:

-.NET Technology

-Java2 Enterprise Edition (J2EE)

-SQL Server

-.NET Framework



-.NET Compact Framework


-SQL Server design and implementation



-T-SQL programming



-Oracle Developer Suite



-Oracle (8i, 9i, 10g) design and implementation

-Software Engineering


-PL/SQL programming

-Web Design

-Apache Tomcat

-Oracle Application Server

-Cold Fusion

-Web Logic

-Oracle Portal


-Distributed Systems Design and Implementation

-Hardware Interfacing design and implementation



-Networking systems


2004 - 2006: Aptech Global Training Center (Headquartered in San Jose, CA) - Academic Head

2002-2005: IIDCO Computer Center - Software Trainer

1999-2002: Data Co. LTD - Software Trainer and Developer


2003-2004: Masters in Industrial Engineering/Management, University of Science and Technology

1999-2003: Bachelor in Computer Engineering, Azad University Tehran South Branch


Recent article: IT Alignment, 2016, Published by Maskan Bank Internal Newspaper

Authoring several articles for Computer News Magazine on Java technology and related programming techniques

Lecturing at University of Science & Technology on subjects of Competitive Intelligence and IT Strategic Management


University Professor teaching various IT technologies such as programming, database, database design and architecture, networking, distributed systems, operating systems, programming languages (Java, .Net), Oracle and SQL Server. (Southern Cross University and Sikkim Mani pal University)


Awarded the Best Faculty in the Computer Centers (2006 and 2009) by Aptech Global Training


Data Warehouse Design and Optimization (Training)

Warehouse and Reports using SQL Server (SSIS, SSRS, SSAS) (Training)

Oracle Database Tuning (Training)

SQL SERVER database migration(Training)

Data Warehouse models(Training)

Sun Java Certified Professional (SCJP) by Sun Microsystems

COBIT (Training)

ITIL (Training)

Project Management (PMI) (Training)

.Net programming (Training)

Java Programming professional (Training)

Oracle Design and implementation (Training)


Available upon request

Contact this candidate