We provide IT Staff Augmentation Services!

Sr .net Developer/ Sr. Sql Developer Resume

NyC

SUMMARY:

  • 6 years extensive in Confidential supporting Asset management (Fix Income, Equities)
  • Expertise on SSIS, SSAS, SSRS, SharePoint, Modeling, Dimensions, Fact Tables, Stored Procs
  • Expertise in developing .Net application development, OO program, Internet / Intranet based database application using ASP.Net, C#, .Net, ADO.Net, MVC 4,WCF, WPF, Silverlight, AJAX, AngularJS,JQuery, Java, Javascript,XML, XSLT, DHTML, Web Services, SOA, SQL Server,Oracle, Silverlight, SSIS,SSRS, JSON, Infragistics, Telerik, Dundust, and Crystal Reports,C++ etc.
  • Develop Entity Framework 5,6 via LINQ and Lambda Expression .
  • Adapted various architectural patterns like MVC, MVVM(via Razor Syntax) Façade, Singleton, Adapter, Messaging, Factory, Entity Framework 5,6, Bootstrap for Response Web Design and more.
  • Designing and developing a Big Data and Enterprise Data Warehouse with ETL processes.
  • Tune database performance, SQL Server Profiler, Sybase IQ,Transact - SQL
  • PowerShell scripting to automate job tasks
  • Domain knowledge expertise including investment research and finance.
  • Knowledgeable for Securities, Equities, Derivatives, trade lifecycle, Wealth Management.
  • Good understanding on the future web, WEB 3.0, HTML5, CSS5, XAML, Mobile technologies such as Android, Windows Phone.
  • In depth understanding Big data, Hadoop/MongoDB

TECHNICAL SKILLS:

  • Asset management (Fix Income, Equities)
  • C#/C++/VB.Net/ASP/HTML/WebServer/MVC 3,4,5
  • Python
  • C#, WCF, WPF,AngularJS,Web API,Javascript,JQuery
  • Object Oriented design & development
  • SQL Server/TSQL: v 6.5/7/2000/2005/2008/2012/2014/2016
  • Oracle, PL/SQL8i/9i/10g/11g
  • SSIS/SSAS/SSRS
  • Unix/Pro*C/Perl:
  • Windows 2000/XP/NT:
  • Knowledge of Financial Trader/Cash flows
  • Project Management

PROFESSIONAL EXPERIENCE:

Confidential, NYC

Sr .Net Developer/ Sr. SQL Developer

Responsibilities:

  • Successfully implemented a global 24/7 Campaign Management System to provide end-to-end bookings management for our advertising platform via WCF, AngularJS,JQuery,HTML5, MVC 4, User Controls, Web Controls and Master Pages.
  • Developed Web Pages in ASP.NET MVC4 utilizing razor syntax
  • Utilize Bootstrap for Response Web Design
  • Utilize Web API and Angularjs for Client Side Access to data
  • Developed Client Side Code using AngularJS.
  • Utilize the ajaxwebtoolkit, JQUERY, JavaScript and CSS in ASP.NET web pages (MVC and ASP.NET).
  • Design a Data warehouse / BI project in finance / banking environment, OLAP, Cube. Sybase IQ
  • Excellent understanding of the Data warehouse life cycle right from data source to ETL to transformations to multidimensional models like data marts, star schema and BI reporting through reporting tools like Business Objects
  • Created Web Services,WCF for Dashboards using Query as a Web Service as well as ASP.NET Web Services.
  • Perform data transformation and loading using SSIS.
  • Optimized query performance, using hints, partitions and indexes as needed.
  • Developed stored procedures in both Oracle and SQL Server Environments.
  • Work with business owners and analysts in planning and estimating throughout the complete life cycle, review the business requirements and as well as identify and evaluate alternatives and present the most efficient and cost effective solution.
  • Excellent working with large development teams and global team.
  • MSBI suite of products (SSIS/SSRS/SSAS/Power BI (Power View, Power Pivot, Power Query, Power Map)/ PerformancePoint (on SharePoint)/MDS/DQS/Data Mining).
  • Strong analytical and troubleshooting skills, SSIS/SSAS/SSRS, Powerpivot - DAX/MDM/Tabular models, Sharepoint, .Net/C#, Teradata, Informatica.

Confidential, NYC (Consultant)

Sr.Net Developer / Sr. SQL Developer

