PROFESSIONAL SUMMARY:

• 13+ years of solid working experience in IT industry.
• Experience as a hands - on Solutions Architect/ Team Lead/ Specialist/ Developer in Big Data, Business Intelligence (BI), Data Warehousing, and multi-tiered applications in Java, and Scala.
• Delivered projects for enterprises such as Confidential, the Ministry of, the Confidential, Confidential, General Motors, as well as startups.
• Expert in Big Data: HDFS, Hive, Spark, Scala, Java, Python, Hadoop, Sqoop, Map/Reduce, Hortonworks, Cloudera, MapR, HBase, Cassandra, Kafka, Storm, Spark Streaming, Zeppelin, Kibana, Spark MLib, Mahout, R, NiFi, Falcon, Oozie, Kylin, Atlas, Drill, Solr, ElasticSearch, Ambari, Ranger, Flume, Impala, Pig, HDInsight, SBT, DevOps, Jenkins, Ansible, Git, Maven, Cloudera Navigator, Data Lineage.
• Expert using Azure Cloud (PaaS and IaaS), Azure Data Lake Store, Azure Data Lake Analytics, HDInsight (Managed Hadoop), Machine Learning Studio, Azure Data Factory, Azure Data Warehouse, Azure Analysis Services, Power BI, and Azure Data Catalog.
• A full stack solutions architect at enterprise scale. Proficient in end-to-end design spectrum: developing business value justification and strategy, selecting and managing a technology vendor, designing a solution blueprint, envisioning the roadmap, team building, implementation, solution sustainment and DevOps.
• Designed solutions utilizing advanced analytics, artificial intelligence and cognitive services. The solutions include prescriptive (recommendation) and predictive analytics, sentiment analysis, text analytics, vision/image processing, and speech recognition, classification, pattern recognition, and regression.
• Defined the data governance strategy, designed cyber security patterns, implemented data standards and procedures across the enterprise; drafted business specific methodology to establish business stakeholder-driven data stewardship through MDM
• Led EDW projects on Massively Parallel Processing (MPP) Data Warehouse/ Data Lake Appliances such as IBM Netezza, Teradata, APS (PDW), Oracle Exadata, Customer MDM, Product MDM, DQ Framework.
• Expert in Enterprise Information Management (EIM) for retail operation. Designed various BI solutions including loyalty programs, card management, POS data management, customer behavioral analysis, store dashboards, finance, ecommerce, and cyber security analytics.
• Migrated 10s of applications and solutions to the Cloud.
• Extensively working on SQL Server 7 to 2016, Oracle, SQL, T-SQL, SSIS, SSRS, SSAS, OLTP, OLAP, Multidimensional Cube, MDX, PowerPivot, Tabular Model, SharePoint, PerformancePoint.
• Demonstrated experience and understanding of the best practices in all aspects of data warehousing (Inmon/Kimball approach). Solid experience in Data Warehouse Development Lifecycle (SDLC) including system analysis, design, implementation, testing, deployment, and maintenance.
• Strong knowledge and proven results in Data Warehouse, Data Mart, and Data Lake design including Dimensional Modeling (Star & Snowflake Schemas), ER Modeling, 3 Normal Forms, Normalization and Demoralization, Logical Model and Physical Model, Fact/Dimension/Hierarchy identifications.
• From Business Case to Data Visualization, I have designed and developed solutions by combining Business Process with Information Technology.
• Years of design and hands on experience in application development using .NET and Service Oriented Architecture (SOA)
• Authored numerous best practices, technical reports, processes & workflows, and methodology documents to standardize implementation, support infrastructure and sustainment teams, and to promote knowledge sharing. Coached and trained development teams in utilizing the BI framework.

TECHNICAL SKILLS:

BI Framework: Strategy and Implementation Plans, Enterprise Metrics, Integration Points, Gap Analysis, BI Portfolio, Performance Management (PM), Analytic and PM Technologies, Defining Business and Decision Process, Building Metadata and Services Centers, Establishing Enterprise Information Management (EIM) Committees, Defining the Role of DW and BI Program Steering Committee, It's Mission, Objectives, Roles and Responsibilities, DAMA DMBOK

