PROFESSIONAL SUMMARY:

• Over 6 years of experience in developing BI applications utilizing SQL server, BI stack, ETL Power BI SSIS.
• Manage end - to-end change implementation planning including project management, issue management, and communications
• Develop test plans and protocols for evaluation of system performance
• Capacity to work with business units in analyzing business processes and recommending new ideas and/or efficiency opportunities
• Performs well under pressure; shows diplomacy, tact and good judgment when conflict arises
• Collaborate with other IT and functional area personnel on routine and major system upgrades activity
• Support internal and external audits
• Developed parameterized reports which were used for making current and future business decisions.
• Worked closely with the offshore team in finding solutions to arising problems.
• Identify the associated Store Procedures and parameters used for the reports.
• Involved in job scheduling and alerts.

TECHNICAL SKILLS:

Database: MS SQL Server, MS Access, Oracle, Posture SQL Server 2016, T-SQL, SSMS, Excel, SSIS, DTA, SQL Profiler, Power BI, Tableau, MS Azure, Data Factory, Visual Studio, C#.

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Service (DTS), Tableau

Database Tools: SQL Server Management Studio, Data Warehousing, Extract, Transform, Load (ETL), Business Intelligence (BI), Microsoft azure

SQL Server Tools: SQL Server Business Intelligence Development studio, Enterprise Manager, SQL

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP &OLTP, Adobe Photoshop, Abode Flash, Hyper-V Manager

PROFESSIONAL EXPERIENCE:

SQL SQL/ETL/SSIS Developer

Confidential, Alexandra VA

Responsibilities:

• Planned and designed data collection and survey tools and performed data analysis.
• Created and tuned database objects such as tables, stored procedures, triggers, views, indexes and joins in MS SQL server to support relational and dimensional databases.
• Developed SSIS packages to Extract, Transform and Load (ETL) data from different sources into database; and to transfer data from various sources including MS Excel, MS Access, and Flat Files to SQL database.
• Scheduled SQL Server jobs to load data periodically using SQL Server Agent.
• Writing T-SQL queries and stored procedures, creating various database objects as well as optimizing T-SQL code for faster performance.
• Created report crucial stored procedures and functions to support reporting dataset manipulation.
• Developed T-SQL stored procedures, functions and views to implement the business logic for front end applications, reports as well as ETL processes.
• Wrote custom T-SQL stored procedures and scripts to provide application functionality and tuned them by creating indexes and ensuring optimized query design.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers
• Created complex SQL stored procedures, Triggers, Functions, Views, Indexes
• Used both System and User-Defined functions to enhance the functionality of my T-SQL code

Environment: MS SQL Server 2019, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, BCP, T-SQL

MS BI/ETL developer

Confidential, San Francisco, CA

Responsibilities:

• The scope of the project is to perform ETL Process and generate customized reports to determine customer’s eligibility.
• Handling the design, development, testing and deployment of customdatawarehouse systems.
• Applying understanding of Kimball Methodologies Data warehousing concepts & knowledge of dimensional modeling using different Schemas (Star and Snow-Flake) to fit reporting, query and business analysis requirements.
• Developed various reports like charts, tables, matrix, and sub reports.
• Created different kinds of Tabular reports like Drill down, Drill through, cascaded parameters.
• Experience in developing BI applications using Power BI as reporting tool.
• Experience in Power BI Report and Dashboard development.
• Deploying and Scheduling reports to generate daily, weekly, monthly and quarterly reports.
• Developed stored procedures using T-SQL to retrieve data and used it to generate ad-hoc reports.
• Comfortable mentoring others in my team for complex SSRS report experience in Data Analysis, Design, Development, and Implementation of Data Warehousing & Data Integration
• Applications using SQL Server Integration Services
• Experience in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Created SSIS Packages to load data from sources like flat File, Excel, OLEDB,XML, and Oracle to SQL Server
• Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
• Created SSIS Packages with different control Flow options and data flow transformations such as conditional Split, Multicast, Union all and Derived Column etc.
• Created Views and worded on slow running SQL to improve performance.
• Experience in creation indexed views, complex stored procedures and useful functions.
• Created Clustered and Non-Clustered Indexes on tables for performance optimization of complex stored procedures.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse database and data marts.
• Expertise in designing, debugging and testing of reports in SSRS.
• Experience in creating and developing Power BI Dashboards into rich look and configuring data gateways to have an automatic refresh of the dataset.
• Used Power View and created various analytical reports andDashboards from Tabular
• Analyze collaborate with our DBA Teams to improve database strategies and maximize performance, capacity and security.

Environment: SQL Server 2014/2016/2019, Microsoft SQL (T-SQL), SSIS, SSRS, XML and MS EXCEL, .

Confidential, Washington DC

MS SQL Server SSIS/ETL Developer

Responsibilities:

• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Developed SSIS Templates that can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev., Test and Production Environments.
• Worked on development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Created SSIS process design architecting the flow of data from various sources to target and Involved in extracting the data using SSIS from OLTP to OLAP.
• Deployed, scheduled jobs alerted and maintained SSIS packages.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Created SSIS packages to retrieve data from Legacy sources and to retrieve user data from the Flat files on monthly and weekly basis.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• Used techniques like backups, restore, replication, and standby databases to ensure higher availability Production Environment.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Developed, monitored and deployed SSIS packages.
• Good understanding of SSRS with Report authoring, Report management, Report delivery and Report security and created reports with Analysis Services Cube as the data source using SSRS 2008/2012.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Filtered inaccurate data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created incremental data load task using SQL Server Integration Services.
• Involved in project status report updates/creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Performed efficient tuning of SQL source queries for data load/usage of stored procedures for performance.
• Designed and developed custom SharePoint 2013 applications using SharePoint Designer.
• Worked with development teams in the design of physical databases and in modification.

Environment: MS SQL Server 2014/2016, SSRS, SSAS, SSIS, SQL Query Analyzer, SQL profiler, IIS 6.0, Oracle10g, 11g, Enterprise Manager, ERWIN Data Modeler, Windows Server 2008/2010, Share Point Portal Server, HTML, XML, C#, Visual Studio 2017, MS Access, Crystal Reports, MS Excel 2010.