Successful SQL/BI/ETL Developer & Designer with 8 years of experience.
Focus on creating clean, robust code with exceptional security while meeting and exceeding customer demands.
Development and Support of Business Intelligence using QlikSense, Qlik View SQL Server, SSAS, SSIS, SSRS, Power BI, Informatica and Tableau.
Worked in various SDLC processes like Agile Scrum and Waterfall methods.
An excellent Review, Analysis and Problem resolving skills in Technology for Financial, Commercial, HealthCare and Pharmaceutical domains.
Work History
Sr. Business Intelligence Developer, 07/2017 - Current Arthur J Gallagher & Co. – Radnor, PA,
Worked with diverse team of developers(12),business analysts and SMEs to determine/implement requirements for critical Financial applications integrating with Azure Cloud using Agile Workflow.
Developed complex ETL packages to extract and transform data from various sources like Flat files, Oracle, Progress, SQL server and load data to different destinations using SSIS/Informatica.
Created and automated SSIS packages to migrate data from legacy system(Progress) for Bank's de-customization to .Net applications which saved close to quarter million dollars.
Developed/Modified complex Informatica/SSIS packages for Ad-hoc, small and medium projects to analyze and strategize critical Financial decisions.
Designed and created MDX queries to retrieve data from cubes using SSIS.
Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
Used SSIS/Informatica to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
ETL workflows designed in DTS for overall data transfer from OLTP to OLAP with help of SSIS.
Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve passwords.
Involved in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Log Shipping, DTS, Bulk Insert and BCP.
Experience in Performance Tuning for SSIS packages by using Row Transformations, Block and Unblock Transformations.
Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
Worked on complex Stored Procedures, Functions, Views and SQL queries.
Implemented various Audit Trail(CDC) for critical application based on business needs.
Created User Defined Functions to encapsulate frequently and commonly used business logic making system more modular, secured and extensible.
Worked on extracting and encrypting/decrypting sensitive data from Office of Finance(OOF) in Web Services using SSIS.
Worked on UI Data pop and Meta-data for populating data in EXCEL(Pivot) using SQL macros.
Strong knowledge in designing and developing QlikView and QlikSense dashboards by extracting data from different sources like Sales Force, SQL Server, Oracle, SAP, Flat Files, Excel files, XML Files
Experience in optimizing QlikView and QlikSense applications to improve the performance.
Developed QlikView and QlikSense objects like Multi Boxes, Straight tables, Pivot tables, Containers, Line charts, Bar charts, Combo charts, Scatter charts, Line objects, Pie charts, Buttons.
Proficient in troubleshooting and fixing the QlikView and QlikSense dashboard issues.
Extensive experience in creating Pixel Perfect reports, Excel reports, Word reports, PowerPoint reports using NPrinting designer and automating the jobs in NPrinting Server.
Hands on experience in customizing the QlikView and NPrinting reports as per the business requirements.
Created incremental load process to load the data into QlikView applications from different source systems.
Designed and implemented automated deployments for Database, SSIS, SSRS using Azure DevOps and TFS.
Created Power BI Reports and effective visualizations to publish them to Power BI service.
Expert in creating and designing SSIS Packages for Integration and Migration of data from XML, Excel, DB2, Sybase, Flat file, Oracle to MS SQL Server using BCP and DTS utility and extracting, transforming and loading of data using SSIS, Log Shipping, DTS, Bulk Insert and BCP.
Involved in developing applications using ASP .NET /C# /SQL Server.
Created/Scheduled and implemented over 50 Jobs in Control -M(BMC) which is very critical for accounting run of organization.
Administered SQL server by creating user logins, dropping and locking logins, monitoring user accounts, creating groups, granting privileges to users and groups.
Created Distribution Databases, updated Publishers, created & managed Publications, managed Replication monitors.
Perform Capacity Monitoring and short and long-term Capacity Planning in collaboration with development resources and System Administrators.
Assessed platform statistics to create customized, data-intensive BI analytics.
Created PixelPerfect reports, Excel reports, PowerPoint reports and Word Reports using NPrinting tool.
Created tasks and scheduled the jobs in NPrinting server.
Involved in performance tuning of QlikView & QlikSense apps for faster data reloads and efficient response times.
Involved in analyzing the data and defining Key Performance Indicators (KPI).
Developed Proof of Concepts for Direct Discovery feature to load the data from SAP.
Created tasks and set dependencies using QlikView Publisher.
Assisted in installation and configuration of QlikView and QlikSense servers.
Developed Proof of Concepts (POC) for various projects using QlikView and QlikSense.
Assisted users with demo sessions in using QlikView & QlikSense converted QlikView applications to QlikSense.
Created detailed technical specification, business requirements and unit test report documents.
Responsible for validating the developed applications against the predefined design standards.
Created roles and implemented security at department level to allow/restrict users to view data depending on departments belong to.
Designed ETL Packages to extract, transfer existing data into SQL Server from different environments for SSAS cubes.
Created dimensions in performance point server.
Imported data into Performance point server from SQL database through Flat files.
Consolidated data from OLTP databases into OLAP using SSIS as ETL.
Created parameterized stored procedures to implement business logic.
Created views on database for better performance and security.
Created SQL jobs and scheduled them for nightly loads.
Created SSIS package to get data from share point and load Cubes.
Deploy SSRS reports in Microsoft Office share point server.
Created archival jobs to archive last # iterations of data.
Involved in creation of reports using SSRS and Configuring SQL Server Reporting Service(SSRS).
Created workflow items in version control system (Visual Studio TFS) to assign work to team.
Tuned performance by making use of clustered and non-clustered indexes.
Rebuilding Indexes and Tables as part of performance tuning exercise.
Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
Performing query plans and making sure each and every query is using appropriate useful indexes.
Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries.
Created UTP document and performed unit test processing.
MDX queries to retrieve data from cubes using SSIS.
Created/Scheduled over 60 jobs in Tidal for refreshing cubes and multiple cyclical jobs to move critical data for business end users.
Environment: Microsoft SQL Server 2012, SSIS 2012, SSRS 2012, SSAS 2012, Visual Studio 2012, tableau 10, tableau 9.0, Planning Business Modeler, Microsoft Office share point 2007, windows 7, .NET Framework, C#, VB.
Monitored assessment software for performance, security and database availability throughout lifecycle.
Wrote and optimized SQL statements to assist business intelligence practices.
Sr.SQL BI/Tableau Developer, 08/2015 - 01/2016 Inventiv Health – City, STATE,
Designed application that collects client transaction volumes for WSS Custody and Sub-Custody products, applies unit costs, and produces monthly export to T&SS Costing system (CIIS).
Excellent Knowledge of HIPAA(Health Insurance Portability and Accountability Act) transaction codes such as 270/271(inquire/response health care benefits), 276/277(claim status), 470(benefit codes), 835(payment or remittance advice), 837 (health care claim) and 834 (benefit enrollment).
Created Volume Automation to enable import and maintain unit costs and other reference data, as well as providing summarized MIS reports for administrative/integrity purposes.
Created functions and developed procedures to implement application functionality at database side for performance improvement.
Created Tableau wireframes for various lines of business.
Lead team of 3 tableau developers in assigning work to meet quality and deadlines.
Utilizing tableau server to publish and share reports with business users.
Built Stories in Tableau with various Data points to narrate data to end users.
Created and published Tableau Dashboards into Tableau Server.
Created action filters, parameters for preparing dashboards and worksheets using Tableau.
Created and Modified T-SQL stored procedures/triggers to validate integrity of data.
Created DTS and SSIS packages.
Created packages and scheduled them in SQL Agent jobs to get data from OLTP.
Created SSIS package to get data from different sources, consolidate and merge into one single source.
Created ETL package for data conversion using various transformation tasks.
Created Cubes from which data can be retrieved rapidly by enterprise information consumers.
Created dashboard to show business performance.
Created partitions and designed aggregations in Cubes.
Created perspectives in SSAS and configured security levels for Cubes.
Designed KPI's in SSAS and imported them to Excel.
Created datasets for reports using T-SQL and stored procedures.
Responsible for maintaining cubes using SSAS and populating cubes with data.
Responsible for Query optimization and Performance tuning
SQL BI Developer, 12/2012 - 08/2015 Glasko Smith Kline – City, STATE,
Involved in analysis, design and development of projects to consume transactional data, consolidate into data warehouse and creating reports and dashboards, writing complex Stored Procedures for creating datasets for Reports and dashboards.
Gathered business requirements, defined and designed data sources, data flows, data quality analysis, worked in conjunction with data warehouse architect on development of logical data models.
Created ETL packages using SSIS to move data from various heterogeneous data sources.
Created critical SSRS reports for analysis which increased sales by 12% for organization.
Created logs for ETL load at package level and task level to log number of records processed by each package and each task in package using SSIS.
Implemented error handling and roll back process in ETL load.
Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
Used XML and environmental variables in package configuration for Deploying SSIS packages.
Created region level security in reports to prevent users of one region from seeing data of different region and implemented subscriptions for Reports using SSRS.
Created Cross-Tabs, Drill-down and Sub-Reports using SSRS.
Deployed RDLs to Report Server.
Created Jobs Performance report that queries system tables to track duration of each job and weekly-average duration using SSRS.
Created reports in SSRS using different types of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
Designed SSAS cube to hold summary data for Targit dashboards.
Created User Defined Hierarchies depending on business requirement using SSAS.
Responsible for maintaining cubes using SSAS and populating cubes with data.
Created different measure groups and calculations using SSAS.
Created usage based aggregations in cube to minimize time for query retrieval from client tool Targit.
Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region using SSAS.
Populated data store with CRM Data (Oracle) using Integration Services (SSIS) as catalyst for ETL process.
Created Databases, Tables, Views, Indexes and Created and maintained Roles and Database users.
Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
Scheduling Jobs and Alerting using SQL Server Agent.
Created datasets for reports using T-SQL and stored procedures.
Performed DBA tasks like Backup, Restoration of tables and Stored Procedures and Refreshing Databases on weekly basis.
Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.
Planned and engineered REST web services to manipulate dynamic datasets.
Completed full redesigns of existing websites to improve navigation, enhance visuals and strengthen search engine rankings.
Reviewed code to validate structures, assess security and verify browser, device and operating system compatibility.
Skills
Power Apps(4)
XML Web Services(3)
HTML(2)
Web API(2)
SQL Profiler(5)
Performance Tuning(7)
Database Design(5)
Data Modeling(4)
Data Migration(6)
Jira(4)
Confluence(4)
Control-M(4)
Tidal(3)
QNXT(3)
MS Access(3)
Visio(5)
Enterprise Architect(4)
BCP(5)
Visual Basic(3)
Agile(5)
Waterfall(3)
Education
Bachelor of Science: Electronics and Communication Engineering, Expected in - Andhra University - Andhra Pradesh, India, GPA:
Certifications
Microsoft Power BI: https://courses.edx.org/certificates/91513f60bdae4a4aa7b8ed68e6faa3e6
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
