Kashif Wasim Email and Phone Number

From the day it was founded, Pareto Systems has been dedicated to providing IT consulting and services that are guided by the Pareto Principle, also known as “The 80/20 Rule.” The Pareto Principle stipulates that 80 percent of the troubles a company faces can be solved by fixing 20 percent of its problems. Our mission is to find that 20 percent for our clients, and then deliver IT products and services that elegantly fix most of the troubles they encounter. Without totally revamping a company, we can drastically cut down the issues it faces and rapidly improve its overall efficiency and performance. That’s the strength of Pareto Systems.

• Designed and developed a data warehousing and SSAS Tabular solution by combing 9 instances of Microsoft Dynamics SL for Project, General ledger, Budget, Commitments and Payroll modules• Designed and developed views, stored procedures and SSIS packages to load data into data warehouse.• Implemented table partitioning and indexing strategy on fact tables. • Designed and developed ETL strategy to load current month fact partition data. • Implemented ColumnStore indexes on fact tables. The largest 52 million row fact table gets summarized in less than a second.• Created SSIS packages to dynamically create staging tables and Switch it with fact table partition.• Implemented incremental data loading in dimensions by comparing source and target tables.• Fixed existing report issues in SSRS• Diagnose and fix issues reported in Development and Production environment.Technical Summary: SQL Server 2012, T-SQL, SSAS (Tabular), SSIS, SSRS

Calpine is one of the nation’s largest and cleanest power producers in America. • Designed and developed BI solutions for ETRM applications (Allegro & Nucleus) and Real time plant monitoring applications.• Mentor and helped developers in their technical challenges.• Provided support and administration for BI solutions for ETRM and real time applications using SSIS, SSAS and SSRS.• Configured and deployed packages in Dev/Test/Productions environments.• Scheduled jobs and validated steps to make sure the load sequence is correct.• Monitor scheduled jobs in early morning and evening sessions. • Diagnose and fix issues reported in Production environment.Technical Summary: SQL Server 2012, SQL Server 2008 R2, SSAS, SSIS, SSRS

Exterran is a leader in natural gas compression products and services and a premier provider of equipment and solutions for processing, production, air emissions and water treatment.• Architect, Designed and developed an end to end BI solution using SSAS, SSIS, SSRS, SQL Server, SharePoint & PerformancePoint• Performed ETL to extract, transform and load data from multiple data sources including Hyperion, Sales Force, AccPac, Perfomix, QHSE and Oracle into multiple data warehouses.• This BI solution provides value to the client by saving time and money as the financial department used to spend 300+ hours each month to prepare these reports.• Developed several multi-dimensional OLAP cubes in SSAS using the data warehouse schema• Implemented parent-child & regular hierarchies for rolling up data. • Developed 550+ MDX calculations for complex financial accounting calculations. Created named sets and Scope statements for complex calculations.• Created a Master SSRS report with more than 200+ sub-reports. The reports are defined for Business Units as well as for Region level.• Configured and deployed SSRS report in SharePoint environment. • Created PerformancePoint dashboard for Sales Force data.Technical Summary: SQL Server 2008 R2, SSAS, SSIS, SSRS, Performance Point Server 2010, Share Point Server 2010

Alta Mesa is a privately held company engaged in onshore oil and natural gas acquisition, exploitation, exploration and production whose focus is to maximize the profitability of our assets in a safe and environmentally sound manner.• Designed and developed a custom BI solution for Alta Mesa using SSRS and SQL Server.• Performed requirements gathering with financial SME’s at Alta Mesa.• Designed and developed a BI report in SSRS for Accounts department to find out error records in GL entries within BOLO financial system. BOLO system was primarily used for Accounting, land and production software within the company.• Performed ETL to extract, transform and load data from BOLO databases (SQL Server)• Configured SSRS report to generate and automatically deliver to finance people on weekly basis. Technical Summary: SQL Server 2008 R2, SSRS

- Designed and developed a new reporting solution using a data warehouse with multiple dimensions and multiple fact tables.- Performed ETL to extract, transform and load data into the data warehouse.- Developed a multi-dimensional OLAP cube in SSAS using the data warehouse schema. - Implemented multi-level hierarchies for rolling up data. - Created a Power Pivot excel file to import data and define Business Intelligence Semantic Model (BISM).- Created a solution in SQL Server Data tools to import model from Power Pivot file.- Deployed the model file to Sharepoint and created a BISM file utilizing the model.- Designed and developed ED Scorecard, ED Comparison dashboard, Top Patient by Diagnosis, ED Monthly Trends and several other reports using SSRS, Power View, Power Pivot and Perfomance Point Server.Technical Summary: SQL Server 2012, SQL Server Data Tools, SSAS, SSIS, SSRS, Power View, Power Pivot, Performance Point Server 2010, Share Point Server 2010

