Database Analyst/ Software Engineer

PROFESSIONAL SUMMARY

• An I.T. Professional with over 12 Years of extensive experience in Information technology building Client/Server, Internet and Intranet application business applications. Strong emphasis on database designing, stored procedures writing, object-oriented technology, reusable/maintainable software and other web technologies.
• Solid Experience in client server and multi-tier architecture projects using C .NET, ASP.NET, ADO/ADO.NET, VB .NET, Visual Basic, JavaScript, XML, XSL,SQL Server 2000/2005,2008,2012, Oracle 10g, SQL Server Integration Services SSIS ,SQL Server Analysis Services,SQL Reporting Services, PostgreSQL,PgAdmin,Solr,Nutch,Drupal CMS,Crystal Reports, C/C , Assembly 8086/8051 , FORTRAN,Pascal, COBOL, Java,PHP, Cold fusion, PROGRESS db,Postgress, MS ACCESS, DBase and HTML.
• Proficient in requirement analysis, system design, development and application systems, database design and development, and Object oriented design UML and Programming skills.
• Extensive experience of writing Stored Procedures, Views, User Defined Functions, Triggers and Indexes in SQL Server 2000/5.
• Knowledge and experience of working with VB 6/5 and Active X Controls.
• Also have programming experience with AJAX1.0 and Web Services.
• Experience of working on different operating System including Windows NT4.0 Server/Workstation, Windows 2000/3 server/workstation, Windows Vista, Windows NT 3.51 Server/Workstation, Windows 95, Windows 98, IBM AS/400.
• Also worked on Host Integration Server, Microsoft Visual Source safe, PVCS tracker.
• Involved in Epicor ERP implementation and Customizations.
• Invovled in designing the DataWarehouse , DataMart and OLAP cubes for IBM Cognos using Framework Manager, Report Studio and TM1.
• Knowledge of Software Development Life Cycle and methodologies.
• Prepared Requirements Documents, Design Documents and Test Plans.
• Demonstrated ability to identify root causes of problems, consider both the long and short-term impact of proposed solutions and develop workable solutions. Ability to manage Multiple project tasks with changing priorities and tight deadlines. Ability to work well in a team. Open to Team related tasks, team meetings, team interaction and conference calls.
• Direct Interaction with customers. Clear written and oral presentation of ideas, proposals and concepts. Ability to articulate alternative solutions. Strong listening, interpersonal analytical skills.

TECHNICAL EXPERIENCE

• Technologies ASP.NET 3.5/2.0/1.0,ASP 3.0,.NET Framework 1.1/2.0, Ajax1.0, Web Services, SMTP, ActiveX, Active Directory, Share Point, Classic ASP VBScript, JavaScript .
• Programming Languages: C , VB.Net, Visual Basic 6.0, C/C , Java, Cold Fusion Pascal and Assembly 8086/8051 ,PHP.
• Scripting Language: JavaScript, VBScript,Jquery.
• Markup: HTML/DHTML, XML/XSLT, CSS.
• Development Tools: Visual Studio 2005 and 2003, Visual Studio 6, MS FrontPage 2000,PgAdmin
• Database: SQL Server 2005/2000, Oracle 10g, Progress database, MS ACCESS and dBase,Postgres.
• Reporting Tools: SSRS,Crystal Reports XI.
• Operating Systems:Linux, XP, 2003, 2000, Vista, IBM AS/400.

PROFESSIONAL EXPERIENCE

Confidential

Software Engineer/Database Analyst

• Part of Epicor,ERP, implementation and customization team. Rigorouly worked with different team to address the organizational and security needs. Customized Epicor core functional units, using BAQ,BAM, Quick Searches, also customized reports using crystal reports and SSRS.
• Also Involved in designing and implementing Data Warehouse and Data Mart using IBM Cognos BI tools called framework manager, Report Studio, Workspace and Workspace Advance. Also worked on data warehousing tool called TM1 to fulfill the budgeting and forecasting need here at Globecomm.
• Also worked on setup/installation and maintenance of Postgres 9.1.11 on Linux/Ubuntu 12.04, with emphasis on right securities to right network group, maintained in 'pg hba.conf' file. Wrote multiple transactions-based stored functions to provide the required functionality with error handling and logging. Effectively used PgAdminIII as a graphical interface to database, have used built in monitoring tools like 'pg stat activity' to keep an eye on processes. Did database backups and restore between multiple test databases. Used EMS database comparison tool for postgres,'dbcomparer',to track the changes and synchronize them. Worked on postgres linked server by adding extension called 'dblink'.
• Worked on Sql server 2012, database development phase and did all the required schema changes along with writing transaction based stored procedure with error handling and logging. Also as part of database maintenance used 'Redgate Sqlcompare' to monitor schema and data changes between different databases.

Confidential

• Helped medical billing agency to make it HIPPA compliant.
• Also worked for Jannah.com and have used different Drupal modules extensively.

Confidential

Consultant/Web Developer

Projects:

