PROFESSIONAL SUMMARY:

• About 8 years of extensive experience in database design, development and administration with BI/MS SQL Server versions 2016/2014/2012/2008 /2008 R2 using SSIS, SSRS (BI Tools) in various industries.
• Strong experience in creating T - SQL objects, working with DDL/DML, performs most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
• Skilled professional with experience in all stages of SDLC: planning, analysis, design, implementation and Worked with SDLC methodologies like Waterfall, Agile (Scrum).
• Extensive experience with SQL Server and T-SQL in data analysis from SQL Server databases as well as PL/SQL in Oracle.
• Proficient in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Created DDL and DML triggers.
• Experience using Try Catch block and @@Error for better error handling.
• Hands on experience in loading OLTP data into the Datamart and Data Warehouse using SSIS packages and also automating it using SQL Server Agent Jobs.
• Expertise in Extraction, Transforming and Loading (ETL) data using SSIS creating mappings/workflows to extract data from SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities (Data Warehouse, Data mart).
• Expert in Creating, Configuring and tuning MS SQL Server Integration Services (SSIS).
• Skilled in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Expert in Creating, Configuring and tuning SSIS packages, SSRS reports and T-SQL queries using tools like SQL Profiler, Performance Monitor and Database Engine Tuning Advisor.
• In-depth Knowledge in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN 7.1 and Visio.
• Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS) and its component like log Shipping, DTS, Bulk Insert and BCP.
• Developed, monitored and deployed SSIS packages.
• Experience in creating various reports like drill down, sub reports, parameterized, Multi-valued and various Adhoc reports through Report model creation using SSRS.
• Good Business and System analysis skills to understand the requirements and customize client applications.  
• Strong troubleshooting and problem-solving skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing and teamwork spirits.
• Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem-solving skills.

BUSINESS/TECHNICAL SKILLS:

• MS SQL Server 2016/2014/2012/2008 R2/2008/2005,
• Reporting Services (SSRS) 2012/2008R2/2008/2005,
• Integration Services (SSIS) 2012/2008R2/2008/2005Tableau 9.X/10.3,
• T-SQL,
• PL/SQL,
• SQL Server Data Tools(SSDT),
• Database Engine Tuning Wizard,
• Visual Studio,
• MS Visio,
• Erwin 3.x/4.x/7.x,
• Tableau 9.x/10.x,
• Oracle 9i/10g,
• C#,
• ASP.Net,
• Team Foundation Server (TFS),
• HP Quality Center,
• Remote Desktop,
• Microsoft Office Suite.

PROFESSIONAL SUMMARY:

Confidential, Jersey City, NJ

Sql Server/SSIS/SSRS Developer

Responsibilities:

• Planned, Defined and Designed data based on business requirement and provided documentation.
• Gathered data and documenting it for further reference and designed Database using Erwin data modeler.
• Created SSIS package to load data from Flat Files and SQL Server by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis using SQL Server Agent.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2012.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Sub-Reports, Conditional, Drilldown reports, Drill through reports and parameterized reports using SSRS 2012.
• Created reports to retrieve data using Stored Procedures that accepts parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database object like stored procedures, functions, tables, views
• Configured the report viewing security for various users at various levels using Report Manager
• Scheduled report and exported in PDF format.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Tools & Technologies-MS SQL Server 2014/2012, T-SQL, SQL Server Profiler, SSIS, SSRS, Team Foundation Server, Share Point, Erwin

Confidential, Newark, NJ

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Developed queries for the advanced segmentation to fulfill paramount importance of customer- centricity.
• Planned and coordinated project levels of performance and activities to ensure project completion in time.
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data warehouse and data marts.
• Created Stored Procedures, Triggers and view Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Created SSIS packages to load data to Sql Server using various transformations in SSIS.
• Prioritized requirements to be developed according to Agile scrum methodology.
• Worked closely with business owners to discuss requirements.
• Analyze marketing metrics to identify relationships between marketing actions & financial outcomes.
• Manipulating, cleansing & processing data using SSIS.
• Resolved any deadlocks issues with the Databases/Servers on a timely basis.
• Developed SQL code for populating the standard lift reports based on business requirements.
• Analyzed massive and complex data sets, performing ad-hoc analysis and data manipulation.
• Analytical design, execution & analysis of marketing campaigns with focus on direct Email.
• Participated in weekly meeting and discussed modification request with management team.
• Work on extensive requirement analysis and gap analysis.
• Created dynamic stored procedures to retrieve the customer details, payment history by giving the related parameters.
• Developed Customer Loyalty metrics report that can be used for predicting estimations for Campaigns.
• Provided data insights with the aid of cohort - trend charts, audience, a/b tests & offer comparison of results with past campaigns.
• Worked with FACETS to create various operational Drill-through and Drill-down reports and different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports using SSRS.
• Help Business owners to pull customer segmentation, targeting & positioning activities.
• Extensively used SQL for accessing and manipulating database systems.
• Automated execution of SQL code with the help of SSRS to publish weekly, monthly and daily reports using SSRS.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)