Architecture and Data Modeling: Initial Conceptual Solution, Solution Blueprints, Technology Impact Analysis (TIA), Gap Analysis, Technology Roadmap, Dimensional modelling, ER Modelling, Start Schema, Snowflake, Fact, Dimension, Hierarchy, Inmon/ Kimball/ Imhoff, Data Marts, EDW, ERWin 9.5/8.0/7.x, DeZign, Microsoft Visio, Enterprise Architecture (EA), Service Oriented Architecture (SOA), UML, Zachman, TOGAF, Star & Snowflake Schemas, 3 Normal Forms, Normalization and Demoralization, Logical Model and Physical Model, Fact/Dimension/Hierarchy identifications, Data Warehouse Development Lifecycle, Data Mapping, Data Dictionaries

Data Governance: IBM InfoShere MDM, Informatica MDM, MDS, DQS, Profisee Maestro, SAS MDM

Integration and ETL: SSIS/SSRS/SSAS, SQL Server 2014/2012/2008 R2/2008/2005, Informatica PowerCenter, DataStage, Cognos, ETL Mapping design, Data Profiling, Data Validation, Data Migration, Data Cleansing, Data Structure, Data Quality Services (DQS), BIDS, SQL Data Tools (SSDT), Auditing Framework, Execution Plans, ETL Parallel Processing, Error Handling, Custom Scripting, IBM Cognos, InfoSphere DataStage, Informatica PowerCenter, SAP BusinessObjects (BO)

Data Warehousing and Analysis: Data Analysis, Descriptive, Predictive Analysis, Prescriptive Analysis, Recommendation Engines, Machine Learning, clustering, classification, pattern recognition, and regression, Data Mining, sentiment analysis, text analytics, vision/image processing, speech recognition, SAP HANA, OLAP/Cube/MDX/DAX, Dimensional Modelling, Tabular Modelling, KPIs, KPPIs, Data Analysis, SPSS, Predictive Analysis, Data Mining, Machine Learning, SAP HANA, Statistical Analysis, SAS, SAS VA (Visual Analytics), R, XLSTAT, Sentiment analysis, Speech analytics, Teradata. Netezza, Cloudera, PDW, Aginity, Master Data Services (MDS), Master Data Management (MDM), Data Quality (DQ), Analysis of Change (AOC), Metric Engine, analytics for General Data Protection Regulation (GDPR)

Reporting: Predefined Reports, Ad-hoc Reporting, Analytical Reports, Custom Reporting with .NET/ Report Viewer, SQL Server Reporting Services (SSRS), SharePoint 2013/2010/2007/2003, PerformancePoint, PowerPivot, Power View, Crystal Reports, Hyperion, MicroStrategy, Cognos Report Studio, Framework, Workspace Advanced, DMR, TM1

Data Visualization: Power Map, PowerPivot, Power View, SharePoint, Liferay, PerformancePoint, Google Visualization, Esri's GIS (geographic information systems), mapping, SAP Lumira, QlikView, Tableau, Data Mapping

Database: MS-SQL, Oracle, Oracle SQL Developer, TSQL, MDX, DMX, PL/SQL, Stored Procedure, View, Function, Erwin Data Modeler, DB2, PowerDesigner, MongoDB, Access, Excel, FoxPro, Informix, NoSQL, Big-data, Hadoop, Spark, HBase, HDInsight, PDW, PolyBase, Hive, HQL, Map/Reduce, HFS, Alert

Programing Languages: SQL, T-SQL, PL/SQL, C#, WCF, Restful Services, WPF/Silverlight, WF, VB .NET, ASP .NET, ADO.NET, LINQ, MVC, MVVM, MVP, AJAX, HTML 5.0, DHTML, XML, XSL, WSDL, XSD, JSON, Java Script, PowerShell, COM, DCOM, VB Script, UNIX Shell Scripting

Others: Agile, Extreme Programing, RUP, Use Cases, SDLC, TCP/IP, CVS, Microsoft Team Foundation Server (TFS), Tortoise SVN, SQL*Plus, TOAD, WinSQL, SilverLight, LightSwitch, Kerberos, Single Sign-On, Datazen, One-Key.

Architecture and Design: Enterprise Architecture (EA), Service Oriented Architecture (SOA), Enterprise Service Bus (ESB), Top-Down/ Bottom-Up Design, Structured Design, Object Oriented Design, Multi-tiered and Multi-threaded architecture, Rational Rose, UModel, Patterns: Model/View/ViewModel (MVVM), MVC, MVP, Visio, UML, Zachman, TOGAF, Federal Enterprise Architecture, Gartner Methodology

