SUMMARY:

• Ten plus years (10+) of IT experience which includes Data Analysis and Design, and Architecture.
• Development & Support of MS SQL Server & Oracle in Production and Development Environments.
• Experience in installation and configuration of Microsoft Dynamics CRM.
• Expertise in Supply Chain & Logistics
• Extensive experience in writing Complex Stored procedures as well as analyzing and debugging existing complex stored procedures.
• Extensive experience on SQL Server Integration Services in the areas of Master/Child Packages, SSIS Transforms etc.
• Extensive experience in performing Source System Analysis, designing the Staging DB, defining ETL Strategies, creating ETL Packages and populating ROLAP and MOLAP Warehouses.
• Extensive experience in Agile/Scrum software development, Test Driven Development, Continuous Integration
• Skilled in SQL Server administration of a multi - database environment in a 24x7 environment.
• Hands on experience with SQL Server and T-SQL in constructing procedures, user-defined functions, triggers, relational database models and maintaining data integrity.
• Excellent experience in creating and modeling tables, views and indexes.
• Expertise in Data Modeling, Data Warehouse Design & Implementation
• Involved in creating Dashboards via Microsoft Excel & SSRS
• Interacting with all levels of the team members mainly the developers and guide or made things to meet the deadlines.
• Highly intuitive, hardworking, motivated and easily adaptable to challenging environments.
• Experience in creating Reports using SQL 2005, 2008, 2012 Server Reporting Services
• Excellent aptitude, soft spoken and have good oral, written and pleasing interpersonal skills.

TECHNICAL SKILLS:

Languages: PHP, JavaScript, HTML, CSS, XML, XHTML, DHTML, VB.NET, ASP.NET, C#, Safari

Database: Microsoft SQL Server, MS Access, Oracle, MS Excel

Designing Tools: ER-Win, SAP, Dynamics CRM, MS Project

Platforms: Windows XP / NT / /2008

Database Tools: SQL Server, T-SQL, OLAP, OLTP, Query Analyzer, Reporting Service (SSRS), Analysis Services (SSAS), SAP Data Integrator, SQL Server Integration Services (SSIS), SQL 2000 DTS, Cognos, Informatica, Pentaho, Power BI, Python

PROFESSIONAL EXPERIENCE:

Confidential

Director of Business Intelligence

Responsibilities:

• Coordinate, review, implement, test, support, improve requirements presented by stakeholders, and manage stakeholder expectations, and proactively communicate between all stakeholders to ensure all parties are aligned and all issues and conflicts are resolved leveraging openness and honesty;
• Lone contributor in leveraging Pentaho Enterprise Edition (PDD/PAZ/PIR/PDI) to create collections of content components - namely Dashboards and Reports.
• Deliver high quality code with minimal defects/rework, execute and participate in the testing process, including: unit, integration, regression, and performance with a focus on minimizing defects and rework;
• Understand and participate in the production and non-production deployment process;
• Provide application, database, and console support for production and non-production issues;
• Create, configure, maintain, and monitor the different application environments; n process: gain an understanding of the different company and client processes, producing documentation.

Environment: Oracle 12c /Pentaho 8 /Java/Python

Confidential, San Diego, CA

Sr. Data Analyst

Responsibilities:

• Coordinating sprints in MS Project in Agile environment
• Conducting SCRUM meetings
• Converting customer data from legacy systems to Oracle databases using SQL scripts, Oracle Packages and Excel spreadsheets (supported by Visual Basic macros)
• Document the conversion processes
• Salesforce implementation according to business requirements.
• Ensuring data accuracy and integrity within LIMS.
• Escalate issues to the implementation consultants in a timely manner to allow for rapid resolution
• Provide accurate and appropriate feedback in a timely manner
• Data migration process from analysis of existing data, cleansing, validation, translation tables, conversions and subsequent upload into the new platform
• Created data conversion processes for bases throughout the Kingdom of Saudi Arabia, Kuwait and Oman to implement GOLDesp into Royal Saudi Air Force (RSAF), Kuwait Ministry of Defense (KMOD) and Royal Air Force of Oman (RAFO).
• Travel to various cities for data gathering, data reviews for Supply & Maintenance.
• Performed soft Go-Live and Go-Live activities for bases in coordination with EMDAD.

Environment: Windows 2003, ER-Win 7.1, SQL Server 2008, 2005, Database Engine / Integration Services / BI Development Studio / MS Dynamics CRM 2011/NoSQL/ Oracle 11g /Crystal Reports 2008/ Cognos 8 / Microsoft Dynamics AX/ MS Excel/Safari/Pentaho/Java/Agile/Salesforce Administration/SCRUM

