SUMMARY

• A highly motivated SQL Server/BI Developer with comprehensive knowledge of software development life cycle (SDLC) with over 6 yrs of experience in developing SQL database and BI solutions using T - SQL, SSIS, SSRS and SSAS.
• I am seeking to work with a reputed company to achieve new levels of competence.
• Very good hands-on experience with T-SQL programming and good knowledge on RDBMS concepts.
• Proficient in creating objects such as stored procedures, tables, temp tables, views, triggers, user defined functions.
• Experience in writing complex T-SQL queries, common table expressions (CTEs), sub queries, dynamic SQL queries.
• Hands on experience in tuning T-SQL queries to improve the database. E.g. creating various clustered, non-clustered indexes and indexed views.
• Involved in creating Jobs, SQL Mail Agent, Alerts and Scheduled ETL Packages.
• In-depth knowledge of SQL Server BI services, SSIS, SSAS and SSRS.
• Experience at transforming and validating data from heterogeneous data sources (OLE DB, Excel, Flat file, MySQL, Oracle, DB2 etc.) using ETL tools like Conditional Split, Lookup, Merge Join, Sort and Derived Column.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Experienced in building OLAP cubes, fact and dimension tables with different architectures and data sources for business intelligence and populating/maintaining data marts in SSAS.
• Used multi-dimensional expressions (MDX) queries for calculated members of OLAP cube, key performance indicators, aggregation, and measures in SSAS.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Experience in using SQL server reporting Services (SSRS) and creating various reports such as Parameterized, Cascading, Tabular, Matrix, Chart, Drill through and Drill down reports.
• Familiarity in creating web applications using ASP.Net, XML, HTML, JavaScript.

TECHNICAL SKILLS

Components/Environment: SQL-Server 2008R 2/2012/2014/2016 , SQL-Server Management Studio (SSMS), Integration Services (SSIS), Analysis (SSAS), Reporting Services (SSRS), SharePoint, Power BI. Service

Software Applications & Tools: Microsoft Visual Studio, Erwin, UML, Microsoft Visio, DB2, Power BI, MySQL, ArcGIS, Erdas, Envi. Oracle

Programming Languages: TSQL, MDX, vb, C#, .Net Framework.

Web Technologies: HTML, XML, ASP.Ne, Java Scripts.

Operating Systems: WINDOWS ... Server, UNIX, Linux.

PROFESSIONAL EXPERIENCE

Confidential

SQL Server/ BI Developer

Responsibilities:

• Analyzed the existing database structure, designed and normalized the databases, involved in installing and migrating databases.
• Responsible for running day to day ETL processes and automating a variety of manual data integration tasks and designing SSIS packages to transfer the data from DB2, flat files and excel documents to the Staging Area.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Loop Containers, Fuzzy Lookups, and Derived Columns.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Scheduled Packages using SQL Server Agent Jobs, monitoring nightly jobs.
• Involved in implementation of data mart and OLAP cubes using SSAS and extensively used SSIS Import/Export Wizard for performing the ETL operations.
• Extracted data using ETL from OLTP to OLAP. Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Created views and stored procedures to be used by Sharepoint and Power BI dashboards.
• Created dashboards using Performancepoint dashboard designer, combining scorecards and reports generated in SSRS, and Excel Services.
• Uploaded reports on to the report manager and organized them into folders.

Environment: MS SQL Server 2012/2014, SSAS, SSIS, SSRS, Visual Studio 2012, SharePoint, Power BI, Erwin, Oracle, DB2, Excel, ETL, MDX, XML.

Confidential

SQL Server/ BI Developer

Responsibilities:

• Loaded legacy source data from MSSQL, MySQL, Oracle, and Access into SQL Server 2008 R2 staging DB’s using SSIS Import & Export Wizard and VB scripts and SSIS packages.
• Created TSQL stored procedures, functions, etc. and tuned them using query analyzer and explain plans.
• Performed data profiling, data analysis to identify legacy data that needs data cleansing prior to the migrations using SSIS Data Profiling Task, Data Profile viewer and T-SQL queries.
• Used various transformations, tasks, containers present in SSIS which include Fuzzy grouping, Derived Column, Conditional Split, Aggregate, Lookup, Merge Join, Union All, Copy column, Data conversion.
• Used Fuzzy grouping transformation to consolidate data and submitted data cleansing reports to the client.
• Identifying, and documenting ETL Standards and best practices for the development team.
• Troubleshooting ODBC and OLEDB connection issues in SSIS packages.
• Involved in performance tuning of ETL transformations, data validations and stored procedures.
• Participated in creating data conversion and migration strategy, conversion design and conversion development documents.
• Hosted SSIS, SSRS knowledge transfer, data quality issue meetings with the client on a weekly basis.
• Deployment of SSIS packages to the conversion server and create and schedule SQL Server Agent jobs to automate the run of SSIS packages on a weekly basis.
• Experience in creating master and child packages, using package configurations and SSIS logging.
• Performed SQL Server DBA tasks like Conversion DB backups using compression, restore and disk space management on the conversion server, disabling and enabling constraints and triggers, applying DB Change requests, lookup data changes in corporation, logins & permissions.
• Used SSRS Report Designer to create reports from OLTP and OLAP data sources and deployed on report server.

Environment: SSIS 2008/2012, SQL Server 2008R2, T-SQL, Visual Basic Studio, C#, .Net, Vb6, XML, Microsoft Project, Microsoft Access, SSRS, Microsoft Excel.