PROFILE:

Professional, dedicated, and resourceful with proven success in developing with BI/EDW Applications SSIS, SSAS and SSRS. Demonstrated ability to analyze complex situations. Set goals and conceived strategies in meeting deadlines and produced several successful projects

PROFESSIONAL SUMMARY:

• A Microsoft certified professional with 7 years of total IT experience in the design, modeling, development, implementation and support of SQL Server 2012/2014.
• Expert in analyzing designing development, installing, configuring and deploying SSRS, SSAS and SSIS.
• Experience in maintain one - to-many and many-to-one relationships while moving data between two databases.
• Experience in using Cte, temp tables and effective DDL/DML trigger to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Expertise in writing T-SQL queries, dynamic, sub-queries and complex joins for generation complex stored procedures, triggers, user-defined functions, view and cursors.
• Extensive knowledge in database maintenance, SQL query optimization & performance tuning using performance tools like SQL Profiler, Index Tuning Wizard, and Database Engine Tuning Advisor.
• Skilled in error and event handling precedence constraints break points, check points and logging.
• Extensive experience in developing Drill through and Drill down reports, parameterized reports, Linked reports, Sub reports, Matrix reports, and Chart reports using MS SQL Server Reporting Services (SSRS)
• Strong experience in designing and developing large number of reports in SSRS using the data from ETL Loads
• Experience in using SSIS tool like import and export wizard, package installation and SSIS package designer.
• Experience in ETL process involving migrations and in sync process between two databases.
• Experience in Building cubes using SSAS. Experienced in MDX Queries which is used for querying
• Multidimensional Data from analysis services and supports two distinct models.
• Defining data warehouse (star and snow flake schema), fact table, cubes, dimensions, measures using SSAS.
• Highly proficient in working with users to gather requirements, analyze them, and subsequently use design tools to model the requirements.
• Ability to handle multiple tasks, initiative and adaptable, self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.
• Ability and willingness to learn new technology and deliver results in a timely manner.
• A well-organized, goal-oriented, highly motivated effective team member.
• Ex perienced in Business Intelligence and ETL implementation based on Microsoft SQL Server, Microsoft Integration Services (SSIS), Microsoft Analysis Services (SSAS), and Microsoft Reporting Services (SSRS).
• Data Warehouse Design and Implementation.
• SQL Query Optimization and Performance Tuning.
• Microsoft SQL Server DBA (up to SQL 2016).
• Strong knowledge and background on Oracle Database Server. Core competencies
• ETL Design and Implementation.
• Relational Data Modeling.
• Multidimensional Data Modeling (Snowflake and Star Schema).
• Parallel Data Loading.
• Database Security. / Data Partitioning
• Co-ordination with regional warehouse teams for 6 regions for monthly production load process into EDL. Working closely with business and functional users for enhancement requirements and documentation

TECHNICAL SKILLS:

MS Office: Windows 98,2000,XP,NT, 7, Vista, 10, 2010 MS Office Excel, Word, Outlook, PowerPoint

Database Tools: SQL Server Management Studio(SSMS)2008, 2016,2017, SQL Server Business Intelligence Development Studio (BIDS), SSIS, ETL

BI Tools: Visual Studio 2017 SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), Tableau Reporting services.

Languages: T-SQL, PL/SQL, C#, UNIX Shell scripting, Batch Scripts, PowerShell, Python

PROFESSIONAL EXPERIENCE:

Confidential, Livingstone, New Jersey

Consultant ( SQL/SSIS/SSRS) ETL Developer

Resposibilities:

• Collaborated with Business People for requirements gathering and Participated in translating the business requirements into technical requirements in agile methodolgy.
• Involved in design and developing the end-to-end ETL process.
• Prepared High-level design document and mapping document according to the business requirements by analysing different data sources.
• Designed and developed mappings in SSIS to load the data into Oracle/MSSQL database.
• Extensively used different transformations such as Source qualifier, look up (connected and unconnected), Expression, Aggregator, Update strategy, Sequence generator, Joiner, Filter, Rank, Normalizer and Router transformations.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Implemented Slowly Changing Dimensions (SCD) Type 1 and Type 2 for initial and history load using SSIS .
• Wrote Unix shell scripts to transfer files from windows servers to Unix server using sftp connections, file validation including checking existence of file, file name check, file size and archiving.
• Developed SSIS mappings to perform file validation (field datatype, length, file count, header etc.) on the files provided by business users and to load those files into the Oracle database.
• Used various SSIS functions in the mappings.
• A rchitect, Install and configure Control-M environments
• A dministered Control-M environments, applied latest Patches and Fix-Packs
• D esigned Job request and change process and request forms
• Worked with various Confidential clients and Confidential partner to provide custom solutions to their unique scheduling need
• Wrote SQL stored procedures to extract data and applied transformation logic in the query before loading data into target table.
• Tested Stored procedure stage-by stage and created partitions and indexes on the tables for the better performance of the query.
• Scheduled the work-flow using Active Batch and configured the Active Batch to send success and failure emails of the jobs to IT support team and business users.
• Performed the unit testing as per the design document and mapping design flow.

Confidential, ALLEN, TEXAS

MSBI (SQL/ SSIS/SSRS /SSAS ) ETL Developer

Responsibilities:

• Worked on all activities related to the development, implementation, administration and support of ETL processes
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases
• Used advanced SSIS tools (i.e. Derived Columns, Condition Split, Data Conversion, Aggregations, Multicasting).
• Contributed to the development and modification of coding standards for the team to ensure consistency, efficiency and accuracy in reporting and data analysis.
• Enhanced performance using optimization techniques-normalization and indexing
• Performance tuning of Queries and Stored Procedures.
• Performance tuning on existing ETL packages.
• Designed various SSRS reports as requested by the client
• Created and developed Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created Dashboards, Tabular, Matrix reports (cross-tab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Rendered reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and managed subscriptions.
• Applied security to reports on item and folder level.

Confidential

SQL Server SSIS/SSRS ETL Developer

Responsibilities:

• Designed, reviewed, and created primary objects such as Views, Indexes based on logical design models, user requirements and physical constraints.
• Worked extensively on creating SSRS canned and ad-hoc reports (Model based) using Business Intelligence Development Tools.
• Extensive experience in designing, creating and deploying SSIS packages for transferring data from Flat files, Excels spreadsheets and heterogeneous data to and from SQL Server.
• Regular monitoring of Time/Data driven Subscription based SSRS reports (Daily, Weekly, Monthly) and SSIS external file transfers.
• Created parameterized reports for the users and clients, with drill-down, drill-through features.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Created Entity Relationship (ER) diagrams based on requirements.
• Worked extensively on creating Stored Procedures, Views to support Web front Dashboards and reports.
• Administrated interface to organize Reports and Data Sources, schedule report execution and delivery, subscription of reports and track reporting history.
• Generated Weekly and Monthly Trigger based Reports regarding assigned projects to designated Managers and Clients, Formatted reports for various Output formats.
• Managed business issues on connectivity, permissions, data validation and worked closely with business analysts for report generation.
• Coordinated with DBA in creating and managing Tables, Indexes, Triggers, Db links and Privileges.
• On call 24/7 support to databases as needed.

Confidential, Boston, MA

MS SQL BI Developer

Responsibilities:

• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS).
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MSSQL Server by using BCP utility, DTS and SSIS services.
• Perform unit testing at various levels of the ETL.
• Worked on Migration of packages from DTS using SQL Server Integration Service (SSRS).
• Generating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Involved in Report writing according to business requirement using SSRS.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.
• Designed and created the table schema and stored procedures that will be used in Data QC.
• Designed and developed the Data QC Maintenance website that will be used to maintain the application tables, execution of main Data QC store procedures, and report generation that will be exported to Microsoft Excel file.
• Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
• Responsible for documentation of system related activities.
• Setup replication within the SQL databases.
• Provides technical documentation of the system
• Setup the database with suitable memory and hard disk space allocation, creating different user and security profiles for the team.

Environment: SQL Server 2005/2008/ 2012/2014/2016 , MS Access, SSRS, SSIS, T-SQL,, C# .NET, ADO.NET, Microsoft Visual Studio.Net 2005, .NET Framework 2.0, EXCEL2007.