Confidential, San Diego, CA

Sr. ETL Architect

Responsibilities:

• Revamp and add functionality to existing and create new SSIS packages.
• Oracle/SQL Server Development.

Environment: Windows 2003, ER-Win 7.1, SQL Server 2008, 2005, Database Engine / Integration Services / BI Development Studio /Oracle

Confidential, Carlsbad, CA

IT Project Manager & Data Architect

Responsibilities:

• Travel to client sites to gather business requirements
• Conduct kick-off meetings.
• Ensures project documents are complete, current, and appropriate.
• Develop custom ETL packages to clients’ specifications.
• Lead and participated in SCRUM sessions.
• Performing business process analysis for clients, reviewing and optimizing business processes and providing process re-engineering services where appropriate. Developing custom documentation.
• Implementing project configurations using VB.NET, MS SQL, MS Access, and Crystal Reports.
• Assisting with client-facing support in all phases of the SDLC: planning, requirements gathering, development of hybrid system, project implementation, and post-implementation maintenance
• Reviews deliverables prepared by team before passing off to client
• Prepares for project milestone reviews with quality assurance of procedures
• Resolves and/or escalates issues in a timely fashion
• Possesses a thorough knowledge of our software and a thorough understanding for configuring the system during each project
• Identify clients’ active needs, produce design requirements, and directly translate the key deliverables into SSRS, SSIS, and Crystal Reports.
• Install and configure Microsoft Dynamics CRM 2011
• Setup business units, security roles, add users, and create teams, and reporting in CRM 2011
• Ensures on-time delivery of completed system
• Capable of assisting with several projects at one time
• Identifies risks throughout the project and determines appropriate mitigation of any foreseen issues
• Addresses client issues immediately

Environment: Windows 2003, ER-Win 7.1, SQL Server 2008, 2005, Database Engine / Integration Services / BI Development Studio / MS Dynamics CRM 2011/ Oracle /Crystal Reports 2008/ MS Excel/ MS Access /Cognos/Informatica

Confidential, San Diego, CA

Database Architect & Configuration Analyst

Responsibilities:

• Maintain test environment hardware, software, and documentation baseline control.
• Maintain SQL Server Databases in multiple versions.
• Establish initial baselines and control multiple versions of multiple releases.
• Develop web applications, web services in .NET framework.
• Work with procurement specialists, project manager, and product specialists to confirm hardware and software versions.
• Created reusable data maps, workflows in Microsoft Dynamics CRM 4.0
• Adding new users to Dynamics CRM.
• Defines CM standards and develops CM quality metrics to ensure CM process quality.
• Resolves database performance issues, capacity issues, replication, and other distributed data issues.
• Develops, establishes and enforces CM standards and metric measures for the organization
• Actively involved with software configuration and deployment for US Department of Defense (Healthcare and Family Programs).
• Monitor and identify performance problems and quickly address bottlenecks. (Performance Tuning)
• Involved in all the stages of the software development cycle (SDLC)
• Motivate and lead project teams to ensure that all systems are developed on time, within budget, and beyond client expectations.
• Interface with key technical and business owners to design reporting and analytical applications that leverage the data warehouse.
• Identify clients’ active needs, produce design requirements, and directly translate the key deliverables into SSRS, SSIS.
• Develop the project concept and plan, facilitating project meetings, adherence to quality standards and budget; manage internal and external resources, review of project deliverables, change control, and status reporting.
• Provide single point-of-contact support for all parties—clients, management, and project staff—throughout the entire project life-cycle.

Environment: Windows 2003, ER-Win 7.1, SQL Server 2008, 2005, 2000 Database Engine / Integration Services / Analysis Services / Reporting Services / BI Development Studio / MS Dynamics CRM 4.0/ Server Agent/Team Foundation Server/Visual SourceSafe, .NET Framework /MS Excel/ MS Access/Informatica/SAP

Confidential, Whitehouse Station, NJ

ETL Developer Consultant (Business Intelligence)

Responsibilities:

