SUMMARY

• Eight years of experience as SQL Developer with extensive knowledge of data analytics.
• Expert in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS), QlikView and Power BI.
• Acquainted with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Extensive Knowledge and work experience in writing T - SQL queries, RDBMS concepts, Views, Triggers, Stored Procedures, Indexes, and Constraints in SQL Server 2000/2008/2012/2014/2016.
• Extensive Knowledge and experience in data profilingusingSQLon various sources systems.
• Extensive knowledge and experience inproducing tables, reports, graphsand listings using various procedures and handlinglarge databases to performdata manipulations.
• Experienced in ETL processes, Data warehousing methodologies and concepts, dimensional modeling and reporting tools, Data Mart and OLAP technologies.
• Knowledge and experience in Microsoft Azure.
• Conversant with Agile work environment.
• Anexcellent team player& technically strong person who has capability to work withbusiness users, project managers, team leads, architectsand peers, thus maintaining healthy environment in the project.
• Excellent written, communication and Interpersonal skills.

TECHNICAL SKILLS

Databases: SQL Server 2017, SQL Server 2016,SQL Server 2014,SQL, Server 2012,SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000

Database Tools: Business Intelligence Development Studio, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Service, SQL Server Management Studio, Microsoft Azure SQL Database.

Data Analysis Tools: QlikView, Power BI and Microsoft Azure data analytics.

ETL Tools: SQL Server Integration Service (SSIS), DTS

Languages: SQL Server 2016,SQL, Server 2014, SQL Server 2012,SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000.

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Report, Power BI, QlikView.

Office Tools: MS WORD, MS EXCEL, MS VISIO, MS Power Point

Operating Systems: Windows XP, Windows 2008, Windows 7, Windows 8, Windowsserver 2012/2016, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Media, PA

Business Intelligence Developer

Responsibilities:

• Help define and lead key projects within the Corporate BI, Data and Reporting team.
• Working with the user community to capture business requirements and translating them into technical specification.
• Designing, developing, implementing and improving business intelligence and data warehouse solutions.
• Identifying, analyzing and interpreting trends or patterns in data sets.
• Constructing the underlying physical and logical data models required to explore and interpreting information via a variety of analytics platforms.
• Defining and implementing optimized ETL routines to populate the data warehouse with data from a variety of internal and external sources.
• Developing and maintaining technical and end-user documentation.
• Defining, developing and deploying dashboards, reports and visualization to enable metrics-driven decisions.
• Understanding data strategy and supporting it keeping Data governance and Compliance guidelines in mind.

Environment: T-SQL, SSMS, SSRS, SSIS, SQL Server 2017 and Microsoft Visual Studio, MS-Excel, XML, MS Dynamics 2013 CRM, Microsoft Azure.

Confidential, Wayne, PA

MS SQL Server Developer

Responsibilities:

• Responsible for rebuilding datasets using T-SQL and stored procedures as part of performance tuning.
• Performed Query optimization & Performance Tuning.
• Analyzed existing programs and formulates logic for new systems, procedures, performs coding and tests/debugs programs.
• Conducted the analysis of new systems, including requirements of the user and is responsible for maintaining and improving existing applications systems.
• Managed the day-to-day technical aspects of the project and understands the impact of changes throughout the system.
• Validation of datasets and integrity check using SQL queries and Stored Procedures.
• Optimized queries using SQL Profiler and Database engine tuning advisor.
• Responsible for creating Stored Procedures, Functions, Views, Tables, Synonyms.

Environment: T-SQL, SSMS, SSRS, SSIS, SQL Server 2016 and Microsoft Visual Studio, MS Dynamics 365 CRM.

Confidential, Norristown, PA

MS SQL Server/ BIDeveloper(SSIS/SSRS)

Responsibilities:

• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Wrote efficient stored procedures for the optimal performance of the system.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Responsible for Creating and Modifying T-SQL queries, stored procedures/ triggers for validating the integrity of the data.
• Created indexed views and appropriate indexes to reduce the running time for complex queries.
• To keep track of data manipulations using Audit functionalities.
• Extract Transform Load(ETL) development Using SQL server 2008,SQL 2008 Integration Services(SSIS)
• Enhancing and deploying the SSIS packages from development server to production server.
• Created complexSSISpackages using proper Control and Data flow elements.
• Created reports in SSRS with different type of properties.
• Created reports fromOLAP,sub reports, bar charts and matrix reports usingSSRS
• Created report snapshots to improve the performance ofSSRS.
• Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services(SSIS).
• Actively involved in developing Complex Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Responsible for creating datasets using T-SQL and stored procedures.
• Scheduled the packages to keep extracting the data from OLTP at specific time intervals.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Used SQL Server Agent for scheduling jobs and alerts.
• Optimized queries using SQL Profiler and Database engine tuning advisor.

Environment: T-SQL, SSMS, SQL Server and Microsoft Visual Studio, XML, MS Access.

Confidential

MS SQL Server / BI Developer (SSIS/SSRS)

Responsibilities:

• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Wrote efficient stored procedures for the optimal performance of the system.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.
• Created indexed views and appropriate indexes to reduce the running time for complex queries.
• To keep track of data manipulations using Audit functionalities.
• Generated custom and parameterized reports using SSRS.
• Created reports that call sub reports in SSRS.
• Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Responsible for creating datasets using T-SQL and stored procedures.
• Created several packages in SSIS.
• Scheduled the packages to keep extracting the data from OLTP at specific time intervals.
• Used various transformation tasks to create ETL packages for data conversion.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Used SQL Server Agent for scheduling jobs and alerts.
• Performed Query optimization & Performance Tuning.
• Optimized queries using SQL Profiler and Database engine tuning advisor.

Environment: MS SQL Server 2008, MS SQL Server 2012, SSRS, SSIS, SSAS, T-SQL, MS-Excel, XML, Windows 2000/2003/NT/XP/7/8/10