Sandhya Lankalapalli

acxfhg@r.postjobfree.com

Phone: 612-***-**** (cell)

Strengths:

•12+ years of IT experience in supporting Client Server applications using Java, C, Visual-Basic on Windows Platform.

•Experience working in DB2, Oracle Clinical, SQL Server 2000 and 2005 and Access databases and in healthcare industry.

•Experience with Joint Application Design (JAD) sessions, test plans and test cases.

•Experience in supporting Share Point web applications, monitor and maintain their performance using Moss2007 and Microsoft office 2007.

•Experience in analyzing business requirements and demonstrated effective solutions, acted as Business Analyst in some projects.

•Strong SSRS, SSIS, DTS, ETL and Quality Assurance methods as Systems Engineer.

•Strong organizational and communication skills, analytical and problem solving skills

•Strong leadership qualities, Customer contact and community outreach skills.

•Experience in different industries like health care, financial and banking industry.

•Experience in Testing with Rational Clear Quest, HPSM, JIRA etc for bug tracking and problem solving, incident management etc.

•Prioritize and work in fast paced work environment with tight deadlines in production support environment and Agile methodology.

•Experience working in Visual Café, Clear Case and Microsoft Visual Studio 6.0.

•Trained in MOSS 2007 (SharePoint), Oracle, SQL Server, DB2, Teradata, Metadata, SQL*Plus, PL/SQL, TSQL, Stored Procedures, Rapid SQL, Java 2.0, HTML, XML, VBA, VB, Visual Basic, .Net Framework 3.5, MS Visio, MS Project, Biztalk Server, BIDS, CRM Dynamics, Autosys, TWS, Tivoli, SSMS, SSAS, Data warehouse, BCP, Disaster Recovery, Tableau, Tortoise, Pivot tables, vlookup, macros, powerpoint

•Multi Lingual and excellent communication skills.

Technical Qualifications:

•Masters Degree in Business Administration. MBA - Finance.

•Post Graduate Diploma In Computer Applications. PGDCA.

•Bachelors Degree in Engineering. BE

Achievements:

•Sun Certified Programmer for Java 2.0.

•Microsoft Certified Professional in Visual Basic.

•PMP Certification in progress

Professional Experience

United Health Group

Lead BI Developer June ‘16 - Current

•Predict emerging customer needs and develop innovative solutions to meet them

•Solve unique and complex problems with broad impact on the business

•Develop and manage complex projects and business plans to achieve objectives

•Lead BI projects specifically for Treasury, Physical Health, Optum data etc

•Collaborate with quality assurance team to ensure testing efforts align with system deliveries and business processes

•Assist in managing and coordinating all production related activities with business and a team of offshore resources

•Provide leadership in critical production issue resolution both Priority 1 and Priority 2

•Responsible for 24x7 application availability for production issues.

•Ensure timely resolution of all production issues, meeting or exceeding SLA’s

•Ensure that the work delivered by the team is of high quality

•Assist Service Manager in providing management status reports weekly and monthly basis.

•Conduct or facilitate root cause analysis on all in-scope incidents and recommend a corrective action plan

•Predict emerging customer needs and develop innovative solutions to meet them

•Solve unique and complex problems with broad impact on the business

•Deploy and maintain Applications / Systems, statistical analysis, creating Reports, trends, data analysis, data modelling and ETL .

Wells Fargo Home Mortgage Jul‘15 – April’15

Analytics Consultant

•Worked in Wells Fargo Home Mortgage, experience with Banking, Financial and Mortgage industry. Performed Risk Analysis and dealt with Audit issues in Bankruptcy.

•Collaborated with different teams, interaction with clients to develop solutions and manage the Project, budget, Joint Application Design sessions and allocating resources.

•Extensive experience in reporting tools Tableau, SSAS, SSIS, ETL, SSRS, Analytical Reports, creating Subscriptions and exporting them to Share point site.

•SSRS Reporting experience, Analytics and Statistics experience in Bankruptcy and Home Equity areas of business. Gave Presentations to Leadership and created statistical and risk based reports using Tableau visualizations, maps and dashboards.

•Maintenance and Production Support of Bankruptcy Applications. Worked extensively on ticketing system, assign and follow-up on tickets, make sure the ticket is completed on time without any issues, tracking defects and incident management and resolution in the tracking system JIRA.

•Knowledge and understanding of data flow diagrams, data transformation and data integration, packages using SSIS tools. Created various packages and scheduled jobs in Home Equity.

•Relational database experience in SQL Server as well as DB2 and Oracle. Used SQL stored procedures, data sets, Rapid Sql, Visual Studio, Excel, Access.

•Ability to work across multiple lines of business leading large scale initiatives and large data and metadata. Experience with all phases of SDLC.

