Real Estate Data

Financial Services – Real Estate – Health Care – Telecommunications

Accomplished SQL/ETL developer with extensive experience on Microsoft SQL Server and .NET in Mortgage Servicing, Risk and Loss Mitigation, Real Estate, Health Care and Telecommunications domains. Experienced in Data Warehousing, ETL, Application Disaster Recovery testing, Building of test and Production environments and Migration of applications across Data Centers. Experience with Waterfall and Agile methodology of SDLC.

Industry Expertise: More than 10 years of progressively responsible experience in designing and developing Data warehouse, Windows and Web applications and reports for Mortgage Risk and Loss Mitigation, Health Insurance, Real Estate and Telecommunications systems.

Continual Improvement: Passionate interest in computers and IT and dedication to enhancing technical knowledge via coursework and self-study. Won steady promotions – from Software Engineer to AVP of applications – for continually improving internal risk and loss mitigation systems.

AREAS OF EXPERTISE

Data Warehousing

Data Governance

Data Quality and Control

Internal/External and SOX Audits

Deployment/Migrations

Change Management

Disaster Recovery

Virtual Teams

Devops

Microsoft Technologies

ETL – SSIS, BCP, Bulk-load

T-SQL Programming

TECHNICAL SKILLS

ETL/BI Reporting:

Microsoft SQL Server SSIS, SSAS, SSRS, Informatica,

Database:

Microsoft SQL Server 2012, MS-Access, ADO, Oracle (PL/SQL), Teradata (SQL Assistant)

Programming Methodologies/Tools:

Waterfall, Agile, Team Foundation Server, Rally, Microsoft Visual Studio 2008, Visual Interdev

Web/Network Technologies:

.Net, Web Services

Programming Languages:

C#, VB Script, SQL, .NET

AWARDS

Gold and silver awards for outstanding performance and commitment at Bank of America.

EDUCATION & TRAININGS

Master of Computer Applications, Sri Venkateshwara University, Tirupati, A.P., India.

Bachelor of Science, Andhra University, Visakhapatnam, A.P., India

PROFESSIONAL EXPERIENCE

Bank of America

Role: Assistant Vice President Aug 2015 – May 2017

Cons Prod Strat Analyst III Nov 2012 – Aug 2015

Bank of America is a financial institution, serving individual consumers, small and middle market businesses, corporations and Governments with a range of banking, investing, asset management and other financial and risk management products and services. The Company provides a range of banking and nonbanking financial services and products through five business segments: Consumer & Business Banking (CBB), Consumer Real Estate Services (CRES), Global Banking, Global Markets and Global Wealth & Investment Management (GWIM).

As a SQL/ETL Developer in Global Risk Analytics (GRA) group I designed, developed and supported data warehouse along with 4 other team members. The data warehouse (called CLMS) sources, refines, aggregates and provides most accurate and relevant data for several modeling and downstream applications. Organized, lead, documented and supported data governance, data quality, data control and SOX audits.

Key Accomplishments:

Designed and developed ETL to handle high data volumes – 5 different platforms, 10+ source applications, 150+ files, 450MM+ records per monthly load for a data warehouse over 2 TB in size.

Optimized data provisioning processes by automating manual tasks that reduced the turn-around time up to 2 days in certain cases. Met all SLA agreements 98% of time by streamlining and stabilizing production process.

Improved data accuracy by up to 14% by developing new and optimizing existing methods to measure data quality and reasonableness of data.

Conducted/lead monthly Data Governance meetings with line of business and downstream systems. Represented as key technology SME on quarterly and annual SOX/technology audits with external and internal audit teams. Coordinated with offshore team on development and maintenance projects.

Rapattoni Corporation Mar 2011 – Nov 2012

Role: Programmer (Full-time Employee)

Rapattoni is the nation's leader in management information software for real estate associations, with more than 250 installations nationwide. Rapattoni’s association-management customers represent more than 85% of the membership of the National Association of Realtors®. Rapattoni provides an array of integrated products and services for real estate associations and MLS organizations, including Internet MLS systems, association management software, and Secure Logon two-factor authentication services.

As a SQL/C# programmer, I designed and developed several reports on a home-grown custom platform/framework built in C#/.NET with SQL database as a backend. These reports feed property searches on many popular real estate websites and mobile platforms that are used by 1000s of realtors nationwide.

Key Accomplishments:

Delivered 30+ custom reports for 8 MLS websites during 18-month tenure by directly working with client-SMEs.

Designed and developed 20+ SSIS packages to pull necessary data for data mart to build monthly reports for billing and reconciliation.

Streamlined Dev-Ops processes to reduce turn-around time by 18% to provide production fix.

Worldwide Telecommunications, Inc. June 2010 - Feb 2011

Role: Developer (Full-time Employee)

Worldwide Telecommunications, Inc (WTI) offers telephone communication services to business including toll-free telephone services, international and domestic calling and payphone using state of art technology.

As a SQL Developer, I enhanced existing and developed new processes to collect telephone call details and designed rule-based billing procedures to chargeback clients based on usage. Built data mart and developed reports for internal and external use.

Key Accomplishments:

Developed data sourcing procedures to handle 5MM+ monthly call details for 6 different clients. Enhanced existing stored procedures to meet changing business needs. Developed 8 new reports for Accounts Payables and International Billing.

Automated complex billing procedures that reduced billing-errors by 18% and generated bills 2 days sooner.

Enhanced several stored procedures to handle transition from legacy TeleCount to new IVR.

Processed monthly billing and ensure timely delivery of invoices to clients.

Employer: IQ Systems, Inc (www.systemsiq.com)

Client: SAP GRC, Fremont, CA Oct 2007 – Oct 2009

Role: .Net Developer (Contractor)

SAP GRC Access Enforcer incorporates a customizable, workflow engine that provides business owners with simple role definition, simulates compliance issues in the SAP production system before approving the request, automatically provisions/ de-provisions access changes into multiple SAP systems, and provides self-service password reset functionality for users.

Key Accomplishments:

Developed an internal tool (query updater) to improve the productivity of developers that saves 15% of total development time.

Implemented 3-tier design (UI, Business Logic, Data Access Layer) in Access Enforcer application to minimize dependency of one layer on the other. Data access layer supports both Oracle and SQL Server databases.

Client: Humana Inc, Louisville, KY July 2006 – Sep 2007

Role: .Net Developer (Contractor)

Humana Inc is one of the nation's largest publicly traded health benefits companies, with approximately 9 million medical members. The objective of Clinical Care Advance (CCA) is to gather, verify and maintain Insurance member information for Humana Inc. This project helps to develop a plan for patient care and disease management. The project also helps to provide optimum health care plan for a group health care.

Key Accomplishments:

Designed and developed User Interface for Healthcare Program Participation Search using C#, and SQL Server.

Implemented Authentication features as a .NET Security measure by providing a login page.

Developed windows Developed proxy application to consume web services for authorization submissions for Clinical Care Advance.

Developed various database queries and Stored Procedures using SQL Server and T-SQL.

Contact this candidate