PepsiCo – GHG Air Emissions & Incident Reports PepsiCo, one of the world's largest food and beverage companies, is committed to reduce GHG emissions and health & safety incidents across their global operations. PepsiCo implemented Essential Suite to monitor GHG air emissions, EHS Incidents, Water & Waste etc. PepsiCo took services of Optimized System and Solutions for data Integration and customized reports development.- Worked closely wth Implementation Consultants to explore and understand the functional requirements.- Designed and developed several complex reports including the Emissions Summary, Data Summary, 12 Month Rolling and 13 Period Rolling & Incident Reports.- Performed ETL to move data to the ARS database which is used for report generation.- Used SQL Server 2005 as backend database. Developed complex stored procedures to implement reporting logic and extract dataset for reports.- Develop stored procedures and functions to Roll up Air Emissions data for PTE’s, Actuals and Allowable Emissions.- Implemented dynamic column generation based on user selection in several reports using multiple matrix controls.- Investigated and fixed bugs for Staging, Training and Production environments.- Generated reports in Excel, PDF formats.Technical Summary: BIDS, SQL Server 2005, SSRS, EPASS Essential Suite

Wood Group ESP - Smart Card ProjectWood Group ESP is one of the world’s largest Electric Submursible and Surface Pumping companies. Wood Group design, manufacture and service ESP and SPS equipment and solutions. The purpose of Smart Card solution is to provide periodical analysis of service of testing used pumps and motors as they were pulled from the well. These services include testing of seals, pressure sensors and the computerized testing of cable for Wood Group customers. Wood Group ESP developed the software and designed and developed the testing equipment and the software used to perform these services.- Designed and developed Smart Card reporting solution using SQL Server 2008 SR2, Integration Services and Reporting Services.- Worked closely with SME’s and Integration team to gather data necessary for reports.- Developed several complex stored procedures to pull most recent data to create datasets. - Created a data warehouse in SQL Server 2008 based on the Dimensional Model. - Designed and developed several Well Maintenance reports with multiple charts, graphs and data sets to provide perioical analysis of pumps and equipments installed within the well. - Generated reports in Excel, PDF formats.- Implemented reporting solution in Test, Staging and Production environments.- Investigated and fixed bugs for Staging and Production environments.- Created a detailed technical document for maintenance purpose.Technical Summary: BIDS, SQL Server 2008 SR2, SSRS, SSIS , Dundas Chart for Reporting Services.

EHM (Equipment Health Monitoring)EHM monitors the condition (health) of engineering equipments. The purpose of the monitoring is to detect the early signs of equipment defects or failures with sufficient time to allow remedial action to be taken by maintenance engineers and operational planners. This is achieved by monitoring equipment performance, vibration, or other relevant behavior and analyzing the acquired data for signs of significant change. - Designed and developed a Business Intelligence Architecture Framework to implement OLAP solution for O-SyS suite of products. - Created an Architecture document for the overall BI Framework. - Created Dimensional Model (Star/Snowflake Schema) according to the requiments specifications. - Created a data warehouse based on the Dimensional Model. - Developed SSIS packages to Extract, Transform and Load data from staging database to data warehouse. - Implemented Change Tracking in staging database to keep track of incremental data changes and moved incremental data to data warehouse periodically. - Used Slowly Changing Dimensions (SCD) in SSIS packages to move incremental data in dimension tables. - Created SSIS package to process cubes periodically. - Created a parent SSIS package to call child packages to control the overall ETL process. - Designed and developed Analysis Services cube using the data warehouse. - Designed Measures to Count, Sum and Roll up average on Parameter, Asset and Notification values. - Used attribute relationships to define hierarchies in dimensions. - Used Dundas chart for reporting services to develop complex graphical reports with the ability to drill down for detailed information. - Used Dundas chart for .Net OLAP Services for advanced dynamic charting and data visualization. - Integrated reports and charts with the ‘Business Console’ Sharepoint portal. - Generated reports in Excel, PDF and CSV formats.

