Lekshmy Krishna

Experience

• 

  ER&DCI Institute of Technology, Govt. of India

  Dec 1998 - May 1999

  Project Trainee

  Project entitled AUTOMATED SHARE BROKING SYSTEM, automation, management and operations of trading process of shares, developed in IBM S/390 using CICS/ESA, DB2, COBOL 370.

• 

  Kerala Statistical Institute

  Jun 1999 - Dec 1999

  Software Programmer

  Designed, developed and implemented, CONCURRENT EVALUATION OF MILLION WELL SCHEME using FoxPro, MS Access on Windows OS. Under a centrally sponsored scheme by Govt. of India, farmers were given investment assistance for construction of wells for the purpose of improving crop production.

• 

  M2 Technologies

  Jan 2001 - Jun 2001

  Software Developer

  M2 Technologies is a software consulting solutions for Web-based Applications that can efficiently manage all the inherent activities involved in the operation and management of a clinic. A modular-architecture-based solution, which can be customized to contain features and modules such as. Patient Administration, E-prescription, Electronic Charts, Lab, Billing, Radiology, Transcription, Patient Reports etc.Responsibilities:• Hands on experience in Object Oriented Programming implementing Waterfall Model using ASP and JSP.• Validated the server pages using VBScript and JavaScript.• Was involved in the development of GUI for Reports. The data for the reports were fetched from the ORACLE database and they were displayed as bar graphs by manipulating a single pixel image.• Passed on the validated data in the form of Query stings to Practice Management System. • Made recommendations & implemented them to improve the reporting mechanism in terms of graphical analysis alongside data.• Was privileged to conduct presentation on Object Oriented Modelling.• Was involved in the development of user interface screens using HTML and ASP.• Delivered powerful, richly formatted, dynamic reports from virtually any data source, delivered in preferred language and format implementing Crystal Reports.• Performed Unit Testing and Integration testing during development as well as deployment phases.Environment: SQL Server Enterprise Edition, HTML, XML, Classic ASP, JSP, VBScript, JavaScript, Dreamweaver, Crystal Reports. Show less

• 

  Indsoft Infotek and Services (P) Ltd.

  Jul 2001 - Dec 2003

  Software Engineer

  Indsoft Infotek and Services conceived foreseeing the possible needs of a wide range of customers, which makes the comprehensive E-Retail CRM software easily customizable for B2B and B2C solutions. The website is enriched with Business support features like most popular products most searched items etc. ● Worked closely with the stakeholders / end users in writing the functional specifications for Accounts Online project and WAP portal.● Design, develop, and maintain web applications using JavaScript, HTML, and CSS.● Develop user interfaces for web applications using Dreamweaver.● Develop and maintain RESTful APIs.● Motivate colleagues to comply with the quality standards and procedures.● Conducted Internal Quality Audits ( ISO 9001 ).Environment: Oracle 9i, Java, JSP, ASP, JavaScript, HTML, CSS, XML, VBScript, Dreamweaver Show less

• 

  Experian Consumer Services

  Oct 2013 - Sept 2014

  SQL Database Engineer/ Analyst - ( CCS Global Tech Poway, CA from May 2013 till Sept 2014 )

  ● Responsible for gathering requirements, creating system specifications and providing high level estimates for Notification projects and Kit-Entity-Site configurations.● Responsible for designing and creating logical and physical model tables to cater for new requirements, Replication Environments and enhancements using Embarcadero Data Studio approved by Database Model Review Board. ● Created notification stored procedure which is designed to send reminder emails on 30th, 60th and 90th day respectively for ID Protection enrollment.Environment: MS SQL Server 2008 R2, SSMS, Embarcadero Data Architect, Flat Files, Excel, MS Access, Windows Server 2008 R2, Serena Team Track, Serena Dimensions. Show less

• 

  Cengage Learning, ed2go division

  Oct 2014 - May 2016

  SQL Database Engineer / Administrator

  ● Initially involved with Analysis, Design, Development, Maintenance, Enhancements of Data Migration Project, MOODLE, for system unification.● Migrated data from PostgreSQL to MS SQL Server.● Furnished various SSRS reports from Report database based on requirement specifications especially for Account Managers, like Invoice Reports, Net-Checks, Roster Close reports etc.● Developed and scheduled SSIS Packages, implementing configuration files and file system deployment. ● Ensure data integrity by generating Alerts implementing SQL Agent Jobs, when the data deviates from its threshold values. Environment: MS SQL Server 2008 R2, SSIS, SSRS, MS Visio, MS Access, Gemini. Show less

• 

  Lee Hecht Harrison ( In Transition )

  Jun 2016 - Nov 2016

  JSWT ( Talent Development and Transition )

  Actively pursuing new opportunities as Business Intelligence Developer / Database Engineer / Team Lead / Business Analyst / Data Analyst / Database Architect / Database Administrator.

• 

  First Direct Lending, LLC - NMLS #1110278

  Dec 2016 - Jul 2017

  Report Writer

  ● Create SSIS Packages to move relevant data to Reporting Server.● Develop and maintain Tableau and SSRS reports.● Create, optimize and maintain stored procedures and functions necessary for new reports.● Supporting QA & UAT in fixing defects / bugs, identifying impact areas and test scenarios.Environment: MS SQL Server 2008 R2, SSIS, SSRS, Tableau 10.3, Taiga.

• 

  Performance Team

  Oct 2017 - Apr 2019

  Business Intelligence Developer

  ● Develop standard Bill of Lading reports and Packing Slips based on business requirements.● Performs data warehouse design and modeling according to established standards.● Configure transactional replication from systems like Warehouse Management, Soft Pointe, TruckMate etc. to SQL Server 2012.Environment: MS SQL Server 2012, SSIS, SSRS, Crystal Reports, SharePoint 2010

• 

  Accurate Background

  May 2019 - Oct 2023

  Sr. Business Intelligence Developer / Team Lead

  ● Created and executed streams and tasks in snowflake for CDC.● Replicated existing database tables to Snowflake from MS SQL Server using Qlik Replicate● Used FLATTEN table function to produce a lateral view of Variant, Object and Array Column.● Created stored procedures and functions using JavaScript in Snowflake● Created a C# module in SSIS to import data from MS Excel to Reporting MS SQL Server● Archive SSRS Reports in Archive folder in Report Manager implementing PowerShell ScriptsEnvironment: MS SQL Server 2016, SSIS, SSRS, ZappySys, Snowflake, JavaScript, PowerShell, Tableau, Mongo DB, Dynamo DB, QLIK Replicate, GitHub, Jira Show less