• Gathered business requirements, and analyzed business needs to prepare Functional Specifications.
• Led meetings with End-users and Developers from cross-functional teams; prepared project status reports.
• Responsible for Data Modeling of SQL 2005 Staging Database.
• Created Logical and Physical models for Staging Database using Erwin 7.1.
• Designed a Star Schema with supporting documentation
• Worked with DBA to build Dimension and Fact Tables.
• Monitor and identify performance problems and quickly address bottlenecks. (Performance Tuning)
• Create complex stored procedures; UDF’s to be used in ETL packages and reports.
• Developed complex ETL Packages using SQL Server 2005 Integration Services to load data from various sources like flat files/Oracle/SQL Server to Staging Database and then to Customer Data Warehouse. The packages included various transformations like Slowly Changing Dimensions (Type 1 & 2), Look up, Derived Column, Aggregate, Fuzzy Lookup, Multicast, Conditional Split, Data Conversion etc.
• Tested Packages and fixed bugs using SQL 2005 Business Intelligence Development Studio.
• Arranged ETL Packages into Master/Child Packages and defined the workflow for loading data from Source DBs to Staging DBs utilizing simultaneous pipeline loading procedure.
• Scheduled and executed SSIS Packages, using SQL Server Agent.
• Optimized SQL queries for better performance by indexing and UN indexing tables.
• Created and maintained ETL technical documentation.
• Created MOLAP Data Warehouse on SQL Server 2005 Analysis Services.
• Created Cubes and populated them with Dimensions and Facts from the Staging Database.
• Created reports from ROLAP as well as MOLAP using MDX queries as well pulling reports from OLTP.

Environment: Windows 2003, ER-Win 7.1, SQL Server 2005 Database Engine, Integration Services, Analysis Services, Reporting Services, BI Development Studio, Server Agent, SAP, Replication Services, .NET Framework/ MS Excel/ MS Access

Confidential, Miami, FL

SQL/ETL Developer Consultant

Responsibilities:

• Worked with business analysts to identify appropriate sources for Data warehouse and to document business needs for decision support data.
• Created and optimized indexed view to be accessed by front end applications for better performance
• Designed the ETL processes using SQL Server 2000 DTS to load data from Oracle, SQL Server, Flat Files and Excel files to target SQL 2000 Data Warehouse database.
• Created, modified and redesigned OLTP and OLAP Data Models Using Erwin.
• Involved in the design of Data model (Star-Schema structure), created design documents.
• Created Dimension and Fact Tables for the Staging Database following the Kimball school of design.
• Wrote complex SQL Scripts to Create and Drop Indexes before and after an ETL process.
• Performed data transformations using complex stored procedures and queries and embedded them into DTS Packages.
• Monitor and identify performance problems and quickly address bottlenecks
• Wrote ad hoc queries that would be used for reporting or auditing.
• Participate in the establishment of business performance metrics and measures to support key business objectives.
• Enforce the change control for the data architecture.
• Manage the data quality/metadata environments.
• Lead the development and implementation of data warehouses, data marts, and data stores including the ETL used to populate those databases.
• Lead the development and implementation of normalized and dimensional data models (logical and physical) to support reporting and analytics.
• Used SQL Server Agent to schedule jobs, maintenance tasks, and BCP and ETL packages.
• Used Job Monitor to monitor the execution of the Jobs as well as notification services to alert the team on success, completion and failure of a job.
• Maintained existing SSIS Packages and worked on the performance turning of the queries, ETL procedures and processes.
• Migrated packages from testing to production environment.

Environment: ER-Win, SQL Server 2000, ORACLE 8i, Windows NT 2000, SQL Server 2000 DTS, Query Analyzer, Enterprise Manager, Replication Services, and DTS Designer, .NET Framework

Confidential, Salt Lake City, Utah

SQL Report Developer Consultant

Responsibilities:

• Responsible for creating mapping and transformation specifications based on business requirements.
• Performed Source System Analysis to arrive at the design for the Staging Databases and the ROLAP Warehouse.
• Involved in the design of Data model (Star-Schema structure) using Erwin, created design documents.
• Created the Staging and ROLAP Databases and their corresponding objects like tables, constraints, stored procedures and triggers.
• Monitor and identify performance problems and quickly address bottlenecks. (Performance Tuning)
• Wrote very complex stored procedures to perform transformation of data between source and staging databases.
• SQL Server Replication Services to replicate and synchronize database objects
• Wrote scripts for dropping and creating referential Integrity constraints to decrease load time.
• Created DTS Packages to load the ROLAP Warehouse from the Staging Databases.
• Created documentation of complete ETL Process and Data Dictionary of Staging Database and ROLAP Warehouse.

Environment: Environment: ER-Win, SQL Server 2000, ORACLE8i, Sybase, Windows 2000, SQL Server 2000 DTS, Query Analyzer, Enterprise Manager, and DTS Designer, .NET Framework