| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateIFTHEKAR MUHAMMED Phone: PHONE NUMBER AVAILABLE
Residency Status: US Citizen - Plano TX Email: EMAIL AVAILABLE
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.
Technical Skills:
Business Intelligence: SAP Business Objects 4.X, Tableau 10, PowerBI
Databases: MS-SQL Server 2000/2005/2008/2012/2104, 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, Visio
Scripting Languages: R (Basics), Python (Basics)
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)
Work Experience:
Employer: SchoolSpire (SchoolSpire acquired PCG Education Plano division in 2016), Plano TX
Duration: October 2016 Present
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 create 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, PowerBI, 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
Created Teacher Level Analysis Reports/Dashboards using Power BI
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 on 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 and supervised 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 & Accounting
Technologies: Centura/Gupta Team Builder 1.1.1, Report Windows and SQL Base 6.12
Involved in the design, development, and unit testing of customized Material Management system for ENSCO
Successfully implemented 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 & Accounting
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 & Accounting
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, 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: Manufacturing
Technologies: MS SQL Server 6, Gupta SQL Base 5
Product: Visual Manufacturing application helps manufacturing industry to automate activities like estimating, ordering, resource planning, scheduling etc.
Involved in the database back-end conversion from SQL Base 5.0 to MS SQL Server 6.
Reference: References furnished upon request |
