SUMMARY:
- Technology Lead with over 10.9 years of experience in Various Database Development and Business Intelligence projects in Insurance and Banking domain.
- Implemented various successful DB Design & BI implementations across the spectrum of complexity and business functions using SQL Server and Confidential tools.
- Efficiently translated various functional or business requirements to technical specifications and design.
- Provided Technical Architecture and Technical Design for various Database Development, Data Warehouse DWH, Business Intelligence BI and OLTP and Reporting applications for Domains like - Banking and Insurance.
- Developed and Lead multiple Database Development projects as a Sr. Database Developer and BI Team lead.
- Mentored, coached, cross-trained junior developers by providing domain knowledge, Technical expertise.
- Closely worked with various clients and successfully accomplished multiple complex projects till closure.
- Accomplished BI Architect and BI Program Manager Roles with proven track record in successful project deliveries, by conceptualizing, analyzing, and Coordinating development of various DB Design and BI solutions.
- Involved in Requirement Gathering and was responsible for business analysis and Business Requirement Documentation based on Technology Landscape and setup of initial Development Environment.
- Implemented Technical Architecture and Design of the Databases and the ETL Workflows and reports, Developed Proof Of concepts and created Technical Design Document and Presented to clients as part of project pursuit.
- Developed Dynamic Package Generator which generates SSIS packages based on automated SQL Server table driven metadata framework and there by reduced the development efforts and time.
- Developed Automated SSAS Cube migration framework using PowerShell scripts and scheduled the cube migration via Autosys Scheduler.
- Responsible for assigning tasks to the team based on individual strengths and responsible for tracking efforts and providing Weekly status updates to the management and clients, and ensured Timely delivery.
- Developed Complex DB Objects and Stored procedures with error handling and emailing, SSIS packages, SSRS reports and Implemented Package Configuration and Logging, Worked on Events and error handling of packages.
- Developed the SSRS reports with various pie and bar charts. Developed and Set up Snapshot reports and Auto Subscription of various reports. Have basic knowledge on QlikView, Tableau, Power Pivot and Power Query.
- Performed code reviews using TFS and Ensured Smoother coordination of User acceptance testing by closely tracking various issues raised and provided timely resolution for various issues.
- Document and conducted unit testing, documented the Deployment plan and coordinated Deployment.
- Documented the Case Studies of the successful project implementations and published internally for future use.
- Involved in requirement gathering and documenting the Business requirements and actively coordinated with client for various changing Business Requirements and created the technical design.
- Developed SSIS Packages with multiple complex Script components to implement various File Manipulations like Excel to CSV conversion and Usage of Zipping and Generating of New Zip Files and Execution of SSIS packages using Script components Enhanced Packages to implement custom logging.
- Analyzed the existing data mapping code and determined the standard data sources and destination tables.
- Developed a demonstrated POC by Enhancing existing Data Flow to cater the Data needs of new Data Flow.
- Created the Technical Design, Unit Test case results and Deployment documents for smooth deployment.
- Involved in requirement gathering and documenting the Business requirements and actively coordinated with client for various changing Business Requirements and created the technical design.
- Automated the migration process based on SQL table driven configuration to execute seamlessly across multiple environments just with minima changes.
- Actively implemented the review suggestions and enhanced performance based on clients’ inputs and completely automated the process and minimized the manual intervention.
- Automated SSAS Cubes migration from using PowerShell Commands.
- Analyzed the existing data mapping and determined the standard data sources of data based on data standardization rules and provided ranking for various data sources.
- Created Data profiling package to generate the data profile Xml files of the stage data and documented the data profiler usage and presented to clients to aid data quality.
- Created hierarchical Database Design for creating the reference data database for Hosting various hierarchical Data elements like Brokers, Agent Info, Geographical Info, Segment Info.
- Documented the user manual and Case Study of Automation and published internally for future reference.
- Was responsible for technically leading team and involved in requirement gathering and documenting the Business requirements for various computed queries and Adhoc Reports.
- Developed Basic Dashboard reports POCs using Qlikview.
- Automated and scheduled snapshot reports via batch file to execute Rss files for various snapshot reports which in turn create snapshot reports based on a specific schedule.
- Developed various complex stored procedures and views for Snapshot based reports and setup the subscriptions for the reports on need basis. And deployed the reports in Custom UI configuration.
- Developed various SSIS packages and scheduled execution of the SSIS packages via automated batch commands and scheduled the Jobs using Autosys Scheduler.
- Thoroughly understood the client requirements and documented the technical design based and Designed and Developed the Metadata Framework and Data Integration Framework tables for development of Automated ETL Packages.
- Analyzed the design implications for automated load and designed the various stages within the data load process i.e. staging area, processing area and archival area.
- Designed and Developed the Dynamic Package Generator SSIS Package, which will automatically generate the SSIS packages by picking up the metadata from Metadata tables.
- Developed ETL Dashboard Monitoring reports, Execution summary reports, parameterized, drill down reports.
