Senior Programmer Analyst Bentonville Ar
Skills
Experienced in interpreting business requirements, developing use cases sequence diagrams, and process flow
4 Years
2012
3 - Expert
Experienced in CRM, Order Management applications, and Billing Applications
3 Years
2012
2 - Proficient
Experienced in – TSQL, Views, Functions, Indexes, stored procedures, and Triggers, user-defined functions (MS SQL 2000/2005/2008)
12+ Years
2012
3 - Expert
Experienced in MS DTS or MS SQL Server Integration Services
12+ Years
2012
3 - Expert
Experienced in SQL Reporting Services, Developing Dashboard Applications & Customized online Reports
5+ Years
2012
3 - Expert
Experienced in Database Tuning and Performance Monitoring
12+ Years
2012
2 - Proficient
Import and export data; manipulate heterogeneous data using Transact-SQL
12+ Years
2012
3 - Expert
Database Maintenance and Administration including back-up, recovery plan (SQL 2000/2005/2008)
4+ Years
2012
2 - Proficient
Experienced in web page design
12+ Years
2012
2 - Proficient
Experience in java script, AJAX, master pages, style sheets, and themes
12+ Years
2012
2 - Proficient
Experienced in ADO.NET, ASP.NET 2.0/3.5/4.0 & C#.NET under Visual Studio .NET development
12+ Years
2012
3 - Expert
Experienced in developing test cases and test plans
8+ Years
2012
2 - Proficient
Certifications on Database & Web Application Development
Brainbench
Nice to have
Experienced in Telecommunication Billing and Invoice Reconciliation Systems
2+ Years
2012
2 - Proficient
Experienced in latest Telecommunication technologies (VoIP, Video, etc.)
-
Nice to have
Education & Certifications:
B.Sc. Engineering, Confidential,
- One Year diploma in “Computer system analysis and design”, Bangladesh Institute of Information Technology (BIIT), Bangladesh - 1992.
Certifications and Training
- Certification Certified in C# (Master) from Brainbench.
- Certified in ASP.NET from Brainbench.
- Certified in VB.NET from Brainbench.
- Certified in SQL Server Programming from Brainbench.
- Certified in Oracle PL/SQL Fundamentals from Brainbench.
Employment History:
Confidential,
CA March 2012 – September 2012 Lead Developer
Projects:
Compromised Customer Information Mgmt (CCI)
Security Control
Banker Exam
ATM Hardware Reporting
ETL Process Maintenance for different application
Responsibilities:
- Lead a team to day to day basis for development and maintenance applications.
- Involved in Design & Development of all new reports using ASP.NET, JavaScript AJAX, master pages, style sheets, and themes in Presentation layer, and C #in Business Layer and MS-SQL Server in Database layer.
- Enhanced existing reports basing on the new business requirement
- Converted ATM Hardware reporting written in SQL Server Reporting Services to custom application.
- Enhanced Compromised Customer Information Mgmt (CCI) to provide the Mail merge feature.
- Used SQL Reporting Services for developing Dashboard Applications & Customized online Reports.
- Successfully implemented Managing Premier Performance Online.
- Worked on Web Page design.
- Worked on exporting the reports to Word, excel and PDF formats.
- Worked closely with the testing team during the QA activities.
- Developed test specification, test plan, test cases and test report.
- Worked on database tuning and performance monitoring with a special emphasis on web based server.
- ETL Process Maintenance feed (daily, weekly, and monthly) from to Host to Oracle/SQL using NDM and Informatica and SSIS.
- Rewrite VB6 application to .Net one, and for sometime use CCW, to use business logic COM components wit callable wrapper.
Environment: Microsoft .NET Framework 2.0, MVC 3, ASP.NET, C#, VB6, CCW, VB.Net, ADO.NET, Microsoft SQL Server 2005/2008, Oracle 10g, DB2, TSQL, SSIS, SSRS, VB Script, JQuery, VSTO, JSON, JavaScript, AJAX, Toad, NDM, Informatica, Chart FX, XMLPDF, XML SPY (Altova), Microsoft Visual Studio 2005/2008/2010, SQL Server Reporting Services, Unit Testing, Microsoft Team Foundation Server, Microsoft Visio 2003.
Confidential,
Tax and Treasury
Wal-Mart Inc. Bentonville, AR September 2011 – October 2012 Senior Programmer Analyst– ISD
Responsibilities:
- Involved in Design & Development of Tax and Treasury related system.
- SAP integration.
- Import data from AS400 for internal client server applications with SSIS
- Fixing Tax and Treasury related system issues reported my user.
- Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for this project.
- Developed test specification, test plan, test cases and test report.
- Design and developed SSRS necessary online reports, dashboard applications and give user training to use the new reports and updated features.
- Worked on Web Page design.
- Worked with java script, AJAX, master pages, style sheets, and themes.
- Experienced in Database Tuning and Performance Monitoring.
- Converting VB6 application, and use VB6 business com components with com callable wrapper (CCW) till rewrite business layer.
Environment: Microsoft .NET Framework 4.0, ASP.NET, ADO.NET, Visual Studio, MVC3, C#, SQL Server 2008, Informix, SSIS, SSRS, VSTO, JQuery, JSON, TSQL, CRM, JavaScript, AJAX, Microsoft Team Foundation Server, Microsoft Visio, VB6, CCW.
Confidential,
CA March 2011 – July 2011 Sr. Software Developer
Projects: CLAIMS, MI CLAIMS.
Responsibilities:
- Lead a team to development and maintenance user requested applications.
- Involved in Design & Development of all user change request implementation.
- Create DTS using SSIS to import data from BOA legacy Claims database to new CLAIMS database.
- Worked on Web Page design.
- Worked with java script, AJAX, master pages, style sheets, and themes.
- Experienced in Database Tuning and Performance Monitoring.
- Developed test specification, test plan, test cases and test report.
- Create DTS using SSIS to reverse data from new CLAIMS database to BOA legacy Claims database for reporting purpose.
- Worked with the testing team during the QA activities.
- Use VSTO to create Word and excel documents for different report from new CLAIM system.
- Use share point server 2010 to manage development related documents.
- Fixing existing bugs in new CLAIMS system.
- Create online reports and dashboard applications for CLAIMS system using SSRS and provide users training to use those efficiently.
- Used Telecommunication Billing and Invoice Reconciliation Systems.
Environment: Microsoft .NET Framework 4.0, MVC2, ADO.NET, C#, SQL Server2008, SSIS, SSRS, TSQL, VB Script, Visual Studio, VSTO, JQuery, JSON, JavaScript, Toad, Unit Testing, Microsoft Team Foundation Server, Microsoft Visio.
Confidential,
CA August 2009 – February 2011
Lead Developer
Projects:
Compromised Customer Information Mgmt (CCI)
Regional Resource Planning (RRP)
ATM Hardware Reporting
ETL Process Maintenance feed from to Host (Main Frame)
Responsibilities:
- Involved in Design & Development of all new reports using ASP.NET, JavaScript AJAX, master pages, style sheets, and themes in Presentation layer, and C #in Business Layer and MS-SQL Server in Database layer.
- Designed the Object Oriented Design and Entity Relationship Model using Visio 2003.
- Designed the database for MPP and CCI Mail merge enhancements using Visio 2003.
- Used ASP.NET GridView and ChartFX Controls to display data in a customized format in the ASP.NET web pages.
- Enhanced existing reports basing on the new business requirements.
- Converted ATM Hardware reporting written in SQL Server Reporting Services to custom application.
- Worked on Web Page design.
- Experienced in Database Tuning and Performance Monitoring.
- Enhanced Compromised Customer Information Mgmt (CCI) to provide the Mail merge feature.
- Successfully implemented Managing Premier Performance Online
- Worked on exporting the reports to Word, excel and PDF formats.
- Worked closely with the testing team during the QA activities.
- Used XML PDF for report conversion to PDF format.
- Create online reports and dashboard applications for different applications using SSRS and provide users training to use those reports efficiently and timely.
- Use VSTO to create Word and excel documents for reports and mailing letters to customer.
- Worked with Telecommunication Billing and Invoice Reconciliation Systems.
- Use share point server 2007 to create workflow and to manage development related documents.
- Developed Stored Procedures in MS-SQL Server 2005. Also involved in the performance optimization of existing database objects.
- Developed test specification, test plan, test cases and test report.
- Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
- Enhanced the performance of the company’s Oracle environment by providing advanced database tuning and performance monitoring and coding standards.
- ETL Process Maintenance feed (daily, weekly, and monthly) from to Host to Oracle/SQL using NDM and Informatica and SSIS.
- Database Maintenance and Administration including back-up, recovery plan (SQL 2000/2005/2008)
- Rewrite VB6 application to .Net one, and for sometime use CCW, to use business logic COM components wit callable wrapper.
Environment: Microsoft .NET Framework 2.0, MVC, ASP.NET, ADO.NET, C#, VB6, CCW, VB.Net, Microsoft SQL Server 2005/2008, Oracle 10g, DB2, SSIS, SSRS, VB Script, JQuery, VSTO, JSON, TSQL, CRM, JavaScript, Toad, NDM, Informatica, Chart FX, XMLPDF, XML SPY (Altova), Microsoft Visual Studio 2005/2008/2010, SQL Server Reporting Services, Unit Testing, Microsoft Team Foundation Server, Microsoft Visio 2003.
Confidential,
New Haven, CT March 2008 – April 2009 Sr. Software Engineer
Responsibilities:
- Developed an application which will upgrade data and database from Ikonisys20 version database to Ikonisys21 with converting related images using SSIS, C# and WinForms.
- Worked as a team member to enhance and supporting Ikonisys Image Viewer.
- Did routine performance tuning slow queries.
- Code new objects (programs) to meet the requirements.
- Worked on Web Page design to meet the requirements.
- Worked with java script, AJAX, master pages, style sheets, and themes.
- Design transactional and dimension databases to meet the requirements.
- Developed SQL 2005 reports as per user requirements.
- Developed test specification, test plan, test cases and test report.
- Did requirements gathering and analysis and system design with Altova UModel (UML).
- Extensive experience with UML using Business Process Diagrams, Flow Charts, Context Diagrams, Use Cases, Use Case Diagrams, Sequence Diagrams.
- Developed necessary Data Transformations packages (SSIS).
- Strong SQL Server Development skills including writing Transact-SQL (T-SQL) Queries, Stored Procedures, Triggers, User Defined Functions (UDF), Views, Indexes, and User Defined Data Types.
- Experienced in Database Tuning and Performance Monitoring.
- Created a database access layer component. This made application independent from backend database.
- Create necessary reports using SQL 2005 Reporting Service for researchers and trained then to use it.
- Maintained and Administered Database including back-up, recovery plan (SQL 2000/2005/2008).
- Create online reports and dashboard applications for different applications using SSRS and provide users training to use those reports efficiently and timely.
- Developed Biology “Sample Management System” application.
- Use VSTO to create Word documents for reports.
- Use share point server 2007 to manage development related documents.
- In all development and maintenance work, I have to strictly follow FDA rules and regulation.
Environment: C#, Visual Studio 2008, Visual Studio 2005, ASP.Net 2.0, ADO.NET, SharePoint, Visual Studio, JavaScript, WinForms, Webform, Team Foundation Server, VSTO, Remoting, Design Patterns, Agile Methodology, and Test-Driven Development, NUnit Unit Testing SQL Server, TSQL, XML SPY (Altova), NHibernate, SSIS, Analysis Service, UML (UModel), SVN.