Tools & Technologies: MS SQL Server 2016/2014, Visual Studio 2012, Share point, Agile/Scrum, TFS server, SSIS/SSRS, HP Quality Center.

Confidential, East Greenwich, RI

SQL Server /SSIS/SSRS Developer

Responsibilities:

• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Successfully extracted data from flat files/excel files, applied complex transformation and loading data to SQL Server DataMart and data warehouse on daily, weekly, biweekly, monthly basis.
• Created database objects like tables, view, store procedures, functions, triggers using SQL server.
• Loaded Excel files consist of OLTP data and processed it with the stored procedures to comply certain rules depending on the company and incentive offers.
• Gathered functional requirements and Business requirements and written the technical specifications for building the Enterprise Integrated Data warehouse.
• Worked closely with developers, end users in designing and creating the Enterprise Integrated Data warehouse.
• Optimization of queries by looking at Execution Plan for better tuning of the database.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Assisted with various ad hoc query requests.
• Extensively used SSIS transformations such as Lookup, Fuzzy Lookups, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Provided back-end support for functional testing, performance testing and provided testing evidence.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from different SQL Server Databases and Excel files, apply business logic, load in table and create view for end users.
• Used Index Tuning Wizard, SQL Profiler and SQL trace for Performance Tuning.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning.

Tools & Technologies-SQL Server 2012/2008R2 enterprise edition, BIDS (SSRS, SSIS, SSAS), Oracle 10g, Windows XP, Erwin 7.1.

Confidential, Kingston, NY

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Extracted data using SSIS packages (ETL) from different server locations and data sources.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
• Designed high level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Analyzed & designed the business rules for data cleansing that are required by the staging & OLAP and OLTP databases.
• Implemented the Data Cleansing using various transformations such as Lookup, Fuzzy Lookup and Derived Column.
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
• Migrated packages from development server to production server using package configuration.
• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, and Drill through, Sub reports using SSRS.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Deployed generated reports onto the Report Server to access it through browser.
• Created various geographical and time dimension reports of fiscal year, quarter month, week and daily reports for all domains and published through Report Server.
• Created various reports by comparing the growth of company based on each quarter by using bar charts.
• Responsible for generating annual reports based on the growth of company with respect to customers.
• Conducted user training sessions and supported the requests for enhancements, modifications and new reports.

Tools & Technologies-MS SQL Server 2008R2, Reporting Services (SSRS), Integration Services (SSIS), Microsoft Performance Point Server 2008R2, Microsoft Share Point Server, T-SQL, .NET, C#, MS Access and Excel.

Confidential, Pinebrook, NJ

SQL Server Developer

Responsibilities: 

• Expert in creating database objects such as tables, procedures, triggers, constraints, indexes and views.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Used highly complex T-SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Created various DTS packages for data transfer and migration.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Creation/ Maintenance of Indexes for fast and efficient reporting process.
• Created reports using stored procedure that involved in scheduling, creating snapshots and subscriptions for the reports (SSRS).
• Designed and developed matrix and tabular reports with drill down, drill through and various other reports using SSRS.
• Created ad-hoc reports using SQL server 2005 Reporting Services (SSRS).
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Involved in project planning, also schedule for database module with project managers.
• Created Stored Procedures and T-SQL code for complex business logic.
• Extract data from database and export to Excel files for Data Analyst to analyze the data.
• Scheduled Packages using SQL Server Agent Jobs to execute at specified time on weekly and monthly basis.

Tools & Technologies: SQL Server 2008/2005, BIDS, MS power point, MS Access, MS Excel, Windows