Key Result Areas:• Significant role in complete software development life cycle encompassing - development, documentation, testing and maintenance of website used by the clients • Actively engaged working as a Backend developer in tasks like - implementing stored procedures in SQL Server for managing huge amount of financial data; designing/architecting front-end using HTML5/CSS to provide a scalable UI and creation of reports/dashboards utilising DAX Project Title- Enterprise Application Services and Growth Market Unit (Finance Internal project)Technologies used- SQL Server 2008 R2/2012, SSDT, Microsoft Power BIOverall Deliverables:• Instrumental in array of activities entailing - data analysis, data modeling, database designing, creating SSIS packages to load the Excel data to SQL database, creating stored procedures, user defined functions/views/triggers; package deployment and monitoring • Efficiently scheduling/maintaining jobs for deployed packages; creation of SSRS Reports on the data integrated using SSIS packages • Key role in performance tuning of ETL jobs, SSRS reports and SQL scripts • Engaged in creating Macros for Excel based reports to be shared with Business Analysts• Diligently interfacing with team members to enhance the productivity by automating certain daily jobs; daily load processing and so on• Integral development role on the Power BI module involving preparation of technical specifications based on requirement specifications; development of reports; working on yearly/monthly/quarterly/daily reports