Client list in alphabetical order Client: Amazon Position: BI/Data Engineer ConsultantTechnologies: AWS Redshift, AWS QuickSight, Tableau Client: California State UniversityPosition: Senior AWS QuickSight and Arora PostgreSQL ConsultantTechnologies: AWS QuickSight, PostgreSQL on AWS RDSClient: Sogeti/Capgemini Position: Data Architect/Lead Consultant --End Client: Alterra Mountain, Colorado--Technologies: Azure SQL Server, Power BI, T-SQL--End Client: NationalGrid - USA--Technologies: Snowflake, Matillion, Liquibase, DevOpsClient: WM Position: Snowflake Data Architect ConsultantTechnologies: Snowflake, Matillion, SQLDBM, Arora PostgreSQL, S3, AWS

Responsibilities: Data warehouse/BI/ ETL /SQL DevelopmentClient: Solomon Associates, Dallas, TXDomain: Oil & Gas Technologies:, SQL Server on AWS RDS, S3, AWS GLUE, AWS Data Migration Services, AWS QuickSight, SSIS

Responsibilities: Data warehouse/Data Modeling/ ETL /SQL DevelopmentDomain: Commercial Real Estate and InvestmentTechnologies:, ER Win, Jira, PostgreSQL, Jenkins, Mesos, JSON, AWS, EC2, S3, ELK, Kibana, Agile MethodologyDW Architecture, Data Analysis, Data Modeling, ETL • Interpret and analyze data from various source systems like OLTP and Cloud based systems like Salesforce to support data integration and data reporting needs within CBRE• Work with team leads to prioritize business and information needs• Prepare high-level ETL mapping specifications• Develop complex code data scripts (using PostgreSQL) for ETL to migrate data form Staging to Unified & Unified to Data mart• Manage exploratory data analysis to support database and dashboard development, as well as advanced analytics efforts• Use DevOp tools for CI/CD

Client: Cottonwood FinancialResponsibilities: Data warehouse/BI/Data Modeling/ ETL /SQL DevelopmentTechnologies: MS SQL Server 2016, MS - SSIS, T-SQL, MySQL, ER Studio, TFSDW 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• Migration of Loan engine & Analysis of Risk data mart

Technologies: MS SQL Server 2012/2014, MS - SSIS, T-SQL, SAP Business Objects 4.X, Crystal Reports 2013, Power BI, GIT, JiraDW 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 structuresDW, 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 2013SQL 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

Position(s): Held various positions as BI Manager, Sr. BI Manager, Associate IT OfficerTechnologies: 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, Perl, GIT, Jira, ERWin, Dimension Data(Cloud)Clients: Various School Districts across USAData 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 structuresData Visualization & Reporting• Designed and developed EdPlan Dashboards using BO WEBI• Created State Assessment reports and dashboards using Tableau Desktop 10• Migrated IMS reports Crystal Reports from 8.5 to Crystal Reports 2011• Migrated BISE reports from Crystal Reports from 8.5 to Crystal Reports 2013Team Management• Managed and supervised in-house and offshore BI/reporting team and coordinated with other teams and managers on deadlines and deliverables. • Worked closely with Clients and Client Representatives on Report and Data requirements and Support

Position(s): Held various positions as Sr. Software Engineer, Sr. BI Analyst & BI ManagerTechnologies: MS SQL Server 2008, Perl, MS - SSIS, T-SQL, Crystal Reports 8.5, MS SSIS, Jira, ERWinResponsibilities: ETL Development /SQL Development/ Reports Development/Team Management & Delivery/Client SupportClients: Various School Districts across USASQL 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• Extensively involved in Stored Procedure creation, optimization and tuning• Created ETL to import STAAR data into IMS• 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 the development team • Created Perl scripts to access data from SQL server through ODBCReporting Solution• Designed and created more than 500 reports using SAP Crystal Reports and SQL Server, from gathering requirements, report UI design, stored procedure creation, deployment and maintenance of reports.• BISE Reporting: 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 effectivenessTeam 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

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 FinanceTechnologies: 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 data 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• Created ETL process to migrate ENSCO Requisition data into PeopleSoft’s procurement data model.Client: Atlas Match LLC, Euless, TXDomain: Retail & FinanceTechnologies: Centura/Gupta Team Builder 1.1.1, Report Windows and SQL Base 6.12• Application enhancements, implementation and maintenance of Atlas Tracking System (Billing System) using Centura/Gupta Software TechnologiesClient: Grey Stone Communities, Las Colinas, TXDomain: Hospitality & FinanceTechnologies: Centura/Gupta Team Builder 1.1.1, Report Windows and SQL Base 6.12• 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: Merck & Co, Blue Bell, PA.Domain: Health Care & Clinical ResearchTechnologies: Gupta SQL Windows 5.02, Crystal Reports, Oracle 9• Daily reconciliation of pharmaceutical industry data sets• Created a sophisticated Inventory analysis ProjMan System Application for Clinical Inspectors• Researched and resolved data issues related to existing data and processes in place before my tenure