EXPERIENCED IT PROFESSIONAL

7 years of full time work experience in all aspects of software development life cycle (SDLC) with experience in finance, education and government sectors. Experienced in Database Architecture Design, Data Warehousing, Business Intelligence, SQL Programming, Web Services using XML, Database Development, ETL/SSIS/DTS, Reporting, Web Development, Web Design and Enterprise COTS tools

PROFESSIONAL TRAINING

SAP - Business Objects XI R3Nov 2008
Successfully completed SAP Business Objects online courses (72 hrs) in Designing Universes, Infoview, Web Intelligence, Building Reports, Crystal Xcelsius 2008, Advanced Universe and Querying Techniques

TECHNICAL SUMMARY

• DatabaseManagement:Microsoft SQL Server (2000, 2005, 2008), Microsoft SQL Server Integration Services (SSIS/DTS), MySQL, MS Access
• Business Intelligence: Business Objects XIR2: (Infoview, Web Intelligence, Desktop Intelligence, Universe Designer, Xcelsius 2008, QAAWS, Live Office), SQL Server Reporting Services (SSRS), Crystal Reports 2008
• Programming Languages:T-SQL, ASP.NET, VB.NET, Java, JSP, XML, C, C++, ASP, PHP, JavaScript, ActionScript, Lingo, HTML, XHTML, CSS
• Web Servers Apache, Tomcat, IIS
• Applications: Microsoft Office, Microsoft Project, Microsoft Visio, Adobe Flash, Adobe Director, Adobe Photoshop, Adobe Illustrator, Adobe Premier, Adobe Dreamweaver, Microsoft FrontPage, UML (Rational Rose)
• Development Environments: Microsoft Business Development Studio, Microsoft Visual Studio, Java Netbeans, Borland C++
• Operating Systems:Windows (XP, Vista, 7), Windows Server (2000, 2003, 2008)
  

FULL TIME WORK EXPERIENCE

• Data architecture, design and implementation of the SC DOR Business Intelligence database
• Develop schemata for financial, transactional, operational and informational data sets
• Design and create tables, views, data marts, indexes, functions, custom functions and stored procedures
• Design and implement normalized and de-normalized entity relationship models
• Design Business Objects Universes using contexts, alias tables, derived tables complex SQL objects and filters
• Create list of values (LOVs), hierarchies, conditional objects, prompts, contexts, derived tables and alias tables
• Create static, drill down, cross tab and ad-hoc Web Intelligence reports
• Program custom reports based on freehand SQL involving complex joins and sub queries
• Create complex reports with ad-hoc filters, prompts, sorting, ranking, cumulative calculations and sections
• Use Query as a Web Service (QAAWS) Business Objects tool for creating dynamics and complex dashboards
• Design star and snowflake schema for OLAP cubes
• Program triggers, cursors and maintain data integrity with constraints
• Manage and Assign SQL Server security by assigning roles, logins and permissions
• Write custom SQL scripts for data extraction, data testing and implementing data checks
• Design, test, deploy and monitor ETL/SSIS/DTS processes for data loading and refreshing
• Utilize SOAP Web Services( WSDL and XML) and ETL processes to consume and load data
• Creation of agency wide operational, performance, trending, analytical and financial dashboards
• Develop high profile time critical reports with extensive data checks, notifications and rollback options
• Design dynamic SSIS packages with checks and standards in place to prevent and fix data issues promptly
• Analyze business requirements, make data decisions and resolve data issues
• Data integrity, consistency and unit testing against source files and mainframe systems
• SQL Server job scheduling, monitoring, support, troubleshooting and communication for more than 50 jobs
• Create and resolve helpdesk support tickets for production data and report issues
• Involved in process analysis, design, development, implementation, testing and support
• Create test scripts for data and report testing for use for User Acceptance Testing
• Maintain documentation, process flow Visio charts and reports on SharePoint site

• Installed, configured, customized and maintained COTS Taxmaster audit tool
• Implemented the tool successfully for 12 tax types, ahead of schedule
• Designed, tested and implemented audit case templates for various tax types
• Created detailed documentation for various software modules and functions
• Trained users in using the software and its various components
• Designed and tested automated forms for various tax types based on user requirements
• Regularly maintained and uploaded template packages for automated software update on the FTP website
  