Spectra Energy is one of North America's premier natural gas infrastructure companies. Spectra use EPASS – Essential Suite to manage GHG Air Emissions data across United States and Canada. Spectra Energy has a requirement to submit GHG Air Emissions reports to Dow Jones Index on yearly basis. Spectra took services of Optimized Systems & Solutions to develop these complex reports.- Worked wth Implementation Consultants to explore and understand the functional requirements. - Designed and developed several complex reports including the Sustainability and Transmission reports for US and Canada using SQL Server Reporting Services 2005. - Used SQL Server 2005 as backend database. Developed complex stored procedures to implement reporting logic and extract dataset for reports. - Develop stored procedures and functions to rollup air emissions data to update Air Emissions Cache tables. Implemented dynamic column generation based on user selection for Sustainability report. - Investigated and fixed bugs for Test, Staging and Production environments. - Created subscriptions to generate reports based on periodic schedule. - Generated reports in Excel, PDF formats. Technical Summary: BIDS, SQL Server 2005, SSRS, EPASS Essential Suite

The purpose of G-METREX application is to provide a common enterprise solution for storing, reporting and analyzing work process metrics at the 38 Downstream-One refining and chemical plants. These are key drivers in Manufacturing’s overall performance measurement program, impacting safety, reliability, product quality, cost and margin. The application will enhance global business decision-making by giving its users a standardized global view of Downstream Manufacturing’s plant performance measurement activities from a work process perspective.- Designed and developed 40+ graphical and tabular reports for all regions, global regions and RVP regions using SQL Server Reporting Services 2005. - Used SSIS to Extract, Transform and Load data from multiple files and databases. - Used Dundas chart for reporting services to develop complex graphical reports with the ability to drill down for detailed information. - Used SQL Server 2005 as backend database. Developed complex stored procedures to implement reporting logic and extract dataset for reports. - Designed and developed rollup mechanism to rollup data from site to region level. - Developed stored procedures to display only submitted data and making sure restricted data is not visible in reports or dropdowns. Investigated and fixed bugs for Staging and Production environments. - Integrated reports with the front-end G-METREX web application Generated reports in Excel, PDF and CSV formats. Technical Summary: BIDS, VB.Net, ASP.Net, SQL Server 2005, SSRS, SSIS, Dundas Chart for Reporting Services

One Touch Portal (Gulf of Mexico) (BP - Houston / TX)The purpose of developing One Touch Portal is to digitize, optimize and support Exploration and Production operations in Gulf of Mexico region. This portal consisted of multiple communities and projects serving clients in North America and around the globe. The projects I worked on include* Performance Management - Tier II, Tier III, HSSE, Integrity Management* Safety & Operations Integrity - GoM SnOI, Alaska SnOI, Alternative Energy SnOI, SnOINAG* Crisis Management - People TrackerRole & Responsibilities:- Designed and developed several complex scorecard reports using Microsoft Reporting Services and SQL Server 2005. These reports are used to monitor Key Performance Indicators (KPIs) across the business processes found within a Performance Unit. - Designed and developed dynamic SnOI reports with the ability for user to select which report columns to display/hide in the report. User can also select which report column to be used for dynamic grouping.- Designed and developed dynamic reports for People Tracker project with the ability to select dynamic grouping and dynamic summary generation of report based on user selection. - Used Share point lists as a data source in some of the reports. Integrated Performance Management reports with Data Analytics charting tool. - Fixed bugs and issues related to reporting for Test and Production environments - Provided deployment checklist and deployment guide to the configuration manager for deployments to Staging and Production environments. - Designed and developed SnOINAG report on top of Share point lists. - Setup automated report delivery thru emails based on subscriptions and shared schedules - Generated reports in Excel and PDF formats. Technical Summary: BIDS, VB.Net, ASP.Net, SQL Server 2005, SSRS, MOSS 2007, Performance Point Server 2007, Data Analytics, Enesys data provider.

