PROFILE

Highly skilled, detailed and results-oriented Information Technology professional with a solid experience of over 15 years. Dedicated, organized and self-directed with a keen eye on the bottom-line as well as strong relationship-building and communication skills.

Specialties:

• Data Engineer Data Warehousing, Source to Target data mapping, SQL Queries and ETL processes, analyze and evaluate data.
• Systems Design Requirements Definition, Documentation, prototyping and design.
• Project Management Scope and Approach, Return-On-Investments, Sizing Estimates, work
• breakdown, Project Plans and on-time Project delivery.
• Web Development Programming web applications using Relational Databases.

PROFESSIONAL EXCELLENCE

Service Information Developer,

Confidential

• Currently working on the Data Conversion team for the Florida Early Learning Information System ELIS . This involves data conversion from a SQL Server Legacy System to Microsoft Dynamics CRM 2011 System. Direct and advise the data conversion team on the use of SSIS to write data to CRM using CozyRoc components, participate in the review of source to target data mappings, coordinate between the data conversion team and CRM teams, implemented TFS for the source control of SSIS packages. Develop SSIS packages for the different business areas in ELIS.
• Work with a justice case management system called Justware. Write XSLT transformations to convert customer's XML Data files to the XML format that can be recognized by a Broker so as to import data into the JustWare's SQL Server database.
• Write SQL queries to extract data from the JustWare database and generate into XML data that can then be imported by into other databases using Justice Broker and SSIS.

Application Analyst,

Confidential

• Developed SSIS SQL Server integration Services packages and workflows in Informatica for the Prosecutors Data Warehouse project. This included extracting, cleansing and transforming the data from the mainframe as the source and loading it into an Oracle Data Warehouse for use by Business Objects.
• Spearheaded the complex database conversion from SQL Server to ORACLE using ETL Software such as Informatica and writing Java Programs for Access Oakland. Access Oakland is the County's most used Internet application to enable citizens to access property data, compare properties, review property documents, etc.. Migrated all the SQL Server stored procedures to PL/SQL. Used ORACLE Designer to create the tables in the ORACLE database.
• Also, leading the business analysis effort for a Time Tracking System for the Children's Village. This included developing a Requirements Definition Document by interacting with the Children's Village Staff and developing an RFP for the Time Tracking System.
• Successfully completed migration of the pay traffic tickets online application from Java to .Net and from using Mainframe as the source data to using data from IBM's DB2 database housed in the State's Judicial Information System.
• Business and Technical Lead on multiple projects such as the ePraecipe and Electronic Transfer Of Notices. This included gathering the business requirements leading to the creation of Business Specifications as well as coming up with the technical specifications. Followed the complete project lifecycle including requirements gathering, analysis, design, development and implementation of the project using .Net and SQL Server.
• In a Project Manager Role, compiled sizing estimates on key projects, developed the work-breakdown structures, created project plans in Clarity and managed projects using Clarity Workbench. Assigned and scheduled work assignments, trained and reviewed the work of the team members for the projects I managed. These include the Projects for Community Corrections and the ePraecipe filing for motions electronically , Alternate Dispute Resolutions ADR and Electronic Notices for the Circuit Court.
• Coordinated the installation of many Off-the-Shelf Applications acting as a liason between the Vendors and IT. The applications include the Campaign Finance Reporting System for the Elections Department and the COMPAS Application and Offender Link for Community Corrections. Wrote a Web Service client for Community Corrections application to talk to the vendor app COMPAS. Wrote a web service for a vendor OffenderLink to access Community Corrections Data.
• Successfully analyzed, designed, developed and implemented several applications for many County Departments namely District Court, Circuit Court, Clerk and Register Of Deeds. Examples include the District Court Probation System, Marriage Affidavit Online and the Pay Traffic Tickets online which was re-written from java and ORACLE to using .net and SQL Server.
• Lead on the support and maintenance of many mission critical Web applications in the various departments of the County primarily Ordering Birth, Death and Marriage Certificates, CSTAR for Community Corrections, Medical Examiner and application for the Animal Control Department. These are written in Java, ORACLE and SQL Server. Also supported these - Court Explorer, Oak Reports, Vitals, Court Recordings Online, etc. and other applications. Also, wrote SSIS Packages for Animal Control.
• Lead the Oakland County Live Election Reporting effort in most of the elections during the 2006, 2007 and 2008 Elections. This included getting the ASCII data from the Unity Election Reporting System, converting it and presenting it as different summary and detail reports on the County's Election Web site. Initially, for a couple of years, the reports were generated using Access and Crystal Reports, later the reports generated from Unity were published on the website. Also, generated the post-election Certificates Of Nomination and Statements of Vote reports for some elections.
• Lead on implementing the changes for the database consolidations and server virtualizations for all the applications that used the servers being virtualized and databases being consolidated belonging to the Courts Team.

Senior Programmer Analyst,

Confidential

• the support and maintenance of client server applications such as MEDDS Manufacturing Equipment Design and Description System , the PCR Process Change Request and Powertrain AMPS Automated Manufacturing Planning System . All of these were Visual Basic applications using Sybase.
• Facilitated the new development and enhancement of the existing applications mentioned above.
• Lead the conversion of applications from older to newer technologies such as converting the CGI-based Intranet Application KEY PROCESS TRACKING KPT to object-oriented three-tier architecture using Java Servlets and WebSphere. Coordinated the upgrade of several applications from one version to the next such as migrating the PCR Process Change Request Application to WAS5.0 from WAS3.5
• Researched reporting technologies for converting the existing reporting methods in existing applications to use newer methods.
• Received the Star Performer Award for successfully converting a CGI-based Intranet Application to a Java based WebSphere application called Key Process Tracking.
• Followed ISO Procedures involving creating Tasks, inputting Start and Finish Dates, inputting Estimated and Actual Time spent completing the Task, logging all the details of the Task along with the modules changed, newly created, etc. Performing Code Reviews with Team members, entering detailed Test Plans for each task, and doing Unit and System Testing. Extensive use of Version Control System to check-in and check-out files to work comfortably in a Team Environment.
• Programmer Analyst, Confidential Responsible for the Analysis, Design, Development, Implementation, Documentation and Maintenance of PC based Applications for various departments in the Bank.
• Successfully developed Application Setup Programs for two applications - IGUANA and REAL ACCESS - using Installshield.
• Successfully maintained and enhanced of some Foxpro-based applications. Collaborated with the Bank Employees Customers to analyze their manual procedures in order to develop Applications that would completely meet their needs. Applications that I developed were well received by Customers.

TECHNICAL SKILLS

• Software SSIS, Informatica, MS Visio, SQL Server Management Studio, Clarity Project Management, Sharepoint, Business Objects, Microsoft Visual Studio, Websphere RAD, Crystal Reports
• Databases MS SQL Server, ORACLE
• Languages SQL, Java, .Net, HTML, Javascript