SUMMARY

• 9 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 2016/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.
• Experienced in writing complex DAX functions inPower BI and Power Pivot.
• 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 SQL ETL 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.
• Extensive Experience Develop visual reports, dashboards and KPI scorecards using Power BI desktop.
• Expertise in creating different reports, like Drill-Down, Drill-Through, Parameterized, and Tabular reports based on client requirement using SSRS.
• Created shared dimension tables, measures, hierarchies, levels, cubes, and aggregations on MS OLAP/ Analysis Server (SSAS).
• Experience in Creation and deployment of cubes on SSAS.
• 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

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

Database modelling tools: Erwin, Enterprise Architect, Visio.

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

Programming Languages: C#, .NET

Web Technologies: HTML, XML, DHTML.

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

Query Language: SQL, T-SQL, Payton & other coding Languages

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

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,Code Coverage X-unit test.

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

PROFESSIONAL EXPERIENCE

Confidential

SQL BI Developer

Responsibilities:

• Generated complex Transact SQL(T-SQL) queries, Sub queries, Co-related sub queries, and Dynamic SQL queries. Programming in SQL Server - Using the Stored Procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs)
• Interacted with technical team and Business users to perform analysis of business requirements and transformed them into technical requirements for ETL and Reporting needs.
• Experience in coding the T-SQL using the Temp tables, Table variables by analyzing the Business logics.
• Deep financial and sales reporting experience for software data visualization in Data Studio,
• I interacted with team providing BI Support to multiple teams within Cloud Organization Mapping Requirements to Data Model
• Investigate and resolve data access issues.
• Performed data cleansing and validation to figure out reportable data based on the requirements.
• Build new PLX dashboards, modify existing dashboards.
• Generated Ad-Hoc reports as per the client requirements.
• Involved in Coding Data Aggregation Workflows
• Involved in understanding the user requirements and developed ETLs using SQL Server Integration Services.
• Involved in Technical Specification Documentation.
• Responsible for Motoring daily and Monthly scheduled jobs with workflow and checking status mails, taking course of actions, if required.
• Analysed the source data and figured out correct data mapping to staging tables, data warehouse and data marts.
• Create a System that generate reconciliation report, generate those reports for clients for legacy to Target comparison.
• Restore SQL database, Integrity Verification, Data cleansing, Analysis, and Interpretation.
• Modeling, Database Design, Test, and implementation of data warehouse and
• Extract, Transform, Load (SQL ETL) processes.

Environment: SQL Server 2016, SQL Server 2019, Query Analyzer, SQL Profiler, Performance Monitor, Query Optimizer, T-SQL, Apex Code, Agile, XML, MS Visual Studio, Data studio Import Export Wizard, Tableau, Power BI Desktop, Agile Jira, Kanban

Confidential, NC

Sr. 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 SQLSSIS packages development and unit testing.
• Involved in Deployment of SSISpackages with SQL Server Data Tools.
• Responsible for Motoring Monthly scheduled jobs and checking status mails, taking course of actions, if required.
• Implemented appropriate logging, error handling and notification routines to aid maintainability support of ETL process.
• Implemented custom logging in ETLs using SQL SSIS 2012.
• Created 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.
• Create reports in Power BI preview portal utilizing the SSAS Tabular.
• Used SSAS features to build and configure Hierarchical dimensions, define Measure groups, create Calculated Measures, KPI, configure Partitions, aggregations as well as Actions.
• Involved in generating data sets for analysis teams for their analysis input as per the business requirement.
• Performance tuning of the ETL process and SQL queries and implement ETL and query tuning techniques.
• Extensive Experience SQL (query performance tuning, index maintenance, etc.) as well as an understanding of database structures.
• 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.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI
• Prepare and update project documentation on SharePoint site.
• Experienced in designing and implementing Star and Snowflake Schemas.
• Generating daily Autosys reports, identify and trouble shoot failed jobs.

Environment: SQL Server 2014, SQL Server 2016, 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, Power BI Desktop, Team foundation Server (TFS), GIT, SQL Server-working knowledge of designing/deploying SSRS custom report/dashboard, specifically with Dynamics CRM entities, Jira software, Agile Jira, Kanban.

Confidential, DC

Sr. SQL/ETL Data Warehouse SSIS & 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.
• Developed Star schema using SSAS cubes.
• Worked withSSASin creatingcubes, data source views, named queries, dimensions and deploying of analysis services projects.
• 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 into 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.
• Designed Dimensional Modelling using SSAS packages for End-User. Created Hierarchies in Dimensional Modelling.
• We will load customer file or Sample file into DB through using different technologies like SSIS, BizTalk server and then validating the customer information through set of Client defined validation rules /Cleaning rules.
• 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.
• Define, design, and develop interactive dashboards and other automated reporting in Tableau / Power BI, SAS, and Business Objects.

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

Confidential, Glen Allen, VA

SQL STAGING 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.
• 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.

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

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 workstation, 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.