Digital Workflow is a global initiative that aligns process, tool and deployment activities that will identify, develop, integrate and deploy a standard set of end-to-end processes supported by a common tool-set. Digital Workflow processes and toolset have been deployed to 11 production instances in support of 329 clients worldwide, representing 36 percent of the EDS client base. Digital Workflow is currently in production for more than 108 EDS internal and external clients, 14,545,678 client end users, 1700,000 managed assets and 23,041 Digital Workflow users. Digital Workflow generates more than 55,000 printed reports monthly from 300+ report definitions.- Converted 30+ reports from Business Objects and Crystal Reports to SQL Server Reporting Services 2005 - Used SQL Server 2005, Oracle 10g and DB2 as backend database. Developed complex stored procedures to implement reporting logic and extract dataset for reports. - Used SSIS to create work flows to stage and process data for ETL operations. Generated huge data extracts with millions of records in CSV format. - Automated the process of report generation by creating Subscriptions and Shared Schedules. - Investigated and fixed production tickets.- Generated reports in Excel, PDF and CSV formats. Participated in migration and testing of application and reports from 32 bit to 64 bit servers. - Provided 24x7 support for all global instances of Reporting Services servers and SQL Server database servers. - Participated in development of custom tools to capture logs and performance counter statistics. - Developed a Reporting Services troubleshooting guide for support level 1,2,3 and 4. - Provided a detailed list of best practices to developers for performance optimization. - Troubleshoot existing Analysis Services cubes to fix issues related to reports.Technical Summary: BIDS, SQL Server 2005, SSRS, SSIS, SSAS, Oracle 10g, DB2

AESM - Accenture Election System ManagerAESM includes functionality ranging from determining voter eligibility, registering voters, and assigning precincts to producing district registers and election management functions. The AESM system will replace the outdated collection of many county level voter files by creating a centralized, uniform statewide registration of voters. AESM is designed to meet the new federal voting requirements mandated by the Help America Vote Act (HAVA). The AESM project will greatly enhance overall accuracy and integrity of the voter registration process and voter rolls, and the resulting quality of voter services. AESM provides a comprehensive and integrated solution that is highly flexible, allowing a single version of the software at the state level to support large and small counties across the state.- Designed and developed a reporting solution for Wyoming state using SQL Server Reporting Services and Visual Studio.Net - Developed 50+ mid level to complex level mailings and reports using multiple datasets, multiple filters, multiple data regions and multiple sub-reports. These reports were designed and developed in different layouts including letter heads, summary, lists, envelope labels, certificates and duplex reports. - Worked closely with functional team to understand reporting requirements. - Developed complex stored procedures to implement reporting logic to extract data for reports using SQL Server 2000. - Designed and developed 26 Go-Live data validation reports for Wyoming and Colorado state - Generated reports in pdf and excel format. - Investigated and fixed SIRs for DEV, SIT, UAT, Staging and Production environments. - Involved in production code drops for deployment validation tasks. Also helped Colorado and Wisconsin state teams in development and support for their reports. Technical Summary: BIDS, SQL Server 2000, MSRS

CIBOS - Corporate Investment Banking Origination SystemThe Corporate & Investment Banking Origination System (CIBOS) is a sales management tool designed to help origination and execution for bankers to manage their client relationships and provide client, industry and product reporting to bankers and senior management.- Designed and developed Class libraries in Business tier in VB.Net for Customer Support Services (Deal Processing Website). - Developed web interface and code-behind files using ASP.Net and VB.Net for CSS. - Developed stored procedures with transactions in T-SQL using SQL Server 2000 used by business components in ADO .Net - Used Microsoft Reporting Services to develop around 30 mid level and complex level reports using multiple datasets, multiple filters, multiple data regions and multiple sub-reports. - Used Dev. Partner DB Debugger for Sybase and SQL Transmitter in creating and testing stored procedures for reports. - Developed complex stored procedures using 15 to 20 tables to extract data for reports. - Generated reports in pdf and excel formats. - Deployed reports on Dev. Server using Report Manager. - Involved in Users Acceptance Testing. Worked with testers and fixed bugs identified by testers. Technical Summary: Sybase SQL Server, MSRS, ASP.Net, VB.Net

Verizon.com is the largest transactional website in the telecommunication industry. The project was kicked off in January 2001 and launched to the public in October 2001. Since launch Verizon.com has won numerous awards and accolades for its rich content and ease of use. Every month the number of unique visitors and transactions continues to increase. General Business- Development and support for RTI (West) middle tier .Net components (GB_BL and GB_DBO) - Provided Production support and maintenance for 'ForYourBusiness' website. Worked as a developer in Production IR's, bugs and fixes. Represented 'General Business' in weekly bridge calls for Production IR's and VGI's. - Involved in testing of Production IR's on DEV, SIT, UAT, Staging, FTTP25 and Production. - Responsible for Production website's daily health check, issue and logs. - Responsible for investigating and assigning Production issues to different teams including RTI (East & West), SAS, Registration, eCors, eGain, and SSO teams. I also follow up on the issue to make sure it gets fixed. - Worked with DBA's in investigating and fixing of database related issues. - Provided support for existing 'Order Status' application for GB. Consumer- Developed and deployed 'Order Status' CID's 382108.1 and 374223.4 - Participated in client meetings to finalize the top level flow of 'Order Status' application. - Responsible for production code drops and testing of 'Order Status' application. - Worked as a developer to investigate and fix IR's and got certification of 382108.1 and 374223.4 CID’s for April release. Technical Summary: C#, ADO.Net, ASP, VB 6, SQL Server 2000, ADO, IIS, XML, VB Script, Java Script, CSS.

