Resume

Sign in

BI, DW, ETL, Data modeling (SAP+Microsoft stack)

Location:
Plano, Texas, United States
Posted:
August 28, 2018

Contact this candidate

Resume:

IFTHEKAR MUHAMMED Phone: 214-***-****

Residency Status: US Citizen - Plano TX Email: ac6uie@r.postjobfree.com

Summary:

Seasoned BI & Data Architect with very strong experience in SQL Development and Data Architecture with over 15 years of experience in Data warehousing, Business Intelligence, Reporting and hands on experience in data modeling, data access, data quality, data integration, data analytics, data visualization & reporting

20 plus years of IT experience in the fields of Clinical Operations, Oil & Gas, Quality Management, Manufacturing, Finance and Educational systems.

Team Management: Lead, managed, supervised and mentored in-house and offshore BI/reporting team and acted as liaison between Business and Technology teams.

Technical Skills:

Business Intelligence: SAP Business Objects 4.X, Tableau 10, PowerBI

Databases: MS-SQL Server 2000/2005/2008/2012/2016, ORACLE 6/7/9, Gupta SQL Base 6.12, PostgreSQL 9.6.2

Reporting: SAP Crystal Reports 8.5/2011/2013, Gupta Report Windows, SSRS

ETL: Microsoft SSIS (SQL Server Integration Services)

SQL Development: T-SQL and SQL Plus

Data Modeling: ERWin, ER Studio,Visio

Development Methodologies: Waterfall, Agile

Cloud Environment: Dimensions

Other Tools/Applications: MS Office, Jira, GIT & Tortoise (Version control), Gupta SQL Windows, Oracle Forms 4.5

Education:

August 1995: MS from Osmania University (Dept. of Computer Science & Engineering), India (First Class with Distinction)

August1992: BS from Nagarjuna University, India (First Class)

Certification:

Certified Scaled Agile Framework Enterprise (SAFe) 4 Agilist

Work Experience:

Employer: Sogeti US (Subsidiary of Capgemini Group)

Duration: February 2018 – Till Date

Position: Manager Consultant- SQL Development, Business Intelligence & Data Warehouse

Responsibilities: Data warehouse/Data Modeling/ ETL /SQL Development

Clients: Cottonwood Financials, Irving, TX

Technologies: MS SQL Server 2008 & 2016, MS - SSIS, T-SQL, ER Studio, Agile Methodology

DW Architecture, Data Analysis, Data Modeling and Data Visualizations

Reverse engineer existing Serenity Data warehouse using ER studio and generate Data Models

Go through the code and ETLs and recreate Data mappings between source (OLTP) databases and data warehouse and document data flow.

Enhance data warehouse model to implement new changes

Redesign ETL packages and tune SQLs used in ETL queries

Loan Engine Migration and Risk data mart analysis

Employer: SchoolSpire (SchoolSpire acquired PCG Education Plano division in 2016), Plano TX

Duration: October 2016 – January 2018

Position: Senior Business Intelligence & DW Architect

Responsibilities: Data warehouse Development/Data Modeling/ ETL Development /SQL Development/ Reports Development/Support

Clients: Various School Districts across USA

Technologies: MS SQL Server 2012/2014, MS - SSIS, T-SQL, SAP Business Objects 4.X, Crystal Reports 2013, Power BI, GIT, Jira

DW Architecture, Data Analysis, Data Modeling and Data Visualizations

Conducted requirement gathering sessions and data analysis based on client's functional requirements

Developed and maintained enterprise data warehouse (OLAP) to support corporate reporting system called Empower Analytics based on Client’s business requirements

Developed ETL processes using MS - SSIS to move data from OLTP systems to reporting data structures including data validation, cleansing and mapping.

Created Teacher Level Analysis dashboards (Visualizations) using BO WEBI and Power BI

Developed and maintained end-user interfaces to access reporting data structures

DW, Reporting and Data Visualizations from live Relational Transactional System

OneTouch Analytical Reports out of transactional RDBMS database: Designed and developed data warehouse data model and oversaw all aspects development including Metadata, Reports and Dashboards

Used BO WEBI and Power BI to design and develop OneTouch Teacher Analytical Dashboards.

Traditional Reporting

Create and manage existing canned Educator Analysis reports developed using Crystal Reports 2013

SQL Development & Optimization

Developed and tuned stored procedures, functions, queries in Reports for optimal performance

Define and maintain tables, views, indexes needed to execute logic and coordinate their creation and deployment with the DBA.

Created and scheduled jobs to automate administrative tasks performed against a SQL Server database

Employer: PCG Education, Plano TX

Duration: February 2002 – September 2016

Position(s): Held various positions as Sr. Software Engineer, Sr. BI Analyst, Sr. BI Manager, Associate IT Officer (Latest Position)

Responsibilities: Data warehouse Development/Data Modeling/ ETL Development /SQL Development/ Reports Development/Team Management & Delivery/Client Support

Clients: Various School Districts across USA

Technologies: MS SQL Server 2008/2012/2014, MS - SSIS, T-SQL, SAP Business Objects 4.X, Crystal Reports 8.5/2011/2013, MS SSIS, Tableau 10 Desktop, GIT, Jira, ERWin, Dimensions (Cloud)

Data warehouse and Architecture

As one of the architects of IMS enterprise Data warehouse (OLAP), worked on this project from inception. Conceived, designed, developed and implemented the data warehouse solution from scratch based on Client’s business requirements.