• Texas department of state health services
• Newborn Hearing Screening Data Management for Washington health services
• National Newborn Screening and Genetics Resource Center NNSGRC
• Involved in secure HL7 compliant, web application for entering demographic and specimen information, and was responsible, along with other team members for database creation, stored procedure writing/maintenance using Sql server 2005. Also designed front end and business layer using Microsoft .Net Framework 2.0/3.5, C , CSS, ADO.NET,Ajax ,Xml/Xslt, java scripting and Microsoft enterprise blocks for data access layer. Also involved in complex data imports into Sql server 2005 using SSIS, and text file as data source.

Confidential

Programmer/Analyst

• Developed intranet project using Microsoft .Net Framework 3.5/2.0,Sql server 2005, C , ajax, ado.net, client-side java scripting, web services, CSS, XML/XSLT,Active directory, .Net email service and more.
• The existing intranet at wafcorp was made in coldfusion. In order to incorporate .Net piece, Iframe was used. There was an autosuggest set of information just like google suggests for getting the list of employees in the organization. That piece used web services, synchronous Ajax.
• Redesigned the cold fusion reports using macromedia dream weaver. It has SQL server 2000 at the back end and modified stored procedures accordingly.
• Documented the specs for CRM Customer Relationship Management database build. E-R diagrams for different objects in the database and then built the database for the replacement of Goldmine CRM for their marketing division.
• Worked on Absolutenm Content management System for mysln.com web project that uses C , AJAX Toolkit, SQL Server 2000 and ASP.NET
• Worked with the web designer team to put the customer feed back functionality in their retail site using C .

Confidential

Senior Developer-Consultant

Projects

• Designed complete application for furniture store including inventory control and order replenishment for the whole line of their products. Created database using SQL server 2000, did normalizations of different tables. First did screen mock-ups and wrote functional spec. Next, designed the architecture and detailed design spec, and then created web pages using ASP.Net as front end tool and Vb.Net as middleware tool. Also wrote T-SQL stored procedures, trained people and wrote user manual.
• Developed Automatic order replenishment system for a warehouse. It includes tracking status of different items for ordering. Created normalized database using SQL server 2000, wrote stored procedures to handle business/functional logic. Created Front end using ASP.Net, used Vb.Net to handle business logic, used Crystal report to handle different reporting needs. Documented it and also trained the staff about its usage.

Confidential

Senior Programmer/Database Developer

• A reporting application that provides statistical and analytical information for the Stores sales. This software contains multiple sub-applications with legacy portions written in Classic ASP in VBScript/JScript, and most newer portions written in ASP.Net 1.1 Visual Studio 2003 in VB.Net.
• Developed, implemented and maintained multiple relational databases using DTS technologies and linked server between SQL server and db2.
• Experience in working with Host integration server in setting up connectivity between SQL server and AS400/DB2 for data insertion and selection.
• Responsible for real-time data deletion and updating and inserting in AS400 using SQL server as middle ware and ASP.NET as a front end designing tool.
• Responsible for Troubleshooting and backup/replication of databases.
• Database backups and restores, exports and imports, and disaster recovery.
• Software development process including collecting business information requirements of user departments.
• System tuning and reporting.
• Created Stored procedures and user defined function in order to aid in the application using T-SQL.
• Set up IIS for multiple intranet applications.
• Created multiple Desktop/WEB for user data input and reports using VB.NET and Crystal reports.
• Converted Access databases into MS-SQL databases and dealt with many data conversion issues.
• Also worked in Java and Java applets and used JDBC for connectivity to AS400 for different application support.
• Used MS-Access and created queries, forms and reports that were utilized across intranet.
• Implemented financial equations into queries, forms and reports.
• Created professional, sophisticated and easy to use reports for senior management.
• Created multiple interfaces for user to input data.
• Created documentation of work.

Confidential

Software Engineer

• Developed a GUI based Human Resource system for Pakistan Refinery in client/Server Environment that runs under TCP/IP protocol on Windows NT using PROGRESS database.
• Time Management system for KPMG Pakistan.
• Reporting System for KPMG Pakistan.
• Database Designing, database Implementation.
• Data Administration, Database Management.
• Data Migration, Post deployment Services.
• Involved in Web Crawling project that gets its information from traveling sites using Apache NUTCH, used APACHE SOLR for indexing data and mySQL for data storage on top of Apache Tomcat Also did Facebook data retrieval by using FaceBook OpenGraph API in PHP.
• Learnt Data mining techniques with emphasis on data warehousing.

Confidential

• Designed PC based cable tester in collaboration with ABM InfoTech Karachi, this cable tests the data signals for different types of cables types, in that Project C is used as programming tool.
• Developed a text Editor in Turbo-C/Visual Basic with standard features.
• Designing and Implementation of 8088 based system in that project using Assembly/i86 was used as programming tool.
• Worked on Image handling application in VB which used to handle different resolutions of images.

ADDENDUM:

Data Mining

• Search Engine/Information Retrieval Systems
• Computer Communication Network
• System Programming
• Computer Architecture and Organization
• Theory and Application of Microprocessor
• Computer System Modeling
• Data Structures