SUMMARY

• Experienced in SQL/BI Development includes Business Intelligence applications design, development and maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Enterprise Data Warehouse.
• And highly proficient in using T - SQL for developing complex stored procedures, triggers, tables, views, user functions, and data integrity, SQL joins and query writing.
• Expert in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS teh data into teh Enterprise Data warehouse from Heterogeneous sources such as Excel, and Flat files.

TECHNICAL SKILLS

Operating Systems: RedHat Enterprise Linux, CentOS (7, 8)

Programming/Scripting Languages: SQL, Java (Basic), Bash, HTML

Tools: EKS, Ansible, Terraform, Docker.

Cloud: AWS, GCP (VPC, Storage, Compute Engine)

Storage: LVM, NFS, SAMBA

Database tools: Power BI, SQL Server Integration Services(SSIS), SQL Server Reporting Services (SSRS)

PROFESSIONAL EXPERIENCE

Cloud Database Engineer

Confidential, Boston, MA

Responsibilities:

• Worked Directly wif Business team to gather ETL/BI requirements, Identify PKs, gap analysis and come up wif technical design and effort estimates.
• Contributed in SSIS packages upgrade and migration project to upgrade from and move them to Azure Data Factory.
• Used Azure Data Factory to schedule, run and monitor SSIS packages and move data through landing zone (raw data), process and analytics zones.
• Authored complex T-SQL statements (stored procedures, Functions) and developed different DB objects to support enterprise applications as part of teh data layer team.
• Deployed SQL Server on Azure VMs (Windows and Linux) through ARM templates and Terraform modules.
• Utilized Azure Key Vault to store secrets (password, Access Keys, API keys) and pass them through secret parameters during automated deployments.
• Configured Azure SQL data masking, logging and alerts to meet compliance and regulation needs.
• Configured Azure SQL partitioning
• Configured data retention policy and life cycles for Azure Blobs.
• Participated in migration efforts of on prem SQL databases into Azure SQL (multiple flavors of SQL, MS, PostgreSQL and MySQL).
• Designed SSIS Extract transform load (ETL) pipelines development using SQL server 2008/2017, SQL 2008/2017 integration services (SSIS).
• Configured backup and recovery of Azure SQL according to teh company’s policies.
• Scheduled jobs for executing teh stored SSIS packages, stored procedures using SQL Agent.
• Azure SQL user management (IAM, RBAC).
• Created complex SSIS packages to extract data from various heterogeneous sources (SQL server, Teradata and flat files) to load it into SQL Server.
• Used ETL (SSIS) jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Designed Azure SQL for Disaster Recovery and High availability scenarios.
• Set up centralized logging for enterprise data layer through Azure resource logs (SQL databases and VMs), routed them to Azure storage and SQL analytics for event handling and back up purposes.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Performed maintenance duties likeperformance tuningand optimization of queries, functions and stored procedures.
• Create/ Maintain over 100 SSIS packages.
• Interacted wif teh existing database developers and DBA to understand teh existing schema.
• Fine-Tuned SQL Queries for maximum efficiency and performance.

BI/SQL Developer

Confidential, San Francisco, CA

Responsibilities:

• Experience in desgin, development, impelementation, support of misssion critical BI applications.
• Delivered BI reporting solutionn in BI and SSRS.
• Design and develop Microsoft SQL Integration Services programming objects for gathering, manipulating and loading data.
• Manage, monitor and improve Microsoft SQL Server Analysis Services environment including ongoing changes and active product backlog.
• Adhere to compliance procedure and internal/operational risk controls in accordance wif any and all applicable regulatory standards and policies
• Experience managing and maintaining Microsoft SQL Server Analysis Services Cubes
• Meticulous attention to detail an eye for consistency
• Pro-Active and resourceful wif teh ability to work independently and problem solve
• Communicates effectively wif colleagues, clients and partner vendors
• Provides support and evaluation of BI Management, Application Specialists and teh SSIS Data Warehouse team to leverage existing BI Informatics and Data Warehouse architecture
• Analyze complex business problems to execute teh vision and strategy of teh Compliance organization wif teh overarching goal to reduce operational risk across teh enterprise
• Involved in building analysis of teh OLTP and OLOP data and decision support.
• Utilized Power BI gateway different source to matching analysis criteria and further modeling for pivot and power view.
• Setting up and designing clinical studies requirements in BioClinica CTMS (Clinical Trial Management System) application.
• Managing, running and configuring CTMS integration processes for client’s ongoing clinical studies.
• Building and deploying custom SSRS reports for clinical operations and finance departments.
• Testing and deploying integration programs in different environments.
• Support and maintenance of clinical studies in production (live) environment.
• Designing mapping documents and processesto extract raw data, transform and load it into teh CTMS application.
• Designing and building test scenarios to ensure data integrity, integration program and CTMS application functionality.
• Configured and maintainedReport ManagerandReport ServerforSSRS.
• Involved in Migration ofSSRS 2012 to SSRS 2016.
• Created and Deployed teh Reports usingSSRS 2016clinical sites data and study arms.
• Identified and worked wifParametersusing complex expressions for parameterized reports inSSRS2016.
• Deploying, scheduling SSIS packages to load CTMS data on a daily, weekly, monthly and quarterly basis.
• Ensure accuracy & integrity of data & applications through logging and test plans.
• Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc.
• Experience in creating complexSSIS packagesusing proper control and data flow elements.
• Experience in providingError handlingby usingEvent Handlerfor SSIS Packages.
• Transferred data from various sources likeMS Excel, MS Access, and SQL ServerusingSSIS.