•Review peers code and make recommendations on improvising code, efficiency and performance of the program. Managed and mentored other developers.

• Bankruptcy and foreclosure departments needed me to analyse data for their business needs...to make statistical analysis, to see the business progress, to estimate the growth and future of certain business processes and to compare different projects..etc

• Connected to spreadsheets and SQL database, Accessed data with few easy clicks. Combined disparate data sources without writing code. Created spot visualizations and graphs for the Business. Used Tableau desktop to build fast adhoc reports and exported to Server for the business users.

United Health Group – Optum Health Dec ’14 – July '15

Sr Apps Programmer

•Extensive experience with Visual Studio, ASP.Net, VB, C#, Sql Server database

•Maintaining SSIS packages, jobs, SSRS Reports, share point dashboards and create subscriptions.

•On Shore and Offshore model of working and collaborate with multiple teams, JAD sessions.

•Extensive experience in production support and ability to troubleshoot, root cause analysis, debugging code and fixing issues

•Development of C# code and ASP.Net applications like Physical Health Application.

•Project management and assigning duties and guiding offshore and Jr. developers.

•Experience with system testing, writing test cases, test plans, and interaction with Customers to provide solutions they need and for UAT/ user testing.

Wells Fargo Insurance Aug‘10 – Dec’14

Programmer Analyst

•Extensive experience in reporting tools, SSRS, Analytical Reports, created Subscriptions and exported them to Share point site.

•Experience with Excel advanced level and expertise in Mathematics.

•Experience using various tools like TOAD, SSAS, Tableau etc

•For Flood Insurance group, I have created Tableau reports for senior leadership.. the reports shows the flood zone areas in US and helped the business make data driven decisions and estimates for flood insurance premiums etc... Worked on regressions and Correlations.

•Created interactive presentations and cool dashboards, which in turn helped in forecasting. Using Tableau reduced the time of development and it was much faster compared to SSAS. Also have experience in creating OLAP cubes, dimensions and measures using SSAS tabular... Created SSIS packages, used T-SQL, wrote stored procedures, CTEs and created SSRS Reports on share point server.

•Analyzed and Created SSIS packages to automate manual billing cycles for Flood team.

•Integrated Billing functions that needed technology refresh, allowing administrators to view the rules as needed.

•Lead Change management and compliance rules articulation per project guidelines.

•Communication with business users, vendors, operations team as needed.

•Worked with business users and created requirement documents, designs and flowcharts.

•Lead projects, resource planning and estimation and ensure they are completed within timelines.

•Extensive experience with Visual Studio, ASP.Net, VB, C#, Sql Server database

•Created Invoice templates and did ongoing maintenance for operations team.

•Participated in BCP, Disaster Recovery and Audit programs.

•Maintenance of SCOM - System Center Operations Manager on a daily basis, finding the issues on different servers and resolving them.

•Supported Biztalk application (Flood Insurance) and CRM Dynamics Call Center application.

•Wrote test scripts and test cases, did manual testing for the windows and web applications.

Univita Health, Inc (Health care) Nov'09- Aug ‘10

Operations Analyst

•Developed and supported HealthEZ, America's PPO and TPA web applications.

•Developed web pages and web parts in a website using C#.net based on the requirements and designed the presentation layer using AJAX.

•Experience in trouble shooting and resolving problems in the financial system of the company which is a Windows based application used by the internal users.

•Database maintenance including writing queries, scripts and stored procedures using T-Sql, Query Analyzer and SQL Server Management studio.

•Provided excellent customer service to the application users depending on the helpdesk tickets, prioritizing and fixing issues on time.

•Participated in the development and discussion meetings in IT team to coordinate next steps in the SDLC of the projects.

•Developed schedules and plans to set project deadlines, worked in all phases of the project lifecycle including testing and implementation phases.

•Participated in the analysis, code review, testing and documentation of various versions and releases of different applications using waterfall, iterative and Agile methodologies.

Environment: Windows XP, Windows Server 2003, SQL Server 2005,SSIS, SSRS, MOSS2007,Visual Source Safe, Visual Studio.Net, ASP.Net,C# and VB.Net, WSS 3.0.

Wells Fargo Home Mortgage Jan ‘09 – Oct ‘09

Systems Engineer

•Developed schedules and plans to set project deadlines, worked in all phases of the project lifecycle including testing and implementation phases.

•Participated in the analysis, code review, testing and documentation of various versions and releases of different applications using waterfall and iterative methodologies.

•Supported Rush-3 step refinancing project as a systems engineer. Fixing the problems or issues that the users have with loans.

•Writing SQL scripts and stored procedures to do database fixes.

•Doing uploads, manual uploads, sending loans to main frame, communication with LIS.

•Resolving eligibility issues, working on HARP loans, making HERA/HOEPA Compliance changes.

Contact this candidate