SUMMARY

• 8+ years of overall IT experience with 8+ years of experience as a SQL ETL/BI Developer.
• Broad experience in different phases of Software Development Life Cycle (SDLC).
• Strong experience with demonstrated success in the Database Design, Development, and Implementation using MSSQL Server 2014/2012/2008/2005.
• Extensive experience in T - SQL for developing Stored Procedures, Triggers, Indexes, View, User Defined Functions, CTE, Temp Tables, Table Variables and SQL Joins.
• Experienced in Installing, Upgrading and Configuring Microsoft SQL Server.
• Excellent experience in creating Indexes, Indexed View in observing business rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Extensive experience in creating SSIS packages for extracting, transforming and loading data from Excel, Flat Files and other sources to different databases and data warehouses.
• Extensive Experience with OLTP, OLAP and Data Warehousing Design concepts.
• Experience in implementing& managing Event handlers, Package Configuration, logging, system & user-defined variable, check point, transactions & expression for SSIS Package.
• Proficient in Creating/developing complex SSIS Package.
• Expertise in creating different reports, like Drill-Down, Drill-Through, Parameterized, and Tabular reports based on client requirement using SSRS.
• Developed Report Models based in Relational Databases and created Ad-Hoc reports to the specific users in the requested formats using Report Builder.
• Practical experiences in using charts, graphs, cross tabs and gauges in SSRS reports.
• Experience creating the SQL Jobs, Sending Alerts using SQL DB Mail and schedule SSIS, DTS packages.
• Strong understanding of network security definition and design to include Cisco router /Switch/Firewall Citrix, Exchange EMC SAN Load balancers, Data Domain & Network environment.
• Provided support for UNIX based Applications and servers on an as needed basis.
• Excellent communication and writing skills with the ability to adapt to new and dynamic environments.
• Ability to multi-task, prioritize and work with time constraints while paying attention to details.
• Good problem-solving, judgment, and decision-making skill.
• Ability to work with all levels of management, willingness to learn and implement new ideas quickly and to be a collaborative team player

TECHNICAL SKILLS

Databases: Microsoft SQL Server 2005/ 2008/ 2008 R2/2012/2014, Oracle 11g, My SQL.

Database modelling tools: Erwin, Enterprise Architect, Visio.

Operating Systems: Windows2000/XP/2003/Window7/8, Linux.

Query Language: T-SQL.

Programming Language: C#.

ETL Tools: SSIS 2008/2012, SSMS Import/Export.

Reporting Tools: SQL- SSRS 2012 and 2008 R2, Report Builder 2.0 and 3.0, Power BI.

Web Technology: HTML, XML, DHTML.

Networking: TCP/IP, DNS, DHCP, LAN, WAN.

Other Tools/Technology: SharePoint, Team Foundation Server, Microsoft Word, MS Excel, Outlook Express, Power Point, Visual Studio 2010/13.

Remote Access: Citrix Go to Assist, Dame Ware, Net Meeting, WebEx, Web Mx & VPN.

PROFESSIONAL EXPERIENCE

Confidential, CHARLOTTE NC

SQL ETL SSIS & BI Developer

Responsibilities:

• Involved in understanding the user requirements and developed ETLs using Sql Server Integration Services.
• Involved in Technical Specification Documentation.
• Involved in development of Sql SSIS packages development and unit testing.
• Involved in Deployment of SSIS packages with Sql Server Data Tools.
• Responsible for Motoring Monthly scheduled jobs and checking status mails, taking course of actions, if required.
• Implemented custom logging in ETLs using SSIS 2012.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, For Each Loop, Multi Cast, data type conversion, Script Components, Error handling.
• Wrote and integrated stored procedures to generate the special reports per client’s need.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Drill down reports as well as interactive reports per business requirements in time restricted environment.
• Involved in generating data sets for analysis teams for their analysis input as per the business requirement.
• Involved in Designing tabular, matrix, Parameterized, Drill down and Drill through reports, Sub Reports and charts.
• Created various ETLs using Parent Child design pattern using SSIS 2012.
• Extensive Experience MS SQL Server integration services (SSIS) to import, export & transform the data between the linked servers
• We will load customer file or Sample file in to DB through using different technologies like SSIS, BizTalk server and then validating the customer information through set of Client defined validation rules /Cleaning rules

Environment: SQL Server 2014, windows server 2008, Query Analyzer, SSIS, SSAS, SSRS, SQL Profiler, Performance Monitor, Query Optimizer, T-SQL, Apex Code, Agile, XML, MS Visual Studio, Import Export Wizard, Tableau, Team foundation Server(TFS), GIT,SQL Server-working knowledge of designing/deploying SSRS custom report/dashboard, specifically with Dynamics CRM entities.

Confidential, Mclean, VA

SQL Server ETL & BI Developer

