Data Developer

Jagadeeswar

Employer : **********.*@*********.***

https://www.linkedin.com/in/jagadeeswar-alampally-98a56133/

Profile @ Glance

Over 11 years of experience in developing BI applications utilizing SQL server, MSBI stack(SSIS,SSAS,SSRS), Power BI, and Tableau.

Proficient in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, SQL Server and MS Access.

Hands on experience with various transformations such as lookup, conditional split, multicast, Derived column, merge, for each, for loop, Multi - cast, sorting, Data profiling, Bulk insert, Sequence container, Delayed validations etc. in Integration Services development.

Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.

Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions.

Extensive database programming experience in writing T-SQL, User Defined Functions, Triggers, Views, Temporary Tables Constraints and Indexes using various DDL and DML commands.

Developed complex and customized Stored Procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.

Experience in managing and automating control flow, data flow, events.

Generated reports with parameters, sub reports, cross tabs, charts using Cognos, SSRS, tableau.

Experience in Design, development of Business Intelligence Solutions using Tableau.

Experienced in Design and Optimization of OLTP, OLAP tools, creating SSAS based OLAP Cubes.

Assist in the creation of efficient and reusable processes surrounding the deployment and security of BI deliverables utilizing content packs, Provide training and mentoring to team on Power BI.

Experience in developing visualizations using Tableau 10.x/9.x. Proficiency in Tableau functionalities including Data Blending, Joins, Dual Axes charts, Filters, Sets, Groups, Reference lines and bins, exposure to Tableau admin activities.

Experience in creating Interactive reports, dashboards and visualizations. Implemented various actions, providing security and permissions for various users groups. create and re-fresh extracts for tableau reports.

Expert in developing SSAS Cubes, Dimensions, Relationships, Aggregations, KPIs, Measures, Partitioning Cube, and deploying and Processing SSAS objects. proficient in optimizing MDX queries.

Education:

Master of Business Administration (MBA).

Assignment Summary:

Thermo Fisher Scientific, Tewksbury, MA 09/2017 – present

Lead MS BI Developer/BI Analyst

Responsibilities:

Collaborated with senior management, subject matter experts, and IT teams to define business requirements

Transformed business requirements into functional and nonfunctional requirements.

Created complex stored procedures to perform various tasks including, but not limited to: index maintenance, data profiling, metadata searches, and loading of the data mart.

Designed, developed, and tested the ETL strategy to populate data from multiple source systems.

Implemented SSIS packages to perform ETL data messaging operations (data profiling, cleansing, and verification).

Designed incremental loads to populate the data mart with checksum and timestamp techniques.

Created master-child packages to consolidate data from data sources into SQL server with execute package tasks, enabling modular programming.

Implemented package configurations on development, test, and production environments utilizing parameters.

Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.

Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema.

Created SSAS cubes with KPIs and aggregation for the front-end analysis team.

Utilized multi-dimensional and tabular model in analysis services to pull and generate reports directly from in-memory from back-end relational data sources.

Designed SSRS reports for in depth business analyses.

Designed expressions to calculate, group, filter, parameterize, and format report contents.

Generated score cards with executive summary dashboards to display performance monitoring measures with Tableau.

Delivered on-demand reports in multiple rendering formats with standard and data driven subscriptions.

Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.

Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

Implemented code check-in/check-out and managed multiple versions of complicated code within TFS.

Provisioned VMs with SQL Server on cloud utilizing Microsoft Azure and setting up communication with the help of endpoints.

Perform thorough unit testing on all relevant platforms to ensure proper implementation.

Designed SSAS Cube and developed MDX queries for Analysis.

Using Team foundation server (TFS) for managing source code changes.

Involving in developing test cases for Unit Testing.

Environment: SQL Server 2012, T-SQL, SSMS, Excel, SSIS, SSAS, SSRS, SharePoint, Power BI, Tableau, TFS, DTA, SQL Profiler, MS Azure, Data Factory, Visual Studio, C#.

Morgan Stanley, Broadway, NY 07/2016 – 08/2017

Principal Engineer/Lead L3 Engineer

Technologies & Environment: MS SQL Server 2008 r2/2012, SSAS, SSIS, Visual SourceSafe, Windows 2003 Advanced Server.

Responsibilities:

Responsible for Monitoring OLAP cubes and SQL jobs, if any issues in ETL packages while refreshing data troubleshoot on high priority.

Align solution design with overall architectures and strategic technologies

Help define team development best practices and process improvements.

Provide technical solutions to L2 team, work with client teams on critical issues and performance issues.

Developed and enhanced SSAS cubes and MDX scripts, Responsible for Monitoring and Tuning SSAS cubes and MDX scripts for optimization.

Worked on Aggregation designs for cubes, created various aggregations and Implemented usage based aggregation design for SSAS cubes.

