Aakansha Singh
Summary
Analytical and process oriented with in depth knowledge of database types ,data capture ,curation ,manipulation and visualization. Proficient in identifying efficiencies and problem areas within data streams while communicating needs for projects .Bringing forth the ability to synthesize quantitative information
Overview
10
10
years of professional experience
1
1
Certification
Work History
Team Lead
Neoquant Solutions
Mumbai
09.2019 - Current
- Provided leadership and guidance to team members, ensuring that tasks were completed on time and to a high standard.
- Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modelling process.
- Proficient in working closely with project managers to understand and maintain focus on their analytical needs, including identifying critical metrics and KPIs , and deliver actionable insights relevant decision-makers .
- Skilled at analyzing data to answer key questions from stakeholders or out of self-initiated curiosity with an eye for what drives performance ,investigating and communicating areas of improvement in efficiency and productivity.
Expert ay developing and maintaining databases by acquiring data from primary and secondary sources and building scripts that will make our data evaluation process more flexible or scalable across data sets. - Utilized excel to gather ,compile and analyze data from pivot tables and created graphs and charts ,provided analysis on any claims of data discrepancies in reports or dashboards .
Key team member responsible fore requirement gathering , design , testing & validation. - Trained new staff in relevant processes and procedures.
- Experience in creating and developing Power BI Dashboards into a rich look, Managing Workspaces using Power BI services,creating data gateways to connect data residing on premises and develop dashboards on same
- Writing calculated columns, Measures query's in power bi desktop to show good data analysis techniques,Adept at receiving and monitoring data from multiple data streams including SQL Server, Oracle, Excel and Text file.
Analyst (SQL Developer)
Inventurus Knowledge Solutions
Mumbai
04.2019 - 08.2019
- Worked as an MY SQL Developer and establishing strong relationships with end users and technical resources throughout established projects
- Work closely with the development team to provide support for database objects and performing code review
- Take regular database backup
- Provide authentication and authorizations for Database
- Communicated project status through project and program reviews compiled reports metrics in the standardized format to management and finance
SOFTWARE ENGINEER (SQL - DEVELOPER)
Ticker Plant Ltd
Mumbai
10.2018 - 03.2019
- SQL Development - Writing Transact SQL
- Deploying environments/applications fixes, patches, improvements.
- Made substantial contribution in preparing and presenting reports and analysis ,predictive modelling and other data mining results using SSIS and Excel applications.
- Identified data discrepancies in key business reports that were leading incorrect reporting of financial data .
SR TECH OFFICER (SQL DEVELOPER)
21st Century Informatics
06.2014 - 09.2018
- Notify manager of any conflicts or other issues related to timely delivery of work. Assist client managers with development of client work orders
- Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.
- Proficient in Creating, Configuring and Fine-tuning ETL workflows designed in MS SQL Server Integration Services (SSIS).Designed and Deployment of Reports for the End-User requests using Web Interface & SSRS
- Work to facilitate creation of high performing data centric components and applications
- Review the designs, code, and test plans of other developers and provide recommendations for improvement or optimizations
- recommendations towards the development of new code or reuse of existing code. Improve performance of T-SQL stored procedures. Database administration including performance monitoring, access management and storage management
- Create, develop and maintain advanced SQL queries, procedure, cursor, triggers, and batch files
- Large database maintenance and troubleshooting
- Enterprise Software troubleshooting
- Maintaining SLA (TAT commitments)
- Help Team Lead to generate change request
- Holding periodic customer review meetings.
Education
Bachelors in Information Technology -
DAV (Mumbai University Affiliated)
Post Graduate Diploma in IT projects Management -
Hybrid Program-Welingkar Institute of Management
Skills
- Data visualization and modelling
- Data query language: SQL, DAX
- Data warehousing
- ETL frameworks
- Microsoft BI stack (SSIS, SSRS, SSAS)
- Microsoft Excel -Advanced: Pivot
- Microsoft Power BI Desktop & Power BI service
- Critical thinking
- Troubleshooting
- Experimental design and analysis
Certification
- Microsoft Certified Power BI Data Analyst Associate
Personal
Languages Known: Hindi , English & Marathi .
Hobbies & Interests: Baking
Timeline
Team Lead
Neoquant Solutions
09.2019 - Current
Analyst (SQL Developer)
Inventurus Knowledge Solutions
04.2019 - 08.2019
SOFTWARE ENGINEER (SQL - DEVELOPER)
Ticker Plant Ltd
10.2018 - 03.2019
SR TECH OFFICER (SQL DEVELOPER)
21st Century Informatics
06.2014 - 09.2018
Bachelors in Information Technology -
DAV (Mumbai University Affiliated)
Post Graduate Diploma in IT projects Management -
Hybrid Program-Welingkar Institute of Management
Similar Profiles
Sourabh KhandkeSourabh Khandke
Software Developer at Neoquant Solutions Pvt LtdSoftware Developer at Neoquant Solutions Pvt Ltd
Vijay ChauhanVijay Chauhan
Principal Consultant at Nice Software Solutions Pvt. Ltd.Principal Consultant at Nice Software Solutions Pvt. Ltd.
Sophia ParnamiSophia Parnami
Large Corp -API Integration at BusyBees Logistics Solutions Pvt LtdLarge Corp -API Integration at BusyBees Logistics Solutions Pvt Ltd