Bi Developer Resume
Summary of Professional Experience:
Over 7 years of success in meeting critical software engineering challenges and experience in all phases of software development lifecycle. Extensive skills in object-oriented programming and has applied them to Internet and database technologies. Well-versed in the major programming languages including C#, VB.NET, ColdFusion, JavaScript, XML, Pl/SQL. Experience in Agile development methodology using SCRUM. Well versed with Oracle and Microsoft SQL Server databases. Experienced in database design (logical and physical models), stored procedures, functions and various SQL objects using TSQL and PL/SQL. Proven talent in MS Integration Services (SSIS), MS Analysis Services (SSAS) and Reporting Services. ETL development using Informatica: transformations and mappings using Informatica Designer, Data Migration from multiple sources to targets using Workflow manager. Data mapping across multiple data sources, source to target mappings, editing business rules and validating them. Strong communication, interpersonal, organizational and presentation skills matched with my excellent work ethics, hard working, enthusiasm, and quick learning capability make me an asset to the team.
Certifications:
- Oracle Certified Associate (Completed two exams)
- Microsoft Certified Professional
- Sun Certified Web Component Developer for J2EE
- Sun Certified Java Programmer 1.4
Trainings:
- SharePoint 2010 Technologies Comprehensive Introduction from Learning tree
- Oracle Databases: Application Development & Tuning from Learning tree
- Software Testing Foundation Introduction from Learning tree
Job Assignments:
Confidential January 2012 September 2012
BI Developer
- Responsible for creating Microsoft SQL Server Integration Services (SSIS) packages, scripts, and other elements involved with the data warehouse.
- Extract, transform, and load (ETL) data from various source systems to the data warehouse solving the complex technical problems.
- Created jobs for processing data and monitored activity of the jobs in various environments.
- Developed business logic in C#.
- Developed report model on SSAS cubes, as well as changing default configuration on existing cubes.
- Developed OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2008 Analysis Services (SSAS).
- Developed stored procedures, functions and made code changes to increase performance.
- Documented the deliverables such as source to target mappings and transformation rules.
Environment: Microsoft SSIS, Microsoft SSRS, Microsoft SSAS, Microsoft SQL Server 2008 R2, Team Foundation Server (TFS), C#.
Confidential November 2011 December 2011
Consultant
- Performed work on the NDS-AD (Novell Directory Services to Windows Active Directory) migration team acting as a software developer to insure that migrated applications would run correctly once the migration was completed. Applied fixes to software as necessary.
- Performed risk analysis on Sybase systems. Collected information required to fill out a questionnaire.
- Collected information on FTP questionnaire for various applications under the group I am working.
Environment: Remedy, Clear case, VB, ASP
Confidential November 2007 July 2011
Software Engineer
- Designed and developed new modules and functionality for existing applications.
- Created new database objects like stored procedures, views and SQL functions to accommodate new application functionality and for better performance
- Code, debug, unit test, systems integration test, and document new applications/enhancements on development projects as assigned.
- Developed and maintained WebForms using C# and ASP.NET
- Responsible for ongoing technical maintenance and support for assigned applications.
- Assist project manager in estimating durations for tasks, deliverables and activities.
- Meet deadlines and formally report progress regularly to IT Project Manager.
- Coding, code optimization in quality assurance point of view, code review as per the coding standards.
- Successfully upgraded legacy applications from Cold Fusion 5, Oracle 8i to Cold Fusion 8, Oracle 11g. Resolved all the issues in migration including client side JavaScript validations using JQuery
Environment: C#, ASP.NET, Cold Fusion 8, Oracle, WinCVS, Subversion, JavaScript, HEAT, SharePoint 2010
Confidential August 2006 October 2007
ETL Developer
- Worked on various modules using Informatica, SQL Server 2000, SQL Server 2005, Oracle 10g.
- Actively involved in the design and development of Database.
- Developed stored procedures and SQL functions to increase performance.
- Coded Business Logic in C#.
- Participated in Quality Assurance by testing the application and reporting the bugs.
- Developed many reports using Informatica and SQL Server Reporting Services.
Environment: Informatica, SQL Server 2000/2005, Oracle, C#, Subversion, MS SourceSafe, Microstrategy.
Confidential February 2005 July 2006
NET Application Developer
- Actively involved in the design and development of UQube.
- Designed and developed database for UQube (in SQL Server 2000 as well as SQL Server 2005).
- Developed stored procedures and SQL functions to increase performance.
- Designed and developed UI for applications using ASP.NET
- Improved efficiency by using Telerik RadControls AJAX developer tools.
- Coded Business Logic in VB.NET
- Participated in Quality Assurance by testing the application and reporting the bugs.
- Developed many reports using SQL Server Reporting Services and Active Reports.
- Developed cubes using Analysis Server for faster user experience and to generate reports from cubes.
Environment: VB.Net, DotNetNuke Framework, Dundas Software, Active Reports, MS SQL Server Reporting Services, MS SQL Server Analysis Services, CodeSmith, Telerik Rad controls, HTML, CSS, JavaScript, WinCVS, MS SourceSafe, Microsoft SQL Server 2000, Microsoft SQL Server 2005, IIS 6.0
Education:
- MS in Computer Science from Confidential University
- BS in Electronics and Communications Engineering
Technical Skills:
Languages:
C#, VB.NET, Java, XML, XSL, JavaScript, PL/SQL, TSQL
Databases:
Microsoft SQL Server, Oracle, Microsoft Access
Data Warehousing:
Informatica PowerCenter 8
Other:
.NET, ASP.NET, Microsoft SQL Server Integration Services (SSIS), SharePoint 2010, DotNetNuke Framework, Dundas Software, Active Reports, Microsoft Reporting Services, Microsoft Analysis Services, Telerik Rad Controls, Visual Studio .NET, IBM WebSphere Studio Application Developer, Eclipse, Macromedia Homesite +, Microsoft Office, IIS, WinCVS, Subversion, MS SourceSafe.