Business Optimization: Asset management, Information Technology Infrastructure Library (ITIL), customer satisfaction, call center management, service request enhancement, AODA compliance, fraud detection, CRM and ERP optimization, improving marketing effectiveness, portfolio optimization, governance, risk management, compliance, healthcare Confidential t records management, electronic medical records (EMR), optimizing routes and schedules for logistics planning, insurance risk assessment, optimizing manufacturing production.

Integration: Windows API, Biztalk, SOA, WCF, SSIS

Data Access: ADO.NET, LINQ, Entity Framework, Microsoft Enterprise Library, OLE DB, Oracle Data Provider, MS OLAP, SQL Master Data Services (MDS), StreamInsight

Methodologies: Test driven programming, Agile software development, Extreme Programming (XP) Microsoft .NET Framework (from 1.0 to 4.0), C#, Visual Basic .NET, VB .NET, ADO .NET, WinFX including Windows communication foundation (WCF), windows workflow (WF), windows presentation foundation (WPF), XAML, XML, HTML, HTML5, Java J2EE, Spring Framework, Scala, JavaScript, AJAX, RESTful services, Payment Card Industry (PCI), Image ProcessingVisual C++ (MFC, SDKs, COM, DCOM, ATL ActiveXs), VB, C++, Perl, VHDL, Verilog, Shell, Skill, Ocean, SystemC

Version control tools: Source Safe, Team Foundation Version Control, (TFVC), Subversion Tortoise SVN

Code metrics: Simian, RSM

Type/ industry: financial, banking, biomedical, pharmaceutical, engineering, telecommunication, semiconductor, logistics, health, scientific, e-commerce, instrumentalCloud ComputingAzure Cloud, Azure Data Lake Store (ADLS), Azure Data Lake Analytics (ADLA), HDInsight (Managed Hadoop), Machine Learning Studio (ML), Azure Data Factory (ADF), Azure Data Warehouse (ADW), Azure Analysis Services (AAS), Power BI, and Azure Data Catalog, Amazon EC2

SharePoint: SharePoint 2013/2010/2007/2003, Multi-machine SharePoint Farm Architecture, Setup, Configuration, Load Balancing, Clustering, Backup Plans, Web Part and module development, Collaboration, Social, Search, Web Content Management, Enterprise Content Management, App Management, PerformancePoint and PowerPivot, PowerView, Application Federation, Secure Store Application, Business Connectivity, Usage Reports, SharePoint Designer, Dashboard Designer, PerformancePoint, dashboard, charts, KPI, Scorecards, reports, filters, Excel Services, PowerPivot Services, Web Analytics, Static Analysis, Hit Counters, Custom Development, PowerShell, SharePoint API, Object Model, web parts web services, workflows, Content Management, site collections/structure

Internet Development: ASP .NET, MVC, Sliverlight, HTML, DHTML, Web services for marketing and financial applications, AJAX, ASP, JavaScript and VB Script, XML, Microsoft Internet Information Server (IIS), Microsoft E-Commerce, PHP, WebloadMobile DevelopmentAndroid, iOS, Windows

Operating System Used: Windows, UNIX, Windows Azure, Linux, Android, iOS, Windows Mobile, MS-DOS

Hardware and Simulation: Matlab, Cadence Spectre, Spice, Eldo, ANSYS

Algorithms: Genetic algorithm, simulated annealing based algorithms, heuristic search, binary search, quick sort

Automation and Scripting: VB, Perl, Unix Shell

IDE: Eclipse, IntelliJ, Visual Studio

WORK EXPERIENCE:

Senior Big Data and BI Lead / Solutions Architect, Consultant

Confidential

Responsibilities:

• Led Big Data and BI projects for a pension fund management system (Ontario Municipal Employees Retirement System). The projects ingest, transform, and analyze data for Capital Market, Private Equity Market, and Pension investment management. Created a big data framework architecture and implemented solutions using Azure Cloud, Azure Data Lake Store, Azure Data Lake Analytics, HDInsight (Managed Hadoop), Machine Learning Studio, Azure Data Factory, Azure Data Warehouse, Azure Analysis Services, Azure Data Catalog, and Power BI.
• Designed and developed a Big Data project utilizing Spark, Java, Cloudera, Hadoop, Hive, Impala, Flume, Sqoop, Map/Reduce, and Pig. The project collects information from capital market, performs advanced analytics for risk management. Subsequently, the unstructured data is processed to feed the BI layer.
• Designed solution, performed data modeling, and automated the data flow for Cyber Security and Incident Management System (ServiceNow) by running U-SQL scripts on Azure Data Lake and scheduling the data pipelines using data factory. Provisioned Azure environments by using Azure PowerShell and Resource Manager to manage the resources.
• Successfully installed and deployed an entire IBM Cloud Private ICP Cluster then implemented and deployed ELK Elasticsearch, Logstash, Kibana, Filebeat, Kafka, Zookeeper, Cassandra, Curator on ICP IBM Private Cloud, Kubernetes, Pods using Helm Charts, Scala SBT. IBM Cloud and IBM Cloud Private (ICP) is a Distributed Container based Architecture, Docker, Docker CLI, Kubernetes, Kubernetes CLI, Pods, Pods deployments. Service Deployments, Ingress, Helm Charts, Helm Charts CLI.

Senior Big Data / BI Solutions Architect - Consultant

Confidential

Responsibilities:

• Designed and developed a Big Data project on Teradata utilizing Spark, Java, Hortonworks, Hadoop, Hive, Impala, Flume, Sqoop, Map/Reduce, and Pig. The project collects information from cameras and sensors installed on the highways, performs advanced analytics to capture the information.
• Led BI/DW projects for Ontario's driver examination services. The solution consolidates the information from 55 Drive Test centers as well as 39 travel point locations. Designed the full stack BI solution including ETL, Staging, DW, Dashboard, and reporting layer in Power BI.
• Designed and developed an advanced analytical solution that utilizes Machine Learning and Deep Learning frameworks for Ontario's driver examination services. The solutions utilize tools such as Machine Learning Studio, DLVM, R Server, Python, Jupyter notebooks, Azure Data Lake, Azure SQL database and many other data science and ML tools.
• Analyzed and prepared various datasets, ingested them into Azure, built data model, and applied various Machine Learning algorithms to find the most important parameters impacting the wait time at the centers and to predict the wait time at the centers. These algorithms include regression, Two-class classification, Multi-class classification, and anomaly detection. I also performed What-If analysis, proposed actions to be taken to reduce the wait time.
• Designed and developed Artificial Intelligence (AI) applications with Natural Language Processing (NLP) - With Cognitive Services API's. The solution includes text analytics, Vision, and Speech recognition. The project collects information from cameras and sensors installed on the highways, performs advanced analytics to capture the information. Subsequently, the unstructured data is processed to feed the BI layer.
• Designed and developed fast scalable search system using Azure Search (utilizing Elastic Search) for incident and ticket management. The high-speed search gets its data from a Machine Learning system with Key Phrase extraction capabilities. Subsequently, user can search and perform text mining through unstructured text in a large-scale data source.
• Established a roadmap for migrating legacy information warehouse to a modern high-performance data warehouse running on multiple DW appliances. Drafted a BI/DW prioritized implementation roadmap while taking input from organization, business, and IT strategy documentation
• Created high-level architecture, solution blueprints, technology infrastructure implementation plan, integration plan, and disaster recovery plan. Created architecture artifacts and provided subject matter expertise in support of a technology selection process.

Senior BI Lead/ Solution Architect Consultant

Confidential

Responsibilities:

• Led a big data project on large clusters utilizing Spark, Scala, Hadoop, Hortonworks, Cloudera, Hive, Impala, Flume, Sqoop, Map/Reduce, Pig, HDInsight, HBase, oozie, Data visualization, and facilitating real-time data analysis by data scientist.
• Led EDW projects on Massively Parallel Processing (MPP) Data Warehouse Appliances such as IBM Netezza, Teradata, APS (PDW), Oracle Exadata, Java
• Defined the data governance strategy, designed security patterns, implemented data standards and procedures across the enterprise; drafted business specific methodology to establish business stakeholder-driven data stewardship through MDM
• Designed Enterprise Information Management (EIM) solutions for retail operation. Led technical teams, provided estimation, planed resources, and designed various BI solutions including loyalty programs, card management, POS data management, customer behavioral analysis, store dashboards, finance, ecommerce, cyber security analytic.
• Drafted a BI/DW prioritized implementation roadmap while taking input from internal divisional service plans, business and IT strategy documentation, as well as corporate BI Strategy and the Financial Planning and Reporting System
• Created high-level architecture, solution blueprints, technology infrastructure implementation plan, integration plan, and disaster recovery plan. Created architecture artifacts and provided subject matter expertise in support of a technology selection process
• Designed a Scorecard and Strategy Management BI solution with capabilities aimed at communicating strategic goals across the organization and monitoring progress over time. Scorecard and Strategy Management provided capabilities to establish specific goals, defined how to measure success, and communicated information down the entire organization to increase organizational effectiveness and productivity through improved transparency, processes and technology
• Conducted and documented business stakeholder interviews and workshops
• Conducted BI maturity assessment of the organization. Architected DW&BI Program Structure defined the role of DW&BI Program Steering Committee, it's mission, objectives, roles and responsibilities, monitored regular improvements to help manage risks, evaluate trends, and develop capacity and capability to achieve the Program mission
• Led a team of 16 individuals to plan, design, and migrate a portfolio of 6 projects to Azure Cloud. Was involved in the full cycle of vendor selection, evaluated RFP responses, requirement gathering, design, and development of this project. The migration included various aspects of the project from front, backend, and integration. According to the requirement, we selected Azure cloud for this project and utilized cutting edge utilities to perform the migration.