Analyzed user requirements, translated logical design into physical model and developed enterprise data warehouse (using Star/Snowflake schema). Also developed metadata structures to support corporate reporting initiatives.

Designed and developed ETL processes using MS - SSIS to move data from OLTP systems and external sources like flat data files from EdPlan team into to data warehouse data structures including data validation, cleansing and mapping.

Conducted data analysis and data quality checks to verify and enforce client's functional and data requirements after the ETL

Created a process to download EdPlan data files from FTP and load it into DW data structures

Created Data warehouse Universe using BO Universe Design Tool (UDT)

Developed end-user interfaces to access report data structures

Data Visualization

Designed and developed EdPlan Dashboards using BO WEBI

Created State Assessment reports and dashboards using Tableau Desktop 10

Data Integrity and ETL

Created ETL using MS-SSIS to load State and National data into IMS Relational database

BISE Project: Created ETL process to load Student enrollment, test centers, Subject Areas data files

Manage and maintain the integrity and reliability of our data and databases

Reporting

Designed and created more than 500 reports using SAP Crystal Reports and SQL Server, from gathering requirements from Clients, report UI design, creation of stored procedure to retrieve data, deployment and maintenance of reports.

BISE Reporting System: Designed, developed and implemented Assessment Analysis reports for over 9 million student state assessments (9, 10,11, 12 graders) conducted by Punjab Board of Intermediate and Secondary Education on a tight schedule and guided team for the timely delivery

Created Statistical Analysis reports for Educators to determine Assessment and Item effectiveness

SQL Development (SQL Server, T-SQL)

Defined and maintained tables, views, indexes needed to execute logic and coordinate their creation and deployment with the DBA.

Created and scheduled jobs to automate administrative tasks performed against a SQL Server database

Collaborated with data operations group to ensure database logic complies with business requirements

Extensively involved in Stored Procedure creation, debugging, optimization and tuning

Optimized SQL Statements in Java COM objects used in filters

Created Stored procedures to import STAAR data into IMS relational database

Worked closely with other development team members on issues related to data and functionality

Created and maintained EWS Measure data for HTML based EWS Drill-Down dashboards

Conducted Data Quality checks for the data loaded through web application and addressed data quality issues/gaps with development team

Team Management

Managed, supervised and mentored in-house and offshore BI/reporting team and coordinated with other teams and managers on deadlines and deliverables.

Conducted Functional Requirement and Design meetings with the team

Worked closely with Clients and Client Representatives on Report and Data requirements and Support

Direct interaction with some of the clients like Plano ISD, Grand Prairie ISD, Irving ISD and BISD

Employer: Infotech Software Corp, Dallas, TX

Duration: October 1998 – January 2002

Position: Sr. Software Engineer

Client: ENSCO International (USA, UK, SINGAPORE, VENEZUELA), one of the world’s largest offshore drilling companies with operations spanning six continents.

Domain: Oil & Gas, Material Management Planning and Finance

Technologies: Centura/Gupta Team Builder 1.1.1, Report Windows and SQL Base 6.12

Involved in the design, application development, and unit testing of customized Material Management system for ENSCO

Financial & Accounting info migration during rig move from one cost center to other

Onsite implementation of ENCO System at various ENSCO offices, Broussard–USA, Aberdeen-UK, Ojeda-VENEZUELA and Singapore-SINGAPORE

Developed ETL to migrate ENSCO Requisition data into PeopleSoft’s procurement data model.

Client: Atlas Match LLC, Euless, TX

Domain: Retail & Finance

Technologies: Centura/Gupta Team Builder 1.1.1, Report Windows and SQL Base 6.12

Involved in application enhancements, implementation and maintenance of Atlas Tracking System (Billing System) using Centura/Gupta Software Technologies

Client: Grey Stone Communities, Las Colinas, TX

Domain: Hospitality & Finance

Technologies: Centura/Gupta Team Builder 1.1.1, Report Windows and SQL Base 6.12

Involved in application enhancements, implementation and maintenance of PrismGold application used by various senior home communities for Resident Activities, Billing, Cash Receipts, Banking, Unit Maintenance, Resident Maintenance and Reporting

Client: Birdville ISD, Birdville, TX

Domain: Education

QA Tester: Unit Testing, verifying and validating data against IMS web based educational application functional requirements

Bug tracking using RT

Employer: Intelligent Systems International Gaithersburg, MD

Duration: November 1997 – September 1998

Position: Software Engineer

Client: Merck & Co, Blue Bell, PA.

Domain: Health Care & Clinical Research

Technologies: Gupta SQL Windows 5.02, Crystal Reports, Oracle 9

Involved in application/reporting enhancements, implementation and maintenance of ProjMan System used by Clinical Inspectors during to enter findings during their visit to investigation sites.

Employer: IndoSoft Software Inc. Hyderabad, India

Duration: September 1995 – October 1997

Position: Software Engineer

Client: IQS Inc, OH

Domain: Enterprise Quality Management

Technologies: Gupta SQL Windows 5.02, Oracle Forms 4.5, Report Windows, Crystal Reports, Oracle 7.1/SQL Server 6.5

Involved in the design, development, and unit testing of IQS modules namely Sysdoc, Product, Process, Employee Involve, Customer and Collect

Client: Lilly Software Associates, OH (Acquired by Infor Global Solutions, Inc in 2004)

Domain: ERP

Technologies: MS SQL Server 6, Gupta SQL Base 5

Product: Visual Manufacturing & Financials

Involved in the database back-end conversion from SQL Base 5.0 to MS SQL Server 6.

Reference: References furnished upon request



Contact this candidate