Created time based partitions and Implemented Slicers for restricting cube space.

Created calculations, scoped assignments in cube calculations, worked on attribute relationships.

Created optimized attribute relationships and defined exact properties and settings to utilize best aggregation design for cubes. Implement best practices on Cube designing and dimension designing.

Created and enhanced Tableau visualizations, reports and Dashboards.

Experience in cube deployments to various environments and administrative activities like monitoring OLAP objects, and processing, scheduling processing jobs using ETL tasks.

IMS Health, Parsippany, NJ 02/2012 -06/2016

Senior BI Developer- MS SQL Server.

Responsibilities:

Analyzed business requirements, facilitating planning and implementation phases of the OLAP model in meetings

Encapsulated frequently executed SQL statements into stored procedures to reduce the query execution times.

Performed data cleansing and scrubbing in the staging database.

Created SSIS packages to implement error/failure handling with event handlers, row redirects, and loggings.

Implemented a master-child package model to improve maintenance and performance.

Configured packages with parameters to acquire values at runtime.

Optimized SSIS packages utilizing parallelisms, fast load options, buffer sizes, and checkpoints.

Managed packages the in SSISDB catalog with environments; automated execution with SQL agent jobs.

Involved in the design of Data-warehouse using Star-Schema methodology and converted data from various sources to oracle tables.

Created data models and data flow diagrams for the to-be process.

Implemented new and complex calculated members in cubes improve report performance.

Designed SSAS cube objects such as KPIs, aggregations, perspectives, and translations.

Formatted dashboards, multiple chart types, trends, and KPIs with Power View to support analyses.

Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.

Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.

Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.

Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis

Optimized report performance with caches and snapshots.

Proactively resolve issues to drive quality and system performance improvements across the application

Participate in cross-team information sharing resources and work to identify risks early in the development process

Implemented TFS for project version control and change management with bug tracking.

Environment: Microsoft SQL Server 2012, SSDT, SSMS, T-SQL, SSIS, SSRS, SSAS, Power BI, SharePoint, TFS, DTA, Tableau, Visual Studio, C#

IBM Bangalore - India 3/2010 -01/2012

Senior Application Developer- MSBI

Interacted with business users for gathering requirements and look and feel of the applications to be developer.

Developed various dashboards, used context filters, sets while dealing with huge volume of data.

Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.

Designed dash boards for actionable, non-actionable complaints from Multidimensional database.

Generated dashboards to compare the expected weekly registration andphysician specific registrations used dual axis for comparison.

Generated Dashboards by joining multiple complex tables.

Prepared different views for Patient Registrations, Doctor Scheduling and Lab Tracking.

Generated dashboard for Billing and Deposit Systems

Provided security and user roles for all the users of the various modules

Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.

Environments: Microsoft SQL Server 2005/2008, T-SQL, Tableau, JavaScript, TFS

Accenture Hyderabad - India 06/2008 – 02/2010

Senior Software Engineer/ MSBI Developer

Responsibilities:

Participated in discussions with Team leader, Group Members and Technical Manager regarding any Technical and Business Requirement issues.

Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources.

Create new SSIS Packages to export flat files.

Write Stored Procedures, Triggers, Functions and T-SQL Queries to capture updated and deleted data.

Used different data Transformations like Lookup, Derived Column, Conditional Split, data conversion while creating the SSIS Packages.

Created Ad-Hoc Reports, Sub Reports and Summary Reports using SSRS.

Effectively handled data errors during the modification of existing reports and creation of new reports.

Export and import data from CSV files, Text files and Excel Spreadsheets by creating SSIS Packages.

Experience in reporting services based on existing XML documents.

Scheduled Jobs and Alerts using SQL Server Agent.

Creating, maintaining the users, roles and granting privileges.

Fine tuning the Database Settings as well as the Server Settings.

Capgemini, Hyderabad - India 06/2005 – 02/2008

Associate Consultant/ Cognos BI Developer

Technologies & Environment: SSRS, SQL Server, Cognos Report net, 8 BI(Framework Manager, Report Studio, Query Studio).

Responsibilities:

Worked as Cognos BI report developer, responsible for creating framework manager models, publishing those models to Cognos BI environment using Cognos connection for making available to reports creation.

Crated various types of reports using report studio like list, crosstab, chart, parameterized reports for user business analysis.

Extensively worked on FM for designing report model for report authors, experience with Cognos power play transformer for creating cubes on Cognos BI environments.

Experience with Cognos administrative activities using Cognos connection, creating users and providing permission & implemented security models.

Worked on Migration from Cognos to SSRS reports.

Created various kinds of reports like parameterized, drill through, drill down, and sub report using SSRS

sound understanding of both reporting architecture and deployment.

Contact this candidate