Responsibilities:

• Participated in gathering requirements and discuss details with team lead.
• Analysed the source data and figured out correct data mapping to staging tables, data warehouse and data marts.
• Created Tables, Views, Indexes, Stored Procedure and Triggers.
• Used multiple join statements to retrieve data and update the tables.
• Design and develop T-SQL procedures, query performance tuning and SSIS packages.
• Created functions to provide custom functionality as per the requirements.
• Used SSIS to implement slowly changing transformation to maintain historical data in data warehouse.
• Developed Hive Queries to reach the bench marked time frame& UDFS to Analyse/Transform the data in HDFS.
• Implementing full load and incremental load logic to load data warehouse based on the size of the source data.
• Used various SSIS transformations such as conditional split, look-up table and derived column for data scrubbing and data validation during staging, before loading the data into data warehouse and implement proper auditing for the ETL process.
• Deployed SSIS Package into Production and scheduled SSIS jobs through SQL Server Agent.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Hands of Experience using Query tools like TOAD, SQL developer, PLSQL Developer, Teradata SQL Assistant & Query Man.
• Created summary reports, sub reports, Drill Through and Drill-down reports using SSRS.
• Deployed SSRS reports in to SharePoint portal and Report Manager.
• Extensive Experience with OLTP, OLAP& Data warehousing Design Concepts.
• Utilized Microsoft team foundation server and its features for code sharing and updates from other members.
• Good experience using SSIS script task to create complex transformation logic using C#.net
• Debug through C#.Net code to troubleshot production issues & crated untested methods for validation of codes develop.

Environment: SQL Server 2012, windows server 2008, Query Analyzer, SSIS, SSAS, SSRS, SQL Profiler, Performance Monitor, Query Optimizer, T-SQL, Agile, XML, MS Visual Studio, Tableau, Team foundation Server(TFS), SQL Server-working knowledge of designing/deploying SSRS custom report/dashboard, specifically with Dynamics CRM entities.

Confidential, Glen Allen, VA

SSIS& SSRS Developer

Responsibilities:

• Participated with business analysts to gather requirements for design and implementation of database
• Created complex Stored Procedures, Triggers, User Defined Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Used execution plan and tuning advisor to solve performance issues of query and followed instructions to improve query performance.
• Installed SQL Server Management tools using SQL Server Setup Program.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Created indexed views and appropriate indexes to reduce the running time for complex queries.
• Performed data cleansing and validation to figure out reportable data based on the requirements.
• Developed Query for generating drill down & drill through reports in SSRS.
• Worked on SSIS script task, look up transformation & data flow task using T-SQL & visual Basic (VB) scripts.
• Worked on SSIS packages & utilizing complex transforms, a wide variety of data sources including SQL Server, delimited & fixed width text files, XML, Services, DB2.
• Provided assistance for optimizing& performance tuning of DB2 SQL & Store procedures.
• Wrote and maintained technical documentation based on business and functional requirements.
• Generated Ad-Hoc reports as per the client requirements using Report Builder.
• Generated various SSRS Reports based on requirements.

Confidential

SQL Server Developer

Responsibilities:

• Actively involved in gathering system specification requirements for the project through JRD sessions from business users and Subject Matter Experts (SMEs).
• Involved in creation of functional requirement specifications (FRD) and supporting documents for business systems, experience in database design process and data modelling process.
• Examined and evaluated the data structures in the source and enhanced the old logical and physical database design to fit new business requirement and implemented new design into SQL Server.
• Worked with database objects like Stored Procedures, User Defined Functions, Triggers and Indexes using T-SQL to create complex scripts and batches.
• Created and deployed SSIS packages using various Transformations such as Fuzzy Lookup, Fuzzy Grouping, Aggregate and Derived Column Transformations to make data standardized.
• Involved in package troubleshooting utilizing error logs, checkpoints, breakpoints and data viewers.
• Wrote SQL queries on data staging tables and data warehouse tables to validate the data results.
• Designed and deployed Drill-Down, Drill-Through and Drop-Down features and Parameterized reports.
• Delivered on-demand and scheduled reports on daily, weekly, monthly and quarterly Reports including status for business analysis or management decisions using SQL Server Reporting Services.
• Specified & upgraded all computer equipment including work station, back end SQL servers, routers switch for all location.
• Experience in installing & configuring DNS, DHCP Servers & TCP/IP & OSI Models.
• Managed programs & databases for each module within the operating system (UNIX, VMS, AIX) for the ERP.
• Manage, Check services & perform backups by executing scripts SQL ERP System which runs PL-SQL.
• Follow the standard IT services (ITIL) & the best practices to provide quality client services.

Environment: MS SQL Server 2008/2012, Excel, TSQL, MS visual studio 2008, SQL Reporting services, SQL integration services, SharePoint, Import Export Wizard.