Senior BI Lead/ Solution Architect Consultant

Confidential

Responsibilities:

• Led a big data project to be hosted on Azure cloud. Led the design and development of big data solution to conduct sentiment analysis for all schools across Ontario. The solution merges feeds from social media with school board structured data. The data then is analyzed by multiple dimensions including geographical, parent income, and crime rate. The analysis provides valuable insight and is used in planning, early detection of issues, and enhancing school performance. The tools utilized include Hadoop, HDInsight, PDW, Map/Reduce jobs, Java, Hive, and Sqoop.
• Led the design and development of BI solution, ETL processes, and data mapping using SQL server, Master Data Services (MDS), Data Quality Services (DQS), SSIS to extract data from ITIL and Process Implementation tools such as Remedy and HP OVSD. The process loads the asset management information including server hardware, software, and application data and transform and load the data into data warehouse. Subsequently, designed and developed reports that are accessible through a SharePoint portal. Developed several BI components for implementation of new policies, process improvements and detailed work instructions that integrates application management processes with existing ITIL based processes such as incident management, change, knowledge, IT financial, and configuration management.
• Led the design and development of a SQL Server SSAS Analysis cube utilizing star schema with complex MDX calculated measures, named sets and KPIs, KPPIs to present an analytical view for the data and data quality with multiple dimensions.
• Led the design and development of data visualization using Microsoft Power View and Power Map to represent the server information across multiple data centers in Canada.
• Was involved in the full cycle of vendor selection, evaluated RFP responses, requirement gathering, design, and development of the projects.

Senior BI Solutions Architect/ Lead/ Senior BI Specialist

Confidential

Responsibilities:

• Led the design and development of 311 data warehouse and business intelligence solution that provide a consolidated view for the data for all services that the City provides to the citizens. The solution extracts data from Lagan ECM, different divisions including 311 Toronto, Toronto Water, Solid Waste Management, Municipal Licensing & Standards, Forestry & Recreation, Transportation Services and Parks. The extracted data, then, are corrected and cleansed according to business rules and presented as a single analytical view to the users such as Councillors, City senior management, and operational managers.
• Led the design and development of a big data solutions by utilizing Hadoop/HDInsight, PDW, Map/Reduce jobs, Hive, and Sqoop. The solutions measure the performance of 311 call centre by analyzing the data gathered from Cisco/IPCC telephone systems. Integrated with Cisco Verint for VOIP call recording, quality monitoring (QM), and speech analytics. The BI solution improves the communications between the City and the customers. The real-time data visualization shows a snapshot of the interactions between the CSRs and the customers at any given time.
• Led the design and development of the Workforce Management (WFM) data warehouse and BI solution to optimize adherence and attendance in the contact centre. The predictive analytic component accurately forecasts the number of CSRs needed in the call centre to fulfill the services.
• Led the design and development of an efficient BI auditing framework that collects the data from packages being executed and used in data flows, row counters, versioning, and error handling. The framework is crucial for monitoring, timing, troubleshooting, and auditing. Also, developed Stored Procedures, Views, and Functions for the framework to automate logging the information and error handling in the packages.
• Led the design and development of ETL processes and data mapping using SQL server, Master Data Services (MDS), SSIS to extract data from Lagan ECM and division data sources including SQL server and oracle databases, flat files, and excel sheets. The data, then, is transformed and loaded into a data warehouse for reporting.
• Led the design and development of data quality ETL packages to correct and cleanse the data and enhance the quality of consolidated data. Wrote hundreds of lines of .NET C# code, embedded in the packages, to create a rules engine that loads business rules and apply them to the data efficiently. In addition, the data quality issues are mapped for reporting purposes.
• Led the design and development of an SQL Server SSAS Analysis cube utilizing star schema with complex MDX calculated measures, named sets and KPIs to present an analytical view for the data and data quality with multiple dimensions.
• Led the design and development of map application and report using ASP.NET/C# web application. The application loads the data from the data warehouse, combines it with geographical information, and displays the data on a map. The application communicates through restful mapping services and uses client-side scripts (JavaScript and AJAX) to improve performance and user experience.
• Led the design and development of SharePoint web application, site collection, dashboard, and libraries. To present the analytical reports in a user-friendly and interactive way, SharePoint and dashboard designer 2010 are used to create a site that hosts PerformancePoint charts, filters, and integrated SSRS reports. The dashboard is connected to an SSAS cube and dynamically applies the filters to the data shown on the charts.
• Prepared system architecture documents and designed for high-availability clusters. Also, he configured multi-machine SharePoint farm through windows clusters to ensure reports and dashboards are always available in case of a failure. Also, configured distributed reporting services to be integrated with the farm.
• Led design of a Java application using Spring Framework to communicate, create and update the booking for the City facilities.
• Led the configuration of access levels for different groups and created security roles within SharePoint.
• Led the enhancement of the security of map application through SSL, security s, and windows authentication in IIS.
• Authored naming conventions, BI best practices, and development and deployment guidelines. The guidelines also provide steps for SharePoint installation, setup, backup, and recovering the system to help sustainment team promote the solutions to QA and production.

Senior BI Architect/ Sr. Business Intelligence Consultant

Confidential

Responsibilities:

• Led the design and development of a BI solution for a data quality management system (DQM) for a capital market Anti-Money Laundering (AML) solution using SQL server SSAS cubes and DB2 financial system. The solution measures the data quality according to a set of business rules and calculates KPIs with respect to the given thresholds. Created reports using SAS.
• Led the architected and development of a business intelligence solution for BMO Employee Giving Campaign. The solution extracts information regarding the donations of BMO employees to United Way from multiple sources including HR system and UW campaigns both in Canada and the US. Developed auditing framework, ETL packages, and a data warehouse with complex MDX calculated measures for the analytical reporting.
• Led the architected and development of a SharePoint dashboard using PerformancePoint 2010 that helps visualizing the quality of the data using charts, scorecards, reports, and indicators.

Sr. Business Intelligence Consultant

Confidential

Responsibilities:

• Led the architected and development of several projects for this leading insurance company. Also helped with the architecture. The projects facilitate the title insurance for commercial and residential transaction as well as refinancing mortgage programs for lenders such as TD, Bank of Nova Scotia, and RBC.
• Utilized service-oriented architecture (SOA) for integration and developed analytical reporting using SSIS, MS SQL Server 2008, SharePoint/PerformancePoint, SOA, .NET 4.0, ASP.NET, C#, WCF, MVC, LINQ, NetTire, SOAP UI.

BI Architect/ SSIS/SSAS Specialist/ Sr. Software Engineer

Confidential

Responsibilities:

• after broadcasts, giving TV and Radio broadcasters and advertisers critical insights into the impacts of broadcast.
• Designed the template and built analytical reporting, business intelligence and data warehousing using SSIS, SSAS, SSRS, SQL server, and Oracle 10g, Oracle Mantas, and PL/SQL.
• Led the architected and development of a service-oriented solution to retrieve the data from various data sources for data staging, parsing, and loading to a data warehouse using .NET 4.0, C#, WCF services, LINQ, WPF composite application block/Prism, Silverlight, MVC.

Lead/ SSIS/SSRS/SSAS Specialist/ Sr. Software Developer

Confidential

Responsibilities:

