Leda Summer
Sql Server Dba Developer @Tata Consultancy Services
Signup · Get unlimited contacts
WORK HISTORY
Sql Server Dba Developer @Tata Consultancy Services
Group insurance data warehouse. Information Management,Business Intelligent reports. Rental Commission rate development)Oracle SQL, DB2 SQL, Unix, Linux, SQLDBX, ServiceNow, Bitbucket, git, Jenkins, Putty. SSIS integration, SSAS cube, SSRS report For Prudential Financial, Under Unix / Linux, troubleshot, modified Unix Cron file for scheduling jobs issues, added, deleted modified scheduled reports; troubleshot missing scheduled reports on Unix server; worked with tickets on clients’ requests for various issues on server; created, modified, and troubleshot various DB2 or Oracle SQL reports about insurance company’s claims, disability, absence, billing, payments, plan, rule engine, funding, and etc, including understanding business logic and designing then implementing it in the code for complicated Litigation reports with required dates not directly saved in the database. Designed and programmed rule engine program for reports by digging out missing requests in specs, and etc. For Sunbelt Rental, conducted development for a Rental Commission project by using SQL with SSAS as source, SSIS as ETL and SSRS as output reporting.
EDUCATION
Graduate School of University of Alabama at Birmingham
Master of Science, Biomedical Engineering,Bio- Instrumentation
Shanghai University, Engineering College
Bachelor of Science, Electronical Engineering, Radio communication
SKILLS
ABOUT LEDA SUMMER
DATABASE/DATA WAREHOUSE, ANALYSIS & DB Admin / Development, BUSINESS INTELLIGENCE-Over 20 years’ experience in database application life cycle implementation with foundation programming: gathering information, designing system structure, development, testing, & production implementation using SQL, SSIS, SSRS, SSAS, C, ASP, SAS base/EG languages. Designed and built SQL databases and data warehouses, SAS libraries & applications, which included designing database structures, creating or modifying of tables, views, stored procedures, functions, & stored processes. Over eight years Credit Risk Management database application experiences.SKILLS:DATA/DATABASE ARCHITECT, Development DBA, Reporting Analyst/Analytics, Senior Programmer/Analyst• 20 years of SQL database development experience with different languages, including database / data analysis, data relationship, patterns, database structure, procedure/ table design and build, resolving customer’s needs with designing/coding BUSINESS INTELLIGENCE With Microsoft, SAS• Designed and built SQL database/data warehouse applications, SSIS, SSRS, SSAS cube, SAS OLAP cube, Microsoft data integration applications in various lines of businesses, SAS reports, Power BIDATABASE SERVER DBA With Network Administrator Work Experiences• SQL database server DBA experiences; included setup, installation, job scheduling, database backup & restoration, replication, and maintenance and administration of database servers
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.