SQL Developer/ Data Analyst

Confidential

Responsibilities:

• Analyze, design, develop, and document teh application software for teh Classification Project.
• Designing SSIS Packages to transfer data from various sources like Flat files, XML files, and Excel to SQL Server using Business Intelligence Development Studio.
• Implementing SSIS packages related to teh extraction, transformation and loading ETL process for database applications, in accordance wif established standards
• Developing clear statement of objectives and performance metrics. Involved in tuning and configuration of SSIS.
• Applying in-depth understanding of business and IT requirements to streamline administration and internal processes, resulting in enhanced automation and operational efficiency.
• Creating T-SQL queries, complex stored procedures and functions to perform database tasks such as inserts, updates and deletes and performance tuning Views.
• Designed new reports and wrote technical documentation, gatheird requirements, analyzed data, developed and built SSRS reports and dashboard.
• Developed Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports and Matrix reports using SSRS.
• Developed different type of reports including: Sales Report, Client Contact Report, Accounting Statement Report, Employee/benefits census report, Benefits statements report, Enrollment count summary report, Billing report and other insurance/payroll reports by using SSRS and SQL Server 2008/2012.
• Documentation of proposed new batch jobs, programs, database table designs and /or reports.
• Developed browser-based management system, allowing various documents to be placed in Windows Explorer interface folders.
• Strong writing skills to translate system requirements into easy to use training documents
• Created SSIS packages to extract data from different files according to teh Business User Requirements.
• Designed SSIS Packages to transfer data from various sources like Flat files, XML files.
• Wrote T-SQL queries, Stored Procedures and used them to create Reports using SSRS
• Wrote SQL Stored Procedures to maintain and supports a variety of reports or queries utilizing appropriate reporting tools.
• Assisted in development of standardize reports for ongoing customer needs
• Maintains data integrity in systems by running queries and analyzing data and coordinating appropriate training as needed
• Worked on Claims Data Migration and Claims Reporting Project.
• Designed SSIS Packages to transfer data from various sources like Flat files, XML files, and Excel to SQL Server using Business Intelligence Development Studio.
• Wrote T-SQL queries, Stored Procedures and used them to build packages.
• Designed, Developed and Deployed packages in SQL server environment using SSIS.
• Involved in tuning and configuration of SSIS.
• Deployed SSIS packages from Development to Testing Servers
• Wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS)
• Created database and database objects like tables, stored procedures, views, triggers, user defined data types and functions.
• ETL implementation using SQL Server Integration Services (SSIS), applying some business logic and data cleaning in staging server to maintain child and parent relationship.
• Created complex SSIS packages using proper control and data flow elements.
• Enhanced and deployed teh SSIS Packages from development server to production server.
• Used SSRS creating well-formed reports and web-based reports for financial applications and transactions.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Configured teh report server and generated teh report models for user interactions.
• Involved in teh tuning of teh existing Database Objects.
• Used Query Analyzer to optimize SQL queries.
• Excellent technical and analytical skills wif clear understanding of design goals of ER modelling for OLTP and dimension modelling for OLAP.

SQL Developer

Confidential

Responsibilities:

• Monitor performance of database systems resources and query throughput
• Monitor and maintain database storage resources
• Monitor and maintain database maintenance plans for backups, index rebuild/defragment, and database statistics
• SQL Server Installation, Upgrades, Migrations and Configuration
• Install database software service packs and cumulative updates as necessary
• Maintain database documentation as required
• Maintain and administer database security access
• Perform database Ad-hoc backups and restores
• Trouble shoot and resolve database connectivity issues
• Follow Change Management processes to implement database configuration changes
• Follow Problem Management processes to troubleshoot and resolve recurring issues
• Proactively monitor and respond to MSSQL database Alerts.
• Write SQL-queries for sending daily reports
• Maintain a database through creating procedures, triggers, jobs(scheduler), which provides teh best performance
• Experience in developing complex packages, stored procedures, functions, triggers.
• Experience in Query Performance Tuning by Analysing tables, and Explain plans.
• Experience in using Cursors, Collections and Bulk Collect feature.
• Effectively made use of Indexes, Table Partitioning, Analytical functions.
• Strong in writing simple and complex SQL queries using DML, DDL, and Table joins.
• Working experience in Dynamic SQL and Exception handling.
• Clear understanding and usage of Data dictionary and other dba tables.
• Experience in Data mapping and Data migration.
• Support Data warehouse, ETL Process
• Profound noledge in Data warehouse concepts.
• Demonstrated experience in understanding project requirements and functionality, in order to design appropriate test plans and test cases to verify features and functionalities.