Sweta Shakya Email & Phone Number

Australia

Sydney, Australia

• Developing and executing ETL packages to migrate data from various formats (Oracle, MySQL, Sybase, flat files etc.) to the company’s database architecture in MS SQL Server.
• Developing complex optimized T-SQL scripts for reporting in live environments.
• Performing ad hoc updates.
• Analyzing foreign data sets.

Nepal

• Designed and developed data integration process using ETL tool Oracle Data Integrator (ODI) to map, validate different format source data like Excel, flat file, MS Access and applied business logic to fit it into.
• Redesigned legacy imports and analysis scripts in ETL platform that significantly saved execution time and simplified the process.
• Developed business logics using complex SQL code such as stored procedure, function, triggers, indexes and views for the application.
• Optimized slow running queries automated and simplified regular tasks of reporting and server space cleanup by developing stored procedures that boosted performance.
• Mentored junior team members and provided technical guidance.

Nepal

• Accomplished production tasks as a production engineer and given the dedication of delivering the service in parent company in USA and in disaster recovery site in India
• Recipient of team of the quarter award in recognition of exceptional job performance for data center migration.
• Monitored data acquisition tools and system, generated fronts, reports and extracts, prepared backup and managed space in servers.
• Led the team, prepared metrics reports, established priorities and schedule for timely delivery and communicated with client for any issues related to data acquisition, format changes and erroneous data.

• Built stored procedures in Microsoft SQL Server and Oracle to automate the process of generating reports and minimized manual effort and execution time.
• Imported and analyzed complex data sets provided by client and performed verification and validation as per the business rules.
• Developed test scripts, test metrics, implemented test clients and debugged application programs errors.
• Documented business process flows within the organization.

Nepal

• Imported and validated data provided by client in Microsoft SQL Server and Oracle server.
• Ensured data quality using data trend reports and scripts to verify imported data and control totals provided by clients.

Nepal

• Designed and created programs and procedures using Microsoft SQL Server 2005 and ASP.NET to bulk import source raw data provided by the clients.
• Analyzed, validated and identified the layout mismatch as per organization standards.
• Led the team, accomplished major projects and was a main point of contact for discussing issues with the team in Holland.
• Monitored the system, tested and fixed errors and generated client specific reports and extracts.

Nepal

• Developed and maintained financial transaction modules in Visual Basic 6.0 and SQL Server.
• Analyzed code to find causes of poor performance and recommended solutions for optimization.
• Delivered customer support and conducted end-user training for the software.