Responsibilities:

  • Built a data warehouse supporting risk analysis, portfolio manager and client reporting, integrating data from multiple and shifting back-office and legacy risk systems. Assisted risk management team defining and developing reporting suite. Co-ordinated API interface development with back-office system vendor.
  • Collect the business requirements and merge them into the design and implementation for all end-to-end BI/Data Warehousing solutions.
  • Served as a Business Objects/Crystal Reports Developer/Net Developer.
  • Developed complex reports using Crystal Reports and SSRS.
  • Migrated Reports from Crystal Reports to SSRS.
  • Strong hands-on experience in MVC 4,R, AngularJS, C++, .Net/C#, Informatics. Preferably with Teradata as source/target
  • Excellent working with large development teams and global team.
  • Exposure to data modeling, predictive analytics, and forecasting techniques
  • Design and implement ETL framework with features like error handling, logging, data quality, data security
  • Collect the business requirements and merge them into the design and implementation for all end-to-end BI/Data Warehousing solutions.
  • Design a Data warehouse / BI project in finance / banking environment, OLAP, Cube. Sybase IQ.
  • Excellent understanding of the Data warehouse life cycle right from data source to ETL to transformations to multidimensional models like data marts, star schema and BI reporting through reporting tools like Business Objects
  • Ability to effectively be the single point of contact for the team to the external world
  • Exposure to data modeling, predictive analytics, and forecasting techniques
  • Strong analytical and troubleshooting skills WCF,JQuery, Sharepoint, .Net/C#, Teradata, Informatica.
  • Developed snowflakes and star schemas for use in Crystal Reports and Business Objects Universe.
  • Optimized and maintained various schemas in the universe.
  • Deployed and maintain reports on the Business Objects Server
  • Optimized The Performance of Reports, using hints and indexes as needed.
  • Published reports in Crystal Server’s QA Environment.
  • Developed stored procedures in both Oracle and SQL Server Environments.

Confidential, NYC

Sr .Net Developer, Architect / Sr. SQL Developer

Responsibilities:

  • Daily support for e-commerce software systems, and customer facing portals
  • Experience with MVC 4,WCF,JQuery, AngularJS,HTML, XML/XSLT/JSON, HTTP and SSL.
  • Design, architect and development of software systems in collaboration with business stakeholders.
  • Responsible for the development of all Reporting, Analytics, Line of Business, Management and Financial Systems using Microsoft and OSS technology stacks. Working on Sybase IQ.
  • Help to choose company platform, reduced yearly licensing costs by over $300,000
  • MSBI suite and SharePoint of products (SSIS/SSRS/SSAS/Power BI (Power View, Power Pivot, Power Query, Power Map)/ PerformancePoint (on SharePoint)/MDS/DQS/Data Mining).
  • In depth understanding Big data, Hadoop/MongoDB

Confidential

Sr .Net Developer, Architect / Sr. SQL Developer

