SUMMARY

• Skilled IT professional wif 7+ years of Data Warehouse and Business Intelligence experience in Analysis, Design, Development, administering client - server applications using Confidential SQL Server BI suite (SSIS, SSRS, SSAS) and Confidential Azure toolset.
• Confidential Certified SQL Server 2012/2014 (License 15116067) Developer.
• Experience in Data collection, Data Extraction, Data Cleaning, Data Aggregation, Data verification, Data analysis, and Reports.
• Proficient in Data Extraction and Loading (ETL / ELT) tools like SSIS, BODI, DataStage and Azure Data Factory (ADF).
• Proficient in writing SQL queries/ USQL /Scope scripts for on-prem and Big Data stores like SQL server, Oracle, Azure Data Lake Storage (ADLS) / Cosmos (Internal Bigdata of Confidential ).
• Extensive experience in providing Enterprise Reporting solutions / Dashboards using SSRS, Spotfire and Power BI tools.
• Experience of working in Agile methodology / Waterfall model projects
• Organized professional wif excellent oral and written communication skills, fast learner and can easily adapt quickly to new technology wif ability to take new roles in minimum time and little training.
• Ability to work individually as well as in a team wif excellent problem solving and troubleshooting capabilities.
• Experience of training and mentoring new team members.
• Experience working onsite at different geographical locations.

TECHNICAL SKILLS

Databases: MS SQL Server 2005/2008/2008 R2/2012, Oracle 10g, Oracle 11g, Cosmos, Azure Data Lake Store, Azure SQL DB

Programming: T-SQL, PL/SQL

OS: Windows 2012 R2/2008

ETL Tools: SQL Server Integration Services (SSIS), SAP BODI, DataStage, Azure Data Factory (ADF)

OLAP Tools: SQL Server Analysis Services (SSAS)

Reporting: SQL Server Reporting Services (SSRS), TIBCO Spotfire, SAP BOXI R3, Power BI

Tools: MS Office 2007/2010, Team Foundation Server (TFS), JIRA, Skype for Business, SQL Server

Other Tools: Management Studio (SSMS), Visual Studio, Business Intelligence Development Studio (BIDS)SQL Server Data Tools (SSDT)

PROFESSIONAL EXPERIENCE

Confidential

Data Engineer

Responsibilities:

• Understanding and creating Business Requirement and relevant documents.
• Source system analysis to no the frequency of load and fields values.
• Design and set up the Security Service TEMPPrincipal for Azure Data Factory to connect to ADLS.
• Develop data pipelines using Azure Data Factory, to move data from disparate data sources to Azure Data Lake Store.
• Ensure the data provided meets the GDPR compliant by tagging the streams.
• Develop SCOPE Scripts and Views in Cosmos ( Confidential Internal BigData Platform - like ADL).
• Ensuring the committed stories are complete.

Confidential

SQL Report Developer

Responsibilities:

• Business Requirement gathering, understanding and defining high level and low level design documents.
• Development of new reports, enhancements or changes to the existing reports as per the requirements specification.
• Defining different test cases against the business requirements.
• Completely own and manage the changes any of the Spotfire existing reports.
• Deployment wif validation of the reports and ensuring their are no issues.
• Developed reports using SSRS and TIBCO Spotfire and assess impact for the change requests
• Creation and Maintenance of application Handbook for Spotfire BPM.
• Guide the new team members on Spotfire tool

SQL Report Developer

Responsibilities:

• Understanding User requirements and helping them in creating new standard, Ad-hoc reports and report model enhancements in the sprint.
• Creation of SSRS report based on the report specifications and monthly status report.
• Creation of tables and modifying existing EAV tables (worked on the EAV model), views and procedure related.
• To implement all the report model changes requirements.

Confidential

ETL, Report Developer and Production Support

Responsibilities:

• Complete ownership of creation of application handbook.
• To ensure the data load completion successfully and the reports are delivered to customer wifout any issues on a day-to-day basis.
• Creation of customer page, buttons, links and make reports available to end users on SharePoint and providing access to the SharePoint pages and creation of groups.
• Developed SSIS Packages for pulling the data from source systems along wif transformations and making them into facts and dimensions (Data Warehouse) which are required for building cubes (SSAS).
• Enhancement to the existing ETL packages according to the new organization structure in the Production environment.
• Creation of BOXI reports, monthly reports based on the user requirement.
• Ensured the cubes were up to date and available for the reports.

Confidential

ETL, Report Developer and Database tester

Responsibilities:

• Prepare LLD & HLD along wif test cases for the requirement
• Data analysis and developing ETL packages based on the source systems.
• Implementation, Testing & deployment of the ETL package & reports developed.
• Creation of SSRS report based on the report specifications.

Confidential

ETL Developer and Database tester

Responsibilities:

• Creation of LLD based on HLD available.
• Analyzing the source data provided.
• Designing and developing the ETL flow on the business requirement.
• Unit testing of the package developed.
• Testing of the packages developed by the team.

Confidential

Database tester

Responsibilities:

• Understanding of the business requirement and testing the packages developed.
• Data comparison of tables using beyond compare tool.
• Test case preparation for ETL packages, raising the defect and retest the packages.
• To ensure the data match between source and target, functionality of the design and ensuring components ready for UAT deployment.