SUMMARY

• I am a dedicated and detail - oriented person with more than 12 years of IT experience from which more than 6 years SQL server/BI Developer in Database and Business Intelligence Technologies with expertise in SQL Server Database, ETL and Report development using SQL Server 2008/ 2012/2014/2016 , SSRS, SSIS, and Power BI.
• Proficient in database activities like data profiling, data modeling, database design, development, database creation and maintenance, performance monitoring and tuning, troubleshooting, and normalization
• Proficient in writing T-SQL queries, dynamic-queries, sub-queries and complex joins for generating complex stored procedures, triggers, user-defined functions, views, relational database models, data dictionaries, and maintaining data integrity.
• Experienced in Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join, Sort and Derived Column.
• Expert on Configuring MS SQL Integration Service Catalogs, creating Dynamic SSIS Packages with Parameters, local and environmental variables, and check points.
• Performed data migration using import/export, BULK INSERT and Bulk Copy Program (BCP) between heterogeneous systems and SQL Server; Created Alerts and Scheduled SSIS Packages.
• SSRS- created reports with SQL Server Reporting Services (SSRS) and Created Drill Through reports, Drill Down reports, Sub-reports, Cascading Parameters, Linked reports, Matrix etc.
• Power BI- created different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc.
• Quick in learning and applying new technologies and tools and outstanding analytical, presentation and time-management skills. Possess a strong ability to quickly adapt to new applications and platforms.

TECHNICAL SKILLS

• MCSA - Developing SQL Server 2016
• Microsoft BI (SSIS, SSAS, SSRS), T-SQL development
• Network +, Security +, Windows Server 2008/2012
• Salesforce Administration/ development
• T-SQL, C++, Apex, Visualforce, HTML, DAX
• SQL Server Management Studio, Visual Studio (Visual Studio 2010/2012/2015/2016/2017 ), and Microsoft Office (MS)
• Good exposure to entire Software Development Life Cycle (SDLC)
• Jira Agile methodology

PROFESSIONAL EXPERIENCE

SQL and BI Developer

Confidential

Responsibilities:

• Analyzed business requirements and built conceptual, logical, and physical data models that describe all the data and relationships between the data
• Installed and Configured SQL Server 2014/2016 on physical Server and Virtual environments.
• Created T-SQL Stored Procedures, User Defined Functions, Indexes, Views, Constraints, Triggers and wrote complex queries using Joins, Aggregate Functions, Sub-queries, Derived tables and CTEs (Common Table Expression).
• Built and deploy SSIS packages for data extraction and loading including such transformations as Slowly Changing Dimensions, Lookup, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Performed data migration using import/export, Bulk Insert and BCP (Bulk Copy Program) between heterogeneous systems and SQL Server. Scheduled SSIS Packages
• Created reports with SQL Server Reporting Services (SSRS) and Created Drill Through reports, Drill Down reports, Sub-reports, Cascading Parameters, Linked reports, Matrix etc.
• Power BI- created different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc.
• Develop, publish, and schedule interactive Power BI reports and dashboards to meet business requirements .
• Developed relational databases and multidimensional OLAP data warehouses

Environment: Power BI , DAX, SQL Server 2014/16, SSMS, SSIS, SSRS, SSAS, T-SQL, MS Excel, Windows 10, Jira, Lucid Chart, Visual Studio 2016/2017

BI and Database Developer

Confidential

Responsibilities:

• Interacting with Business users, gathering and analyzing requirements
• Built and deployed SSIS packages for data extraction and loading including such transformations as Slowly Changing Dimensions, Lookup, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Created reports that contained Parameters, Sub-Reports, charts, gauges with Drilldown and Drill through features in MS SSRS 2012/2014/2016
• Analyzed the Sources, Targets, Transforming the data, and Mapping the data and Load the data into Targets using SSIS
• Created complex stored procedures and functions to support efficient data manipulation
• Recovering the databases from backup in disasters
• Implemented Error handling and utilized Event handlers for automated notification using SSIS

Environment: Power BI , SQL Server 2014/16, SSMS, SSIS, SSRS, T-SQL, Windows 10, MS Excel, Visual Studio 2014/16

IT Support Specialist

Confidential

Responsibilities:

• Monitor various servers from a dedicated command center.
• Provide onsite support for hardware failures on various Virtual Tape Servers.
• Prepare problem tickets via Confidential ’s internal incident management applications (Maximo).
• Perform daily/weekly full and incremental backups for Confidential Z/VM servers.
• Provide user’s account support for local/remote users.
• Run scripts daily to check database growth.
• Runs scripts daily to check systems performances.
• Write logs to keep track of activities using Confidential ’s internal application.
• Update online procedural documentation accordingly.
• Ensure all security measures are applied accordingly.
• Secure all customers’ data in respective of each customer.
• Configure and build Confidential 2105 and 2107 Shark Disks according to customer specification

Environment: Confidential Maximo, Lotus Notes, MVS, VM, Microsoft Office, Disaster Recovery test, ATL (Automated Tape Library), Confidential Z/VM server, Confidential Shark Disk