Responsibilities:

  • Architect MVC 4,MVVM in internal infrastructure ticketing WPF,WCF, AngularJS,JQuery application. Design and implement Entity Framework.
  • In Confidential, I am responsible to establish MVVM architect pattern for API/portal of internal ERP infrastructure administration system.
  • Engineer deploy and integrate their own server farm, infrastructure, network, applications
  • Project Manager to optimize allocate resource, budget, cost
  • Provide project health report to upper management.
  • Create search engine for all ERP elements via Routed event.
  • Customize all kinds of reports for top management via Telerik control. e.g Gantt reports
  • Convert Winform legacy application to .Net 4.0 and WPF application.
  • Expertise in developing .Net application development, OO program, Internet / Intranet based database application using MVC 4,ASP.Net, C#, .Net, ADO.Net, WCF, WPF, Silverlight, AJAX, JQuery, Java, Javascript,XML, XSLT, DHTML, Web Services, SOA, SQL Server,Oracle, SilverLight, SSIS,SSRS, JSON, Infragistics, Telerik, Dundust, Crystal Reports, VC++,iOS, Android etc.
  • Build wealth management core business application including research analytical report for portfolio manager, performance and risk calculation for funds products for management and administration using 70/30 views methodology.
  • Developed snowflakes and star schemas for use in Crystal Reports and Business Objects Universe.
  • Developed complex queries and stored procedures in Sql Server 2000/2005 Query Analyzer
  • Developed, design and maintain universes in Business Objects.
  • Deployed and maintain reports on the Business Objects Server
  • Optimized The Performance of Reports, using hints and indexes as needed.
  • Published reports in Crystal Server’s QA Environment.
  • Developed stored procedures using PL/SQL, cursors and tables.
  • Analyze performance of programs and take action to correct deficiencies based on consultation with users and approval of supervisor. Confer with users to gain understanding of needed changes or modifications of existing programs.
  • Governance frameworks and design patterns,factory pattern,builder pattern,state pattern, strategy pattern, visitor pattern, adapter pattern,fly weight pattern,Interpreter pattern, iterator pattern, mediator pattern, memento pattern, UML and observer pattern
  • Handle multiple tasks and adapt to a constantly changing environment
  • Experience with the development models and software development lifecycle (SDLC) model.
  • Good organizational and communications skills to be able to effectively work across teams and interact with business partners with six sigma.
  • Currently working on the Life Cycle Solutions includes TFS, home grown life cycle tools for the GWIM transformation program, like I mentioned earlier the goal is to have faster deployment and validation from the source and beyond.
  • Design and implement enterprise strategic tools for upper management. Provide key reports as cost control.
  • Exp in database administration activities like Installation, Configuration, Backup & Recovery, Database Security, Database designing and Query analysis fine tuning / optimization for SQL Server
  • Successfully implemented a bespoke reporting & application framework to provide near real-time statistical and revenue reporting from banking platform. This system enhanced both strategic and tactical decision making.
  • Create equity performance analytical reports via Quantitative Research Model, help portfolio manager, funds administrator to make strategy decisions.
  • Modeling of OTC and Exchanges risks and forecasting the performance of asset through variety methodologies.
  • Successfully implemented a bespoke reporting & application framework to provide near real-time statistical and revenue reporting from banking platform. This system enhanced both Financial Engineering strategic and tactical decision making.
  • Build wealth management core business application including research analytical report for portfolio manager, performance and risk calculation for funds products for management and administration using 70/30 views methodology
  • SharePoint, R,Matlab,Python, Java, PowerShell,Teradata.
  • Plan and implement disaster recovery procedures, 2TB+ DB
  • Ensure data integrity, security and Failover Clustering
  • Develop Transact-SQL objects and write DML for production support
  • Design schemas as required
  • Monitor production environments
  • Provide data architecture guidance
  • Facilitate the efficient flow of data
  • Perform database upgrades, patches and migrations
  • Work with developers in their interactions with the databases.
  • Participate in an on call rotation.
  • Governance frameworks and design patterns, factory pattern, builder pattern, state pattern, strategy pattern, visitor pattern, adapter pattern, fly weight pattern, Interpreter pattern, iterator pattern, mediator pattern, memento pattern, UML and observer pattern.
  • Build wealth management core business application including research analytical report for portfolio manager, performance and risk calculation for funds products for management and administration using 70/30 views methodology.
  • Expertise in developing Data Warehouse, ETL, Data Mart, data modeling, PowerShell scripting.Net/C# etc.
  • Participation in an on-call rotation to provide 24/7 database support
  • Monitor incident ticket queue and troubleshoot and resolve database incidents within SLAs
  • Monitor backup results and resolve/troubleshoot failed database backups
  • Monitor storage capacity and consumption, trend long term usage, and proactively work with Architecture group to plan SAN procurement
  • Monitor database and server performance and identify current and future potential bottle-necks
  • Review, maintain, and periodically test database recovery procedures
  • Monitor violations discovered by security compliance tool and remediate issues as needed
  • Apply database security patches
  • Apply database maintenance patches and upgrade databases to supported release levels
  • Perform new builds as required by discretionary projects
  • Support application upgrades of third party software, where a database
  • Experience with managing enterprise DaaS/SaaS solutions

Confidential, South Plainfield, NJ

Sr .Net Developer/ Sr. SQL Developer

Responsibilities:

  • Developed, design and maintain universes in Business Objects.
  • Designed and maintain web intelligence and desktop intelligence documents.
  • Served as a Crystal Enterprise Reports Developer/Administrator and SQL Server Developer in support of Service Management System.
  • Managed a small team to develop New Crystal Reports.
  • Designed and developed various Service Management Reports, utilizing sub-reports, charts, parameterized reports, conditional, crosstab and dynamic reports.
  • Designed, developed, and tested stored procedures, views and complex queries for Crystal Reports distribution.
  • Developed database triggers and stored procedures using PL/SQL cursors and tables.
  • Managed all indexing, debugging, optimization and performance tuning, Profiler and SQL Server Agent.
  • Developed PL/SQL Queries in TOAD environment.
  • Designed and developed Data Transformation Process using BCP utility.
  • Used advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and other applications in the most efficient manner.
  • Build and perform user acceptance testing on new and modified reports.

Hire Now