SUMMARY

• Results driven professional, with over 10 years of experience, in design, development and implementation of server and web - based applications in various Microsoft technologies. Experience in implementing all the phases of lifecycle of the system like analysis, designing, coding, testing, and deploying high-volume, high-performance, real-time intensive applications.
• Very good experience in SQL server integration services (SSIS 2008/2012) Packages (Developing, Deploying, Scheduling) for performing Data transfers and ETL Purposes across different servers. Involved in Huge data migrations, transfers using SSIS. Expertise in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using SSIS.
• Designed Power BI data visualization utilizing cross tabs, maps, pie, bar, and density charts.
• Created DAX Queries to generate computed columns, measure and tables using existing data.
• Primarily involved in Data Migration using SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell.
• Have good experience in generating reports using SQL Server Reporting Services.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, and drill down reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS) and SQL Server Data Tools.
• Very good working experience in scheduling and deploying reports on report manger.
• Expert in PL/SQL scripts to create complex stored procedures, functions, and triggers.
• Implemented complex business logic with User-Defined-Functions, Indexed Views and created User Defined Data type, Clustered & Non-clustered Indexes.
• Hands on experience in Requirement gathering, analysis and writing use cases and technical specifications.
• Experience in front end development using CSS, XML, AJAX, jQuery, NodeJS, AngularJS and HTML5.
• Expertise in using Web Services/SOA with SOAP and REST for developing web applications.
• Experience with versioning tools like TFS, VSS.
• Good Working knowledge on Agile Methodology.
• Good knowledge in SQL Server Analysis Services.
• Strong inter-personal skills in interacting with End Users, Managers and Technical personnel. Motivated team player with ability to work under minimal supervisions.
• Excellent communication, interpersonal skills, analytical skills, quick learner, ability to work in a team environment, virtual team environment, independently and resilience to work well under pressure.

TECHNICAL SKILLS

Cloud Technologies: Azure Data Factory, Azure HD Insights, Data Bricks, Data Lake Storage, Cosmos DB, Azure Active Directory and BLOB Storage.

Data Warehouse Tools/Technologies: SSIS, SSRS, SSAS 2014/2012/2008 R2/2005, Power BI, Tableau.

Languages & Frameworks: .Net Framework, C#

Web Technologies: ASP.NET, MVC, Web API, REST, Web Services, WCF, XML, JSON, jQuery, JavaScript HTML, CSS, IIS

Windows Technologies: Windows forms

Development Environments: Visual Studio, Visual Studio Code, SQL Server Management Studio

Scripting Languages: PowerShell

Databases: MS SQL Server 2016/ 2014/2012/2008 R2/2005

Processes and Methodologies: Agile Scrum, SDLC Waterfall

Version Tools: Team Foundation Server, GIT

Other Tools/Technologies: Fiddler, SOAP UI, Postman

PROFESSIONAL EXPERIENCE

Confidential

Power BI Developer

Responsibilities:

• Developed critical decision-making reports in Power BI Reports. Reports like Monday Morning, Minerva Reports generated in Power BI. created objects like stored procedure, Views using SQL Server.
• Converted SSAS Cube measures and dimensions logic in Power BI
• Design, Development of Teradata scripts, Database design and query optimization.
• Translated business requirements into design and technical specifications for implementation.
• Developed Tabular, Matrix, different Chart, waterfall chart, Drill-down, and Drill-through reports in Power BI.
• Understating the existed business logic and Prepared Technical design document for new change requests.
• Involved in visual reports, dashboards and KPI scorecards using Power BI desktop.
• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS.
• Some Reports and dash boards are developed using power BI Working experience in doing Performance tuning in SQL server.
• Worked on all type of transformation that are available in Power BI query editor.
• Scheduled automatic refresh and scheduling refresh in Power BI Service.

Technologies used: Power BI, ADF and SQL Server 2014, SSIS, Team Foundation server (TFS).

Confidential

Power BI Developer

Responsibilities:

• Understanding the business needs and provide the solutions accordingly.
• Preparing the hive queries to fetch the data and generate the reports.
• As per requirements developed the reports in the form of Matrix, Table.
• Wrote queries for drill down reports to get the dataset required to build the report.
• Developed different kind of reports using SSRS such a Sub Reports, Matrix reports.
• Created and managed subscriptions for the reports
• Resolving the issues that occur in job runs in production environment.
• Written Stored Procedures and SQL Queries.

Technologies used: SSIS, Team Foundation server (TFS), Power BI, SSRS and SQL Server.