SUMMARY

• About 8 years of extensive experience in database design, development and administration with BI/MS SQL Server versions 2014/2 R2/2005 using SSIS, SSAS, 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.
• Proficient in creating Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Experience in writing Distributed Queries between SQL Servers.
• Expert in using tools like Index Tuning Wizard, database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning Server Performance.
• Handled vast financial data, expert level query optimization and performance tuning experience.
• Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
• 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).
• Expertise in generating reports using SQL Server Reporting Services (SSRS), and Microsoft Access & Excel spreadsheet.
• Experience in creating various reports like drill down, sub reports, parameterized, multi-valued and various Adhoc reports through Report model creation using SSRS.
• Proficiency in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• Excellent Knowledge of Software Development Life Cycle, RDBMS, Data Warehouse & Data Modeling concepts.
• 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.

TECHNICAL SKILLS

• MS SQL Server 2014/2012/2008 R2/2008/2005
• MS SSRS 2012/2008/2005
• MS SQL SSAS 2012/2008/2005
• MS SSIS 2012/2008/2005
• DTS
• Erwin Designer 2000
• Power designer
• DB2 SQL syntax
• MS-Access 2000
• C
• C++
• VB 6.0
• Developer 2000
• Erwin 9.64/9.x/8.x/7.3
• Oracle 9i/10g/11g/12c
• T-SQL
• PL/SQL
• ASP.NET
• HTML
• XML
• XSL
• Visual Studio 2010/2012/2015
• T-SQL
• PL-SQL
• Crystal Reports
• ODBC
• MS Office
• Windows NT/ 2000 Server/ XP.

PROFESSIONAL EXPERIENCE

Confidential, Livingston, NJ

SQL Server/SSIS 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.
• Created Stored Procedures, Triggers, and views, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Created SSIS packages to load data from Oracle 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.
• Performed Data profiling and Data Quality.
• 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.
• Performed the What-if analysis results: what happened- why it happened.
• 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.
• 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 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)

Confidential, Warren, NJ

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Extract data from different sources like SQL server, MS Excel, MS Access, Oracle and transform and load into Dimension and Fact tables in Data Warehouse using SSIS.
• Developed SSIS packages to process all excel files within folder, File System Task to move file into transaction log data into the SQL table, file watcher task to seek for the particular file into individual folder, Execute SQL task to execute.
• Created Dynamic SSIS packages using expressions, variables and control flow
• Components such as For Each Loop, For Loop to loop over a Directory to load inbound files coming daily.
• Implemented ETL to Extract and Transform data from Flat File or CSV, Excel instance and to load into Staging Database.
• Responsible for automation of daily, weekly and monthly system tasks using sql server agent and BPA automation tool.
• Created new workflow with almost 30-40 tasks and declared variables to point out path of those package.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Created stored procedures and views in order to get audit count for daily, weekly and monthly process and added those in the BPA automation as a task.
• Active in SQL server production support and error handling in timely manner. Also checked on package expressions, input SQL, Provider name, and catalog to figure out cause of failure.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server. Wrote the queries for the drill down reports.

Confidential, NYC, NY

SQL /SSIS 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 2008R2 to SQL Server 2012 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.

Confidential, New York, NY

SQL Server/SSIS 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.
• Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Conducted user training sessions and supported the requests for enhancements, modifications and new reports.

Confidential

T SQL Server Developer/ SSIS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• InstalledSQL Serverand Management tools usingSQL ServerSetup Program.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files,SQL Server, Excel and Access toSQL Serverusing Business Intelligence Development Studio.
• Applied various data transformations like Aggregate, Sort, Multicasting, Conditional Split, Derived column.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Handled slowly changing dimensions to maintain the history of the data.
• Migrated packages from development server to production server using package configuration.
• Designed, Developed and Deployed reports in MSSQL Serverenvironment using SSRS.
• Generated Sub-Reports, Drill down reports, Drill through reports and parameterized reports using SSRS.
• Implemented AD HOC reporting with the report builder for the end users.
• Created reports to retrieve data using Stored Procedures that accepts parameters.
• Generated reports using Expressions and Functions using SSRS.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Designed, reviewed, and created primary objects such as views, indexes based on logical design models, user requirements and physical constraints.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• UsedSQL Serverprofiler for auditing and analyzing the events, which occurred during a particular time horizon and stored in script.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.

Confidential

T SQL Server / SSRS Developer

Responsibilities:

• Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
• Successfully installed and configured MS SQL Server 2008 on the production server.
• Automated the migration of data from Oracle DB to MS SQL Server 2008 DB using Microsoft SQL Server Migration Assistant (SSMA).
• Generated assessment reports to analyze the scope and complexity of the migration projects.
• Converted the Oracle DB objects to MS SQL Server 2008 DB objects like tables, views, and stored procedures.
• Designed a new schema design for the data warehouse using dimensional modeling and developed it using the Erwin tool.
• Migrated the entire schema as well as data into MS SQL Server 2008 and also validated the migration process to ensure that it has been successfully migrated.
• Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.
• Designed drilldown, drill through, and parameterized report using SSRS.
• Deployed generated reports onto the Report Server to access it through browser.
• Designed, reviewed, and created primary objects such as views, indexes, views and store procedures.
• Worked with User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least update to improve the query performance.
• Defined referential relationships with the measure groups and fact tables.
• Documented the development work and production release for future reference