Home

SQL BI developer - BI developer

[email protected]

Location: Austin, Indiana, USA

Relocation: Remote only

Visa: H1B

Kashyap M Bloomington, IN | +1 786-686-8873 | [email protected] PROFESSIONAL PROFILE: Seasoned data enthusiast with 8 plus years of experience in design, modelling and development of database, data integration, reporting and visualization solutions. Expertise in data analysis, drawing insights from data and proficient in creating impactful visualizations and transform raw data into meaningful, actionable information. Extensive technical skills and ability to work in a fast-paced Agile environment with advanced understanding of diverse database technologies. Experienced, process-oriented, and strong collaborator team player with excellent communication skills and expertise in analytical problem-solving. Self-motivated, and results-driven data analyst skilled at capturing, curation, manipulation, visualization, and interpretation of data to successful drive business solutions. Always on the lookout for new problems to solve and challenge myself. TECHNICAL SKILLS: RDBMS/DBMS: MS SQL Server 2008 2019, Oracle (9i, 10g,11g), Teradata, MySQL, MS Access, T-SQL, PL/SQL, MDX, DAX, SQL Server Management Studio, TOAD, Oracle SQL Developer, MySQL Workbench, PowerShell. ETL Tools: SQL Server Integration Services (SSIS), Informatica Power Center, Microsoft Power Automate, SSAS. Reporting/Visualization: SQL Server Reporting Services (SSRS), Power BI Suite, Sisense, Tableau, Python. Methodologies: Agile Scrum, Waterfall, Rapid Application Development (RAD), Rational Unified Process (RUP). CERTIFICATIONS: Oracle Database SQL Certified Expert Microsoft Certified: Data Analyst Associate Passed Querying Data with Transact-SQL exam. EDUCATION: University of Houston Clear Lake, Houston, TX Aug 2014 Master of Science in Computer Science o Awarded the prestigious "Dollars for Scholars" scholarship. o Graduated in Top 5% of Class Jawaharlal Nehru Technological University, Hyderabad, India May 2012 Bachelor of Technology in Computer Science o Graduated in Top 1% of Class with 4.0 GPA. PROFESSIONAL EXPERIENCE: Lead SQL Server Data Engineer, Bloom Insurance Agency LLC Bloomington, IN Oct 2020 - Present Mentored a team of 4 data developers as point of contact, managing day to day operations, prioritizing tickets, and redistributing to manage resources efficiently. Prepared and reviewed technical and implementation documentation for database models, Report designs and ETL Data flows. Designed, Guided, and successfully executed the development of database objects and ETL processes using SSIS to validate, cleanse, transform and load health plan data from heterogeneous sources and accelerating client on-board time by 90% and generated $30.8 million revenue. Conducted brainstorming sessions to identify the business requirements and deliver timely solutions by worked closely with development teams. Conducted brainstorming sessions to identify the business requirements and deliver timely solutions by worked closely with development teams. Developed SSRS Reports and automated report delivery to client SFTP locations using SSIS tools. Designed and developed SSRS Linked Reports, Drill-Down & Drill-Through reports to provide timely data delivery and visibility. Played active role in Testing and QA of ETL SSIS processes & SSRS report data testing. Lead Data Engineer, Bloom Insurance Agency LLC Bloomington, IN Oct 2018 Oct 2020 Developed automated report delivery to client SFTP locations using SSIS tools. Involved in specifications gathering sessions with Business Analyst and End Users. Spearheaded the development of Data Mart project to provide point of time data, synthesized interactive dashboards and Key Performance Indicators (KPIs) to identify critical call center metrics eventually replaced traditional static reports. Automated couple of workflows using PowerShell. Involved in writing background jobs using PowerShell. Planned, maintained, documented, and presented SQL Road Map to higher officials for budgeting and growth. Documented, implemented, and maintained data standards, policies, and operating procedures for the team. Data Analyst/SQL BI Developer, Bloom Insurance Agency LLC Bloomington, IN Aug 2016 Oct 2018 Fabricated and implemented data models, tables, user-defined functions, and stored procedures to delegate backend call center operations to user facing application which reduced manual effort by 80% and issue resolution time by 95%. Identified data and time intensive areas and strategized development roadmaps for automating tasks and processes to reduce manual intervention by 8 person hours in a week and increase efficiency. Create PowerShell scripts for server Installs/ad-hoc business reports. Developed 100+ complex reports to provide operations managers with data in various levels of detail quickly. Design/code involving large volumes of data PowerShell ASP.NET/ Web API. Developed SSIS Packages and solutions to ensure timely and secured delivery of critical enrollment data to clients. Designed, diagnosed, and optimized complex stored procedures and queries by reducing processing time by over 90% and achieving nearly 100% report delivery accuracy. Proficient with source control tools like GIT and ensuring code repositories are up to date throughout development life cycle. Programmer Analyst, 3S Business Corporation - Houston, TX Apr 2016 Jul 2016 Extensively worked on developing simple and complex stored procedures and reports that helped identify potential business opportunities and boost sales by 60%. Analyzed existing processes and procedures to identify and isolate performance bottlenecks, tweaked them to achieve peak performance. Performed activities such as Database Backup, Restore Operations, Troubleshooting Issues, monitor error logs and agent jobs. Experienced in development and deployment of database objects to DEV, TEST and PROD environments. Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers. Documented and maintained the IT wiki of the organization with the project developments, tasks, and How-To articles. SQL Database Developer, Oracle Financial Services Software Ltd - Bangalore, India Aug 2012 Aug 2014 Extensively worked with Oracle database and OBIEE suite for Oracle Business Intelligence analysis. Developed ETL processes to pull data from upstream applications into staging databases for generating reconciliation reports. Played active role in migrating project backend from Oracle 10g to MS SQL Server 2012 database. Made recommendations to upgrade reporting mechanisms to shift from Excel embedded macro queries to stored procedure oriented SSRS reporting and improving efficiency by 80%. Exposure to process-oriented tools such as ticketing system, CAB (change advisor board) process for production deployments, incident management and problem management systems. Keywords: quality analyst business intelligence active directory information technology microsoft procedural language Texas