Sr. Software Developer, Tech Analyst Resume
SUMMARY
- A conscientious and results - driven Software Developer, Technology Analyst/Lead with 7 years of experience in the field of Software Development and a Master’s degree in Computer Science.
- Have extensive experience of Web applications and Windows Mobile apps development in .Net and Microsoft technologies.
- Have excellent analytical, technical, design and communication skills. Experience in project management and managing offshore teams.
TECHNICAL SKILLS
Languages/ Framework: C, C++, C# .Net 4.5, VB .Net, .Net Framework 3.0/4.0/4.5
Internet Technologies: ASP .Net, MVC 4, WCF, Entity Framework, jQuery, AJAX, Java Script, HTML, CSS
Mobile Technologies: Windows 8 Phone SDK, Windows Azure, SQL Azure, XAML, Cloud Services
BI Technologies: MSBI 2012 (SSIS, MDX), Power Pivot, Power View, MS Excel Reports
Databases: MS SQL Server 2008/2012, Oracle, MS Access
Tools: / IDEs: Visual Studio 2012, FxCop, Visio, Erwin
Operating System: Windows, UNIX
PROFESSIONAL EXPERIENCE
Confidential
Technologies: MSBI 2012 (SSIS, SSAS), MS SQL Server 2012, C# .Net 4.5, ASP .Net, MVC 4, WCF, jQuery, AJAX, Java Script
Sr. Software Developer, Tech Analyst
Responsibilities:
- Owned the technical analysis of existing MSCloud BI ETL solution, identified the inefficiencies, proposed and implemented optimal design changes, SQL tuning which saved 50% of ETL run time and reduced maintenance cost.
- Designed and Implemented a Framework for data quality audits and Cube/Data Mart alerts on data conditions that improved the productivity of MSCloud BI Data Quality team.
- Proposed a Windows 8 Tablet app for MSCloud BI data audits to provide a cutting edge application for data quality auditing with immense mobility.
- Developed a cutting edge User Interface for Data quality audits Framework using ASP .Net and jQuery.
- Written WCF web services to communicate with various other modules to get the required data.
- Written complex SQL Server stored procedures which will cleanup data and synch data across all environments. Used AJAX controls and invoked Web Services in the project.
- Handled high volume of data, data cleansing and related issues in real-time.
- Actively involved in fixing the issues in existing applications. Actively involved in coordinating and setting up application on different environments using IIS, SQL Server, and SQL Agent Job server.
Confidential
Technologies: MSBI 2012 (SSIS, SSAS), MS SQL Server 2012, C# .Net 4.5, ASP .Net, MVC 4, WCF, jQuery, AJAX, Java Script, Windows 8 Phone SDK, SQL Azure, XAML, Cloud Services
Sr. Software Developer, Tech Architect
Responsibilities:
- Involved in requirement gathering, analysis, conducted pre-design sessions, design review meetings to get useful inputs from the end users, client managers to enrich the design of applications.
- Architected and developed Business Alerts framework which is web-based self-service alerting system in ASP .Net, jQuery and SQL Server for Microsoft Finance Business Excellence team that helps the finance business users to make the business decisions promptly.
- Proactively introduced mobility platform by leveraging Windows Phone 8 SDK, SQL Azure, MVC, WCF in Confidential, designed and developed two Windows 8 Phone apps: Business Alerts, BizOpsKPI and published in Market Place. These Phone apps saved a lot of time and brought the mobility usage of business intelligence apps for finance business users.
- Complete responsible for architecture, design of Business Alerts framework, and Windows Phone Apps.
- Responsible for entire UI/ UX design, Windows Azure accounts and deploying applications to Cloud.
- Used jQuery, Java Script, CSS extensively for much interactive UI/ UX screens for web applications.
- Used Entity Framework, WCF, & Cloud Services for data interaction from On-premise/Cloud databases.
- Designed and implemented the automation of Approval Work flow using C# .Net and Excel services for “Actual Restatement Tool” which saved 100 person hours per every monthly window across the team.
- Designed and developed Mercury Dashboard - Win 8 (Metro) style web application with BI data, which is used for Mercury shift handoff users to handoff the Shift and monitor the different audit reports.
- Maintaining Windows Azure Cloud accounts, deploying web services, SQL Azure database objects for Windows Mobile applications. Follow the security review process of deploying mobile LOB apps and submitting them to Market place.
- Maintenance of legacy BE BizOps applications and providing assistance to the business users during window time.
- Provided Weekly Status Updates and Monthly Project reports to all Business and Supporting Group Stake holders.
Confidential
Technologies: C# .Net 4.5, ASP .Net, jQuery, AJAX, Java Script, CSS
Sr. Web Developer, Tech Analyst
Responsibilities:
- Involved in requirement gathering, analysis, conducted pre-design sessions, design review meetings to get useful inputs from the end users, client managers to enrich the design of applications.
- Migrated all web applications (InRoom Agenda, Door Monitor, Media Wall) User Interface to Win 8 (Metro) UI style to provide a brand new look for Microsoft EBC applications.
- “InRoom Agenda” web app is used for presentations to Microsoft customers in EBC presentation halls. Door Monitor, Media Wall apps are used to direct the customers finding presentation halls and timings.
- Used jQuery, Java Script, CSS extensively for UI migration and developed brand new Metro UI/ UX look.
- Developed a customized Confidential Kiosk app in C# .Net which helps Microsoft customers to make business calls thru Confidential using Corp account in Microsoft EBC Confidential booths.
- Complete responsible for whole UI migration activity, deployment of all applications and User training.
Confidential
Technologies: MSBI 2010 (SSIS), MS SQL Server 2008 R2, C# .Net 4.0, ASP .Net, AJAX, Java Script
Sr. Software Developer, Tech Analyst, Project Manager
Responsibilities:
- Involved in requirement gathering, analysis, conducted pre-design sessions, design review meetings to get useful inputs from the end users, client managers to enrich the design of applications.
- Owned the complete project management, technical leading from onsite for Treasury BI project, starting from requirement analysis to production deployment and support.
- Driven mile stone SDLC meetings: Pre-baseline, Baseline, SIT, UAT, Go/ No-Go and CR management, Risk management, and published project status reports. Provided technical leadership, managed off-shore team, and tracked their progress in a systematic way.
- Architected and developed SharePoint Source data acquisition mechanism, and written custom tools in C# .Net to extract data from SharePoint lists, and rooted this feature into ETL Framework.
- Conducted SIT and UAT testing, responsible for in time Production deployment and User support.
Confidential
Technologies: MS SQL Server 2008 R2, C# .Net 4.5, ASP .Net, jQuery, AJAX, Java Script, CSS
Sr. Web Developer, Tech Analyst
Responsibilities:
- Wrote functional and design specs for “WMT 1.6.1” release, created release timeline and collaborated with other team members and stake holders to implement, test and release the tool on time.
- Designed and Developed important components and features for Wire Messaging Tool releases.
- Complete responsible for whole UI migration activity, and used jQuery, Java Script extensively.
- Wrote Parser component in C# .Net which is the major component used to parse the bank messages.
- Deployed all Treasury projects in Production without any severity bugs successfully.
Confidential
Technologies: MSBI 2008 (SSIS, SSAS, SSRS), MS SQL Server 2008 R2
Sr. Software Developer, ETL Lead
Responsibilities:
- Played ETL Lead role and designed ETL Framework for multiple source systems data extraction in SSIS.
- Requirement analysis, technical feasibility study for end-to-end ETL, Design of DW Data Model, Landing/ Staging databases. Wrote high level design, detailed tech specs, drove design review meetings with clients and other stake holders.
- Coding SSIS Packages & SQL stored procedures, code review, design review, SQL tuning, performance improvement, and troubleshooting.
- Created SIT and UAT test plans, driven SIT, UAT testing and bug triage meetings. Deployed ETL packages and scheduled jobs in Production environment without any major issues successfully. Provided technical support to Confidential team after Production move.
- Provided technical leadership to the ETL team and tracked, reported the project status.
Confidential
Technologies: MSBI 2008 (SSIS, SSAS, SSRS), MS SQL Server 2008 R2, C# .Net 4.5, ASP .Net, AJAX, Java Script, CSS, SharePoint Server.
Sr. Software Developer, Sr. Web Developer
Responsibilities:
- Requirement analysis of ETL, dashboards, web pages, and reports. Technical feasibility of Dashboards, Reports, Web pages, and Design of SSRS Reports, Dashboard. Wrote high level design, detailed tech specs, drove design review meetings with clients and other stake holders.
- Involved in Dashboards design, SSRS Reports integration with SharePoint Server using ASP .Net.
- Responsible for creating master web pages, web pages with SSRS reports and widgets in SharePoint server to integrate all reporting objects in SharePoint web application.
- Created SIT and UAT test plans, driven SIT, UAT and bug triage meetings. Deployed the SSRS reports, SharePoint web pages in Production environment without any major issues successfully. Provided technical support to client team after Production move.
- Provided technical leadership to the web development team and tracked, reported the project status.
Confidential
Technologies: MSBI 2005 (SSIS, SSAS, SSRS), MS SQL Server 2005
Software Developer, ETL Dev
Responsibilities:
- Requirement analysis of ETL, reports, dashboards, design and development of the ETL packages in SQL Server Integration Services.
- Involved in ETL strategy, creation of data mappings from Source databases to the proposed data model.
- Coding of the ETL packages in SSIS, SQL SPs, SQL tuning, and ETL performance improvement.
- Create SIT, UAT test cases, and executed test cases for SIT, and UAT. Deployed the Confidential in production without any P1 bugs. Provided technical support to client team after Production move.
Confidential
Technologies: MS SQL Server 2005, Visual Studio 2005, C# .Net 2.0, ASP .Net, AJAX, Java Script
Software Developer, Web Developer
Responsibilities:
- Requirement analysis of Confidential, technical feasibility study, Design of UI and UX snapshots for Dashboard, master page and other web site pages.
- Wrote high level design, detailed tech specs, drove design review meetings with clients and other stake holders. Driven Dashboard demo meetings.
- Coded Dashboard web pages in ASP .Net using AJAX, Java Script, CSS files for better UI/ UX look and feel.
- Wrote SIT and UAT test cases, executed test cases and deployed the Dashboard in production without any bugs. Provided technical support to client team after Production move.
Confidential
Technologies: MSBI 2005 (SSIS), MS SQL Server 2005, Visual Studio 2005, C# .Net 2.0, ASP .Net, Java Script
Software Developer, Web Developer
Responsibilities:
- Worked as SSIS ETL developer, SQL Developer in MSBI projects for different clients.
- Worked as C# developer, web application developer in ASP .Net projects for different clients.
- Initiated an idea on power consumption by implementing Shutdown Timer tool and approached with ECO and CCD teams to roll out at Org level in Infosys.