Rexall Sundown makes and sells nutritional products, including herbal supplements, vitamins, diet and weight-management products, and sports nutrition supplements. Rexall Sundown had no e-commerce interface to sell MET-Rx products so they setup a team to develop a website using .Net platform and Commerce Server 2002. - Involved in the full development life cycle of the project and played a key role in all phases. - Analyzed the project and suggested a project plan to finish project in time. - Analyzed and designed Commerce Server 2002 product catalog schema. - Defined products, categories, sub-categories, base catalogs and virtual catalogs. - Defined one base catalog and five virtual catalogs to make the products unique across catalogs and categories. - Pointed out an error in Microsoft’s online documentation for setting up Commerce Server environment and coordinated with Microsoft guys in resolving the bug. - Used out of the box Retail 2002 International Site to display catalogs and modified the layout of web pages using customized controls to change the look and feel of the website. - Developed a scriptor component to implement shipping rates based on zip codes. - Suggested a way to track shipping orders using USPS tools and coordinated with teammates in implementation of order tracking. - Developed a scriptor component to implement customized taxes. Modified the existing server controls and created new controls to fulfill the requirements. - Configured the staging environment with dual configuration for testing the system. - Wrote a step by step installation guide to package and deploy the website. I also mentioned all the possible bugs and errors in deployment of website and explained how to fix those bugs. - Involved in testing of the website. Technical Summary: ASP.Net, C#, VB.Net, ADO.Net, Commerce Server 2002, SQL Server 2000

TPCCS – The Psychological Corporation Commerce Server Catalog SystemThe Psychological Corporation (TPC), one of the nation’s largest commercial test publishers, requested assistance of Harcourt IT for the development, maintenance and to manage hosting of the Company’s website. TPC wanted to replace its e-commerce application called Transact, originally developed and supported by OpenMarket, with Commerce Server 2002 catalog system. Transact was no longer a supported application which was the main driver for it being replaced. - Analyzed and designed Commerce Server 2002 product catalog schema. - .Net was used in presentation layer to take advantage of language support, a large set of new controls, XML based components, and better user authentication. - Wrote a utility in Visual Basic to parse 900+ catalog pages and store the products and variants data in an Access database. Identified and removed all the duplicate products and product variants in Access database. - Wrote a utility in Visual Basic, using Commerce Server 2002 API’s, to write the products and product variants from Access database to the Commerce Server catalogs. - To make the products unique across catalogs and categories, I defined one base catalog and four virtual catalogs. - Used out of the box Retail 2002 International Site to display catalogs and modified the layout of web pages using customized controls to change the look and feel of the website. - Imported existing users along with their address and credit card information to the Commerce Server site. - Designed and developed CSR (Customer Service Rep. Access) module, using VB.Net, ASP.Net and SQL Server 2000, for administration purpose. - To calculate taxes and verify addresses we used a third party tool called ‘Tax Ware’.- Involved in testing and implementation of the system. Technical Summary: ASP.Net, C#, VB.Net, ADO.Net, Commerce Server 2002, SQL Server 2000, Tax Ware

Designed and developed conventional client server applications as well as web-enabled applications for local and USA based clients. Technical Summary: ASP, Visual Basic 6, SQL Server 2000/7, Crystal Reports, Dream Weaver, Java script, VB Script, IIS, COM/DCOM, ADO, Exchange Server, RUP 5.5, Rational Rose 2000, MS Project 2000, MS Access, DAO and VSS.

Designed and developed Integrated Information for Burshane. It was a financial application consists of different modules including Fixed Assets, Human Resource, Pay Roll, Purchase Management and General Ledger. Technical Summary: Visual Basic 5.0, Sql Server 6.5, Crystal Reports 4.5, and DAO