• Led reporting analytic team to design and develop the data warehouse, ETL projects, and reporting solutions. The team includes 5 developers and a QA staff. Modeled the data according to the client requirements and business intelligence principles. Also worked on the architecture and created the prototypes for the related projects.
• Designed and developed solutions to help OEM's and dealers manage the end to end automotive sales process from campaign creation, to lead consolidation, delivery and management through sales, service and repurchase.
• Developed a Software-as-a-Service (SaaS) application that provides high performance services by using the state of the art technologies including ETL (SSIS), SSRS, SSAS (OLAP), .NET 3.5, C#, SQL server 2008, MVC, and Silverlight.
• Developed a report analytic project that generates reports for the campaigns as well as the lead fulfillment. The three-tiered application consists of a report viewer, automates the data transfer, and manages the leads. A WCF service in C# handles the logic check and data access.
• Migrated Java application to C# .NET. The application automates and maintains the list of dealers across different states.

Technical Lead/ Sr. Software Engineer

Confidential

Responsibilities:

• Designed and developed a multi-tiered ASP.NET application for Confidential .ca. The application intends to replace the paper brochure and help environment. Was also involved in the architecture and developing the innovative glossy online brochure using ASP.NET, C#, SQL server, data modeling, XML, service and object-oriented page design, Java script, Ajax, and DHTML. The application also incorporates Google map and supports automatic IP to location detection mechanism.

Sr. Software Engineer

Confidential

Responsibilities:

• Involved in the architecture, design, and development of this high-tech application using extreme programming approach (XP).

Sr. ETL/SSRS Developer/Sr. Software Engineer

Confidential

Responsibilities:

• Involved in the architecture and development of an Enterprise Resource Planning (ERP) system for inventory management of companies such as Walmart, Costco, Blockbuster, Cadbury Adams.
• Developed several SSRS reports and automated the data transfer using ETL/SSIS. This distributed application, accessed from different cities, centralizes warehouse management and data entry. It’s an integrated system customized for logistic management with multiple functionalities that manages sales/purchase orders, warehouses, human resources, shipping, financing and scheduling.
• Developed an application using C# 2005, ASP.Net 2.0 and SQL server 2005 utilizing many tools including BizTalk, EDI, ETL, SQL Reporting Services, Web Services, XML, SSIS, Excel Automation, and InfoPath. This is to automate the data entry from various data and after applying rules using a rules engine the data is stored and processed in a Data Warehouse.
• Remodeled and integrated a financial application into the ERP system. The application includes account payable, account receivable, payroll, tax calculation for different warehouses in various provinces. Developed several Web Services for the application with the ability of caching to enhance performance. Designed and developed a graphical user interface (GUI) that changes dynamically based on the user interaction and selections.
• Developed a custom integration application to update the price for items through the API. The application also updates the barcodes, scans the products on conveyers using laser barcode scanners and retrieves the data back into the database. The application also analyzes the data and calculates an accurate KPI (Key Performance Indicator) for both human resources and the unit of operation itself.

Software Engineer

Confidential, California

Responsibilities:

• Led a team of 4 developers to develop an e-commerce application using Visual Studio .NET, ASP .NET, C# .NET, XML, CSS, XSL and SQL. The SQL database contains 45 tables and 50 stored procedures, etc. The application is a large ecommerce application with sophisticated Shopping Cart, Wish List, Product Catalog, Discounting, Coupons, Order Tracking, Fulfillment, Affiliates, Communities, etc. Has more than 50,000 lines of code in C# and ASP .NET that can be presented at the Interview (he does have the permission ):
• Migrated a banking application from classic ASP to ASP .NET. The application is a web-based asset management system that gives the user to customize portfolio, have watch list, and perform transactions. The application includes several Web Services and stock market objects, Capital Market, and provides secure access over TCP/IP.
• Was involved in developing an ERP system in visual C++ using advanced object-oriented hierarchy and implemented the data warehouse. The application supports several modules in resource planning including sales, production, data exchange and inventory. Also, was involved in designing the hierarchical structure for the object model and worked on the security issue.
• Developed an application in VB .NET and SQL server 2000 for windows, called ID maker. The application was designed to drive a digital camera, capture a picture and generate different ID cards (marketing for schools and clubs). The application also supports several customized filters. The Cannon digital camera is controlled via USB port.
• Was involved in the design flow of an ASIC. The IC is a video processing SOC. The project had several phases including simulation analysis, writing Perl and UNIX Shell scripts, Cadence ocean scripts to automate the testing; developing a simulator using C in UNIX environment, and using various tools for synthesis. Was also involved in the design verification and signal integrity analysis in the chip power distribution network (PDN) using PrimeTime SI.
• Identified areas of risk based on performance and reliability optimization for interconnects.
• Extracted the chip level thermal profile.