• Installed, configured, customized and maintained various COTS enterprise tools
• Implemented case and correspondence modules for various tax types
• Installed new releases of COTS Dtax - Data Warehouse tool on Development, Test and Productions Servers
• Custom programming in Java to extend the functionality of COTS products
• Installed and configured SQL Server Reporting Services (SSRS)
• Successfully resolved critical issues with the installation of Audit Workbench COTS case management tool
• Created on-demand reports and scheduled reports to user inbox using SQL Server Reporting Services
• Created custom selection views in SQL server for various tax and audit programs
• Documented various processes including timelines, risks and responsible parties
• Prepared UAT scripts for testers of various case and correspondence modules
• Worked with the users and the IT support team to resolve productions issues
• Involved in business requirement gathering, development, testing, deployment and support of various modules

Confidential, Jalandhar, India. (Developer/Team Manager) Mar 2003 - Jul 2004
(Multimedia Project, Web Portal using ASP.NET, VB.NET ASP, SQL Server 2000, Flash and Director)

• Designed and developed custom .NET classes and user controls using ASP.NET and VB.NET framework
• Used N-tier architecture for presentation, business and data access layers using VB.NET
• Designed web pages using grid views with sorting and paging utilizing ASP.NET MVC framework
• Created ASP.NET pages using master pages, validation controls, cookies and session variables
• Utilized ADO.net (Windows Communication Foundation-WFC data services) to build data access components
• Used login controls and ASP.NET membership class to secure ASP.NET pages
• Programmed stored procedures and triggers using T-SQL in SQL SERVER 2000
• Developed normalized relational database model
• Designed modules for course management, content creation/editing and user access
• Testing and deployment of applications on test and production servers
• Installation, configuration and support of IIS and .NET runtimes
• Created technical documentation covering the module changes and improvements
• Planned designed and developed multimedia educational CDs
• Scripted the multimedia CDs using Action script and Lingo
• Built audio, video, and image libraries and a custom question builder application
• Determined level of effort for various assignments and plan project timelines
• Trained employees and developed work flow processes dividing work clearly among various teams
• Organized team meetings to discuss work progress and to resolve issues
• Created budget estimate and schedules for product/module delivery
• Made checklists and guidelines for checking content quality and errors
• Developed and maintained work assignment and work tracking sheets
• Created quality analysis/ maintenance standards

• Integrated data from multiple sources including Oracle 7, SQL Server 2000, XML and legacy data using JDBC
• Built web service utilizing the remoting framework tying the legacy applications with business application
• Designed web forms and interfaces utilizing Struts and Java MVC model framework and Java beans classes
• Worked with local and international teams to deploy applications to QA and production environments
• Installation, configuration and troubleshooting of Tomcat web server and Java servlets
• In charge of maintaining and updating project Wiki website
• Testing and maintaining cross browser compatibility of various online applications
• Testing of the various Java and JSP based applications
• Worked on design of the website with a corporate look.
• Creating, managing, updating and uploading test reports
• Involved in software implementation, testing and support

PART TIME WORK EXPERIENCE

• Designed the program website using HTML, CSS, JavaScript and Flash
• Conducted and taught computer software training workshops for LSU students
• Created student training material and student worker training guides
• Maintained and updated the program website based on Lotus Notes server
• Assisted in daily communication, program advertising, marketing, student training and scheduling
  

• Designed the website using ASP, HTML, CSS, JavaScript and Microsoft SQL Server
• Developed and maintained web applications in ASP.NET and Microsoft SQL Server 2000
• Lead and trained student workers in computer hardware maintenance, troubleshooting and networking
• Assisted the director in daily communications, class reservations and scheduling

INTERNSHIPS

Confidential, Punjab India Jul 2001 - Aug 2001
Duties: Worked on web application development

Confidential, Punjab, India Jul 2000- Aug 2000
Duties: Maintained and configured web server and routers

Confidential Punjab, India Jul 1999 - Aug 1999
Duties: Met prospective clients and marketed the products of the company

• Master of Business Administration - Finance, Information Systems and Internal Audit.
• Bachelor of Science - Computer Science and Information Systems.