SUMMARY:

• Over 7+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server .
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services ( SSRS ) with good knowledge on SQL Server Analysis Services (SSAS).
• Experience in Creating and writing complex SQL and T - SQL queries, Views, Indexes, Stores Procedures, DDL/DML Triggers and User-Defined Functions to implement Business Logic and Data Protection.
• Experienced in writing complex T- SQL queries using Inner, Outer and Cross Joins.
• Experience in creating/deploying Data Transformation Services (DTS), MS SQL Server Integration Services(SSIS) packages, Reporting Series( SSRS ).
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Integrity using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique).
• Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for unstructured and redundant data.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Proficient in OLTP, OLAP and Data Warehousing Design concepts
• Worked in AGILE/SCRUM methodology in development of Database Objects in SQL Server
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Established ETL design practices for optimization and performance of packages and Parameterized SSIS packages with the use of environment variables.
• Migrated and tested DTS packages to SQL Server to Integration Services (SSIS). Tuned the Production Server to get Perform improvement by using SQL Profiler, SQL Commands and Database Tuning Advisor.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) (2005).
• Preparing Dashboards using calculations, parameters in Tableau.
• Created dashboard reports with drill down reports, drill through reports, parameterized reports, table reports, chart reports, matrix and sub reports.
• Experience in Crystal Reports, MS Access and report writing using SQL Server Reporting Services ( SSRS ) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in report writing using SQL Server Reporting Services ( SSRS ) and in creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports, create complex reports (ex: drill down reports using different objects) using SSRS .
• Experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimensions using SQL Server Analysis Services (SSAS).
• Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views, SSAS-Data Mining Models and Deploying and processing SSAS objects.
• Expertise in Debugging, Optimizing and Performance Tuning of MS SQL SERVER
• Experience in MS SQL Server configuration, performance tuning, query optimization, back-up/recovery, running Database Consistency Checks using DBCC. Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Cooperative person and self-starter with phenomenal relational abilities, capacity to work autonomously or as a piece of group and equipped for grabbing new aptitudes rapidly.

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

Sr. MS SQL SSIS Developer

Responsibilities:

• Design ETL packages and workflows for the Data warehouse project
• Design auditing, batching and logging the SSIS workflow.
• Develop SSIS packages to get data from multiple FTP and SFTP data sources.
• Decrypt SFTP files once received and load the da ta.
• Build SSIS packages using various control flow tasks and transformations to load the data into the databases.
• Work on setting up EDW from different data sources.
• Created ETL to load the data from Source System into stage and to EDW.
• Worked on Creating SSAS tabular Models to build reporting layer for Adhoc reporting.
• Implement Logging to track and create ETL dash boards to monitor the ETL Process.
• Error Handling and Auditing implemented in SSIS to track down the data discrepancies.
• C reated SSIS package to vendors in which records were loaded daily, also to other data resources such as Excel, Access, flat file and XML in order to create and maintain a centralized database.
• Applying strategies for data acquisition ODS implementation, and archive Process.
• Designed and built relational databases.
• Worked on power pivot models, power maps and Power view.
• Worked in pulling data and deal with heterogeneous sources and optimize the data extraction and conversion process using SSIS.
• Involved in daily loads (FULL & INCREMENTAL) into Staging and ODS areas, troubleshooting process issues and errors ( SSIS).
• Extract and encrypt data files. Send them via SFTP to Client Sites.
• Build regular ad-hoc reports using SSRS SQL Server Reporting Services with help of various tools such as Group by, Drill-down, Cascading, Summarized, Matrix, Map and Cross-join.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
• Designed and developed the reports accor ding to the requirements using Power Map.
• Involved in Installation, Configuration and Deployment of Reports using SSRS.
• Scheduled the reports to run on daily, weekly basis in the report manager.

Environment: MS SQL Server 2016/2014, Windows Server 2012, SSMS, SSRS, SSIS, SSAS, Report Model, Erwin, Team Foundation Server, Performance Point Server, ProClarity, snap manager, SharePoint (MOSS), FTP, MS-Visual Studio.

Confidential, Chicago, IL

MS SQL Server SSIS Developer

Responsibilities:

• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS) .
• Developed various operational Drill-through and Drill-down reports using SSRS.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved with Query Optimization to increase the performance of the Report.
• Developed Reports for business end users using Report Builder with updating Statistics.
• Create charts and pivot tables in Excel.
• Established ETL design practices for optimization and performance of packages and Parameterized SSIS.
• Updated functional specification and technical design documents.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Analyze existing ETL jobs and find the gaps .
• Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Designed an OLAP system with the help of ERWIN to visualize data structure.
• Extracted data from heterogeneous sources and transferred to OLAP using SQL Server Integration Services (SSIS) 2008/2014.
• Create low level design and ETL design doc according to requirement.
• Generated daily, weekly and monthly reports using SSRS 2008/2014.
• Served as a SSRS 2008 Reports Developer and SQL Server Developer in support of Service Management System.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS using Visual Studio 2010.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.

Environment: SSIS, SSRS, MS SQL Server 2012/2014, 2008, R2/2005, C#, SharePoint, Visual studio 2008/2010, MS Access, MS Excel, MS Office Access 2007.

Confidential, Chicago, IL

SQL Server SSIS SSRS Developer

Responsibilities:

• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User defined Data type, Clustered & Non-clustered Indexes .
• Installed and configure servers and clients using SQL Server 2008,Upgraded SQL databases .
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing .
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards .
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases .
• Query optimizations (T SQL or Query Analyzer) using query analyzer and Index tuning wizards.
• Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties .
• Knowledge of Database Performance monitoring tools .
• 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 packages in SSIS with error handling and worked with different methods of logging in SSIS .
• Created ETL SSIS packages both design and code to process data to target databases .
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis .
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages .
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Created jobs to collect status information from various servers and feed them to the Master Server .
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks user counts and connections/locks etc.
• Implement automated Index Maintenance strategy run as SQL Job on a daily basis
• Created Snapshots, Subscriptions and Transactions using Replication services
• Worked on Transactional Replication and replicated thousands of tables from various Databases to different production Server
• Resolving any dead locks issues with the Databases/Servers on a real-time basis.
• Worked on development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 2005 for further
• Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems
• Migrated SQL server 2000 DTS packages to SQL Server 2008 SSIS packages using SQL Server 2008 Upgrade Advisor
• Responsible for the design of the SSIS package for updating the data mart from OLTP database and validation of the aggregate data from the ODS and the OLTP Database.

Environment: MS SQL Server2012/ 2008, MS SQL Server Master Data Services 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Visual Studio.NET# 2008, SAP Business Objects, BI Extractor, Microsoft Excel, Add-In Excel with Master data.

Confidential

SQL SSIS Developer

Responsibilities:

• Wrote stored procedures, triggers, and constraints to ensure data integrity, data consistency an d to meet the business rules.
• Converted various T- SQL statements into stored procedures thereby reducing the number of database accesses.
• Created T- SQL triggers, tables, views and SQL joins and queries for the application.
• Wrote various Stored Pro cedures for the purpose of application development.
• Designed and implemented data access stored procedures and Triggers for automating tasks.
• Tuned SQL statements and Stored Procedures.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Developed SQL Server Stored procedures and SSIS packages to extract data from database.
• Performed query optimization and checked performance tuning.
• Integration of PPS (Performance point server) and Excel Services to MOSS (Microsoft Offi ce SharePoint Server) via PPS (Performance point server) and Excel Services web parts.
• Created joins and sub-queries for complex queries involving multiple tables.
• Proper use of Indexes to enhance the performance of individual queries and enhance the Stored Procedures.
• Dropped and recreated the Indexes on tables for performance improvements.
• Used query analyzer to optimize queries.
• Created SSIS packages for transferring the data from different systems.
• Designed and developed a windows appl ication to pull associates details from outlook without any Database access using ASP.NET, C#, MS Outlook.
• Designed and implemented DTS package for data transformation and migration.
• Design and developing SSIS packages to import data from various large volume encrypted files into SQL database for data warehouse.
• Transformed data from various data sources using OLEDB connection by creating various DTS packages.
• Used Tableau to develop dashboards for more intuitiveness as per the user requirements.

Environment: Microsoft SQL Server 2012, Windows Server 2003, SQL Profiler, SSIS, BIDS, Performance Tuning, Oracle 9i, Visual Studio, T SQL, PL/SQL.