SUMMARY:

• Masters of Science (M.Sc.) in Computer Science from The City College of New York
• B.Sc. (Engg.) In Computer Science and Engineering.
• 12+ years of experience in the Analysis, Design, Development and Implementation of Windows and Web - based Application, n-tier architecture and product building using WPF, MVVM, Multithreading, Restful API, Encryption methodology, based security implemented in application, ASP.Net with VB.Net and C#.Net, MVC, LINQ, Visual Basic 6.0, MS SQL Server, MS Access, Oracle, Jason and Crystal Reports with hands on OOPs concepts in Software Development Life Cycle (SDLC)
• Very Good knowledge and Experience in SOA with (Web Service, WCF, Web API)
• Extensive experience of working with XML, XHTML, CSS and JavaScript.
• 14+ years of experience in written Stored Procedures, Triggers, Views, Indexes, complex Queries, TSQL and PL/SQL, Packages with SQL server and Oracle, Jason function in SQL server 2016.
• 8+ Years of Experience to design and Development ETL by using SSIS & Data Stage
• Strong Work Ethics and an earned reputation for meeting deadlines and delivering Solutions.
• 5+ Years Experience of SSRS Report Development and deployments with Reporting Service.
• SSIS Package Schedule, configuration and management by using c# and SQL Agents.
• Strong Knowledge about SOA with WCF and web Services.
• 5+ Years Experience about Special System (Tienet, IEP Direct & Project Special)
• Strong Knowledge and Experience about Networking, TCP/IP protocol, topology, Routing and CCNA certified(Expired)
• Oracle 11g to SQL server 2014 Migration.
• SSIS and 2013 SSDT Bi Migrations
• Very good understanding and experience ESB and IBM MQ message and IBM Web Sphere MQ tools
• Very good understanding SQL Server 2014 in memory tables creation, data CRUD operations and indexes
• Experience with database performance tuning and optimization (Dynamic Management Views, Query Execution Plan)
• Knowledge and experience in managing data warehouse and ODS development design, analysis capability and deployment
• Very Good knowledge and experience in .net and mvc framework, Dependency Injection, Version controlling and Object Oriented concept.
• Very good knowledge and experience in OLAP and Data Warehouse methodologies (Inmon and Kimball)

TECHNICAL SKILLS:

Languages: C, C++, C#, VB .NET, VB Script, Java Script

GUI: WPF, Visual Studio .NET (asp.net, window services, WCF, MVC), Visual Basic 6.0

Distributed Computing: .NET Remoting, DCOM, RMI, WCF, Web Services

RDBMS: SQL Server, T-SQL, Oracle, MS Access, PL-SQL

Database Connectivity: ODBC, ADO.NET, JDBC, ADO, Attunity

Web Development: Web Services (SOAP, UDDI, and WSDL), XML, IIS Web Server, TCP/IP, DTD, Entities, Schemas, HTML, and CSS.

Data Modeling: UML, ER Diagrams, DFD, Structure Charts (with Tools Erwin and ER Studio)

Multithreading: Synchronization (Critical Section, Event, Mutex, and Semaphore)

Operating Systems: Window Server, Windows 95/98/XP/Vista/7, OS400, Linux.

ETL Tools: SSIS, Data Stage

Reporting Tools: SSRS

PROFESSIONAL EXPERIENCE:

Confidential

Senior Application Developer

Responsibilities:

• Developing Application by using WPF, XAML, MVVM, Entity Framework, SQL server and c#.
• Primary language for View Model c# but not limited to c#. we also used vb.net and all legacy application developing tools.
• Web scraping with c#, HTTP Programming.
• Active Directory Management with c# library.
• Adobe Echosign integration by using SOAP & REST API in c#.
• Label printing and barcode integration.
• Geo coding and Map integration with marker and command by using c#.
• Custom MP4 Video Player along with timeline by using WPF & c#. XSD Validation and Generate xml by using C# and xml spy.
• Adding based security in application with encrypted methodology.
• Task based multithreading with Async and await in c#.
• Write Stored procedure, function and types and xml query in sql server 2012/2016. write integration testing test case for testing application which developed by wpf.
• Data analysis and find out root cause of the defect and solved it by using c# and SQL sever.
• Write a stored procedure by JSON function in sql server 2016.
• Developed SSIS Package for data integration and business role validation.
• Generated a xml with complex type by using SQL Server.
• XSD Validation, Generated c# object model of XSD by using XML Spy and created a mapping for generating xml by using c#.
• Created a Custom Calendar control with scheduling events by using win form application and added to WPF application.

Confidential

Programmer Analyst

Environment: IBM, Oracle 11g, Unix, DB2, C#, Visual Studio, SQL Server, Batch File, Cross Flat from, ESB, WCF (Soap Based), Data Stage, SSIS, SSRS, Java Script, XHTML, Data Connectivity tools, TFS (Team Foundation Server), IBM DB2 Copy Provider, BIML, IBM Web Sphere MQ, SOA in WCF(SOAP), IBM ESB, OLAP (Inmon and Kimball)

Responsibilities:

• Developed and build web application based on SDLC and agile methodologies with asp.net Ajax (Telerik control), c#, Entity Framework, java Script and xhtml and css.
• SSIS Package Development based on complete SDLC Procedure.
• Converted Data Stage Package to SSIS package with SQL server, Oracle and Legacy Systems
• SSRS Report Development and Deployment with SQL server reporting Services.
• Configured and Scheduled all ETL Job by using SQL Agents and Complete automated.
• Created/Maintained Web Services by using WCF in Cross Flat form.
• Analysis City wide systems, identified defect and log in ALM Tools and Resolve based on agile approach.
• Wrote Stored Procedure, Trigger, Functions, CTE, Table Variables TSQL/PL-SQL Scripting by using SQL server and oracle
• Production support and Dead lock scenario Handling, Environment Clean up and Data Dictionary scripting.
• Very Strong Understanding Special Term(Referral, Evaluation, CSP, IEP, Placement, Encounter Attendance, Case load)
• Oracle 11g to SQL server 2014 Migration.
• SQL Server 2014 in memory tables creation, data CRUD operations and indexes
• SSIS package and 2013 SSDT BI migration.
• Experience with database performance tuning and optimization (Dynamic Management Views, Query Execution Plan)
• Very good Understanding and experience in SESIS Application (TIENET, LCGMS, HRHUB, ODS) and Infrastructure including server side.
• (K -12) experience including General and Special .
• Consume and developed Soap web service and Processed by using console and ETL process.
• XSD, XSL and XSLT Operation done in the process of SOAP Message.
• Configure ESB for SOA(Soap) and MQ Messages.

Confidential

Programmer Analyst

Environment: Dremel (Big Data), KML, C#, MS. Access, Visual Studio 2010, SQL Server.

Responsibilities:

• Built and Developed a Historical Data base by using SQL Server
• Built tools to 247 Business Unit flat file then loaded into historical database by using c#, SSIS Service.
• Built tools to load Data from Historical Database to Dremel (Big Data) using c#.
• Draw object based on Historical Database on a Confidential earth by using KML Language.
• Built Market trend analysis tools by using TSQL and C#.

Confidential

Data Analyst

Environment: S.Q.L Server 2008R2, Visual Studio 2010, C#, XML, IIS, Crystal Report, Red gate tools, SSIS, SSRS

Responsibilities:

• Implemented IEP Direct (Special Software) and RTIM.
• Import Flat File, CSV and Excel and XML file to SQL Server and manipulation and cleaning Data by using view, Stored Procedure, TSQL and Dynamic TSQ.
• Mapped Flat file to our IEP Direct Software Schema then Exported to Flat File by using SQL server SSIS Package, DTS and BCP.
• Import All Flat File to IEP Direct Web application by using Tool which developing by Dot net windows Application.
• Create Tools to convert XML file to Tab Delimited Flat file.

Confidential

Infrastructure Data and Information Analyst

Environment: Asp.net, C#, XML, CSS, JavaScript, Crystal Report, SQL Server, MS Access.

Responsibilities:

• Created Master Page, Created Navigators (Menu, Sitemap path) on Master page. Configure Web.config file for site map
• Created Content Page based on Master Page, Created and used application data components (public function class and data component library), LINQ to SQL class data model. Used Custom Server control and Add pre built user control in Details page
• Used Web.Config to secure Web Site Contents, Building and Deploying Web Application.
• Linked SQL Server Database to MS Access and manipulated and report designed in MS Access.
• Developed and Automation SSIS package as per business requirements
• Writing macro and coding with VBA, Designed and developed report by using access.
• Wrote sub query and Append query for multiple tables.
• Convert access report to MS Excel and manipulated data.
• Query form Excel to Access through ODBC.
• Designed and developed RDMS database in Access.
• Wrote stored procedures, tables, views, indexes and relations in SQL Server.
• Wrote database components to access Database using ADO.NET.
• Created class for customer data, Employee info, and auto-generated email.
• Created and designed report by using Crystal report.
• SQL Server database linked to access database and manipulated data in MS Access 2003.

Confidential

Responsibilities:

• Support Contract management system (CMS), Financial Management System.
• Report design, Query by using crystal report and SQL Server. User can Export reports as Excel and PDF formats.
• Data Backup Support - SQL Server Database
• Financial data analysis by using Excel Pivot table, Macro and VBA.
• Effective resolve problematic calls and eliminate user dissatisfactions through proactive approach to system monitoring and troubleshooting.
• Designed developed and supported Access Database.

Confidential, Queens Village, NY

Responsibilities:

• Business Objects Enterprise X1 R1/R2, Administering Servers - windows
• Business Reporting Solutions by using Crystal Reports 2008.
• Supported and Maintained web Application Server (IIS).
• Supported existing network built on windows 2003, Linux (UNIX) platform. Responsibilities include network management of more than 80 user’s desktop, laptops, printers and servers.

Confidential

Responsibilities:

• Participated in designed and implemented local and wide area network (LAN and WAN).
• Installed, configured and troubleshooter Cisco Equipments (Switches, Routers, etc.).
• Supported users, Implementation of textile integrated manufacturing (TIM) in AS400 which was Enterprise Resources Planning (ERP) based software.
• Implementing, maintained and supported specific ERP (Data Color software of Textiles)
• Designed developed Employee Payroll System with MS Access and VBA.
• Designed and Developed Fashion Management System windows application by using Visual Basic and SQL server and reporting by using SSRS.
• Data Extraction and loading purpose used DTS tools which is built in SQL server 2000.