Developer/analyst Resume
2.00/5 (Submit Your Rating)
TECHNICAL SKILLS
Business Intelligence: SQL Server 2008R2/2012/2014, Power BI, Tableau, Micro - strategy
Internet Development: ASP.NET 3.5/4.0/4.5, ASP.NET MVC, WCF, Dependency Injection, WSDL, LINQ, SOAP, XML, XSD, XSL, XSLT, XPATH, CSS, JQuery, AngularJS, Bootstrap
Data: SQL Server, Teradata, Oracle, Hadoop, MongoDB, Pig, Map/Reduce
Modeling: ER/Studio, Silver Run, MS-Visio
Methodology: Scrum, FDD, TDD
PROFESSIONAL EXPERIENCE
Confidential
Developer/Analyst
Responsibilities:
- Maintain logical and physical data model for the new generation data mart in ER/Studio
- Build the new generation data mart and ETL for Facets data using SSIS, BIML, and C#
- Create reports that consume data mart using SSRS, SQL Server, SSAS, and MDX
- Resolve data integrity, locking, dead-locking, and performance issues in the database
- Perform bug fixes, and enhancements on ETL, web service, and reports
- Support critical processes that exchange data with external partner systems
- Build benefits enrollment web application using ASP.NET MVC, ADO.NET, Bootstrap, and C#
- Build risk analysis business user analytics using SSAS tabular model, DAX and Power BI
Confidential
Developer/Analyst
Responsibilities:
- Maintain Logical and physical data model for both transactional and reporting databases in ER/Studio
- Create and update DB Objects, Entity Framework, Pre-generated Views, BizTalk mapping for the workflow of Revenue Collection
- Build ETL and semi-aggregated metrics for the data mart using SSIS, SQL, and C#
- Build scorecards and dashboards using SSRS, SQL, SSAS, and MDX
- Develop in-place database upgrade scripts for the product version upgrades
- Resolve locking, dead-locking, and performance issues in the database
- Enhancements and bug fixes in the revenue cycle application using ASP.Net MVC, C#, and JQuery
- Create automated test cases for unit testing, load testing, and coded-UI testing for the revenue cycle application
Confidential
Developer/Analyst
Responsibilities:
- Maintain logical and physical data model for the costing application and data mart in Silver Run
- Build data mart and BI solution for costing solution using SSRS, SSAS, MDX, SQL, and Micro-Strategy
- Resolve data integrity and performance issues in the data mart
- Analyze impact to the existing data mart due to the re-platform of SAP instances in Finance
- Provide mappings and specs to the ETL teams (SAP-BI, Ab-Initio, Teradata) for the changes needed due to the SAP re-platform
- Create physical data model for the contingent worker request-to-allocation cycle
- Bug fixes and enhancements to the contingent worker application
Confidential
Developer
Responsibilities:
- Monitor application interface data and analyze issues for global risk systems production support
- Prioritize and execute test (integration, system, and user acceptance) based on Risk Exposure
- Interface with Experian tech team to improve the data quality of customer credit accounts
- Develop data imports using SSIS and reports using SSRS
