Sql Developer Resume Profile
5.00/5 (Submit Your Rating)
Business Intelligence Data Analyst |
Summary
- Highly motivated analyst proficient with the prevailing analytical tools, possess strong and effective communication skills essential in conveying results in analysis and investigations conducted
- Knowledgeable in statistical techniques and methodology including graphical and tabular presentation of data, probability distribution, parameters, statistical distribution ,confidence intervals, prediction Interval and hypothesis testing, residual , residual Plot, multiple regression
- Familiar with BI , Data Warehouse and Data Mining algorithms
- Strong analytical and mathematical skills - able to gather data, extract conclusions from available data
- In-depth knowledge of software development life cycle SDLC , having detailed understanding of various phases such as requirements, analysis/design, development and testing
- Proficient in database management, business analysis, programming, Data Analysis, Data Visualization SQL, MS Access and Oracle.
Technical Skills
BI Tools: | SAS Data Miner, Spotfire, Tableau , Excel Power Pivot |
CRM: | Microsoft Dynamics |
Databases: | Oracle, SQL Server, MS Access |
Languages: Software : | SQL Excel, Word , Visio, MS Project , PowerPoint , HP Quality Center |
Confidential
Key Deliverables:
- Collaborate with district school supervisors and data management team in creating analytic datasets , conduct statistical analysis and presentation of results to the management
- Provide insights , suggestions and proactively address potential issues and challenges which may thwart successful completion of mission critical data processing
- Design and prepare standard reports, ad hoc reports and summaries for statistical analysis and planning purposes using MS Office, Excel and power point
- Support data integration efforts with hands-on technical involvement in testing, scrubbing, and cleansing of data using
- Document procedures for future reference and make recommendations for data analysis process improvements
- Support teachers and supervisors as they enroll students and trouble shoot registration problems along the way. Process registration data for accuracy
Confidential
Key Deliverables:
- Gathered, organized and formatted data from various sources reviewed for reasonableness and delivered this data for internal and external use.
- Query large data sets using Spotfire to discover transaction patterns, examine financial data and filter for targeted information - using traditional as well as predictive/advanced analytic methodologies
- Assisted in the development and modification of complex technical programs, applying formulas and methods to analyze products, calculate reserves, project financial results and/or assess profitability and risk.
- Prepared insurance rate and form filings for submission with state regulators and verify data used in computations
- Designed and maintained excel spreadsheets , access Databases for presentation to clients and regulators
- Provided and verified data for actuarial reports utilizing actuarial principles and mathematical analysis
Confidential
Key Deliverables:
- Designed developed Spotfire dashboards and scorecards for analysis purposes and decision making showing effectiveness of marketing campaigns and customer churns.
- Merged various data sets from disparate systems and sources to create a cohesive data source for Microsoft CRM to conduct further analysis and generate ad hoc reports
- Managed large and diverse data sets to conduct detailed analyses and then create reports and dashboards to communicate findings to senior leadership
- Analyzed reports of data duplicates or other errors to provide ongoing appropriate communication and monthly or daily data reports
- Used spotfire's data visualization to identify, analyze, and interpret trends or patterns in complex data sets
Confidential
Key Achievements:
- Assisted in the planning and development of effective instructional tools, such as student materials, teacher resources, interactive whiteboard activities and online resources.
Confidential
Key Achievements:
- Developed guidelines and cultivated discipline procedures among children which are very important for them.
- Taught various subjects such as English, Science and the Hindi Language.