SUMMARY:

• I am a lead software and DB developer with experience in Large Scale enterprise systems, Various information technologies, Data Warehousing and mission critical infrastructures. I managed teams of over 20 developers, working on national - scale banking and Data Warehousing projects. I have been acting as the main communication window between the technical staff, senior management and regulators.
• More than 12 years of IT experience in the Design, Modeling, Development and Implementation of Software products in Retail Banking and Payment industries.
• Hands on experience with data warehousing technologies and large-scale handling of data closely related to the banking industry.
• Very well experienced in design and implementation of complex ETL processes with a vast number of data sources such as flat files, databases and web services. Very efficient in designing and implementing data cleansing procedures and efficient use staging databases.
• Fluent with Microsoft Business intelligence suit of products. Especially using my very good knowledge of C# in order to create flexible and smart ETL processes. (either control flows or data flows)
• Very fluent and fast in grasping and designing the data warehouse architecture (star and snow flake schema), fact table, cubes, dimensions, measures using SSAS tools.
• 8+ years of experience in Systems Analysis, Design, Development and Implementation of various applications including Web and Client/Server Applications using Microsoft .NET Framework, C#.NET, VB.Net and ASP.NET
• Experience in developing and consuming XML Web Services, SOA implementations, Service bus and enterprise integration practices. Experience with Micro-Services Architecture, WSO suite of software and IBM IIB.
• Experience and hands-on implementation of OAuth2 and OpenID security in a service-based architecture.
• Expertise in Visual Studio .Net environment and Microsoft .Net Framework 2.0/3.0/3.5/4. x.
• Hands on experience in .Net Core and Open Source technologies. Deploying .Net Core applications on Linux environments and implementing CI with TFS.
• Strong knowledge and experience on object-oriented programming (OOPS) and DDD.
• Strong programming experience with web technologies like HTML, JavaScript, jQuery, CSS, SASS and LESS.
• Hands-on Expertise with client-side NodeJS based build tools: Gulp, Grunt, Webpack.
• Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products and Business Intelligence in SQL Server Analysis Services and SQL Server Integration Services.
• Hands on experience with source control tools (git, svn), build automation and continues integration tools.
• Comfortable to work in a fast-paced environment under agile methodologies.
• Ability to handle Multiple tasks, Intuitive and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.
• Good ability to quickly grasp and master new concepts and technologies.

TECHNICAL SKILLS:

Languages: C#, Java Script, T-SQL, Visual Basic .Net (and for applications)

Technologies: .Net, .Net Core, Web API, REST, Angular, HTML, CSS, Integration Bus (IIB, WSO2)

RDBMS: MS SQL Server, SSIS, SSAS, SSRS, IBM DB2

IDEs: Visual Studio, SSDT, SSMS, WebStorm

Platforms: Windows, Linux

Version Control: Git, SVN, TFS

Methodologies: Agile Methodologies, Scrum, Lean Development

PROFESSIONAL EXPERIENCE:

Senior Software Engineer

Confidential

Responsibilities:

• Developed RESTful web services using MuleSoft Anypoint studio
• Worked on Anypoint studio to use web services and for business-to-business integration.
• Worked on API notebook to explore APIs and for testing and improving these. Furthermore, used API kit to integrate APIs with other services on premise and on cloud.
• Created REST API's using RAML and developed flows using APIKIT Router
• Created various RAML resources to implement REST Based APIs as a part of project implementation
• Implemented RAML files for different entity creations and respective associations.
• Used Mule ESB in designing the application as a middleware between the third-party system and the customer side system.
• Extensively used Mule OOB components like File Transport, SMTP Transport, FTP/SFTP Transport, JDBC Connector, and Transaction Manager.
• Configuring the Mule process for fetching the data from topic and makes web service calls to the middle tier Mule ESB for processing and put the data on the Cloud hub.
• Used Database Connectors to connect with respective systems using Mule ESB.

Senior Software Engineer

Confidential

Responsibilities:

• Designed and implemented Data access layers model using LINQ for XML Data and multi-user interface Used XML, XSLT and defined XML Schema.
• Different Validation controls provided in web forms that are used for input validations, also developed server side code for input validations in C# .Net
• Experience in creating and supporting custom reports from the TFS data warehouse.
• Implemented User Controls to wrap up the reusable code, provided facility to upload various types of documents in attachments page.
• Worked closely to clients (Business) for gathering and analysing requirements and providing solution that meets clients need.
• Interface with database and stored procedure using ADO.NET Dataset, Data Reader and Entity Framework.
• JQuery and JavaScript is also used for client side validations.
• Troubleshoot and provided resolution for different kind of issues during the various stages of project.
• Used Java Script to validate the user input.

Software Project Manager

Confidential

Responsibilities:

• Design and Develop the main e-commerce channel for the Fredrik Lorenz brand representative in the US market.
• Inventory and order management infrastructure setup.
• Generate live XML based feeds of products to integrate with Google merchant center.
• Utilizing APIs provided by online marketplaces such as Wayfair and Houzz to read sale orders data and importing the into our in-house system to control and track inventory and orders.
• Technologies used: .Net Core(Web API), Azure Cloud(functions, web apps), Microsoft Flow (social media accounts and email integration), Microsoft Flow (Email and Project management software integration), Azure SQL(Populate an e-commerce mailing list online and integrate it into Mailchimp API)

SOA Team Lead

Confidential

Responsibilities:

• Involved in entire product life cycle development from the requirement gathering through implementing in production.
• Worked with Data Modeler and DBAs to build the data model and table structures.
• Actively working on and designing the ETL job flow.
• Compiled source to target mapping documents to design the ETL jobs.
• Product development is an Agile (SCRUM) methodology, where progress and task assignment discussed in everyday meetings. I also acted as the SCRUM Master in the API project.
• Designing a REST API Layer on top of our legacy core banking systems. (based on my Knowledge of the data model from previous projects)
• Developed and implemented custom data validation SSIS C# scripts to create smart and flexible ETLs.
• Create and promote a CQRS mind-set in the Architecture team.
• Design and Implement Operational OLTP database using MS SQL server 2012 Memory Tables mainly to be used and very high-performance audit logs.
• Design and Implement Live Reporting DB using MS SQL 2012 and technologies like column store indexing.
• Design and development of very complicated ETL processes using SSIS to update cold reporting database at predefined intervals. Mostly at system Cut-off. (with high performance considerations)
• Design and Implement Initial DB populating ELT processes from our legacy systems using SSIS.
• Implemented an API layer in front of the data warehouse.
• Implement a Banking grade security and access control for the micro-service base API layer using OAuth2 and OpenID connect. (OWIN with an external key store)
• Consuming the back-end legacy SOAP services, implementing WS-Security protocols to achieve security and non-reputability. (utilizing enterprise HSM systems in the production environment)
• Working close with the team form Netherland to implement the banking portal and transfer knowledge. (Java based software, Spring Security, Apache Camel integration layer)
• Systems integration with Iranian Capital Market.

Senior Full Stack Developer

Confidential

Responsibilities:

• Used ASP.NET Model View Controller (MVC) architectural Design Patterns for the development of the product.
• Development of a robust web-based SPA UI layer with jQuery and employing restful ajax connections to the backend server.
• Utilized Entity Framework technology extensively for data retrieving, querying, storage and manipulation using LINQ
• Implemented Framework Entity Framework Code First Approach with Repository Pattern and its implementation over the Business and Presentation layers.
• Implemented Data Access layer using WCF, Web-API restful services and Entity Framework.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse. The data was usually CSV flat files exported from IBM mainframe environment.
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio. Managing a very complex Data Flows, usually involving 10 - 20 dimension tables, Un-Pivoting the data and validity checks.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Extensive use of SSIS Control Flow to automate the ELT processes and control the execution of different ETLs and Integrity assurance.
• Handling Compressed text files and extensive logging using the Control Flow.
• Use of C# script controls inside SSIS to implement more complicated data validation and shape shift.
• Handling extremely large Partitioned tables, managing partition files and indexes using SSIS control Flow.
• Using Control Flow to switch in new partitions and switch out older partitions to backup tables.

Full Stack .Net Developer

Confidential

Responsibilities:

• SQL Server performance and index monitoring.
• Managing and monitoring Index Fragmentation, Re-indexing.
• SQL Server Setup, Implementation, and performance tuning.
• Database Backup and restore.
• Create new tables, views, indexes and user defined functions.
• Actively designed the database to fasten certain daily jobs and some stored procedure.
• Created SSRS reports for Branch Operations and Marketing.
• Created reports by retrieving the data from cube using MDX reports.
• Designed reports, Graphs and deployed reports to web applications using SSRS.
• Created simple SSIS packages for File Transfer from one location to the other using FTP task.
• Designed Cube partitioning and incremental synchronization for SSAS cubes.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Optimized query performance by creating indexes.
• Involved in Administration of the SQL Server by creating users & login ids with appropriate roles & grant privileges to users and roles.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL
• Queries and Stored Procedures.
• Use the SQL Analyzer, and Profiler for studying the SQL statements and procedures
• Developed complex stored procedures to create various reports.

Software and DB Developer

Confidential

Responsibilities:

• As a developer I was responsible for the systems study, analysis, understanding systems design and database design.
• Designed and developed complete front-end application using ASP.NET Web Forms.
• Designed and Developed Visual Basic .Net windows forms applications.
• Designed web forms by implementing CSS, HTML and JavaScript.
• Used ADO.NET objects such as Data Reader, Dataset and Data Adapter, for consistent access to SQL data sources.
• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Created Views to facilitate easy user interface implementation, and triggers on them facilitate consistent data entry into the database.